Mark Heslop, Developer in Bangkok, Thailand
Mark is available for hire
Hire Mark

Mark Heslop

Verified Expert  in Engineering

Geomatics Developer

Bangkok, Thailand

Toptal member since July 13, 2021

Bio

Mark has been working with GIS for more than 20 years and has a comprehensive knowledge of all aspects of spatial data management, analysis, visualization, and interaction. He has a strong ability to quickly understand client requirements and translate them into reliable, functional, and successful GI systems, utilizing out-of-the-box tools for customizations or building stand-alone desktop, server, or cloud applications where appropriate.

Portfolio

Oceaneering (Assigned to Chevron Thailand)
ArcGIS, JavaScript, T-SQL (Transact-SQL), C#.NET, Python, ArcPy...
Accenture (Assigned to Chevron Mid Continent)
T-SQL (Transact-SQL), ArcGIS, APIs, ArcPy, Microsoft Teams, Azure DevOps...
Brunel Energy (Assigned to Chevron Thailand)
ArcGIS, PL/SQL, ArcObjects, ArcGIS Server, COM, ArcSDE, Oracle, Geodetics, GPS...

Experience

  • Geomatics - 20 years
  • GIS - 20 years
  • Geodatabase Development - 19 years
  • ArcPy - 8 years
  • T-SQL (Transact-SQL) - 5 years
  • C# - 3 years
  • Spatial Data Infrastructure - 2 years

Availability

Part-time

Preferred Environment

JavaScript, APIs, ArcPy, T-SQL (Transact-SQL), ArcObjects, QGIS, ArcGIS, SQL Server 2016

The most amazing...

...thing I've developed is a mapping tool that reduced the time to evaluate annual undeveloped reserves by 75% and received considerable recognition and awards.

Work Experience

GIS Consultant

2021 - 2022
Oceaneering (Assigned to Chevron Thailand)
  • Oversaw the migration of the MetOcean and Survey Data databases from on-premise Oracle to MS Azure cloud SQL Server. Primarily responsible for translating geodetic functions from PL/SQL to T-SQL.
  • Oversaw the Map Manager ArcMap extension migration to an add-in for ArcGIS Pro. Wrote all the ArcPy Python code for back-end functionality.
  • Oversaw the Sims MS Access application migration to an MS Azure web application. Wrote the functions for geodetic calculations in TypeScript.
  • Oversaw the migration of on-premise web mapping applications to MS Azure web apps. Primarily responsible for developing a new method to display real-time vessel tracking and MetOcean data from cloud data sources.
  • Wrote custom FME transformers in python to convert complex RDBMS objects to feature classes in the SDE cloud geodatabase.
Technologies: ArcGIS, JavaScript, T-SQL (Transact-SQL), C#.NET, Python, ArcPy, SQL Server 2017, TypeScript

GIS Consultant

2019 - 2020
Accenture (Assigned to Chevron Mid Continent)
  • Developed a web mapping application for planning onshore sites for drilling and production facilities and associated pipelines.
  • Designed a new spatial data model to integrate with the existing proprietary planning and costing database.
  • Developed a geoprocessing service to extract contours and elevation profiles from a precise digital elevation model for display and analysis in the map.
  • Developed a tool to integrate existing KML data with the map and allow users precise control over KML layer visibility.
  • Added templates for standard site pad dimensions, allowing engineers to position and rotate pad sites precisely on the map with a single mouse click.
  • Built a tool for drawing pipelines on the map, either freehand or restricted, to align segments with the orientation of the enclosing section boundary lines.
Technologies: T-SQL (Transact-SQL), ArcGIS, APIs, ArcPy, Microsoft Teams, Azure DevOps, Spatial Data Infrastructure, SQL Server 2016, Geodetics, GIS, Python, Spatial Analysis, JavaScript, Geomatics, SQL, Geospatial Data, Esri

Advising Geomatics Engineer (GIS Solutions)

