DH

Duncan Hardie

available

Last update: 06.09.2022

API & Data Architect & Engineer

Graduation: not provided
Hourly-/Daily rates: show
Languages: Arabic (Native or Bilingual)

Keywords

Attachments

DuncanHardieCV ProjectsSkillSet20.docx

Skills

Integration (EAI), SQL Server, Oracle, XML, IBM Domino, C#, X++, ASP.NET, MVC, WCF, WWF, AMQP, HTML/XHTML, AJAX, JavaScript MongoDB, ElasticSearch, Solir, MS SSIS, SSRS, XQUERY, TSQL, SQL functions, triggers, stored procedures, Web Services, SOAP, RESTful, OData ASP.NET, Silverlight Portable, XSTL, XPath, DOM, SAX, Xalan, Xerces, Google Charting API, Fusion Charts MS SQL 6.5, 7, 2000, 2005, 2010, 2012 - ODATA, DTS, OLAP, IBM Domino v4, R5 LotusScript, Java Agents, Domino API, LotusScript, Formula language, VB6, ActiveX, COM, DEV, Dynamics CRM/AX, Axapta, Autonomy/iManage, Administrator/Developer, Visual Studio 2005-08/10/12 Dataflight products, MS Source Safe / Perforce, SourceOffSite, Dynamsoft, MS SSRS, MS SSIS Bowne JFS, IPRO Crystal Decisions Products (Administrator, Adobe, Acrobat, Capture 3.0 Cluster, Exchange, Document Server, PhotoShop, dtSearch, MS, Search Lotus, IBM, Domino v4 to R6, Administrator, Ubuntu, MS IE / Firefox / Chrome, Microsoft Office Products, MS Access, Word, Excel, API, Cloud, Azure stack, Azure, DevOps, Git, Data Warehouse, analytics, NodeJS, Dynamics, Anypoint Studio, Logic, Azure SQL, Power BI, CRM, online store, webhooks, Azure Logic Apps, REST, JavaScript, debugging, SSL, Cloudflare, ETL, MDM, Azure Data Lake, SQL Data Warehouse, Blob containers, Stream Analytics, real-time data, Visual Studio Code, NET Core, OpenAPI, Apigee, SOA, M2M, Kanban, WebServices, Splunk, Okta, Maximo, JSON & XML, WDSL, XSD, RAML, AWS, data centre, application integration, Middleware, TDD, SoapUI, test suite, test case, Cloud migration, webMethods, parsing, XSLT, continuous Integration, Salesforce, REST Web Services, Mule/Boomi, APIs, Apple, MAF, ESB, Drools, MongoDB, Redis, ELK Stack, RabbitMQ, Hypermedia, JSON, AngularJS, Bootstrap, Openstack, Impala, Spring Boot, Microservices, Selenium/Gherkin, Maven, JIRA, Jenkins/Docker, release management, Data Interchange, information management, programming, design patterns, SAP PI, SharePoint 2010, Dynamics CRM, ASP.NET MVC 3 & 4, ORM, iPhone, Twilio, IBM DataPower, IBM Integration Bus, XSLT/XSL, SAP, Interfaces, data migration, data processing, Perforce, Microsoft .NET framework development, VB.NET, Active X COM & DLL development, MS SQL Server 2005, ADK, SSIS, HTML, data integrity, SQL, data capture, Access/SQL, coding, databases, MS SQL server 2K, Access 97 & 2003, Microsoft .Net, Domino, file system, ASP, SQL Server 2000, Dynamic SQL, SQL databases, database, MSSQL Server, Unicode, dummy data, IIS, NET, XML web services, MS Access 2000, Lotus Notes, Document Imaging, Document Management, Kofax, Crystal Reports, Java, Perl, Firewall, Visual Basic, XML/XSTL

Project history

04/2020 - 04/2020
Application Consultant

(Contract)

