Satish Yadav
Data Analyst
Mumbai
Summary
Experienced data professional with a strong focus on improving efficiency and accuracy. Automated 40% of routine tasks at Morningstar. Proficient in Python, SQL, ML, Advanced Excel, VBA, Power BI, and data cleansing. At Kantar, developed and VBA solutions that improved accuracy and streamlined processes.
Overview
3
3
years of professional experience
Work History
Senior Data Research Analyst
Morningastar
03.2024 - Current
- Preparing weekly and monthly Power BI reports on overall team performance for submission to senior management.
- Creating web scrapper to extract the data from various websites & maintaining them
- Mentoring junior colleagues and providing necessary guidance.
- Identify opportunities for process improvement and optimization
Data Research Analyst
Morningstar
09.2022 - 03.2024
- Automating routine tasks using python & VBA
- Conducting quality assurance of data and updating/inserting them on database
- Create and manage issue, Agile methodology, Collaboration and Communication using Jira
- Checking or validating CA & Historical data for various exchanges as a history improvement project
Cleansing & Coding Analyst
Kantar Worldpanel
11.2021 - 09.2022
- Validating format, uniqueness, integrity and organizing data using advanced excel.
- Analyzing data using Advanced Excel and internal software and finding meaningful insights.
- Identifying outliers using Interquartile Range (IQR) & scatter plot and handling them with median, mean & mode.
- Identifying missing value and its appropriate treatment.
- Creating macros for organization to perform efficient and errorless work.
Education
Bachelor of Science - Statistics
University of Mumbai
07.2016 - 06.2019
Master of Science - Statistics
University of Mumbai
08.2019 - 07.2021
Full Stack Data Science Masters - Data Science
Ineuron (Physics Wallah)
04.2001 -
Skills
- Python for Data Science
- Advanced Excel & VBA
- MySQL
- Power BI
- Machine Learning
- Deep Learning
- MS Jira
- Web Scraping
- Analytical Skills
- Descriptive Statistics
- Git
Accomplishments
- Star of the Quarter from Morningstar, 06/01/23
- Spot Award from Morningstar, 07/01/2024
- Automation Award from Morningstar, 11/01/24
Projects
Store Sales Prediction | (https://github.com/Satishji111/Store_Sales_Prediction)
- Missing & Outlier value treatment for categorical & numerical variable using Mode & Mean.
- Analysis on based on Single variate analysis & Multivariate.
- Prediction of store sales using M.L.R. & Regularization (Lasso Regression, Ridge Regression). Along with this I have also used Random Forest & XG Boost.
- For M.L.R., Regularization, Random Forest & XG Boost I have used Parameter tuning.
Kvathnank: Prediction of Boiling Point
- Finding features which are Most effective among all 1918 features using P.C.A. & Sequential feature selection.
- Prediction of boiling point on mixed data using RMSE & MAE Value of M.L.R., Random Forest, K-nearest Neighbors & Neural Network.
- Individual prediction on functional group using RMSE & MAE Value of M.L.R., Random Forest, K-nearest Neighbors, Neural Network.
Timeline
Senior Data Research Analyst
Morningastar
03.2024 - Current
Data Research Analyst
Morningstar
09.2022 - 03.2024
Cleansing & Coding Analyst
Kantar Worldpanel
11.2021 - 09.2022
Master of Science - Statistics
University of Mumbai
08.2019 - 07.2021
Bachelor of Science - Statistics
University of Mumbai
07.2016 - 06.2019
Full Stack Data Science Masters - Data Science
Ineuron (Physics Wallah)
04.2001 -
Similar Profiles
Priti SharmaPriti Sharma
Senior AVP (Senior Business Executive - Consultant), Audit and Governance at Wells Fargo International Solutions Private LimitedSenior AVP (Senior Business Executive - Consultant), Audit and Governance at Wells Fargo International Solutions Private Limited
Mohammad Kaif ShaikhMohammad Kaif Shaikh
Relationship Manager at ICICI BankRelationship Manager at ICICI Bank
Suraj SethSuraj Seth
Assistant Manager – Direct Tax at CBV & Associates LLPAssistant Manager – Direct Tax at CBV & Associates LLP
Aditya ApteAditya Apte
Product Manager at ProgIST Solutions LtdProduct Manager at ProgIST Solutions Ltd
Sarvani Viswanadha PpSarvani Viswanadha Pp
Senior Data Research Analyst at The Hartford Steam Boiler Inspection and InsuranceSenior Data Research Analyst at The Hartford Steam Boiler Inspection and Insurance