2002 - 2016
Brunel Energy (Assigned to Chevron Thailand)
  • Led the team to re-design and re-write SIGMA in VB6, COM, and ArcObjects as an ArcMap 8.x extension. It included multiple map views in a single ArcMap instance with views in real-world and profile space.
  • Migrated the survey database from standard RDBMS to SDE geodatabase, with a new data model to benefit from structured spatial data storage, with data managed directly through SIGMA.
  • Led the team to build automated processes to maintain features in the enterprise geodatabase from data in the SIMS database.
  • Extended the application to view and interpret geotechnical borehole data in real-world and profile views and the ability to view 3D seismic time-slice data in real-world views.
  • Added functionality for interactive anchor pattern design and reporting for drilling rigs and construction barges.
  • Served as a technical lead for a meteorological and oceanographic data system MetOcean with 20+ stations offshore, central Oracle database, web UI for current and historical data, and web map application.
  • Acted as a technical lead for a vessel tracking system to track all vessels in the offshore fields, with a real-time map application and historical playback capabilities.
  • Developed a pipeline protection system – built a tool on top of the vessel tracking system to identify when vessels may be anchoring close to major pipelines and send email warnings to appropriate personnel on- and offshore.
  • Performed geological structure data conditioning. Led the team to migrate and condition geological structure map data like faults and contours from AutoCAD to the enterprise geodatabase, adding attributes to the features and applying topology rules.
  • Served as a technical lead for CURT Map, web map application for display and analysis of reserves data and attributes for thousands of existing and planned wells, with geological structure data overlaid.
Technologies: ArcGIS, PL/SQL, ArcObjects, ArcGIS Server, COM, ArcSDE, Oracle, Geodetics, GPS, GIS, Python, Geodatabase Development, Spatial Analysis, Geomatics, SQL, Geospatial Data, Esri

GIS and Data Management Consultant

2006 - 2010
PJH Golf
  • Developed an MS Access application for end-to-end management of supply chain and customer order flow, from order capture through to demand planning, shipping, and stock management, fully integrated with 3PL systems for delivery to the customer.
  • Collaborated with the managing director to integrate GIS resources into sales and marketing strategy, ultimately resulting in taking Under Armour Golf from market startup to number one with a 23.9% market share in the UK.
  • Created GIS resources to assist in driving the implementation of product and distribution channel segmentation strategy, including demographic data, golf participation levels by region, and potential retail outlets.
  • Developed a mapping tool in Esri ArcReader to analyze return on retail marketing investment (shop in shop), ensuring geographical optimization to drive incremental sales without dilution of existing retail partners.
Technologies: ArcGIS, GIS, Spatial Analysis, Microsoft Access, SQL, Geospatial Data, Esri

Geomatics Engineer

1995 - 2002
Fugro Surveys (Assigned to Chevron Thailand)
  • Designed a data model (Survey Information Management System) for the survey data for wells, platforms, and pipelines, collected by the geomatics department and built the database.
  • Designed and built an application to view and manage the SIMS database in MS Access.
  • Automated map production via ASCII exports from SIMS and ASCII imports to AutoCAD with AutoLISPfor SIMS Application. Included field and platform charts and maps for anchor patterns.
  • Designed and built a data model for hydrographic and geophysical survey data (tracks, bathymetry, and interpreted horizons) collected by the geomatics team, with data management through ASCII import and export.
  • Designed and built the Site Investigation and Geological Model Analyst (SIGMA) application in Avenue as an ArcView 3.x extension for surface and contour generation and automated, standardized map figures for reports.
  • Wrote a program in VB to convert seismic data in SEG-Y format to TIFF for display in profile view in ArcView, enabling seismic interpretation in GIS. The program included image enhancement filters, seabed detection, and swell filtering.
  • Extended the ArcView extension to translate interpreted horizons from profile to real-world space and automate surface and contour generation for each horizon in ArcView.
Technologies: Visual Basic for Applications (VBA), Visual Basic 6 (VB6), Microsoft Access, Oracle, AutoCAD, AutoLISP, ArcView, Geodetics, GPS, GIS, Spatial Analysis, Geomatics, Geospatial Data

Survey Information Management System (SIMS)

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.

Site Investigation and Geological Model Analyst (SIGMA)

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.

MetOcean System

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.

Vessel Tracking System

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.

Chevron Unified Reserves Tool Map – CURT Map

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.

Pricet Map

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.
1985 - 1988

Bachelor of Science Degree (Hons) in Nautical Studies

Plymouth University - Plymouth, UK

MARCH 2021 - PRESENT

Stripe with C# (Blazor)

Udemy

MARCH 2021 - PRESENT

Serverless Computing with Azure Functions

Packt Publishing

FEBRUARY 2021 - PRESENT

The Complete 2021 Web Development Course