Engaged with SFC as a subject matter expert for the Field Service Lightning offering. To best
support the role as a SFC SME I became Admin accredited and partook in development courses to
strengthen my position as a SFC integration SME. Roles included:

SFC Field Service Lightning SME;
SFC Lightning Framework & Events development;
Manage users, data, and security;
Maintain and customize Sales Cloud & Service Cloud applications;
Build reports, dashboards, and workflows;
Release management;
Integration Apex Classes as REST Web Services with Mule/Boomi;

11/2018 - 01/2019
Data Visualisation Analyst
HRGO Plc

(Contract)
Nov 18 to Jan 19
Working closely with stakeholders and vendors I had the opportunity to deliver the service too both
architect & develop an enterprise wide real-time BI reporting solution for disparate datasets with a
sophisticated Cloud Warehouse, by architecting and developing a low run cost serverless Cloud ETL
Datawarehouse platform.
Using MDM data rationalisation, elements are split into Hot/Warm/Cold segments and stored
appropriately in Azure Data Lake, SQL Data Warehouse and Blob containers.
Azure Logic Apps ingest proxied API content and push records into Event Hubs that are then
transformed and enriched with other enterprise data using a prescribed sequence of Azure Stream
Analytics, more Event Hubs and Logic Apps.
Power BI reports are now able to securely surface real-time data via Direct PolyBase queries
ensuring quality visualisations on up to the moment data.
Tooling included Visual Studio Code,.NET Core, NodeJS along with the Azure stack, using and
consuming API specifications in the OpenAPI/Swagger format.

11/2017 - 11/2018
Integration Engineer & Transformation Architect
HCL Technologies

HCL Technologies
SGN Cloud Programme
Integration Engineer & Transformation Architect
(Contract)
Nov 17 to Nov 18
Responsible for advising and delivering on a large Cloud migration engagement within a large
transformation programme.
Working closely with delivery team to successfully implement agreed upon solutions across
assessment/planning, migration/implementation and operations.
Implemented Apigee to gateway and proxy hybrid-cloud-legacy SOA interfaces that are non-cloud ready
from a governance & security perspective. The Apigee implementation warranted secure and manageable
communication for various use cases between B2B, B2C & M2M channels, enforcing resource
restrictions, quotas, portal on-boarding functionality and end user specification (OpenAPI) &
documentation.
Whilst working within an agile engineering team tracking progress and backlogs with Kanban tickets,
developing good practices and driving continuous improvement in performance for the Mulesoft
Anypoint Platform. Development consisted of WebServices to be utilised by several different
consumers, including Splunk, Okta, ClickSoft, Esendex & Maximo.
Good experience using various Mulesoft/Mule related tools and technologies such as; Anypoint Studio,
Anypoint Platform, Anypoint Vault, MuleSoft Runtime, MEL, Data weave, MUnit, Mulesoft/Mule batch for
external facing interfaces.
Arranged and presided over workshops with a variety of stakeholders to create API mocks &
specification documents, process maps, to facilitate the enablement of delivery group mobilisation.
API documentation & development of IDS and schema representations were for both REST & SOAP in JSON
& XML mark-up (WDSL, XSD & RAML).

04/2016 - 11/2017
Application Consultant/Business Analyst
SGN

(Contract)
April 16 to Nov 17

Engaged in an enterprise wide Cloud Migration Programme to ensure quality analysis, design,
implementation and subsequent production rollout and support of business-critical operational
systems.
Also engaged as the ClickSoftware Application Consultant/Business Analyst SME for onboarding new
business streams. The primary responsibilities of this role are:

* AWS cooperate transformation migrating a data centre environment to Cloud using a "lift & shift"
approach where possible;
* Mule Soft Enterprise Messaging working towards implementing new and enhancing existing
application integration projects within the Middleware framework;
* Mule Anypoint Platform for PCF POC designer;
* TDD testing with SoapUI test suite and test case assertion;
* On-premise migration to Cloud migration, 8.3 to FSE;
* Integration SME for Maximo webMethods, Mule & Click;
* Business analysis regarding ClickSoftware solution requirements;
* Recommendation of possible solutions based on the business requirements and experience of
similar requirements and trends;
* Documentation production;
* Liaison and collaboration with End User and End User's partners, and other relevant parties to
support the delivery of solutions;
* Support for systems BA and solutions other than ClickSoftware;
* Middleware problem solving, traffic analysis, parsing, binding & transformation with XSLT;
* BA for continuous Integration & deployment automation business process change;

