Jackie (Yihuan) HU

Manager, Data Science Analytics at Coffee Meets Bagel
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Berkeley, California, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United States
    • Consumer Services
    • 1 - 100 Employee
    • Manager, Data Science Analytics
      • Jan 2022 - Present

      San Francisco Bay Area · Engaged in shaping CMB's onboarding and recruiting process, successfully brought onboard a Senior Product Analyst within 2 months after joining the team; · Initiated the company's first Analytics Office Hour dedicated to business teams (Marketing, HR, Finance, and etc.) to cover urgent needs that hard to find places in project planning cycle; · Switched to focus on IC work under CMB's OptoPod (optimization team) from mid-2022 to fill the needs of growing project demand: owning… Show more · Engaged in shaping CMB's onboarding and recruiting process, successfully brought onboard a Senior Product Analyst within 2 months after joining the team; · Initiated the company's first Analytics Office Hour dedicated to business teams (Marketing, HR, Finance, and etc.) to cover urgent needs that hard to find places in project planning cycle; · Switched to focus on IC work under CMB's OptoPod (optimization team) from mid-2022 to fill the needs of growing project demand: owning end-to-end A/B test workflow, including experiment plan, test launch, statistical analysis, and product recommendations. *Winner of 2022 CMB Bageler of the Year on Accountability ✨ Show less

    • United States
    • Education
    • 1 - 100 Employee
    • Education Mentor
      • Jun 2023 - Present

      San Francisco Bay Area · Support young professionals and fresh graduates to crush their twenties - both professionally and personally.

    • United States
    • Online Audio and Video Media
    • Founder & Podcast Host
      • Nov 2021 - Present

      San Francisco Bay Area · 🎙️ 4 Asian Americans gather at a round table to chat about how life is like as an immigrant living in the SF Bay Area.✨We upload new episodes biweekly. Please follow us on Spotify & Apple Podcast!

    • United States
    • Software Development
    • 200 - 300 Employee
    • Data Analytics Manager
      • Oct 2021 - Dec 2021

      San Mateo, California, United States · Conducted statistical analysis leveraging Looker & Python to examine the relationship between client usage data versus SendBird's AWS cost. · Helped to recruit Sr. Marketing Data Analyst and shaped recruiting process for data talents.

    • United States
    • Technology, Information and Internet
    • 700 & Above Employee
    • Analytics Manager II, Central Operations
      • May 2020 - May 2021

      San Francisco, California, United States { Projects Taken by Central Ops Have Product Impact As Instacart Is A Marketplace Platform } · Drove company-level Risk Operations initiatives by defining & executing key metrics dashboard reporting and feeding clearly-defined ETL data into Live Issue tool for Risk Operations to action on using Sisense and B12 ETL, preventing dollar leakage resulted from shopper & customer fraud. · Adopted the ETL process and expanded the Analytics team’s functionality to cover the data model, data… Show more { Projects Taken by Central Ops Have Product Impact As Instacart Is A Marketplace Platform } · Drove company-level Risk Operations initiatives by defining & executing key metrics dashboard reporting and feeding clearly-defined ETL data into Live Issue tool for Risk Operations to action on using Sisense and B12 ETL, preventing dollar leakage resulted from shopper & customer fraud. · Adopted the ETL process and expanded the Analytics team’s functionality to cover the data model, data refresh schedule, and dashboard production, achieving the milestone goal of taking full ownership of data products within Central Operations. · Sourced, hired, and trained junior to senior data analysts; set up Instacart’s first Fraud analytics team from scratch with the endorsement from Engineering and DS team at large. · Launched the Central Operations Data Training Program to help Operations associates to enhance data skills, driving the team to become more data-enabled and providing upward/horizontal career possibilities.

    • Senior Data Analyst, Central Operations
      • Jul 2019 - Apr 2020

      San Francisco Bay Area · Defined key business metrics logics and created dashboards to reflect business health across a variety of Operations teams, including Logistic Operations, Field Operations, Trust & Safety, Procurement Operations and etc. using SQL, Python, Shell, Tableau, Blazer, and Sisense. · Performed statistical analysis to derive business/policy recommendations for company-level key initiatives, such as sizing shopper card transaction abuse (expected value model & statistical extrapolation) and… Show more · Defined key business metrics logics and created dashboards to reflect business health across a variety of Operations teams, including Logistic Operations, Field Operations, Trust & Safety, Procurement Operations and etc. using SQL, Python, Shell, Tableau, Blazer, and Sisense. · Performed statistical analysis to derive business/policy recommendations for company-level key initiatives, such as sizing shopper card transaction abuse (expected value model & statistical extrapolation) and quantifying fulfilment quality & commitment tradeoff (key metrics trade-off analysis) using Python and Sisense. · Introduced and enforced JIRA ticketing system and templates for the Operations team to submit data requests and arranged for analytics Office Hour to address trivial ad-hoc requests & train Operations agents to adopt data-driven mentality to solve operation inefficiencies.

    • United States
    • Higher Education
    • 1 - 100 Employee
    • Data Scientist Fellow, Immersive Data Science Bootcamp
      • Apr 2019 - Jun 2019

      San Francisco Bay Area · Developed several data science projects as part of a full-time, competitive 12- week data science immersive program focusing on machine learning, exploratory data analysis, statistical modelling, and data visualization. Projects can be found here: medium.com/@jackiehu0814. Three highlighted projects below: * [ Alibaba Coupon Redemption Classification Project ] - built Machine Learning models to classify whether online users will redeem coupons to purchase offline, using 5 different ML… Show more · Developed several data science projects as part of a full-time, competitive 12- week data science immersive program focusing on machine learning, exploratory data analysis, statistical modelling, and data visualization. Projects can be found here: medium.com/@jackiehu0814. Three highlighted projects below: * [ Alibaba Coupon Redemption Classification Project ] - built Machine Learning models to classify whether online users will redeem coupons to purchase offline, using 5 different ML models & advanced feature engineering techniques with Python ScikitLearn. * [ Recommending Pricing for Airbnb Experiences w/ Linear Regression ] - built a pricing recommendation tool for Airbnb Experience listings hosts based on listing features, using tools that include Selenium, Pandas, ScikitLearn, and Google API. * [ Predicting NYC Subway Traffic w/ MTA Data ] - created a traffic forecasting tool to decide when and where to place crew force at NYC subway stations in order to maximize marketing effect using Pandas and Seaborn. Show less

    • United States
    • Technology, Information and Media
    • 700 & Above Employee
    • Consumer Insights Analytics Consultant, Walmart Global e-Commerce
      • Jan 2018 - Mar 2019

      San Francisco Bay Area · Queried on Jupyter notebook to analyze >1 million data points for consumer-insights projects on Hadoop/Hive, with an end-to-end analytics approach: generate questions, make analytics plan, clean & analyze data, and present results to the Walmart.com leadership. · Created >10-million-row consolidated rolling-sum dataset in HIVE/Hadoop to help Walmart category specialists identify high-performing brands in the rest of the market to onboard with a 2.5-million-dollar annual revenue… Show more · Queried on Jupyter notebook to analyze >1 million data points for consumer-insights projects on Hadoop/Hive, with an end-to-end analytics approach: generate questions, make analytics plan, clean & analyze data, and present results to the Walmart.com leadership. · Created >10-million-row consolidated rolling-sum dataset in HIVE/Hadoop to help Walmart category specialists identify high-performing brands in the rest of the market to onboard with a 2.5-million-dollar annual revenue opportunity. · Built Walmart.com’s competitive metric CVI (Consumer Experience Value Index) to help Walmart GeC Team identify a 1.5-million-GMV annual opportunity after launching recommended operational enhancement. · Defined Walmart.com’s Returns Net Promoter Score, built the methodology, created data slicers for various levels of data aggregation, and automated biweekly dashboard reported to the VP of Operations. Show less

    • United States
    • Technology, Information and Internet
    • 1 - 100 Employee
    • Associate Business Analyst
      • Aug 2017 - Dec 2017

      Dallas/Fort Worth Area { Previously TDn2K } · Conducted Exploratory Data Analysis (EDA) using PowerBI, Excel VBA to discover the correlation between Google Search Index, user sentiment, and net sales of member restaurants; built an automated regression module on Excel VBA to process 10,000+ regressions. · Extracted, Transformed, and Loaded (ETL) clients' raw data into a structured SFTP system, 100K rows of records processed daily. · Automated anomaly detection of clients' submitted data using Excel VBA… Show more { Previously TDn2K } · Conducted Exploratory Data Analysis (EDA) using PowerBI, Excel VBA to discover the correlation between Google Search Index, user sentiment, and net sales of member restaurants; built an automated regression module on Excel VBA to process 10,000+ regressions. · Extracted, Transformed, and Loaded (ETL) clients' raw data into a structured SFTP system, 100K rows of records processed daily. · Automated anomaly detection of clients' submitted data using Excel VBA and treated input typos of large datasets using Python Pandas. Show less

    • United Kingdom
    • Software Development
    • 1 - 100 Employee
    • Marketing Strategy Intern
      • Jun 2016 - Jun 2016

      Oxford, United Kingdom · Completed a 1-year marketing plan for MeVitae' s digital platform, including digital content marketing, branding, and competitor analysis. · Led a 3-member team to search for potential joint-venture partners and assessed probable strategies to attract these firms for an alliance. · Created a short-term strategy to publicize MeVitae at Oxford in Q3 2016 with $5K budget constraint; performed cost reduction analysis.

    • United Kingdom
    • Research Services
    • 700 & Above Employee
    • Graduate Research Assistant
      • Feb 2016 - Apr 2016

      Oxford, United Kingdom · Assisted Prof. Sung-won Kim with her “left-behind teachers in rural China” project, responsible for encoding textual data with Nvivo. · Collected, categorized, quantified and analyzed textual data on Excel for Stata operated regressions. · Succeeded in performing pilot regressions on Stata to eliminate more than 5 insignificant variables in the original equation.

    • United States
    • Higher Education
    • 700 & Above Employee
    • DeCal Gender Studies Course Instructor
      • Sep 2014 - Dec 2014

      Berkeley, California · Instructor, facilitator, and grader of the Decal Course "Discover the Self-Image of the 21st Century Chinese Women", responsible for leading class discussion and preparing lecture material. · This DeCal class aimed at promoting domestic and workplace gender equality on campus.

    • United States
    • Higher Education
    • 700 & Above Employee
    • Harvard IMUSE Summer Fellow
      • Aug 2014 - Aug 2014

      Beijing City, China · Selected as 1 of the 15 American delegates to participate in the 2014 IMUSE summer program. · Visited Beijing/Hong Kong and attended multiple workshops on environmental protections, non-profit organizations, business and entrepreneurship in China. · Gave a closing speech on comparative education and social entrepreneurship in China and the USA.

    • China
    • Business Consulting and Services
    • 1 - 100 Employee
    • Consultant Intern & 2014 Hejun Summer Case Competition Champion
      • Aug 2014 - Aug 2014

      Beijing City, China · Led a 5-member team to win the Champion of 2014 "HEJUN Consulting Group Case Competition". · Formulated a 3-year marketing plan within 2 days for an American craft beer company ‘Three Brothers’ intending to enter China. · Conducted a cost-benefit analysis on Excel and demonstrated why the company should enter China with its extant product portfolio.

    • United States
    • Higher Education
    • 700 & Above Employee
    • Undergraduate Research Assistant
      • Sep 2013 - May 2014

      Berkeley, California, USA · Assisted Ph.D. candidate David SchÖnholzer in discovering the geographical distribution of North Ireland’s political violence in the 1920s. · Performed Excel and Python coding to fixate and visualize the locations of political conflicts on Google map. · Transformed empirical textual data into clustered data for better visual presentation and comprehension.

Education

  • University of Oxford
    Master’s Degree, Interdisciplinary Area Studies, Contemporary China Focus
    2015 - 2016
  • University of California, Berkeley
    Bachelor’s Degree, Economics and East Asian Studies Double Major
    2012 - 2015
  • The London School of Economics and Political Science (LSE)
    LSE Summer Exchange, International Economics & Environmental Economics and Sustainable Development
    2013 - 2013

Community

You need to have a working account to view this content. Click here to join now