Subhalakshmi Ramesh

Subhalakshmi Ramesh

SQL / Power BI Developer

Irving, Texas, United States.


As a SQl/Power BI developer I have a successful track record in handling substantial volumes of data. I was part of teams that effectively managed data by constructing intricate models and creating scripts to extract valuable insights. I utilized both SSRS and Power BI to develop comprehensive reports and implement impactful data visualizations, offering the stakeholders a clear and insightful presentations of complex information for informed decision-making.
With a background in finance and costing, I bring a strong understanding of costs, expenses, and financial metrics assessment to the table. My dual experience as a cost analyst and BI developer positions me as a preferred candidate for the BI developer role.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Employment History 

  • SQL / Power BI Developer

    Colaberry Inc
    November 2020 - Present

    • Extensive hands-on experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server 2019.
    • Excellent backend skills in creating SQL objects such as Tables, Stored Procedures, Effective Functions, Temp Tables, Indexes to facilitate efficient data manipulation and consistency.
    • Strong experience in client interaction and understanding business applications, Data Modeling, Data Mining, Data flow and Data relations.
    • Implement Star and/or Snowflake schemas while designing relational database and data warehouse as per business and report requirements.
    • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS).
    • Proficient in creating SSIS Packages for integrating data using OLE DB, SQL Server Connection from heterogeneous sources (Excel, CSV, Flat file, Data, XML and Zip file) by using multiple transformations.
    • Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
    • Modeled data requirements to successfully create graphs and metrics in Power BI to create insightful and visually appealing data visualizations.
    • Designed and implemented data models using Power BI to establish relationships between different data tables.
    • Created calculated columns and measures using Data Analysis Expressions (DAX) for advanced calculations.
    • Incorporated a variety of visualizations such as tables, charts, maps, and custom visuals to convey insights effectively and also implemented drill-down and drill-up functionalities for users to explore data at different levels.
    • Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
    • Worked with Business Analysts, Web development team and users on database solutions.
    • Collected business requirements from users and translated them as technical specifications and design documents for development.
    • Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

  • Cost Analyst

    Henkel India Limited
    January 2010 - December 2010

    At Henkel India Ltd, a FMCG Company, reported to the Cost Analysis Manager and Business Controller of the Finance department.
    • Variance analysis – calculation of brand-wise material consumption and factory overheads and analyze the differences and report.
    • Sourcing pattern analysis – to identify the lowest cost of source of supply for outsourced products by computing landed cost for each product.
    • Dashboard - develop key performance indicators in consultation with each department, compute the same based on actual reported numbers on a monthly and year-to-date basis and report to department heads for their analysis and controlling.