zeqiangfun

Built and optimized ETL pipelines integrating 4+ data sources; migrated 2+ core Hive tables to BigQuery, improving performance by 30% and processing efficiency by 50%. Automated column-level metadata scanning with BigQuery and Python, saving 3 person-days per request. Developed an API-based PII scanner under tight deadlines, which was adopted by 3 teams to ensure compliance.

Developed a daily-level traffic diagnostics tool and built a real-time analytics warehouse. It provided actionable insights to support 100+ internal users. Led backend development to increase module penetration by 15% by year-end. Migrated 9 content data modules to a new gateway service and added multi-period comparison features, enhancing data flexibility and statistical capabilities. Designed a unified data model with 33 public tables and 6 summary layers, supporting 9 business domains.