Data Analyst, Business Analyst

Xuan Wang

***********@*****.***, San Jose, CA ***12, 626-***-****

www.linkedin.com/in/xuan-zoe-wang, https://github.com/xwang86/scu-projects EDUCATION

Santa Clara University, Leavey School of Business Santa Clara, CA Master of Science in Business Analytics GPA: 3.7/4.0 March 2020

● Relevant courseworks: Data Science Analysis with Python, Machine Learning with Python & R, Marketing Analysis, Deep Learning, Big Data Analytics, Data Visualization, Database Management Systems, Applied Cloud Computing, Econometrics with R

● Merit-based scholarship recipient 2018 - 2019

University of California, Los Angeles Los Angeles, CA Bachelor of Arts in Economics, Minor in Asian Language & Culture December 2016

● Core classes: Statistics, Econometrics, Calculus, Money and Banking, Real Estate Finance & Investment, Intermediate Accounting TECHNICAL SKILLS

● Programming: Python (Panda, Numpy, Seaborn, scikit-learn), R (shiny, ggplot2), MySQL, SQL Server

● Scientific: Machine Learning (Supervised/Unsupervised Learning, Classification, Decision Tree, Random Forest, K-Means Clustering, Regression, Bayes, SVM), Deep Learning (Keras, Tensorflow), Big Data (MapReduce, Hadoop, PySpark), Hypothesis Testing, Natural Language Processing, A/B Testing, Data Visualization (Tableau, Matplotlib, Seaborn)

● Tools: MySQL Workbench, Tableau, Jupyter Notebook, AWS, R Studio, Google Analytics, Github, Anaconda, Advanced Excel EXPERIENCE

3T Biosciences Menlo Park, CA

Data Analyst Intern June 2019 - December 2019

● Manipulated and cleaned different datasets using Python, and developed quality control scripts to ensure the cleanliness of data

● Developed user interface using R Shiny for reading and filtering data in MySQL database and hosted them on AWS

● Utilized Python, SQL and Tableau to conduct detailed analysis, and generated data visualization related to the company research Atlassian Mountain View, CA

Data Science Practicum January 2019 - June 2019

● Collaborated with company’s data scientists and engineers to define business requirement of their ecommerce SaaS products

● Explored several clickstream datasets and conducted feature engineering to explore certain customers’ behaviors related to whether they sign up for free trials of multiple products Assured Management Cerritos, CA

Treasury and Accounting Analyst March 2017 - February 2018

● Performed bookkeeping with QuickBooks and excel; generated monthly profit reports & bank reconciliation reports

● Assisted in real estate budget control and monitored financial activities during construction processes

● Processed checks, credit card payments, and wire transfers to vendors and from tenants American Honda Finance Corporation Torrance, CA

Treasury Analyst Intern July 2016 - September 2016

● Created records of trades and rates in debt of record system daily

● Produced upcoming payment reports and confirmed with multiple banks related to payment and accuracy of trades ACADEMIC PROJECTS

Home Mortgage Approval Prediction in Python June 2019

● Sampled and cleaned 1% of Home Mortgage Disclosure Act Data (1992-2015), resulting in 7 million clean records to process

● Created several machine learning models to predict if a loan could be approved, with accuracy of 90%

● Examined the data bias effects on previous models and built fairness-aware models to reduce bias, with accuracy of 89% Telecom Churn Prediction Machine Learning Project in Python March 2019

● Performed data cleaning/preparation including missing values handling

● Created customer segmentation to discover behavior patterns of customers by using K-means Clustering

● Developed predictive models for customer churn using Decision Tree, Random Forest and Classification SF Bay Area Shared Bike Data Visualization Analysis Using Tableau March 2019

● Cleaned and aggregated data for the data visualization using python

● Collaborated with team members to assess the daily usage of shared bike and explored factors affecting the shared bike usage by plotting different graphs and creating dashboards in Tableau; proposed recommendation for future business improvement Hotel Reservation Database in MySQL March 2019

● Designed ER diagrams and produced Data Models for hotel reservation system

● Developed MySQL queries, triggers, functions and procedures based on business requirements ADDITIONAL INFORMATION

Volunteer: prepared food for homeless people at LA Homeless Shelter; assisted registration & set up booths for athletes in marathon Languages: fluent in Mandarin

Contact this candidate