Kavish Nagpal profile photo 1 on Tal

Kavish Nagpal

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

Delhi

7+ years of work experience

R1 RCM
Apr 20224 y 6 moPresent

Gurugram

Apr 20224 yrs 5 mosPresent

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.
Apr 20224 yrs 5 mosPresent

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.
R1 RCM
Apr 20224 y 6 moPresent

Gurugram, Haryana, India

Belz Instruments Pvt Ltd
Jul 20192 yrs 8 mosFeb 2022

Faridabad, Haryana, India

Belz Instruments Pvt Ltd
20193 yrs2022

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%.
GitHub
@iamkavishnagpal-hash

Kavish’s AI Stack

aistudio
aistudio
anthropic apis
anthropic apis
antigravity
antigravity
codex
codex
n8n
n8n
openai
openai

Education

Bachelor of Commerce - BCom, Marketing

Swami Vivekananda Subharti University, Meerut

20163 yrs2019

Join Kavish and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Kavish Nagpal on Tal

Headline

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

About

Working at the intersection of Data, UX, and Automation to build scalable dashboards, intelligent workflows, and data-driven digital experiences. Currently a Senior Associate at R1 RCM, focused on Business Intelligence, reporting automation, product analytics, and UX-led decision systems using SQL, Python, Power BI, PySpark, and Figma.

Location

Delhi

AI stack

aistudio

anthropic apis

antigravity

codex

n8n

openai

Work experience

Senior Data Engineer at R1 RCM, Apr 2022 - Present · 4 y 6 mo, Gurugram

Senior Business Intelligence Analyst at R1 RCM Healthcare, Apr 2022 - Present · 4 yrs 5 mos, 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.

Senior Product Analyst at R1 RCM Healthcare, Apr 2022 - Present · 4 yrs 5 mos, 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.

Senior Data Engineer at R1 RCM, Apr 2022 - Present · 4 y 6 mo, Gurugram, Haryana, India

Site Coordinator at Belz Instruments Pvt Ltd, Jul 2019 - Feb 2022 · 2 yrs 8 mos, Faridabad, Haryana, India

Data Analyst at Belz Instruments Pvt Ltd, 2019 - 2022 · 3 yrs, 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%.

Education

Bachelor of Commerce - BCom, Marketing, Swami Vivekananda Subharti University, Meerut

Public links

github: https://github.com/iamkavishnagpal-hash