Sumit Kumar Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

Toronto, Ontario, Canada

· Leading and managing a team of 8+ consultants from Onshore to support the Commercial and Strategic Forecast and Insights program for a large pharmaceutical company in the U.S, focusing on commercial assessment of In-line assets across Respiratory, Neuroscience, Bone, and Oncology disease areas.- Travel to the US (client location) for every forecast cycle to conduct forecast assumptions meetings with cross-functional team, provide them with weekly status update and present the forecast summaries to the leadership.- Created prescription based long term forecast model supported by Market Research, Analog Analysis, APLD claims data, evaluation of the competitive landscape and external consensus for a newly launched drug in the Severe Asthma disease area which are being used for both short and long-range forecast- Conducted analog analysis to compute the impact of Bio-Similar entry in the overall market and the share of our brand due to the patent expiry of our drug to effectively plan the strategy for future.- Created a forecast model for the PAP (Patient Access Program) for a newly launched drug to provide the Demand units required to support the program.- Helped the finance team with the revenue forecast for one of the brands in the Neuroscience market to determine if the future brand strategy is justified.- Encourage team to take end-to-end responsibility; ensuring availability when any support is required.- Working closely with various client stakeholders like Commercial Forecasting Director, Brand leads, Finance leads and Business managers in planning and scheduling to ensure smooth execution of the overall program

Pune, Maharashtra, India

Pune, Maharashtra, India

-Leading and managing a team of 5+ consultants to support the Commercial and Strategic Forecast and Insights program for a large pharmaceutical company in the U.S, focusing on commercial assessment of a pipeline asset across Severe Asthma, Atopic Dermatitis, COPD and CRSwNP disease areas for global market.-BD&L: Assessed multiple external assets, in new Therapy areas for the stakeholders.-Created patient based long term forecast model supported by Market Research, Demand Studies, Analog analysis, and competitive landscape for all the indications for the pipeline drug.-Partnered with the stakeholders in revamping the forecast models and process to best-in class

India

·Worked as a Forecasting and Analytics manager with responsibility of commercial Forecasting, Business performance reporting, Incentive compensation, budget management, project execution and quality of deliverables.·Created the commercial forecast of Bio-similar as well as generic drug portfolio (~600 SKUs) of Dr. Reddy’s Laboratory at regional level.·Created, operated, and optimized both existing and new business processes, which included configuring business rules, synthesizing data, and performing quality checks.·Collaborated with numerous internal stakeholders and client stakeholders to initiate and manage the overall transformation of the program from offline reporting to online reporting, resulting in the successful transition to online reporting.

Pune Area, India

-Managed a team of 4 consultants, led commercial and strategic forecast, Business Performance reporting and Analytics projects for Australia, Canada, Brazil and China Markets for Oncology and Cardiovascular disease areas.-Created patient based long term forecasts models for various indications supported by market research, analogue analysis, APLD claims analysis, evaluation of competitive landscape, comparison with external consensus.-Travelled to Canada, Australia, and UK during the forecasting cycles to conduct Assumptions discussions, manage expectations as well as to present the final forecasting outputs.-Created Tableau based business performance reports for all assets to track the performance of the brand compared to the forecasting outputs.-Managed the project overall by managing client and internal expectations with the help of a variety of collaborative tools.-Created business performance reports to track the Sales, New and Total patients and SFE activities of all the assets.-Provided additional insights by performing ad-hoc analyses - Impact due to natural disasters, data restatements and inclusion of additional data sources

Pune Area, India

Pune Area, India

Call Planning and Targeting –-Worked as an analyst to create the targeting universe of the Prescribers and Outlets for leading Pharmaceutical company-The universe is used by the sales representatives for planning calls and also calls are made per our recommendation-Created multiple reports on Excel and Access during the project-Created targeting tools in excel Sales Force Design –-Worked as analyst to process the overall target universe and provided the optimum size of the sales force for the promotion of one of the top selling drug of a leading pharmaceutical industry Targeting and Segmentation:-Worked on Targeting process for Cardio Vascular market for one of the largerst US based pharmaceutical industry-Identified the potential targets (both Hospitals and MDs) based on sales and patient diagnosis data-Worked on segmenting the targets in to various buckets/tiers to identify dominant players in the marketDemand Planning and Forecasting--Worked as an analyst to generate demand forecast of all the products of one of the leading US-pharmaceutical company across different regions-Every month the forecast generated is used by the manufacturing units to supply products to the invoicing points or distribution centers- Worked on different statistical models to predict the forecast at the granular levelTechnical SkillsMS Excel - Proficient in creating dynamic reporting dashboardsMS Access - Proficient in data manipulation in AccessMs Powerpoint: Proficient in creating high impact slidesSAS - Proficient in Unix/Windows SAS. Proficient in writing SAS codes for data analysisVBA - Hands-on experience in VBASQL - Proficient in Advance and PL-SQLSAP APO- Proficient in generating forecast at various levelsSAP Bex Analyzer- Proficient in generating various reports using Bex Analyzer

Bachelor Of Technology (B.Tech.), Metallurgical And Materials Engineering

- Head, Public Relations of Technica- 2014 (Annual Techno-Management festival of Metallurgical and Materials Engineering of NIT.

Intermediate, Science