SUMMARY:

Over 25 years of experience in mapping/surveying, GIS, and spatial technologies. Experience includes mapping, geoprocessing; system architectures; system/application design and coding; business/technical requirements; technical project management; spatial database design, development, tuning, and administration; implementations of enterprise spatial solutions in transportation, utility, and energy sectors.

TECHNICAL SKILLS:

Databases: Database Development/Analysis, Performance Tuning, and Administration. ArcSDE, Oracle 8 - 12c, Oracle Spatial, SQLServer 2005-2016

Languages (past 3 years only): PL/SQL, T-SQL, Python, Javascript, ArcObjects API,ArcGIS Server REST API

Tools: Enterprise Architect, VS.NET 2005-2010, TOAD + TOAD DM, SQLDeveloper, SQL*Plus, VISIO, Oracle EM, ERWin, JetBrains, Amazon EC2 and Azure Cloud Service Administration

GIS: Full ESRI ArcGIS Enterprise Stack to 10.5.1, ESRI Roads and Highways 10.x, ArcGIS Pipeline Referencing (APR), ArcGIS Server, ArcSDE,, ArcFM Solution Suite 10.x, Exor Highways (back- end Oracle development and NM3-API)

RELEVANT WORK EXPERIENCE:

Spatial DBA/Data Architect

Confidential, Buford, GA

Responsibilities:

• Currently providing spatial database, system, and data architect services to SSP Innovations Pipeline Services Group.
• Responsible for spatial database design and tuning, data migrations between pipeline data models (eg. PODS, UPDM).
• Develop ETL and geoprocessing scripts (Esri, Python, SQL) for pipeline datasets.
• Also provide general database support to other SSP business units

Senior Database Analyst/Spatial DBA

Confidential, Athens, GA

Responsibilities:

• Responsibilities include data modeling and design, development, implementation, integration, support, and performance tuning of spatial databases (Oracle and SQLServer).
• Customization, migration, and implementation of ESRI Roads and Highways Data Model and software.
• ArcGIS Server configuration and support.
• Support, testing, and QA of Linear Referenced data.
• Led customer business data and system requirements workshops and documentation
• Responsible for all internally hosted and project databases.

Spatial Database Administrator/Developer

Confidential, Atlanta, GA

Responsibilities:

• Responsibilities included spatial database support for Confidential software working with the PODS pipeline industry standard data model.
• Created migration scripts from existing databases to PODS data model in both T-SQL and PL/SQL.
• Performance tuning of ArcSDE and standard Oracle/SQLServer databases.
• Geoprocessing models for creation of database geometries and spatial QA/QC. QA/QC core linear referencing scripts (Core PODS data model).
• In-house database technical support for Confidential Professional Services and QA groups.

Technical Lead

Confidential, Ft. Collins, CO

Responsibilities:

• Responsibilities included implementation and support of SE's ArcFM Solution Suite.
• Tasks include database development including ArcSDE for Oracle 10g-11g (PL/SQL) and SQLServer 2005/2008R2 (T-SQL); database installation, configuration, tuning, and troubleshooting; ArcGIS tool and geoprocessing model development; Python scripting; scope development; database object modeling; data modeling; schema generation; geometric network creation; development of functional requirements; system configuration; server specification and configuration; system architecture specification; test plan development; customer training; project/technical management.
• SE specific technologies include: ArcFM Enterprise Geodatabase (ArcSDE 9-10); ArcFM Solution Desktop;
• ArcFM Server (extending ArcGIS Server 9-10/Silverlight); ArcFM Mobile Solution (geodatabase replication);
• Fiber Manager; Network tracing; ArcFM customization.

GIS Programmer/Analyst

Confidential, Augusta, ME

Responsibilities:

• Involved with system development at all levels including project management, scoping, contract management, requirements gathering and analysis (system and business), application design and coding, system maintenance, and overall project management.
• Managed the implementation of Confidential 's Crash Analysis System (CAS) including acting as consultant and business unit liaison, contract amendments, backend Oracle data analysis, object creation and coding to facilitate application. Successfully managed implementation of GIS Straight Line Diagram (SLD) application.
• Managed TIDE data warehouse enhancement project. Tasks included business and system requirements analysis, contract development and administration, schedule and scope management, Oracle coding as needed. Point contact to business unit for TIDE data warehouse maintenance and integration of external systems (Highways (Oracle Spatial), PONTIS, CAS, Traffic Analysis, et al.).

Transportation Planning Analyst

Confidential, Augusta, ME

Responsibilities:

• Developed Oracle based queries to extract, analyze and report on crash data, projects, and DOT inventory.
• Used ArcGIS to produce maps and reports based on Oracle data warehouse.
• Provided bureau level data management and support for MS Access, TIDE (Oracle based database application), MS Office, ESRI GIS software, and Oracle Spatial SDO data types.