Data analytics professional and graduate researcher at Columbia University, specializing in translating complex datasets into strategic decisions through machine learning, business intelligence, and statistical modeling.

With experience at Capgemini and Shengtetai Food, I have built systems that directly impact operations and revenue — from automated supply chain pipelines to real-time dashboards tracking $1.5M in annual sales. My research on Bidirectional LSTM architectures for stock price forecasting was published at IEEE MLHMI 2024.

$1.5M
Revenue Tracked
98%
Search Hit@10
40%
Processing Time Saved
IEEE
Published Research

Skills

Programming
Python SQL R
ML / AI
TensorFlow XGBoost LSTM · Bi-LSTM Pandas NumPy
BI & Viz
Tableau Power BI Matplotlib Excel
Tools
SAP UiPath Microsoft Access
Languages
English Mandarin Cantonese

Education

Columbia University
M.S. Applied Analytics
Syracuse University
B.S. Business Analytics & Finance

Experience

Capgemini Business Intelligence Consultant
Jun – Aug 2023 Shanghai
  • 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
May 2024 – Jul 2025 Guangzhou
  • 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.

Research & Projects

NLP · Information Retrieval
Amazon Product Search & Review Summarization

Co-developed a product search and review-summarization system that processed 300,000 customer reviews and indexed 104,259 Amazon Office Products using TF-IDF and cosine similarity.

98.0% Hit@10 92.45% MRR@10 104K+ products
View project →
Business Analytics · NLP
ChatGPT vs. DeepSeek User Sentiment & Product Strategy

Analyzed approximately 843,000 public social-media and app-review records in a five-person team using sentiment lexicons, statistical tests, K-means, PCA, and time-series analysis.

843K records 12.9% vs. 6.7% negative Product strategy
View project →
IEEE MLHMI 2024
BiLSTM Stock Forecasting & Dynamic Trading Strategy

Co-authored a peer-reviewed study comparing LSTM and BiLSTM forecasts across 11 stocks in 8 sectors, then evaluated a dynamic top-five portfolio across four rebalancing windows.

11 stocks · 8 sectors 4 rebalance windows IEEE-published
View project →