Yihui Huang

Finance & Data Analytics

San Francisco Bay Area

About

With a Master of Science in Business Analytics from UC Davis, I've honed my expertise in data analysis and visualization, currently applying these skills at Amazon Lab126 to drive financial insights. Our team utilizes SQL, Python, and Tableau to uncover trends that inform strategic decisions.

Experience

  • Senior Financial Analyst at Amazon Lab126
    Dec 2021 - Oct 2024 · 2 yrs 11 mos

  • Analyst, Financial Planning & Analysis at See's Candies
    Sep 2020 - Dec 2021 · 1 yr 4 mos

  • Data Analyst, Practicum Project at AOPA
    Sep 2019 - Jun 2020 · 10 mos

    Ÿ (Air Safety Institute (ASI) is part of the umbrella organization to the Aircraft Owners and Pilots Association (AOPA). ASI strives to reduce general aviation (GA) accidents by providing educational material to the GA pilots to ensure safe flying experience. Our project aims to discover behavioral insights from previously untapped NASA’s ASRS Database.) · Ÿ Data Cleaning: Used SQL, R and Python (pandas) for data cleaning and exploratory data analysis on 30 years of reports · Ÿ Data Visualization: Developed Tableau dashboards to visualize key ASRS database insights to help ASI discover behavioral incident trends, and led presentation to ASI leadership · Ÿ Machine Learning: Applied natural language processing (NLP) using Python (NLTK) to pilots’ narratives to identify underlying risks for fatal incidents; Built a classification model in Python (Scikit-learn) to group different causes based on the pilots’ narratives

  • MSBA Executive Assitant / Student Marketing Analyst at University of California, Davis - Graduate School of Management
    Sep 2019 - Mar 2020 · 7 mos

    · Work closely with the executive and academic directors to create an engaging experience for students in the MSBA. · Leverage data to work in initiatives related to student experience, program outreach, and market intelligence & analytics. · Official student ambassador for UC-Davis; · Drive market analysis, strategy and implementation for Chinese applicants market.

  • Business Intelligence Analyst at Bulgari
    Sep 2018 - Jun 2019 · 10 mos

    · Model Building: Individually designed a retail analysis & forecast model for Greater China Region (CN, HK&MO and TW) using SAP BI and R; Performed ad-hoc analyses to measure store performance and tracks key business metrics for the company, contributed to monthly revenue growth of 20% · Dashboard Building: Designed date selectors and formulas for internal analysis reports to substantially reduce update procedures and spare 10 hours of work each month for the team · Data Visualization: Used Tableau to design a unified dashboard for internal sales analysis reports · Analysis Reports: Handled weekly/monthly/quarterly reporting over the Greater China Region (CN, HK&MO and TW), covering retail sales, digital/omnichannel, CRM, and product related analysis Ÿ· Market Research: Conducted research on Chinese economy and luxury industry to prepare weekly highlights