John Kirby Email & Phone Number

Bristol, GB

Bristol, England, United Kingdom

Consultant on Data Migration project for Rathbones' acquisition of Investec Wealth and Investments. Advisory planning and architecture. Hands-on migration engineering on Azure Data Platform.

Founder of Solar Battery Scheduler. Providing an automated management service for home owners with solar and battery systems to make them efficient.

Lead developer for greenfield Integration platform using Azure Databricks, Event Hub, ADLS, Log Analytics, DevOps, connected to a variety of systems and web apis.

Development of Azure Lakehouse for analytics of real estate investment portfolios. Interim scrum master.ADF, ADLS, Databricks, Pyspark, Delta Lake, PowerBI, Snowflake, Data Vault 2, Star Schema

Advice and guidance of data modelling and development approaches for supply chain analytics using Azure SQL Database, Data Factory and Power BI.

Azure data engineer for a greenfield project, modelling OLTP and analytical data stores of product sales, packaging boms and recycling processes for new products hosted on the Azure platform; Cosmos DB, Data Lake, SQL DB, ADF, DevOps.

Bristol, United Kingdom

Project 2 - Modelling, integration and reporting of specific data for regulatory reports using the full SQL Server stack.Project 1 - Senior data consultant in an agile team delivering a large greenfield data warehouse and end-client reporting system for commercial workplace benefits, primarily pensions products. Architecture and modelling of the solution.

Bristol, United Kingdom

Project 2 – Commercial Currency Trading - Lloyds Banking Group (Feb 2018 – Sept 2018, 2 renewals)Architect and lead developer of a new commercial currency trading data warehouse on Microsoft SQL Server 2014. Led an agile team using Jira and the Kimball methodology to design and build the solution. Ran data workshops with stakeholders and users to.

Lead the architecture, design and implementation of a new Microsoft BI solution across the Group. Required diplomacy and excellent communications with directors, managers and staff to ensure BI adoption during a change in culture. Provided end-user training and assistance to successfully apply BI to improve business processes and profit.Initial priority to.

Developed a Microsoft SQL data warehouse for in-house analytics and reporting of business operations and management information.Development of Microsoft Integration Services (SSIS 2008R2) packages for gathering and loading data from various data silos into the Data Warehouse (SQL Server 2008R2) following the Kimball Dimensional Modelling methodology..

Developed PHP 5 websites using xHTML, JavaScript, jQuery and CSS 2. Developed web services using SOAP (XML), REST and bespoke HTTP POST APIs. Solely responsible for development and maintenance the Debit Card Payment system and its API with other web systems, in accordance with PCI. Design and build of MySQL 5, MSSQL 2008 and Oracle 10 databases for web.

Build of Windows 98 and XP desktop PCs and laptops for staff. Support of Microsoft Office and other software. Development support of PHP 4 intranet web systems.

Bachelor Of Science (Bsc Hons), Business I.T., 2.1

Education record