ETL Developer with Power BI and Azure

Dimple Inampudi

Sr.Power BI Developer

480-***-**** ***********@*****.*** Professional Summary:

Around 6+ years of IT experience in Business Intelligence, Data Warehousing, Power BI Development, ETL, and Azure Data Engineering with expertise in Power BI, MSBI Stack (SSIS, SSRS, SSAS), Azure Data Factory, Azure Databricks, SQL Server, and T-SQL.

Strong expertise in developing interactive Power BI dashboards, KPI scorecards, and self-service BI solutions using DAX, Power Query, Drill-throughs, Bookmarks, AI visuals, and Row-Level Security (RLS) for Banking and Healthcare domains.

Experienced in designing and implementing scalable ETL/Data Integration solutions using SSIS, Azure Data Factory (ADF), Azure Databricks, and PySpark for processing large-scale enterprise data.

Proficient in building and optimizing Data Warehouse solutions, Star Schema data models, SSAS Tabular Models, and SQL Server database objects including Stored Procedures, Views, Functions, and complex T-SQL queries.

Hands-on experience with Azure cloud services including Azure Synapse Analytics, Azure SQL Database, Azure Data Lake, Azure Logic Apps, Azure Key Vault, and Azure Monitor for cloud-based analytics and reporting solutions.

Expertise in performance tuning and optimization of Power BI reports, DAX queries, SQL queries, and ETL workflows to improve data refresh performance and reporting efficiency.

Strong experience working in Agile/Scrum environments, collaborating with business stakeholders, analysts, and cross-functional teams to deliver scalable and high-performance BI solutions.

Technical Skills:

BI & Reporting: Power BI, SSRS, SSAS, Tableau, Power Query, Power Pivot, DAX, MDX, KPI Dashboards, Self-Service BI, Row-Level Security (RLS).

ETL & Data Engineering: SSIS, Azure Data Factory (ADF), Azure Databricks, PySpark, ETL Pipelines, Data Migration, Data Cleansing, CDC, Incremental Loads.

Databases & Data Warehousing: SQL Server, Azure SQL, Snowflake, Oracle, Teradata, DB2, T-SQL, Data Modeling, Star Schema, Snowflake Schema, Data Warehousing.

Azure Cloud Technologies: Azure Synapse Analytics, Azure Data Lake Storage (ADLS), Azure Blob Storage, Azure Logic Apps, Azure Key Vault, Azure Monitor, Azure DevOps.

Tools & Methodologies: Git, JIRA, Agile/Scrum, CI/CD Pipelines, APIs, JSON, XML, PowerShell, Excel.

Work Experience:

Henry Ford Health, Troy, MI

Senior Power BI / Azure BI Developer, Aug 2024 – Present Responsibilities:

Developed enterprise-level Power BI dashboards and KPI scorecards for executive leadership, enabling real-time insights into business performance, operational metrics, customer analytics, financial reporting, and trend forecasting using advanced DAX, Power Query, Drill-throughs, Bookmarks, Tooltips, and Row-Level Security (RLS).

Designed and optimized scalable Power BI semantic models and star-schema data models, improving report performance, reducing refresh times, and enabling self-service analytics across multiple business units.

Integrated data from multiple sources including Azure Synapse Analytics, Azure SQL Database, Snowflake, APIs, Excel, SharePoint, and SQL Server into Power BI to deliver centralized and highly interactive reporting solutions.

Developed reusable and modular ETL/data transformation workflows using Azure Data Factory, Azure Databricks, and PySpark, enabling efficient ingestion, cleansing, transformation, and loading of structured and semi-structured data into enterprise reporting platforms.

Implemented advanced Power BI features such as AI visuals, decomposition trees, smart narratives, field parameters, dynamic measures, calculation groups, and custom tooltips to enhance analytical capabilities and executive decision-making.

Leveraged Azure Data Factory pipelines, Logic Apps, Azure Key Vault, and Azure Monitor to orchestrate automated workflows, secure sensitive data, monitor pipeline performance, and streamline cloud-based data integration processes.

