Amanpreet Singh Wadhwa Email & Phone Number

Boston, Ma, Us

Lexington, Massachusetts, United States

• Employed Power Query and DAX queries to integrate 13 tables and ERP transactional data in an SQL database into a Power BI MRP tool, streamlining data analysis.• Developed a monthly inventory trend report in Power BI, tracking inventory value against targets to prevent overstocking.• Designed sophisticated data models with object, column, and row level security, ensuring access control and confidentiality.• Implemented dynamic SKU-level safety stock and reorder point calculations through historical data analysis, averting inventory shortfall through timely ordering of SKUs.• Implemented KPI Scorecards for business monitoring and progress tracking, providing stakeholders with actionable insights.• Deployed a Power BI report for 24-month rolling demand analysis proactively addressing late purchase orders, master production schedule (MPS), and expiries, eradicating stockouts.• Enhanced ETL and data retrieval with advanced SQL techniques, including joins, sub-queries, and group-by functions.• Pioneered a data-centric optimization strategy to trim excess offsite pallet spaces, resulting in over $1M annual cost savings.• Leveraged Power Automate using Power BI datasets to automate workflows that alerted departments about items scheduled to scrap, leading to an average 30% MoM reduction in scrapped costs.• Analyzed return data and collaborated cross-functionally with global teams to align GMP BOMs with actual consumption, resulting in a substantial reduction in returns to warehouse within a span of 4 months.• Implemented A/B testing and User Acceptance Testing on developed dashboards, ensuring high adoption rates.

Boston, Massachusetts, United States

• Prepared shift rosters & managed proctors to ensure optimal coverage using Schedule Source ERP and MS Excel.

Boston, Massachusetts, United States

Mumbai, Maharashtra, India

• Generated ad-hoc reports (Tableau and MS Excel) leveraging data wrangling and analysis of large unstructured SAP data.• Tracked and maintained KPI Dashboards including supplier performance, items to re-order, and late purchase orders, enabling stakeholders' decision-making through data-driven insights and reporting.• Utilized Alteryx workflows with batch macros for efficient data consolidation from Excel files, streamlining data processing.• Engineered a data-driven signal to optimize on-site inventory, enabling timely offsite inventory retrieval, and creating a comprehensive retrieval schedule.• Evaluated the firm's supplier performance by generating 6 KPIs and establishing a Tableau dashboard.• Performed RFx methods for Aluminum raw material, and evaluated quotes to select Preferred Suppliers leading to Cost Savings of approximately $40,000• Forecasted Total Retail Demand & Material Requirement using MRP utilizing customer spending trends to prevent overstocking• Initiated 5S & JIT in inventory room to systemize, accelerate & enhance performance reducing the overall lead time• Reduced inventory expense by $17,000 by obsoleting slow-moving SKUs and rearranging fast-moving goods close to outbound.

Mumbai, Maharashtra, India

• Facilitated stakeholder meetings to reduce supply chain risks by providing accurate forecast reports using Excel.• Generated actionable shipment reports facilitating stakeholders with informed cost negotiations with shipment carriers.• Performed SKU rationalization by ABC analysis on inventory records and customer orders by utilizing SAP to avoid shortage.• Streamlined inventory using Lean Tools like JIT & FIFO at company warehouses yielding savings in holding cost• Employed SAP material management module for requisitions, purchase orders, goods receipt, & inventory management• Executed Gemba walks applying Six Sigma & 5S minimizing waste improving efficiency & operation speeds by 11%• Supervised plan for every part (PFEP) data using cross-functional collaboration decreasing inventory waste & bottlenecks

Mumbai, Maharashtra, India

• Analyzed SOP by conducting VSM, rectifying non-value adding time (NVAT) thereby improving cycle time by 7%• Remodeled SKUs to integrate Good Manufacturing Practice (GMP), resulting in 16% better space utilization• Collaborated with sales & production departments for timely delivery of product, reducing late deliveries by 30%• Conducted failure analysis activities in manufacturing of braking parts using Statistical Process Control (SPC) approach, reducing dock to stock time by 8% and dispatch time by 14% using in-house fulfillment

Master Of Science - Ms, Industrial Engineering

Grade: 3.8 Courses Taken: -Data Computation and Visualization -Engineering Probability and Statistics -Data Mining in Engineering -Data.

Bachelor Of Engineering - Be, Mechanical Engineering, 8.43

Relevant Courses: -Industrial Engineering and Management -Project Management -Production Planning and Control -Energy Audit and Management

Diploma, Mechanical Engineering, 8.74

Class X, Science, 93.17%