Back to Developers
rohit bhapkar

rohit bhapkar

Healthcare Data Analyst

Pune
80
Profile Score

About

Healthcare-focused Data Analyst with hands-on experience in medical claims processing and adjudication, leveraging strong knowledge of ICD-10, CPT, HCPCS, and Revenue Cycle Management (RCM). Skilled in Root Cause Analysis (RCA), denial management, and payment integrity analysis to identify financial variances and process gaps. Proficient in Advanced Excel (Power Query, Pivot Tables, XLOOKUP) and Power BI (DAX, KPI dashboards) for data modelling, reporting, and performance tracking. Seeking to advance into a Healthcare Data Analyst role where I can apply analytics, business analysis, and domain expertise to drive operational efficiency, improve claim accuracy, and support data-driven decision-making.

Skills & Expertise (15)

Data Visualization Intermediate
7.8/10
2
Years Exp
Power BI Intermediate
7.8/10
2
Years Exp
Advanced Excel Advanced
7.5/10
2
Years Exp
KPI Reporting Intermediate
7.5/10
2
Years Exp
Healthcare Analytics Intermediate
7.3/10
2
Years Exp
DAX Intermediate
7.3/10
2
Years Exp
Root Cause Analysis Intermediate
7.1/10
2
Years Exp
ICD10 Intermediate
7.0/10
2
Years Exp
CPT Intermediate
7.0/10
2
Years Exp
RCM Intermediate
7.0/10
2
Years Exp
SQL Intermediate
6.6/10
2
Years Exp
Excellent Communication Quick Thinker Adaptability Problem Solving

Work Experience

Claims Specialist

Wellcove-CHCS

May 2024 - Apr 2026

Processed adjudicated high-volume medical claims using ICD-10, CPT, and HCPCS coding standards in compliance with HIPAA and CMS guidelines. Analyzed claim denials, underpayments, and overpayments to identify financial variances and improve payment accuracy. Utilized Advanced Excel (Pivot Tables, XLOOKUP, Power Query) for data reconciliation, trend analysis, and performance tracking. Developed Power BI dashboards (DAX, KPI reporting) to monitor claim turnaround time (TAT), denial rates, and quality metrics. Conducted Root Cause Analysis (RCA) to reduce recurring claim errors and enhance first-pass resolution rate.

Education

Medical Coding - AAPC

2023 - 2024 · Afghanistan

Bachelor of Pharmacy - SPPU

2018 - 2022 · Afghanistan

HSC - SPPU

- 2018 · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Availability Details

Relocation

Open to Relocation

Skills (15)

Data Visualization Power BI Advanced Excel KPI Reporting Healthcare Analytics DAX Root Cause Analysis ICD10 CPT RCM +5 more