Business Analyst

Milton Keynes

• Support the detailed design and implementation of the ‘Ring-Fencing’ regulation as defined by the Bank of England for Santander UK Financial Control functions • Plan business analysis activities for all finance stakeholders: Accounting & Reporting, Bank of England Reporting, Capital Reporting, Corporate MI, Cost Management & Procurement, IT, and Data Quality • Facilitate and coordinate all Finance Business User and IT activities/roles: User Requirements, IT Solutions, UAT/IST implementation plans for System/Operational readiness, Customer Data and Migration schedules, Co-existence testing, Pre/Post Go Live configurations including General Ledger re-allocations and system re-mappings, Test Scripting and Strategy, and Re-Branding • Support the identification and resolution of Risks, Assumptions, Issues, and Dependencies

Key Skills
  • Business Analysis

Work Experience

Business Analyst

Santander UK Plc12 months

• Support the detailed design and implementation of the ‘Ring-Fencing’ regulation as defined by the Bank of England for Santander UK Financial Control functions • Plan business analysis activities for all finance stakeholders: Accounting & Reporting, Bank of England Reporting, Capital Reporting, Corporate MI, Cost Management & Procurement, IT, and Data Quality • Facilitate and coordinate all Finance Business User and IT activities/roles: User Requirements, IT Solutions, UAT/IST implementation plans for System/Operational readiness, Customer Data and Migration schedules, Co-existence testing, Pre/Post Go Live configurations including General Ledger re-allocations and system re-mappings, Test Scripting and Strategy, and Re-Branding • Support the identification and resolution of Risks, Assumptions, Issues, and Dependencies


Business Analyst

Santander UK Plc2 Years

• Enable ‘Risk Data Aggregation’ compliance defined by The Basel Committee on Banking Supervision • Participate on all project lifecycle phases to define and implement the ‘Core Accounting Solution’ interface across all Santander UK CTS’ (customer transaction systems) and its General Ledger (GL), incl. gathering user requirements to simplify, standardise, and improve accounting processes throughout bank • Document the customer view of assets and liabilities within each CTS and the core accounting mappings from the source system to the GL • Validation of the data files used to feed Santander strategic data warehouses • Reconcile and ensure data held in strategic data warehouses is complete, accurate, and supported by balances held in each CTS and the GL • Manage resolution of differences between each CTS, strategic data warehouse, and GL, administering clear change management processes surrounding amendments • Present to the RDA Steering Committee on a weekly basis the progress of all RDA work streams MAIN ACHIEVEMENTS • Achieved successful implementation of most complex legacy CTS into CAS as part of Phase 1, leading and resolving all post-migration and implementation issues with relevant stakeholders • Identified relevant stakeholders to create a User Requirement Document for Phase 2 of the CAS project, relating to the remaining CTS’ planned to be migrated into the Core Accounting Solution interface • Successfully achieved full RDA compliance for the bank on all Santander UK CTS’ • Handed over all control frameworks developed, to the Data Quality team to incorporate into daily controls


Test Lead

VW Group2 Years

• Test Manager for Project delivering new Business Intelligence feeds from all internal systems, and enhanced Profitability Reports to the SAP Business Objects reporting tool incl. formulating a requirement, defining the scope, data validation of new universe, UAT design, testing, defect management, and sign-off • Integration Test Lead for Phase 2 implementation of SAP-ICM incl. identification of all business end-to-end systems, creation of SAP test data, and providing support/coordination of UAT with Stakeholders • Support the creation/execution of project test scripting for Functional/Regression/IS UAT streams • Following 2011 Audit, post Phase 1 implementation of SAP-ICM for ‘Audi’, ensure all margin structures have been applied to Dealer Network sales correctly, Brand Marketing Campaigns have been accounted for, Commission payment processes are valid, and data feeds are consistent across all integrated systems encompassing, Dealer Order systems, Customer Invoicing systems, SAP-ICM, and SAP-FI MAIN ACHIEVEMENTS • Successfully executed an Integration Testing stream for the first time in VW Group since SAP implementation in 2010, whilst identifying and resolving all system/process limitations encountered • Resolved numerous interface errors in SAP-ICM assisting Service Delivery and Business Support incl. re-engineering a process to save c.7hrs daily BAU time • Identified c.£338k of incorrect commission payments to dealers in ‘Audi’, providing a recommendations report on incorrect/poor business processes and control issues to the Financial Controller


Management Accountant

Countrywide12 months


Management Accountant

Ingram Micro UK Ltd3 Years

• Coordinating, developing, and delivering the Monthly Internal/External Forecast, and UK Annual Budget • Revised periodic Reporting Suite to the Board to include variance analysis and facilitate GAP analysis • Revised the entire Operating Expense allocation process of the European Customer & Vendor Profitability application, creating a new Segmentation Profitability pack for the CEO • Supported the Board on lease renewals for the Distribution Centre and Maidenhead Office using NPV analysis, producing a Strategic Report in a SAF framework, with SWOT analysis, and recommendations • Revised, streamlined, and handed over with procedures, tasks including Monthly Vendor Profitability analysis (used to calculate sales commissions); Customer Dispute Tracker; Monthly Opex GL Accounting • Revised the Monthly Market Share analysis pack for CEO decision making


Systems Accountant

Equitable Life Assurance Society2 Years

• Provide monthly Reassurance, and Premiums and Claims trend analysis, to ELAS • Successfully completing a number of internal ELAS projects from an accounting impact perspective and participating in the specification of changes to systems and procedures, liaising with Finance Users / IT for UAT, including tax changes, rectification projects, implementation/improvements of systems, creating and testing new GL account codes, and the delivery of training to impacted areas • Adding value to the BAU team by conducting a number of internal reviews: improving processes to increase efficiency, implementing change/controls to reduce risk, and correcting inconsistent accounting approaches. Encompassing reconciliations, GL account code mappings (Oracle), failed posting processes, implementing reassurance telephonic transfer processes, calculating settlement figures for ex-gratia reassurance, correcting improper account transaction interfaces and historical mis-postings, and various client redress exercises. Reviewing Reassurance Treaties, to identify and resolve any discrepancies. • Pre and Post-implementation Testing of the financial impact of a number of high-level ELAS projects, including the external transfer of Non-Profit Annuity business to Canada Life, With-Profit Annuity business to The Prudential, and University Life Assurance business to Reliance Mutual.


Reconciliation’s Specialist

Abbey National Finance2 Years


Interim Positions

Morgan Stanley 4 Years


COPYRIGHT © JOBDROP GROUP. 2017