Olivia L.

Olivia l.

bookmark on deepenrich
location of Olivia L.New York, New York, United States
Followers of Olivia L.1000 followers
  • Timeline

  • About me

    Sr. Data Analyst | L’Oréal, ex-3M | SQL, Python, R, Tableau, Looker | Marketing Analytics | eCommerce, CPG, Healthcare | Northwestern |

  • Education

    • 國立政治大學

      2013 - 2016
      Bachelor of laws - llb law
    • 國立政治大學

      2012 - 2016
      Bachelor of business administration (b.b.a.) minor in law

      • Leadership: Public Relations Chair of Business Administration Student Association

    • Northwestern university

      2021 - 2022
      Master of science - ms integrated marketing communications, concentration in data analytics

      • Concentration: Data Analytics, Brand Strategy• Leadership: Team Lead of Graduate Consultant of Northwestern IMC Cause Marketing Initiative (CMI).CMI is a student-led consulting group providing pro-bono marketing support and business strategic solutions to Chicago-based NPOs.Data-related Client Projects:• Modeling & Forecasting User Usage Time, Kakao (South Korean social media platform)• Customer Churn Prediction, US Media Subscription Service• Market… Show more • Concentration: Data Analytics, Brand Strategy• Leadership: Team Lead of Graduate Consultant of Northwestern IMC Cause Marketing Initiative (CMI).CMI is a student-led consulting group providing pro-bono marketing support and business strategic solutions to Chicago-based NPOs.Data-related Client Projects:• Modeling & Forecasting User Usage Time, Kakao (South Korean social media platform)• Customer Churn Prediction, US Media Subscription Service• Market Segmentation, US Cereal Market• Data Analysis and Strategy Planning, Cooper's Hawk Winery• Consumer Insight & Qualitative Research, Whole Foods Show less

  • Experience

    • Taiwan excellence brand association

      Jun 2015 - Jan 2016
      Market research intern

      Taiwan Excellence Brand Association (TEBA) is a non-profit association established by Taiwanese companies to build and promote Taiwanese brands to compete in the global marketplace.• Key Accomplishments: - Synthesized and analyzed quantitative and qualitative data to find market trends and provide in-depth reports and case studies for 10k+ managers in Taiwan - Held 6 business training courses for Taiwanese small-and-medium-sized enterprises to offer innovative ideas and to help promote Taiwanese brands Show less

    • Ami

      Jul 2017 - Jun 2018
      Project manager- hewlett packard account

      As the Project Manager of Hewlett-Packard Account, the largest department of AMI, I collaborated closely with customers and vendors including ODMs, OEM and 3rd parties such as Intel and AMD, to fix issues and prioritized the resources to accomplish key milestones on time and within budget.American Megatrends is the World’s Largest BIOS firmware vendorKey Accomplishments:- Directed a 20-person Engineering team through business desktop BIOS project cycles, including design, development, and validation, securing HP as the company’s largest account- Managed 40+ projects with the largest clients (HP, 6 ODMs) and cross-functional teams by identifying scopes and priorities, consistently achieving on-time and on-budget completion Show less

    • Lotte wellfood

      Nov 2018 - Mar 2020
      Brand manager- koala's march

      As the Brand Manager of Koala’s March, the # 1 Lotte brand, I developed and tracked the performance metrics of marketing campaigns across Japanese HQ, Thai factory, and Taiwanese office teams. Lotte is the 1st Confectionery Company in Asia; Top 5 Largest Corporation in Korea.• Key Accomplishments: - Conducted social media analysis and devised targeted strategies based on user demographics, increasing YoY engagement by 163% and YoY Facebook impression by 180% - Leveraged market research to propose rebranding initiatives and go-to-market strategies at Tokyo headquarters as #1 local market, incorporated in global product marketing strategy - Led Koala’s March (#1 Lotte brand) integrated marketing campaigns including but not limited to market research, product positioning, and media planning, generating 6% YoY sales growth Show less

    • Shopee

      May 2020 - Mar 2021
      Data analyst, marketing analytics

      As a Data Analyst under the Marketing Campaign Team, I developed cross-industry marketing campaigns for the annual largest regional shopping festivals, tracked campaign performance, and conducted A/B testing to optimize the user experience and increase sales.Shopee is the Top1 eCommerce platform in Greater Southeast Asia and Taiwan, an NYSE-listed startup.• Key Accomplishments: - Defined campaign performance metrics and conducted A/B testing on 12.12 Premium Day to optimize the customer journey, increasing product visibility by 5X and sales by 6X - Developed integrated marketing campaigns and user acquisition strategies for the largest regional shopping festivals($395M), overachieving 120% of order target - Cooperated with Business Intelligence team to perform user trend analysis and identify the fastest-growing segment using Python, proposing user retention plans that generated $300M sales revenue - Designed segmentation method of 14M customers based on views and purchasing behavior data to retain users; achieving conversion rate uplift by 290% Show less

    • Northwestern university medill school

      Sept 2021 - Dec 2022
      Ms candidate of integrated marketing communications (stem)

      Recipient of Northwestern University Medill Scholarship• Concentration: Data Analytics, coursework including Marketing Models, Data Visualization, Statistics & Marketing Research, Machine Learning, Data Management• Leadership: Team Lead of Graduate Consultant of Northwestern IMC Cause Marketing Initiative (CMI).

    • Inspiration corporation

      Mar 2022 - Jun 2022
      Team lead, marketing analyst consultant | northwestern cause marketing initiative (cmi)

      Selected as the Project Team Lead, I liaised between the team and Inspiration Corporation, managed the project, and developed digital marketing recommendations based on social media analytics.Cause Marketing Initiative (CMI) is a Northwestern student-led consulting group providing strategic marketing solutions to Chicago-based NPOs.- Client: Inspiration Corporation, a nonprofit offering food, housing, and job training to Chicagoans experiencing homelessness and poverty.• Key Accomplishments: - Analyzed social media data, including analytics from Instagram, Facebook, and LinkedIn, and the website to define the target audience and developed cross-platform strategies to drive traffic - Conducted decile analysis and RFM model to explore and target the most valuable donors to find improvement to grow Show less

    • 3m

      Jun 2022 - Aug 2022
      Data analytics & strategy consultant

      As a Data Analytics Consultant, I analyzed Salesforce data and conducted segmentation analysis to uncover market opportunities at 3M. - Analyzed sales data for Industrial Tapes to uncover market growth opportunities for $700M categories, recommended business priorities that drive estimated $23M sales revenue - Developed scalable, automated machine learning models by synthesizing complex datasets into insightful reporting and visualization dashboards (SQL, Tableau) - Collaborated with 7 Business and Sales teams to extract, clean and transform Salesforce data (SQL, R, Tableau) to facilitate cluster analysis methodologies (Latent Class Analysis)- Identified high-growth markets by applying machine learning models (unsupervised) and designed sales activation plans, projecting sales revenue increase by 12% in two years Show less

    • Northshore care supply

      Feb 2023 - Dec 2023
      Senior data analyst

      As a Senior Data Analyst, I supported the health and growth of the core E-Commerce business by analyzing data to identify trends, discover opportunities, and present recommendations that will drive valuable business growth.NorthShore is an eCommerce leader in healthcare products such as high-absorbency adult diapers and bladder control pads since 2002. They have helped over 2.5 million individuals managing incontinence, their loved ones, and caregivers.• Defined key metrics and partnered with engineers and offshore teams to develop data pipelines for customer loyalty program, increasing 10% in customer acquisition • Analyzed checkout funnel data (Google Analytics, Tealeaf) and proposed website renewal strategy, achieving a 20% reduction in bounce rate by enhancing user experience• Developed automated reporting and dashboards (ETL, SQL, Looker Studio, Domo) to effectively communicate data-driven insights to non-technical audiences, saving time by 10% Show less

    • L'oréal

      Feb 2024 - now
      Data analyst, global e-comm & crm (kiehl’s)

      • Led and developed dashboards (Tableau, PowerBI, Domo) for global eCommerce and CRM data on customer acquisition and retention across 46+ markets• Leveraged analytics to drive customer-centric recommendations and maximize opportunities by integrating insights from multiple data sources, supporting multi-channel strategies

  • Licenses & Certifications

  • Volunteer Experience

    • WiDS Ambassador, Chicago

      Issued by Women in Data Science (WiDS) Worldwide on Nov 2022
      Women in Data Science (WiDS) WorldwideAssociated with Olivia L.
    • Elementary School Tutor

      Issued by Book & Breakfast on Apr 2022
      Book & BreakfastAssociated with Olivia L.
    • Project Team Lead

      Issued by Inspiration Corporation on Mar 2022
      Inspiration CorporationAssociated with Olivia L.
    • Attache of Delegation of Brazil

      Issued by Summer Universiade Taipei 2017 Organizing Committee on May 2017
      Summer Universiade Taipei 2017 Organizing CommitteeAssociated with Olivia L.
    • Voluntary

      Issued by Waker International Volunteer on Jul 2013
      Waker International VolunteerAssociated with Olivia L.