Paul Goodfellow Email & Phone Number

Liverpool, England, United Kingdom

• NOW Pension data migration from Mercer/Aptia’s Open platform, and NOW’s Gateway and Salesforce data systems on to TCS’s BaNCS platform. • Support project delivery to implementation• Leading and participating in workshops with the current and future TPA’s together with the pension fund provider• Production of detailed technical specifications, mapping documentation and other key documentation• Working with developers and testers to produce scripts to enable accurate data extraction and timely delivery• Management, investigation and resolution of all defects raised through JIRA• Ensure adequate data validation checks are applied to source data extracts• Support of the creation of reconciliation reports

Edinburgh, Scotland, United Kingdom

• Delivered the automation of all UK invoices from Market Data Management System (MDM) to the Accounts Payable System, Fusion• Facilitated regular meetings with key stakeholders at Calero MDSL, HSBC and Fusion • Ensured swift resolution of any issues that arose throughout delivery• Tracked all progress, issues and requirements through Clarity and Monday.com• Provided frequent updates on the MDS Change Delivery Forum to the Chief Data Officer of MSS

Edinburgh, Scotland, United Kingdom

• Responsibility for the oversight and monitoring of a team of analysts tasked with ensuring HSBC’s invoicing debt was continually reduced• Key point of contact for the escalation of invoicing issues for all vendors with regular attendance on vendor calls• Worked with multiple areas of the business including Invoice and Cost Management, Financing, Access and Reporting and the Product Managers/Product Owners to ensure any outstanding business paid invoices escalated by vendors are paid.• Worked closely with the Accounts Payable team and the Global Head of the department to ensure that invoices were paid in a timely manner and any issues raised were quickly resolved• Led the local billing project which involved regular meetings with the Product Owners to ensure HSBC’s objective of maximising local site billing with each vendor was achieved where possible• Regular reporting to the business on behalf of the Invoicing Team via the Operations Committee forum and meetings with Head of Market Data Services• Supported the project team in key deliverables to drive efficiencies including the invoice automation process which I was later to take on full project management responsibility for

• Provided support in reviewing daily CFD trade reconciliations, liaising with brokers and front office to ensure timely resolution of all trade and position breaks. Working with prime and executing brokers to clear any mismatches, tracking missing give ups and unallocated trades ahead of NAV point• Processing daily cash settlements and resolution of any cash breaks to allow front office accurate view of cash• Supporting ongoing Derivatives migration project by leading thorough cash reconciliation to clear 5+ years breaks across various funds• Development of the reset process to be performed for multiple brokers ensuring appropriate controls are in place to identify breaks in a timely manner• Post reset migration, implemented relevant controls to capture any discrepancies between broker, new service provider and Fidelity • Facilitating daily calls with the new service provider to cover any outstanding position breaks or issues• Providing a thorough overview of end to end processes to auditors• Setting up and leading of workshops to new service providers to cover processes and procedures to close gaps in understanding

Edinburgh, United Kingdom

• Responsibility for the completion of all pre-migration activities including system parameterisation and chart of account mapping• Analysis of Fund and Static Data Requirements• Delivery of all Migration Requirements to migrate Funds, covering Multifonds, migration tools & setup requirements• Testing of the end to end migration activities, including the identification of Known System Differences between Citi and the Legacy TPA • Participation in meetings and daily runbook calls throughout the migration process• Responsible for participation and provision of input to any migration tool (YODA) configuration and development• Successful delivery of the ASI Atlantic ABOR fund migration & reconciliation of funds onto Multifonds from existing TPA’s, Kames and State Street together with the completion of the CTI Brexit Migration. • Extensive participation in the Multifonds platform consolidation project • Raise all issues/concerns identified as risks promptly to Migration Manager• Investigation and explanation/resolution of migration differences to allow client sign-off• Responsibility for input into issue resolution of post implementation queries to both client and Citi expectations• Responsible for the production of multiple Change Requests and Business Requirement Documents

Edinburgh, United Kingdom

• Solution and implementation of the migration of funds from Aviva on to pControl and Icon • Regular attendance of Client and Business Solution Workshops • Definition of test scenarios and documentation of models • Running of report testing and documentation of issues through the QC system • Completion of Proof of Concept and User Access phases of testing • Contributing towards the Runbook set up and population throughout testing phases • Identification, escalation and management of risks and issues • Regular and timely reporting of progress and forewarning of any potential delays • Responsible for the allocation and management of team members workloads

