Business Intelligence Consultant
Birchwood, Gb
Betfred is a UK-based bookmaker, named after its co-founders Fred and Peter Done. It was first established as a single shop in Ordsall, Salford, in 1967. Its turnover in 2004 was more than £3.5 billion, having risen from £550 million in 2003. As of February 2016, the company has 1,370 betting shops.I was brought in to consult & manage and deliver a complete ground up re-write of the main Data Warehouse, Data marts & analytics platform that drives all the self-service BI and reporting for Betfred’s digital online presence.HighlightsLead the initial team to start the project gradually adding members from the BAU team to bring the platform up to production quality.Dramatically improving the performance, reliability & availability of the Data Warehouse & Analytics Platform Introduced DevOps and implemented a full continuous integration & delivery life cycle.Used agile methodology to build and deliver the new environment.Designed and built a meta data driven ETL platform utilising BIML to automatically build the ETL system.Integrated disparate source data systems including Oracle, SQL, MySQL, AWS RDS, HTTP, SFTP platforms.Managing huge data sets > 10TB in size.Implemented a 3rd Normal Form Data Warehouse (Inmon) and Star Schema at the Data Mart layer (Kimball).SQL Server 2016, SSIS, SSRS with Mobile Reports.PowerBI Analytics via Azure Data Gateway for accessing on premise data.Architected a new on premise hardware platform for the new data warehouse environment. PowerApps for democratisation of corporate data. Allowing other departments and partners to manage master data in a secure manner.