Supply Chain Optimization & Quality Analytics

Himanshu Ushara

Male, ** years

Indian Institute of Management Mumbai (NITIE)

MBA – General Management

ACADEMIC PROFILE

Degree Institute %/CGPA Year

MBA Indian Institute of Management, Mumbai 8.16/10 2025 B. Tech National Institute of Technology, Kurukshetra 7.7/10 2021 Class XII St Edmund’s School, Jaipur 72.80% 2016

Class X St Edmund’s School, Jaipur 7.8/10 2014

WORK EXPERIENCE Apr’25-Present

GMM Pfaudler Manager

Project Title - 1: End to End Supply Chain Visibility & Optimization Dashbaord Responsibilities

■ Performed AS-IS of fragmented reporting across 12+ functions, defining scope for digital transformation

■ Consolidated 6+ departmental datasets into a unified Power BI dashboard enabling visibility across 3 plants

■ Transitioned monitoring from monthly to daily tracking across 10+ checkpoints for each production stage

■ Developed automated triggers with end-to-end defect traceability by job-number across 3+ Mfg stages

■ Deployed SPC charts (X-bar, MR & U-charts) across 8+ attributes to enable data-driven quality decisions Achievement

■ Reduced cost of poor quality (COPQ) by 25%, delivering 5L+ savings via auto defect detection & CAPA

■ Improved OTIF predictability by 22% through real-time WIP visibility across the three supply chain nodes Project Title - 2: Redesigning Inventory Norms & Inventory Cost Optimization for Multiple Sites Responsibilities

■ Mapped full cycle inventory flow from Inbound to Outbound surfacing gap b/w actual use & ERP norms

■ Assessed SKU consumption to evaluate current Safety stocks & ROP against demand pattern & variability

■ Conducted ABC-XYZ analysis to segment 48+ SKUs prioritizing high-impact items to optimize stock norms

■ Performed Statistical demand analysis & Usage trend plotting to flag misaligned ROP and Safety Stock

■ Spearheaded Cross-plant collaboration to align ROP & Safety Stock, driving multi-site inventory optimization Achievements ■ Achieved total cost savings of INR 35.95 Lakh via stock optimization across 2 Manufacturing facilities Project Title - 3: Throughput Dashboard for Global Manufacturing Sites Responsibilities

■ Conducted As-Is of material flow in SAP, uncovering gaps for GRN to dispatch for throughput tracking

■ Architected a centralized Dashboard for a unified view of Throughput for each product across global sites

■ Partnered with CFT to decode SAP logics for material tracking & using them for dashboard development Achievements ■ Enabled data-driven decision-making to drive continuous improvement & enhance key operational KPIs SUMMER INTERNSHIP Apr'24-Jun'24

TATA Cummins Pvt Ltd Supply Chain Intern

Project Title - 1: Spare Part Inventory Management and Cost Optimization Responsibilities

■ Developed real-time dashboards enhancing Inventory visibility and liquidation, generating profits of 10L

■ Improved Forecast Variances & Downtime by 6% by conducting VSM and optimizing safety stock levels

■ Achieved a 20% Reduction in Excess Inventory by streamlining the Inventory Replenishment Cycle Plan

■ Envisioned INR50L reduction in annual carrying costs by identifying 545 inactive SKUs using ABC analysis Achievements ■ Obtained 90% data accuracy by developing a centralized master inventory database for mitigating bottlenecks Project Title - 2: Data-Driven Inventory & Supplier Optimization Responsibilities

■ Devised improvement plan for high-impact areas by surveying multiple departments to assess performance

■ Developed Integrated supplier selection criteria via Analytical Hierarchy Process (AHP) for 5+ factors

■ Formulated Risk Matrix, assessing Supplier Risks on the basis of Financial, Operational & Compliance factors

■ Tailored Power BI Dashboard for Real-Time Inventory tracking, Trend Analysis and Supplier-level insights

■ Reduced ordering costs by 15% using cost-benefit analysis, streamlining POs and replenishment strategies

■ Projected 15% cost reduction by identifying local vendors, Optimizing Logistics and enabling JIT inventory Achievements

■ Saved 3 hrs/week on Supplier Scorecard generation by streamlining Cross-Functional Team data sharing

■ Optimized Supplier Selection Accuracy by 15%, leading to a 30% overall reduction in Incident Reports CORE COMPETENCIES

Demand Planning & Forecasting Inventory Management S&OP Understanding Supplier Evaluation Data Analytics Data Visualization Data-Driven Decision Making Structured Problem Solving AWARDS AND ACHIEVEMENTS

Certifications

■ Completed SAP Learning Journey: SAP IBP for Demand-Forecasting & Statistical Models 2025

■ Completed Data Analysts Toolbox: Excel, Python, Power BI, Pivot Tables from Udemy 2023 College Captain ■ National-level Basketball player; captained NIT & IIM teams to multiple titles; featured by NBA India 2024 Email: ***************@*****.*** www.linkedin.com/in/himanshu-ushara Phone: +918********* HOBBIES

■ Passionate about Photography, enjoy listening to Music and Skateboarding

Contact this candidate