Eric Lai Email & Phone Number

Canada

Toronto, Ontario, Canada

• Spearheaded the design and maintenance of real-time operational dashboards, incorporating KPIs such as Patient Volumes, Customer Acquisition Costs (CACs), and Lifetime Value (LTV), enabling senior leadership to.
• Implement automated, multivariable post-campaign analysis using Python and SQL to optimize media strategies, resulting in a 30% reduction in agency costs
• Collaborate with IT to develop an automated ETL pipeline and visualize post-campaign ad hoc analysis using Tableau, enhancing campaign performance monitoring and supporting acquisition and web optimization
• Develop self-service reporting solutions for the marketing and operations teams using Python and SQL, streamlining workflows and saving 4 hours per week
• Partner with IT to enhance enterprise-level data quality and anomaly detection, and re-write patient data tables to achieve over 95% data integrity
• Integrate over 75% of data sources into Snowflake to achieve centralized analysis across marketing, operations, and financial metrics

Toronto, Ontario, Canada

Markham, Ontario, Canada

• Collaborated with account managers and clients to plan product launches, promotions, and seasonal displays, providing historical data analysis support
• Managed the JDA supply planning system, generating a $15 million forecast plan including baseline sales and promotional lifts for top-tier accounts
• Designed and implemented Analytic dashboards using Tableau and Python to visualize and automate hidden revenue growth opportunities for Amazon
• Improved monthly forecast accuracy by 15% for top-tier accounts through a self-developed forecasting tool and optimized order management processes
• Presented monthly forecasting recaps to the lead team, offering strategic input and conducting risk and opportunity analysis

Vaughan, ON, Canada

• Led and Implemented digitization and automation of supply chain management to improve planners' manual tasks efficient from minute-level to second-level（Tableau + Python) and generate BI dashboards for sales and supply.
• Designed and implemented Siemens Preferred Sourcing System (VMI) for automated packaging materials replenishment
• Coordinated with forecasting team to modify, adjust and delete records in SAP to improve forecasting accuracy(Python)
• Saving 20% procurement costs through processing critical orders to clear up excess inventory

Plano, TX

• Achieved over 90% satisfaction through high quality customer service by fulfilling customer requirements
• Led a team to provide sales team with a list of potential valuable clients through data mining
• Reduced penalty costs through tracking container activity on CRM software to ensure on-time release
• Slashed 10% of shipping costs through export contracts negotiation with shipping lines

Grand Prairie

• Executed E-commerce strategy in electronic recycle markets based on data analyst result
• Analyzed online selling performance and managed online operation to achieve $15K monthly revenues
• Developed and utilized a new client database in Microsoft Access to maintain customer relationship
• Explored potential offline clients to generate $10k revenues monthly by mining data in Microsoft Access
• Gathered relevant data from inventory system and online selling reports to optimal inventory management
• Generated online sales report to cooperated with operation department to improve efficiency of the whole operation process in warehouse

Master Of Library & Information Science - Mlis, Human Centered Data Science, 3.82

Key Coursework: Programming for Information Systems (Python) A+, Applied Regression Analysis(R) A, Introduction to Statistics for Data.

Master Of Science - Ms, Logistics, Materials, And Supply Chain Management & Information Technology And Management, 3.97

Activities and Societies: Marketing Leader- CEO Global USA at UTD; Certified participant in Texas Scottish Rite Hospital For Children - UT.

Bachelor'S Degree, Logistics, Materials, And Supply Chain Management

Activities and Societies: Propaganda department leader at Student Union of Soochow University; Peer mentor at Department of Politics &.