Mayank Shandilya

Experience

• 

  Tata Steel

  May 2011 - Jul 2011

  Volunteer Trainee

  Characterization of refractory mortar. Characterization of the samples was done my measurement of MOR, CCS, PLC and XRF analysis.

• 

  Bhabha Atomic Research Centre

  May 2012 - Jul 2012

  Project Trainee

  Powder synthesis and sintering studies of yttria doped barium zirconate. Characterization of the samples was done using XRD, dilatometer and SEM.

• 

  Kohler Co.

  Jun 2013 - Mar 2015

  • In-charge of Robotics in the Spray department - Planning and adherence of SKUs to be sprayed on different robots, development of spray programs and management of daily robotic activities• Played instrumental roles in extensive data analysis for defect detection and elimination

  • Senior engineer

    Jun 2014 - Mar 2015

  • Graduate Engineering Trainee

    Jun 2013 - May 2014
• 

  ZS

  Apr 2015 - now

  • Continuing the CoS role to BI&A VP on a 15+ m$ project of a Fortune 500 pharma company• Managing a large ZS team (30+ members) supporting BI&A in European markets, ensuring timely seamless and high quality deliveries and high client satisfaction• Collaborating with onshore teams to drive business development opportunities focusing on the client business needs• Leading internal initiatives with ZS LTs to tech-enable large client programs through assessing the current state and drivers to get the desired to-be state Show less Chief of Staff to BI&A lead (Vice President) of a Fortune 500 pharma client on a ~15 m$ project: • Strategic support: Being a thought and sparring partner; unearthing opportunities at external conferences; brain-storming agenda for team meetings and summits; developing frameworks for strategic initiatives• Executional support: End to end ownership of LT summits; being a stand-in to being fly on the wall during LT meetings; co-ordinating with teams for outside-in inspiration sessions• Driving impactful analysis across several European markets like strategizing the tactics based on the channel affinity towards promotional channels; measuring impact of promotional channels deployed, on sales for effective resource allocation using statistical analysis like regression modelling• Worked with different data vendors to align on latest requirements, showcasing insights/trends from the industry and issues resolution Show less Lead of team supporting cluster of 9 markets in Central & Eastern Europe• Created and led the ZS team of 8 to support the clients in the expansion of BI&A footprints in the CEE markets• Responsible for shaping the commercial strategy of several launch products in the CEE markets• Created the forecasting framework and onboarded all the 9 markets on patient-based forecasting during the period of 12 months• Was the SPOC to the market GMs for any strategic and BI&A support• Helped the clients to set up platform for Market Research support to smoothen the process with the vendors Show less • Business opportunity market Assessment : Worked with a big pharma organization’s BI&A Exec Director to identify patient potential, build patient journeys, understand current competitive landscape and treatment algorithms being used by physicians in the Intercontinental markets• Developed patient flows and forecasting models for 4-5 new product launches for a big pharma client, which had recently acquired another pharma company• Led a team of 10+ members supporting a Fortune 500 pharma company during the evolving and challenging period of Covid 19 onset• Worked with ZS L&D team to develop several modules for upskilling of broader ZS analysts on machine learning and AI courses Show less • Responsible for forecasting revenues, patients and prescriptions for all the drugs under the client’s portfolio using patient and projection flow-based models, to help in short/long term planning and target setting for large pharmaceutical clients based out of Argentina, Colombia, Russia, Switzerland, Austria, Brazil and Canada • Traveling Consultant for clients based out of Argentina, Colombia and Russia supporting them to set up the forecasting process and business analytics team• Former Traveling Consultant for clients based out of Switzerland and Austria for two years• Former Off-shore Lead and Single Point of Contact for clients based out of Brazil and Canada Show less

  • Decision Analytics Consultant

    Jan 2023 - now

  • Decision Analytics Consultant

    Apr 2022 - Jan 2023

  • Solutions Project Lead

    Feb 2021 - Apr 2022

  • Decision Analytics Consultant

    Jul 2020 - Jan 2021

  • Decision Analytics Associate Consultant

    Jan 2018 - Jun 2020

  • Business Analyst

    Apr 2015 - Dec 2017