Bavesh B.
BengaluruIndia

CPG | Pharma | MMx & forecasting modelling insights | Visualization

As a seasoned Data Scientist with 2.1 years of experience, specializing in both Consumer Packaged Goods (CPG) and pharmaceutical commercials. In CPG, I honed my skills in data visualization, forecasting, and workflow automation using Tableau and Alteryx, enabling data-driven decision-making and fostering 3-year YOY growth through advanced modelling techniques. Transitioning to pharmaceuticals, I excel in key driver analysis, optimizing market promotions to drive performance and maximize ROI. My expertise lies in transforming complex data into actionable insights that fuel strategic business decisions. Projects Key Driver Analysis Helps business in identifying the most influential factors impacting a specific outcome, enabling businesses to prioritize resources and strategies effectively. By using statistical techniques to assess the impact of various variables, it helps optimize decision-making, enhance performance, and maximize ROI. - collecting data using SQL - Pre-processing the data and creating master data set using R programming and driving insights from the data. - Model building and interpreting the results and summarising the impacts of promotions. Category Sales Forecasting Projected category sales for the specified market by employing regression techniques for short term and time series for long term. This approach assists the clients in formulating a three year operational plan considering the macro economic factors. - Data extracting from various platforms. - Performing EDA operations and data wrangling. - Simulator creation helps in Interpret the trends. Supply Chain Dashboard Building a tableau-based framework to create consolidated views to analyze the category-brand performance across various clusters, markets by connecting 6 differed live data source and focusing on Key BMCs at different time frames. - Creating relevant tableau calculated fields: Create a blend for different data sources. - Identification of right fields and additional fields that helps in creating the tableau views. - Create relevant calculated fields & parameters on top of the blended data.
Skills

Skills

  • Tableau
  • Alteryx, Inc.
  • Data Wrangling
  • Statistical Analysis
  • Linear Regression
  • Regression Analysis
  • Time Series Forecasting