Advised multiple Fortune 500 Grocery clients (Hershey, Kraft Heinz, etc.) on their marketing and media strategy by analyzing Amazon’s internal data using SQL & Python; applied machine learning on data and led design and execution of campaign A/B tests to develop actionable insights；Collaboration with various teams such as account, experimentation, PR, legal teams and contributed to over $20M investment opportunities in half a year;Developed churned customers analysis narrative for brands understanding shopping behavior of their churned customers, churn rate trend, and high churn rate products;

Conducted solid market research on the D2C market and pet care industry for Purina's MyFancyFeast D2C platform; Identified business development strategies for market growth using data-driven insights; Produced 50+ pages slide and presented to the CMO of Purina

•Analyzed data for 300 million users from the company database and cooperated with tech and operation teams to deliver campaign suggestions in Xiaohongshu platform (an Instagram-like social media platform in China) for clients•Aggregated and visualized advertising data with SQL and Tableau for 8 clients, assessed the effect of advertisements, and enhanced client's advertising strategy; Executed comprehensive analysis of client's previous campaigns, current trends, and competitor strategies through different metrics, and offered insights for its marketing strategy•Enhanced average advertisement click-through rate (CTR) for nearly 15%; Help clients understand the key metrics fluctuation; Generated client's 2021 trend report on Xiaohongshu platform and campaign plan for client's new-launch products

•Provided resolution for the start-up company Kit.com (an at-home medical service provider) to increase its customer conversion rate.•Compared pros and cons of Kit.com with other companies in the same industry from digital marketing strategies make suggestions on operations of social media, package designing and optimizing user journey.•Cooperated with other 5 team members to have weekly meetings with the project leader and presented our result to the company CEO.

•Collected and assessed performance data of over 10 online projects from 4 categories (webinar, content page, push message, retail). Created corresponding dashboard for the first time in the company using Tableau and gained insights by analyzing those projects from 3 dimensions (reach, interaction, action); Increased average CTR by 10%•Cleaned the company's online access data and more than 200,000 pieces of data are processed through Excel every month. Visualized the data by Excel and provided reports to the marketing department and management team to improve users' experience

•Conducted research on Game & Entertainment and E-commerce industries and wrote reports in English for clients•Designed and distributed questionnaires for an E-commerce electronic company through multifactor analysis including user profile, performance of online & offline stores and comparison with its commercial rivals•Processed the questionnaire results using Excel and found the consumption preference correlation between the mobile phone and other smart appliances•Analyzed the questionnaire results produced slides for an oral presentation in the group meeting. Shared learnings about making questionnaires with other team members