Power BI Developer & Data Engineer - Healthcare Analytics
Resume:
Pavan Bhargav
Power BI Developer / Data Engineer
**************@*****.***
PROFESSIONAL SUMMARY
Results-driven Power BI Developer and Data Engineer with 5+ years of experience delivering scalable, end-to-end data solutions across healthcare and financial services domains.
Specialized in healthcare data analytics, working with EMR/EHR systems including Epic Clarity, Caboodle, Cerner, and Meditech, with strong knowledge of clinical workflows and interoperability standards such as HL7 and FHIR.
Strong expertise in SQL Server, Power BI, and ETL development, with hands-on experience building data pipelines, data models, and interactive dashboards for large-scale datasets including claims, provider, and patient data.
Proven ability to design and optimize data warehouses, improve performance, and deliver actionable insights that enhance operational and clinical decision-making.
Experienced in integrating data from multiple sources including databases, APIs, and flat files, while ensuring data quality, governance, and security in HIPAA-compliant environments.
Skilled in performance tuning of SQL queries, ETL pipelines, and Power BI dashboards, with a strong focus on scalability and efficiency.
Collaborative team player with experience working in Agile environments, partnering with cross-functional teams to translate complex business requirements into data-driven solutions.
TECHNICAL SKILLS
Data Visualization & BI: Power BI (DAX, Power Query, Data Modelling, RLS, Incremental Refresh), SSRS
Data Engineering & ETL: SSIS, Azure Data Factory (ADF), Microsoft Fabric (Lakehouse, Direct Lake)
Big Data & Processing: Databricks (PySpark – basic exposure)
Databases: SQL Server (2019/2017/2016), Azure SQL Database
Programming: T-SQL, DAX, Python (basic)
Data Integration: REST APIs, JSON/XML Data Ingestion
Cloud Platforms: Microsoft Azure (ADF, SQL DB, Storage), Power BI Service (Gateway, Workspaces)
Healthcare Systems: EMR/EHR (Epic Clarity, Caboodle, Cerner, Meditech), HL7, FHIR
Data Modelling: Star Schema, Snowflake Schema, Data Warehouse Design
Tools: SSMS, Visual Studio, SQL Profiler, TFS
Methodologies: Agile, Waterfall, SDLC
PROFESSIONAL EXPERIENCE
Vie Med Healthcare – Lafayette, LA May 2024 – Present
Power BI Developer / Data Engineer
Designed and delivered end-to-end Power BI dashboards and data pipelines for healthcare analytics (claims, provider, patient data), improving reporting efficiency by 30%.
Built scalable data models (star schema) and implemented Row-Level Security (RLS) to ensure secure, role-based data access across business users.
Developed and optimized complex DAX measures and incremental refresh strategies, improving dashboard performance and reducing data load time.
Designed and implemented ETL pipelines using SSIS, Azure Data Factory, and Microsoft Fabric (Lakehouse architecture) for centralized data processing.
Integrated data from REST APIs and JSON-based sources, enabling real-time ingestion and reporting across multiple systems.
Optimized T-SQL queries and indexing strategies, improving query performance by 25%.
Automated data refresh and pipeline scheduling, reducing manual effort by 40% and improving data availability.
Performed data cleansing, transformation, and validation using Power Query and ETL processes to ensure high-quality data.
Configured and maintained Power BI Service environments, including gateways, workspaces, and data refresh pipelines.
Collaborated with stakeholders and clinical teams to deliver actionable insights supporting operational and patient care decisions.
Environment:
Power BI (Desktop & Service), DAX, Power Query, Microsoft Fabric (Lakehouse, Direct Lake), Azure Data Factory (ADF), SSIS, SQL Server (2019/2017), Azure SQL Database, REST APIs, JSON/XML, Power BI Gateway, SSRS
Virtu Financial – NY Aug 2022 – July 2023
BI/ ETL Developer
Developed high-performance ETL pipelines using SSIS, processing large-scale financial and insurance datasets, improving efficiency by 35%.
Designed and implemented data warehouse solutions supporting reporting and analytics for business operations.
Optimized complex SQL queries, stored procedures, and indexing strategies, improving performance by 20–30%.
Built and deployed SSRS reports and dashboards, enabling business users to access real-time and historical insights.
Implemented SSAS cubes and MDX queries for multi-dimensional analysis and KPI reporting.
Ensured data quality and integrity through validation, cleansing, and transformation during ETL processes.
Automated reporting workflows using SQL Server Agent and scheduling tools, reducing manual effort.
Collaborated with business teams to gather requirements and deliver scalable data solutions.
Environment:
Power BI, DAX, Power Query, SSIS, SSRS, SQL Server 2019, T-SQL, SQL Server Agent, Data Modelling (Star Schema)
Capital One – VA April 2021 – July 2022
Power BI Developer / Data Engineer
Designed and developed interactive Power BI dashboards for financial reporting, risk analysis, and customer analytics, enabling data-driven decision-making.
Built and optimized data models (star schema) to support reporting on large-scale financial datasets, including transactions, customer data, and account activity.
Developed and maintained ETL pipelines using SSIS and Azure Data Factory (ADF) to ingest, transform, and load data into centralized data warehouses.
Created complex DAX measures and calculations to support KPI tracking, trend analysis, and executive-level reporting.
Optimized T-SQL queries, stored procedures, and indexing strategies, improving query performance and reducing report load times.
Implemented Row-Level Security (RLS) and data governance practices to ensure secure, role-based data access.
Automated reporting workflows and data refresh processes, improving efficiency and data availability.
Collaborated with business stakeholders, risk, and finance teams to gather requirements and deliver scalable analytical solutions.
Environment:
Power BI, DAX, SQL Server, Azure Data Factory (ADF), SSIS, Azure SQL Database, T-SQL, REST APIs, Data Modelling, Power BI Service
Education: Masters in Information Systems from Indiana Institute of Technology, Fort Wayne, IN
Contact this candidate