Summary
Overview
Work History
Education
Skills
Custom
Certification
Timeline
Generic

James Mills

Berkhamsted,Hertfordshire

Summary

A Business Analyst with a passion for change and project delivery gained across a range of Regulatory Compliance and Finance contracts as well as a holder of several professional qualifications including Certified Financial Risk Manager (FRM)

Overview

18
18
years of professional experience
2027
2027
years of post-secondary education
1
1
Certification

Work History

TOM Business Analyst

HSBC
London
07.2023 - 07.2024
  • Supported the implementation of the Global Regulatory Reporting control environment uplift chiefly responsible for shaping and communicating the new Target Operating Model uplift into Regulatory Reporting
  • Designed and created new Target Operating Model guidance packs including stakeholder RACI mapping and ARIS standard Process Maps to demonstrate specific control environment BAU and Change scenarios
  • Role covered a range of control outcomes including IT Controls, EUCs, Process Modelling, Inventory Management, Risk and Control Assessment, Horizon Scanning and Risk Models
  • Conducted effective cross functional stakeholder engagement to gain an understanding of the current control framework including with relevant Risk Policy owners
  • Presented updates to the TOM guidance at the Global Programme steering committees in order to gather feedback and gain sign off from senior regional and programme stakeholders

Data Business Analyst

NatWest Group
Edinburgh
07.2022 - 07.2023
  • Part of a team focussed on identifying residual data quality improvements to the c120 externally published Statutory and Regulatory returns following implementation of the new Oracle Cloud based Finance ledger
  • Worked closely with the offshore teams in Poland and India to successfully identify and support the development and implementation of disclosure improvements
  • Determined and investigated data linkages between Statutory and Regulatory disclosures (FINREP, BoE, CO-REP and Statutory disclosures) and data feeds from Finance systems
  • Elicited and created requirements on JIRA and liaised with the IT Developers and the Regulatory Reporting teams throughout the lifecycle of design, test, build and delivery
  • Conducted a deep dive of disclosure data attributes as part of Strategic AWS Cloud requirements owning the data catalogue to collate the results including source data feeds and data linkage

BAU Global Liquidity Reporting Manager

Morgan Stanley
Glasgow
10.2021 - 07.2022
  • Part of the management review team of Liquidity variance data impacting the daily submission of the LCR data to the NY Federal Reserve
  • Conducted daily scrutiny and challenged data quality and large variances working closely with IT, Product teams and Treasury stakeholders to escalate and rectify data issues within the agreed daily timelines
  • Required cross team collaboration with teams across the US and India covering full IB and WM product portfolio including Loans, FX, Derivatives, Collateral, Shorts and Deposits
  • Provided support and implementation of successful go live of 6G LCR reporting

BAU Regulatory Capital Reporting Manager

Lloyds Banking Group
Edinburgh
07.2020 - 08.2021
  • Part of the management team within Financial Control responsible for the accurate production of Regulatory Capital reporting data into COREP reporting impacting the Large Corporate, Government, Institutional and SME clients covering the Banking Book portfolio including Loans, Trade Finance and Derivatives
  • Maintained up to date knowledge alongside Risk function of CRD IV and CRR Regulatory Capital changes, developments and interpretations covering IRB and Standardised models
  • Responsible for the delivery of RWA and EEL data processing working with the Finance IT developers to co-ordinate the resolution of data quality issues or data delays
  • Performed the Impairment Provision reporting of IFRS9 Expected Credit Loss (ECL) data
  • Supported the delivery of replacement Moody's Regulatory Calculator working alongside Project delivery team and supporting development of the replacement Provisions control process whilst continuing to deliver month-end reporting
  • The role included line management responsibility ensuring colleagues are challenged and motivated to deliver key priorities
  • Built extensive UK, US and Singapore stakeholder relationships across Business teams, IT, Risk and Finance

Regulatory Reporting Analyst

Clydesdale Banking Group
Glasgow
01.2020 - 07.2021
  • Project to support implementation of new Stress Testing submission templates following merger of Clydesdale Yorkshire Bank and Virgin Money
  • Responsible for interpretation of STDF template requirements and analysis of data sources including review of existing Regulatory return templates as potential baseline reconciliation points
  • Daily interrogation of source table data across Regulatory reporting stack using Oracle SQL bespoke queries
  • Designed and implemented template process improvements following initial template submission
  • Created comprehensive process documentation and delivered training sessions to the Virgin Money team to ensure a smooth transition to the BAU Finance teams

Business Analyst

