Chan Wei Wen

Experience

• 

  均一平台教育基金會 Junyi Academy

  Feb 2022 - Sept 2022

  Data Analyst intern

  - Analyzed millions of user data in the online education platform to get insight and maintain/optimize related dashboards.- Discovered four hundred thousand potential users by EDA and user segmentation.- Created a data visualization & data storytelling handbook which has 100+ example graphs.

• 

  WPG Holdings Limited 大聯大投資控股(股)公司

  Feb 2023 - now

  Data Engineer

  1. Databricks Performance & Cost Optimization1-1. Optimized Spark’s lazy evaluation, achieving a 40x performance boost in data processing.1-2. Optimized Databricks workflow configurations, leading to a 10x cost reduction.----2. GCP Data Pipeline Optimization.2-1. Migrated the GCP data pipeline architecture from ETL to ELT, orchestrating 300+ SQL scripts using Dataform from scratch.2-2. Reduced data latency from 24 hours to <1 hour, while cutting costs by 80%.Enhanced SQL efficiency, optimizing thousands of lines of SQL to reduce computation time from 50 minutes to 1 minute.----3. GA4 (Google Analytics 4) Data Pipeline & Dashboard Development3-1. Developed a scalable GA4 data pipeline, delivering real-time user insights to 100+ internal users.3-2. Built a recommendation system dashboard, leading to a 650% improvement in recommendation efficiency.3-3. Designed 20+ product-based dashboards, providing actionable insights to thousands of internal users. Show less