08/2015 - 03/2016
Client Architect
Carphone Warehouse Dixons Group

(Contract)
Aug 15 to March 16

Duties involve client and partner facing architect responsible for understanding the specific needs,
demonstrating the capabilities of the future state platform, primarily focused on the advanced
dashboarding & overall modular understanding of the entire platform. Working alongside sales,
relationship managers and business analysts in presentations. Owning the successful design and
delivery of technical solutions for partners and the technology/solution relationship for existing
internal and external clients as well as providing technical pre-sales support to sales teams during
new business proposals.
An Event Driven API lead strategy implemented with Mulesoft was used to enable for client/partner
on-premise/Cloud systems and environments to exchange communications securely. By creating an API
network with experience & system APIs, a library of common API assets were then available for
efficiently onboarding new and existing implementations.
Current involvements include:

* Apple
* Telstra
* Vimpelcom
* Daisy
* Brightstar
* Telefonica
* Sprint
* Al-Futtaim Group (MAF)
* Samsung

Below is a hands-on list of the toolsets used as part of the DevOps culture fostered:

MuleSoft ESB & Anypoint (RAML)
Drools
MongoDB/Redis
Solir 5.2.1
Mule Anypoint Platform Private Cloud Edition
XML/XSLT
ELK Stack/SPLUNK
RabbitMQ / Kafka SAML2/Okta REST/Hypermedia
JSON Schemas /RAML
AngularJS/Bootstrap Openstack/AWS/VNS3 Impala
Spring Boot/Microservices
(Camel)
Selenium/Gherkin
Maven/JIRA/Jenkins/Docker


Additionally provided support by optimising a legacy offering to enhance Lucien indexes served by
Solir 5.2.1, faceted artefacts needed to be provided and continuity of these enhancements for the
greenfield Eleastc implementation.

08/2013 - 08/2015
Solution Architect
Click Software

Customer facing position and integration lead in the EMEA, coupling technical and customer
relationship skills to successfully implement ClickSoftware's product offerings. Working with
project teams to perform SOA integration, technical implementation, release management and
application configuration and development to deliver one or more successful concurrent Mobile
Workforce, Service Optimisation & Roster projects.

Involvements include:

* Telecom Italia (Italy)
* Millicom/Une (Colombia)
* United Utilities
* National Grid
* Lowes (US)
* GE Healthcare
* Essex Fire Service
* National Rail
* Systems Maintenance Services (SMS)

10/2010 - 08/2013
IT Consultant
Leadent Solutions

Consultant and technical developer integral for the companies' solution design architecture and
project delivery. Extensive experience of Electronic Data Interchange, Transformation and system
integration.

Delivering clear outcomes and benefits for clients in the utilities, financial, property, accounting
and legal sectors. Characterised as a technical conduit between business and technology.

Facilitated the resolution of businesses problems by streamlining processes through the good use of
technology, leveraging system integration and data transformation skills for bespoke customisations
to off the shelf and greenfield information management solutions.

Wrote specifications for various software solutions, followed by development initiatives, software
testing, and sign off.

Influenced solution architecture & programming design patterns for service optimisation and mobile
workforce projects, resulting in selection of my recommendations. Included presentation to
non-technical subject matter expert groups.

* Click Software;
* SAP PI RFC integration & Crossgate;
* SharePoint 2010;
* Dynamics CRM/AX;
* ASP.NET MVC 3 & 4 (ORM, EF);
* iPhone hybrid app development;
* DNN;
* Twilio/Pusher/Smooth

