Ruoxi (Roxy) Zhang
858-***-**** adkbse@r.postjobfree.com www.linkedin.com/in/ruoxi-roxy-zhang/ github.com/ruz023
Education
Master of Science in Business Analytics (STEM Designated), University of California, San Diego 10/2020 – 12/2021
●Relevant Courses: Customer Analytics; Business Analytics in Operations, Finance, and Marketing; Collecting and Analyzing Large Data; Working with Unstructured Data; Big Data Technology
●Courses to be taken before summer: Pricing Analytics; Fraud Analytics; Recommender System
Bachelors of Arts, Economics, Diplomacy & World Affairs, Occidental College, Los Angeles 08/2015 – 05/2015
●Young Initiative Grant on Global Economy (3500 USD), supporting summer 2016 internship in Spain
●1 of 18 participants selected for the Kahane United Nations Program (see Professional Experiences)
Projects
Customer Analytics: Ads Targetting 02/2021
●Predicted click-through rate for potential customers using neural network (Keras) and XGBoost
●Tuned hyperparameters using randomized search to maximize profit on unbalanced data set
●Achieved $400+K profit from targeting 225K+ potential customers
●Visualized model performance impacts using business metrics, such as lift and gains
ETL (Extract, Transfer, and Load) in Python/Pandas and Snowflake 01/2021 – Present
●Extracted insights on the causes for rejecting US patent applications
●Parsed and cleaned CSV, JSON file from USPTO REST API (Patent Examination Data System)
●Transformed cleaned data into Snowflake table, for scale and constant availability
●Compared and contrasted patent applications and applicants; summarized patterns using SQL queries
Social Network Analysis for ASCEND in San Diego 12/2020 – Present
●Constructed from scratch data tools for ASCEND, a female executives organization
●Automated data cleaning using Python scripts; provided critical feedback on survey design
●Built interactive R Shiny dashboard to visualize demographic patterns among ASCEND members
●Created social network graphs using dplyr, ggplot2, igraph, ggraph, visNetwork packages in R
●Presented advice for ASCEND's expansion to C-level executives who are members of ASCEND
Sentiment Analysis, Yelp Data Challenge 10/2020 – 12/2020
●Researched Las Vegan diners' preferences using 50K reviews from 2017-2019
●Cleaned, lemmatized, and encoded reviews into TF-IDF vectors
●Automated sentiment detection from reviews; implemented and cross-validated logistic regression and Naïve Bayes models in scikit-learn
●Extracted review themes using k-means clustering; summarized actionable advice for restaurant owners
Professional Experiences
Associate Risk Analyst, Beijing Enterprise Water Group (BEWG), Beijing, China 11/2018 – 08/2020
BEWG (HK 00371) is a world-leading water service provider present in 36 countries
●Safeguarded the company's financial legal rights by performing due diligence on dozens of contracts
●Advised million-dollar investment projects and contracts on financial/operational safety provisions
●Managed dozens of bi-weekly decision meetings on 100 million+ RMB investments
Consultant-Green Commodities Task Force, UNDP, New York City and San Jose, Costa Rica 09/2018 – 12/2018
●Worked with a five-member research team to analyze solutions relating to Costa Rica's pineapple production and its effects on forest and biodiversity loss
●Produced a 50-page outcome document now in use by UNDP Costa Rica country team to focus resources toward maintaining Costa Rica's pineapple production and export volume while minimizing environmental degradation
Skills
●Machine Learning Models: Linear/Logistic Regression, Naive Bayes, Random Forest, PCA, Neural Networks, XGBoost, K-Means Clustering
●Programming Stack: Python (scikit-learn, pandas), SQL), R (dplyr, ggplot2, shiny), Hadoop, PySpark, AWS
●Data Visualization Tools: Tableau