Experience

ECS

• United Kingdom
• Information Technology & Services
• 200 - 300 Employee

• Technical Business Analyst

  • Oct 2020 - Present

  Engaged to work as part of technical team at a major banking client of ECS (UK challenger bank). They have embarked upon a new project to implement a DPR mortgage solution. Engaged to work as part of technical team at a major banking client of ECS (UK challenger bank). They have embarked upon a new project to implement a DPR mortgage solution.



Kingfisher Group

• Retail
• 1 - 100 Employee

• Technical BA / Data Analyst

  • Sep 2019 - Mar 2020



Metro Bank (UK)

• United Kingdom
• Banking
• 700 & Above Employee

• Technical Business System Analyst

  • Feb 2018 - Apr 2019

  Engaged on new program to upgrade current Mortgage platform to provide straight through mortgage origination covering Broker and Metro Store channels Encompassing the DPR Mortgage origination platform (for AIP/FMA) and other external 3rd party applications…i.e. Mapping to API’s for ULS (Solicitor Mgt & Ecot), Equifax (Credit/AML), Rightmove (Automated Valuation), Landmark/Quest (Full Property Survey services), Pepper (Mortgage Servicing) and Barclays (EPDQ Payment processing), plus other minor systems & GDPR Mapping, design, test and development support of solution to enable all data to flow seamlessly between DPR (Mortgage origination) through IBM IIB Middleware and/or APIGEE cloud to/from 3rd party services (ULS, Equifax, RightMove API’s etc) Assist in the configuration of DPR business rules using DPRs “Rules Builder” engine Unfortunately due to budget constraints & higher priority regulatory projects the Mortgage Originations project was cancelled in April 2019 Show less



Crawford & Company

• United States
• Insurance
• 700 & Above Employee

• Business Systems Analyst

  • Feb 2016 - Dec 2017

  Crawford and Co are a major Insurance Management business dealing with claims management handling for all the major Insurance Companies, such as AXA, Aviva, Allianz etc. Following on from the buyout of a competitor in 2015, Crawford and Co embarked upon the migration of all claims from the competitors Claims Mgt system (OPERAFLO) into the core system used by Crawford (PRIME). An aggressive migration with VERY short timescales and a target live date of August 2016 (AGILE Environment, daily standups etc). I was brought in to design and document the ETL (Extract, Transform, Load) processes and mapping rules to enable a successful migration to happen. Extensive and deep dive source/target database SQL analysis and mining etc. Elicitation of Requirements and Mapping workshops with business/technical SMEs etc, working with test team/developers to analyse and resolve migration issues. Migration successfully went LIVE on 30th July 2016. (1 month early). *Contract ended due to budget/project constraints in October 2016 *Invited back January 2017 to work on new project to fully automate the feed of new claims from AXA into Crawford thus doing away with human intervention into Crawfords internal systems... Contract finished 10th December 2017 Show less



Practicus

• United Kingdom
• Staffing and Recruiting
• 1 - 100 Employee

• Business System Analyst

  • Jun 2015 - Oct 2015

  Engaged by Practicus, who were a consultancy running a small number of projects on behalf of LBG to remediate several applications away from various NT4 servers onto more recent technology, such as Win2008 R2 to enable LBG to decommission all NT4 servers across the entire group. I was engaged in part to assist with several of these application remediations. However, my primary role was to focus on the remediation/migration of the FICO (Debt Manager v2.0) product onto Win2008 R2 by engaging with the various infrastructure SMEs as appropriate and working closely with the PM for the project to reach a successful conclusion. (I had previously worked for FICO as an implementation consultant for Debt Manager. Debt Manager is a workflow based Collections and Recovery application used extensively by major banks, utilities and other businesses). Show less



Alphabet UK (Part of BMW Group)

• Hook, Hampshire

• Business Analyst

  • Mar 2015 - May 2015

  Engaged on a short term (three month) data project to execute detailed analysis of data quality issues within in house systems, the nature of the issue, the cause and likely rectification of the data issues. I was tasked with producing a report that was to go back to the business with recommendations for them to act upon. This involved:- * Engaging with both business and technical IT areas to identify and understand key data issues * Execute detailed deep dive database analysis (Using SQL) on those data issues and come up with proposals to:- i) Retrain users and/or change business process to reduce and eventually cease the issues continuing iii) Propose system wide changes, such as improvements to data input validation to assist users in this respect, date validation etc iii) Propose and prototype processes such as new SQL scripts etc to fix and data-cleanse the in-situ data quality issues iv) Propose ongoing audit reporting to identify and monitor growing data quality issues and capture user data entry issues at an early stage before becoming a major issue in the future The report was completed on time and passed to Management for action Show less



