About Me

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.

manheim_logo.gif
codecomputerlove_logo.png
cga_logo.png
alpha-lsg_logo.jpg
vee24_logo.png
nhg_logo.png

March 2017 - June 2017

Zoek

Software Developer

Zoek.Uk

The Old Shippon - Moseley Hall Farm, Chelford Road, Knutsford WA16 8RB
June 2016 - January 2017

CGA Strategy

SQL developer

www.cgastrategy.co.uk

Waterloo Place, Watson Square, Stockport, SK1 3AZ
March 2016 - May 2016

Now Healthcare

Software developer
www.drnow.com

1 Lowry Plaza, Salford Quays, M50 3UB, UK
March 2013 - February 2016

Vee24

Software and database developer

www.vee24.com

Pinewood Court, Tytherington Business Park, Macclesfield, SK10 2XR
January 2012 - February 2013

Alpha LSG

Software and database developer

www.alphalsg.co.uk

Manchester Bond, World Cargo Centre, Manchester Airport, Manchester, M90 5EX
Jun 2010 - November 2011

CGA Strategy

SQL Developer

www.cgastrategy.co.uk

Waterloo Place, Watson Square, Stockport, SK1 3AZ

2010 March - May

Code Computer Love

Software Developer

www.codecomputerlove.com

Sevendale House, Dale St, Manchester M1 1JB
September 1998 - February 2010

Manheim Retail Services

Software Developer

www.manheim.co.uk

Leeds Road, Rothwell West Yorkshire , LS26 OJE

Why Me?

Why would you want David Bridge to assist with your next project?

My Skills

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!

asp.net C#
SQL Server development
MVC
SQL Server Administration
Javascript
Bootstrap
Web forms
Non-microsoft technologies

Non-technical skills

Technical ability and knowing syntax is just part of the job. Successful projects are built from much more and I've got this covered...

  • Managing projects and effective communication with stakeholders
  • Integration of different technologies. Understanding the strengths and weaknesses of each and how to exploit them
  • Managing teams or just being part of one.

Recent Projects

Here is a selection of either recent or particularly interesting projects that I have been involved with


zoek-logo.png

Job board development and integration

Spring 2017 Zoek Applications Limited

Requirement:

Incomplete back-end application and new features

Solution:

Software development and DevOps work

cga_logo.png

Generic data cubing system

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:

I created a generic system that produces "client flavoured" SSAS data cubes from common fact data with client tailored dimension data. (SQL, SSAS, Excel)

nhg_logo.png

RESTful API for mobile health care application

2016 Now Healthcare

Requirement:

This fast-growing company wanted to open their system to corporate client applications.

Solution:

We used C# on .net core with an Azure SQL Database back-end, to build a RESTful API and a Swagger document API.

vee24_logo.png

Management overview dashboard with KPIs

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)

vee24_logo.png

Web facing real-time dashboard

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)

vee24_logo.png

Secure Web-based configuration management system

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)

vee24_logo.png

Created secure web-based reporting system

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)

vee24_logo.png

Filter Payment Card Information (PCI data) from real-time chat system

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)

vee24_logo.png

Major SQL performance refactoring

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)

vee24_logo.png

RESTful API for B2B clients

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)

vee24_logo.png

Azure Migration

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)

alpha-lsg_logo.jpg

ETL system for data warehouse population

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)

cga_logo.png

ETL system and train staff

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.

cga_logo.png

Back population and consolidation of billions of rows of data

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)

cga_logo.png

Procure hardware and configure in-house SQL

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)

codecomputerlove_logo.png

Maintenance changes to web sites

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)

manheim_logo.gif

Create web sites for major vehicle manufactuers

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)

manheim_logo.gif

DBA, Monitoring and developer support

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

barclays_logo.png

Management Informaton System (MIS)

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)

Testimonials

What have people said about David Bridge?