Patrick Hill

Developed a GIS synchronization application across multiple systems, including SQL views spanning multiple sources and transformations for UPDM assets. Built Python-based automation for contingent values and ArcGIS Portal workflows, including Arcade attribute rules to segment features and populate attributes.

Installed and configured ArcGIS Portal, ArcGIS Server, and ArcGIS GeoEvent, and engineered Python/Azure workflows to upload terabytes of natural gas pipeline imagery, geolocate aircraft imagery, and generate services with critical metadata. Developed change-detection hashing for attribute updates, automated service publishing via ArcGIS Python/REST APIs, and built real-time AVL/CAD (911) and E911

Built ArcPy geoprocessing tools for advanced agricultural analysis, publishing selected layers to ArcGIS Portal. Automated weekly USDA crop progress ingestion (CSV to feature classes) and created analytics workflows including descriptive statistics/histograms, raster algebra, elliptical buffers, and harvest data interpretation; also developed a web prototype using ArcGIS JavaScript API and React.

Developed geoprocessing toolboxes delivered with ArcGIS Pro for Intelligence using ArcPy and Python, and implemented unit test frameworks and tests for geoprocessing tools. Produced components for Military Tools for ArcGIS (C#), gathered requirements, and delivered and maintained 26 GeoEvent-based real-time GIS solution products; supported with technical presentations, documentation, and holistic

Served as a contracted GIS Analyst/Developer at the National Geospatial Intelligence Agency (NGA) and built runway charting applications using ArcObjects and C#. Developed Esri components across Production Mapping and Military Analyst suites (COM, C++, C#), created Mosaic datasets for raster storage/querying, and implemented raster and network analysis workflows using Python and JavaScript (includ

Managed the Transportation Improvement Program (TIP) database and developed VBA/ArcObjects tools to build the Chicago Area Transportation Study’s Chicago Highway Interchange Atlas. Conducted transportation geographic analysis to support planning and reporting needs.

Managed updates to the Census Bureau’s digital geographic database (TIGER) and coordinated preparation of Census materials sent to local governments across Indiana, Illinois, and Wisconsin. Oversaw address matching of Census addresses to the USPS Master Address Files and supervised a team of 6 employees.

Earned a Master of Science in Computer Science from the University of Chicago in 2006.

Earned a Master of Arts in Geography from the University of Illinois Chicago in 2001.

Earned a Bachelor of Arts in Geography from the University of Illinois Urbana-Champaign in 1994.