Old Mutual Limited

• South Africa
• Financial Services
• 700 & Above Employee

• Migration Business Analyst

  • Aug 2014 - Jan 2015

  Old Mutual Wealth (formally Skandia) are replacing the technology that supports much of the UK Wealth and UK Heritage businesses as part of a strategic 20 year partnership with International Financial Data Services (IFDS), known as Project Oval. This is a major commitment for OMW and the project presently occupies 400+ people across the globe. * Working as part of the analysis team tasked with migrating a ‘thin layer’ of data from various source DBs into the new frontend service OPENDOOR, to enable a single customer view to be presented to both Customers and Financial Advisors alike, when they login online. * Working closely with the third party software providers (DST Systems in Melbourne and HCL in Chennai, India) to produce the complex data mapping and functional design documentation that will enable the migration ETL (Extract, Transform, Load) software build to commence. * Data analysis via SQL (ORACLE and SQL Server) of the various source DBs to assist in the migration design as well as checking source data quality, gap analysis, building data models where required etc and raising issues where appropriate. * Engaging with the business SME’s to ensure that the migration will deliver the data and functionality as is required by the business in the new world. Unfortunately part of the project was de-scoped affecting me, so I left January 2015 Show less



Nationwide Building Society

• United Kingdom
• Financial Services
• 700 & Above Employee

• IT Business Systems Solutions Designer

  • Jun 2013 - Jul 2014

  Having previously completed two successful migrations with Nationwide on a prior engagement; in May 2013 I was invited back to perform a similar role to work on the analysis and design elements for a new migration of retail mortgages that had been purchased from Bank of Ireland in 2011. Although the mortgages were being administered by a third party, Homeloans Management Ltd on behalf of Nationwide, in March 2013 it was decided to migrate into the Nationwide core Customer Operations and Lending Control system, ACTIVATE/SUMMIT, with any delinquent accounts additionally migrated into the COLLECT arrears management application, both applications are supplied by SOPRA (www.sopragroup.co.uk). * Responsible for the complex data mapping and documentation of this between the source and target systems, identifying data quality issues and executing gap analysis. Developing the many design specifications and writing a large majority of the migration SQL scripts (ORACLE and SQL Server) to be used as part of the ETL migration process * Writing extensive SQL scripts to perform data mining and analysis in order to undertake data quality investigations and/or source data cleansing and gap analysis. * Acting as the initial point of contact for the test teams (offshore & onshore) whenever new QCs were raised, perform initial problem analysis and reject, accept and/or manage resolution as appropriate with the relevant internal or external development teams. The migration successfully went live on 28th Feb 2014, with minimal issues and no disruption to the business Following migration I was tasked with performing a typical BA design role for various FCA regulatory reporting projects (PSD Reporting, Mortgage Market Review MMR etc) such as interviewing both business and technical SME’s, database analysis to identify the required data, identify data gaps etc and producing the high level technical design documentation to produce the reports. Show less



Lloyds Banking Group

• United Kingdom
• Financial Services
• 700 & Above Employee

• DM System Development Anayst

  • Jul 2012 - May 2013

  Engaged from July 2012 to work on project migrating HBOS Credit Cards from an older version of FICOs Debt Manager Collections application (v4.1) into the LBG version of Debt Manager (v6.2). This project forms part of the ongoing process to merge the two bank core systems into a single platform. In this instance HBOS to LBG. Project delayed. Therefore utilised to perform typical Business/System Analyst role to support BAU changes to LIVE Collections & Recoveries operation (Debt Manager v6.2, Placement Plus & TRIAD). Show less



Nationwide Building Society

• United Kingdom
• Financial Services
• 700 & Above Employee

• IT Business Systems Solutions Analyst

  • Sep 2010 - Jun 2012

  Engaged from Sep 2010 by Nationwide Specialist Lending in Bournemouth as a Systems Analyst/Designer to assist with a project to migrate two mortgage books from the Derbyshire and Cheshire Building Societies into the Nationwide strategic Mortgage originations & servicing platform (Activate/Summit) Activate/Summit is a product suite supplied by Tieto (www.tieto.com) that provides a full mortgage origination and servicing solution for major mortgage providers in the UK mortgage market. Nationwide Specialist Lending are using Activate/Summit configured on an ORACLE 9i database service with an Oracle Forms 6 front end running on a combination of Windows and Unix Engaged primarily to handle the complex data mapping between the two external source systems and Activate/Summit, working closely with Tieto development staff to build a successful relationship and drive the data migration part of the project through to successful completion • The project successfully went live with both mortgage books migrated into Activate/Summit at the end of July 2011 Contract extended to perform similar role to migrate internally managed mortgage book of approx 18500 accounts consisting of a mix of multi property portfolios (ie Buy to Let), individual non-commercial mortgages and commercial mortgages. Successfully went live at end of June 2012. Show less



