Jiayue Fei Email & Phone Number

Shanghai, China

• Collaborated with different teams effectively and worked with famous social media influencers to select the list of products for the 6.18 Shopping Festival and achieved over $30 million sales in live stream in 18 days.
• Queried search keywords data using SQL, visualized data with wordcloud and used VLOOKUP to match related products, used social network analysis to select target customers; devised strategies for seasonal products.
• Managed competitors’ sales data, segment images and product price distribution using excel to summarize product trends on Tiktok and provide product analytic insights and marketing strategies from various dimensions.

Nanjing, Jiangsu, China

• Set automatic coupon distribution tasks to support daily promotion events and monthly super discount events, helped to reach $1.5 million sales; collected coupon usage rate using SQL to generate profit reports.
• Processed user data using SQL and analyzed customer return rate, designed customer satisfaction survey and collected over 1,000 responses, modified promotion strategies to decrease customer churn rate by 5%.
• Used A/B testing to evaluate promotion effects to evaluate the new customer registration effect of various promotional tools and adjusted promotional messages strategies to increase registration rate by 10% in 2 months.

Nanjing, Jiangsu, China

• Managed customer information using SQL and find customer segments using Python and clustering analysis.
• Designed and refined customer satisfaction surveys and analyzed more than 10,000 survey responses and provided survey reports on consumer insight monthly for the China branch and the US branch.
• Shortened time by 70% through designing an automatic process for filtering leads and sending promotion emails through company system and provided more than 2,000 hot leads for sales in the US and China regions weekly.

Master Of Science - Ms, Marketing Analytics, 3.98

Bachelor Of Science - Bs, Applied Chemistry, 3.78

Integrated Marketing Communications, 4.0

As an exchange student at Northwestern University studied Integrated Marketing Communications in a month and achieved a full A grade.