PANKAJ THORAT
Analytics Consultant
Pune
Summary
Laborious and motivated employee, helping Fortune 500 clients including Retail/CPG Chains and Parma Client to optimize their business using Marketing Mix Modelling.
Overview
5
5
years of professional experience
3
3
Languages
Work History
Decision Analytics Associate Consultant
ZS Associates
06.2025 - Current
- Supported pre-launch analytics for a new brand of a Fortune 500 US-based pharmaceutical client by identifying targeted HCPs and generating rep-level suggestions, improving market awareness estimates by 35%, and developing production Business Rules (BRs) and data pipelines for Tier-2 projections using Komodo claims data to estimate real-world patient counts.
- Delivered insights through automated dashboards and structured analytical reports for business stakeholders.
- Currently working on Behind Healthcare (BHC) and pharmaceutical projects, contributing to business implementation.
Consultant
Marketing Management Analytics, Ipsos
03.2024 - 06.2025
- Leading multiple projects related to Retail Industry, collaborating with different teams as required in different phases of the project to ensure smooth delivery.
- Ensuring smooth onboarding of the new team members as and when required in the projects and imparting KT sessions to these new folks to reach desired skill set.
- Optimized a validation process for 30 models using Python, reducing the time required from 5 hours to just 1 hour.
- Streamlined the EDA process using Python, cutting execution time from 3 hours to 30 minutes.
Analyst/Senior Analyst
Marketing Management Analytics, Ipsos
06.2021 - 02.2024
- Building Data Validation Reports and Analytic Data set for Marketing Mix modelling.
- Building MMX models to get insights on sales drivers, mainly at broader marketing & non-marketing drivers.
- Deep Dive using Post modelling techniques like Second Stage Modelling to further decompose the contribution of marketing drivers at their required granularities.
- Ran Optimization to find an optimal mix of spend across marketing tactics so that we could achieve maximum profit/revenue, provided total budget is fixed or in some other scenarios as required.
- Delivering the results to the clients using PPT/Excel, helping them by measuring the impact of marketing drivers to improve ROAS using CPM, Effectiveness & Marketing Spend and suggesting the optimal mix of spends across marketing drivers & their granularities.
- Trained some new team members to reach desired skill set ensuring smooth delivery.
Education
M.Sc. - Statistics
Pondicherry Central University
Pondicherry06-2020
B.Sc. - Statistics
Savitribai Phule Pune University
Maharashtra06-2017
Skills
- Marketing Mix Modelling
- Optimization Techniques
- Team Collaboration & Leadership
- Machine Learning
- Regression Analysis
- MS Office
Interests
Bike Riding, Swimming, Reading, Blogger
ACHIEVEMENTS
Star of the Month (03/2022), Star of the Quarter (10/2022), Creative contest winner (12/2022), People Deal Shout-out US Team (01/2023), Going Extra Miles (04/2023), Star of the Quarter (07/2023), Client First – US Team (02/2024), Star of the month (02/2024), Recognize ZS – Growth Award(2/2026)
Timeline
Decision Analytics Associate Consultant
ZS Associates
06.2025 - Current
Consultant
Marketing Management Analytics, Ipsos
03.2024 - 06.2025
Analyst/Senior Analyst
Marketing Management Analytics, Ipsos
06.2021 - 02.2024
B.Sc. - Statistics
Savitribai Phule Pune University
M.Sc. - Statistics
Pondicherry Central University