SQL / Power BI Developer at SSM Health (2024-08 – Present)
Spearheaded healthcare analytics modernization by migrating legacy reporting into scalable Power BI and cloud-based platforms supporting 20M+ healthcare records.
- Developed 25+ enterprise Power BI dashboards and executive scorecards tracking PMPM cost, readmission rates, denial trends, provider utilization, LOS metrics, and clinical KPIs for 500+ business and clinical users.
- Integrated Epic EHR clinical data (ADT, clinical orders, patient encounters, and care management records) into enterprise analytics pipelines, enabling real-time operational reporting and clinical decision support dashboards.
- Extracted and transformed Epic Clarity and Caboodle data using T-SQL and SSIS to build analytics-ready datasets supporting population health, chronic disease management, and quality measure reporting.
- Implemented advanced DAX time-intelligence measures, rolling averages, KPI frameworks, and variance analysis supporting enterprise healthcare performance management.
- Developed HIPAA-compliant analytics solutions enforcing PHI data governance through Row-Level Security (RLS), column-level masking, role-based access controls, and audit logging across all reporting layers.
- Designed and maintained HIPAA-compliant data pipelines with end-to-end encryption, de-identification protocols, and access governance frameworks ensuring regulatory adherence across 20M+ patient records.
- Reduced dashboard refresh and report execution time by 40% through SQL optimization, indexing strategies, execution plan analysis, aggregation techniques, and incremental refresh configurations.
- Built scalable SSIS and Azure Data Factory ETL pipelines processing 5M+ daily healthcare transactions integrating SQL Server, Salesforce, Snowflake, Epic, and cloud enterprise systems.
- Designed enterprise Star and Snowflake dimensional data models improving Power BI query performance and analytics scalability by 35%.
- Piloted Microsoft Fabric (OneLake, Lakehouse, Data Factory pipelines) to modernize data ingestion and reporting workflows, reducing pipeline development time by 30% and enabling unified analytics across structured and semi-structured healthcare data sources.
- Automated manual reporting and reconciliation workflows using Power BI, SQL, and Python (Pandas), reducing manual effort by 60% and improving data accuracy.
- Configured Power BI Gateway, scheduled refreshes, and workspace administration supporting 99% refresh reliability across enterprise reporting environments.
- Collaborated with clinical operations, finance, and data engineering teams in Agile/Scrum sprints to deliver scalable BI solutions aligned to value-based care initiatives.
SQL / BI Developer at Wells Fargo (2020-08 – 2023-06)
Developed enterprise-scale Power BI and SSRS reporting platforms supporting customer analytics, loan performance tracking, profitability analysis, and regulatory reporting across US banking operations.
- Built and maintained 20+ interactive Power BI dashboards utilized by finance, operations, and leadership teams for strategic financial decision-making and KPI monitoring.
- Modernized legacy Excel-based reporting by implementing automated Power BI solutions, reducing manual reporting effort by 50% and improving accuracy and audit readiness.
- Built high-performance T-SQL queries, stored procedures, and ETL workflows processing 15M+ financial transaction records supporting enterprise reporting pipelines.
- Improved ETL and reporting performance by 35% through advanced SQL tuning, indexing, query optimization, partitioning, and parallel execution enhancements.
- Designed scalable SSIS ETL packages integrating data from multiple banking systems, reducing batch failures by 30% and improving processing reliability.
- Developed dimensional data warehouse models using Star Schema architecture enabling enterprise-wide financial reporting and faster business insights delivery.
- Supported enterprise governance and regulatory audit initiatives through source-to-target mappings, governed datasets, and controlled reporting frameworks.
- Created advanced DAX measures, KPI scorecards, rolling trend analysis, and dynamic reporting solutions for executive-level financial analytics.
- Contributed to cloud migration initiatives leveraging Azure Data Factory, Snowflake, and hybrid analytics environments for scalable financial reporting modernization.
