Mohamed Rizwan

Mohamed Rizwan

Manufacturing Engineer Intern

Followers of Mohamed Rizwan2000 followers
location of Mohamed RizwanAtlanta, Georgia, United States

Connect with Mohamed Rizwan to Send Message

Connect

Connect with Mohamed Rizwan to Send Message

Connect
  • Timeline

  • About me

    Data Analytics Manager at The Home Depot

  • Education

    • B.S.A.Crescent Engineering College

      2008 - 2012
      Bachelor of Engineering (B.E.) Mechanical Engineering

      Activities and Societies: SAE BAJA 2012, a national level competition to design and fabricate an all terrain vehicle conducted by Society of Automotive Engineers

    • Texas McCombs School of Business

      2024 - 2025
      Post Graduate Program Artificial Intelligence and Machine Learning
    • University of Houston

      2013 - 2014
      Master's degree Industrial Engineering

      Activities and Societies: Member of Institute of Supply Chain Management

  • Experience

    • Meclin Fabricators Pvt Ltd.

      Aug 2012 - Nov 2012
      Manufacturing Engineer Intern

      • Designed and Improved process layout and assembly operations for increasing productivity• Performed time and motion study to reduce bottle necks for maximum efficiency• Reduced five minutes in travel time between processes, optimizing work flow paths• Gained exposure to Lean Six Sigma, 5S and Kaizen• Proposed American Welding Society training for welders, successfully improving quality and reducing defects.• Recommended strategy to implement in-house NDT Radiographic X-Ray testing projected to save over $2,600 annually in overall production cost reduction. Show less

    • Shipcom Wireless

      Jun 2014 - Aug 2014
      Inventory Location Designer Intern

      ● Implemented new room design with real-time locating system (RLTS) to automate and reduce inventory● Conducted cycle counts for adjusting inventory levels before ERP (Catamaran) Go-live● Utilized Kanban and high-density racking to provide logisticians with improved supply replenishment process● Coordinated with logistics staff to ensure the project tracker reflects the true progress of work accomplished

    • Hardy Machine & Design

      Aug 2014 - Dec 2014
      Industrial Engineer Intern

      • Proposed Lean Methodologies to reduce non value activities and increase utilization and production• Developed scheduling board to track the Work-In-Progress (WIP)• Developed part families based on From-To Chart and performed P-Q-$-R Analysis• Suggested improvement to reduce cross-flows, back-tracking in part flow, and high traffic in material handling aisle• Conducted feasibility, cost benefit and root cause analysis (5 whys)

    • Shipcom Wireless

      Feb 2015 - Jul 2016
      Supply Chain Analyst

      • Extensive knowledge of writing and tuning complex SQL queries and generate reports for data analysis• Developed automated tools for data collection, generating reports, and to ETL the data for analysis using Excel macros, Access, VBA, and SQL • Highly proficient in using Microsoft Excel such as VLOOKUP, pivot tables, and Statistical functions• Created advanced chart types, visualizations, and dashboards to demonstrate KPIs using Tableau• Performed assessment at VA site and resolved the discrepancies in the existing supply chain model• Implemented Kanban replenishment strategy in the VA medical center to increase the supply chain efficiency and improve material flow as part of the VA Point-of-Use project• Analyzed large set of historical data using ABC analysis to identify usage trends, inventory turns and effectively locate the surgical supplies thereby increasing the efficiency• Re-designed the distribution center layout to improve order picking accuracy from 88% to 97% based on ABC analysis• Proficient with AutoCAD in designing inventory location layouts and generated BOM based on planning bill forecast• Developed spend analysis to analyze, sort, and categorize inventory data based on vendors• Established forecasted stock levels to reduce capital investment in inventory through regression models Show less

    • The Home Depot

      Nov 2016 - now

      • Led the network strategy analytics team to provide data-driven supply chain strategy recommendations to ELT• Provided multi-scenario long term capacity projections for different types of DCs• Developed network models to determine investment in the right infrastructure, location, capability, and capacity to meet long-term sales & growth targets• Built cost models to determine landed supply chain cost for stocking specific SKU assortment and compare against various stocking DCs• Identified an innovative use-case for multi-echelon concept within the supply chain network and estimated potential savings opportunity of ~$900M in inventory take-out Show less • Led Engineered Flow Schedule (EFS) for various initiatives like reducing RDC trailer backlog to 1.5 days and enabling manual ready-to-ship functionality for suppliers due to challenges posed during COVID pandemic • Implemented flow path changes using network optimization model due to supplier fill-rate constraints saving $350K in transportation cost avoidance• Successfully implemented EFS for new Atlanta RDC building and merging two IFCs (McCalla & West Columbia) into Atlanta IFC as a part of strategic network modeling• Supported enabling truckload rounding (TLR) for One Supply Chain networks like Flatbed Distribution Center (FDC) and Direct Fulfillment Center (DFC)• Managed a team of senior analysts through development and implementation of EFS user-interface, overage automation, and improving forecast accuracy using tools such as Electron, UI Path, Python and Google BigQuery ML Show less • Led the redesign of Sync Engineered Flow Schedule (EFS) audit to take it from a report to a completely automated action-driven audit that protects order frequency and achieved the goal of 100+ days with no order issues• Created tableau dashboard to compare planned vs actual intra-week RDC inbound carton arrivals and identified areas for improvement such as inbound plan forecast, RDC shifts and transit times.• Identified and worked on solutions for standardizing reports and managing truckload parameters as a part of continuous improvement team• Developed an automated process for improving truck utilization that significantly increased scope and standardized the incremental approach with an estimated savings of $3 million by end of 2020• Coordinated a team of 6 to reach finals for a trendsetter competition to pitch the idea of IFC aggregation project • Leveraged Cloud resources to modernize Home Depot's data strategy for supply chain and replenishment to improve scalability and cost effectiveness• Prototyped new business logic and processes to improve supply chain performance while working with IT to enhance and scale the solutions• Researched methods to integrate new product flow and distribution networks as part of One Supply Chain initiative to improve inventory management and to achieve one-day delivery for 90% of US population• Managed groups of resources across business and IT to close the technical gap between business prototype and IT enterprise solutions Show less • Responsible and accountable for sync purchase order creation, reconciling purchase orders to shipments, sending order quantity and reconciliation emails to vendors• Provided support to stakeholders at multiple levels, including vendors and 3PL carriers for issues related to Sync• Built more than 10 audits to monitor Sync engine proactively and resolve the errors by working with internal supply chain teams• Streamlined operational processes by developing various automated tools, standardized communication, execution and remediation plans• Provided Senior Management with reporting solutions for reviewing DNO SKUs, IDM data and Truckload rounding input errors at a high level• Developed EFS import tool which reduces the maintenance time it takes per vendor from more than 3 hours to less than a minute and mass onboarded more than 65 vendors to Sync import program in 2018• Created SQL stored procedures for business decision making to reduce transportation cost and for better utilization of full truck loads• Trained team members on SQL queries, VBA, and SME for reconciliation process Show less

      • Manager - Channel Analytics

        Jun 2024 - now
      • Manager - Network Strategy

        Oct 2021 - Sept 2024
      • Manager - Supply Chain Analytics

        Mar 2020 - Oct 2021
      • Senior Logistics Analyst

        May 2018 - Mar 2020
      • Logistics Analyst

        Nov 2016 - May 2018
  • Licenses & Certifications

    • Six Sigma Green Belt Certificate

      Management and Strategy Institute
      Mar 2015
  • Honors & Awards

    • Awarded to Mohamed Rizwan
      Associate of the Month Home Depot - Supply Chain Analytics Jun 2019 Mohamed led the redesign of Sync Engineered Flow Schedule (EFS) Audit to improve root cause identification of ordering issues and automation of manual tasks. Through his efforts, the team is now able to review and resolve ALL potential ordering issues in less than a day to prevent order skips. We have gone from approximately 1% of all Store-SKUs skipping an order from 2+ weeks to less than 0.1%