Luna Lee Email & Phone Number

South Korea

Michigan, United States

Data Cleansing and Quality Improvement Project● Led a project to resolve product data inconsistencies in SAP ERP by enforcing data governance policies and managing data using Snowflake and Oracle Data Warehouse.● Utilized Python and R Studio to perform data imputation, detect duplicates, and identify outliers (using techniques like Z-score and IQR) to enhance data quality.● Implemented data validation rules and automated error detection processes, achieving a 20% increase in data accuracy and overall data integrity.● Developed clear, real-time reports and dashboards in Power BI to monitor data quality, supporting sustained improvements in accuracy and decision-making.Supply Chain Lead Time Optimization Project● Led an initiative to reduce supply chain lead times by analyzing vendor performance using linear regression and time-series analysis in Python to align with cost-saving objectives.● Achieved a 15% reduction in lead times, enhancing operational efficiency and customer satisfaction.● Created real-time dashboards in Power BI to track key performance metrics, improving visibility and supporting better decision-making.

Downers Grove, Illinois, United States

Web Analytics and Optimization ProjectAnalyzed web traffic data using SQL and Google Analytics, identifying optimization opportunities and implemented data-driven SEO changes, which improved organic traffic by 25% and increased search engine rankings.Controlled Experiment Analysis for Digital CampaignsExecuted A/B testing on ad campaigns utilizing Python and SQL to identify high-performing strategies, and developed real-time tracking dashboards in Power BI, driving a 20% increase in conversion rates through data-driven optimizations.

● Provided data-driven recommendations for optimizing global business operations by analyzing system performance data using Python and SQL. ● Used decision tree and random forest models to improve operational efficiency, achieving a 25% increase in overall performance.

Meta Ads Campaign Optimization ProjectIncreased program applicants by 40% by leading A/B testing for Meta ad campaigns, using Python and Excel to analyze key performance metrics and optimize ad effectiveness. Performed statistical analyses to validate test results, driving data-driven decisions that maximized campaign performance. Awarded the Excellence Student Award for outstanding achievements in data analysis and campaign management.

Master Of Science - Ms, Management, 3.7 / 4.0

Activities and Societies: Member of the Data Analytics student club ‘DAIS’ / 2023 Gies business scholarship recipientGlobal IT Client.

Bachelor'S Degree, Media

Upper Second Class 2 : 1

Exchange Student

Exchange student as Film/ Communication