Supply Chain Data Analyst

MAYANK SAHU

832-***-**** *********@*****.*** Houston, TX LinkedIn

Summary

• 6-year experience as a supply chain professional adept at mitigating operational disruptions and optimizing inventory management to meet customer demand.

• Consistently enhanced organizational processes through a holistic and strategic approach, effectively showcasing my expertise in data analysis, automation, cost-saving, troubleshooting, and comprehensive team development.

• Skilled in conducting data analysis to define key performance indicators and implement strategic forecasting strategies. Education

Master of Industrial Engineering, University of Houston, Houston, TX, May 2021 Bachelor of Mechanical Engineering, Guru Gobind Singh Indraprastha University, India May 2018 Skills

• Supply Chain Analysis

• Sourcing, Logistics

• Global Supply Chain Management

• Data Analysis in Python/SQL

• Demand Forecasting

• Production Planning

• Continuous Improvement

• Project Management

• Advanced Excel, SmartSheet

• ERP, SAP

• Financial Modeling

• Agile Manufacturing

Professional Experience

Sr. Scheduler/Buyer, Applied Materials, TX Oct 2021 – Present

• Collaborated with Purchasing and Operations teams to analyze high-risk parts, implementing a quarterly forecasting strategy. Achieved significant downtime reduction from 15% - 5% by proactively mitigating shutdown risks.

• Introduced a streamlined method for injecting information into ERP systems using Python and Excel, boosting efficiency by 90% and eliminating over shipments, shortages, obsolete materials, invoice issues, & rework or scraps.

• Performed Descriptive analysis on the manufacturing processes to define KPI’s for increased dwell time, which was 20% more than SLT, 138 reduced to 111 hours, realizing cost savings of $364K.

• Spearheaded a comprehensive project to formulate the organizational framework for high volume production encompassing all five phases of the Product Development Cycle, while also delineating the roles and responsibilities of stakeholders.

• Utilized Excel dashboards & SAP to solve supply, quality, and logistical problems pertaining to acquired commodities for smooth operations to get best possible procurement results by interacting with Production, Engineering & accounting team.

• Created a cloud ERP (Smart Factory) tool to monitor Manufacturing Floor and KPI’s to help track supply chain and customer commit which updates SAP data as well. Reducing planning hours of production team.

• Led a collaborative initiative with manufacturing and operations teams to develop a Standard Labor Hours Model, enhancing cost efficiency and performance optimization within each fiscal year.

• Streamlined the RFP, RFI & RFQ processes by creating comprehensive documentation, organizing multidisciplinary teams, and assessing international vendor offers to guarantee well-informed choices, optimize benefits, and cultivate robust supplier connections.

• Established Autostore team to ensure timely delivery of parts from warehouse to MFG floor, reducing lead time from 7 to 4 days and saving $275K in labor costs.

• Tailored ad-hoc reports to align with leadership expectations, enhancing organization-wide decision-making processes.

• Successfully trained two new team members on SAP systems and Smart Factory processes to build a skilled and cohesive team.

• Evaluated Capacity Sheet for expansion of 2 business units to design a schedule for ramp up in manufacturing according to the S&OP numbers.

Operations Intern, Solarcraft, TX Jan 2020 – May 2021

• Managed Material Requirements Planning (MRP) within SAP, ensuring the accuracy of inventory levels and facilitating timely production scheduling.

• Developed an Excel Dashboard leveraging VBA, Xlookup, and Pivot tools to forecast critical shortages and optimize resource allocation for future project builds.

• Generated routine shortage reports to facilitate communication and coordination among manufacturing, purchasing, and project management stakeholders.

Supply Operations Analyst, Satyam Auto Components Ltd, India Jul 2017 - June 2019

• Managed a cross functional team and trained new hires in PO’s, RFQ’s, designs and proposals increasing overall efficiency by 20%.

• Created RFQs and POs for sourcing raw materials on ERP software and implemented suppliers score card.

• Modified manual tracking system, used excel to generate tracking link which reduced manual hours from 90 min to 5 min.

• Implemented Tableau to create an interactive Capacity Dashboard with defined KPI’s for accurate forecast.

• Acted as a liaison between clients and stakeholders to gather project requirements, address concerns, and provide regular updates on project progress.

Contact this candidate