Lloyds Bank Corporate Markets
London
06.2018 - 04.2019
  • Markets IT project in Agile environment to ensure CRD IV compliance within the Trading Book of Lloyds Bank Corporate Markets
  • Sourced, interpreted and documented key Large Exposures requirements from EBA and PRA publications
  • Collaborated with subject matter experts, Risk and Business Stakeholders to validate requirements and resolve gaps and constraints relating to data, processes and technology
  • Co-ordinated Project Impact Assessment with IT architects and developers to determine Strategic options to meet project objectives
  • Successfully gained confirmation from IT of project viability with a proposed Strategic control tool framework signed off by the business sponsor
  • Investigated and documented IT Markets 'as is' position and identified systems in scope for proposed design
  • Engaged front line Global Sales and Trading senior stakeholders including FX, Fixed Income and Swap desks to validate proposed Strategic solution
  • Deputised Product Owner and Technical BA roles by leading steering committees with Senior Stakeholders and production of Visio flow diagrams to demonstrate latest 'to be' position design options
  • Organised and led workshops with IT developers including control tool and trading platform owners and System developers to refine proposed design and determine development prioritisation against existing workflow activities
  • Identified design blockers and created an options analysis paper to achieve consensus
  • Presented at Steering and agreement reached with key Stakeholders on modified design ready for IT build phase

Business Analyst

Lloyds Bank Corporate Markets (LBCM)
Edinburgh
11.2016 - 05.2018
  • Part of a project team to support the implementation of the Ring Fencing regulation within Risk Reporting
  • Assessed the impact on Risk Reporting across Credit and Market Risk functions resulting from Ring Fencing regulation including the introduction of new Regulatory disclosures to the UK Regulator
  • Key requirements captured and managed within JIRA
  • Responsible for capturing requirements and designing a new Commercial Banking Monthly Risk Report for the Chief Risk Officer to support the Non Ring Fenced Bank Risk function
  • Designed dashboard reports using dynamic charts, pivot tables and advanced excel with data sourced using SQL
  • Collaborated with the data team and Risk function to provide assurance that the synthetic portfolio reflected the Ring Fencing perimeter definition as prescribed by the PRA Ring Fencing policy
  • Co-ordinated a review of Credit Limits data sourced from the synthetic portfolio with all Commercial Banking Credit Risk managers and Front Line Trading teams

Business Analyst

Royal Bank of Scotland
Edinburgh
05.2016 - 09.2016
  • Focused on the design and stand-up of the Mailroom function of the new divested bank, Williams & Glyn
  • Modelled 'as is' business processes on IBM Blueworks following site visits to existing RBS Mailroom site
  • Collaborated with end user colleagues, IT and Third Party suppliers to capture Functional and non Functional relating to inbound customer communication (Mail, Email and Fax)
  • Created options analysis paper containing potential target operating model (TOM) options
  • Managed project plan using MS Project and highlighted key issues to project management using RAID log

Business Analyst

Lloyds Banking Group
Edinburgh
07.2014 - 08.2015
  • Full project lifecycle to design a Tactical Process covering Commercial Banking Credit Risk data and sign off process for 6 CRD IV FINREP templates relating to Forbearance and Non Performing Exposures
  • Analysed and documented EBA directives and Technical Standards relating to Forbearance and Non Performing Exposures
  • Conducted and documented gap analysis of 'as is' Credit Risk data vs the new data points required to support completion of the EBA templates
  • Collaborated with Technical Analyst and Risk System owners to source, validate and map source data to the golden source Risk data warehouse
  • Worked with IBM TM1 used to upload template data to the Finance team
  • Lead meetings with Credit risk managers, Risk IT and Finance to assess data availability and key constraints
  • Worked with Commercial Banking business units not on the main reporting stack to construct bespoke solutions including Commercial Finance and Agricultural Mortgages portfolios
  • Supported the Technical lead with the testing of a new reporting database gaining daily experience of writing SQL scripts to interrogate and test the risk dataset
  • Collaborated with the Credit Risk Policy team to ensure a reporting framework in line with existing Default, Impairment and Forbearance policies
  • Successfully designed and implemented a new Tactical reporting operating model to Commercial Banking credit risk teams across good book, business support and Recovery teams
  • Created Professional PowerPoint management sign off packs and conducted quarterly meetings with Credit Risk Directors to successfully obtain attestation of the Credit Risk data
  • Fully documented processes and operating model and held training sessions to ensure successful handover to BAU Credit Risk reporting team

Reporting Analyst

Lloyds Banking Group
Edinburgh
02.2014 - 05.2014
  • Following a resource restructure the project involved the process migration of the COREP Capital Reporting function from Bristol to Edinburgh
  • Built strong working relationships with the Large Corporates Capital Reporting team in Bristol to learn key systems and processes including production and analysis of new CRD IV and existing reporting templates covering COREP, FSA and Leverage Ratio templates to report EAD, RWA, EL and Capital metrics
  • Utilised BIPRU rulebook to interpret compliance requirements and taxonomy
  • Daily use of capital calculator Moody's RAy analytics to query Risk database and SAP General Ledger
  • Created clear transition documentation and successfully embedded process into BAU

Finance Business Partner

Lloyds Banking Group
Bristol
11.2012 - 08.2013
  • Supported delivery of the Group IT Sourcing contract savings target via close interaction with business leaders within Group IT
  • Prepared and presented bi-weekly savings data to senior Group IT sourcing teams

SAP Interface Test Analyst

Lloyds Banking Group
Bristol
05.2012 - 11.2012
  • Created scripts and executed testing on a Mainframe Graphical User Interface to be used by TSB in order to translate Commercial Banking portfolio data between Source and SAP
  • Resolved defects with offshore IT

SAP Transactions Test Analyst

Lloyds Banking Group
Bristol
01.2012 - 04.2012
  • Full functional and regression testing of SAP Transactions as part of Archiving project to improve latency within the General Ledger
  • Created and executed tests, compiled progress reports and loaded defects into Quality Centre and resolved with the offshore IT team

Procurement Benefits Analyst

Lloyds Banking Group
Bristol
03.2010 - 01.2012
  • Managed the daily use of the SharePoint high volume database containing synergy contract savings negotiated across all areas of Lloyds Banking Group
  • Redesigned monthly Senior MI pack

Graduate Finance Scheme

Somerfield Stores Ltd
Bristol
01.2007 - 01.2010
  • 3 Year Finance Graduate scheme covering Buying, Retail Finance and Expense Management functions
  • Extensive experience gained working with Senior Stakeholders and interrogating and transforming large data sets for reporting and analysis

Education

Financial Risk Management (FRM) -

06.2023

AgilePM (Practitioner) - undefined

Certified Scrum Master - undefined

BCS (ISEB) International Diploma in Business Analysis - Certificate in Requirements Engineering, Certificate in Business Analysis Practice, Foundation Certificate in Business Change, Certificate in Modelling Business Processes

01.2016 - 05.2016

SAS Base Programming Certification - undefined

Prince2 Project Management (Practitioner) - undefined

Chartered Global Management Accountant (CGMA) - undefined

01.2007 - 05.2010

BA (Hons) - International Business Economics

University of the West of England

Skills

  • Data Visualisation
  • Process and Data Mapping
  • Requirements Elicitation
  • Data Analysis
  • Teamwork
  • Stakeholder Management
  • Written Communication

Custom

  • Data Visualisation: Design and production of executive level reporting
  • Process and Data Mapping: Translation of requirements into gap analysis, data flows, and Visio process maps
  • Requirements Elicitation: Track record of eliciting, validating and refining requirements in line with either Waterfall or Agile project methodology
  • Data Analysis: Comfortable interrogating large datasets from data warehouses using advanced Excel and SQL techniques
  • Teamwork: Collaborating closely with cross functional teams to achieve delivery objectives
  • Stakeholder Management: Extensive experience interfacing between technical and Business teams, facilitating workshops and liaising with Senior stakeholders
  • Written Communication: Production of Professional presentations and concise documentation for Project or Business stakeholders

Certification

  • XML Certification Program

Timeline

TOM Business Analyst

HSBC
07.2023 - 07.2024

Data Business Analyst

NatWest Group
07.2022 - 07.2023

BAU Global Liquidity Reporting Manager

Morgan Stanley
10.2021 - 07.2022

BAU Regulatory Capital Reporting Manager

Lloyds Banking Group
07.2020 - 08.2021

Regulatory Reporting Analyst

Clydesdale Banking Group
01.2020 - 07.2021

Business Analyst

Lloyds Bank Corporate Markets
06.2018 - 04.2019

Business Analyst

Lloyds Bank Corporate Markets (LBCM)
11.2016 - 05.2018

Business Analyst

Royal Bank of Scotland
05.2016 - 09.2016

BCS (ISEB) International Diploma in Business Analysis - Certificate in Requirements Engineering, Certificate in Business Analysis Practice, Foundation Certificate in Business Change, Certificate in Modelling Business Processes

01.2016 - 05.2016

Business Analyst

Lloyds Banking Group
07.2014 - 08.2015

Reporting Analyst

Lloyds Banking Group
02.2014 - 05.2014

Finance Business Partner

Lloyds Banking Group
11.2012 - 08.2013

SAP Interface Test Analyst

Lloyds Banking Group
05.2012 - 11.2012

SAP Transactions Test Analyst

Lloyds Banking Group
01.2012 - 04.2012

Procurement Benefits Analyst

Lloyds Banking Group
03.2010 - 01.2012

Graduate Finance Scheme

Somerfield Stores Ltd
01.2007 - 01.2010

Chartered Global Management Accountant (CGMA) - undefined

01.2007 - 05.2010

AgilePM (Practitioner) - undefined

Certified Scrum Master - undefined

SAS Base Programming Certification - undefined

Prince2 Project Management (Practitioner) - undefined

BA (Hons) - International Business Economics

University of the West of England

Financial Risk Management (FRM) -

Similar Profiles

CREATE PROFILE
James Mills