Barclaycard

• United Kingdom
• Financial Services
• 700 & Above Employee

• IT Business/Systems Solutions Analyst - Credit Risk & Impairment

  • Nov 2008 - Aug 2010

  Barclaycard were implementing a replacement Collection & Recoveries system for their UK Secured Lending business in Cardiff. The solution encompassed the implementation of the FICO (Fair Isaac) products; Debt Manager Web (v6.3.1), TRIAD (v8.4) utilising Blaze Advisor and Placements Plus (v5.04), hosted via an IBM iSeries with a WebSphere Web Server front end and IBM pSeries running an AIX (5.3) operating system and external service hosted by FICO to service the placement of accounts with external agencies. I was engaged as a Business/System Analyst and was part of the team tasked with the design, test and implementation of the solution that would enable the three FICO products to work in parallel and interface with both internal Barclays and other external third party systems such as external Credit Agencies This work involved arranging and hosting requirements gathering workshops/meetings, system data mapping, solution design, functional specification, assisting the test team for All System & UAT testing and final implementation of the solution • The project successfully migrated the Collections portfolio (Secured loans – Typically Second Mortgages) into Debt Manager in July 2009 • Retained on contract until end of May 2010 to further implement Barclays Partner Finance in Glasgow onto the same Collections Platform. Successfully migrated in excess of 1m accounts at end of May 2010. Remained on contract until end August 2010 to support the new implementation until bedded in Show less



Lloyds Banking Group

• United Kingdom
• Financial Services
• 700 & Above Employee

• IT Business/System Solutions Analyst

  • Sep 2007 - Oct 2008

  Lloyds Bank were undergoing a major transformation program to consolidate & upgrade their Collection and Recoveries operations in Brighton from various AS400 and OS390 applications onto a single application (Debt Manager Web v6.2) and single hardware platform (IBM P_Series running an AIX operating system, Websphere Web Server and Oracle 10g database). The project was progressed in three phases – Recoveries Accounts, Delinquent Credit Card Accounts & Delinquent Bank Products (ie Mortgage, Unauthorised Overdrafts, Secured / Unsecured Loans etc). This involved the usual Business & System Analysis activities, such as requirements gathering, data mapping, workshop facilitation etc for the new collections system as well as functional specification, testing and acting in a consultancy capacity advising Lloyds on best practise to achieve their goals and resolve issues for the project in relation to the Collection & Recoveries Debt Manager platform Show less



GSK

• United Kingdom
• Pharmaceutical Manufacturing
• 700 & Above Employee

• Technical Business Systems Analyst

  • Jul 2006 - Aug 2007

  Following a wave of redundancies at FICO, engaged by Glaxo SmithKline on a short term contract as a Technical Systems Analyst working within Glaxo's Global BPCS support Group. Involved in the design, build, test and implementation of several small projects ALL of which were subject to very rigourous Pharmaceautical quality standards Following a wave of redundancies at FICO, engaged by Glaxo SmithKline on a short term contract as a Technical Systems Analyst working within Glaxo's Global BPCS support Group. Involved in the design, build, test and implementation of several small projects ALL of which were subject to very rigourous Pharmaceautical quality standards



FICO

• United States
• Software Development
• 700 & Above Employee

• Solution Consultant / Business-Systems Analyst

  • Mar 2001 - Jun 2006

  Feb 01 to Jun 03 - Solution Delivery Consultant, responsible for the implementation of Debt Manager Collections & Recovery Application into client base. Projects completed:- - Ford Motor Credit, St Albans (Personal and Corporate Motor Finance) - Lloyds TSB Blackhorse, Edinburgh (Credit Cards, Mortgages, Personal and Motor Loans) Jun 03 to June 06 – Business System Analyst / Consultant Provide Business Analysis and Consultancy to Web development team and clients primarily for Web version of Debt Manager. Part of the team tasked with total redesign of the Debt Manager database in preparation for moving the application to an SOA (Services Oriented Architecture) based system (Debt Manager v8) Show less



Pacific Associates

• Project Manager

  • Oct 1996 - Feb 2001

  Support, Development and implementation of BPCS v6 into various clients such as; Ciba-Geigy (Now Novartis); Basle, Switzerland GlaxoSmithKline; Brentford, West London SC Johnson, UK Support, Development and implementation of BPCS v6 into various clients such as; Ciba-Geigy (Now Novartis); Basle, Switzerland GlaxoSmithKline; Brentford, West London SC Johnson, UK