Academic Projects University of Pennsylvania Philadelphia, PA

• Performed raster overlay to calculate urban growth and development suitability in Philadelphia by ArcGIS which will present in 2019 Esri User Conference

• Calculated retail site suitability and trade area in Philadelphia using ArcGIS

• Programmed in ArcGIS with Python to establish a platform to analyze the relationship between the home sale price and house density in Philadelphia

• Uploaded sensors readings in chicago into an SQL database using SQLite3 and used imputation model to predict the readings using RStudio and designed a real-time web dashboard by R-Shiny and JavaScript;

• Predicted hedonic home price with linear regression model in Philadelphia using RStudio;

• Adopted poison model to analyze crime risk in Cincinnati by RStudio and created user interface (UI) about crime risk use case in Adobe XD

City Planner Shenzhen Urbanspace Planning & Architecture Design co., Ltd Shanghai, China

• Independently complited 4 projects and correlated compited over 6 projects, all of which including urban design, urban data analysis, control detailed planning and urban strategy research

• Developed a real-time dynamic heat map of Shenzhen City, and established an accurate collaborative filtering model to predict origin-destination flows of subway and bus electronic payment data of 36 stations by using ArcGIS, RStudio and JavaScript

• Designed paper and online questionnaires (over 2000), conducted field interviews, collected data and wrote "Public Facilities Planning in Jinjiang" report including data visualize through charts and tables using Microsoft Excel, which won the Excellent Work in the company

• Completed both 3.7 and 0.9 square kilometers of control detailed planning in the "Urban Design of Pilot Zone in Da Jiang Dong I ndustrial District, Hangzhou" project by using AutoCAD and ArcGIS, which carring First Prize in the competition

• Trained over 10 interns with Adobe Photoshop, Adobe Illustrator and Adobe Indesign City Planner-Joint Employment AS+P Architects Consulting (Shanghai) Co., Ltd Shanghai, China

• Conducted research into real estate policy initiatives, with particular emphasis on national programs and master plan

• Created design guidelines to positioning characteristics, design strategy and cartographic design principles in the "Urban Design for the Related Area of Zhoupu East Station of Metro 16, Pudong, Shanghai" Project which winning project of competition City Planner Tongji Urban Planning & Design Institute Shanghai, China

• Presented directly to business stakeholder, with responsibilities of research into the transformation strategies of industrial zone

• Used ArcGIS to develop a platform for visualizing buildings information in industrial zone

• Proposed land use strategy and modifued master plan using AutoCAD Intern Chongqing Urban Planning & Design Institute Chongqing, China

• Examined the balance of indicators of land-use and proposed improvements to unreasonable parts

• Analyzed on the site condition and recorded data collected University of Pennsylvania, Philadelphia, PA

Master of Urban Spatial Analytics

• PennDesign Scholarship of $5000 (2018)

• Coursework: Statistics, GIS, Web Mapping, Data Visualization, Machine Learning, Real Estate Investment Hunan City University, Hunan, China

Bachelor of City Planning

• Excellent Representative of Graduate (top 98%)

• Advised by Professor Xia Nankai, studied on “Analysis of Spatial Urban Structure of Central Shanghai through Twitter Checkin Data” using ArcGIS in Tongji University (2014) XIAOQI TANG

urban scientist with a focus on intersection of

spatial analysis and data visualization

215-***-****

ac81h6@r.postjobfree.com

2930 Chestnut Street, Apt 2309B, Philadelphia, PA 19104

• Portfolio Website: www.xiaoqitang.com

• Github: https://github.com/XiaoqiTang/Portfolio

EDUCATION

TECHNICAL SKILLS

EXPERIENCE

03/2015 - 06/2017

08/2018 - Present

June 2014

Expected May 2019

07/2015- 11/2015

07/2014 - 02/2015

07/2012 - 08/2012

Spatial Analysis: ArcGIS, QGIS, GeoDa, AutoCAD, Tableau Database: SQLite, PostgreSQL

Programming Languages:RStudio,JavaScript, Python, html, css Languages: Chinese (native), English

Design: Adobe Photoshop, Adobe Illustrator, Adobe

Indesign, Adobe Effects, Adobe XD, SketchUp, Final Cut Pro, DaVinci Resolvel, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Keynote, Microsoft Outlook

Contact this candidate