I started programming computers when I was just 10 years old so it was probably predictable that I would ultimately attend university to study software development and head my career down that path. My interest in data and analysis however, came much later during my 11 year position at Manheim Retail Services where I was responsible for all of their database servers. Following this with many years of contracting experience, I have maintained a keen interest in application software, database technology and data analysis.
With 25 years of experience in a wide range of technologies, my main skill doesn't lie in one specific technical area. If I had to pick one main skill then it's the ability to bring technologies together as a whole with a lot of consideration to performance, reliability, scalability, and longevity.
I have attempted to rate my experience graphically below taking in to account how recent the experience was, the version of the environment and the amount of features I have used.
Nobody can ever know everything and skills level is subjective so I reserve the right to change my opinion here at any time. It's a good job this is content managed!
Projects: Click anywhere on the project to view its detail.
2022-2025 Church Commissioners for England
Requirement:
The Church commissioners for England manage an £11bn endownment fund with the aim of providing £400m per year for Church of England activities, whilst continuing to grow the fund.
Solution:
Provision of Data Engineering, Automation, Analysis, and Reporting using bespoke software, Azure technologies, and the Matrix Investment Management Platform (Rimes), with data from JPM, Limina, efront, Bloomberg, FRED, and many more data management companies.
2021-2022 Coeo (Pantheon Adventures)
Requirement:
Business Information with Power BI
Solution:
Provided technical output and stakeholder presentations on Power BI
2021-2022 Coeo (Cabot Finance)
Requirement:
Data Engineering / Automation
Solution:
Provided technical output and stakeholder training and presentations on Automation, Databricks and System Configuration.
October 2020 - July 2021 First Central Group
Requirement:
Build a Data warehouse
Solution:
I worked on the Data Lake "Variables" project, which is part of the company's Data Transformation Programme (DTP).
May 2020 - June 2020 Health Shield Friendly Society
Requirement:
Build a Data warehouse
Solution:
This project was designed to raise awareness and understanding of the need for a data warehouse by demonstrating the possibilities through a spike
Mid 2019 - June 2020 Health Shield Friendly Society
Requirement:
Design and build REST API for web application
Solution:
Created a secure API and supporting Azure SQL Database for a new customer-facing application using DotNet core 3.1
September 2018 - Mid 2019 Health Shield Friendly Society
Requirement:
Migration of in-house services to a managed service provider
Solution:
Arranged for the provision of configured servers with extensive pre-live testing and effective communication with all concerned stakeholders. This was a large team effort.
April 2018 - September 2018 Really Good Domains
Requirement:
Reporting and analytics solution
Solution:
Power BI front-end reporting
ETL using CQRS based Dotnet core application with Azure message bus and Azure SQL Database (SQL Server 2017)
June 2017 -April 2018 Missguided
Requirement:
Data Migration project
Solution:
ETL operations using Integration Services
Spring 2017 Zoek Applications Limited
Requirement:
Incomplete back-end application and new features
Solution:
Software development and DevOps work
2016 - 2017 CGA Strategy
Requirement:
To build data cubes using SQL Server Analysis, but with nearly 400 live databases this looked like a huge undertaking.
Solution:
Created a generic system that produces "client flavoured" SSAS data cubes from common fact data with client-tailored dimension data. (SQL, SSAS, Excel)
2016 Now Healthcare
Requirement:
This fast-growing company wanted to open their system to corporate client applications.
Solution:
Created C# .net core REST API with an Azure SQL Database back-end, including Swagger documentation.
2015 Vee24
Requirement:
Allow their clients to be able to see fast management overview information using web browser.
Solution:
Created management overview dashboard showing fast response high level KPI versus actual summaries. (JavaScript / JQuery / HTML5 Canvas)
2015 Vee24
Requirement:
Create a web-facing real-time dashboard showing operator availability and customer waiting times.
Solution:
Created secure web-socket based dashboard with ability to drill down to finer detail. (SignalR, Bootstrap, JavaScript, C#, SQL)
2014 Vee24
Requirement:
Old SharePoint system was slow and hard to use with poor security and maintenance.
Solution:
Created Configuration Management System using C# MVC and Bootstrap to replace ageing SharePoint system. (C# .net, MVC, SharePoint, Bootstrap, JQuery, JavaScript)
2014 Vee24
Requirement:
Old reporting system was slow and ineffective with accuracy and security issues.
Solution:
Created secure reporting system presenting time-zone sensitive data using templates. (SQL, SSRS, SQL CLR .net extendibility)
2014 Vee24
Requirement:
The chat needed to be filtered in real-time to prevent PCI data from being entered.
Solution:
I created a SQL CLR object to handle three main areas: Regular expressions, time zone conversions and base64 encoding and decoding. (SQL Server, C#.net, RegEx)
2013 Vee24
Requirement:
The live system was over-powering the SQL resource causing slowdowns and reliability issues.
Solution:
Found many inefficiencies and design errors and fixed them whilst adding new features and enhancing existing ones. (SQL Server, C# .net web handlers, SOAP)
2015 Vee24
Requirement:
Allow B2B data transfer of historic data using REST API
Solution:
Created an API (with Azure Management API front end) to provide clients with secure and monitored access to raw JSON data (SQL, C# .net, Azure, REST)
2014 Vee24
Requirement:
Development servers were handled in-house and production in local data centre.
Solution:
Moved dev system to Azure, Created prototype production system for back-end SQL Server 2014 Enterprise with Always On High Availability Groups on Microsoft Azure (SQL Server, AlwaysOn, Azure)
2012 Alpha LSG sky chefs
Requirement:
Get data from many disparate systems to produce consolidated view using local Analysis Services cube
Solution:
Created many ETL processes and a management system for monitoring them. Trained staff. (SQL, SSAS, SSIS)
2010 - 2011 CGA Strategy
Requirement:
Create ETL to import from multiple clients in vastly different formats
Solution:
Created many ETL systems using a template approach to allow permanent employees to maintain and enhance the system. Trained staff.
2010 - 2011 CGA Strategy
Requirement:
Lots of data in Access needed importing in to SQL Server, cleansing and consolidating.
Solution:
Imported and consolidated data and set up partitioning to allow faster access and easier maintenance. (SQL Server)
2010 CGA Strategy
Requirement:
Need for a stable, fast and reliable system to store, process and serve billions of rows of data
Solution:
Specified Dell rack server and SAN for SQL Server, set up server and populated with historic data. (SQL Server, hardware, Windows Server)
2010 CodeComputerLove
Requirement:
Many changes to many projects in tight timescales
Solution:
Working with unfamiliar code across many projects in tight timescales and wide range of tech. (C# .net, JavaScript, various 3rd party plugins)
1999 - 2010 Manheim Retail Services
Requirement:
Provide systems for users to search for vehicles within the Volkswagen Audi group, Toyota and other major vehicle manufacturers
Solution:
Created many web sites for heavy load, high concurrency systems (C# .net, SQL Server, HTML, JavaScript)
2007 - 2010 Manheim Retail Services
Requirement:
Management of multiple clustered production database servers and in-house development servers
Solution:
Keeping systems running fast and reliably. Creating best practices and ensuring they are adhered to. Supporting the dev team
1998 Barclays Bank
Requirement:
Monitor and report on Call Centre activity using web-based reporting
Solution:
Created a system for capturing data and reporting on it using browsers on an intranet, which at the time was quite innovative. (VB, Cognos, Access reporting)
What have people said about David Bridge?