1. Conducted monthly and quarterly user sentiment analysis for 20-30 product brands for operation and product departments to improve marketing strategy, by collecting 300-400 users’ feedback with research survey, analyzing user data and compiling research findings into key brand health metrics such as NPS, CSAT, BA2. Produced an annual industry report to share top 120 trending makeup and skincare brands in China, by extracting both internal and external sales data, uncovering new dimensions for analysis based on data trends, and performing multi-dimensional comparative analysis to conclude brand profitability3. Ran ad-hoc analyst duties such as brand exposure analysis on social media platforms (Tiktok, Xiaohongshu and Weibo) using search tag distributions, and user portrait analysis on 6 brands of YATSEN

1. Delivered data analysis support to identify performance gaps, produce improvement suggestions, andimplement new processes, for Xunni, a social dating platform for seniors with over 30,000 users2. Produced daily user activity reporting pipeline, identified abnormal metrics such as DAU, ARRPU, CRR using SQL, Excel Pivot-Table and Tableau, dissected user types and located source problems, optimizing user experience with about 1000 DAU increase and 3% growth in new user weekly retention rate3. Provided competitive product analysis for product enhancement and proposed adding recommendation and matching function in home page, raising the overall weekly video rate by about 5% in the new version

1. Presented valuation assessment of an AI solution provider with over 10 pages slides according to thecollection and analysis of its profits, costs, personnel structure and other data from the prospectus2. Supported industry research in knowledge management field; Predicted the market size of AI Knowledge Graph industry through gathering data from wind/other websites and building analysis model, creating 5 pages slides of core conclusions and model structures