Data Analyst

Zhaodi Wang

**** **** ******, ***. *****, Philadelphia, PA 19131 ************@*****.*** 215-***-****

EDUCATION

Drexel University, LeBow College of Business Philadelphia, PA

MS in Business Analytics, MIS Concentration Sept.2015-Dec.2016

Relevant Courses: Hadoop and MapReduce, Operations Research, Data Mining, Analytics with Relational

Database Data, Database Design, Applied Regression Analysis, Advanced Program SAS.

Dongbei University of Finance and Economics Dalian, China

BE in Applied Statistics Sept.2011-June 2015

Relevant Courses: Linear Algebra, Probability and Statistical Inference, Optimization Method, Mathematical

Statistics, Method of Multivariate Analysis.

PROFESSIONAL EXPERIENCE

Technical Support Analyst, LT Security Aug. 2017-Present

Provided end to end support for vendors and installers with issues of LTS surveillance product line.

Cleaned and analyzed the call center database in Excel and SQL server to help sales department find out the potential customers and increase the efficiency of responding the inquires by using Excel and Tableau.

Collected the data from ticket system and analyzed the common categories of issues that customers will encounter and report it to product management department to improve the products.

Responsible for data entry and maintenance of ticket system and manipulated GB sized data using Excel.

Performed interactive dashboard based on the result of analyzing the different database with Excel and Tableau and reported to IT, PM and Sales department’s manager weekly.

Data Analyst, Wanda Group July 2014-Sept.2014

Investigated and analyzed overall status and performance of real estate business in Jiamusi, Heilongjiang, China.

Collected housing data from internal databases, local real estate companies, governmental bureaus, and multiple websites.

Cleaned 30 GB data and prepared the desired dataset for analysis by using PROC SQL in SAS.

Performed predictive model in SAS to predict the apartments and houses’ market price and the future sale performance.

Implemented data visualization and calculated statistical measures in SAS and Tableau.

Finished a highly-acclaimed report: Market Research of Jiamusi’s Real Estate Business in 2014 and presented in Marketing Research Department Town hall meeting.

Data Analyst, Jiamusi Statistical Bureau July 2013-Sept.2013

Analyzed Jiamusi, China third-quarter economic accounting data in 2013.

Participated in the 3rd China National Economic Census and collected data from enterprises on site.

Updated daily incoming data to the existing database, created new databases, tables and views to support the information needs for the report by writing SQL queries in SQL server.

Extracted data from multiple sources and manipulated up to 150GB data into the standard format for the searchable database by using Excel.

PROJECT EXPERIENCE

YouTube Video Categories Analysis Mar.2016-June 2016

Sought to identify the most popular categories of videos on YouTube. Provided suggestions to YouTubers and advertisers to gain more attention and increase profit.

Obtained 11GB sized dataset from YouTube Data API by applying Web Crawler in Python.

Defined mapper, reducer and driver class for Hadoop MapReduce in Python language.

Mined YouTube dataset in Hadoop MapReduce and outputted lists of top 10 categories by kinds of attributes including total views, average rating, and number of uploaders.

Identified the most popular keyword in each category by text mining TF-IDF weighting scheme in Hadoop.

Portfolio Optimization Jan.2016-Mar.2016

Performed analysis to conduct an optimal portfolio to maximize the expected return under certain risk level and customer’s requirements.

Gathered around 2000 stocks data from Yahoo Finance by employing Web Crawler in R.

Cleaned dataset using Excel and Proc SQL in SAS.

Applied Linear Optimization model to create portfolios from more than 2000 stocks with multiple constraints to

raise expected return and satisfy the customer’s requirements using SAS coding.

SKILLS

Certification: SAS Certified Base Programmer for SAS 9, Six Sigma Yellow Belt Training

Software: MS SQL Server, MS Access, Tableau, Advanced Excel, PowerPoint, Virtual box

Programming: SAS, Python, R, Hadoop, SQL

Contact this candidate