👉

I was a Junior Data Analyst with a background in CX and a strong focus on improving customer experience through data. Starting my career in a startup, I moved beyond simple operations to design data-driven workflows that directly impacted business outcomes. Key achievements include reducing refund rates by 50% (5.5% → 2.7%) through workflow redesign, building a full GA4 + GTM tracking infrastructure (79 events, 21 triggers) for a new service, and automating repetitive CX processes with Google Apps Script, cutting processing time from 5 minutes to 16 seconds.

I have hands-on experience with SQL, Python, Tableau, Power BI, GA4, and Excel, applying them to EDA, funnel analysis, and RFM segmentation in both bootcamp projects and real-world work. My approach combines structured problem-solving (MECE, hypothesis testing) with agile collaboration.

• Portfolio Projects
• Work projects
• Certificate
• Connect
  
  

• 📂 Repository: SQL Project   
• 📊 Description:  

    Analyzed shopping behavior patterns to identify purchase trends between subscribed and non-subscribed users and age segments using SQL. Focused on calculating AOV, revenue distribution, and conversion metrics to uncover business insights from raw transactional data.

• 📚 Dataset:  Datasets
• 📈 Dashboard:  Tableau Visualization

👉 Preview

• 📂 Repository: SQL / Python Project
• 📊 Description:  

    Through the E-commerce dataset between 2010 and 2011, this project executed an integrated 'Product-Centric Analysis' and 'Customer-Centric Analysis'. Initial steps, focused data cleaning, I identified 135,080 missing values in customerID and cleaned the 2,166 noises in item name’s column.

  The subsequent analysis revealed the revenue, aov, item sales across countries and months. Concurrently,  it revealed customer lifetime value, repurchase rate, and purchase pattern by Country, each customer and months.   

• 📚 Dataset:  Datasets
• 📈 Dashboard:  Tableau Visualization

👉 Preview

• 📂 Repository: SQL Project   
• 📊 Description:  

  Indentifying Key success drivers in the Spotify 2023 dataset by performing 'Comparative analysis of audio features' and 'Platfrom effeciency Analysis' and 'Correlation analysis'.

• 📚 Dataset:  Datasets
• 📈 Dashboard:  Tableau Visualization

👉 Preview

• 📂 Repository: Preview Tableau Dashboard Project

• 📊 Description:  

    Developed a Tableau dashboard analyzing U.S. car market sales between 2022 and 2023. Cleaned and standardized raw Kaggle data, created calculated fields for YoY growth and brand share, and designed interactive visuals highlighting post-pandemic recovery trends across major car brands and regions.    Focused on storytelling through key KPIs such as total sales, monthly growth rate, regional performance, and top 5 brands by market share.  

• 📚 Dataset:  Datasets

• 📈 Dashboard:  Tableau Visualization

👉 Preview

2022 - 2023 USA Car Sales Trend
Car Sales Trend by Brand
Car Sales Trend by Car Types
Car Sales Trend by Gender
Sales Trend by Dealer Region
  

📂 Notion portfolio: Project   

• 📊 Description:
• Designed and deployed 79 events and 21 triggers using GA4 and GTM, covering external acquisition (ads, SNS, YouTube) through internal actions (sign-up, payment, learning entry).
• Delivered real-time dashboards (Looker Studio) for executives and marketing teams.

📂 Notion portfolio: Project   

• 📊 Description:
• Designed and implemented a structured system for refund reason collection and categorization, consolidating all customer channels.
• Reduced refund rate from 5.5% → 2.7% (50% decrease) for Service A and stabilized refund rates at 3–4% for Service B.
• Improved CX efficiency and converted refund cases into repurchase opportunities.

📂 Notion portfolio: Project   

• 📊 Description:
• Automated repetitive tasks (certificates, receipts, CRM data prep), cutting process time 5 min → 16 sec with zero errors.
• Removed 90% of off-hour work, boosting team efficiency.

• Google Data Analytics Certificate (Coursera, 2024)
• Daterian Basic SQL Certificate (Daterian, 2024)
• HackerRank (SQL) Basic Certificate (HackerRank, 2024)