JUNGUN LEE
BI & Data Analytics
Process Optimization
Workflow Automation
Process Optimization
Workflow Automation
📌 5+ Years of Experience in BI & Data Analytics
📌 Turning Data into Business Impact
📊 I optimize workflows, build BI solutions, and deliver real-time insights for smarter decision-making.
📌 Turning Data into Business Impact
📊 I optimize workflows, build BI solutions, and deliver real-time insights for smarter decision-making.
🛠 My Expertise
✔ 5+ Years BI Strategy & Data Analytics
✔ Process Optimization & Automation
✔ Executive Dashboard Design
✔ Proof of Concept (POC) Execution
🌍 Languages: Native Korean, Fluent in English and Chinese
✔ 5+ Years BI Strategy & Data Analytics
✔ Process Optimization & Automation
✔ Executive Dashboard Design
✔ Proof of Concept (POC) Execution
🌍 Languages: Native Korean, Fluent in English and Chinese
📩 Email Me
Lotte Duty-Free Shop Next-Generation Transition ProjectBI LeadGo to Project 🚀
🔹 Objective: Built a scalable BI data pipeline to resolve extraction failures and optimize dashboard performance.
🔹 Key Achievement: Reduced data extraction failures by implementing a partitioned ETL strategy, enabling seamless data processing and cutting report loading time from 2–3 hours to under 1 minute.
🔹 Challenges Solved:
Overcame data extraction failures caused by excessive data volume.
Developed an ETL pipeline using Tableau CMD and Linux shell to automate partitioning and merging.
Optimized data refresh strategy by segmenting historical and real-time data, ensuring efficient updates.
Enhanced Tableau performance, enabling faster and more reliable reporting across dashboards.
🔹 Objective: Built a scalable BI data pipeline to resolve extraction failures and optimize dashboard performance.
🔹 Key Achievement: Reduced data extraction failures by implementing a partitioned ETL strategy, enabling seamless data processing and cutting report loading time from 2–3 hours to under 1 minute.
🔹 Challenges Solved:
Overcame data extraction failures caused by excessive data volume.
Developed an ETL pipeline using Tableau CMD and Linux shell to automate partitioning and merging.
Optimized data refresh strategy by segmenting historical and real-time data, ensuring efficient updates.
Enhanced Tableau performance, enabling faster and more reliable reporting across dashboards.
MZD Asset Development – Predictive Analytics & Machine LearningData Preprocessing, Predictive Modeling & BI IntegrationGo to Project 🚀
🔹 Objective: Applied predictive modeling in BI to analyze happiness score drivers.
🔹 Key Achievement: Model explains ~70% of variations in happiness scores (R² = 0.7034), demonstrating strong predictive ability in social and economic data.
🔹 Challenges Solved: Optimized data preprocessing and improved Tableau BI reporting with TabPy integration.
🔹 Objective: Applied predictive modeling in BI to analyze happiness score drivers.
🔹 Key Achievement: Model explains ~70% of variations in happiness scores (R² = 0.7034), demonstrating strong predictive ability in social and economic data.
🔹 Challenges Solved: Optimized data preprocessing and improved Tableau BI reporting with TabPy integration.
Lotte Homeshopping – Call Data Integration & Business Process OptimizationBI Lead – Data Integration, Business Process Optimization, Data AnalysisGo to Project 🚀
🔹 Objective: Integrated a new call infrastructure, transforming dispersed call data into a unified business metric for executives and customer service representatives.
🔹 Key Achievement: Optimized customer service operations by eliminating duplicate call data (10% efficiency gain) and implementing real-time dashboards for better decision-making.
🔹 Challenges Solved: Streamlined call workflows by analyzing inefficiencies, ensuring data-driven executive decisions and improving agent performance tracking.
🔹 Objective: Integrated a new call infrastructure, transforming dispersed call data into a unified business metric for executives and customer service representatives.
🔹 Key Achievement: Optimized customer service operations by eliminating duplicate call data (10% efficiency gain) and implementing real-time dashboards for better decision-making.
🔹 Challenges Solved: Streamlined call workflows by analyzing inefficiencies, ensuring data-driven executive decisions and improving agent performance tracking.
