Abrar Ali Email and Phone Number

• Collaboratively use Python Script and Power BI to identify Suppliers with high lead time variability in order to accurately predict lead times and safety stock• Formula and execute disposition plan to reduce Point of Use, Cycle and Safety inventory resulting in $3.6M savings.• Facilitated a 1.3M sq. ft. facility closure initiative for a fortune 100 Heavy Equipment Manufacturer, resulting in the successful transfer of $40M inventory to 12 international and domestic locations in a record 6 months.• Create and execute a strategic plan for the sale of over 12K parts, resulting in a 50% reduction in scrap and a $5M increase in sales.• Design and implement a demand/capacity KPI using Microsoft Excel, enabling senior management to make strategic decisions regarding plant closure timeframe, fulfilling customer orders, and decreasing past dues from $20M to $500K.• Develop automated scheduling dashboard to track material flow, capacity and manpower, leading to increased efficiencies in fulfilling customer orders. • Develop an inventory and storage consolidation process, increasing shipping performance by 50%, reducing head count by 75%, and streamlining communication flow between teams.• Align with dealers and product group to perform Voice of customer analysis to understand market segmentation and capture lost opportunity.• Used Power Bi to connect various data sources to help identify aftermarket opportunity worth $600 million.• Used Data Analysis Expression (DAX) function to create measures in data model using Power BI.• Developed an algorithm using VBA to identify Bracket Pricing opportunity to reduce supplier cost by 20%.

•Perform analysis on load positioning of Autonomous Hauling Systems for a fortune 100 Heavy Equipment Manufacturer, improving efficiency of travel.•Implement R Studio to clean, mine and perform analysis on Big Data, decreasing processing time by 50%.•Utilize Machine Learning methodologies, including Amelia, Regression, Mice and KNN, to identify missing data and improve accuracy of results.•Write R code to detect anomaly in live data, resulting in the identification of correct load positioning.•Create comparison charts and perform cluster analysis on tableau to demonstrate improvement potential of 24% of COG and load positioning.

• Perform analysis on load positioning of Autonomous Hauling Systems for a fortune 100 Heavy Equipment Manufacturer, improving efficiency of travel.• Implement R Studio and SQL to clean, mine and perform analysis on Big Data, decreasing processing time by 50%.• Utilize Machine Learning methodologies, including Amelia, Regression, Mice and KNN, to identify missing data and improve accuracy of results.• Write R code to detect anomaly in live data, resulting in the identification of correct load positioning.• Create comparison charts and perform cluster analysis on tableau to demonstrate improvement potential of 24% of COG and load positioning.

• Create MRP Solution to automate the monitoring of multi-store inventory and the notifying of restocking to ensure customer orders are fulfilled in a timely manner.• Write Visual Basic code at customer site to enable daily inventory updates and reduce response time for order fulfillment. • Collaborate with new retailers and suppliers to determine their needs and expectations, leading to a 6% increase in sales and a 75% expansion of the customer base.• Lead brainstorming sessions with team of 5, including senior leadership and manufacturing professionals, to identify opportunities for improvement and implement better quality assurance standards. • Perform quality checks on products before dispatching to retailers applying control charts, DMAIIC, 6s, resulting in a decrease in returns and an increase in satisfaction.

•Inspection of heavy duty vehicles that come to the workshop and carry out troubleshooting and repairs.•Installation and replacements of various parts including gear box, brake system, drive train, etc.•Maintain, analyze and update database of incoming vehicles and their spare parts.