Involvements include:
* EDF;
* SAP PI;
* Skanska;
* Serco;
* IBM DataPower Gateway;
* IBM Integration Bus (v9);
* XSLT/XSL
* SAP;
* SAP II/Crossgate
* National Grid;

12/2006 - 10/2010
IT Consultant
MRI Software Ltd (Intuit IRES)

Involved in client implementations and customisations for the EMEA (Europe, Middle-East and African)
region. Leveraging a strong technical skill set with practical knowledge of up-to-date development
platforms and an array of related technologies and methodologies I aim to produce high quality
product and level of service within the industry. Work with issue prone, time sensitive data. I have
an eye for identifying and resolving complex issues and creating innovative solutions.

During client engagements and in house activities I have worked on many varying asset/fund
management and accounting initiatives such as Electronic Banking Interfaces/e-Commerce, region
packs, dashboard & stacking plan design, data ring-fencing, CPI formulas, CIS regulations, VAT
adjustments, multi-currency environments, data migration & valuation data processing. All code is
maintained in Perforce and its my remit to investigate any core product functionality from source.

Main technologies employed are as follows:

* Banking/Valuation Interfaces: Microsoft .NET framework development (C# & VB.NET), Classic VB 6
Active X COM & DLL development;
* MS SQL Server 2005 & 2000;
* MRI ADK (Window & Web)
* MRI Report design & MS SSRS
* Data manipulation and migration: SSIS & MS Access;
* Dashboard : HTML, XML, XSLT, Fusion Charts &Javascript

01/2005 - 12/2006
IT Consultant
KrollOnTrack

Joined KrollOnTrack initially to fill a need for Tobacco Support Group (TSG) redundancy between
Kroll, Lovells & BAT. These duties involved maintaining data integrity between a multitude of SQL
based systems, along with documenting the approach TSG used. Once the secondment term with TSG was
over my duties at Kroll were to provide bespoke solutions for projects that needed more diverse
technical solutions than those currently employed for boiler plate projects. The main projects for
which my skills came into effect were off-sight government defence inquires.

In effect this position was mainly production orientated requiring liaison between client, sales
person, project manager and data capture/entry teams. In addition my day to day technical duties
involved creating new Access/SQL based coding databases and modifying/creating reports from the
companies CRM Axapta implementation.

Main technologies employed are as follows:

* MS SQL server 2K;
* MS Access 97 & 2003;
* Microsoft .Net framework development (C# & VB.NET);
* VB 6;
* OLAP;

10/2003 - 12/2004
IT Consultant
Ringtail Solutions

Joined Ringtail Solutions as a sales/technical conduit, the role involved examining business needs
for new & potential clients & to work in an R&D capacity to assist the technical team in developing
marketable additions to the core Ringtail Casebook product.

During this employment I acted as a satellite worker from home, it was essential to communicate with
others thought-out the world in many different time zones. Delegation & initiation of support,
development & client feedback thought this global infrastructure was also a major factor in ensuring
the success of day to day operations.

I was tasked to investigate the best technical approach for achieving the market requirements for an
automated solution. With the use of .NET Web Services & a transformation toolkit by Stellent I
provided a marketable prototype cross tired application that converted a multitude of electronic
document formats into a the CaseBook application environment.

Main technologies employed are as follows:

* MS SQL Server 2K;
* Classic ASP;
* IIS;
* Microsoft .Net framework development (C#,VB.NET, XML web services);
* XML;

04/2003 - 10/2003
IT Consultant
RSMi LLP

Joined the RSM Robson Rhodes Financial Services Group to facilitate the businesses increasing
technical needs. And promote the MooD toolkit through presale presentations of real world
applications of the technology.

As a consultant my skills were marketed through-out the firm in order to facilitate the business
with complex matters that could be streamlined through the use of technology. I was posted offsite &
spent considerable time away from home whilst working on projects. The migratory of this work was
for the insurance sector.

Main technologies employed are as follows:

* MS SQL Server 2K;
* MS Access 2000;
* MooD;
* Lotus Notes;
* VB6;

02/2002 - 04/2003
IT Systems Coordinator
IKON

Joined the IKON Office Solutions Document Services department to deliver development projects that
arose from the core business area of Document Imaging. Also I joined the newly formed Integrated
Document Management (IDM) team as the primary London technical resource.

The Document Imaging department provide images and meta data for clients information management
systems, I possess sound knowledge of these systems, with my assistance IKON are in a position to
offer a better end product, in addition IKON now also offer bespoke customisations to these off the
shelf information management solutions.

IKON is a large company and has many departments with other core business areas. My involvement
within the company reached into these other departments to develop solutions that better assist
management of company data.

I assisted the sales process by setting realistic goals and timescales for projects, in addition I
created proposal documents for work that fell outside the departments imaging or printing scope.

Whilst working for IKON I perform work for many clients. Below is a list of the active accounts with
which I was involved:

* Walker Morris OnLine;
* BAe;
* Clifford Chance;
* Morgan Stanley;
* Davis Arnold Cooper;
* Masefield;
* CGNU;
* ICI & Quest International;
* Allen & Overy.

Main technologies employed are as follows:

* Kofax;
* MS Access 2000;
* Lotus Notes;
* VB6;
* Crystal Reports;
* Java (Limited)
* Perl (Limited)

02/1998 - 12/2001
Consultant
G3 Consulting Ltd

I joined G3 Consulting Ltd on its first day of business, as a consultant to support solutions
inherited from the company's buy-out.

My position included implementing and managing existing solutions, scoping new solutions and
developing new solutions. I had a key role as a technical post/pre-sales consultant. I managed G3's
internal network and implemented their Firewall, and also developed many of G3's internal business
solutions.

I played a strategic role in adopting new software and technologies in order to successfully deliver
development projects. For example I successfully persuaded the business to adopt Visual Basic,
Crystal Reports and XML/XSTL standards, to broaden the type of development projects G3 are qualified
to deliver.

The area in which my skills are particularly invaluable is system integration. I have integrated
many existing technologies and products, such as Domino, iManage, PC Docs and SQL databases with
proprietary systems.

Most of my billable work is performed at client premises, which for the most part were Law Firms,
Barristers' Chambers and accountancy practices. A great deal of discretion is involved as many
clients run a non-disclosure policy. Due to this environment it is imperative that my communication
skills are of a high standard.

Whilst working for G3 Consulting Ltd. I perform work for many clients. Below is a list of the active
accounts with which I am involved:

01/1997 - 12/1998
Webmaster/Web Developer
Proarte

I was employed as a Webmaster/Web Developer for Proarte while the existing Webmaster was travelling.
When the Webmaster resigned I was promoted to his position. The tasks I performed are as follows:

* Applied dynamics of e-commerce to contemporary art resale;
* Business process analyst;
* Web page development;
* Graphic design;
* Network manager;
* Maintenance of the Dow Jones Telerate system;
* Office/Project administration.

01/1997 - 12/1998
sales assistant
Geerings Ltd

I worked full time and part time as a sales assistant in the office machinery department of the
Ashford branch. I gained valuable customer relations experience. In addition to my front line sales
role I provided weekend PC support and technical assistance to Geerings customers.

01/1996 - 01/1997
Web developer
Wye College

I started work for Wye College in their IT department during my work experience from the Towers
School. The Web was a relative new medium at the time. I had prior knowledge of the Internet as I
had worked with HTML as a hobby. For this reason the college provided me with a great deal of full
and part time employment after the end of my work experience. My main tasks are listed below:

* Creating and updating online prospectus;
* Setting up the intranet;
* Creating departmental and research pages;
* General PC / MAC support.

Local Availability

Only available in these countries: United Kingdom
Profileimage by Duncan Hardie API & Data Architect & Engineer from API & Data Architect & Engineer
Register