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

國立政治大學
2013 - 2016Bachelor of laws - llb law
國立政治大學
2012 - 2016Bachelor of business administration (b.b.a.) minor in law• Leadership: Public Relations Chair of Business Administration Student Association

Northwestern university
2021 - 2022Master 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 2016Market research internTaiwan 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 2018Project manager- hewlett packard accountAs 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 2020Brand manager- koala's marchAs 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 2021Data analyst, marketing analyticsAs 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 2022Ms 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 2022Team 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 2022Data analytics & strategy consultantAs 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 2023Senior data analystAs 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 - nowData 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
- View certificate

Solve real-world data problems with sql
LinkedinJan 2024 - View certificate

Data manipulation in sql
DatacampDec 2022 - View certificate

Programming for everybody (getting started with python)
CourseraJul 2021 - View certificate

Introduction to r
DatacampApr 2022 - View certificate

Introduction to power bi
DatacampDec 2023 
Google adwords
Google adwords certifiedJan 2016- View certificate

Introduction to sql
DatacampJan 2022 - View certificate

Joining data in sql
DatacampMay 2022 - View certificate

Intermediate sql
Datacamp - View certificate

Master of science in integrated marketing communications
Northwestern university medill schoolDec 2022 - View certificate

Postgresql summary stats and window functions
DatacampNov 2022 - View certificate

Intermediate sql
DatacampJan 2023
Volunteer Experience
WiDS Ambassador, Chicago
Issued by Women in Data Science (WiDS) Worldwide on Nov 2022
Associated with Olivia L.Elementary School Tutor
Issued by Book & Breakfast on Apr 2022
Associated with Olivia L.Project Team Lead
Issued by Inspiration Corporation on Mar 2022
Associated with Olivia L.Attache of Delegation of Brazil
Issued by Summer Universiade Taipei 2017 Organizing Committee on May 2017
Associated with Olivia L.Voluntary
Issued by Waker International Volunteer on Jul 2013
Associated with Olivia L.
Languages
- enEnglish
- geGerman
- maMandarin chinese
Recommendations

Charudatta vibhandik
Design Engineer | Solidworks | CSWP | Specialist Visualize | Passionate About Precision, Functionali...Pune, Maharashtra, India
Angelica reid
Administrator / CDA at Ortho On YatesVictoria, British Columbia, Canada
John newman
Foodservice Sales AF Wendling FoodserviceCharleston-Huntington Area
Ting ho
Story-teller and adventurerEindhoven Area
Fabricio magalhães vieira
Gestor Comercial | Coordenador de Vendas | Supervisor comercial | Gerente de contas | Vendas | Venda...São João de Meriti, Río de Janeiro, Brasil
Georgia gale
Customer Success Associate at EdstartGreater Sydney Area
Rassam meethal
Manager Asset & Liability Operations at Bank NizwaMasqaţ, Oman
John-paul unwin
Senior Technician at Technaut IT ConsultantsIsle of Man
Régis roeckel
Commercial Pêche chez Shimano France, oeuvrant sur 22 départements, secteur Est, Suisse romande et O...Strasbourg, Grand Est, France
Peter sills photography
PhotograperScottsdale, Arizona, United States
Saikiran namani
Bachelor of Engineering in Information TechnologyMumbai, Maharashtra, India
Danny connolly
Field Sales Director - LionGreater Sydney Area
İlayda yalkın
Flight AttendantIstanbul, Türkiye
Kabiru adamu nbabuine
First Line Manager @DHL - TJX EuropeNorthampton, England, United Kingdom
Francis ahiwe
Senior Application Engineer at SOLOMON Technology Thailand Co. LTDปทุมธานี, ประเทศไทย
Ragunathan p
Account Delivery Manager at MphasisSan Ramon, California, United States
Nilam supekar
Assistant Development Engineer at Signify Innovation India Ltd.Pune, Maharashtra, India
Moira mckenna
MBA | Founder | Advisor | Business Leader | Revenue DriverDublin, County Dublin, Ireland
Sidoine adopre-doh
Ingénieur d'affairesToulouse, Occitanie, France
Dario francione
Vigile del fuoco presso ministero degli interni dipartimento vigili del fuocoChieti, Abruzzi, Italy
...