ROHAN BANSOD
Senior Manager
Mankoli, Thane, Mumbai
Summary
Strong leader and problem-solver dedicated to streamlining operations to decrease costs and promote organizational efficiency. Uses independent decision-making skills and sound judgment to positively impact company success.
Overview
13
13
years of professional experience
2
2
years of post-secondary education
Work History
SENIOR MANAGER, STRATEGIC FORECASTING
GENPACT
8 2022 - Current
- Forecasting team lead, supporting clients and stakeholders with forecasting requirements and planning for launch products across therapy areas
- Managing team of 9 forecasters having experience in Strategic forecast, Demand Planning and Business Development forecast
- Driving stakeholder's discussions across multiple functions (Marketing, Finance, Market access & Demand planning)
- Supporting multiple markets in validating forecast assumptions and its impact on forecast output and provide market insights through value added analysis
- Conducting workshops with multiple markets to train them on forecasting platform and resolving their forecasting related queries
- Supporting markets to successfully complete strategic forecast cycles
- Perform extensive research of market aided by competitive dynamics, market assessment, multiple analysis and secondary research in developing actionable insights
- Identify risks and opportunities within forecast across markets
- Bringing transformative ideas to solve forecasting challenges faced by stakeholders across markets
- Working closely with team members having expertise in PowerBI & VBA who supports on creating dashboards and customized report for stakeholders
- Databases worked on: IMS PADDS, IMS OneView, Xponent, Evaluate Pharma, Clarivate (DRG)
- Responsible for growth, development and appraisal of team members
- Actively involved in hiring new talent and managing, mentoring & up-skilling of team.
CONSULTANT, FORECASTING & COMMERCIAL ANALYTICS
IQVIA
08.2019 - 07.2022
- Responsible for developing project proposals, designing forecast methodology, project planning and stakeholder engagement
- Responsible for developing patient based forecast models
- Expertise in pipeline product forecast for rare/orphan indications
- Expertise in product profiling, epidemiology analysis, analogue & attribute analysis
- Healthcare data analytics, assumption building and validation, market assessment and report generation
- Expertise in IMS data analysis and various other databases, interpretation of data in excel and power point
- Data analytics, data interpretation and insights generation using in-house and client databases.
MANAGER, BUSINESS INSIGHTS & ANALYTICS (US COMMERCIAL OPS)
SUN PHARMA
06.2017 - 08.2019
- Stakeholder management and communication for smooth running of commercial operations for North America region
- Responsible for Incentive plan design, Incentive compensation and process implementation for key dermatologic and ophthalmic products of SUN Pharma
- Field goal designing, commission calculations and ad-hoc analysis for various sales operations
- Solving sales force queries related to call planning, territory alignment and territory designing
- Development, implementation and execution of sales contest
- Development of excel model for payout summary calculations
- Develop Tableau report of IC results for sales force team
- Designing of Goal cards, score cards and resolving field force queries post IC calculations
- Data analytics, data interpretation and insights generation using in-house and client databases
- Database management, maintaining data repository and data dictionary documents
- Development of product performance dashboard and presenting results to stakeholders
- Expertise in dealing with various IMS databases & Symphony Data
- SOP, QC checklist, business plan documents
- Traveled Onsite twice and holding B1/B2 visa valid till Dec 2027.
ANALYST, FORECASTING
NOVARTIS HEALTHCARE PVT. LTD.
03.2015 - 05.2017
- Strategic 5 year forecast of blockbuster drug in Neuroscience franchise including life cycle management opportunities
- Market forecast of key Novartis product along with other key competitor product which include event analysis, competitor analysis and proper market dynamics understanding
- Expertise in pipeline product forecast for rare/orphan indications
- Expertise in IMS/Decision resource and other data handling, interpretation of data in excel and power point
- Involved in preparation of key presentation decks which includes key insights to be shared with brand team for key decision-making activity.
JUNIOR CONSULTANT, IMS HEALTH INDIA PVT. LTD.
BANGALORE
08.2013 - 02.2015
- Competitive intelligence on diabetes for one of th market leader organization in the world
- Newsletter, Monthly & Quarterly reports, key competitor financial analysis, Competitor launch timelines, Pipeline analysis, Key abstract findings for major conferences
- Data analytics using in-house and client data in different therapeutic areas
- Expertise in IMS data handling, interpretation of data in excel and power point
- Involved in preparation of slide decks, newsletters and event calendars to be shared with client
- KOL analytics on major therapeutic area for one of the leading organization.
ASSOCIATE ANALYST, DMV BUSINESS AND MARKET RESEARCH PVT. LTD.
HYDERABAD
07.2011 - 05.2013
- Expertise in handling projects related in Competitive Intelligence (CI) and Forecasting in complex therapeutic areas
- Data Collection, Data Consolidation & Analysis utilizing Secondary Research
- Expertise in information extraction from secondary resources (paid/free), for example, Company press releases, Annual reports, Bloomberg Business Week, Google Finance, SEC filings, FDA, EMEA, MHRA, ClinicalTrial.gov and others
- Handling the client queries and project related with the Market Sizing and Forecasting.
Education
MBA PHARM. -
NATIONAL INSTITUTE OF PHARMACEUTICAL EDUCATON AND RESEARCH (NIPER), MOHALI
Mohali 07.2009 - 04.2011
GATE, IIT ROORKEE -
B. PHARM - undefined
SKB COLLEGE OF PHARMACY (RTM NAGPUR UNIVERSITY)
AISSCE (CLASS XII) - undefined
KENDRIYA VIDYALAYA SHAHIBAUG (CBSE), AHMEDABAD
AISSE (CLASS X) - undefined
KENDRIYA VIDYALAYA (CBSE), BALAGHAT
Skills
Forecasting
Sales Force Effectiveness
Sales Analytics
Market Assessment
Business Analytics
Business/Competitive Intelligence
Data Analytics integration and Management
Reporting Analytics
PowerBI
Tableau
VBA & Macros
MS Excel & Power Point
Timeline
CONSULTANT, FORECASTING & COMMERCIAL ANALYTICS
IQVIA
08.2019 - 07.2022
MANAGER, BUSINESS INSIGHTS & ANALYTICS (US COMMERCIAL OPS)
SUN PHARMA
06.2017 - 08.2019
ANALYST, FORECASTING
NOVARTIS HEALTHCARE PVT. LTD.
03.2015 - 05.2017
JUNIOR CONSULTANT, IMS HEALTH INDIA PVT. LTD.
BANGALORE
08.2013 - 02.2015
ASSOCIATE ANALYST, DMV BUSINESS AND MARKET RESEARCH PVT. LTD.
HYDERABAD
07.2011 - 05.2013
MBA PHARM. -
NATIONAL INSTITUTE OF PHARMACEUTICAL EDUCATON AND RESEARCH (NIPER), MOHALI
07.2009 - 04.2011
SENIOR MANAGER, STRATEGIC FORECASTING
GENPACT
8 2022 - Current
GATE, IIT ROORKEE -
B. PHARM - undefined
SKB COLLEGE OF PHARMACY (RTM NAGPUR UNIVERSITY)
AISSCE (CLASS XII) - undefined
KENDRIYA VIDYALAYA SHAHIBAUG (CBSE), AHMEDABAD
AISSE (CLASS X) - undefined
KENDRIYA VIDYALAYA (CBSE), BALAGHAT
Similar Profiles
Zaki Uddin SyedZaki Uddin Syed
ITSM Consultant (IM,PM,CM) at GenpactITSM Consultant (IM,PM,CM) at Genpact
María Fernanda Granados ArroyoMaría Fernanda Granados Arroyo
Customs Process Developer at GenpactCustoms Process Developer at Genpact
S SrinivasS Srinivas
Senior Associate at GenpactSenior Associate at Genpact
ISHITA TRIPATHIISHITA TRIPATHI
Trade Review & Operation Analyst at GenpactTrade Review & Operation Analyst at Genpact
Mohammad Kaif ShaikhMohammad Kaif Shaikh
Relationship Manager at ICICI BankRelationship Manager at ICICI Bank