Sushant Garg Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

• Leading multiple projects with a team of 9 people across different geographies and consulting clients to deliver better output and drive business decisions.
• Visited a client site in the UK (March’23) to streamline their reporting process and deliver ad hoc analytics solutions during the visit.
• Delivered process of reporting (Excel Dashboard for Omnichannel reporting) and market mix exercise by coordinating across Onshore and Offshore to identify current returns and presented multiple budgeting scenarios to.
• Led the delivery to reconcile data and automate the existing process with expected reduction in time and effort from 12 weeks to ~8 weeks.
• BD document creation for pitching new ideas and innovative solutions to the clients to maintain business continuity.
• Strategic planning for new and ongoing projects like workload balancing, timeline estimations, staffing etc.

Gurgaon, India

• Led a Marketing mix project to understand the impact of promotions on sales and identifying the future spend strategies for a brand
• Communicating with client to understand the needs of the project and also convey the analysis and findings on a day to day basis. Coordinating the project operations and ensuring timely delivery
• People management role to guide and identify improvement areas and providing regular constructive feedback, Contributing actively in upscaling the team based on the requirement and historical knowledge by driving.
• Led the end to end delivery of Commercial reporting and ad hoc analytics for one of the Top 10 global pharmaceutical companies across different business units along with a team of 5 associates
• Implemented automation techniques to reduce the runtime (by ~ 70%) and creating error free deliverables and automated dashboards
• Owned & implemented several employee engagements, capability development, recruitment initiatives within the account

Gurgaon, India

• Led the delivery of Product Analytics service for a $1B+ dotcom in the Internet/Media space. Key activities included A/B Testing, ROI Analysis, formulating Go/No-Go recommendations and new product launch analytics
• HEOR model development including patient-level microsimulation on Excel VBA
• Performed model enhancements and analyses to support numerous publications on patient-level and public health benefits of drug interventions including abstracts, posters, and manuscripts, which helped the client in FDA.
• Performed Marketing mix for calculating the impact of personal and non- personal channels in the Hemophilia market
• Led the end to end delivery of Commercial reporting and adhoc analytics for one of the Top 10 global pharmaceutical companies across different business units along with a team of 5 associates

Gurgaon, India

• Implemented digital campaign measurement (ROI) for campaigns targeted at physicians for portfolio of drugs and evaluate the incremental revenue from the campaigns, which further helped the client to take better.
• Analyzed data through test control methodology, propensity scores and statistical modelling (Linear and logistic regression) over target audience to validate the campaigns
• In house tool for calculation of revenue share for Axtria (VBA)
• Analyzed activity data (Digital marketing) to understand the behavior of physicians by analyzing the trend of engagement rates for tactics at different levels

Gurgaon, India

• Worked for one of the Japanese largest pharmaceutical company and studying thegrowth trends in the cardiovascular treatment market (USA)
• Designing functional solutions for business directors for multiple therapeutic areas
• Worked on requirements gathering to understand client needs and deploying the same using tools such as SAS,SQL, VBA etc

Gurgaon

> Delivered monthly, weekly reports for US Pharma major, to capture sales trend for portfolio of drugs.> Automation of generation of reports using MS excel and VBA.

Tapukara

> Minimized breakdown of machines by finding appropriate counter-measures to prevent re-occurrence of similar issues> Organized plant work by properly distributing responsibilities to manufacturing associates and regular follow-up> Responsible for preventive maintenance of the manufacturing lines and Kaizen processes for improvement in production

Aurangabad

> Summer training on Audi and Volkswagen assembly lines.> Time study of Volkswagen assembly line.> Optimization of Audi door line.