Michael Barrett

Experience

• 

  Domino's Pizza

  Jul 2007 - Aug 2010

  Manager In Training

  • Ensure high quality in all areas of the pizza making process; taking orders in store and over the telephone, making and topping pizzas, oven tending.• Run shifts ensuring efficient labour percentage, cash handling and management at the end of shifts• Deal with any dissatisfied customers professionally to resolve the complaint or issue

• 

  HFC Bank

  May 2009 - Aug 2012

  Investigate complaints in relation to the miss-selling of Payment Protection Insurance (PPI). Inbound and outbound calls dealing with customers in financial difficulty.

  • Complaints Investigator

    Feb 2012 - Aug 2012

  • Collections Advisor

    May 2009 - Feb 2012
• 

  Sopra Group

  Aug 2012 - Sept 2015

  SAS Consultant

  Lead SAS Developer @ Large Retail Bank – Mortgage Remediation • Lead Developer as part of a large remediation project; over 100,000 affected customers. • Responsible for solution design and development. • Creation of technical and functional specifications. • Working with external auditors as part of their Quality Assurance • Use of SAS Enterprise Guide and DI Studio to develop a number of calculators to remediate customers on a variety of issues including Arrears Capitalisation, CCA and Early Repayment Charges. • Utilising advanced SAS macro, arrays and hash lookups in complex solutions. SAS Developer @ American Credit Card Provider – Remediation Issues • Design and development of a large transaction level data set for use of the Marketing Department. • Vast quantities of data requiring implementation of advanced efficiency techniques.• Data Requests for numerous remediation issues relating to terms and conditions of credit card customers.• Development to agreed specifications • Meeting with Stakeholders to assist with defining requirements.• Use of Base SAS for development and Excel for output. • Ad-hoc analysis to senior stakeholders detailing progress of newly opened accounts and applications factoring in various KPI’s depending on campaigns. • Presenting technical coding and terminology in business and non-technical terms Show less

• 

  Dufrain

  Oct 2015 - Jan 2018

  Line Management responsibilities including presenting each appraisee as part of internal Performance Management Process. Whilst on client sites, being available and approachable for both stakeholders and colleagues alike. Projects include: Senior MI Developer @ International Asset Servicing Provider • End to end development of complex MI Reports to service a Cash Manager for a recent asset sale • Use of Advanced SAS (Macros, SQL, XML) to produce sophisticated, streamlined reporting solutions. • Utilisation of Mortgage Expertise to develop Principal and Interest allocation report. • Technologies used; SAS Enterprise Guide for coding, Advanced Excel and VBA for Report Production Show less Technical Lead @ Large UK Retail Bank – Finance & Credit Risk Alignment • Lead SAS DI Studio Developer working as part of a bank wide Finance Transformation Programme. • Solution design and automation of strategic financial data streams. ETL to consolidate existing systems and source data feeds into a single data mart ensuring alignment of general ledger to regulatory reporting (including FDSF and COREP). • Streamlining of Provisioning Process to use strategic data sources. • Preparation and presentation of all design documents to the appropriate Design Authority to ensure appropriate design gate sign-off. • Development of non-strategic data consolidation into a single SAS platform. • Leading team of two other junior developers. Provided technical mentoring and support on ETL and DI Studio best practice along with quality assurance and peer review of all SAS DI Studio development. • Underlying technologies utilised; SAS DI Studio, SAS Enterprise Guide, Oracle, UNIX. • Key interface with the senior programme management, providing support, guidance and timescales on technical design deliverables at steering group level.• Involved in planning all aspects of project delivery – data analysis, design, build, test, release to production environment • Implementation management for promotions into production of large project releases. Technical Lead @ Large Irish Retail Bank – Mortgage Remediation • Sophisticated solution design and implementation of SAS coding to identify Mortgage Product Rate Types using interest rate transactional data. • Leading team of three other developers on site; managing workload and providing technical assistance. • Underlying technologies utilised: SAS Enterprise Guide, Teradata and Excel; Advanced SAS Skills in solution development e.g. arrays for transposing data • Teradata used for storing output from SAS solution and for adhoc queries; transferable SQL skills. Show less

  • Senior Consultant

    Jan 2017 - Jan 2018

  • SAS Consultant

    Oct 2015 - Jan 2017
• 

  The Co-operative Bank plc

  Jan 2018 - Jan 2021

  Automatic of manual processes to utilise technologies which allow the business to spend more time making better decisions and less time churning out data. Using SAS DI Studio to automate jobs and flows for efficient ETL, adding trigger files to remove overhead. Use of Excel SAS Add-In to remove manual steps of sending to excel, creating less room for errors where copying and pasting still exists. Use of PowerPoint SAS Add-In to automate Exec Level Board packs to be a one click refresh each week/month with a solid ETL process behind.Line management and technical mentor.Automation of new Covid Payment Holiday process to take raw CSV files, transform and load into Marts for MI along with Exec Dashboards. Show less • Working as part of major Bank Project to implement new Credit Risk IFRS9 Models.• Involved in all stages of the project lifecycle; gathering requirements, design, build, test and implementation.• Production of high and low level technical documentation of the process, including usage of Microsoft Visio.• Preparation and presentation of design change documents to the appropriate Triage/Steering Groupto ensure appropriate sign-off.• SME for COREP, FDSF and FINREP Finance Reporting• Wide range of stakeholders to deal with across Risk and Finance Teams• Significant change to ETL process to ensure accounting balances were extracted from Strategic Sources.• Major overhaul, simplification and streamlining of Finance Downstream Reporting including adoption of SAS Add-ins for Excel• Development of a new reconciliation process to reconcile the Bank Model Output File to the Bank’s General Ledger.• Underlying technologies utilised; SAS DI Studio, SAS Enterprise Guide and UNIX. Show less

  • Data Process Automation Lead

    Jan 2020 - Jan 2021

  • Senior Data Developer

    Jan 2018 - Jan 2020
• 

  Handelsbanken

  Jan 2021 - Dec 2021

  Credit Risk Analytics Lead

  Significant simplification, testing and validation of Credit Risk MI Process including automation of visualisation using Advanced Excel Pivots, Graphs and VLOOKUPS. • Technical mentoring and training of junior team members including a peer review of all coding. • Automation of Stressed Credit Loss Model Coding • Production of Excel Tool for selection of candidate model variables showing test results for stationarity, correlation and R2 alongside visualisation of time series. • Set up a new team mailbox to manage data requests from a variety of stakeholders. • Improve Bank understanding of Forbearance and Concession Data and produce monthly MI pack for key stakeholders. • Attending and contributing member of Banks’ Data Quality Analytics Forum • Stakeholders in the UK and Sweden as part of Handelsbanken Group • Underlying technologies utilised; SAS Enterprise Guide and Microsoft Excel. Show less

• 

  Markerstudy Insurance

  Jan 2022 - now

  • MI Technical Lead

    Nov 2022 - now

  • MI Senior Developer

    Jan 2022 - Nov 2022