Anil

Microsoft Certified Power BI Developer and Data Analyst with 6+ years of experience delivering data-driven insights and business intelligence solutions. Expertise in designing and implementing complex data models, interactive dashboards, and ETL processes to drive operational efficiency and informed decision-making. Skilled in Power BI tools, SQL, and cloud platforms like Azure and Snowflake, with a proven track record of optimizing data workflows and reducing manual processes.

Adept at collaborating with cross-functional teams and applying analytical thinking to transform raw data into actionable insights.

Business Intelligence Report Developer (Power BI) at State of Florida (2024-01 – Present)

Designed and developed enterprise-grade Power BI dashboards and reports to deliver actionable insights for healthcare and operational analytics across correctional facilities.

• Transformed complex healthcare and EHR data into interactive visualizations using Power BI (drill-through, slicers, tooltips, bookmarks) to support data-driven decision-making.
• Developed advanced DAX measures and calculations (time intelligence, KPIs, rolling metrics) to enhance reporting accuracy and analytical capabilities.
• Built and optimized data models using star and snowflake schemas, ensuring high performance and scalability for large datasets.
• Designed and implemented ETL pipelines using SSIS and Azure Data Factory, enabling efficient data ingestion and transformation from multiple structured and unstructured sources.
• Integrated data from SQL Server, Azure SQL Database, APIs, and flat files into centralized data models for unified reporting.
• Wrote and optimized complex T-SQL queries, stored procedures, and views to improve data retrieval performance and support large-scale analytics.
• Performed data cleansing, transformation, and validation using Power Query and SQL to ensure high data quality and consistency.
• Developed paginated (pixel-perfect) reports using Power BI Report Builder for operational and regulatory reporting needs.
• Implemented Row-Level Security (RLS) and role-based access control to ensure secure and compliant access to sensitive healthcare data.
• Automated data refresh, gateway configuration, and deployment pipelines in Power BI Service, ensuring data availability and reliability.
• Collaborated with business stakeholders, healthcare teams, and IT to gather requirements and deliver scalable BI solutions aligned with organizational goals.
• Conducted data validation, troubleshooting, and performance tuning, resolving discrepancies and ensuring accuracy across reporting systems.
• Supported cloud data initiatives using Azure Synapse, Azure Data Factory, and Microsoft Fabric, enabling modern data platform capabilities.
• Maintained documentation for data models, ETL processes, and reporting logic, improving transparency and long-term maintainability.

Senior SQL/SSIS Engineer at US Bank (2022-05 – 2023-12)

• Developed and maintained complex Power BI dashboards and reports to support banking operations, financial risk analysis, and regulatory compliance reporting
• Designed and optimized stored procedures and T-SQL scripts for high-volume transaction processing, reporting, and data validations
• Engineered end-to-end ETL workflows using SQL Server Integration Services (SSIS), enabling daily and intraday data movement between internal systems and data warehouses
• Created data models (star and snowflake schemas) supporting Power BI and SSAS, enabling fast and consistent analytical reporting across departments
• Managed deployments using Power BI Deployment Pipelines and Git-based version control (TFS), ensuring traceability and rollback options
• Implemented SSRS and Power BI paginated reports for compliance, audit, and reconciliation teams; delivered parameterized, subscription-enabled reports
• Leveraged Visual Studio 2019 for SSIS development and automated data loading, error handling, and event-driven job orchestration
• Worked with enterprise Autosys job scheduling system to manage SSIS package execution, alerts, and dependencies in production
• Built and managed Analysis Services (SSAS) cubes for key banking KPIs; developed hierarchies, KPIs, and calculated members for executive dashboards
• Maintained strict data quality standards and implemented audit logs within ETL flows to comply with internal and external audit requirements
• Participated in code reviews, deployment validations, and post-deployment testing to ensure smooth promotion across development, UAT, and production environments
• Supported Snowflake data warehouse integration during initial rollout by evaluating ingestion strategies and testing schema compatibility

Power BI Developer / Business Intelligence Analyst at Maricopa County Public Health (2020-04 – 2022-05)

• Designed and developed healthcare analytics dashboards in Power BI to support clinical, operational, and financial decision-making across large-scale enterprise datasets.
• Built scalable data models using Power BI Desktop and Power Pivot, improving reporting efficiency and enabling faster healthcare data analysis.
• Developed interactive dashboards for healthcare KPIs such as patient outcomes, utilization trends, operational performance, and service efficiency, improving decision-making speed by 40%.
• Created advanced DAX measures and calculations (time intelligence, KPIs, rolling metrics) to support clinical and operational reporting requirements.
• Designed impactful visualizations including trend analysis, KPI cards, bar charts, and matrix reports, enhancing stakeholder engagement by 35%.
• Developed and optimized ETL pipelines using SSIS and Azure Data Factory, integrating healthcare data from EHR systems, claims systems, APIs, and SQL Server databases.
• Integrated data from multiple healthcare sources (EHR, SAP HANA, flat files, Excel, cloud systems) into centralized Power BI models for unified reporting.
• Implemented data cleansing, validation, and transformation processes using Power Query and SQL, improving healthcare data accuracy and consistency.
• Built and optimized SQL Server stored procedures, views, and complex queries to support high-volume healthcare data processing and reporting.
• Designed and deployed SSRS paginated reports for regulatory, clinical, and operational reporting requirements.
• Developed enterprise-level SSIS packages with error handling and event logging, ensuring reliable and automated healthcare data pipelines.
• Implemented Row-Level Security (RLS) in Power BI to ensure HIPAA-compliant role-based access to sensitive patient and operational data.
• Optimized Power BI performance using efficient data modeling, query tuning, and aggregations, reducing report load time by 30%.
• Built dimensional data models (star and snowflake schemas) to support scalable healthcare analytics and reporting systems.
• Integrated Power BI with Azure Data Factory and Azure SQL Database, enabling automated data ingestion and near real-time healthcare reporting.
• Performed data reconciliation and validation across multiple healthcare systems, ensuring 99% data accuracy and reliability.
• Collaborated with clinical analysts, business stakeholders, and IT teams in Agile/Scrum environments to deliver enterprise BI solutions aligned with healthcare goals.
• Developed Python-based data transformation scripts for advanced data cleansing and statistical processing of healthcare datasets.
• Automated ETL workflows across Azure and Snowflake environments, reducing manual data processing efforts by 25%.
• Designed and delivered SSRS and Power BI reports for healthcare operations and finance teams, improving visibility into performance metrics and resource utilization.
• Implemented performance tuning strategies for SQL and ETL processes, improving system efficiency by 20–40%.