YASHI GROVER

PnP Modelling Analytics (Jul 2020 – Present)

Working as a Data Scientist on a modelling project of Price and Promotion(PnP) Analytics and Market Mix Modelling of the CPG product. The project results delivers insights over the seasonal as well as non seasonal products and also calculate the COVID-19 impact over the sales and various other facts.

• Used Linear Regression and Bayesian Regression models to break down, interpret and model data.
• Executed end-to-end ETL Azure pipelines within SRM project to provide modelling results
• Developed and optimised reporting tools and interfaces for all levels of KPIs to enhance transparency and boost the overall sales performance.
• Built predictive models and regression algorithms for providing insights as per the client requirements
• Tutored 4 team members and several other teams to enhance data mining, modelling and analysis techniques.
• Reviewed business areas to strengthen analytics, enhance strategic planning and support decision-making processes with solid data.
• Pre-processed structured and unstructured data for modelling.
• Adept knowledge of the artificial intelligence field.
• Delivered predictive-based models through Machine Learning Regression models

360 Integrated Project (Oct 2021 – Feb 2022)
Working as a Data Analyst to understand the flow and impact of different types of data over Sales. Worked alongside team members and leaders to identify analytical requirements and collect information to meet customer and project demands

• Handled the project from the scratch where raw data regarding Media, Customer Serviced, POS was captured and structured.
• Normalization of data was handled in Azure Databricks using python
• Analysis were captured through different drivers or independent variables from model and used to describe the impact of all the sales.
• The project was integration of POS as well as Customer Based data
• Results were presented on the visualization tool PBI with help of Waterfall Data depicting positive and negative impact period wise.

Data insights from Amazon Fresh website (Covid Analysis) (Apr 2020-Jul 2020)

• Developed an automated tool by applying web scraping python tools to scrape data used in the website.
• Data was captured for the client products and to provide each and every detail of product as well as the availability of product in the website on the weekly basis. The motto was to acknowledge the purchase of online products at the time of COVID.

Entry level Data Analyst (Jan 2020 – Apr 2020)

Worked as an independent to execute end-to-end ETL pipelines for a FMCG consumer goods company. The role was to work with client gather all the requirements and was asked to capture data from various sources, manipulate the data, normalize it and use that source of information for running or testing the accuracy of model.

• Worked from client office during the UAT phase
• Able to explore various different sources to capture big datasets and tried to automate the whole process through python in Azure databricks
• Translating business propositions into quantitative queries and collect and analyze as per the test models

Worked as a System Engineer with 1.5+ years of experience and trained under programming languages like Python, Java and database systems.

• Primary role in building models to automate several jobs and tools to test the data models using python
• Experienced in big data handling and work around tools like MongoDB and Apache as well
• Spearheaded complete database restructuring of biggest US healthcare firm which was then used by client for every task.
• Developed a front end tool using Python and PHP which handles the whole backend database and helped user to view data as per the filtered information.
• Compiled data and generated graphs to interpret results and suggest key operational improvements.
• Developed and maintained policies to control information technology and security for BigData operations.