Supply Chain Analyst with Lean & Analytics Expertise

AYUSH DESHMANKAR

Atlanta, GA 945-***-**** *********@********.*** LinkedIn

EDUCATION: -

University of Texas at Dallas Dallas, TX

Master of Science in Supply Chain Management Sept 2025 Rajiv Gandhi Proudyogiki Vishwavidyalaya Indore, India Bachelor of Engineering in Fire Technology & Safety Engineering July 2020 SKILLS: -

Programming Language: - Python, R, Minitab, SAP ERP Supply Chain Technologies: - Lean Techniques, Lean Six Sigma Data Analytics: - MS Excel, Power BI, Power Query

Certificates: - Six Sigma Green Belt, Data Analytics by Google WORK EXPERIENCE: -

Important Gifts Inc. Atlanta, GA

Supply Chain Management Jan 2026 - Present

• Improved storage performance, created materials reports using Excel, and removed the non-valued materials from inventory.

• Collaborated with stakeholders to increase optimal 3PL assurance, quality and streamlined return delivery time by 3 days.

• Monitored lead time of spares by value stream mapping to maintain continuous improvement, and improved efficiency by 25%. Schneider Electric Athens, TX

Logistics Engineer Intern Jan 2025- May 2025

• Collaborated with the warehouse team for building package flows, and ramped up the delivery of materials to the line by 15%.

• Managed capacity plan using YMS for move order inventories, optimized inbound/ outbound logistics & improved yard efficiency.

• Optimized SOP of materials delivery, created a dashboard for 3PL delivery timeline & built a roadmap for reducing lost parts.

• Ensured ad-hoc deliveries on time, created a supplier lead time errors dashboard and tracked logistics are delivered as per BOM Alliant Infotech Indore, India

Supply Chain Analyst July 2022 – August 2023

• Collaborated with NPI to improve BOM readiness, optimized inventory lead times using Power BI & improved production by 20%.

• Issued RFP, RFQ, and PO using SAP, documented updated specifications in SAP, and collaborated with vendors to evaluate TCO.

• Analyzed supplier performance, eradicated redundancies in PO, & improved OTIF service level from 84% to 95% using SAP ERP.

• Collaborated with material planners to benchmark suppliers, optimized safety stocks & improved material delivery rate by 10%.

• Optimized SOP of parts lifecycle, collaborated with Purchase Managers for supplier onboarding & reduced stockouts of Class-A.

• Collaborated with suppliers for PO lead time, categorized data based on consumption & reduced the stock-outs of Class-B parts.

• Standardized SOP for procurement, analyzed SKU dataset for safety stocks & reduced supplier lead time & costs by $30000.

• Led team of 13 GSMs for procuring Tier-1 raw materials, analyzed data using Power BI, & reduced overstocking worth $3000. Ashiyana Group Indore, India

Site Engineer- Procurement July 2020 – June 2022

• Optimized E2E demand forecasting of semiconductors worth $50000 performing root cause analysis for motor sourcing based on SKU’s consumption rate and negotiated procurement costs KPIs worth $10000 supplies per month.

• Developed RMA lead time tool based on lead time, and vendor’s alternative using Excel & mitigate overstock risks worth $40000

• Improved in-stock & fill rates from 48% to over 90% by analyzing vendors’ databases, and reduced E&O to the line by 30%.

• Improved 10% sourcing & capacity planning and a 15% reduction in inventory by analyzing reorder points in SAP using MRP. PROJECTS: -

Inventory Management System Feb 2022 – June 2022

• Analyzed Class-A inventory based on the consumption rate, built SQL script to analyze high-priority parts & optimized the min/max.

• Analyzed SKU’s dataset, drew forecasts, and remodeled ABC analysis using Power BI for 1800 SKUs across 20 product categories. Supply Chain Optimization Sept 2021 – Dec 2021

• Created a database of materials, identified frequently used SKUs using Power BI, and forecasted the lead time of replenishment.

Contact this candidate