Logistics Coordinator
Current- Analyzed inventory level & vendor quote for price/specifications to purchase 1500+ SKU from 10+ vendors from Canada and US via SAP-ERP system - Negotiated product availability, potential delay, potential substitutes and updated lead time to avoid shortages/delays for production process & customers - Maintained 100% of communication efficiency via Teams/Outlook with stakeholders and suppliers to solve issues of Less-than-truckload/ Full-truckload deliveries- Collaborated with 5+ carriers for properly tracking shipments and scheduling pick up/inbound deliveries accurately via Outlook/Teams/calls- Issued RFQ and purchase orders from SAP-ERP; assisted with sourcing and negotiating for best freight rates- Collaborated with Account Payable and vendors/carriers to investigate and resolve invoice variances, extra charges and product returns (reached 100% accuracy) by using Teams/ Outlook/ Excel and SAP- Set up & maintained SAP database and suggested potential cost-saving solutions (99% of accuracy)- Utilized Excel and SAP system to analyze and forecast monthly sales demand, updated items monthly usages properly to purchase and maintain inventory levels accurately - Entered and maintained computerized records of Purchase Order Acknowledgements, items purchased, costs and schedule of deliveries - Communicated effectively with 5+ suppliers via Outlook on product costing/availability and lead time/shipping date for accurate ETA - Expedited/ Followed up on late orders on a regular basis and updated accurate ETA in SAP-ERP to reflect current status of backorders, or closed, as required- Collaborated closely with SAP business partners and stakeholders to keep track of project plan/ budget/ resources by using Smartsheet to improve Operations procedure- Prepared weekly/monthly reports (Word, Excel) and presentations (PowerPoint) to provide management with process improvement solutions/risk assessment for on-going projects via Google Workspace