YL

Yuhan Li

Social Intelligence Analytics Intern · Ipsos


Work Experience

Social Intelligence Analytics Intern

Ipsos

2022 – 2022

Monitored 50k+ e-commerce reviews for 20 primary competing products of Philips across 5 categories consistently; leveraging text-mining and sentiment analysis to identify key insights into market response in monthly reports • Assessed online campaign performance for 16 competing brands of Philips through quantitative and qualitative analysis; consolidated insights into media strategies aimed at improving a 20% engagement rate • Conducted competitive research on small appliances, including key profitable features, product position, and innovation trends to bridge perception gaps, optimize differentiation marketing and prospect growth opportunities • Evaluated brand-enhancing effectiveness of product placement for Ford Territory on consumer & product dimensions through the integration and cross-analysis of 400+ questionnaires using Excel's pivot table and t-testing

Media Planner

Market Plan for Family Resiliency Center at UIUC

2021 – 2021

Targeted scholars and service providers on different platforms by devising annual social media strategy with a pulsing schedule, tracking online and offline communication channels, and tailoring content for different platforms • Optimized budget allocation through leveraging public resources including university newsletter and library digital display to reduce costs by 17% and to reach a greater target audience • Convened with the client on a regular basis to align the process with organization's goal and make timely adjustments; the final proposal was chosen by client among 7 competing groups for future implementation

TECHNICAL SKILLS & LANGUAGES Computer: MS Office; Adobe Photoshop & Lightroom; RStudio, Python (in-progress); Google Analytic; Canva Languages: English (Proficient), Mandarin Chinese (Native)

Account Executive Intern

Ogilvy

2021 – 2021

Orchestrated communication among co-organizers and vendors to assist in event implementation of the 2021 World Artificial Intelligence Conference for representatives from 300+ industry-leading companies and institutions • Oversaw the operation of the opening ceremony and 4 sub-forums by leading 12 volunteers to perform field control; formulated procedures to respond to unplanned circumstances, vacant seat relocation, and material distribution • Translated and proofread 7k+ words of external and internal documents for pharmaceutical client; aligned schedules and calibrated scripts with client and press release distribution platform; integrated follow-up media reports

Remember Their Voices (NGO) New York City, NY Part-time Social Media Creative Dec 2020 - Apr 2021 • Administrated day-to-day social media accounts management and executed highly engaging social media campaigns • Enhanced public awareness of underrated injustices against BIPOC and disadvantaged groups by updating social media 3 times a week with 3 different columns that share facts, concepts, and stories of historical figures • Researched and generated infographics via the Canva platform; published 20 Instagram and Facebook posts and obtained a 26% increase in engagement rate as well as over 120 new followers

ACADEMIC PROJECT

Education

Master of Science in Marketing Analytics

Johns Hopkins University Carey Business School

2023

Master of Science in Marketing Analytics

Bachelor of Science in Advertising

University of Illinois at Urbana-Champaign College of Media

2018 – 2021

Bachelor of Science in Advertising