Data Analyst

Melody Zhu

Phone: 646-***-**** Email:*************@*****.***

LinkedIn: www.linkedin.com/in/guanwen-melody-zhu

Employment Status: OPT 3-Years

SUMMARY

Data analyst with nearly 1 year’s full-time work experience; capable of R & Python based data analysis, SQL, and Tableau-based data visualization. Able to create product vision, analyze business performance, and turn data into actionable solutions for the clients.

SKILLS & INTERESTS

Programming Language & Tools: R, Python (Pandas, Numpy), SQL (MySQL, MS SQL) Tools: Tableau, Power BI, Advanced Excel (VBA, Pivot Table, Vlookup), Matplotlib, Basic Cassandra, Basic MongoDB Other Skills: Predictive Analytics, Machine Learning (Random Forest – basic), Data Visualization, Data Mining, Experimental Design, A/B Testing, Exploratory Data Analytics, DCF Modeling, Google Cloud Platform WORKING EXPERIENCES

Data Analyst (Full-Time/Contractor), Walmart, Changchun, China Jul 2018 Jul 2019

• Performed sales analysis & data cleaning on datasets of 10k+ rows using SQL to predict the trend of product sales

• Employed data mining (market basket analysis) to optimize product placement using R, resulting in 10% increase in sales

• Conducted data visualization of sales based on which Walmart can adjust its inventory strategy for different combinations of products using Tableau, growing revenue by 15%

• Implemented text analysis by text mining using R to collect information from surveys & customer data, enabling Walmart to adjust its current strategy, leading to a 10% efficiency improvement Data Analyst (Intern), China Merchants Securities Co., Lt, Shanghai, China May 2017 - Aug 2017 CMS is a Chinese state-owned company, part of China Merchants Group, a Fortune Global 500 Firm

• Gathered and synthesized financial data of about 10 companies via SQL, cleaned the data via Python Pandas, and built prediction model in R (linear regression model), saving 50% of human hours

• Conducted correlation analysis of portfolios with different combinations of securities using R, and used the data to recommend specific portfolios to clients, resulting in a 30% increase in sales

• Inserted & analyzed company data; accounts, profit and loss sheets, and cash flow information via Advanced Excel

• Wrote 10+ industrial research reports using analytics data, and visualized & presented the results using Tableau PROJECTS & RESEARCH

Columbia University Capstone Project: Analytics of Vertoe Expansion (R, Python) Summer 2020 Vertoe is America's first highly rated daily luggage and short-term storage provider nearby

• Devised geographical expansion for Vertoe’s storage service using user data; drew geographical maps to visualize Vertoe’s locations using Python, saving 98% of human hours and growing revenue by 10%

• Employed R to clean and analyze a dataset of 10k+ rows, and presented the result to the whole class Columbia University Course Project: Expanded NoSQL Database (MongoDB, Cassandra, Python) Spring 2020

• Manually created databases and found related information using basic MongoDB and Cassandra

• Implemented pymongo to import MongoClient using Python, enabling a quicker finding of relevant data Kaggle Competition: Predicting Airbnb Rental Price - Top 5% ranking (R) Fall 2019

• Used R to construct ML models such as random forest and gradient boosting to predict the price of a set of Airbnb rentals using supplied dataset with 90 variables for over 35,000 Airbnb rentals in New York

• Employed business intuition and feature selection (Stepwise Variable Selection) to select the most significant variables, reducing the RMSE by 20% and exceeding class average of 85% EDUCATION

Columbia University, New York, NY Aug 2019 – Dec 2020 Master of Science in Applied Analytics (STEM) Term GPA: 4.0/4.0 Courses: Applied Analytics Frameworks & Methods I, II (R), Python for Data Analysis (Python), Experiment Design, Storytelling with Data (Tableau), Machine Learning, Managing Data (Cassandra, MongoDB, SQL) Rutgers University, Newark, New Jersey (Joint-Institute with separate diplomas) Aug 2015 May 2019 Northeast Normal University, Changchun, Jilin, China Aug 2015 May 2019 Bachelor of Science in Finance Cumulative GPA: 3.81/4.0 Honors: Scholarship for Academic Work and Endeavor (5%, 2015), First Prize Scholarship (8%, 2016), Excellent Student Award (10%, 2016&2017), Social Practice Award (5%, 2016), Dean’s Scholarship (5%, 2017) Courses: Calculus, Statistical Methods, Linear Algebra B, Theory of Probability and Mathematical Statistics

Contact this candidate