This position supports Sysco supply chain in all US board line distribution centers. Responsibilities include:

Analysing Modelling and Deploying:

• Extract, transform, and load (ETL) transportation data using Redshift Amazon S3.
• Built a perishable food transportation Tableau dashboard to track transportation KPIs and reduce delivery time and payment by 15% in metropolitan areas, resulting in a $2 million miscellaneous pay reduction every six months.
• Redesigned hours of service calculation employing Python to decrease load times by 98%.
• Loaded 2G daily operation data in data warehouses to Redshift using Postgres SQL, Python, and PowerShell.
• Designed and modeled the in-house payroll system from scratch and worked with the offshore dev team in Agile. My role owned payroll data auditing and syncing with the S3 data warehouse.
• Digest labor planning payroll data from ADP and heritage system for over 70,000 drivers, identified patterns, relationships, and trends across multiple data sources.
• Designed and coordinated with the robot team to implement mini pallets on testing and scaling to West Coast distribution centers.

Strategic Sourcing and ROI analysis:

• Led and managed a $20 million routing platform RFQ, frontend and backend implementation, UAT, testing, site go-live, and scaling for all US 68 super distribution centers, supporting 70,000 drivers. This role reported to senior directors and supported VP decisions.
• The management team would like to understand the ROI of the return of the new routing system. I Built profit and loss models to evaluate project ROI and evaluation in a 5-year projection. The profit and loss history data comes from Sysco accounting system SAAS, which stored 50 years of financial data. The IRR was defined based on food industry standards and Sysco history data on similar projects.
• Sysco started to implement RFID to increase delivery effectiveness. The old Zebra device was not flexible regarding speed and flexible angle scanning. I worked with IT and the warehouse leader to source and purchase 20,000 handhelds to upgrade the current barcode system to RFID scanning. The IRR was evaluated based on market and Sysco history data. The model simulated three scenarios to calculate the breakeven timeline. This upgrade increased ROI by 28%; the expected breakeven point is three years.

• Monitored and implemented an inventory tracking system using VBA to track real-time inventory.
• Designed strategic sourcing to reduce costs, increasing the revenue-to-expenses ratio by 20%.
• Created and maintained standardized documentation and SOPs for demand forecasting and planning processes on a $ 10,000 daily inventory basis.
• Optimized inventory control procedure and reduced inventory loss by $20,000 monthly.
• Refined developing annual inventory evaluation reports with 40% timesaving.
• Designed strategic sourcing to obtain cost-effective deals and increased the ROI by 20%.
• Built Tableau dashboards for tracking operation KPIs and lowering the holding cost by 15%.

This position supports Sysco supply chain in all US board line distribution centers. Responsibilities include:

• Managed an annual volume of $2 million in direct-hire strategic sourcing around the globe, including product life cycle and cross-functional coordination.
• Monitored and evaluated the compliance of 20,000 temporary contractors.
• Implemented a global VMI vendor management inventory system for external suppliers.
• Drafted contract clauses for procurement as per RFQ, including tax, insurance, and compliance.
• Implemented a strategic sourcing vendor management inventory VMI system, narrowing the vendor list from over 3,000 to 100 across 80 countries. Saved over $1 million headcount spent quarterly.
• Monitored and evaluated the compliance of 20,000 temporary contractors across 80 countries.

The leading oil and gas company in China. My role support upstream supply chain management. Procurement and sourcing :

• Purchased and managed a $ 10 million pipeline and CNG station installation through EPC.
• Organized competitive tendering and procured fracking over $10 million for over 200 wells..
• Reduced upstream exploration and production operation costs by $ 2 million. SAP consulting:
• Implemented SAP system Financial Accounting (FI), Material Management (MM), Sales and distribution (SD), and Production and Planning and Control (PP).
• Roll out a barcode system to track airway bills and shipping status.