Designing and building a new DWH and associated Dimensional Models for an insurance firm specialising in vehicle warranty and related protection products.Responsible for the new ETL (SSIS) framework, pipelines, Dimensional Models and Cubes (including MDX) and presenting the SSAS cubes via PowerBI, SSRS and Excel (PowerPivot).Working with actuaries to design and build specialist revenue forecasting models.Leading and mentoring junior staff.

Designing the Dimensional Model for George.com’s online business and the build instructions\designs for the ETL pipelines, to be built by Asda’s offshore development teams\partners.

Designing, building and deploying SSRS reports for Healthcare clients, and creating automated Development Environments using Powershell – VS2017, SSDT, SQL Server 2017 and Tortoise\SVN.

Designing and building a DW and its ETL pipelines for a Financial Services firm, using SQL Server and SSIS - retrieving data from a variety of systems: Progress OpenEdge, SQL Server & Telephony systems.Including the ETL pipelines for the incremental and initial loads - dealing with SCD2 dimensions and a full historical load whilst ensuring data quality.Designing and deploying SSAS cubes utilising Temporal Snapshot designs providing very high compression rates and surfacing data via Qlikview and SSRS.

Designing and building a Data Mart for NHS England to allow the analysis of Mental Health referral data – a full Data Warehouse development lifecycle including user workshops and requirements gathering.This included the ETL (SSIS) pipeline\s, Dimensional Model\s (SQL Server 2014) and Cubes (SSAS 2014) including MDX and presenting the SSAS cubes via an OLAP browser.Also included the design and build of a proof of concept SSAS cube for NHS England's Cancer Waiting Times project to track milestones.

Stakeholder management and collaboration with other Product and Development teams to shape and contribute to the overall BI architecture and systemsExtending the coverage of the Data Warehouse (Dimensional Model).

Working as part of a team to deliver Data Warehouse solutions for Amey’s Facilities management contracts.Full Data Warehouse lifecycle ranging from user workshops, integrating multiple sources from Microsoft Dynamics CRM to in-house applications into a Kimball Data Warehouse, via SSIS, building cubes and deploying reports via SSRS.

Design and implementation of Data Warehouse (including ETL sub-system design) involving the integration of diverse systems such as Microsoft CRM 4.0, Dynamics GP and proprietary web based CMS. Delivering BI solutions via SSRS and Business Objects XI.Providing SQL Server expertise\mentoring to DBA's and development\infrastructure teams with regard to advanced T-SQL, Database design, Indexing Strategies, Storage Design and Disaster Recovery\Business Continuity Planning.

Projects ranged from implementation of MS Dynamics, and MOSS 2007 across multiple sites to Virtualisation technology within the SQL Server estate using VMWare and the associated storage strategy using EMC Symmetrix. This included High Availability catering for site failure and real time DR provisioning for the SQL Server stack. Also included operational responsibility such as the optimisation of T-SQL, providing design guidance to junior staff and Development teams, and performance tuning of production systems, including Indexing strategies and hardening.

Total lifecycle responsibility and management of Data Warehouse and associated ETL processes, in the Financial Services Sector, working for one of the largest 3rd party mortgage processing companies, in the UK.Providing design and architectural input to development teams and cross functional project teams.The development of systems to manage automated reporting from Data warehouse\ODS.

SQL Server contractor working in diverse sectors ranging from Energy Generation to Financial Services (credit card processing)

Support and implementations of Baan ERP and SQL Server, including migrations to SQL Server 7.0

Part of a team responsible for the complete migration of financial systems from a proprietary Unisys system to a Microsoft based client\server solution, including the complete design of a 200+ site LAN\WAN enterprise, with sole responsibility for SQL Server systems.