Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

Paul Patterson

Liverpool

Summary

Highly skilled IT professional with extensive experience in SQL Server (2000-2019), .Net (3.5-4.7), and web technologies including HTML, CSS, and JavaScript. Proficient in developing and maintaining robust applications using VB.Net, Web Services, and Ajax. Expertise in database management, reporting services, and cloud solutions with Azure. Adept at utilising tools such as GIT, SwaggerHub, Sentry, and Crystal Reports to enhance project efficiency. Committed to leveraging technical skills to drive innovation and achieve organisational goals.

Overview

23
23
years of professional experience
4
4
years of post-secondary education

Work History

Applications Design consultancy

Homecare Service Centre
Aintree
06.2018 - 12.2025
  • Systems architecture install
  • Enhancements to existing CRM (which I built previously) system
  • Full ETL (and merge) of historical data from three legacy systems to new CRM build
  • SSRS MI suite design and build
  • Cloud server install and management
  • Moving system to cloud including disaster recovery, backups and security
  • Hosted VOIP system installation and integration into CRM
  • Automated SMS / Emailing integration into CRM
  • Call recording integration into CRM
  • Direct debit collection software integration into CRM
  • Bespoke firewall configuration
  • Creation of mobile (tablet) module to allow deployment of tablets to engineers
  • Tablet fleet management
  • Mobile device control (using IBM Maas360)
  • Google Routing
  • API builds
  • Engineer app creation and release
  • Card machine integration
  • Skills Technologies Used: SQL Server 2016/2019, .Net 4.7, VB.Net, Web Services, HTML, CSS, Jquery, Windows Server, Azure, GIT, SwaggerHub, Sentry, Laravel
  • Developed comprehensive consultancy strategies for improved business operations.
  • Managed complex projects to ensure timely completion and quality results.

ETL consultant and application developer

One Manchester Housing
06.2016 - 06.2018
  • Validation and transformation of ‘survey tool’ application data
  • Load above data into new installation of Aareon QL management solution
  • Design and build new ‘survey tool’ using web application technologies
  • SSRS report writing using data from Aareon QL
  • Orchard Housing QL Housing integration
  • Skills Technologies Used: areon QL, Orchard Housing, SQL Server 2014, Reporting Services, .Net 4.0, LINQ, Entity Framework 5.1, HTML, javascript, CSS, jQuery, Enterprise Library 5.0, Windows Server 2012, Visual Studio 2010, VB.Net

Applications Design consultancy

Homecare Service Centre
Aintree
05.2015 - 06.2016
  • Full CRM system architectural and functional design and build
  • Modules including customer, products, stock control, finance, MI reports, fleet management
  • Full MI reports suite using SSRS
  • Skills Technologies Used: SQL Server 2016, .Net 4.7, VB.Net, Web Services, HTML, CSS, Jquery, Windows Server 2016

Applications Design and Build

Your Housing Group
Warrington
09.2014 - 05.2015
  • Web based Risk Assessment application for internal use
  • Web Based KPI Data Capture Application
  • SQL Server infrastructure
  • Financial Systems Consultancy
  • SSRS
  • Skills Technologies Used: SQL Server 2008 R2, Reporting Services, .Net 4.0, LINQ, Entity Framework 5.1, HTML, javascript, CSS, jQuery, Enterprise Library 5.0, Windows Server 2008 R2, Visual Studio 2010, VB.Net

Applications Design and Build

Barcode Tech
Liverpool
09.2013 - 06.2014
  • New sales and procurement business in need of internal management system to facilitate and management large sales and maintenance contracts
  • End solution was a secure web based system
  • Full system architecture design encompassing database and functional
  • Modules include stock and product catalogues, Clients, Maintenance, Orders, Suppliers, Finance and System Administration
  • Full reports module using SSRS
  • Skills Technologies Used: SQL Server 2008 R2, Reporting Services, .Net 4.0, LINQ, Entity Framework 5.1, HTML, javascript, CSS, jQuery, Enterprise Library 5.0, Windows Server 2008 R2, Visual Studio 2010, VB.Net

Applications Developer

Your Housing Group
Preston
12.2012 - 09.2013
  • Brought in to provide solutions to the finance teams to help smooth the merger of two major housing associations with respect to their diverse third party management systems
  • The crux of the problem was to parse housing benefit files based on which ever system the appropriate tenancy resided in and produce output files to enable automatic import into target housing management systems
  • The merging of both sets of data was phased so the solution had to provide integration into both Orchard and IBS housing systems through SQL Server via ODBC connections
  • Final solution was in the form of a secure web application providing the necessary functionality to upload and parse txt and csv files
  • The data contained in these files was then presented to the user to select which target system the data would eventually end up in
  • This solution was later expanded to include other payment methods such as bank statements and other import routines
  • The web application was secured via a combination of SQL roles and logins and windows authentication based on active directory– essentially single sign on
  • Solution had to handle many variations of file structure and this was held in the database and was fully configurable and extendable
  • Other aspects of the solution include archiving of all data and files processed, complete logging, security
  • Skills Technologies Used: SQL Server 2008 R2, Stored Procs, Table Types, .Net 4.0, Linq, Entity Framework 5.1, HTML, javascript, CSS, Enterprise Library 5.0, Windows Server 2008 R2, Orchard Housing, IBS Housing

MI Developer

Hill Dickinson
Liverpool
09.2012 - 11.2012
  • Creation of SSRS reports from specification
  • SSRS consultancy
  • SSIS package production and management
  • SSIS consultancy
  • Skills Technologies Used: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SSRS, Stored Procs

Senior Software Developer

