Kavish Nagpal

Senior Power BI & Data Engineer | Power BI • SQL • PySpark • Azure | BI & Data Analytics | Product & UI/UX · Delhi, India

As a Senior Analyst with 6 years of experience, I am driven by a pragmatic and logical approach to data, consistently striving for mastery in transforming complex information into actionable insights. My commitment to accountability and reliability ensures that I deliver robust solutions, from data validation to dashboard building, empowering stakeholders with clear, impactful analytics.

Experience

Senior Analyst

R1 RCM · Apr 2022 – Present

Not yet confirmed

Senior Data Analyst

R1 RCM · Apr 2022 – Present

Not yet confirmed

R

Senior Product Analyst

R1 RCM Healthcare · Apr 2022 – Present

Not yet confirmed

• Re-architected legacy operational reporting into dynamic SQL Server queries and Power BI ETL pipelines, cutting reporting turnaround time by 40% and boosting stakeholder platform utilization by 25%.
• Built scalable star-schema data models, Row-Level Security (RLS) policies, and custom DAX measures to monitor operational healthcare delivery KPIs and revenue impact metrics.
• Engineered Python data automation scripts utilizing Pandas and SQL connectivity to ingest multi-source files, reducing daily claims verification processing time from 1.5–2 hours to under 3 minutes.
• Partnered with US Product Owners and Agile cross-functional teams to translate ambiguous business requirements into 15+ leading/lagging KPI frameworks and actionable decision-support scorecards.
• Conducted statistical analysis and hypothesis testing on user event telemetry to validate product decisions, reducing false-positive insights by 30% and optimizing roadmap prioritization.

R

Senior Business Intelligence Analyst

R1 RCM Healthcare · Apr 2022 – Present

Not yet confirmed

• Re-architected legacy operational reporting using optimized SQL Server queries and Power BI transformations, reducing reporting turnaround time by 40% and increasing stakeholder platform utilization by 25%.
• Designed and optimized Power BI semantic models using star-schema architecture, including fact and dimension tables, relationships, Row-Level Security (RLS), and custom DAX measures supporting healthcare delivery KPIs and revenue-impact reporting.
• Created interactive Power BI dashboards and decision-support scorecards for operational performance, claims verification, and product KPIs.
• Managed Power BI Service delivery for operational reporting, including report publishing, workspace-based access, dataset refresh schedules, and troubleshooting refresh and report-availability issues to maintain reliable self-service BI.
• Automated claims verification and reporting workflows using Power Query, Python, and SQL, reducing daily processing time from 1.5-2 hours to under 3 minutes.
• Translated complex stakeholder requirements into 15+ KPI frameworks, analytical reports, and self-service BI solutions for Product Owners and cross-functional teams.
• Partnered with cross-functional stakeholders to define reporting requirements, structure KPI logic, validate analytical outputs, and deliver BI solutions aligned with operational and business objectives.

Site Coordinator

Belz Instruments Pvt Ltd · Jul 2019 – Feb 2022

Not yet confirmed

Data Analyst

Belz Instruments Pvt Ltd · Jan 2019 – Jan 2022

Not yet confirmed

• Consolidated and modeled operational data across 3–4 departments using multi-table SQL JOINs and advanced Excel models to establish standardized performance logs.
• Automated morning performance report compilations using Power Query refresh templates, reducing daily compilation effort from 2 hours to 10–15 minutes.
• Formulated and distributed technician capacity scorecards and queue aging metrics to laboratory leadership, optimizing operational scheduling efficiency by 15%.