SUMMARY

• Currently building .NET add-ins for ArcGIS Desktop using vb.net and ArcObjects
• Six years experience with GIS applications in watershed modeling / transportation planning using ArcGIS 10.1 Spatial Analyst and SWFWMD-ArcHydro.
• Python GIS programming experience including ArcPy raster / vector data geoprocessing workflow automation and interface development between ArcGIS and H H models such as HC-SWMM.
• Python written multi-tasking applications in topo-bathymetric LiDAR mapping using modules such as laspy numpy struct pyproj gdal osr threading Queue Tkinter ttk gc py2exe shutil and logging.

PROFESSIONAL EXPERIENCE

Confidential

GIS Analyst III / ArcObjects Programmer

Currently developing an editing tool for address point data which is an ArcObjects-VB.NET add-in for ArcGIS desktop. The tool is intended to be hosted by city GIS staff to facilitate the creation and maintenance of an authoritative data for addresses. The tool is available for free to be installed and hosted by city GIS staff that wish to aggregate address point data for inclusion in a city wide SDE geodatabase.

Confidential

Remote Sensing Applications Developer

Responsibilities Developed software for remote sensing applications primarily airborne LiDAR. Also developed desktop GIS applications on engineering and technology projects for federal and state agencies.

Confidential

Senior Associate Engineer II

Responsibilities Developed tools to automate different hydrologic and hydraulic workflows for watershed management plan WMP projects using Python and VBA such as a best management practice assessment tool a time of concentration calculation tool a Pipe Flow Direction Tracking Tool and a hydrograph plotting tool within and outside ESRI GIS environment Developed an ASP.NET 4x based data driven web site using C HTML5/CSS/JavaScript/AJAX.

Confidential

On-site Engineering Contractor

Responsibilities Set up stormwater management master plan in both GIS and ICPR as well as calculated floodplain compensation volumes based on the modeling results delineated basins using ESRI ArcHydro Toolset reviewed QA/QC numerous WMP submittals at SWFWMD including checking watershed delineation and characterization ICPR modeling key parameters such as TC DCIA CN runoff calculation using SCS/Green-Ampt percolation input and floodplain delineation.

Confidential

GIS Analyst

Responsibilities GIS supported both Florida and Idaho Department of Transportation facility inventory projects which includes designing the data dictionary for the GPS units compiling and converting the field data from GPS to GIS format using GPS Pathfinder Office software GIS supported the corridor alternative analysis process to verify the most environmental preferred alternative for FDOT transportation improvements which includes map production impact quantification as well as geoprocessing workflow automation using Python.

PROJECT EXPERIENCE HIGHLIGHTS

GIS Programming

• Refraction Correction Tool In order to minimize the systematic error caused by the refraction of the laser light at the water surface for topo-bathymetric LiDAR data processing this Python written multi-tasking application in Remote Sensing was developed using modules such as laspy numpy struct pyproj gdal osr threading Queue Tkinter ttk gc py2exe shutil and logging. This tool consists of a LiDAR point classification module a refraction correction optical calculation module input and output data pre- and post-processors and three GUIs. Three GUIs were developed to improve the efficiency of LiDAR data processing. Particularly the second GUI with a progress bar indicating the data processing status is the main program running in the foreground while heavy-duty calculation tasks running in the background at the same time. Both the actual concurrency and data sharing between parallel tasks were accomplished through Python s multiprocessing technique threading together with the Queue module to provide inter-thread communication and coordination. Please refer to the attached word document rc GUIs.doc for GUI samples.
• Online Pipe Review QA/QC System This is a dynamic web application built in ASP.NET 4.5 and Visual
• Studio 2012 through client-side scripting HTML5/CSS/AJAX/JavaScript and server-side coding C . The connection between webforms and the SQL server database is established through ADO.NET.
• Pipe Flow Direction Tracking Tool for sewer collection systems using Python 2.7 within ArcGIS 10.1 The objective of this tool is to ensure that the continuity of the sewer system is correct by checking the direction in which line pipe features have been digitized. In other words the tool ensures that pipes are digitized in such a way that they are not all moving toward the same point manhole when exactly one pipe should be digitized away from the point.
• Methodology key points 1 construct pipe FromID and ToID based on x y coordinates extracted from first and last vertices of pipe line segments 2 loop through the pipeline network 3 flip the pipe when two connected pipes share the same FromID and have different ToIDs.
• Best Management Practices Assessment Tool This integrated GIS tool was implemented using ArcGIS 10 ArcInfo Version software and its Python 2.6 language which actually serves as a GIS/Stormwater Management Modeling Utility to interface between the ESRI ArcMap application and the Hillsborough County SWMM model. The key components include the HC-SWMM model input and output data pre- and post- processors and the GIS interface. All the information required to run the HC-SWMM model within GIS/PythonWin environment is collected through GUIs generated using Python Tkinter module. Therefore the HCSWMM input file gets updated by the pre-processor based on user inputs collected through these GUIs. Then the model is executed through a python system command. Finally the post-processor displays the existing-proposed model results comparison in a scrolled text box on the interface. Please refer to the attached word documentBMP GUIs.doc for GUI samples.
• Time of Concentration Calculation Tool Developed a Python-written tool in GIS to calculate time of concentration in minutes for each sub-catchment within a watershed based on the TR-55 equations through a geoprocessing workflow consisting of raster manipulations with ArcGIS spatial analyst. Time of concentration was calculated as the combination of several flow regimes including sheet and shallow concentration flow and channel flow where applicable. Most of the time channel flows are not incorporated into TC calculations due to the fact that most of the existing channels within the watershed are modeled hydraulically and the TC component ends at the interface with the channel. Also permanent wet areas within each subbasin have been excluded out to make sure TC flow path stops at the boundary of waterbodies to obtain higher accuracy. Eventually both TC values in tabular format and the longest flow path in vector format are generated. Please refer to the attached word document TC GUIs.doc for GUI samples.
• Hydrograph Plotting Tool Developed a user-friendly plotting tool within the MS EXCEL environment using VBA to enhance the HC-SWMM model graphing capabilities which allows users to interactively select the SWMM output file and generate stage and flow hydrographs for the individual node and link specified by users through a GUI. Please refer to the attached word document HydrographPlottingTool GUIs.doc for GUI samples.
• Hydrologic Database Viewer Tool Developed a Hydrologic Database Viewer tool for Suwannee River Water Management District which allows users to easily access large quantities of real-time hydrologic data such as the streamflow data to generate queries such as Flow Duration Curve. It was written in Visual Basic and the viewer WinForm was connected to an MS Access database through the JET engine. Please refer to the attached word document DataViewer GUIs.doc for GUI samples.

