Simon Lin Email & Phone Number

Toronto, Ontario, Canada

• Mass data analysis on customer behavior, customer account balance/credit tracking, loaner operations and channel operations performance dashboard• Designed and created “Data Slicers” showing strategic level performance dashboard. Supported the problem analysis by function of “Drill Down” in multiple hierarchies• Deep dived on Customer Survey results to analyze channel performance and business efficiency. Illustrated business status with operational mass data.• Streamlined process of channel operations on loaner allocation with user-friendly interface and process. Improved operation-planning efficiency by 400%. • Provided query tools for customer account management, loaner operations management and strategic analysis team to align information from multiple data sources. • Optimized reporting process providing semi-auto tool for national wised cycle count status tracking and reporting. Cut the hourly tracking process from half an hour to less than 5 mins.• Run data validation for dataset within one million records with around 80 data fields.• Worked with SAS EG, QlickView and Power BI to generate reports automatically for service channel performance and channel operations.

Toronto, Canada Area

A solution provider facing small business firms, finding business solutions for data management and analysis with VBA (Macro), Access and BI tools; optimizing current planning/operational processes with Lean method and automatical tools

Toronto, Canada Area

• Managed supply chain operations including customer order fulfillment, material forecasting and replenishment, supply allocation and inventory control for 20-million-project in western Canada. Deployed 1700 more sites within one and a half years.• Optimized the logistics and warehouse operations processes to reduce inventory cycle from 21 days to 12 days while kept inventory accuracy at 99.6% by applying Lean methodologies• Created operations dashboard, estimated the business trend based on current business status. Provided the business solutions for incoming operational problems• Optimized operational KPI and business dashboard. Lead end-to-end operational process enhancement and SOP documentation. Setup daily operations procedures and streamlined the reversed operations with multi-functional co-operations. Improved the operational efficiency rate from 92% to 99.7%, 2nd highest across 19 divisions within the company.• Supervised SCM team with seven team members in four locations with two warehouses and office locations. Managed the resources for supply chain management.

Beijing City, China

• Identified business opportunities on process improvement across multiple functional teams, including Channel Management, Order Management, Fulfillment, Manufacturing and Logistic leading POF (Perfect Order Fulfillment%) improvement from 31% to 75% by applying Work-Out method in Lean Six Sigma for problem solving• Optimized SOP to improve business efficiency in Global Share Service Centre. Improved order loading automation percentage from 73% to 98% in North America team by applying VBA macros.• Streamlined the operational procedure by creating operational dashboard. Conducted S&OP review meeting to track the business KPI. Configured KPI tracking reports and provided the consultancy on KPI improvement• Created SIPOC diagram to map the end-to-end business processes starting from marketing, order management, order fulfillment to manufactory. Conducted process re-engineering workshop. Built strong relationships with both the operations team and IT solution team and create a cohesive partnership

Beijing, China

Black Belt & Supply Chain Systems SME• Managed the maintenance and ongoing development of operations management processes and data warehouse to support the daily operations by using Access and VBA tools.• Managed business intelligence reporting to commodity departments on key supply chain metrics, such as build plan, supply allocation plan, safety stock management, demand-supply alignment and business scenarios simulation. Kept the daily operational process streamlined.• Acted a key role in Global ERP system implementation. Involved in global ERP projects, Oracle Demand Planning, Oracle and i2 Supply Chain planning, as an SME, PDA, reporting lead and regional DBA. Create the functional requirement document and manage the change requests.• Conducted functional test, UAT and end user training for functional teams in China, Singapore and US.Consultant Materials, Supply Chain Operations Planning• Streamlined 15-day regional operations cycle to adapt with 8-day planning cycle from worldwide supply chain by replacing manual processes with programed data loading tools. Implemented data warehouse to adapt into the global planning cycle. Improved the efficiency of daily operations by 300%.