Wenrui Xie

Brooklyn, NY ***** 347-***-**** adg4ol@r.postjobfree.com www.linkedin.com/in/wenrui-xie EDUCATION

New York University Tandon School of Engineering Brooklyn, NY Master of Science, Computer Engineering Sep 2018—May 2020 GPA: 3.55/4.0

Relevant Courses: Machine Learning, Data Mining, Big Data, Forecast Time Series Data, Visual Analytics Beijing University of Posts and Telecommunications Beijing, China Bachelor of Management, E-commerce Engineering with Law Sep 2014—June 2018 GPA: 3.52/4.0

Relevant Courses: Database Management Systems, Python, Probability and Statistics, Numerical Linear Algebra TECHINICAL SKILLS

Python (Pandas, NumPy, Scikit-learn, Matplotlib, Seaborn), R, SQL, Microsoft Office, Java, C/C++, PHP, HTML, JavaScript, CSS

WORKING EXPERIENCE

Gugnir & Partners New York, NY

Data Analyst Intern Feb 2020—June 2020

Annual food ingredients data modeling and visualization (Python,R Shiny)

• Initialized data ETL process and life cycle development with data engineers; Applied Python cleaning and merging structured datasets by the country, month and category

• Generated segmentation models using K-means clustering and performed hypothesis testing based on the importance of main features

• Achieved data visualization by creating an interactive web app using R Shiny; Built heatmaps, pie charts and histograms for top 10 importers and export countries per ingredient over time

• Composed an aggregated report and proposed the optimal budget plan for the client by descriptive statistics analysis

Web scraper of maltodextrin suppliers (Python, MySQL)

• Steered Python with Selenium and BeautifulSoup libraries to scrape the business and product data of maltodextrin suppliers via Alibaba, parsed and stored HTML context into MySQL database

• Filled missing values and accomplished visual analysis of seller's products and business information by using Python Matplotlib

• Documented purchase regulations and counseled plan’s legitimacy with the compliance department MOYI Inc New York, NY

Data Analyst Intern Oct 2019—Dec 2019

Index of housing price analytics and prediction (Python,R)

• Leveraged Python to preprocess millions of pieces of raw data including missing imputation and feature standardization

• Trained supervised machine learning models by staking involving Linear Regression, Random Forests on statistically significant factors to predict price of Commercial Real Estate

• Managed and executed the successful delivery of algorithms to meet business needs, assisted data scientists to devise different transformation functions to refine the accuracy of models by 15%

• Customized forecast reports and described the precision and deviation in weekly group meetings Speechocean Corporation Ltd Beijing, China

Intern Sep 2017—Dec 2017

Company working platform development (PHP, MySQL)

• Developed the project reimbursement section of internal contracts in the company's web system

• Used the Blade module of PHP Laravel frame’s MVC mode to implement modules, adding records, particulars, editing, and deleting functions for employees with different permission

• Improved platform security by preventing SQL infusion, defending XSS and CSRF attack

Contact this candidate