CV
Education
Columbia University — M.S. Applied Analytics (Expected December 2025)
Syracuse University — B.S. Business Analytics & Finance (May 2024)
Experience
Capgemini — Business Intelligence Consultant · Shanghai · Jun – Aug 2023
- Analyzed Fortune 500 supply chain data from SAP using SQL and R, delivering strategic insights to C-suite leadership
- Built Power BI dashboards for real-time visibility into supplier performance and procurement risk
- Reduced manual data processing effort by 40% through automated workflows and UiPath-SAP integration
Shengtetai Food — Data Analyst · Guangzhou · May 2024 – Jul 2025
- Engineered Python pipelines (Pandas, NumPy) processing 50,000+ rows of sales and inventory data
- Developed Tableau dashboards providing leadership with real-time visibility into $1.5M in annual revenue
- Identified high-value customer segments through SQL-based behavioral analysis, improving targeted marketing performance
Skills
| | |
|---|
| Programming | Python (Pandas, NumPy, TensorFlow, Matplotlib) · R · SQL |
| BI & Visualization | Tableau · Power BI · Excel |
| Machine Learning | XGBoost · LSTM / Bi-LSTM · Feature Engineering · Hyperparameter Tuning |
| Tools | SAP · UiPath · Microsoft Access |
| Languages | English · Mandarin (Native) · Cantonese |
Publications
Jiayi Liu, Yufeng Yang, Teng Lin, Chuanhui Peng, and Yancong Deng. (2024). "Enhancing Stock Price Forecasting and Trading Strategy through Bidirectional LSTM Integration." 2024 5th International Conference on Machine Learning and Human-Computer Interaction (MLHMI), pp. 22–25. DOI: 10.1109/MLHMI63000.2024.00013