Data Analyst Python

Chang Liu

Address: **-** ******* ***, **** Island City, NY 11101

Phone: 917-***-**** Email: adjvag@r.postjobfree.com

EDUCATION

Fordham University Gabelli School of Business New York, US Master of Science in Business Analytics Aug 2019 – Dec 2020 Cumulative GPA: 3.73/4.00

Courses: Database Management (SQL), Data Mining (Predictive Modeling, Python Scikit-Learn, SPSS), Big Data Analytics (Hadoop, Spark), Business Analytics for Managers (Tableau), Web Analytics (Python) Beijing Hospitality Institute (BHI) Beijing, China Bachelor of Management in Financial Management Sept 2012 – June 2016 Cumulative GPA: 3.72/4.00

Honors: Excellent Student Leader (top 5%); Beijing Municipal Excellent Graduate (top 3%) REAL-WORLD BUSINESS PROJECTS

KPMG Data Analytics Consulting Project New York, Sept 2020 - Dec 2020

● Explored 20k rows of preliminary data of a medium-sized bikes & cycling accessories organization and identified ways to improve the quality of Customer Demographics, Customer Address, and Historical Transactions Data through Python Pandas

● Built 3 Tableau dashboards to understand the sales trend as well as the correlation between critical demographic variables (customer segment, customer value, age, product line, etc)

● Specified who the client's marketing team should be targeting out of the new 1k+ new customer list as well as the broader market segment to reach out to

Deloitte March Madness Data Mining Competition New York, Feb 2020 - May 2020

● Extracted and transformed a dataset of 157 variables over 2002 to 2020, ensured high data quality by data normalization and regression imputation, applied Pearson Correlation to select most related features

● Predicted gaming results of each game in 2020 NCAA Men’s Basketball Tournament, applied Logistic Regression, Convolutional Neural Network, and MLP Classifier

● Developed and optimized model to predict gaming result with accuracy over 74% and log loss of 0.49

● Identified coach and strategy are the key factors of winning and recommended the team to balance defense and offense based on the opponent's performance and characteristics

● Led a team of 4 to present data models and insights to Deloitte senior data team Art Gallery Database System Design & Operation New York, Sep 2019 - Dec 2019

● Designed relational & physical model and generated DDL script via Oracle Modeler, created database in Oracle Apex and inserted collected historical data into it, performed basic and advanced SQL queries(aggregate functions, joins, window functions) to meet various potential demands

● Transformed, matched and standardized public historical art gallery data from multiple sources into SQL tables for the database

PROFESSIONAL EXPERIENCE

Forage New York, US

Data Analyst Virtual Internship, Oct 2020 – Dec 2020

● Owned the analysis tasks and actions to address data quality issues and to achieve necessary data quality levels

● Established a complete process of data processing, cleaning, integrating, and analyzing

● Create reports for internal teams and/or external clients SERVEONE Nanjing - LG Affiliated company Nanjing, China Account Payable Specialist, May 2017 - August 2019

● Analyzed a variety of purchasing data over 500 vendors using SAP, SQL, and Excel, partnered with cross- functional teams in detecting inactive vendors, and reduce the related maintenance fee

● Initiated purchasing trending analysis to detect price increasing products, recommend the advanced purchase to reduce cost

Contact this candidate