Lead Developer - Plutus Pioneer (3rd Cohort) - Dropspot.io

As Lead Developer on Dropspot.io (DS), a market place for Cardano NFT's (cNFT), Gavin is instrumental in developing the companies knowledge of the technical aspects of the Cardano Blockchain.
Gavin is a minor contributor to the Helios API and has developed all Dropspot's Smart Contracts with the Helios DSL.

Development of Junior React Developer - As Team Lead Gavin is mentoring a junior React Developer, this includes code paring via screen share, code and task reviews.

CEL Mobile - Technical Support

Evie Digital maintain support for the CEL Mobile native iOS and Android Application utilised by Worley.
Gavin has responsibility to keep the full SaaS stack running efficiently and securely.
Gavin worked closely with Worley's technical team to produce Oracle SQL DB Patches to support the Oracle 19c DB upgrade.
During this time, he also migrated the SaaS middleware (NodeJS application) from AWS Elastic Beanstalk
to AWS ECS. Lastly, Gavin also patched up the iOS and Android native applications ensuring support with the latest mobile Operating Systems.

Loop Law

• Solution Design - work with Salesforce and Heroku pre-sales teams to produce, analyze and determine the feasibility of solutions
• Initial Development - Create the initial environment (Salesforce to Heroku PostgreSQL to Secured API output)
• Technical Team Lead - Upskill colleagues on the solution design and technical implementation

CEL Mobile

• Solution Architecture - Work with client's Architecture Teams to produce a technical solution to allow client's to link their Oracle EBS Suite to CEL Mobile
• Technical Development - Develop NodeJS Middleware solution that will allow CEL Mobile Device application to securely authenticate to client's Active Directory, and then pull data from the Oracle EBS Suite (appropriately striped to the Authenticated user)
• Android Developer - Develop the CEL Mobile Android device application
• Android Lead - Skill up colleagues to speed up development

Oracle Payroll Technical Support

• On-site Client Support for Oracle EBS Suite
• Develop Oracle BI Publisher reports according to prescribed requirements

Loop.Law

Gavin led the design and implementation of the Loop Law application, collaborating with the client to meet their needs and future goals. He also made Loop Law the first law firm to integrate with PEXA and served as the Technical Team Lead, ensuring timely and high-quality delivery of the project.

Technology

The Loop Law tech stack consisted of:

• Salesforce - used internally as the data store and for the business users to manage and progress property transactions,
• Heroku Cloud - used to host all Loop Law Middleware components
  • Heroku Postgres - data store for Device / Web Application read and writes,
  • Heroku Connect - used to keep Salesforce and Heroku Postgres in sync
  • Papertrail - log storage
  • …
• Auth0 - Used for user authentication and as our user store,
• Angular web application
• iOS Device Application

Salesforce

