Business Analyst Intern

• Feb 2021 - Present

An AI-powered video interview prep platform based in NYC• Conduct Web Analysis using Google Analytics, visualize performance data via Google Data Studio - provide strategic insights based on website performance and audience behavior to increase conversion rate - deliver weekly Web Analysis presentation to PM and ENGN teams to optimize the operation and design of the website• Create 500+ event triggers via Google Tag Manager, set up tags for each event to track user… An AI-powered video interview prep platform based in NYC• Conduct Web Analysis using Google Analytics, visualize performance data via Google Data Studio - provide strategic insights based on website performance and audience behavior to increase conversion rate - deliver weekly Web Analysis presentation to PM and ENGN teams to optimize the operation and design of the website• Create 500+ event triggers via Google Tag Manager, set up tags for each event to track user behavior• Deliver competitor analysis using SimilarWeb, provide optimization insights based on search, referrals and audience interests• Manage Email promotion via MailChimp, deliver weekly email analysis based on performance and present to the Marketing team Show more Show less

Columbia Edx Course Assistant - Demand and Supply Analytics

• Feb 2021 - Present

Student Consultant - Marketing / Strategic Analyst

• Sep 2020 - Dec 2020

A middle eastern dessert startup based in New Jersey● Delivered cluster analysis using R for market segmentation, brand positioning and new product development- helped the brand repositioning to new customers outside the middle eastern group● Developed campaign and performance analysis using Google Analytics to achieve ROI target, provided strategic insights● Conducted trend analysis by using Google Trends & SEMrush based on key search terms, seasonality & geography of… A middle eastern dessert startup based in New Jersey● Delivered cluster analysis using R for market segmentation, brand positioning and new product development- helped the brand repositioning to new customers outside the middle eastern group● Developed campaign and performance analysis using Google Analytics to achieve ROI target, provided strategic insights● Conducted trend analysis by using Google Trends & SEMrush based on key search terms, seasonality & geography of search● Delivered A/B testing for 3 holiday display ads and optimized the advertising design Show more Show less

Marketing Analyst Intern

• May 2019 - Jul 2019

A Japanese 4A Advertising Agency● Conducted 3 Million RMB national spot planning and coordinated multi-channel campaigns for industry leading cosmetics groups such as Shiseido and NARS● Managed 5 media platforms allocation for clients, and made daily adjustments according to demographics, customer behavior, and conversion rate to meet customer ROI requirement● Conducted On-air report and Post-buy report for each campaign- analyzed customer behavior during each step of customer… A Japanese 4A Advertising Agency● Conducted 3 Million RMB national spot planning and coordinated multi-channel campaigns for industry leading cosmetics groups such as Shiseido and NARS● Managed 5 media platforms allocation for clients, and made daily adjustments according to demographics, customer behavior, and conversion rate to meet customer ROI requirement● Conducted On-air report and Post-buy report for each campaign- analyzed customer behavior during each step of customer journey mapping- deliver presentations to clients, carried out media analysis, evaluated metrics for website traffic effect, and delivered insights to improve marketing performance● Assisted creative team to deliver 30+ variations of competitive campaign showcase for each client Show more Show less

Operations and Transportation Analyst Intern

• May 2017 - Aug 2017

● Conducted transportation and performance analysis by using internal logistics systems (CNS, P3, like SQL) for domestic and international orders● Developed order inquiry template for 15 freight companies, made daily update covering 150k data points● Delivered cross-functional support for transport fleet team to handle emergencies like truck leakage, strike and cargo damage