Development Island (UK) | via Udemy

JANUARY 2021 - PRESENT

Git and GitHub Beginners Crash Course 2021

Bluelime Learning Solutions | via Udemy

JULY 2020 - PRESENT

Getting Started with .NET Core

IAmTimCorey

JUNE 2020 - PRESENT

Xamarin Forms: Build Native Cross-platform Apps with C#

Udemy

MARCH 2019 - PRESENT

Object-oriented Programming in JavaScript

Udemy

FEBRUARY 2019 - PRESENT

The Complete ASP.NET MVC 5 Course

Udemy

FEBRUARY 2019 - PRESENT

Entity Framework in Depth: The Complete Guide

Udemy

JANUARY 2019 - PRESENT

C# Advanced Topics: Prepare for Technical Interviews

Udemy

DECEMBER 2018 - PRESENT

C# Intermediate: Classes, Interfaces and OOP

Udemy

NOVEMBER 2018 - PRESENT

C# Basics for Beginners: Learn C# Fundamentals by Coding

Udemy

JULY 2018 - PRESENT

Spatial SQL with Postgres: A Language for Geographers

Udemy

JUNE 2017 - PRESENT

Microcontrollers for the Internet of Things

Udemy

APRIL 2017 - PRESENT

Amazon Alexa Development: From Beginner to Intermediate

Udemy

MARCH 2017 - PRESENT

Amazon Web Services (AWS) - Zero to Hero

BackSpace Academy | via Udemy

JANUARY 2012 - PRESENT

Geoprocessing with ArcGIS Model Builder and Python

TeachMeGIS

JUNE 2009 - PRESENT

Managing Editing Workflows in a Multiuser Geodatabase

ESRI South Asia

JANUARY 2009 - PRESENT

Data Management in the Multiuser Geodatabase

ESRI South Asia

JANUARY 2007 - PRESENT

Developing ASP.NET Web Applications

Excom Australia

MAY 2005 - PRESENT

Developing Applications with ArcGIS Server

ESRI South Asia

APRIL 2005 - PRESENT

ArcSDE Administration for Oracle

ESRI South Asia

MARCH 2005 - PRESENT

Oracle 9i Database Administration Fundamentals I and II

Oracle Australia

JUNE 2004 - PRESENT

Oracle 9i: Program with PL/SQL

Oracle Australia

JANUARY 2004 - PRESENT

Introduction to Oracle 9i SQL

Oracle Australia

JANUARY 2003 - PRESENT

Project Management for IT Projects

IPS Associates Asia

SEPTEMBER 2001 - PRESENT

VBA and ArcGIS COM Development

ESRI South Asia

APRIL 2001 - PRESENT

ArcGIS VBA Development

ESRI South Asia

JANUARY 2001 - PRESENT

ArcGIS Geostatistical Analyst

ESRI South Asia

JUNE 1998 - PRESENT

ArcView Avenue Development

ESRI South Asia

JANUARY 1998 - PRESENT

Using ArcView GIS

ESRI South Asia

Libraries/APIs

ArcGIS, Google Maps API, Entity Framework, Node.js, Stripe

Tools

ArcObjects, GIS, Microsoft Access, Esri, SQL Server BI, Microsoft Teams, AutoCAD, Git, GitHub

Languages

Visual Basic for Applications (VBA), Visual Basic 6 (VB6), T-SQL (Transact-SQL), C#, VB.NET, SQL, JavaScript, Python, VBScript, AutoLISP, HTML5, CSS, ECMAScript (ES6), C#.NET, TypeScript

Storage

Geodatabase Development, PL/SQL, SQL Server 2016, Oracle PL/SQL, PL/SQL Developer, Oracle DBA, PostgreSQL, PostGIS, SQL Server 2017

Frameworks

ASP.NET MVC, ASP.NET, ASP.NET MVC 5, ASP.NET Core, Razor Pages, Blazor

Paradigms

Azure DevOps

Platforms

Oracle, ArcGIS Server, Amazon Web Services (AWS), Amazon Alexa, Arduino, Azure Functions

Other

GPS, Geodetics, Geomatics, ArcView, ArcSDE, Geodatabases, Geospatial Data, ArcPy, QGIS, Spatial Analysis, COM, APIs, Data Modeling, Spatial Data Infrastructure, IT Project Management, ESP8266, Xamarin.Forms

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring