Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Kevin Bohyuck Sohn

La Mirada

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

6
6
years of professional experience

Work History

E-Commerence Data Analyst

Coway USA
08.2024 - Current
  • Analyzed 10K+ monthly Shopify Plus orders across U.S. and Canada to track revenue, return rates, and error trends.
  • Used 12-month data to reduce return/refund rates by 17% and boost ops efficiency by 12%.
  • Built SQL models linking 250K+ Shopify rows with Salesforce, enhancing customer journey insights.
  • Created 15+ Power BI dashboards, driving a 10% lift in campaign ROI for cross-functional teams.
  • Managed 500+ weekly UPS shipments via SAP, ensuring timely fulfillment and error tracking.
  • Delivered monthly logistics and SG&A reports on $1.5M shipping spend, enabling an 11% YoY cost reduction.

CRM Data Analyst

Fanatics Inc
09.2022 - 03.2023
  • Executed 50+ targeted email campaigns quarterly across site portfolios, collaborating with CRM and Business Management teams to align strategy and execution.
  • Analyzed campaign performance using SQL, Tableau, and Excel (1M+ rows/month), generating reports that improved CTR by 15% and conversions by 10%.
  • Conducted A/B tests and performance reviews in Salesforce Marketing Cloud, providing insights for optimization.
  • Built audience segments using behavioral and transactional data, increasing targeting precision by 20% and reducing churn by 8%.
  • Implemented dynamic content and sequencing logic to drive personalized engagement across a 2M+ subscriber base.

Marketing Data Analyst

FEW MODA
09.2019 - 03.2020
  • Boosted customer engagement by 17% by managing and optimizing Instagram and TikTok content strategy, growing follower base by 25% and increasing average post reach by 30%.
  • Led and executed holiday sales campaigns, resulting in a 9% YoY sales increase and a 14% improvement in conversion rates across digital channels.
  • Analyzed social media performance using Google Search Console, Facebook Analytics, and Tableau; identified top-performing content and optimized posting cadence, contributing to a 20% increase in CTR and a 12% reduction in bounce rates.
  • Delivered quarterly digital performance reports using Tableau dashboards with data from 10K+ interactions, presenting findings to the Social Media Manager and senior leadership to inform updates to marketing strategy and budget allocation.

Education

Marketing And Sports Business

Drexel University
Philadelphia, PA
09-2023

Skills

  • Gap analysis
  • Visual data representation
  • Data filtering
  • Data formatting
  • SQL
  • Python
  • Power BI
  • Tableau
  • Back End Data Management

Languages

Korean
Native or Bilingual
Japanese
Professional Working

Timeline

E-Commerence Data Analyst

Coway USA
08.2024 - Current

CRM Data Analyst

Fanatics Inc
09.2022 - 03.2023

Marketing Data Analyst

FEW MODA
09.2019 - 03.2020

Marketing And Sports Business

Drexel University

Similar Profiles

CREATE PROFILE
Kevin Bohyuck Sohn