Software Engineer · Backend & Frontend
@ TikTok
Apr 2024 — Present
Singapore
Building high-scale query infrastructure and data products at TikTok. I improved the realtime user segmentation system to sustain over 2M peak QPS at approximately 30ms P99 with over 99.99% SLA, re-architected Hive-to-ClickHouse loading to reduce data readiness time by 73%, and designed a multi-region on-demand pipeline for cohort-level Creator Analysis with 30%+ user penetration.
- Sustained over 2M peak QPS at approximately 30ms P99 with over 99.99% SLA by optimizing realtime user segmentation system cache access patterns.
- Reduced data readiness time by 73% (5.5 hours → 1.5 hours) by re-architecting Hive-to-ClickHouse data loading.
- Designed and built a multi-region, on-demand data pipeline for cohort-level Creator Analysis, reaching 30%+ user penetration.
- Expanded Data Suite query capabilities with a visualization engine supporting direct ClickHouse queries and configurable virtual columns.