Develop tools and ETLs for ArcGIS, Using ArcGIS, FME, and Python

Develop tools and ETLs in ArcGIS, FME, and Python for IT Integration Group TomTom API download to SDE GEOTAB API download to SDE Lease Data Exchange Report Proof of concept for Fleet Device Services

Project to migrate PRISM to PODS databaseTest and validate relational and geo-spatial data (compare databases)GIS Portal Maps and AppsResolve error report Validate geospatial data using Topology Rules, FME, ModelbuilderCreate Revised test plan for software implementationConduct software testingCreated data for alignment sheets (Sheet Cutter)Proof of concept for asset management migration Proof of concept Tax boundary and dataFME ScriptingProvide GIS support and train

• Design pipeline Production Optimization Tools in Oracle• Building Telemetry data from sources together with geo-processing programs in C#, and database programming to create Rick and Production tools• Database programming in Oracle / Toad building tables, views, and programming logic• Provide GIS support and train• Re coding Geo-processing in Python• FME Scripting for well casing study

Midstream gas and liquids pipeline Transportation CompanyProject to Implementing and loading an enterprise ESRI-based GIS pipeline database based using PODS 5.1 model on SQL ServerStarting with evaluating data maintenance and integrity tool vendors to develop a Bolt On – Bolt Off system where customization is completed and data loading is handled internallyPrimary As-Built QA/QC team leadAdministrate GeoFields Admin SDE, and SQL Server (Stored procedures, adding modifying tables)Administrate ArcGIS Server publish maps, adminTask includes creating and transforming data from multiple sourcesQC and review data prior to loadingValidated regulatory data (DOT Class, MAOP, teat pressure, etc.)Created GAP reportsProvided support MS IISLoading and maintaining PODS 5.1 database (Specifically regulatory pipe)Setup project folders guidelines by creating data storage standardsData creation and transformation from multiple sources like DeLorme, Google Pro, Survey, using MS Access ERSI tools, and FME

GIS Pipeline Analyst working with interstate pipelines using APDM on both Oracle and SQL Server using Eagle Information Mapping tools. Working proof of concept testing and documenting work flows.Pipeline updates (As-Builds) In APDM 4.0Reverse engineered PODS database for migration into APDM 3.0Used alignment sheet to create centerline and pipeline features.Used FME to load data into APDM 3.0Team Lead to answer analyst question for ArcGIS and Oracle tasks. Created work flows for the team to use including coding domain conversion.Technical liaison with vendor’s technical team.Kept track of progress and crafted measures for management.QC data prior to loadingGenerated ad hawk reports and analyst such as miles of pipe, schools local to pipe, T4, etc.

• Create and manage oil and gas lease data using Tobin Landnet and Metes and Bounds from Tobin Lease Suite database

Creating and revising data using ArcMap and ArcCatalog tools in a versioned and replicated Geodatabases• Provide team training and support on Arcdesktop• Creating up to date zip code boundaries.• Verifying 911 road centerline data.

Working with ESRI and Intrepid software on pipeline data management project using PODS database.• Pipeline data creation from as-built CAD drawings, tables, and other resources.• Used Topology Rules and Geometric Networks to QC data.• Create models in ArcObjects to consolidate Tobin (P2) data into SDE.• Analyzed and generated requested maps.

Manzanita Services is technical and data services company for oil and gas companiesSupplied GIS analytical and technical services at OXY Permian to facilitate oil field and asset management.Data creation from as-built CAD drawing, tables, and other sources to create data and geodatabase.Developed measurements for project planning and goals.Created geodatabase, QC standards, schema models, and templates for completion of data and transfer. Manage and load data in Intrepid including NPMS and Pipephase beta test (proof of concept). Create and edited stationing for pipe evens.Analyze and generate maps including Oil Field Units, Population density, T4, and numerous map requests for many Oxy divisions.Coded tools using VBA and VB.net to improve workflows.Used SQL queries in Access to query Oracle databases to create, analyze, and manage data.Wrote several training and standards documents including QC procedures. Taught first time user to use Arc Desktop, and training new employees Oxy projects and standards.