Sanket Lokhande

About Sanket Lokhande

Graduated in Electronics and Telecommunications Engineering, now working as an Analyst at…

Experience

1. Associate - Analytics

   IQVIA

   Jun 2024 — Present · Pune, IN

   Improve data visibility and time-to-insight for commercial teams by developing streamlined dashboards and reporting pipelines in Excel and Tableau• Create modular analytics workbook from scratch to handle dynamic KPIs, and trendscomparisons• Led HCP targeting initiatives for rare/ultra-rare diseases, aligning targeting logic with patient access patterns and regional diagnosis trends to optimize outreach.• Leveraging business intelligence dashboards, enabling the client to make faster, data-backed decisions.• Utilized LAAD dataset for market-sizing of drugs and helping clients to identify behavioral patterns of patients.• Build end-to-end analytical workbooks from scratch, integrating dynamic KPIs and delivering actionable insights to brand teams for data-driven decision-making.• Developed interactive Excel dashboards with automated refresh and multi-filter capabilities, significantly improving decision turnaround time and stakeholder engagement.• Automated reporting frameworks using advanced Excel functions and SQL queries, reducing reporting turnaround time by 30% and enhancing data accuracy.• Supported territory alignment by mapping sales representatives to correct L2 accounts, ensuring clean and effective targeting logic.• Analyzed weekly sales call data to generate performance reports by region and representative, enabling real-time field team performance tracking and optimization.

Education

• Mar Ivanios Convent high school

  SSC

  2005 — 2018

• Pune Institute of Computer Technology

  Bachelor of Engineering - BE, Electronics and Telecommunication Engineering

  2020 — 2024

• Bharat English Jr College

  HSC, Mathematics and Computer Science

  2018 — 2020