Analyst (Developer)
Dell Technologies Taiwan
- 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