GIS Spatial Analysis

• TECO Gypsum Handling System Master Stormwater Management Plan In the GIS environment set up 1 master stormwater management plan including a node-link schematic for the hydro network of the project site for TECO Gypsum Handling System including both existing and proposed conditions 2 ICPR parameters in the .dbf format based on the available survey data site conditions and the existing HC-SWMM model. Modeled existing and proposed conditions in ICPR and calculated floodplain compensation volumes based on the modeling results.
• Derived a raster-based Digital Elevation Model DEM and ESRI Terrain based on a Digital Terrain Model DTM of the study area Centralia Watershed in Hernando County including LiDAR data points and supplemental three-dimensional breaklines which provided the foundation for developing watershed and subbasin boundaries storage and conveyance. Tested ESRI Arc Hydro Tools to delineate subbasins around all the depressions greater than a defined threshold which was considered a part of the generic schematic. Within closed drainage basins all depressions that were considered significant for developing floodplains were broken out as separate subbasins. Within open or dendritic drainage basins areas discharging to significant hydraulic features that are 40 acres or greater were delineated as separate subbasins. Additionally subbasins along channels were revised so the basin divide was approximately located at the midpoint of the channel to be consistent with guidelines recommended in ICPR. Developed a geodatabase to store different feature classes in GWIS compatible format for the modeling process such as CATCHMENT HYDROJUNCTION HYDROEDGE conveyance way channel primary flow path watershed boundary cross section drainage point boundary drainage line and watershed master schematic.
• Created HEP hydraulic element point and HEP LINE feature classes as well as associated subelement tables such as WEIR and PIPE-BARREL for Willow Sink Watershed in Hernando County to test SWFWMD Connectivity Tools which was newly released back then. HEP is a point feature class within the GWIS geodatabase used to inventory hydraulic features throughout the watershed. HEP together with HEP LINE and sub-element tables provide hydraulic characteristics for all the identified hydraulic features watershed-wide.
• ESRI ArcHydro Tool Set Tested ESRI Arc Hydro Tools to delineate subbasins around depressional areas greater than a defined threshold which was considered the preliminary portion of the generic hydronetwok schematic in Watershed Management Program WMP projects at Southwest Florida Water Management District SWFWMD as an engineering contractor 09/2007-07/2008 .
• GIS QA/QC Reviewed numerous WMP submittals at SWFWMD as an engineering contractor 07/2008-09/2011 including checking watershed delineation and characterization ICPR modeling key parameters such as TC DCIA CN runoff calculation using SCS/Green-Ampt percolation input and Floodplain delineation.
• Statewide Utility Inventory Project GIS supported a statewide ADA curb ramp inventory project for Idaho Transportation Department which includes designing the data dictionary compiling and converting the field data from GPS to GIS format using GPS Pathfinder Office as well as visualizing sidewalks and curb ramps on the state highway system in the GIS environment.
• GIS supported FDOT PD E corridor alternative analysis process to verify the most environmental preferred alternative for FDOT transportation improvements for State Road SR 710/Warfield Boulevard in Martin County Florida. The GIS portion includes map production impact quantification as well as some geoprocessing automation using Python.
• Generated GIS exhibit for County Road 901 Vanderbilt Drive over Cocohachee Canal. Created and reformatted a mailing list by writing a script using VBA in Excel for public involvement including all the property owners within 300 ft from the right-of-way in Collier County Florida Spreadsheet Automation using VBA .

GIS Map Production

• Generated the Interstate System 2030 Needs Exhibit for Florida Department of Transportation FDOT District Wide Strategic Intermodal System SIS Studies Contract including Hernando Pasco Hillsborough and Pinellas Counties Florida eventually used by FDOT District Seven at FHWA Conferences.
• Generated overview exhibit soils survey map existing land use future land use and community facilities and services maps for SR 674 in Hillsborough County Florida. Also created soils survey map for I-75 PD E study in Pasco Hernando and Sumter Counties Confidential