GIS, Web Mapping
Resume:
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
*******@******.*****.***
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