Selected Projects

Shopify & Salesforce Integration Model SQL • Data Modeling

Built SQL models merging 250K+ Shopify rows with Salesforce data to map comprehensive customer journeys.

Processed 250K+ Rows
Mapped Full Journey
Return Rate Reduction Analysis Operations Analytics • R

Analyzed 12 months of order data to identify error trends and implement fixes in logistics.

Return Rate -17%
Efficiency +12%
CRM Audience Segmentation Python • Marketing Analytics

Developed dynamic segments using behavioral data for 50+ quarterly email campaigns.

CTR Lift +15%
Churn -8%

Experience

Coway USA / E-Commerce Data Analyst

Aug 2024 – Nov 2025
  • Analyzed 10K+ monthly Shopify Plus orders to track revenue and errors.
  • Reduced return rates by 17% and boosted ops efficiency by 12% via data insights.
  • Created 15+ Power BI dashboards increasing campaign ROI by 10%.

Fanatics / CRM Data Analyst

Aug 2022 – Feb 2023
  • Executed 50+ targeted email campaigns quarterly; improved CTR by 15%.
  • Analyzed 1M+ rows/month using SQL, Tableau, and Excel.
  • Built audience segments reducing churn by 8%.

FEW MODA / Marketing Data Analyst

Aug 2019 – Feb 2020
  • Managed marketing budgets and analyzed ROI, contributing to 20% sales growth.
  • Executed direct mail campaigns increasing customer acquisition by 15%.

Education

Expected 2026

M.S. Business Analytics

University of California, Irvine
Sept 2023

B.S. Business Administration

Drexel University

Marketing & Sports Business