Language - Python, R, SQL, XML, ETL
BI Tools - Power BI, Spotfire, Tableau
Database - Normalization/ Store Procedure/ Trigger, ERD
Automation Tools - Power Automate, Power APP, VBA Macro
Data - Data Mining, Descriptive/Predictive/Perspective Data Analysis, Data Visualization
Machine Learning - Regression, Text Mining, Classification, Clustering
Workload Model & Peak Hour Analysis
- Collaborated with central team and analyzed operation workload using mathematical approaches.
- Planned ways to decrease workloads and enhance way of working to meet the target of saving 8% annually workload
- Built BI dashboards to keep monitoring supply chain network demands volume, and adjusted shift model accordingly to make each headcount handles proper workload
Case Allocation Process Automation Solutions
- Provided and designed automation solutions to integrate both parties of multiple supply chain channels, which saved 80% manual efforts and errors to allocate world wide demands
Automation Output Bots to Gather Operational Data
- Programmed Python, VBA automation bots to crawl supply chain data from Microsoft Outlook, SharePoint, SAP, and forwarder sites, then integrated different sources into BI dashboards to ensure the best sourcing efficiencies
Communication
Adaptability
Project Management
Mandarin
English