Sign in

Data Analyst

Hoboken, NJ
March 19, 2020

Contact this candidate


Ziyue (Zoe) Wang

*** ***** ***** *****, ****** City, NJ 07310 646-***-****


New York University, New York, NY 09/2018-05/2020 Master of Science, Database Technologies

Relevant Coursework: Data Mining and Data Warehousing, Managing Big Data, Data Analytics and Visualization

Capital Normal University, Beijing, China 09/2014-06/2018 Bachelor of Economics, International Economics


Universal Processing, New York, NY 09/2019-01/2020 Data Analyst Intern

Implemented large data sets cleaning and standardization using R and Python, built web crawler for business leads generation, and imported over 100,000 pieces of valid and reliable leads

Excuted Excel and Google sheets functions, such as VLOOKUP, IMPORTRANGE, to automatically synchronize, monitored accuracy of data entry, and updated department daily work log

Optimized database schema, boosted speed of data extraction and data filtering

Conducted demographic analysis, industry analysis, user behavior analysis to find potential customer locations

TalkingData, Beijing, China 06/2019-09/2019

Data Analyst Intern

Queried and extracted data from database, cleaned and filtered data to improve data quality, visualized processing results

Conducted factor analysis, principal component analysis (PCA), and built related models for price forecasting

Released user portrait, user behavior analysis, price forecasting reports and store location assessment according to data analysis results

Deutsche Telekom AG, Beijing, China 12/2018-02/2019 Automotive Consulting Intern

Collated daily automotive industry news, issued daily briefing within department

Supported project data collection, market research and user interviews for application launch and improvement

Participated in product and administrator platform testing, tested application operating system, wrote administrator manual

Conducted multidimensional data analysis, visualized and presented analysis results using R and PowerPoint

China Galaxy Securities, Beijing, China 02/2017-04/2017 Investment Management Intern

Collected daily bulletin and relevant news of public companies, reviewed and collated information data such as quarterly and annual financial reports

Drafted analysis reports of public company based on data summary and statistical analysis

Participated in departmental meetings, and delivered presentations on Chinese liquor industry, Beijing, China 08/2016-03/2017

Finance Intern

Scrutinized contracts and updated company qualification materials using proficiently Oracle Customer Relationship Management system

Organized and sorted dispatch lists, verified accuracy of invoice amount and overdue reimbursement applications

Issued special VAT invoices and lists using Golden tax software, conducted monthly copy duty and declared taxation RESEARCH EXPERIENCE

NYPD Complaints and Crimes Analysis 09/2019-01/2020

Obtained data from NYC Opendata, standardized data and built logical model using Oracle Data Modeler

Created connection from Oracle sql developer to Tableau, imported data sets and defined data availability

Visualized location, time, race and sex analysis and description of complaints and crime in NYC using Tableau SKILLS

Language: Native in Mandarin, Fluent in English

Leadership: Director of Capital Normal University Outreach Department Software: SQL, Python, R, MySQL, Oracle, Tableau, SPSS, Microsoft Office, EViews, Lingo

Contact this candidate