• Conducted sentiment analysis and built a model using Natural Language Processing to analyze text reviews independent of the star ratings to calculate polarity scores (NLTK).• Designed and implemented a loyalty program with a personalized recommendation system, utilizing collaborative filtering to generate personalized product recommendations.• Developed and implemented a topic modeling technique using Non-negative Matrix Factorization to analyze text reviews, resulting in the identification of key themes and topics present in the data.• Developed and integrated an RPA algorithm using AWS Lambda, Amazon SageMaker, and AWS Step Functions to generate personalized emails. Improved the efficiency and effectiveness of email marketing campaigns for the customer loyalty program.

• Conducted market research on “Private Traffic”. Became the first intern to hold the sharing meeting in the company.• Utilized SQL and Tableau for performance analysis, identified top-performing sales and engagement channels, and provided strategic insights for future marketing strategies.• Participated in planning the “upgrade” transformation of Xiabu Catering Management Company (XIAXF). Conducted Key Opinion Leader performance and created detailed Tableau dashboards to monitor influencer campaign’s earned media values, engagements, and impressions. The campaign received 210K views and 2K interactions and gained 7.6K followers.

• Researched the top 10 competitors for clients by evaluating metrics such as customer demographics, marketing strategies, social media performance and financial reports to assess profits brought by social platforms. Created reports and presentations that highlight actionable insights for the management team.• Generated weekly Power BI dashboards to monitor advertising performance and reported insights to the director on recommendations on bidding, targeting regions, budget allocations, etc. and adjusted strategies accordingly.