Jinyuan Chen Email & Phone Number

Woburn, MA

• 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

Greater Boston Area

• 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 City, China

• 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.
• Designed automated performance reports by the time period in Tableau to display KPI, ROI, and modeling results for different Philips department

Shanghai City, China

• 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

Master Of Professional Studies In Analytics, 3.9

Activities and Societies: RISE Sharing Economy Award; Outstanding Research Awards: Computer and Information SciencesThe main courses.

Bachelor Of Science In Applied Mathematics, General Statistics, Applied Mathematics

Associate Of Science In Mathematics And Computer Science, Mathematics And Computer Science