Morgan Tseng Email & Phone Number

Los Angeles, Ca, Us

Huntington Beach, California, United States

• Pooled Hyundai CRM data from third-party OLAP systems into Databricks via automated ETL pipelines, reducing manual data entry by 20 hours per week and streamlining analytics for enhanced reporting and decision-making• Developed a Pandas DataFrame in Databricks to aggregate marketing campaign data via Sharepoint REST API, connecting to Tableau with a live feed for dynamic visualizations and year-end reporting• Queried using MySQL statements like GROUP BY and JOIN to generate KPIs for… Show more • Pooled Hyundai CRM data from third-party OLAP systems into Databricks via automated ETL pipelines, reducing manual data entry by 20 hours per week and streamlining analytics for enhanced reporting and decision-making• Developed a Pandas DataFrame in Databricks to aggregate marketing campaign data via Sharepoint REST API, connecting to Tableau with a live feed for dynamic visualizations and year-end reporting• Queried using MySQL statements like GROUP BY and JOIN to generate KPIs for Hyundai CRM campaign-specific sales performance, enabling demographic-targeted insights and strategy optimization• Improved sales predictive modeling accuracy by 10% using advanced feature selection techniques (Ridge, Lasso)• Designed a propensity model using Random Forest, Logistic Regression, and XGBoost to predict customer purchase likelihood based on web interactions, handling class imbalance and improving recall, precision, and F1 scores Show less

Irvine, California, United States

Chiayi City, Taiwan, Taiwan

Master Of Science - Ms, Business Analysis

Bachelor Of Arts - Ba, Business/Managerial Economics