Headline

Business Analyst | Pharma Commercial Analytics | Power BI · SQL · Advanced Excel | IQVIA | B.Pharm + MBA (Pharma Management) | Turning Prescription & Sales Data into Decisions

About

I sit at the intersection most analysts skip — I studied pharmacy before business before data, so when I look at a prescription trend or a sales dip, I'm not just reading a number, I understand the clinical and commercial story behind it. At IQVIA, I work as a Data Analyst in Commercial Analytics — building Power BI dashboards end-to-end (data modeling, DAX, KPI design), automating recurring reports, and translating messy pharma sales/RWE data into insights that Commercial and Medical Affairs teams actually act on. What I bring to a Business Analyst role: → Domain-first thinking: I know the difference between a real brand problem and a formulary/step-edit artifact in the data → Technical fluency: SQL, Power BI (DAX/data modeling), Advanced Excel — I build, I don't just request → AI-augmented, not AI-replaced: I use Power BI Copilot and LLMs to move faster, but the judgment layer — the right question, the interpretation that looks right but isn't — stays mine → Delivery discipline: consistent on-time delivery across a high-volume monthly reporting queue in a zero-room-for-error healthcare data environment Currently exploring Business Analyst opportunities in pharma/healthcare commercial analytics — open to a conversation if you're building a team that needs someone who can think in both clinical and commercial terms. 📩 Jainam.kothari08@gmail.com

Location

Indore

Work experience

Data Analyst at IQVIA, Apr 2025 - Present · 1 yr 4 mos, Bengaluru, Karnataka, India, Delivered 30+ analytics projects across commercial and sales functions with zero delays and zero quality escalations, maintaining a 100% on-time delivery record across critical and standard workstreams. Engineered end-to-end KPI dashboards in Power BI that consolidated regional sales metrics into a single source of truth, enabling faster performance reviews and reducing manual reporting effort by an estimated 40%. Spearheaded data readiness initiatives to enable AI-powered automation of recurring deliverables, structuring and validating datasets to meet quality thresholds required for machine learning pipelines. Owned stakeholder communication across 6 critical deliverables — led requirement-gathering sessions, translated business needs into analytical briefs, and incorporated feedback loops that improved output relevance and adoption. Designed Advanced Excel models and SQL-based data extraction workflows to support commercial analytics reporting, reducing query turnaround time and improving data accuracy for downstream reporting teams.

Healthcare marketing intern at Trizone Healthcare Consultants, May 2024 - Jul 2024 · 3 mos

Education

MBA pharmaceutical management, MBA, IIHMR University

Bachelor of Pharmacy - BPharm, Pharmaceutical Marketing and Management, Devi Ahilya Vishwavidyalaya