Jae Hoon Lee Email and Phone Number

CPRO & Sales Data Analysis: Leveraged SQL, Power BI, and Tableau to analyze CPRO data and parts sales, enabling actionable insights for marketing strategies and sales targets.Customer Survey Analysis: Managed and analyzed customer survey feedback from Honda and Acura service visits, delivering reports that contributed to CRM improvements and regional performance reviews.Predictive Analytics & Financial Modeling: Conducted 10-year NPV analysis for a $35 million investment, achieving a 356.73% ROI. Used Python to model CPRO customer visits and retention rates, providing accurate forecasts.Automated Reporting & Process Optimization: Automated financial reporting with Python scripts, enhancing efficiency and accuracy. Ensured data quality across CDK Global systems by resolving discrepancies and maintaining data integrity.Cross-Functional Collaboration: Collaborated with IT and business stakeholders to align reporting processes with operational goals. Contributed to KPI reports for executive teams and field managers.KPI Monitoring & Vendor Collaboration: Designed dashboards and tracked KPIs to monitor operational success. Partnered with vendors to maintain data pipelines and ensure smooth reporting operations.

* Use Hadoop and HiveQL to analyze correlationship between COVID-19 cases and vacciantion. * Use Hadoop and HiveQL to analyze tweet data for COVID-19 sentiment analysis. * Use Tableau and excel 3D map to visualize COVID-19 cases, vacciantion and sentiment analysis. * Publication: Jae Hoon Lee, Timothy Rochester, Riker Santivong, Wesam Farjo, Justin Licea, Jongwook Woo, "The Correlation of Covid-19 Vaccination and Confirmed Cases Using Scalable Big Data", KSII The 13th International Conference on Internet (ICONI) 2021, Dec 12-14 2021,Jeju Island, Korea, ISSN 2093-0542