• Research & Strategy: Led a marketing campaign for a video game, conducted 20+ competitor and consumer analyses, and developed a strategic marketing roadmap with goals, strategies, key activities, and timelines for each phase.• PPC Marketing: Optimized Google and Facebook ad campaigns using Google Ads and Meta Ads Manager by conducting A/B tests on ad images and analyzing KPIs like CPC, CTR, and conversion rates.• Email Marketing: Designed automated email customer journeys using Mailchimp to send personalized welcome and monthly update emails to thousands of subscribers.• Website Development: Developed the product website using WordPress and leveraged Google Analytics 4 tracking and heatmap analysis to optimize website content and enhance user experience.• Social Media Management: Managed YouTube, Facebook, X, Instagram, and TikTok accounts using Buffer. Created content calendars, produced videos, engaged with audiences, and conducted data analysis to optimize posting strategies.

• Data Analysis Using SQL & Tableau: Engineered a MySQL database by extracting data from 11 tables, executed 8 advanced SQL queries using subqueries, CTEs and window functions, developed a Tableau dashboard with 6 key visualizations, including box plots and bubble charts, offering actionable insights such as reallocating resources towards top-performing influencers, increasing their average performance by 21%. • Integrated Event Marketing: Orchestrated a pop-up store campaign in partnership with a renowned luxury brand, implementing an integrated marketing strategy that combined online and offline channels. Leveraged influencers visiting the store as the key topic for social media, while driving online users to the store through a UGC contest on TikTok, resulting in $80K profit and 60 million social media impressions.

• Data Analysis Using Excel: Analyzed data from 4 competitors using advanced functions like VLOOKUP and SUMIFS. Created 20+ pivot tables and graphs to deliver insights on content types, episode lengths, etc., for an original podcast, contributing to 3 million play counts.• Market Research: Spearheaded a survey with 857 responses, 6 in-depth interviews, and a focus group discussion to gather consumer insights for the M-Pet program, which integrates music experiences with virtual pets, achieving 20,000 users and 70,000 social media impressions.