Data Analyst

YANCHAO XU

*** ***** **, *** ***, Brooklyn, NY, *1217

******@***.***

(917) 373 – 0161

Education

****/* – 2016/7

NEW YORK UNIVERSITY

New York, NY

Center for Urban Science and Progress GPA: 3.46/4

Master of Science in Urban Informatics

Specialization: Civic Analytics

Coursework: Urban Decision Models, Urban Spatial Analytics, Machine Learning, Urban Informatics

2011/9 – 2015/5

UNIVERSITY OF ALBERTA

Edmonton, Canada

Bachelor of Arts: Economics GPA: 3.1/4

Bachelor of Arts (Minor): Political Science

Experience

2014/7 – 2014/8

HANGZHOU AUWHERE TECHNOLOGY CO., LTD

Hangzhou, China

Sales Intern

- Market researching, estimating market potential

-Sales data collection and analysis, sales decision making

2013/7 – 2013/8

GUANGSHA CONSTRUCTION GROUP CO., LTD

Hangzhou, China

Assistant Secretary

-Using Excel’s advanced application to calculate indicators to estimate program’s cost and profit

-Conducting trend analysis and drafted report to estimate the impact of the construction programs

2012/7 - 2012/8

GUANGSHA HOLDING GROUP CO., LTD

Hangzhou, China

Assistant Secretary

-Analyzed and evaluated the output, outcome and impact of the initiative

-Business data collection and analysis, advisement to decision making and cost accounting

2012/5 – 2012/6

ZHEJIANG DONGYANG THIRD CONSTRUCTION ENGINEERING CO., LTD

Dongyang, China

Assistant Secretary

-Conducted empirical report on cost accounting and risk managing

-Using R to analyzing historical data

Extracurricular Activities

2012/9 - 2014/5

Member of Chinese Students and Scholars Association in University of Alberta

-Held events and initiated routine meetings and discussions

Research

GIS Project November – December 2015

-Analyzed hospital accessibility and distribution in New York using ArcGIS

-Network analysis on public medical facilities and bed space capacity analysis

Machine Learning Project March – May 2016

- Predicting crime level in Queens through studying business units, housing values and demographic features in terms of census block groups using machine learning techniques

Capstone Project April – July 2016

- Worked with NYC 311 Agency and analyzed the impacts of socio-economic and spatial characteristics on 311 service request in NYC neighborhoods

Proficient in Excel Solver and Monte-Carlo simulation, R and RStudio, SHAZAM, ArcGIS, Python, SUMO. Basic knowledge in SQL and Tableau.

Computers

Languages

English (Full Proficiency) and Chinese (Native).

Contact this candidate