* Proposed and planned a restructure of the warehouse solution to use database projects within Visual Studio to decrease the time from requirements to delivery to the business while minimising failures using Azure Managed Instances.* Adopted and structured the use of GitHub to maintain versioning and release management of changes to the new data warehouse solution.* Started using DevOps to help assist in priority tracking and change management and advised on how to expand the use of DevOps to the entire data warehouse development team.* Optimised DAX statements within multiple Tabular Models in Azure Analysis Services Servers.* Significant changes to the data warehouse to resolve serious performance and stability issues implemented over time to reduce business impact.* Significantly improved the capture and quality of Excel based data feeds using semi-automated load processes.* Extended the available measures and attributes in multiple tabular models to suit diverse regional requirements.* Enhance the data quality of the warehouse through rigorous data analysis and testing.

* Rapidly designed a Kimball star schema data warehouse for a global corporate law firm during a major firm wide upgrade and business alignment of two separate merged legal partnerships to deliver globally consistent reporting from two separate source systems. * Mentored contract team members with no experience in the legal industry. * Acted as the lead developer in a global Agile project team of developers and testers to deliver a critical solution within the project deadline. * Drove the adoption of additive structures in the warehouse to eliminate the need for rework caused by evolving business requirements. * Created essential executive dashboard reports in SQL Server Reporting Services, coded to a high standard to appeal to the Partners of the firm. * Produced bug free code under high stress which allowed successful delivery of the data warehouse globally. * Provided continual enhancement of the new solution after the global delivery to achieve the ultimate goal of the project, one solution with global relevance that will evolve with the business.

* Secured and maintained an XAMPP website using Apache, PHP and MySQL to reduce running costs on an Azure platform. * Enhanced the website above to provide a more user-friendly reporting interface based on feedback from an industry expert. * Implement a WordPress website.

* Replaced a SAP DW reporting solution with a Microsoft SQL Server based approach to reduce support costs. * Modelled a new data warehouse containing detailed sales information of 800 million rows to allow both basket analysis and report on the success of promotions. * Enhanced the new data warehouse after engagement with the business to support stock control reporting, replacing an existing Microsoft Access reporting solution. * Built and documented a new low-cost standard computer image to replace expensive legacy Point of Sale terminals while improving performance.

* Successfully transitioned a data warehouse from SQL 2005 to DB2 with no business impact. * Automated testing of a third-party weighbridge system to speed up delivery of a system upgrade. * Automated posting of sales data from the weighbridge system to the general ledger.