Autocoding Systems Ltd
Sutton Weaver, Cheshire
08.2011 - 08.2012
  • Conversion of existing classic asp / crystal reporting system to .Net 3.5 / SSRS
  • SSRS dashboard providing snapshot production line machine state
  • MSSQL XML capabilities
  • Requirements gathering
  • Analysis and design
  • Database design
  • Functional design
  • Distributed MSSQL database systems – master / client
  • Linked Servers
  • MSSQL Change tracking
  • Bespoke managed audit implementation using triggers
  • Bespoke multi language / localisation implementation for web / windows applications
  • Bespoke synchronisation push and pull routines across master / client distributed database systems – using T-SQL and change tracking
  • Windows Server 2008 R2 Administration (IIS and Database)
  • Skills Technologies Used: Asp.Net 3.5 / 4.0, VB.Net, XML, Javascript, CSS, HTML, jQuery, Ajax, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SSRS, Change Tracking, Stored Procs, Triggers, UDFs, Windows Server 2008 R2

Senior Software Developer

Safety Software Limited
Rainhill, Merseyside
03.2007 - 06.2011
  • Conversion of legacy health and safety reporting systems from classic ASP to .Net
  • Conversion included Crystal reports to SSRS 2005
  • Roll out to numerous clients worldwide
  • Plan, coordinate and implement bespoke client requests
  • Database design, build and implementation
  • Database administration
  • Development of ETL import routines
  • Research and development into XML support (.net and SQL) and subsequent build and implementation of one time, re-usable save and load routines for .Net web applications
  • Implementation of multi-lingual support using .Net
  • Windows Server management
  • Implementation of source control
  • Single Sign On implementation for both legacy ASP and .Net
  • Client requirements
  • Skills Technologies Used: Asp.Net 2.0 / 3.5, VB.Net, XML, LINQ, Javascript, CSS, HTML, Ajax, SQL Server 2005, SSRS, Stored Procs, Triggers, UDFs, Windows Server 2003, Crystal Reports, Classic ASP

Senior Software Developer

Iware Systems Ltd
Liverpool
10.2005 - 03.2007
  • Design, build and implement classic ASP booking system for Cavern City Tours Magical Mystery Tour
  • Design, build and implement .Net hotel booking system for Beatle Week Festival
  • Design, build and implement .Net scheduling system for band management for Beatle Week Festival
  • Design, build and implement .Net system covering ‘cradle to grave’ process of Insurance Contractor industry
  • Windows Server 2003 management
  • SQL Server 2005 administration

Software Developer

Reidmark
Liverpool
08.2002 - 10.2005
  • Working on design and development of numerous web based data driven classic systems
  • Quite a few in the LSC sector
  • Two systems tailored towards asset management (housing)
  • Skills Technologies Used: HTML, Ajax, SQL Server 2000, SQL Server 2005, Classic ASP, Javascript, VBScript, CSS

Education

BSC(Hons) - Computer Studies

Liverpool John Moores University
Liverpool
09.1997 - 06.2001

Skills

  • SQL Server 2016/2019
  • Net 47
  • VBNet
  • Web Services
  • HTML
  • CSS
  • Jquery
  • Windows Server
  • Azure
  • GIT
  • SwaggerHub
  • Sentry
  • Laravel
  • QL
  • Orchard Housing
  • SQL Server 2014
  • Reporting Services
  • Net 40
  • LINQ
  • Entity Framework 51
  • Javascript
  • Enterprise Library 50
  • Windows Server 2012
  • Visual Studio 2010
  • SQL Server 2016
  • Windows Server 2016
  • SQL Server 2008 R2
  • Stored Procs
  • Table Types
  • SQL Server 2008
  • SSRS
  • AspNet 35 / 40
  • XML
  • Ajax
  • SQL Server 2005
  • Change Tracking
  • Triggers
  • UDFs
  • Windows Server 2003
  • Crystal Reports
  • Classic ASP
  • SQL Server 2000
  • VBScript

Affiliations

  • Squash
  • Chess
  • Football

Timeline

Applications Design consultancy

Homecare Service Centre
06.2018 - 12.2025

ETL consultant and application developer

One Manchester Housing
06.2016 - 06.2018

Applications Design consultancy

Homecare Service Centre
05.2015 - 06.2016

Applications Design and Build

Your Housing Group
09.2014 - 05.2015

Applications Design and Build

Barcode Tech
09.2013 - 06.2014

Applications Developer

Your Housing Group
12.2012 - 09.2013

MI Developer

Hill Dickinson
09.2012 - 11.2012

Senior Software Developer

Autocoding Systems Ltd
08.2011 - 08.2012

Senior Software Developer

Safety Software Limited
03.2007 - 06.2011

Senior Software Developer

Iware Systems Ltd
10.2005 - 03.2007

Software Developer

Reidmark
08.2002 - 10.2005

BSC(Hons) - Computer Studies

Liverpool John Moores University
09.1997 - 06.2001

Similar Profiles

  • KENNETH NWAKAUBA

    KENNETH NWAKAUBAKENNETH NWAKAUBA

    HealthCare Assistance / Caregiver at Atlantic Medical Centre/Homecare ServiceHealthCare Assistance / Caregiver at Atlantic Medical Centre/Homecare Service

    View Profile
  • MICHAEL ACHEM ATTA SENIOR

    MICHAEL ACHEM ATTA SENIORMICHAEL ACHEM ATTA SENIOR

    Registered Nurse at Mimi Homecare CentreRegistered Nurse at Mimi Homecare Centre

    View Profile
  • Malissa Russell

    Malissa RussellMalissa Russell

    Health Care Aide at WestView Health Centre HomecareHealth Care Aide at WestView Health Centre Homecare

    View Profile
Paul Patterson