| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePHONE NUMBER AVAILABLE
Seattle, WA
Candidate's Name
EMAIL AVAILABLE LinkedIn: Candidate's Name
EDUCATION
UNIVERSITY OF WASHINGTON Overall GPA 3.8/4 Seattle, WA
Master of Science in progress: Electrical and Computer Engineering (Data Science Track) Sep 2022 - Expected June 2024
Coursework: Database Systems, Data Visualization, Machine Learning, Probability and Random Processes, Computer Vision
SHANGHAITECH UNIVERSITY Overall GPA 3.6/4 Shanghai, China
Bachelor of Engineer: Electrical and Information Engineering Sep 2018 - Jun 2022
Coursework: Information Theory, Discrete Mathematics, Algorithms & Computational Complexity, Introduction to Economics
SKILLS
Programming Languages Proficient: Python, SQL, Vimscript, MATLab, R; Competent: Java, C/C++, JavaScript
Analytical Skills A/B Testing, Hypothesis Testing, Time Series Analysis, Decision Tree, Linear/Logistic Regression
Tools and Database Tableau, Power BI, core service of AWS, MySQL, PostgreSQL, MongoDB, AsterixDB, Git, SPSS
WORK EXPERIENCE
Data Scientist and Analyst Intern Jul 2023 - Sep 2023
BEIERSDORF AG Python | SQL | Power BI | Database Management Shanghai, China
Built ETL pipelines using Pandas and HPCC to streamline data cleaning process of a substantial 1.3TB nationwide offline sales
data for Nivea; integrated the cleaned data into MySQL, established Python-based automation for seamless updates in Power BI
Designed, executed and analyzed A/B testing on Nivea Men Skincare products on Baidu Ads Platform, provided daily data-driven
reports and strategic insights to sales manager, resulting in a remarkable 4% boost in click-through rate (CTR)
Supported sales team to visualize Nivea offline data; transformed sales data into business measurement metrics using DAX;
designed 24 sheets of Power BI visualization plan to enhance data comprehension and accessibility for other sales teams
Program Data Management Intern Nov 2021 - May 2022
SHENGQU GAMES Python | SQL | Tableau | R Shanghai, China
Performed data filter and classification for the department employee KPI metric on over three TB data load using SQL. Employed
the 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
Technical Engineer Intern Jun 2021 - Sep 2021
EXIDE TECHNOLOGIES SQL | Java | AutoCAD 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
PROJECTS
PACCAR Capstone: Driver Classfication - Safer and Beyond Project Jan 2023 - Jun 2023
A Lidar based detection and safe secure Deep Learning application Python | SQL | AWS | Lidar Seattle, WA
Led a team of seven people to implement data visualization and classification for Safer and Beyond Project; Employed CNN
algorithm 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
Covid-19 Vaccine Appointment Application Design Sep 2022 - Jan 2023
A database application and management for vaccine appointment Python | SQL | Microsoft Azure Seattle, WA
Designed Entity Relation Diagram (ERD) of the project and created corresponding database tables
Implemented a vaccine scheduling application for hospitals using Python with a database hosted on Azure to support
interaction with users through command-line interface
Developed a wrapper class to manage the connection of vaccine scheduling application to Azure SQL Server database, including
establishment, pausing, termination all with error handling
|
