US federal government agency

the US federal government agency maintained land unit data — with a primary focus on recreation sites — in a legacy Oracle database integrated with ArcGIS Enterprise. The objective was to migrate recreation site data off Oracle onto PostgreSQL with PostGIS, redesign the schema for better performance, and modernize how recreation site data was surfaced and managed, including ultimately replacing a ServiceNow-based map display with a custom frontend application.

- Worked extensively with a legacy Oracle database (integrated with ArcGIS Enterprise) storing the US federal government agency land unit data, with primary focus on recreation sites - Led migration of recreation site data from Oracle to PostgreSQL with the PostGIS extension - Redesigned the database schema to improve performance - Worked closely with the client to deliver demos and obtain approvals throughout the engagement - Managed a 2-3 person team of database developers - Integrated the new PostgreSQL/PostGIS database with ArcGIS Server - Spent significant time on ArcGIS Enterprise configuration and publishing map features - Integrated ArcGIS with ServiceNow so ServiceNow could display maps - In the final 2-3 months of the engagement, led development of a custom frontend application to replace the ServiceNow map display, using GitHub Copilot to accelerate development with a modernized framework - Integrated the new frontend application with the PostgreSQL database and ArcGIS - Built a recreation site inventory feature allowing users to view and modify data associated with a recreation site - Built a ticketing system for surveys conducted on recreation sites - Presented the finished proof-of-concept application to the client

- Legacy state: Oracle database integrated with ArcGIS Enterprise, storing the US federal government agency land unit data (recreation sites in particular) - Target state: PostgreSQL with the PostGIS extension, redesigned schema, integrated with ArcGIS Server for map publishing - Mid-engagement integration: ArcGIS-to-ServiceNow integration so ServiceNow could render maps - Final-phase proof of concept: a custom frontend application (modern framework — specific framework TBD) built with GitHub Copilot assistance, integrated directly with the PostgreSQL database and ArcGIS, replacing the ServiceNow map display; included a recreation site inventory (view/edit) and a survey ticketing system

Redesigning a legacy, ArcGIS-integrated Oracle schema for performance while maintaining continuity of a live GIS system used for recreation site management; a late-stage scope change to replace ServiceNow's map display with a custom-built frontend, delivered in a compressed final 2-3 month window

Successfully migrated recreation site data from Oracle to PostgreSQL/PostGIS with a redesigned, more performant schema, and integrated the new database with ArcGIS Server. Delivered a proof-of-concept custom frontend application (recreation site inventory + survey ticketing system) integrated with PostgreSQL and ArcGIS, built with GitHub Copilot assistance. The client ultimately did not proceed past the POC stage with the custom frontend due to budget constraints — the underlying database migration and ArcGIS integration work remained the durable deliverable of the engagement.

Managed a 2-3 person team of database developers; worked directly with the client to deliver demos and secure approvals across the full engagement