Shirley Sun Email and Phone Number
Hello! I’m an enthusiastic marketer and an active learner currently pursuing the master’s degree of Full-time IMC at Northwestern University, on segmented tracks of data analytics and media. I graduated from Peking University with a major in Japanese Studies, during which I also studied Macro/Micro Economics, Communication Research Methods and Financial Accounting.I’m deeply interested in Marketing Analytics and Data Storytelling, which is my main focus at the IMC program.
Nordstrom
View- Website:
- nordstrom.com
- Employees:
- 37365
-
Data AnalystNordstrom Dec 2023 - PresentChicago, Illinois, United States -
Market Research AnalystToho Technology Sep 2023 - Oct 2023Chicago, Illinois, United StatesConducted independent market research to discover the opportunities of introducing surgical devices into the US market. -
Data Analytics ConsultantChrisad Jun 2023 - Aug 2023Corte Madera, California, United States• Customer Analysis: Designed and distributed survey for dentist entrepreneurs to 800+ clients regarding factors impacting customers’ priorities and preferences on dental practices, willingness to pay and refer, and public dental care and insurance status, to better understand target customers mindset, derive consumer behavior insight and discover opportunities to increase revenue. • Industry Research: Researched job satisfaction and benefit offerings in the dental care industry… Show more • Customer Analysis: Designed and distributed survey for dentist entrepreneurs to 800+ clients regarding factors impacting customers’ priorities and preferences on dental practices, willingness to pay and refer, and public dental care and insurance status, to better understand target customers mindset, derive consumer behavior insight and discover opportunities to increase revenue. • Industry Research: Researched job satisfaction and benefit offerings in the dental care industry qualitatively by occupation and clinic size in literature review and quantitatively with syndicated data analysis sourced from the Bureau of Labor Statistics• Data Processing: Cleaned and processed 800+ survey results by dropping unqualified data and fixing structural errors in SQL • EDA: Performed exploratory data analysis to discover distributions and correlations of customer pain points regarding demographics such as region and income level with pivot table in Excel and regression models of average spendings on deductible amount in R• Financial Modeling: Constructed a profitability model that tests growth rate and hiring hygienists based on workforce cost, billable hours, fringe benefits, and treatment type to simulate dentistry ROI • Business Strategy: Participated in strategic planning for solo-owned clinics, dentist-facing survey data analysis regarding compensation, and competitor analysis against corporate clinics to decrease the hygienist turnover rate and achieve business growth• Sentiment Analysis: Crawled comments from 50+ webpages on Yelp and Google map regarding dental services by region using Octoparse and performed sentiment analysis by identifying keywords into 6 categories and visualized frequency by Adobe Design Show less -
Graduate Research AssistantMedill Spiegel Research Center Mar 2023 - Aug 2023Evanston, Illinois, United States -
Marketing Analyst - Brand BuildingUnilever Jul 2021 - Aug 2021Shanghai, China• Marketing Campaign: Developed and implemented Q3 social media marketing plan for the LUX LEAP product line, including establishing a seeding calendar, cooperating with influencer marketers, and defining budgeting plans across social media platforms• Budgeting Allocation: Allocated $10,000 budget into 4 social platforms through assessing historical performance data by platform and seasonality, comparing influencers’ price and conversion rate in Excel, resulting in a quarterly ROAS of 2.7… Show more • Marketing Campaign: Developed and implemented Q3 social media marketing plan for the LUX LEAP product line, including establishing a seeding calendar, cooperating with influencer marketers, and defining budgeting plans across social media platforms• Budgeting Allocation: Allocated $10,000 budget into 4 social platforms through assessing historical performance data by platform and seasonality, comparing influencers’ price and conversion rate in Excel, resulting in a quarterly ROAS of 2.7 • Product Management: Led product launch event for hair serum which obtained an ROI of 5.0 through researching target demographic needs, product durability in competitive analysis, and conducting clientele demonstrations• Market Analysis: Compared competitor brands in the product matrix regarding sales trends, market share, target consumers, branding strategies, and social media campaigns to help LUX position new products within strategic competitive niches• A/B Testing: Conducted A/B testing experimental design that tests sponsored content at different times of day at the same platform facing over 10,000 followers to optimize budgeting and ROI Show less -
Consumer Insight Analyst - Consumer Packaged GoodsNielsen Jan 2021 - Mar 2021Beijing, China● Project Management: Assisted in managing the market research project for RELX e-cigarettes by conducting desk research, writing pitch proposal, setting the project calendar, creating a roadmap and milestone, and deploying team staff● Quantitative Analysis: Developed experimental design for differentiated brand image promotion, utilized SQL and Excel functions such as VLOOKUP for quantitative marketing analysis, and visualized questionnaire results to motivate brand position… Show more ● Project Management: Assisted in managing the market research project for RELX e-cigarettes by conducting desk research, writing pitch proposal, setting the project calendar, creating a roadmap and milestone, and deploying team staff● Quantitative Analysis: Developed experimental design for differentiated brand image promotion, utilized SQL and Excel functions such as VLOOKUP for quantitative marketing analysis, and visualized questionnaire results to motivate brand position monitoring● Dashboard Development: Customized an interactive dashboard using PowerBI with connection to dataset API for automated update by month, and added filters by time hierarchy and region hierarchy to improve user experience, as well as features to show the top-ranking customers’ information to monitor KPI trends and identify high-value customers for stakeholders Show less -
Public Relations Account Executive - Technology And Health BuOgilvy China 奥美中国 Apr 2020 - Aug 2020Beijing, China-Localized global announcements and selected media, based on manuscript types and needs of clientele, to report and amplify, resulting in average exposure of 70% out of Intel’s core 50 media for regular press releases per time.-Proposed topics and guests for industry conversation on neuromorphic technology based on industry studies; assisted in identifying possibilities for media engagement on Douyin App through collective data analysis; led clientele revising the advertisement strategy and… Show more -Localized global announcements and selected media, based on manuscript types and needs of clientele, to report and amplify, resulting in average exposure of 70% out of Intel’s core 50 media for regular press releases per time.-Proposed topics and guests for industry conversation on neuromorphic technology based on industry studies; assisted in identifying possibilities for media engagement on Douyin App through collective data analysis; led clientele revising the advertisement strategy and starting to adopt Douyin as new media channel.-Monitored competitors’ media communication of progress on technology frontier; wrote weekly reports.-Assisted in establishment and maintenance of relationship with influential reporters on Intel’s core media list along with industrial analysts; helped shape perceptions of Intel as an innovator with technology leadership. Show less
Shirley Sun Education Details
-
3.9/4.0 (To Date) -
3.7/4.0
Frequently Asked Questions about Shirley Sun
What company does Shirley Sun work for?
Shirley Sun works for Nordstrom
What is Shirley Sun's role at the current company?
Shirley Sun's current role is Data Analyst @ Nordstrom|M.S. @ Northwestern University|B.A. @ Peking University.
What schools did Shirley Sun attend?
Shirley Sun attended Northwestern University, Peking University.
Who are Shirley Sun's colleagues?
Shirley Sun's colleagues are Shanae Reyes, Brandon Postlethwait, Natalie Walker, Crystal Bassey, Ronald Weintraub, Joseph Sherman, Monica Kirnak.
Not the Shirley Sun you were looking for?
-
Shirley Sun
Sammamish, Wa4hotmail.com, coupang.com, coupang.com, microsoft.com -
7facebook.com, gmail.com, gmail.com, roku.com, apple.com, apple.com, fb.com
2 +1.650.XXXXXXXX
-
1gmail.com
-
Shirley Sun
San Francisco Bay Area2uber.com, owllabs.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial