About

Software proficiency, professional skills, and professional development.

Download my latest Resume here. Last update: March, 2020.

Software

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

Professional Development

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

Professional Skills

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.

• Completed market analysis and economic analysis reports for Spartanburg’s Highland Transformation Plan.

• 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.

Site Planning

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.

Market Analysis

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 Skills

Working with big data: retrieving big data using API calls.

R mapping, data manipulation, data visualization.

Marketing

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 Engagement

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.