Holyrood Road, Edinburgh

• Led the Migration of the Threadneedle Asset Management migration from JP Morgan to Citi from an Effective Yield team perspective• Key contributor at Client and Auditor meetings• Successfully investigated and resolved complex internal and client queries in a timely manner• Developed strong, pro-active relationships with all internal parties and external customers to ensure timely exchange of information• Deputised for Manager at internal and external meetings• Validated standing data which was used in bond amortisation calculations• Assisted in the creation of end state process for IMPACT solution• Actioned ad-hoc queries from auditors, the client and other internal customers• Created, maintained and enhanced productive working relationships with all customers• Planned work for all clients within the team to consistently achieve optimal outputs• Contributed in the improvement of systems, products and services

Holyrood Road, Edinburgh

• Successfully managed a shift rota of 7 individuals responsible for the provision of operational support across a series of shifts covering a 24/6 work pattern• Provided support for the Core Fund Accounting system (Multifonds) and associated applications for BAU and Business Change Delivery teams• Managed overnight support of Lux and Singapore BAU processes and proactively monitored Client Data feeds and deliverables• Managed and distributed client and BAU queries• Conducted thorough investigation and provided resolution on a wide range of queries in a timely manner

Holyrood Road, Edinburgh

• Lead and organised the Effective Yield team in all aspects of production of bond amortisation calculations• Reviewed all work produced by the team using the Access Database, IMPACT and various other offline calculations• Reviewed quarterly and semi annual packs supplied to the client• Assisted in the creation of end state processes for Impact solution• Ensured queries from other teams, the client and auditors were answered in a timely manner• Planned workloads for all Effective Yield team members• Conducted regular one-to-one meetings with each team member to identify developmental requirements• Supported team members in achieving their goals within Citi• Contributed to the improvement of systems, products and services

Holyrood Road, Edinburgh

• Development of new applications for yield calculations (Project Impact Lead)• Project management responsibilities including risk analysis• Reviewing vendors’ proposals to supply specific data and determining their ability to meet Citi’s static data needs• Process re-engineering and procedure documentation following guidance from the IMA on effective yield• Scoping and product review of the effective yield calculation methodology• Reviewer of bond yield and amortisation computations on Multifonds and offline validation analysis for both unrealised and realised amortisation• Writing, reviewing and validation of Functional Requirement Documents (FRDs) and Business Requirement Documents (BRDs) to improve Multifonds yield calculations• Specification of FRDs for new yield calculation methodology with frequent meetings with the Product Team• Presentations to other business units on effective yield, staff training and other team leader related responsibilities• Periodic production of client reports detailing distribution of amortised income

Holyrood Road

• Migrated AEGON funds from ICON to Multifonds• Coordinated the static data load• Produced performance analysis on migrated funds between Legacy, Multifonds and the benchmark index• Produced legacy to Multifonds fund reconciliations and accounted for differences• Liaised with the model office to investigate accounting differences on balance sheet or P&L statements• Documented procedure notes and facilitated training sessions

Ferry Road, Edinburgh

• Responsible for providing a first class and timely service to clients• Accountable for daily pricing of OEIC and Unit trust funds• Undertook daily NAV calculations• Instrumental In the production of daily bank reconciliations and the investigation and rectification of any discrepancies• Prepared daily and weekly reports• Successfully liaised with trustees and clients to ensure all relevant data was captured• Utilised systems to set up, maintain, collect and process data

Ifsc, Dublin

Responsibilities included the processing of redemptions to shareholders, the transfer of monies to and from fund accounts, answering telephone and dealing queries, processing foreign exchange deals, adherence to anti money laundering regulations and checking bank account liquidity daily.

Blenheim Place, Edinburgh

Role responsibilities included the payment of both initial and renewal commission and any queries that arose as a result, dealing with deceased clients PEP, ISA and OEIC holdings, provision of probate and up-to-date valuations. Had regular correspondence with solicitors and executors, adherence to anti money laundering regulations and provision of daily, weekly and monthly statistics to client companies, client managers and senior management.