- Built data pipeline from 3 enterprise resource planning systems for over 20 commodities and 4,000 parts, providing a central SQL Server data repository fundamental to all data analytics solution - Design, developed, and deployed early warning mechanism for anomalies in forecasted demand, introducing unprecedented visibility on parts with high risk of shortage and saving over 20 man-hours/week on reporting - Established review process for spending across suppliers to ensure adherence to strategic allocation, preventing hard dollar leakages through incompliance of suggested spending allocation - Automated report generation for weekly days’ sales of inventory (DSI) review using Excel VBA and scheduled PowerShell tasks, standardizing over 30 different data sources into a single Power BI dashboard - Devised and implemented digital project governance framework to manage up to 4 concurrent digital projects, involving teams across US, Malaysia, and China spanning across 4 different lines of businesses

- Designed and deployed warning system for app downloads through time series anomaly detection, which successfully captured one data anomaly online due erroneous software update - Corrected database ETL logic error in marketing attribution model that reduced attribution to paid channel by over 15%, providing better perspective to performance of paid traffic - Led cross-functional team of 3 on development of an internal marketing optimization platform, improving marketing ROI by 12% through customer persona discovery visualized with R ggplot2 - Optimized marketing budget allocation through linear programming with Python and developed an A/B testing validation tool, improving ROI by over 7% - Conducted exploratory analysis that resulted in savings of over RMB 100, 000/week by terminating ineffective marketing activity on an alternative app

- Conducted market research and evaluation for 10+ products across 5 different industries, and assisted in securing a coffee machine deal with the largest convenience store in Taiwan - Worked with the Service and Maintenance Team to model revenue projections of inventory clearance options for over 2, 700 units of coffee machine, converting aging inventory to a potential NTD 7.8 million business - Introduced automation tools with Excel VBA and Google Apps Script to streamline workflow, saving 2 hours/month on manual work with a KPI calculator