Migrated MongoDB to a centralized data warehouse on Oracle Cloud and built cross-database synchronization for seamless data

Engineered CSORE, a profitability composite indicator synthesizing peer group metrics and financial indicators reflecting company

Applied NLP (prompt engineering, few-shot learning with GPT-4o, FinBERT) to extract evasiveness/bullishness/sentiment from

Preprocessed data (Pandas) and applied regression models (linear regression, decision tree, XGBoost) to remove outliers, enhancing

Evaluated various Time Series Models (ARIMA, LSTM.) to predict traffic trends and choose promising video types for traffic allocation.

Managed data (SQL) and built dashboards (Tableau) delivering market trend insights and performance benchmarks for 10+ clients.

Held an office hour twice a week to assist students in learning algorithms and concepts of database systems and to answer students’ questions in SQL and database design projects

Analyzed 7M shopping records from 44k users on Taobao to identify key behaviors driving customer retention.

Presented retention insights and actionable recommendations to high-level stakeholders, improving decision-making.