img
Picture1
ABOUT ME

I'm a Full-Stack Business Analyst having +7 Years Of Experience

I’m a data evangelist who is self-motivated and passionately curious, especially about how data can be used to inform actionable insight. To do this, I extract, transform and load disparate data sets from multiple sources using R, Alteryx or Tableau Prep. Then deep dive into data sets to answer key business question using Excel, R and Tableau. In addition, I formulate business metric for reporting then scale and automate user-friendly reports.

Specializing in

Retail Analytics; Product, Marketplace(Channel, Store) and Consumer. Analyze products POS data in order to maximize sales opportunity and optimize inventory by planning and forecasting. With geographical and demographic information, I can inform noteworthy stories to stakeholders.

ETL using SQL

Writing complex SQL queries to pull data and answer key business question from large data sets. Create view, table and stored procedure to manage data

Analyze data using R and Python

Own and perform individual deep dive analyses to solve complex problems. e.g) Demand & Supply Optimization, Demand Forecasting, Marketplace Analysis

Visualization and Reporting using Tableau

Create, design and implement visualized dashboard with statistical graphics,plot and mapping. It makes everyone in on it and get actionable insight fast.

Education

Certificate

img
WORK

Experience

Data Analytics Manager

Nike
Beverton, USA
  • Translate complex business problem statements into analysis requirements
  • Develop SQL queries and data visualizations to fulfill ad-hoc analysis requests
  • Lead structured end-to-end analysis to inform product strategy

Key City Analyst

Nike
Seoul, Korea
  • Conduct geographical and demographic modeling to find insight
  • Build Tableau Dashboard using mapping
  • Omni-channel analytics(Physical store and Digital store)

Marketplace Intelligence Analyst

Nike
Seoul, Korea
  • Migrate local database into global database
  • Validate data integrity within data products supporting
  • Support best practices in reporting and analysis

R&D Engineer

LG Display
Seoul, Korea
  • Engineering data modeling using LabView
  • Experimental Design for OLED
  • Publish US Patent for White OLED
img
COMPETENCY

Skills

R
90%
Python
70%
SQL
90%
SQL Server
70%
Power BI
80%
Tableau
95%
Alteryx
80%
Excel(VBA)
80%
PORTFOLIO

Case Study