Shirley Sun

Shirley Sun Email and Phone Number

Data Analyst @ Nordstrom|M.S. @ Northwestern University|B.A. @ Peking University @ Nordstrom
seattle, washington, united states
Shirley Sun's Location
Chicago, Illinois, United States, United States
About Shirley Sun

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.

Shirley Sun's Current Company Details
Nordstrom

Nordstrom

View
Data Analyst @ Nordstrom|M.S. @ Northwestern University|B.A. @ Peking University
seattle, washington, united states
Website:
nordstrom.com
Employees:
37365
Shirley Sun Work Experience Details
  • Nordstrom
    Data Analyst
    Nordstrom Dec 2023 - Present
    Chicago, Illinois, United States
  • Toho Technology
    Market Research Analyst
    Toho Technology Sep 2023 - Oct 2023
    Chicago, Illinois, United States
    Conducted independent market research to discover the opportunities of introducing surgical devices into the US market.
  • Chrisad
    Data Analytics Consultant
    Chrisad Jun 2023 - Aug 2023
    Corte 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
  • Medill Spiegel Research Center
    Graduate Research Assistant
    Medill Spiegel Research Center Mar 2023 - Aug 2023
    Evanston, Illinois, United States
  • Unilever
    Marketing Analyst - Brand Building
    Unilever Jul 2021 - Aug 2021
    Shanghai, 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
  • Nielsen
    Consumer Insight Analyst - Consumer Packaged Goods
    Nielsen Jan 2021 - Mar 2021
    Beijing, 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
  • Ogilvy China 奥美中国
    Public Relations Account Executive - Technology And Health Bu
    Ogilvy China 奥美中国 Apr 2020 - Aug 2020
    Beijing, 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

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, Wa
    4
    hotmail.com, coupang.com, coupang.com, microsoft.com
  • Shirley S.

    Solopreneur (Coaching, Consulting, Advising) | Ex-Fb, Ex-Apple, Ex-Roku
    Saratoga, Ca
    7
    facebook.com, gmail.com, gmail.com, roku.com, apple.com, apple.com, fb.com

    2 +1.650.XXXXXXXX

  • Shirley Sun

    Senior Software Developer At Hra, The City Of New York Goveronment
    Great Neck, Ny
    1
    gmail.com
  • Shirley Sun

    San Francisco Bay Area
    2
    uber.com, owllabs.com

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.