Yingyi Chen Email & Phone Number

San Diego, California, United States

Shanghai, China

Built ETL pipeline using Pandas and HPCC to streamline data cleaning process of a substantial 1.3TB nationwide sales data, connected cleaned data on MySQL to Excel and Power BI data sheet using VBA(Visual Basic) to achieve automatic data update.Optimized an AI intelligent customer service chatbot by enhancing NLP model, leveraged K-Means clustering, anomaly detection, LDA(Latent Dirichlet Allocation) and word embedding, improved the accuracy and efficiency of call and chatbot automation.Conducted A/B test for 14 new products ad copy on Baidu Ads Platform to enhance ad performance, led to a 4% CTR boost.Developed data set entity relationship, created detailed measurement in Power BI using DAX and provided 24 pages of Power BI data visualization solutions for IT department.

Seattle, Washington, United States

Led a team of seven people to implement data visualization and classification for Safer and Beyond Project; Employed CNNalgorithm to achieve license plate and lane detection for image and video data set, mAP achieved 53.9%• Leveraged AWS(GLUE and S3) to achieve automatic data integration, offering a holistic overview of death rate of reckless driving• Developed Vehicle Detection, Following Distance Alarm, Tracking and Speed Estimation module using OpenCV and Python

Shanghai

ShengQu GamesPerformed data filter and classification for the department employee KPI metric on over three TB data load using SQL. Employedthe KNN (K-Nearest Neighbors) algorithm for multi-class classification to identify abnormal data, accuracy of fault data recognition is improved to 99.7%• Built automatic pipeline for employee KPI metrics calculating and updating for 13 project teams using Python and SQL• Applied time series analysis on the game: The legend II to understand the trend for user purchase rate and for further modeling• Designed 34 pages of Tableau workbooks to monitor KPI metrics, project deliverable and upcoming milestones, enabled real-time metrics tracking and efficient analytic• Made weekly presentation on key metrics and project timeline to project managers and shareholders

Shanghai, China

Implemented a data formatting function using Java to transform data from company internal pipeline into a required format• Updated battery size sketches and battery parameters data base of over 86 types of batteries using AutoCAD and SQL• Collaborated with Europe HQ engineers on new porduct parameters confirmation and Greater China area database update

Shanghai, China

Cleared wage settlements of all other teaching assistants. Planned the resorting of library books.

Master Of Science - Ms, Electrical And Electronics Engineering (Data Science Track)

Bachelor'S Degree, Electronic Information Engineering

Activities and Societies: Student Union, Dancing Association