• Conducted A/B testing to explain user propensity and give actionable insights to improve user product experience, increasing click through rate on “favorite” button by 15% • Identified metrics with data scientists for recommendation system and initiate in-house analysis reports to track user feedback overtime using SQL and Python and created dashboards in Tableau• Analyzed web behavior during customer journey using Python and Google Analytics to explore reasons for drop-off and proposed suggestions on product improvement, remaining customer retention in 75%• Developed dashboards for KPIs along conversion funnel across different channels using Tableau to help optimize marketing spending and set working priorities• Automated weekly performance reports by building ETL pipeline includes data collection, cleansing, calculation and visualization in Airflow and Python, improving work efficiency by 5 times

• Predicted future CPM using random forest regressor model with R squared 0.97 to compare the effectiveness of paid ads traffic with organic traffic and provided actionable insights to marketing team• Performed clustering analysis using K-prototype to create 8 segments for demographic targeting • Analyzed ads campaign with conversion funnels using Python and simulated marketing campaigns to increase 5% of margin by providing demographic targeting on digital and social channels • Established user-interactive Tableau dashboards for KPIs along conversion funnel across different channels to help optimize cost per click

Shanghai Phillps Healthcare CRM System Team• Identified metrics and attributes required to address broad business needs in the CRM and OLAP System • Extracted metadata in TB by SQL using join, and aggregation functions from an RMDB• Developed and deployed 36 ETL job workflows with reliable exception handling and rollback in UNIX-Scripting and Informatica including data transformation, data integration, cleansing, regularization, and labeling into the distributed file system (HDFS)• Designed automated performance reports by the time period in Tableau to display KPI, ROI, and modeling results for different Philips department

•Set deadlines and monitored project status for the ERP system with 126 teammates and reported to executive manager•Evaluated and recommended changes to current and future ERP system requirements to meet business needs •Built 20 end-user search pages with SQL querying in C# and analyzed issues that have the potential to jeopardize performance