Data Analyst Python

Zhanhao Ou

*** ***** ******, ****** ****, NJ ****2 857-***-**** adcjo5@r.postjobfree.com

SUMMARY

Project experience in data analytics and finance from academia and industry

Strong passion in data analytics and eager to learn new technology

Software: R, Python (Numpy, Pandas), Jupyter, SQL, Tableau, github, SPSS, SAS, Excel (vlookup, pivotable), PowerPoint, Access

Algorithm: Machine Learning, NLP, DNN, LSTM, regression analysis, classification analysis, decision tree, time series analysis, clustering, factor analysis, PCA

EDUCATION

Bentley University - McCallum Graduate School of Business, Waltham, MA Master of Science Major: Business Analytics GPA: 3.65 May 2019 Honor: graduated with Distinction

Bentley University, Waltham, MA

Bachelor of Science Major: Finance Minor: Actuarial Science GPA: 3.59 May 2018 Honor: graduated with cum laude, President’s List, Dean’s List ACADEMIC PROJECT

Optimizing Business Operations for Coffee Shop Spring 2019 Graduate Course: Data-Driven Development with Python

Constructed a matrix summarizing purchase history based on products specified by user indicating product popularity

Enabled user to decide time interval length to reveal heavy traffic time in shop

Modified matrix into a simple and standardized format showing business information one week starting from the date of month based on user input

Unearthing Textual Traits of High Rating Reviews on Yelp Spring 2019 Graduate Course: Data Mining

Created a standardized textual dataset in Python containing randomly selected 50,000 records from raw review data from Yelp

Built visualization maps and WordCloud to develop insight on review data in Yelp’s original dataset in different metrics

Built a text mining model in SAS Enterprise Miner to discover keywords for low and high ratings to deliver business insights for restaurants in different price range

Finding Client Demographics for Computer Education Companies Fall 2018 Graduate Course: Data Management and SQL for Analytics

Co-led team to achieve >95% score on project by conducting data collection and cleansing, creating and managing SQL database

Designed database relationship to categorize SQL table and attributes by using Excel and Oracle SQL

Connected SQL with Tableau to provide data visualization specifically on client, class taken, and book selling relationship, including client location map, gender attributes, and age distribution in an user-specified class PROFESSIONAL EXPERIENCE

Kalo Inc., New York, NY December 2019 – Present

Data Scientist

Categorize makeup products in use area by using NLP to build and fine tune Deep Neural Network (DNN) and LSTM model

Improve online search efficiency by grouping and categorizing over 50,000 brands and merchants registered in company database

Reduce manual work by constructing APIs in Python to cleanse new data imported to database

Improve color prediction model using random forest in Python to provide higher accuracy in product color detection in images Kalo Inc., New York, NY September 2019 – December 2019 Data Analyst Intern

Delivered key marketing insight to product manager by analyzing Tik-Tok product promoting video data in the year of 2019

Identified a successful solution to handling data repetition by connecting company database with interactive R-shiny framework

Assist with senior backend engineer to build an integrated brand management system for users to register

Expedite progress of ongoing projects led by software engineers to build automated data cleaning Bentley University, Waltham, MA September 2017 – May 2019 Eco-Fi Lab Center Tutor - Finance

Mentored approximately 20 students per month to develop communication and problem solving skills resulting in improving their academic performance

Established strong analytical skills by using analytical software (R and Excel) to advise students on financial modeling projects

Developed strong interpersonal skill by providing unsolicited advice and maintaining strong team-oriented working environment

Contact this candidate