Full control over modernising the flagship product, to run on Access 2016/365 and deploying via C2R technologies and updating the legacy components in VS2019/2022 and adding features like Google mapping and directions using APIs with support for advanced route optimisation using GraphHopper. Adding the C# component to add ability to import XML data using XSLTs

Developing and supporting the main software product ‘Protean'. Developed in MS Access XP/2010 using OOP structured VBA Class Modules and various third party Active X components.Developing and maintaining SQL Server 2005/2008 Databases. Using T-SQL including Views, Stored Procedures, and bespoke functions.. Also developing COM libraries and VB.Net assemblies for integration with third party software including Sage accounting software Google maps. Extended Development team assistance. A daily troubleshooting clinic to assist with the Support teams’ more complex issues. Assisting with customer support when required, including customer interaction and site visits.

Developing/ Supporting the Main MS Access Recovery management System.Processing data for audits, using ACL, MS Access & SQL Server.Specifying and developing MI reports within MS Access and outputting them to pdf format collated documents.

(VAT BAT Debt Recovery)Developing Tracking systems and supporting the team.Specifying, developing MI reports within MS Access.

Developing systems for both payroll and pensions departments to support their work. Mainly via ODBC link to Oracle databases.Specifying, developing MI reports within MS Access and Cognos Impromptu.

MS Access/VB developer with the Billing department System Support team. Initially covering Change Management. Then as part of a team producing databases that reconciled and adjusted complex gas invoices. This includes full system support and change control procedures.System development, covering the full Project Life Cycle from Initial Feasibility Studies, Analysis of Information Requirements, Design of Data Models using SSADM, Constructing Tables, Queries and Forms and Reports through consultation with the business.Development using VBA / Visual Basic, both DAO and ADO Recordset Manipulation, SQL, Active X controls and windows API technologies.Design of Unit Test and User Testing strategies, Financial Controls Audit and external Price waterhouse cooper (PWC) audit / sign off. Technical and User Documentation and Change Control.Use of several data warehouse querying techniques such as OBDC links and Business objects.Development of the systems department's global VBA libraries, for use by the rest of the team.Conducted audit of 300 business critical databases, to ensure they meet our high development best practises.Leading a small team of developers on database projects.