Yogesh Kumar Agarwal Email & Phone Number

Hyderabad, In

Hyderabad, Telangana, India

India

Commercial Forecasting and Global Guidance Support• Markets Supported: Global (Primarily US)• Forecasting Guidance creation– Creating forecasting guidance for a key Lung oncology portfolio by coordinating with various teams i.e., Finance, Business Insights, Marketing, Data Quants, Market research and COE team• Global Stakeholder support – Supporting and guiding the stakeholders across globe in interpreting the guidance and executing the forecast• Forecasting and Analytics – Actively led the long term strategic forecasting for US, Risk and Ops exercise, sensitivity analysis, reporting• Lean Certification – Implemented lean principles across a certain forecasting process that was critical to timely delivery of accurate results• Tools / Platforms: MS Excel, MS PowerPoint , Spotfire report

India

1. Offshore lead - Ex-US Modelling and Capabilities• Promoted to Associate Consultant in 3 cycles (~20 months)• Managed a team of 5+ members to deliver key forecast models for a multinational pharmaceutical firm across entire Ex-US markets in areas of Oncology, CV, Haematology, Immunology• Task and Project Management – As a lead streamlined the standardization across models, project planning, development process, version and delivery management and day-to-day task management• Modelling – Lead the model development process for 5 key brands• Capabilities – Actively led a critical data compliance related enhancement process across 30 markets2. Offshore lead - Promotion Response / Key drive analysis (US)• Tools / Platforms: MS Excel, MS PowerPoint , R – Analytics• US KDA: Lead the Key driver analysis for US market for two key brands across various promotional channel like SF detailing, Digital tactics, consumer tactics etc.

Pune, Maharashtra

1. Commercial Forecasting, Analytics and Reporting• InterCon HQ – Opportunity assessment of new assets, Long term strategy planning, SF analytics and co-promotion analytics• Brazil – Reporting, Forecasting for 4 key Therapeutics areas and lead the Promotion response exercise. Actively lead development of 4 Tableau reports• Australia – Tableau based commercial Reporting2. Medical Affairs Analytics• Medical Affair Analytics [US, Ex-US] – 4 months - Analysed the impact of MSL visits on few of the key metrics of Clinical trials• Markets Supported: US and 4 Major markets• Tools / Platforms: MS Excel, MS PowerPoint, R – Analytics

Pune Area, India

• OEM market and Verasys Support :My routine in this team was develop Control Logic for different BMS units. The team majorly met the requirement of the OEM market. CCT and EMPCT tools were used (Johnson controls copyrighted tools). The Major challenge in this team was to propose Complex sequences to meet different customer requirements and develop logic for the same

Mumbai, Maharashtra, India

Graphics, MUI team:My Daily routine in this team was to develop Interactive User Interface for Operator control for different BMS units. Graphics generation tools, Sweet home & MUI were the different tools that I worked on (Johnson controls copyrighted tools). Successfully lead the UI development of control dashboard for a US based University. Received Appreciation Award for successfully leading the same

Mumbai, Maharashtra, India

Underwent a training for 30 days on the HVAC industry. Worked in Hardware department for half duration and other half in Graphics team.

India

Learnt about PLC & CNC