Summary
Overview
Work History
Education
Skills
Core Skills
Datasets Worked On
Certification
Websites, Portfolios and Profiles
Timeline
Generic
Mrunal Kaledhonkar

Mrunal Kaledhonkar

Summary

Healthcare Data Analyst with 4+ years of experience in US Healthcare Claims Analytics, Commercial Analytics, Real-World Data (RWD), and Pharmaceutical Consulting. Proficient in SQL, Python, Power BI,ETL development, and Microsoft Excel, with hands-on experience in Patient Journey Analytics, Patient/ HCP Zip code analysis,Line of Therapy (LOT), Duration of Therapy (DOT), Persistency & Adherence, Market Access, Drug Coverage, and Commercial Analytics. Experienced in developing analytical datasets and dashboards, automating reporting workflows, performing data validation and quality checks, and translating complex healthcare data into actionable insights for pharmaceutical clients.

Overview

1
1
Certification
5
5
years of professional experience

Work History

Associate Consultant

PharmaAce Innovations LLP
11.2024 - 08.2026
  • Led end-to-end healthcare analytics projects for pharmaceutical clients, translating business requirements into actionable data-driven insights.
  • Performed patient journey analytics to identify treatment patterns, therapy progression, treatment switching, and patient behavior.
  • Conducted Line of Therapy (LOT) and Duration of Therapy (DOT) analysis to evaluate treatment patterns and therapy progression.
  • Developed persistency and adherence analyses to assess long-term patient treatment behavior.
  • Performed drug coverage using healthcare claims datasets & sales data to evaluate access and treatment utilization.
  • Analyzed commercial sales datasets including 867 and DDD to evaluate product performance, market trends, and therapy utilization.
  • Delivered client-facing analytical solutions including Drug Effectiveness Assessment and Smart Alert processing, translating complex data into actionable recommendations.
  • Conducted ZIP3-level geographic analysis on healthcare claims data to evaluate patient–physician location concordance, identify state/ZIP3 mismatches, and detect potential data quality issues for downstream analytics.
  • Conducted payer analytics using Symphony Health Solutions (SHS) data to identify key payer contributors, analyze payer mix trends, and quantify patient movement between payers, highlighting shifts in coverage patterns and potential market access opportunities.

Data Engineer

PharmaAce Innovations LLP
02.2023 - 11.2024
  • Designed and maintained ETL pipelines for processing large-scale healthcare claims and patient-level datasets.
  • Developed SQL-based data extraction and reporting solutions to support healthcare analytics and downstream reporting requirements.
  • Automated recurring reporting workflows using Python, reducing manual effort by approximately 90%.
  • Performed data validation, reconciliation, and data quality checks to ensure accuracy, completeness, and consistency of healthcare datasets.
  • Optimized data processing workflows to improve reporting efficiency and reduce turnaround time.
  • Supported production data loads and scheduled jobs, ensuring timely and reliable delivery of analytical datasets.

Analyst

PharmaAce Innovations LLP
11.2021 - 02.2023
  • Prepared weekly and monthly deliverables for US pharmaceutical and healthcare clients.
  • Performed healthcare data loading, validation, and quality assurance activities.
  • Conducted SQL-based data extraction, reporting, and analysis.
  • Supported patient journey analytics and healthcare reporting projects.
  • Collaborated with senior consultants to improve reporting accuracy and delivery quality.

Education

PG - Diploma - Big Data Analysis

Sunbeam Institute of Information Technology
Pune
01-2021

Bachelor of Engineering (B.E.) - Computer

AISSMS COE,PUNE (SPPU)
Pune
01-2020

Skills

  • Programming: SQL, Python
  • Visualization Tools: Power BI, Tableau
  • Data Tools: Excel, ETL Pipelines
  • Analytics: Healthcare Claims, RWD, Commercial Data

Core Skills

  • Healthcare Analytics | Claims Data Analysis | Real-World Data (RWD)
  • Patient Journey Analysis | LOT (Line of Therapy) | DOT (Duration of Therapy)
  • Persistency & Adherence Analysis
  • SQL | Python | ETL Development | Data Modeling
  • Power BI | Tableau | Advanced Excel
  • Data Visualization | Dashboard Development
  • Data Validation | Data Quality Assurance
  • Stakeholder Management | Client Consulting

Datasets Worked On

  • IQVIA
  • Symphony Health Solutions (SHS)
  • Xponent
  • DDD sales
  • Payer Data
  • EMR

Certification

  • PG Diploma in Big Data Analytics (PG-DBDA)
  • Python for Data Science
  • Advanced Microsoft Power BI
  • Data Engineering Foundation

Websites, Portfolios and Profiles

https://www.linkedin.com/in/mrunal-kaledhonkar-1135091b8/

https://www.naukri.com/mnjuser/profile

Timeline

Associate Consultant

PharmaAce Innovations LLP
11.2024 - 08.2026

Data Engineer

PharmaAce Innovations LLP
02.2023 - 11.2024

Analyst

PharmaAce Innovations LLP
11.2021 - 02.2023

PG - Diploma - Big Data Analysis

Sunbeam Institute of Information Technology

Bachelor of Engineering (B.E.) - Computer

AISSMS COE,PUNE (SPPU)
Mrunal Kaledhonkar