About

Work Experience

• Data Analyst, Apple

  Jun, 2020 - Dec, 20211 year 7 months

  • Built real-time detection for low-conversion pages using Spark and Snowflake; reduced response time to 5 mins and fix times to 4 hours, boosting sales conversion.

  • Streamlined user segmentation for personalized promotions with Spark, reducing processing time to 2 hours to support daily marketing activations.

  • Created Tableau dashboards with SQL models to visualize inventory turnover, leading to a 12% reduction in excess stock via data-driven replenishment.

  • Optimized large-order allocation using SQL to identify supply chain bottlenecks, ensuring stability during high-stakes product rollouts.

• Specialist, Apple

  May, 2018 - Jun, 20202 years 1 month

  • Applied K-means clustering to analyze sales imbalances; redesigned display strategies based on clusters, increasing Q1 units sold by 25%.

  • Developed time series models to forecast hourly traffic; designed Tableau dashboards to help managers optimize staff schedules and improve customer service ROI.

  • Applied ARIMA models to forecast stock shortages across 7+ stores, preventing over 2,000 potential stockouts through proactive inventory management.

  • Processed 200+ product return records using TF-IDF for keyword extraction and sentiment analysis to identify key user friction points.

Projects Experience

• Real-time Customer Behavior Data Processing

  - Present

  Implemented a stream processing system using Apache Flink to identify conversion funnel drop-offs; simulated A/B testing to evaluate UI changes on CTR.

• Housing Data ELT Pipeline & Analytics

  - Present

  Led end-to-end ELT pipeline development, reducing processing latency by 50% via dbt modeling and automated Airflow orchestration; ensured 100% data reliability.

Skills

Education