Shu Miao
Marketing Analyst
Hire this person
Send a job offer directly to this candidate
About
Actively seeking for an opportunity of Marketing Analyst, currently a graduate student at Washu
Experience
Shanghai Kaytune, Shanghai, China Data Analysis Intern
June 2022 - August 2022
December 2024
May 2023
Led seven successful marketing campaigns of summarizing and promoting of brand on JD and Taobao platforms by leveraging historical strategies and sales information.
Conducted comprehensive analysis of new products in the market, including competitor analysis, user profiling, and product evaluation, using data analysis skills with business visualization techniques in Excel, including VLOOKUP and pivot table, to extract insights and inform marketing strategies.
Analyzed conversion rates and market share in comparison to competitors, utilizing analytics dashboard design skills in machine learning to present key performance metrics to stakeholders.
Researched market penetration rates and trends across Europe and Asia to gain insights into market dynamics, combining data analysis and visualization skills to identify strategic opportunities.
Explored the relationship between brand search demand and conversion rates through product sales analysis, employing SQL to clean and analyze user data on various advertising channels and thus made insight about next year's marketing strategy.
Rapidamic LLC, Remote February 2021 – August 2021 Operational Assistant
Helped promote and operate the company's official social media account by composing promotional articles for the official account and editing video clips.
Proficiently imported Excel data into SQL to enhance efficiency in managing students, including removing duplicates, handling missing values, and performing format conversions, which reduce manual operations and errors.
Education
EDUCATION
WASHINGTON UNIVERSITY IN ST LOUIS, OLIN BUSINESS SCHOOL,St. Louis, MO Master of Science in Business Analytics - Customer Analytics (STEM with 3 years OPT)
- Relevant courses: Database Design and SQL, Data Science and Python, Machine Learning.
University of Nottingham,Ningbo, China (one semester in UK)
Bachelor of Science in FAM (Finance, Management, Accounting)
- Relevant courses: Database Design and Implementation, Computer Science, Quantitative Methods, Econometrics.
