Tom Phipps Email & Phone Number

London, GB

- 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.

- 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.

Brighton, United Kingdom

- 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.

- 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.

London, United Kingdom

- 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.

Guildford, United Kingdom

- 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..

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..

Bachelor Of Science (Bsc), Mathematics

Modules relevant to business finance and analysis: - OPERATIONAL RESEARCH PROJECT - My final year project used advanced statistical.

Foundation Degree, Engineering

Education record