Mark Heslop

Assigned to develop a back-end data model and front-end application for the Survey Information Management System (SIMS). The system stores survey and engineering data for all offshore infrastructure, including wells, platforms, moorings, pipelines, and fittings. Originally developed in MS Access 97, providing wizard-based forms for data entry and forms and reports for display, it became the system of record (SoR) of surface position information for all offshore assets. Subsequently developed to include extract, transform, and load (ETL) processes for automated maintenance of spatial data in an enterprise geodatabase.

The back-end database was migrated to Oracle in 2005, enabling the provision of well surface locations to OpenWorks through a DBLink and automated scripts. The product has grown to include various other drilling, construction, geotechnical, and survey data and remains the cornerstone for infrastructure data management in its current MS Access 2019 incarnation.

Tasked to design and develop an ArcGIS desktop extension Site Investigation and Geological Model Analyst (SIGMA) to integrate physical infrastructure data from SIMS with 2D and 3D geophysical survey data and geotechnical borehole data. It provides multiple views of the integrated data in ArcMap, both in plan and profile views, and includes tools for interpretation, analysis, and automated mapping and reporting for seabed and sub-seabed features. Refactored to ArcGIS 10 in 2013 and added tools for integration of rig and barge locations and design of associated anchor patterns.

Served as a technical lead and database architect and developer for the MetOcean system, which captures and disseminates real-time meteorological, oceanographic, and motion data from approximately 25 offshore platforms, rigs, FSOs, and barges. A data logger and graphical user interface were developed using LabVIEW (National Instruments) to log data from various sensors at each remote location and provide real-time instrument displays.

Summary data is regularly transmitted via a proprietary web service to a centralized database in Bangkok, where the data is managed to provide fast and efficient retrieval of real-time and historical time-series data to web applications and maps. Business logic was built into the database where possible using PL/SQL, making the data management transparent to higher-tier applications.

Acted as a technical lead and GIS and database developer for the vessel tracking system that provides a real-time interactive web map showing current positions and a 30-minute trail for all vessels in the Chevron fleet.

The system was implemented with minimal equipment costs, using freely available AIS data and extending the MetOcean web service to transmit data to the central database. Historical playback of data from any period is provided through another web map application or a customized ArcMap document when more detailed analysis or cartographic control is required.

Served as the technical lead on the Chevron Unified Reserves Tool (CURT) map, an interactive web mapping application providing earth scientists and petroleum engineers with up-to-date attribute information for existing and planned wells and platforms throughout all concession areas. Spatial views in the geodatabase utilize DBLinks to three other RDBMS databases to eliminate stale data.

The project included a huge data conditioning effort to migrate approximately 14,000 km2 of geologic structure maps from CAD into queryable, attributed features in the new enterprise geodatabase model. The application reduced the time to evaluate annual undeveloped reserves by 75% and received considerable recognition and awards within Chevron.

Tasked to design and build a web mapping application using ArcGIS JavaScript API to enable facilities engineers to plan and map new facilities and pipeline networks, using innovative solutions to integrate data from many sources and linking geographic features to facility elements in the proprietary planning and costing cloud database through a custom API. The project included a geoprocessing service for contour and profile generation. Area of operations spanned three state plane zones, requiring the incorporation of a custom projection engine when placing site layout templates to maintain the true scale and orientation of sites.