Data Analyst Python

MENGYUAN (CHRISTY) REN

*** ****** *****, **. *****, MO 63130

314-***-**** www.linkedin.com/in/mengyuan-christy-ren **********@*****.*** EDUCATION

WASHINGTON UNIVERSITY IN SAINT LOUIS, St. Louis, MO December 2019 - Now Master of Science in Analytics

• GPA: 3.9/4.0 GRE Quant: 170/170

• Degree qualifies for a STEM designation; eligible for 36 months of OPT (12 months OPT+ 24 months of extension) BEIJING FOREIGN STUDIES UNIVERSITY, Beijing, China September 2015 - June 2019 Bachelor of Economics Minor in Computer Science

• Overall GPA: 3.70/4.00

UNIVERSITAT DE BARCELONA, Barcelona, Spain September 2017 - January 2018 Exchange Student, fully funded by China Scholarship Council PROFESSIONAL SKILLS

- Programming Languages & Data Structures & Algorithms Java, Python, Matlab

- Machine Learning & Data Mining Python (Numpy, Pandas, Scikit-learn, NTLK, Tensorflow, Keras, Jupyter Notebook, PyCharm) R

(dplyr, tidyverse, Logistic Regression, Decision Trees, RandomForest, Xgboost, SVM, NN, Markdown) Text Mining

- Big Data and Cloud Computing Spark, Hadoop, MapReduce, Impala, Hive, AWS, Linux, Cloudera, SAS

- Database Management MySQL, Tableau, NoSQL(Docker, Redis)

- Data Visualization Tableau, ggplot2, HTML, CSS, D3, JavaScript PROJECTS

Los Angeles Airbnb Data Analysis Project November 2019 - December 2019

• Fitted a Decision Tree and a Random Forest with Sklean to find amenities and description sentiments that lead to success

• Manipulated listings and reviews data using Python - Sqldf, Pandas, Numpy and visualized data using NLTK, Matplotlib

• Recommended the most potential zones to run an Airbnb business by visualizing the listings with Plotly 2019 Kaggle Data Science Bowl December 2019 - January 2020

• Explored the features with Python Jupyter Notebook to help measure how young children learn in the data from an app

• Built a baseline model and two LightGBM models for feature engineering and ranked 26% among 3497 teams Beijing Livestock and Poultry Information Inquiry System February 2019 – June 2019

• Brief Introduction: The system helps to find the farms in the area with a radius of 3 kilometers. Filtering by conditions, ] different color layers are shown in the map to distinguish the farms in different districts. The query results can be exported to Excel. Detailed information of the farm can be sent to mobile phone, which facilitate driving navigation.

• The project is built with Spring Boot, using Spring + SpringMVC + Mybatis, Mysql as database, Maven for management and Git for version control. The front end applies Bootstrap and Thymeleaf. Baidu maps is used for map control, and displays map without refreshing through Ajax. Used Alibaba Cloud as server, and SMS services as applications.

• Responsible for designing databases according to requirements, dynamic query and front-end development. EXPERIENCE

Royal Canin, St. Louis, MO January 2020 - Present

Data Analyst, Center for Experiment Learning Practicum

• Aggregated data with Python, R, Tableau, established customer segments and built descriptive & predictive models with 8- year Royal Canin's sales and product data from channel partners of over a million rows

• Wrote an algorithm to detect and update the average number of pet food subscription orders, visualized result in tableau and updated the average pet food subscription orders with sales and product data from channel partners

• Derived insights about customer lifetime value, retention rate, opportunities, trends for different pet food products ChinaAMC Funds, Beijing, China August 2018 - October 2018 Quantitative Analyst, Research Department

• Analyzed with Stata and Python the effect of large purchase announcement of 192 companies on Shanghai and Shenzhen Stock Exchanges using event study method, concerning over 484000 rows of stock price data

• Advised investors on the market effect of the Chinese stock market large buyout and drafted quantitative reports ACTIVITIES/INTERESTS

Youth League General Branch at Student Union September 2015 - June 2017

• Organized “Multicultural Festival”, “New Powers Competition” and volunteered in APEX Innovation Business Competition Support Education at Charity Primary School September 2015 - December 2015

• Led a group of 10 volunteers to teach at the Beijing Swan Charity School in Beijing suburb Interests: Pipa (Chinese lute, Level 10, the highest level for amateurs); Tai Chi (National Level 2 Athlete) Languages: English(Fluent), Chinese(Native), Spanish(No.1 in Spanish Certified Exam), Catalan, Greek

Contact this candidate