• Custom Object design - creating Custom SObjects which were fit for purpose. Linking SObjects to create required relationships.
• APEX Class Development - Creating APEX Classes (Queueable and Future classes for executing Web API's, APEX Triggers to react to changes in SObject Properties …) ensuring that the classes had appropriate test classes.
• Development of Flows to handle Business logic events, triggering APEX Classes when needed.
• Development of Screen Flows to aid in the seamless capture of core data.
• Configuration and Code Migrations utilizing GearSet.

Heroku – Cloud

• Development of Node Express JS API layer
  • Implemented Auth0 JWT API Security for b2c access. Each request requires to authenticate with a verifiable Auth0 JWT (Json Web Token) Bearer Token.
  • Implemented Auth0 API Security for internal API usage (Salesforce Web Callouts to Heroku API layer).
  • Integrating the Loop Law system with PEXA, Domain, SAI Global and CoreLogic. This required consumption of their public secured API's.
• Provisioning of Heroku Postgres Database
• Integration of Salesforce and Heroku Postgres utilizing Heroku Connect.
• Development of SQL functions required to safely handle (appropriate Data validation, ensuring that all related SQL Table rows are created) data create from the Node JS API Layer.

Web Application – Angular

• Assist in the development of the Angular Web Application creating new functionality.
• Identification of Bugs and Implementing Fixes.

Auth0

• Configuration of Auth0:
  • Multi Tenant - Production and Pre-production
  • Custom Domain.
  • Custom Login Page (which is used on both the Web and Device application).
  • Set-up of Social Authentication - Facebook, Apple and Domain (discontinued).
  • Development of Auth0 Rules to append additional assertions to the Auth0 generated JWT token.

CEL Mobile

CEL Mobile is a mobile application (and associated Architecture) to render HR, Payroll, Worklist information onto employees iOS and Android devices. This application is being used by large organizations the world over.

Gavin was the early pioneer in getting the very successful SaaS model built for Colab. He worked with sales and pre-implementation teams to guide clients Architecture Team on how CEL Mobile integration could occur.

Technology

The CEL Mobile platform is a hybrid SaaS and on system application. The SaaS (managed by Colab) part of the application is hosted on Colab's AWS Cloud.

NodeJS Middleware

The CEL Mobile Middleware is two NodeJS applications which are run out of AWS (Amazon Web Services) ElasticBeanstalk. Gavin worked on the initial development of the NodeJS Applications, ensuring that the appropriate standards were put in-place for Security and Performance. Gavin then trained two of his colleagues to ensure business redundancy and continued to make highly valuable contributions to the project.

• Architect - Designed the AWS architecture to allow Colab to support their clients on secure, isolated infrastructure utilizing VPC Private Subnets to keep servers off the Internet and AWS ElasticBeanstalk as a PaaS (management of server, OS, and platform (NodeJS and nginx)).
• Worked with all CEL Mobile client's IT Architecture teams to describe how CEL Mobile integrates with Oracle EBS and therefore what actions need to be taken to make the project a success.

Android Mobile Application

Gavin built the thing!

I.T. Consultant

October 2008 – August 2009 – Department for Work and Pensions – Cabinet Office and Department for Children, Schools and Families (DCSF)

Payroll Implementation

Senior HCM Functional Consultant

Analysis of Customer Requirements

Improvising the DWP system for Cabinet Office / DCSF

Design, demonstrate and Implement Payroll solutions using Fast Formula and PL/SQL Formula Functions

Document Functional Build into BF160 and Technical extensions into MD050

Support System, Integration and User Acceptance Testing

Aid Expert Domain with Post Go Live issues and Training

Improve current DWP solutions to make them more re-useable and stable

Development of SQL Scripts to aid in the documentation process

Production of Advanced Excel Spreadsheets to aid in the development of Fast Formula and Data Loaders

February 2008 – October 2008 eMbrace Support Consultant

Dunnes Stores

Payroll Implementation

Understand client requirements, Implement using RAD methodology and maintain core BR100 and document a guide to implementing Payroll for Dunnes Stores. Training Dunnes staff in implementing Payroll for their Subsidiaries.

Redcar and Cleveland Borough Council

Payroll Implementation

Gather Requirements, Develop design, Implement using Fast Formula and Payroll Elements, Present CRP and support through UAT changes for the provision of Part Time and Short Notice Teachers

LBBD

OTL Demo

Demo preparation and delivery

Scottish Legal Aid Board

Support Consultant

Aid in the development and implementation of OLM and OTL. This involved core setup and Self Service Personalization’s.

IBO - Support

Support Consultant

Resolved several long running HR and Workflow calls. These calls were degrading confidence in IBO’s implementation of HR and required a large amount of research both Functional and Technical.

IBO

Internet Expenses – Consultant Support

Developed Technical Customization for Oracle Internet Expenses Approval Workflow. Assisted colleague in the Functional Implementation.

ITV, Carnival UK and Redcar and Cleveland Borough Council

OTL, iRecruitment and HR/Payroll

Used as Functional expert for pre-sales meetings with the above customers.

September 2006 – January 2008
EDS for Armed Forces Personnel Administration Agency (AFPAA) - Winchester (UK)

Oracle HRMS / Payroll Applications (11i) Functional Consultant

Key Skills and Accomplishments:

• Successfully delivered several major process reviews, from design to testing and implementation.
• Implemented high-profile payroll solutions utilizing Payroll Fast Formula, Direct Payment, and Information Element entries and Balances.
• Designed and implemented new HR and Payroll functionality based on customer requirements.
• Authored Functional & Technical Specification documents for new projects.
• Provided training and knowledge transfer to the Permanent Technical and Application Support (TAS) team and military functional leads.
• Created testing plans and scripts for custom functionality.
• Researched new functionality for HRMS/Payroll extensions, including analyzing Oracle legislation patches.
• Served as the point of contact for issues arising from the Oracle Application Framework developed Arrivals process and designed fixes to issues and aided business in data resolutions via Professional Forms.
• Worked closely with the EDS Business and Requirements Analyst team, providing solution design options for proposed changes.
• Liaised with military, EDS management, and technical resources to establish problem resolution and change priorities.
• Provided onsite support for Oracle HRMS/Payroll implementations and steady state systems (300,000 employees).
• Served as the point of contact for Oracle HR and Payroll issues.

January 2006 – September 2006
EDS for UK Defence - Swansea (UK)

• Web Designer / Developer (UK Defence)
• Gather customer requirements through face to face meetings and walk through
• Develop detailed designs of .NET systems (UML)
• Develop ASP.NET web solutions using C# and Microsoft SQL Server 2000 Database.

August 2006 – January 2006
EDS for Liverpool Victoria LARS Account– Swansea, Bournemouth, Crawley, Redditch and Sunderland (UK)

• Developer / System Administration – LV Lars
• Design/Development of Sun Solaris Unix scripts to aid running of bespoke batch system
• Install and configure UNIX and Windows 2000 software (CICS, Sun Studio One and bespoke applications)
• Develop COBOL applications from Designs
• Administer user access to Windows 2000 Citrix development environments

May 2002 – August 2004
EDS – Newcastle (UK)

Developer / PSCS/Incap

• Produce Functional and Technical designs from customers requirements
• Develop COBOL code from Technical Designs following local standards
• Aided in the development of Quality Management Processes following GSMS to help EDS Swansea gain CMM Level 3
• Point of contact for both Technical and Business questions fielded from colleagues
• Worked as part of a well organised Team and under his own initiative

January 2002 – July 2002
EDS - Swansea (UK)

Web Developer

• Aid in the design of the DVLA Drivers Car Hire Web system
• Developed COM components using Microsoft Visual Basic version 6
• Developed web sites using ASP, XML, XSL and XSLT

November 2000 – January 2002
EDS – Swansea (UK)

Info centre Helpdesk (EDS Intranet)

• Worked as 2nd line support for EDS UK and EMEA internal Intranet
• Designed and developed web sites for use on the Intranet and Internet
• Point of contact for technical queries
• Developed my understanding of programming, design and quality management concepts (CMM)