//assets.cakeresume.com/assets/contentarea/contentarea-2d64eca8dae2a1ffb31e0fb1df887bbad072c7c19734d7d30fa14884bbcc299a.css

Data analyst with 2 years' experience in helping organizations leverage data by establishing data governance, identifying use- cases and implementing appropriate techniques to extract business value from data. Seasoned in managing projects involving stakeholders from varying regions and business functions. Project experiences include building data pipelines, report automation, and data mining using Python and R.

National Tsing Hua University

Analyst (Developer), Strategy and Project Management Office

Alex Cheng

Dell Technologies Taiwan

Analyst (Developer)

- 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

Jianpu Technology Beijing

Business Intelligence Data Analyst

- 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

Alex Cheng’s posts