Prem Bharat Shah Email & Phone Number

Toronto, ON, CA

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

Mississauga, Ontario, Canada

• Supply Chain intern at Trexo Robotics, a medical device manufacturer building robotic legs that assist children with disabilities with walking/ gait training.Main responsibilities:
• Work with domestic and overseas supplier in procuring custom and off the shelf parts.
• Maintain and improve internal ERP tools and processes.
• Carry out ad-hoc and weekly internal inventory audits to assist with development of quarterly demand forecasts.
• Create weekly shipment and inventory reports for upper management supply chain related meetings.
• Participate in new and existing supplier development and management.

Dallas/Fort Worth Area

• Production planning & Inventory Control
• Collaborated closely with experienced associates, managers, and supervisors within each department to best understand business operations in the most efficient way possible to refine and better cultivate product delivery
• Created ad-hoc reports displaying status of company metrics to support production associates, supervisors in inventory management and viewing performance on a just-in-time basis using complex SQL queries
• Reviewed 200+ BOMs monthly using ERP to analyze and proactively manage material availability by coordinating with purchasing, program managers and vendors
• Developed production dashboards using Tableau, MS Excel to track production forecasts and meet on-time delivery (OTD) metrics
• Created and distributed error reports to assembly leads to ensure company standards for quality assurance are maintained at the highest possible level to minimize complaints and ensure the highest customer satisfaction

Greater New York City Area

• Coordinate with regional sales managers, distributors to receive and process domestic and Direct Import purchase orders, allocate inventory and invoice customers upon shipment using SAGE ERP software.
• Perform weekly audits to maintain Master Inventory Database, reconcile inventory of warehouse & ERP data for multiple SKUs and order stock to maintain inventory levels.
• Handle logistics and shipping of Wine samples using UPS Worldship or FedEx as requested by RSMs or Distributors.
• Work closely with overseas team to coordinate Direct Import orders to USA, track shipment and provide status reports to internal and external customers as needed.
• Developed an Inventory Tracker to analyze depletion of multiple SKUs for promotional program to select key markets.

Buffalo/Niagara, New York Area

• Utilized Python for data wrangling and exploratory data analysis of shipment data.
• Performed shipment lane analysis using Python, and provide recommendations for carrier selection, route management.
• Created visualizations to better understand spread of TCS’s customers, available carriers for brokerage.
• Generated an interactive dashboard using MS Excel to gain actionable insights on fleet operations.
• Carried out trend analysis of selected carriers, forecasting demand using Moving Average model.

Buffalo/Niagara, New York Area

• Researched on "Improving Work Scheduling by implementation of Optimization techniques" under mentor-ship of department professor.
• Developed an optimization model for allocation of shifts that reduces total salary cost by 60 % using Linear Programming in Python.
• Developed Gantt charts to display assignment of nurses to available shifts and departments using Excel, Python.

Buffalo/Niagara, New York Area

• Lead team of five to undertake Time and Motion Studies at orthopedic department to improve patient and information flow.
• Implemented DMAIC methodology for process improvement leading to reduction in non–value added time by 25%.
• Analyzed current performance at the department by using a Time Value Diagram and calculated current sigma level of 1.84.
• Performed Root Cause Analysis to determine factors contributing to increased patient waiting time.
• Reduced Patient waiting time by 30%, ergonomics waste by 23% and overall cycle time by 40 %.
• Performed Data Analysis using Excel, Minitab to generate Scatterplots, Process flow chart, Time-value diagram

Postgraduate Degree, Business Analytics, 3.83/4.0

Activities and Societies: Center for Business Mentorship Program - Participated in George Brown College's prestigious CFB Mentorship.

Postgraduate Degree, Supply Chain Management & Global Logistics, 4.0/4.0

Masters, Industrial Engineering, 3.56/4

Concentration: Supply Chain, Optimization, Quality Assurance, Six Sigma, Process Improvement Relevant Coursework: - Supply Chain Analytics.

Petroleum Engineering, 7.73/10 (In Top 15% Of The Batch)

Education record