- Maintaining and developing the existing databases and accompanying data models, ETL etc. across multiple environments. - Leading on the migration of legacy databases and business logic, refactoring where necessary to improve efficiency, readability and enforce database standards. - Collaborating with product, testers and front end developers on the delivery of new website features from inception to delivery. - Building out the back end of a new external API to enable… Show more - Maintaining and developing the existing databases and accompanying data models, ETL etc. across multiple environments. - Leading on the migration of legacy databases and business logic, refactoring where necessary to improve efficiency, readability and enforce database standards. - Collaborating with product, testers and front end developers on the delivery of new website features from inception to delivery. - Building out the back end of a new external API to enable more flexible data submissions from third parties. - Leading on the build of a multiple data models to facilitate reporting via PowerBI. - Identifying opportunities for optimisation and implementing changes in ADF. Show less

- Technical lead on a production SQL server migration. Single instance 2008 R2 to multi environment 2017 upgrade and migration including DBs, ETL (SSIS) & SSRS.- Moving DB schemas, SSIS & SSRS solutions from the file system to Azure DevOps to enable version control and audited collaboration for bugs & fixes etc.- Responsible for the ongoing maintenance and development of the new production SQL server (2017) for operational reporting within the business.- Building bespoke ETL… Show more - Technical lead on a production SQL server migration. Single instance 2008 R2 to multi environment 2017 upgrade and migration including DBs, ETL (SSIS) & SSRS.- Moving DB schemas, SSIS & SSRS solutions from the file system to Azure DevOps to enable version control and audited collaboration for bugs & fixes etc.- Responsible for the ongoing maintenance and development of the new production SQL server (2017) for operational reporting within the business.- Building bespoke ETL pipelines to accommodate 3rd party data upgrades (TSQL, C#, SSIS, XML, JSON, web APIs).- Completed change management training for raising full production changes.- Working on and delivering to multiple projects simultaneously.- Continued to act as a data SME for actuarial and other analytical colleagues.- Relentlessly seeking data quality and DB/ETL efficiency advances wherever possible. Show less

- Responsible for the maintenance and development of a production SQL server for operational reporting within the business (TSQL, PL/SQL, SSIS, SSRS, C#).- Building dashboards to meet dynamic business requirements (Tableau, SSRS).- Developing a suite of bespoke tools to automatically document the relationships and interactions between objects within our SQL server (XML, SQL, VBA, SSRS, SSIS).- Working on and delivering to multiple projects simultaneously.- Acting as a data SME… Show more - Responsible for the maintenance and development of a production SQL server for operational reporting within the business (TSQL, PL/SQL, SSIS, SSRS, C#).- Building dashboards to meet dynamic business requirements (Tableau, SSRS).- Developing a suite of bespoke tools to automatically document the relationships and interactions between objects within our SQL server (XML, SQL, VBA, SSRS, SSIS).- Working on and delivering to multiple projects simultaneously.- Acting as a data SME for actuarial and other analytical colleagues.- Championing data quality and accuracy and striving to improve this wherever possible. Show less

- Overhauling the existing monthly reporting cycle to automate, future proof, document and include error tracking. Process reduced from 10 days to 6 hours.- Building numerous bespoke tools from scratch using SAS, SQL & VBA.- Engaging with executive level colleagues to ensure any bespoke reporting accurately reflects the business challenges they are required to articulate.- Providing complex data transformations to meet actuarial requirements when required.- Working with the… Show more - Overhauling the existing monthly reporting cycle to automate, future proof, document and include error tracking. Process reduced from 10 days to 6 hours.- Building numerous bespoke tools from scratch using SAS, SQL & VBA.- Engaging with executive level colleagues to ensure any bespoke reporting accurately reflects the business challenges they are required to articulate.- Providing complex data transformations to meet actuarial requirements when required.- Working with the actuarial team to prepare deep dive papers for the board.- Collating disparate data from around the globe using SAS/SQL.- Analysing underlying claims data to unearth key trend drivers and make recommendations to exploit savings opportunities.- Supporting other areas of the business with SAS, VBA and SQL queries.- Supplying multiple departments with ad-hoc claims queries.- Relentlessly seeking data quality advances for touch points on the data lifecycle. Show less

- Production of credit risk reporting to the board and wider management audience covering both retail and commercial portfolios.- Leading the development of an in-house solution to replace a 3rd party process for CRA reporting.- Utilising external data to improve the accuracy of impairment model allocations and regulatory returns.- Improving the integrity and efficiency of all BAU reporting.- Built and maintained an ETL solution to provide a single data source to be used by… Show more - Production of credit risk reporting to the board and wider management audience covering both retail and commercial portfolios.- Leading the development of an in-house solution to replace a 3rd party process for CRA reporting.- Utilising external data to improve the accuracy of impairment model allocations and regulatory returns.- Improving the integrity and efficiency of all BAU reporting.- Built and maintained an ETL solution to provide a single data source to be used by multiple business areas.- Processing ad-hoc requests for data and analysis from all areas of the business.- Acting as an analytical mentor for junior colleagues on 6-month secondments. Show less

- Applying Statistical techniques to determine the benefits of telematics.- leveraging both internal and external data sources to build basic pricing models to ascertain business viability & profitability.- Producing informative and efficient MI with the use of SAS and VBA.- Aggregating large raw data sets to varying levels depending on requirements.- Developing innovative uses of existing data in order to support other areas of the business.- Built a tool for the main… Show more - Applying Statistical techniques to determine the benefits of telematics.- leveraging both internal and external data sources to build basic pricing models to ascertain business viability & profitability.- Producing informative and efficient MI with the use of SAS and VBA.- Aggregating large raw data sets to varying levels depending on requirements.- Developing innovative uses of existing data in order to support other areas of the business.- Built a tool for the main pricing team to speed up their own pricing model testing. Show less

Key Achievements:- Quickly becoming competent in the use of SAS and SQL.- Being heavily involved in the remediation of existing LBG processes to provide the new TSB bank with Business As Usual reporting. - Acting as a subject matter expert during the separation of the mortgage business from LBG to the new bank.- Receiving a recognition award for my work.- Being awarded a ‘strong’ rating at my end of year review and subsequently being asked to stay on for an additional 2… Show more Key Achievements:- Quickly becoming competent in the use of SAS and SQL.- Being heavily involved in the remediation of existing LBG processes to provide the new TSB bank with Business As Usual reporting. - Acting as a subject matter expert during the separation of the mortgage business from LBG to the new bank.- Receiving a recognition award for my work.- Being awarded a ‘strong’ rating at my end of year review and subsequently being asked to stay on for an additional 2 months.Skills:- Practical application of mathematical concepts and techniques to provide real business insight.- Confidently manipulating large datasets using SAS and SQL.- Producing clear and concise analysis following ad-hoc requests.- Managing stakeholder expectations.- Good time and project management skills.- Networking and quickly establishing a rapport with colleagues enables me to build successful relationships in all areas of the business. Show less