Prabhakar Srivastava
Hyderabad,TG
Summary
Strategic Forecasting Expert with nearly a decade of experience driving commercial insights within the Pharma sector. Adept at partnering with marketing, finance, and supply chain teams to optimize inventory, develop brand forecasts, and mitigate risk. Highly skilled in translating market research and secondary data into actionable business strategies that enhance market performance and profitability.
Overview
10
10
years of professional experience
Work History
Manager - Forecasting
Sandoz
Hyderabad
08.2024 - Current
- Spearheaded design and deployment of an automated EU forecasting model used by the portfolio team—improving forecast reliability and saving 300+ hours annually.
- Established a standardized EU forecasting process and governance to ensure cross-country consistency and improve decision making for hunted molecules.
- Developed interactive Power BI and excel insight as well as dashboards, for ALIMENTARY TRACT AND METABOLISM, BLOOD AND BLOOD FORMING ORGANS, and CARDIOVASCULAR SYSTEM therapy areas to inform portfolio prioritization and commercial decision-making.
- Led development of a scalable BEAT forecasting platform to centralize forecasts for 500–1,000 molecules across markets; coordinate cross-functional stakeholders and mentor team members.
Global Forecasting Manager
Novo Nordisk Service Centre (India) Pvt. Ltd.
Bengaluru
05.2022 - 07.2024
- Led end-to-end long-term forecasting (LTF22/LTF23) for diabetes (A10C-D) and rare-disease portfolios (H01), facilitating assumption-setting workshops and aligning stakeholders across pricing, commercial, manufacturing and regional affiliates.
- Delivered patient-based epidemiology forecasts and scenario analyses to inform strategic planning, capacity and resource allocation.
- Automated IQVIA data cleaning and reporting pipelines, significantly reducing manual effort and providing standardized, timely inputs for portfolio decision-making.
- Prepared and presented monthly, quarterly and ad-hoc reports to cross-functional stakeholders, translating forecasts into commercial and operational actions.
Assistant Manager
WNS Global Services Pvt. Ltd.
Noida
06.2021 - 05.2022
- Built multi-scenario forecasts for Takeda oncology products (Ninlaro, Adcetris) across indications and EU28 markets; delivered stakeholder-ready reports and sensitivity analyses.
- Led drug pricing analyses for Takeda and competitors across therapy areas; developed a VBA dashboard visualizing price per mg and annual cost per patient across countries to support competitive benchmarking.
Senior Analyst
Decision Resources Group (subsidiary of Clarivate plc)
Gurugram
08.2019 - 05.2021
- Delivered syndicated and client-based forecasting and quantitative analytics projects (patient-based and epidemiology) for oncology and hematology clients.
- Built and maintained Excel-based forecast models and client presentations; integrated Symphony PHAST and other data sources to produce actionable insights.
- Performed peak sales estimates using an analog modeling tool, assessing launch potential based on molecule type, indication, and market entry sequence.
- Provided drug-, class- and company-level forecasts and bespoke analyses to address client queries and inform commercial strategy.
Advanced Analyst
Prescient & Strategic (P&S) Intelligence Private Limited
Noida, India
03.2017 - 07.2019
- Executed market research, forecasting and competitive-intelligence projects in the pharma and medical devices domain, including drug pipeline and disease epidemiology reports.
- Performed data analysis, authored reports and developed SOPs, newsletters and business presentations to communicate findings to clients and internal stakeholders.
Drug Safety Associate (Intern)
Novartis Healthcare Pvt. Ltd.
Hyderabad
07.2016 - 03.2017
- Processed adverse-event reports in Oracle Argus: conducted clinical checks, de-duplicated entries, created case files and initialized safety reports; coded medical history and events using MedDRA to ensure data quality and regulatory compliance.
Education
Master of Science - Biotechnology
National Institute of Pharmaceutical Education And Research (NIPER)
Mohali, India06-2016
Bachelor of Pharmaceutical Sciences -
Gautam Buddh Technical University
Lucknow06-2014
Skills
- Forecasting (patient-, sales-, and event-based)
- Demand and statistical forecasting (ARIMA, SARIMA, exponential smoothening)
- Data insights and analytics
- Revenue variance analysis
- NPV and sensitivity analysis
- Regression analysis
- Advanced MS Excel and VBA (automation)
- Power BI and DAX measures
- Python programming (basic)
- Business Analytics
- Competitive landscape
- Drug pricing
Extracurricular Activities
Team games, adventures, and sports Team games, adventures, and sports
Languages
English
Hindi
ADDITIONAL INFORMATION
- CMO/Patient safety Hyderabad Team — Exceptional Team Performance 2016 at Novartis Healthcare Pvt. Ltd.
- AIR 284 in NIPER - JEE 2014
- AIR 1101 in GATE 2014
- Industrial Training at Sanofi India Ltd., Ankleshwar, Gujarat Jul 2013
Key Strengths
- Quick-learner
- Determined
- Dedicated
- Competitive
Hobbies
- Travelling
- Listening music
- Outdoor games - cricket and volleyball
- Indoor games - table tennis
Timeline
Manager - Forecasting
Sandoz
08.2024 - Current
Global Forecasting Manager
Novo Nordisk Service Centre (India) Pvt. Ltd.
05.2022 - 07.2024
Assistant Manager
WNS Global Services Pvt. Ltd.
06.2021 - 05.2022
Senior Analyst
Decision Resources Group (subsidiary of Clarivate plc)
08.2019 - 05.2021
Advanced Analyst
Prescient & Strategic (P&S) Intelligence Private Limited
03.2017 - 07.2019
Drug Safety Associate (Intern)
Novartis Healthcare Pvt. Ltd.
07.2016 - 03.2017
Master of Science - Biotechnology
National Institute of Pharmaceutical Education And Research (NIPER)
Bachelor of Pharmaceutical Sciences -
Gautam Buddh Technical University