Resume

Technical Skills

  • Programming Languages: Python, HTML, CSS, JavaScript, R Studio, PostGIS & PostgreSQL
  • Geospatial Libraries: Geopandas, GDAL, Geemap, NetworkX OpenStreetMaps (OSMnx), Arcpy, Shapely, Leaflet, D3, Mapbox, Vue.js
  • Software Tools: ArcGIS Pro, ArcMap Desktop, Adobe Illustrator, Adobe Photoshop, AutoCAD, Google Earth Pro, GitHub, MapBox, QGIS, MS Office Tools

    • Experience

    Graduate Teaching Assistant, Dept of Geography

    Sep 2023 - Dec 2023

    • Under the guidance of Prof. Zhu Axing, use ArcGIS Pro to teach students the practical course of Geog 377: Introduction to Geographic Information Systems (GIS).

    Intern GIS Developer, Zhengyuan Aerial Remote Sensing Technology Co., LTD.

    May 2023 - Sep 2023

    • Use PostgreSQL to create a road database, classify and import data into database, and maintain database and process data and publish online, convert between different data type such as udbx, json, shp, dwg, etc.
    • Assist in designing and development of front-end interface and be responsible for the optimization of the user interface and implementation of interaction logic to improve user experience and interactive effects.

    Research Assistant, GeoDSLab@UW-Madison

    Sep 2022 - May 2023

    • Data Algorithms: using Python to extract and aggregate data for research in geospatial data science, machine learning, and remote sensing.
    • Data Analysis: using python or R to analyze the data, e.g., random forest, regression, and k-s test.
    • Resilience Analysis: using OSMnx from Python to analyze network resilience during flooding events.

    Intern GIS Specialist, Haitian Dianxin Technology co., LTD, Yantai, China

    Mar 2020 - Sep 2020

    • Data Capture: Use ArcGIS to build spatial database and perform data capture and editing tasks such as digitizing maps, converting data formats and georeferencing images.
    • Spatial Analysis: Analysis of vector data for using GIS tools to identify patterns, trends and relationship.
    • Model Building: Assisted in development of spatial model that predict location of future land use change.

    Education

    University of Wisconsin-Madison

    Jan 2022 - Dec 2023

    Master of Science in GIS & Cartography, GPA: 3.85*

    • Course: Geographic Information System, Advanced Quantitative Methods, Advanced Geocomputing Geospatial Big Data Analytics, Geospatial Web and Mobile Programming, Geospatial Database Design and Development

    Arizona State University

    May 2020 - Dec 2021

    Bachelor of Science in Urban Planning, GPA: 3.96*

    • Course: Geographic Info Science; Stats for Geography & Planning; Planning Methods

    Project Experience

    Wisconsin Hospital Resources Distribution Analysis & Database Design

    • Used ERDPlus to create the ER-Diagram, created the relational table for each entities in pgAdmin 4.
    • Data organizing and importing to pgAdmin 4, showing the fairness of data distribution by analyzing data.

    Analyzing the Importance of Variables Affecting Chicago's Crime Rate

    • Use R to perform multiple linear regression analysis on crime data to find correlations between variables, and use a random forest model to find important variables for Chicago's high crime rate.
    • Intergrate different types of crime data into census tracts using tools such as Python, GeoPandas, and more. Access report PDF Icon

    Evaluating the resiliency index of the road network under flood conditions in Madison, Wisconsin

    • Use the OSMnx package and Google Map API in Python to load Madison area road-related data and perform spatial road analysis.
    • Select two representative areas in the road network. The performance of the road network was assessed by comparing the connectivity and efficiency indices of roads between the two regions before and after flooding.
    • The road betweenness centrality was calculated and the relevant data of the top 2% roads ranked by influence were deleted, and the conclusion was drawn that water level rises exceeding 1.49m would have a greater impact on the road network.

    For a PDF/Download version of resume, please click here - Dong Gai Resume PDF Icon