Developed and managed analytics system and service (logging, pipelines, datasets, dashboards, API) for Messaging Ads to supervise key metric movement, reveal growth opportunities, enrich machine learning feature store, and facilitate business reporting
Sample Daily Jobs:
•Led the team’s data strategy and build data warehouse & ETL solution
•Logged user activities via React and Php; Ingested the data from message queue to Hive tables
•Built data pipelines to compute KPI metrics, and visualize them on dashboards
•Worked as a part-time data scientist and performed market analysis for new products
•Built data pipelines to supply potential customers to Eng team and achieve product wins
•Built Python application to automate the analytics process
Sample Projects:
“Click to Message” Ads Product Analytics System - Built out the data analytics infrastructure (logging, pipelines, datasets, dashboards) for 5 advertisement products to provide daily and real-time insights into product performance and business KPIs.
Auto Root-Cause Analysis Tool for Consumer Metric Spike (winner of 2020 FB AI Hackathon) – Built an analytics feature in FB anomaly detection tool to automatically analyze unusual spike/drop of KPI metrics, and suggest “root-cause” based on a predictive model. The feature was adopted by FB’s biggest user profile data mart (1,600+ downstream users), successfully calling out metric spikes due to country-level events, and helping engineers save 30% time on metric movement debugging
Messaging Ads Data Warehouse Optimization – Redesigned the whole data warehouse by stopping unused pipelines, normalizing duplicate tables, and improving query efficiency to cut CPU and storage costs by 70%+