Data & Consulting_

Consulting Intern · AWS · QuickSight · Samsung MX

Company

EY Han Young

Role

Consulting Intern

Location

Seoul, South Korea

Client

Samsung MX

Full case study coming soon — detailing the AWS data pipeline architecture, QuickSight dashboard redesign, and segment mapping framework built for Samsung MX global marketing.

Scroll

preview — key impact

What I built & what it moved

At EY Han Young, I worked as a Consulting Intern on a data infrastructure and dashboard project for Samsung MX — building an AWS-based reporting pipeline that consolidated marketing performance data across 5+ global markets, redesigning the QuickSight UX for executive reviews, and developing a master taxonomy for 500+ Similarweb domains.

↑40%

efficiency

AWS Data Pipeline — Amazon Ads / AMC consolidation

Architected an end-to-end AWS pipeline (S3 → Glue → Athena → QuickSight) that consolidated Amazon Ads and AMC performance data across 5+ global markets for Samsung MX, accelerating marketing reporting efficiency by 40%.

↑30%

accuracy

Segment Mapping Framework — 500+ Similarweb domains

Developed a segment mapping framework that standardized retailer, carrier, and competitor categorization across 500+ Similarweb domains into a unified master data taxonomy — improving data classification accuracy by 30%.

−3hrs

per cycle

QuickSight Dashboard UX Redesign — executive reporting

Analyzed and redesigned the QuickSight dashboard information architecture to surface campaign KPIs (Impressions, ROAS, Orders) in a single-view layout for executive reviews — reducing stakeholder time-to-insight by 3 hours per reporting cycle.

tech stack

Tools & technologies used

AWS S3 AWS Glue Amazon Athena QuickSight Amazon Ads AMC (Amazon Marketing Cloud) Similarweb Data Pipeline Design Dashboard UX / IA Master Data Taxonomy SQL / Athena Queries Business Consulting

[ _ ]

Full case study coming soon

I'm currently documenting this project in detail — covering the pipeline architecture, dashboard redesign decisions, and the data taxonomy framework. Check back soon.

Impact & key metrics — done

Tech stack overview — done

AWS architecture diagram — in progress

QuickSight before/after — in progress

Segment mapping framework — coming soon

Process & reflection — coming soon