Validated schema on 5M+ transaction and engagement records from Salesforce and e-commerce platforms using PySpark on AWS EC2; built STAR schema consumer database partitioned by region and product category to enable scalable reporting. Segmented 1M+ order and behavioral data via RFM scoring; classified products into revenue tiers using Amazon Athena SQL; applied KNN imputation for missing attributes and deployed an Isolation Forest to flag anomalies in daily purchase behavior. Built 10+ Power BI dashboards with DAX scoring and anomaly alerts to monitor KPIs (e.g., CLV, UPT) and product margins; automated weekly Excel reports using Python and Databricks.

Strategy Consultant Intern at EY-Parthenon

January 1, 2024 - January 1, 2024

Developed go-to-market strategies for dairy innovation by applying marketing mix modeling and multi-linear regression with SHAP value interpretation to assess the impact of price, placement, and promotions on consumer adoption; introduced retail strategies including flagship stores and O2O delivery to overcome taste barriers and drive cheese consumption. Conducted P&L analysis by modeling store-level unit economics and benchmarking top F&B retailers on business models and entry strategies. Automated Excel dashboards using PivotTables and macros to track CPM, CTR, and ROAS from B2C campaign logs; identified underperforming platforms and recommended geo-targeted segmentation to boost brand visibility and media ROI.

Strategy Analyst Intern at Zuoyebang

June 1, 2023 - June 1, 2023

Analyzed conversion funnels using SQL and Amplitude data, identifying a 40% drop-off at the cart-to-checkout transition. Performed cohort analysis by device type and region, revealing mobile latency and coupon application confusion as key drivers. Designed and executed A/B tests using Optimizely to test two redesigned checkout flows; monitored key metrics including conversion rate and bounce rate; conducted two-proportion z-tests in Python to validate a 4.2% uplift. Optimized version launched, driving a 10% increase in completed payments.