Hello, I'm

Kevin Sohn

E-commerce Data Analyst transforming millions of data points into operational efficiency and revenue growth.

View Projects Download Resume
Kevin's Photo

About Me

I am an E-commerce Data Analyst currently driving operational success at Coway USA and pursuing my MSBA at UC Irvine. With a strong foundation in marketing and sports business, I've pivoted into the world of rigorous data analytics.

My expertise lies in bridging the gap between raw data and actionable business strategies. From reducing return rates by 17% through meticulous analysis to handling data for massive email campaigns, I focus on tangible ROI and efficiency.

Skills & Tools

Analytics & Programming

  • SQL (Advanced)
  • Python
  • R
  • Data Filtering & Formatting

BI & Visualization

  • Power BI
  • Tableau
  • Google Analytics
  • Excel (Advanced)

CRM & MarTech

  • Salesforce Marketing Cloud
  • SAP
  • Shopify Plus
  • CRM Data Analysis

Languages

  • English (Native)
  • Korean (Native)
  • Japanese (Professional)

Featured Projects

Work Project

Shopify & Salesforce Integration Model

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

250K+ Rows Processed Mapped Customer Journey
Proprietary / Internal
Operations

Return Rate Reduction Analysis

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

-17% Return Rate +12% Ops Efficiency
Proprietary / Internal
Marketing Analytics

CRM Audience Segmentation

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

+15% CTR Lift -8% Churn Rate
Proprietary / Internal

Experience

E-Commerce Data Analyst

Coway USA Inc. July 2024 – Present

Los Angeles, CA

  • 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%.

CRM Data Analyst

Fanatics Inc. 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%.

Marketing Data Analyst

FEW MODA 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 & Certifications

Master of Science in Business Analytics

University of California, Irvine

Status: Student | VP of Outreach, Merage Analytics Club

B.S. Business Administration

Drexel University

Marketing & Sports Business | Graduated Sept 2023

Google Analytics Certification

Google

Get In Touch

Always open to discussing data strategy, e-commerce optimization, or new opportunities.

Email Me LinkedIn GitHub