• Analyzed users index and designed two projects’ schemes and strategies based on the requirements of clients• Built a predictive model with ridge regression and polynomial regression algorithms for population density measurement project, successfully predicted population density based on building information of Guandong province• Built two classification models with logistic regression algorithms and random forest algorithms for Zhaoqing city dual card user identification project• Conducted data extraction, table creation and data cleaning on Teradata database to provide data support with SQL • Performed data preprocessing and feature engineering to improve data quality by python• Crawled ten million of rows data by python from different websites to provide data support• Used python, R shinny and Tableau for data visualization and presented the findings and insights to clients

• Conducted data cleaning and analysis to provide data support by SQL in the customers electricity complaint project• Optimized data visualization via Excel and Tableau in customers electricity complaint project• Proposed complain improvement plans based on insights from data analysis, provided the recommendation to leader