Jonathan Ford Email & Phone Number

Reading, England, Gb

London, Gb

• Lead developer for design and implementation of Analysis Services Tabular model to be used for Power BI reporting of AllAssets risk-based inspection module. The solution included ETL processing using Azure Service Bus and Azure durable functions. The model supports customer-specific dynamic columns using AMO-TOM API.• Implemented AutoCAD dwg drawing annotation functionality to AllAssets using Open Design Alliance Teigha library.• Designed and implemented Excel data upload functionality to help with customer on-boarding. Included support for template downloads, lookup lists, and client and server-side validation.• Joined team for new reliability-centred maintenance module to ensure the deliverable was met and the required features were at a high quality.• Implemented software development workflow to Azure DevOps, including creation of build and release pipelines, unit & integration test pipelines, task groups, variable groups.

London, Gb

• Developed a new minimum viable product called AllAssets with Angular front-end and .NET Core RESTful API / Entity Framework Core ORM.• Implemented Excel export for AllAssets modules using Open XML SDK.• Added support to IP 2018 for well coordinates in reference systems other than default WGS 84.• Added support to IP 2018 for selecting the naming convention of wells (Well Name, UWI, API) used throughout the application.

London, Gb

• Lead developer for project enabling Windows 10 support for recent IP 4.4 release, resolving compatibility issues with .NET Framework v4.5 and above.• Lead developer for data link between the company’s two software products, IP and IC, to facilitate sharing of well data and cross-selling of products. Extensive performance profiling was done to minimise data transfer times.• Lead developer for replacement of MS Access support with MS SQL Server LocalDB single file database option.• Member of a team of developers working on converting legacy code of IP software from Delphi to C# built upon the DGrok parsing tool. This work includes enhancements to the tool to speed up the conversion process.

Westhill, Gb

• Developed API for company’s IC product using NHibernate, mapping by code data tables to MS SQL Server, Oracle and MS Access databases and ensuring consistency between database engines.• Implemented support for OpenSpirit 4.0 data link for import and export of data utilising new vendor API.• Member of a team of developers that converted ODM product from VB6 to C#.• Championed use of dependency injection design pattern in the company, promoting clean, intelligible and decoupled code that can easily be unit tested.

Westhill, Gb

• Implemented FlexNet Publisher licencing capabilities in C++ for IP product, allowing customers alternative licencing options to check in/out and borrow module licences.• Worked with electrical engineers to develop a library in Fortran 90 for PSS/E power systems engineering software to calculate optimal wind turbine speeds.• Developed project and financial reports for Epicor E4SE management system using the Yii PHP framework, which was presented to users via Microsoft Sharepoint views.

• Provided ongoing IT consultancy to local businesses on an ad hoc and contract basis.• Reviewed and made improvements to IT processes including backup strategies, timesheet systems and data archiving.• Developed Intranet systems with Prado framework to facilitate information sharing and remote working of electrical engineers across international sites.• Developed a new website for Tynedale Care with a custom content management system and maintained existing North Energy company websites.

Au

• Managed code of ASP classic based company Intranet including creation of project reports to users.• Maintenance of company website using HTML, CSS and JavaScript.• Chargeable project work designing and implementing a common framework with PHP and the Prado development framework, subsequently developed into the user interface for the GenAVC R&D product.• Managed company back-end database and deployed updates to client front-end interfaces.