Jenny Yang
Washington, D.C. · Business Analyst · Green Card
jennyyang@caa.columbia.edu ·
(347)-419-3727 ·
jennyyang.djmp.tw ·
LinkedIn: jennyyang-cu
Professional Summary
Consumer-focused Business Analyst with 3+ years’ experience in eCommerce, CPG, and Media.
Skilled at leveraging customer segmentation, behavior analysis, and product bundling strategies to uncover growth opportunities,
including identifying 7× cross-sell potential through data-driven insights.
Skills
- Business Intelligence: SQL (MySQL, PostgreSQL), Relational Database, Advanced Excel, ETL
- Data Visualization & Analytics: Tableau, Power BI, R, Python, Data Cleaning, Data Manipulation, A/B Testing
- Project Management: Stakeholder Management, Requirements Gathering, Process Improvement
Education
Columbia University – M.S. Applied Analytics (GPA: 3.72/4.30)
New York, NY · 09/2022 – 12/2023
Courses: NoSQL/SQL Database, A/B Testing, Data Management, Statistical Modeling, Storytelling with Data, AWS Cloud Computing
University of San Francisco – B.B.A. Marketing (GPA: 3.82/4.00)
San Francisco, CA · 08/2017 – 05/2021
Honors: Magna Cum Laude, 4× Dean’s Honor Roll, 4× Global Award Scholarship
Work Experience
Intenza Fitness – Business Analyst
Seattle, WA · 03/2024 – 07/2024
- Created Tableau dashboard visualizing 8 quarters of sales KPIs, reducing reporting time by 20%.
- Built automated reporting for 100+ monthly requests, improving team visibility and cutting manual checks by 80%.
- Optimized workflows via Smartsheet-based data system, reducing costs by 10%.
Baldor Specialty Foods – Data Analytics Consultant
New York, NY · 09/2023 – 12/2023
- Analyzed 33M+ sales data in Power BI, revealing 7× cross-sell opportunities.
- Led 7-person team using R, Python, Power BI to optimize marketing strategy.
- Segmented 5 key customer groups using LRFM analysis, improving personalization efficiency by 6×.
- Conducted market basket analysis on 2,000+ products to guide product placement and cross-sell strategy.
Chinese Newcomers Service Center – Business Analyst Intern (Marketing)
San Francisco, CA · 09/2019 – 12/2019
- Analyzed demographics to create marketing personas, increasing voter resource conversion by 10%.
- Optimized campaign keywords, boosting ad traffic by 33%.
Corning Incorporated – Business Analyst Intern
Taipei, Taiwan · 07/2019 – 08/2019
- Improved data quality by 12% through Excel-based data cleaning and requirement analysis.
- Forecasted TV shipment growth (2019–2026) via linear regression, informing strategic decisions.
Projects
Airbnb Review Intelligence – R (05/2023)
Identified key features driving customer engagement across 4K+ Airbnb listings, quantifying amenity impact on review volume and positivity to guide host visibility strategy.
