Built BI systems and analytical frameworks to support decisions across marketing, product, and e-commerce.
Built end-to-end BI dashboards and metric frameworks for paid media analysis, covering the full funnel from impression to click, add-to-cart, and payment, improving campaign monitoring, attribution, and review efficiency.
Designed and implemented a workforce analytics solution using Python and Feishu OpenAPI, automating data collection, cleaning, and budget-vs-actual labor analysis to improve resource planning accuracy.
Developed funnel analysis for cloud storage incentives, tracking exposure, claim, retention, and payment to identify conversion bottlenecks and support incentive strategy optimization.
Built the data infrastructure for a new drone business from 0 to 1, covering serial-level logistics and activation tracking, revenue and attach-rate analysis, real-time sales monitoring, market exposure, and after-sales dashboards.
Advertising & Growth Analytics, Ads Team
Supported paid media growth through attribution analysis, campaign optimization, and reporting automation.
Built monitoring and attribution frameworks for TikTok campaigns across creatives, audience segments, and budget allocation, helping increase ROI from 6 to 10+ and drive 290% revenue growth.
Partnered with product, operations, and engineering teams to build the advertising funnel for the cloud storage app from scratch, defining conversion paths, tracking logic, budget allocation, and reporting structure.
Led analytics support for Black Friday and Christmas campaigns by rebuilding the tracking framework and creating automated dashboards for daily monitoring, anomaly detection, and performance review.
Standardized weekly reporting workflows and automated creator ad naming conventions, improving attribution consistency and reducing manual effort by 80%.
Beijing Xiaomi Technology Co., Ltd
Internship, Investor Relations Specialist Assisted in daily operations of Xiaomi’s Investor Relations Department.
Assisted in producing a detailed comparative company research report on Transsion, where I analyzed complex issues related to the company’s financial performance and industry competition using data analysis.
Developed comprehensive report and presentation materials focusing on the electric vehicle industry, encompassing an in-depth analysis of the primary product development cycles of leading companies in the electric vehicle sector.
Tracked analyst expectations, quarterly performance, and operational status of various comparable companies. Contributed to the production of Xiaomi’s quarterly reports.