Ziyue (Zoe) Wang
*** ***** ***** *****, ****** City, NJ 07310 646-***-**** adcdgf@r.postjobfree.com
EDUCATION
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
INTERNSHIP EXPERIENCE
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
SOHU.com, 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