Developed complex T-SQL stored procedures, views, functions, and optimized SQL queries to support large-scale reporting and analytical requirements while improving overall database and report performance.

Collaborated with business stakeholders, analysts, and cross-functional Agile teams to gather requirements, define KPIs, and deliver scalable BI solutions aligned with strategic business objectives and data governance standards.

MSBI / Power BI Developer

First Citizens Bank, Phoenix, AZ Sep 2022 – Aug 2024 Responsibilities:

Designed and implemented enterprise-grade data warehouse and ETL solutions using SSIS, Azure Data Factory (ADF), SQL Server, and T-SQL to integrate high-volume banking data from transactional systems, Oracle, flat files, APIs, and cloud platforms into centralized reporting environments.

Developed advanced Power BI dashboards and executive KPI scorecards for banking operations including customer analytics, loan performance, fraud detection, risk analysis, branch performance, regulatory reporting, and financial forecasting using DAX, Power Query, drill-throughs, bookmarks, and Row-Level Security (RLS).

Built scalable and optimized SSIS ETL frameworks with incremental loading, CDC, auditing, error handling, logging, and automated scheduling, significantly improving data processing efficiency and operational reliability.

Developed complex SQL Server objects including Stored Procedures, Views, Triggers, Functions, Indexed Views, and performance-tuned queries to support real-time reporting, large-scale data transformation, and analytical processing.

Designed and deployed enterprise reporting solutions using SSRS, SSAS Tabular Models, Power BI, and Tableau, enabling senior leadership teams to monitor business KPIs, customer behavior trends, revenue growth, and risk exposure in near real-time.

Implemented cloud-based ETL modernization using Azure Data Factory Pipelines, Mapping Data Flows, Copy Activities, and Azure SQL, streamlining data migration and improving scalability, governance, and performance across BI platforms.

Collaborated with cross-functional teams including business analysts, risk management, finance, and compliance stakeholders in Agile/Scrum environments to deliver scalable BI solutions while ensuring data quality, security, governance, and regulatory compliance standards. Performed extensive performance tuning and optimization of Power BI datasets, DAX calculations, SSIS packages, and SQL queries, reducing dashboard refresh times and improving report responsiveness for enterprise users.

MSBI / Power BI Developer

Tango, Phoenix, AZ, Jun 2020 – Sep 2022 Responsibilities:

Designed and implemented enterprise-scale ETL and Data Warehouse solutions using SSIS, Azure Data Factory (ADF), SQL Server, and T-SQL to integrate healthcare data from EMR/EHR systems, claims platforms, Oracle, Excel, and flat files into centralized reporting systems.

Developed highly interactive and executive-level Power BI dashboards for healthcare analytics, including patient outcomes, claims analysis, provider performance, revenue cycle management, operational KPIs, and financial reporting using advanced DAX, Power Query, drill-throughs, and Row-Level Security (RLS).

Architected and optimized complex SSIS packages with incremental/full load strategies, error handling, auditing, event handlers, and automated deployments, significantly improving ETL performance, scalability, and data reliability.

Built advanced analytical models and enterprise reporting solutions using SSAS (Tabular & Multidimensional), SSRS, Power BI, and Tableau, enabling real-time business insights and faster strategic decision-making for healthcare leadership teams.

Performed extensive SQL performance tuning by optimizing stored procedures, views, functions, indexes, and complex queries, reducing report execution and data refresh times while ensuring high-volume data processing efficiency.

Led cloud modernization initiatives by implementing Azure Data Factory pipelines, Copy Activities, and cloud-based ETL frameworks, streamlining healthcare data migration and improving operational efficiency across reporting platforms.

Collaborated with cross-functional business stakeholders, analysts, and leadership teams in Agile environments to translate complex healthcare business requirements into scalable BI solutions while ensuring data accuracy, governance, compliance, and production support excellence.

Contact this candidate