Peyush Maini
Columbus,OH
Summary
Senior Data Analyst with 3 and half years of experience in Supply Chain, Data Analysis, and Project Management. Data Analysis/Visualization experience in requirement gathering, design, development, testing, and production rollover of reporting and analysis projects.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Walmart
Grove City, OH
08.2023 - Current
- Forecasting demand and capacity for the transportation network to detriment Dwell time and Empty trips.
- Provided cost and operations recommendation to reduce process waste like manual touches and increased efficiency and using automation in transportation with an annual savings of $4M.
- Analyzed supply chain data from multiple stakeholders to streamline and improve network efficiencies by optimizing network routes and using simulation with a total savings of $2M annually.
Project Manager
Walmart
01.2022 - 08.2023
- Developed a vendor tool using Power Apps and Power BI to track the performance of all the vendors which became useful for the stakeholders to focus on their KPI's.
- Developed an application for online PTO’s for employees to track it in a organized way with the help of a tool Power App.
- With the help of Data Analysis tools (SQL and Power BI), identified system outliers whose resolution led to saving of $1.9M through increased efficiency of KPI like optimized dispatching, empty trailers on road.
- Performed data mining to find out the trend of scheduling loads by vendors to match with company’s scheduling using SQL and Power BI and optimized to save dwell and $1.5M of savings.
Logistics Load Manager, Data Analyst
Walmart
07.2021 - 01.2022
- Optimized Routing and Dispatching process by introducing short term rule with the help of Power BI and SQL
- Developed the dashboard tool to identify the area having maximum number of empty miles for trucks and reduced it with the help of supply chain optimization using SQL and Excel.
Quality Engineer
Kamet Precision Machining & Assembly
03.2021 - 07.2021
- Investigated supplier and product quality issues to determine root causes (CAPA, 8D, 5Why), identified and implemented corrective actions
- Performed failure analysis (8D) for non-conformance’s (NCR’s), and investigated, developing and implementing effective and compliant solutions for product and process corrections and improved KPI from 34% to 80%.
Industrial Engineer - Intern
Continental Automotive Components.
05.2017 - 07.2017
- Identified the issues causing delays in production using tool DMAIC and concepts of lean manufacturing, time study, production planning, line balancing and other specific technical aspects related to the process
- Performed Value Stream Mapping, devised and implemented the corrective measures to improve the quality of a product, reduce the lead time, and increase the process cycle efficiency from 0.11% to 0.21%.
Education
Master of Science in Industrial Engineering -
University of Texas at Arlington
Arlington, TXBachelor of Technology in Industrial & Production Engineering -
National Institute of Technology
Jalandhar, IndiaSkills
- SQL and Databases
- Python Programming
- Advanced Excel
- Tableau
- Data Warehousing
- Data Mining Techniques
- Data Modeling
- KPI Tracking
- Data Mining
Certification
Lean Six Sigma Green Belt - 04/2017
Timeline
Senior Data Analyst
Walmart
08.2023 - Current
Project Manager
Walmart
01.2022 - 08.2023
Logistics Load Manager, Data Analyst
Walmart
07.2021 - 01.2022
Quality Engineer
Kamet Precision Machining & Assembly
03.2021 - 07.2021
Industrial Engineer - Intern
Continental Automotive Components.
05.2017 - 07.2017
Master of Science in Industrial Engineering -
University of Texas at Arlington
Bachelor of Technology in Industrial & Production Engineering -
National Institute of Technology