Priyanka Bhati Email & Phone Number

Bikaner, Rj, In

Hyderabad, Telangana, India

Gurugram, Haryana, India

Worked with the forecasting team to set-up framework and processes for forecasting for large and medium pharmaceutical client organizations to help them assess the opportunity and potential for a new pipeline, launch or inline productsWorked with client organizations to understand product profiles, suggest suitable forecasting methodology, design and develop forecast models (excel based and online), train forecasters to use them and help them finalize forecasts by collecting different assumptions required to create forecastsIntegrated cross functional teams like MR (Market Research), Analytics and Forecasting to build Tableau dashboard to provide 360-degree view and better visualize live submissions and resultsDeveloped dynamic projection based forecast model which can be configured and repurposed for multiple brandsKey point of contact for multiple clients, responsible for managing their forecasting projects - including finalization of forecasting methodology, creation of timelines, managing risks and planning for future projects

Gurgaon

Excel forecast model development: Designed and implemented multiple forecast models using excel and VBA, along with functionalities such as Market event modelling, Scenario management, Monte Carlo simulation, Sensitivity analysis, Waterfall, etc. to help client understand the future trend and take business decisionsTableau Reporting dashboard: Build dashboard with multiple views to collate the results from the forecasting modelsSaved 40+ man hours/month in OP support by developing an automated dynamic dashboard “Live Consolidator” which helps in reviewing live aggregated forecasts by countries across productsDirectly worked with clients across various geographies (US, EU and JP) on different therapeutic areas such as Oncology, Vaccines, Rare diseases, etc.