Post Job Free

Resume

Sign in

Python, SQL, R, Tableau, Data Analysis

Location:
La Jolla, CA
Posted:
April 27, 2023

Contact this candidate

Resume:

ZHUO CHEN www.linkedin.com/in/zhuochen***

La Jolla, CA 614-***-**** adwrut@r.postjobfree.com

EDUCATION

Master of Science in Business Analytics, Rady School of Management 12/2023 University of California, San Diego, CA GPA:3.5/4.0

Relevant Courses: Business Analytics Consulting, Large Data Analytics, Web Mining & Recommender Systems, Scalable Analytics, Unstructured Data Analytics, Customer Analytics, Fraud Analytics, Experiments in Firm. Bachelor of Science in Business Administration, Finance, Fisher College of Business 05/2022 The Ohio State University, Columbus, OH GPA: 3.8/4.0

Minor in Statistics. Honor: Magna Cum Laude, Dean’s List 6 terms.

Relevant Courses: Advanced Investment, Corporate Finance, Fintech, Trading and Markets, Operation Management. EXPERIENCE

Intern, Investment Banking Division, China Galaxy Securities, Beijing, China 07/2020-11/2020

Conducted thorough research on industry and analyzed competition, profitability, and potential risk leveraging Excel and Python with Logistic Regression Models to list in IPO prospectus to give stakeholders a better understanding of situation of company and market.

Utilized Excel and Python to collect and analyze financial data from online resources, developed easy-to-understand visual representations such as histograms and trend plots of company profits and statements, helped investors and Securities Regulatory Commission to gain a clear understanding of company’s financial status.

Collaborated in a team of 7 efforted on IPO prospectus writing, including obtaining information from various sources, drafting, proofreading, typesetting, and creating PowerPoint presentations. Played a role in project’s success.

Performed online interviews with Chinese and foreign clients’ and distributors’ managers to facilitate business communication in both Chinese and English to learn about evaluations and suggestions to company to inform stakeholders on a better understanding of company’s situation. PROJECTS

Mazda Capstone Project 03/2023-06/2023

Improving automobile dealers’ performance included profitability and customer loyalty deploying service visits and customer loyalty data of Mazda in a team of 5 with data analytics by SQL statements written in Python, Machine Learning model building by Python, and visualization by Tableau.

Present outcomes to Mazda managers and supervisors with PowerPoint.

Serve as rotating leader.

S-Mobile Customer Churn Prediction 03/2023

Reviewed mobile company’s customer loyalty data in a team of 4 to improve company’s customer loyalty.

Built Logistic regression, Neural Network, and XGB Models to predict customers’ churn and compare models’ performance to select best through AUC value.

Provided feasible improvement suggestions by exploring importance of features and evaluating Customer Lifetime Value Analytics. Presented outcomes which lead a raise in 5 years CLV around $700 per customer to professors. Fake News Detection Project 03/2023

Built Logistic Regression, Naive Bayes Classifier, and linear SVM Classifier fraud detection models and tested combinations with text representation CountVectorizer, TF-IDF, and Word2Vec to find out best unstructured text fraud detection combination with F-1 score as a metric. The combination of TF-IDF, Logistic Regression and Unigrams+Bigrams is most effective method for task with an accuracy of 0.94. Snowflake SQL and Python Project 08/2022

Developed a virtual warehouse, database, schema, table, and inserted data in Snowflake.

Performed SQL statements written in Python and sent to Snowflake to extract, load, and transform data. SPECIALIZED SKILLS

Coding: Python (Advanced), SQL (Advanced), R (Advanced), Radiant (Advanced).

Tools: Bloomberg Reuters, Tableau (Advanced), Excel (Advanced), PowerPoint (Advanced), Word (Advanced).

Language: Mandarin (Native), English (Fluent), Japanese (Beginner).



Contact this candidate