Abhishek William
Gurgaon
Summary
With over 9 .5 years of experience in analytics, I bring a strong track record of driving insights and strategic recommendations for pharmaceuticals and consumer packaged goods(CPG) and other clients, specialising in forecasting and marketing mix optimisation. My expertise extends to product analytics within the online marketplace retail space, where I have spent the ~2 years leveraging data to enhance customer experiences and drive growth. I am passionate about using data to solve complex problems, improve decision-making, and support business objectives.
Overview
9
9
years of professional experience
Work History
DATA ANALYTICS CONSULTANT
ZS ASSOCIATES PVT. LTD.
01.2022 - Current
- Successfully led (while also coaching & mentoring) multiple teams of up to 10 Associates and Associate Consultants simultaneously
- Worked with multiple Big Pharma clients and their marketing, sales force, and business teams to analyze and inform their marketing strategy through data driven insights
- Informed long term marketing spend decisions for multiple Big Pharma as well emerging pharma clients by running Marketing Mix Analyses and also helped them with multiple simulations to optimize their spend and maximize their profit
- Worked with a Big Pharma client to set up their demand forecasting framework for EMEA markets. Also helped their data science team to ensure adoption of the framework by creating a user interface on Streamlit
- Helped numerous emerging pharma companies with epidemiology based forecasting/opportunity assessment exercise for oncology brands which was backed with sound market research and robust technical framework
- Developed an online forecasting platform which helps run patient based models across brands and geographies to easy collaboration amongst regional and global stakeholders. Further extensions to this were then developed and deployed enabling users to run quick sensitivity and driver analyses
Decision Analytics Associate Consultant
ZS Associates
03.2020 - 12.2021
- Produced detailed and relevant reports backed with insights and rationale to enable data-driven business decisions.
- Leveraged on-site observation and personal interviews to identify team and individual strengths.
- Analyzed the marketing spends across brands and geographies to help client stakeholders identify ROI of different channels and further optimize the same to increase profitability.
- After successful pilot of the marketing mix initiative, deployed an optimization framework for the client to enable quick develop scenarios and also, co-presented the recommendations to CXOs
- Collaborated with multiple teams to create an application that could be used by the sales force team create call plans and monitor their reps' performance.
BUSINESS ANALYST
FLIPKART INTERNET PVT. LTD.
08.2018 - 02.2020
- Translated data requirements into business insights and analytical solution/reporting framework for a diverse set of customers - from Business Teams to Supply Chain Teams to Product Teams
- Understand and analyze the traffic entering on the platform and help come up with strategies to improve conversion and also consumer experience
- Understanding the post-return behavior of the customer and calculating the probable impact of new initiatives to improve consumer experience
- Analyzing the Net Promoter Score for the returns and putting in place a driver model for the same.
DECISION SCIENTIST
MU SIGMA BUSINESS SOLUTIONS
06.2015 - 07.2018
- Developing business recommendations & insights for multiple clients based on analytical results through intensive analyses and developing efficient algorithms using tools like R, RShiny, MS Excel, SQL, Tableau
- Developing dashboards for regular reporting framework to ensure better visualizations and increased readability or showcasing results of analysis
- Led a team of 5 to identify and accurately predict the fluctuating demand using time-series and regression modeling. Also, developed a visualization tool, which acts as a one-stop shop for client's SCM and Consumer Insight team
- Performed analysis and created several automated frameworks for generation of business Insights by using POS data for identifying consumer interactions between different tobacco brands, identifying chain/store's inventory performance or data issues and for forecasting e-vapor landscape.
Education
BACHELORS IN INFORMATION & COMMUNICATION TECHNOLOGY -
DHIRUBHAI AMBANI INSITUTE OF INFORMATION & COMMU-NICATION TECHNOLOGY
Gandhinagar, GJ04.2015
10th & 12th CBSE -
ST. PAULS SEN SEC SCHOOL
Kota, RJ05.2010
Skills
- Technical:
Tableau, Qlikview, Adobe Omniture, Microsoft Power Point, Microsoft Excel, R, Rshiny, RMarkdown, SQL, Jupyter Notebook, Python, Streamlit
Basics of Assembly, C, JAVA, SAS, HTML, CSS, JavaScript
- Analytical:
Data wrangling and warehousing
Predictive Modeling & Forecasting (Patient Based/Patient Flow, Epidemiology, Trend Based using Time Series based forecasting like ARIMA & its variations, Regression based etc)
Marketing Mix and Budget Optimization
Driver Analytics
Clustering Analytics
Coursework
UNDERGRADUATE ICT(B.TECH.)
- Data Structures & Algorithms
- Software Engineering
- Operating Systems
- Elements of Business Management
Awards & Recognition
- 2022 ZS Associates Ingenious Award(For development and deployment of a Forecasting App on Client side)
- 2018 Mu Sigma Spot Award(For complete ownership of project and leading the team)
- 2014 DA-IICT Event Coordinator(Annual Cultural Festival)
- 2013 DA-IICT Event Coordinator(Annual Sports Festival)
- 2011-2014 DA-IICT Student Body Government and Cultural Committee
- 2012 DA-IICT Bronze Medal IEEE Summer School for Web Development
- 2008 & 2010 St. Pauls Sen Sec School Head Boy
Timeline
DATA ANALYTICS CONSULTANT
ZS ASSOCIATES PVT. LTD.
01.2022 - Current
Decision Analytics Associate Consultant
ZS Associates
03.2020 - 12.2021
BUSINESS ANALYST
FLIPKART INTERNET PVT. LTD.
08.2018 - 02.2020
DECISION SCIENTIST
MU SIGMA BUSINESS SOLUTIONS
06.2015 - 07.2018
BACHELORS IN INFORMATION & COMMUNICATION TECHNOLOGY -
DHIRUBHAI AMBANI INSITUTE OF INFORMATION & COMMU-NICATION TECHNOLOGY
10th & 12th CBSE -
ST. PAULS SEN SEC SCHOOL
Similar Profiles
Sushant VyasSushant Vyas
Business Technology Analyst at ZS Associates Pvt. Ltd.Business Technology Analyst at ZS Associates Pvt. Ltd.
Umeed SharmaUmeed Sharma
Business Technology Associate Consultant at ZS Associates Pvt.. Ltd.Business Technology Associate Consultant at ZS Associates Pvt.. Ltd.
Manpreet LuthraManpreet Luthra
Analytics Consultant at ZS Associates Pvt. Ltd.Analytics Consultant at ZS Associates Pvt. Ltd.