SQL and Database Management Resume

SUMMARY

An adaptable professional who specializes in data analyzing and visualization, machine learning algorithms with Python, and database management.
A 2018 Master’s of Business Analytics graduate of the Confidential .

TECHNICAL SKILLS

Excellent Data Analytical skills
Data Visualization with Tableau
SQL and Database Management
Machine Learning with Python
Writing and Verbal Communication
Problem Solving & Team Working

PROFESSIONAL EXPERIENCE

Confidential

SQL and Database Management

Responsibilities:

Communicated with TI s managers and figured out that they needed a high quality mathematic model to predict their transaction conversion rate.
Explored TI s transaction data, cleaned outliers and empty observations, and transformed skewed variables by using Python.
Clustered TI s customer data into 5 segments with unsupervised machine learning algorithms PCA and K - means, and visualized features of each customer group in Tableau.
Executing Scikit-learn in Python, we trained classification models, including Logistic Regression, Random Forest, and Support Vector Machine, to predict transaction conversion rate and evaluated training results using Cross-validation.
The final mathematical model has a 79 percent accuracy and potentially increases TI s revenue by 35 percent when a suggested price modification is applied. Fortunately, we entered final round and got the 3rd place.

Election Data Visualization

Confidential

Responsibilities:

Preprocessed dataset and joined demographic information and election results on county level using SAS studio
Explored patterns between election results and demographic information like race, population, age, education and income by using Tableau.
Created a dashboard and a story in Tableau to present the relationships which we found from 2016 Prime Election.
Transformed database requirements into entity and relationship, and drew a corresponding ERD with MySQL
Converted the ERD into SQL schema and architected 8 tables by using MySQL and modified constraints of each table
Identified faults and imported data into the rational database

TECHNICAL SKILLS

Languages: English, Chinese

Computer skills: Excel (Advanced), Tableau, MySQL, Python (Numpy, Pandas, Scikit-Learn, Seaborn, Matplotlib, Tensorflow), R (base), SAS (base), Hadoop (Sqoop, HDFS, Hive)

Eligibility: Eligible to work in the U.S. for internships and full-time employment for up to 36 months without sponsorship.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship