Julian Holling

Engaged to develop a RESTful API (and later a web application) to provide endpoints for a bespoke ERP application. The API was to be made available to third parties to allow them to manage their own orders.

The Web application was created as a in house tool to allow the internal staff to manage Customers, Products, Orders, Billing, Reports, Network Infrastructure etc

Achievements:

• Created a RESTful WebApi written using ASP.NET core and EF core using C#, code first with Fluent API, Data Migrations and SQL Server. Hosted in Azure, secured by JW Tokens.
• Created a Web Application (Portal), written using C#, ASP.NET core using Razor Pages. A CSS template was used and bootstrap as a UI framework was used for layout.
• Integrated the Oneserve job management APIs into the MS3 API for scheduling engineer workload.
• Integrated the ArcGIS API's into the MS3 API to aid management for visibility of available properties to roll out Fibre connections and the current network architecture.
• Integrated Hangfire to schedule regular updates from Oneserve (job status updates) and ArcGIS (network infrastructure updates).
• Created a Portal (Web Application) to allow the internal staff to manage MS3 company assets including Customers (partners), Products, Orders, Network Infrastructure etc. Several reports were made available via the portal including current open orders (automatically filtered for partners so they could only see their own data), existing connections (partners can only see their own connection information), list of all properties available for connection. Interactive maps were created using MapBox.js to show current network infrastructure status including active connections, connections on order and properties where a connection cannot currently be made.
• Involved in the configuration of the system to allow partners such as uSwitch and TalkTalk to create orders on behalf of other third parties.

Technologies used:

• C#
• ASP.NET core
• SQL Server
• Azure
• Blob Storage
• Swagger
• PostGres
• Hangfire
• jQuery
• JavaScript
• Bootstrap
• Razor Pages
• MVC
• JW Tokens
• GitLab
• Jira
• Agile
• Mapbox.js

Employed on a permanent basis to support the development and maintenance of internal software to manage the supply of lease vehicles to the automotive industry.

Achievements:

• Helped to develop MicroService endpoints to capture and process user intent on Vehicle Purchase Options inclusing options to Waive, Purchase Or Defer.
• Developed a standalone WPF application to prettify and compare two JSON configureation files for the purposes of easily identifying configuration changes. The application automatically opened the files in WinMerge (if installed).
• Developed and application to compare two configurations (internal to the System) and perform any updates on the configuration at the time the application was deployed. The current configuration was stored in an AWS S3 bucket and any mods to the target config file was logged to the console and also into SPLUNK.
• Maintained a couple of React.js components. (Classes).
• Used XUnit and MOQ to create unit tests for C#, JEST with Enzyme for React components. Latterly moved to a TDD methodology for C# using test fixtures.

Technologies used:

• C#
• ASP.NET core
• MicroService Architecture
• AWS
• React
• XUnit
• MOQ
• Jest / Enzyme
• WinMerge
• AWS Buckets
• PostGres
• Fluent Assertions

Employed on a permanent basis to assist in the creation of a new set of Restful API's to support a new collaboration between VentureAxis and Hawk-Eye Innovations for the capture, transformation and presentation of event tracking data for sporting events.

Achievements:

• Created a RESTful WebApi written using ASP.NET core and EF core using C#, code first with Fluent API, Migrations and SQL Server hosted in Azure for the 2021 EUFA cup event.
• Created a RESTFul WebAPI to transform player tracking data capture using Hawk-Eyes multipele camera system, pushed into Pulsar and at scheduled intervals stored in SQL Server for the purposes of providing real-time, Delayed and Post match analytical data.
• Researched the best technology for the purposes of managing the capture and queing of the data.

Technologies used:

• C#
• ASP.NET core
• Redis Cache
• AWS
• RabbitMQ

Employed on a permanent basis to support and enhance existing systems which allow pharmacies to drive compliance and take control of their own purchasing options.

Achievements:

• Created an auto updating caching system that refreshes based on a data change in the database. Uses SqlDependency as the driver for the automatic updates to the cache. This has been added to a new customer facing website written in C#, ASP.NET core using razor pages.
• Partially implemented a flexible graphing application using jQuery, HTML and Chart.js. The data for the graphs is driven by stored procedures and dynamic SQL. Code behind is written in VB.NET using ado.NET.
• Integrated an HTML editor into the back-office systems to maintain documents for a new customer facing web site. The documents are for carousels, news items etc and are stored as HTML in a SQL Server database.
• Completed a partially developed returns process in two disparate web sites (one for pharmacies and a separate application for hospitals)

Technologies used:

• C#
• VB.NET
• JavaScript
• jQuery
• HTML
• ASP.NET core
• Razor Pages
• Chart.js
• SSRS
• SQL

Engaged to develop microservices as part of a data integration project

Achievements:

• Developed the Stock Reconciliation microservice in C# .NET core using T-SQL stored procs to transform the data.
• Developed the Add Product microservice in C# using T-SQL stored procedures to transform the data.
• Developed the Edit Product microservice in C# using T-SQL stored procedures to transform the data.
• Developed the Expected Goods Receipt microservice in C# using T-SQL stored procedures to transform the data.
• Developed the Payment Reconciliation microservice in C# using T-SQL stored procedures to transform the data.
• Created a Web Application in ASP.NET core to allow the configuration of the microservices, monitor queue event failures and allow the events to be re-submitted.
• Wrote in depth technical documentation on the microservice endpoints (request parameters, response messages, data formats etc) to be provided to third parties.

Technologies used:

• C#
• ASP.NET core
• T-SQL Stored Procedures
• Bootstrap
• JavaScript
• RabbitMQ

Engaged to maintain and enhance the Glance web application.

Achievements:

• Modified the Service function to retrieve an address's long and lat value for addresses outside the UK which don't have a post code.
• Used the Google Maps api to provide a map picker function for addresses that could not be found automatically.
• Modified the process of taking a payment so the response from the payment is automated.
• Supported and mentored Junior developers in bootstrap and C#
• Added Dependency Injection through Autofac, implemented interfaces on business objects and added some unit tests.

Technologies used:

• C#
• jQuery / jQueryUI
• Google Maps Geocoding Api
• Bootstrap
• ASP.NET WebForms
• JavaScript
• Autofac Dependency Injection

Engaged as a consultant web developer to work on a number of RESTFul web services.

Achievements:

• Implemented a RESTFul web service to retrieve car part stocks and prices for a given part group e.g. Braking components
• Created a Windows Service to transfer files via SFTP / FTP from one server to another. Also handled Transformations and emailing files
• Documented the API's I developed using Swagger / Swashbuckle to be able to provide a descriptive endpoint for the client (Halfords)
• Investigated IdentityServer (OAUTH/OWIN provider) as a method of protecting the public facing Urls
• Successfully implemented SignalR as a method of passing data from the client to the server and "tunneling" service calls.

Technologies used:

• C#
• Rebex
• OpenApi 2.0
• Json
• Xml

Engaged as a consultant to analyse and manage the migration of web services (WCF) from older servers to new servers.

Unfortunately I finished this assignment early due to un-forseen circumstances surrounding the commute.

Achievements

• Reverse engineered and documented the current settings of a number of web services hosted on older server technology.
• Created scripts to update the configuration settings of each of the web services from the old server location to the new server location.
• Created a number of tasks and jobs in Visual Studio Team Services highlighting the required steps to successful migration.

Technologies used:

• Visual Studio Team Services
• IIS
• C#
• SQL Server

Engaged as a short term consultant to work on a number of projects

Achievements

• Re-developed a report to be included in a Safety Reporting Pack indicating when scheduled work was to take place on track and what safety measures need to be put in place for the work to commence.
• Involved in the design and development of a track plant and machine planned maintenance application to allow the entry and reporting of scheduled maintenance on track and plant machinery

Technologies used:

• C#
• SQL Server
• Entity Framework
• ASP.NET MVC
• Microsoft Reporting Tools