Download my latest Resume here. Last update: March, 2020.
Modelling and Visualization Rhino, Grasshopper, Sketchup, AutoCAD, V-ray, 3dsMAX
Graphic Photoshop, Illustrator, InDesign
Mapping ArcMap, ArcGIS Pro, ArcGIS Urban, Esri City Engine, Erdas Imagine, QGIS
Data Management ArcGIS Server, ArcSDE, PostgreSQL
Data Processing Tableau, SPSS, RStudio, Access, Advanced Excel
Application and Web Development Markdown, CSS, HTML, Shiny, Python
American Planning Association
Enrolled in AICP Pilot Program.
Student Planning Association of Georgia Tech
May 2018 to April 2019 Board Member: Webmaster
Managed the SPA website, created multi-media marketing materials, organized poster trainings.
Georgia Planning Association Spring Conference 2019
Session Presenter: Emerging Voices: Analyzing and Visualizing Transportation Issues Around Atlanta
APA National Planning Conference 2019
Poster Presentation: Analyzing Bikeshare Activity Using Bing Map API
I worked as the GIS Planner at APD Urban Planning and Management from July 2019 to March 2020.These are my work highlights when working at APD:
• Developed site plans, master plans, and renderings for community revitalization at various cities (Florence SC, Houston TX, Cincinnati, OH, Spartanburg SC) using both architectural path (AutoCAD, Sketchup, Adobe CC) and GIS path (ArcGIS Pro, ArcGIS Urban, City Engine).
• Manages the GIS database and server: using ArcSDE, ArcGIS Server, and PostgreSQL to host GIS data and online maps with multiple query options and layers.
• Sought to automate APD-U’s analysis work using various tools and coding scripts. Automated the housing supply and demand gap analysis process and multi-level Census data downloading process.
• Project management role of Westside Future Fund Mapping Task.
The following descriptions are my prfossional skills at work. You can click on the links for work samples.
Creating site plans for neighborhood development from the level of street block to neighborhood. Designing parking lots that accommodate maximum parking spaces; Designing landscape, and street section.
Example: APDU Historic Third Ward Project. (Responsibilities: Site plan and design for three pilot projects and financing, cost estimates, funding sources, and capacity building recommendations.)
Architectural Design and Rendering
Rendering CAD and GIS drawings for site plan, building plan, elevation, and section.
Generating perspective renderings of buildings and neighborhoods.
Example: click here.
GIS and Mapping
Example: APDU GIS Workflow Case Study. (Responsibilities: all items included in the case study.)
Integrating GIS with design workflow using AutoCad, Adobe, Sketchup, Rhino.
Existing condition and suitability analysis. Site planning and modelling using ArcGIS Pro.
Working with ArcGIS Online,ArcGIS Server, Portal, PostgreSQL, and RStudio.
Organizational data management.
Financial analysis and creating Pro Forma.
Financial analysis under different Low-Income Housing Tax Credit (LIHTC) scenarios: 9% and 4%. Calculate development budget, construction loans, cash flow based on development program.
Residential market analysis looking at home owners, renters, recent sales and permits, and socioeconomic indicators. Example: Spartanburg Highland Neighborhood Transformation Plan Market Analysis.
R mapping, data manipulation, data visualization.
Website Managing using website platform and Markdown language.
Flyers, banners, brochures. Story maps. Example1: APDU Florence Project (flyers, news letters). Example2: City of Florence (flyers, renderings).
Community Meeting Preparation: prepare boards, posters, cards, handouts, etc.
Community Meetings: help with signing in, direct exercises, collect input. Example: Spartanburg SC Highland Community Open House news report video.
Community meeting output analysis: translating boards/conversations to report.
Existing Condition Review
Land use and zoning condition analysis. (Responsibilities: current project lead for Westside Future Fund mapping requests.)
Future land use analysis.
Previous plans and upcoming projects scan.
Field Data Collection
Build apps and dashboards in ESRI to monitor field data collection.
Collect housing characteristics by field works.