Martin Lyons Email & Phone Number

London, United Kingdom

• Worked closely with business stakeholders to agree EMIR/MiFID2 reporting requirements, wrote epics and user stories in JIRA to capture requirements for developers to build, map and transmit data from Murex to CMRS (Sapient reporting tool) for downstream submission to trade repositories.• Analysed EMIR/MiFID2 reportable fields for derivative and bond products to ensure their correct definition as Murex native or user defined (UDF) MxML fields, counterparty reference data or CSV Valuation, Collateral and Position reports for developing user stories.• Liaised closely with middle office to write tests in JIRA to ensure reportable events were captured and agreed acceptance criteria were met, and that trades were correctly messaged downstream to CMRS and trade repositories DTCC, Tradeweb and TRAX in FIT and UAT cycles for bond, IRS, FRA and FX trades.• Undertook testing to comply with sprint cycles by inputting trades to Murex, Tradeweb and Markitwire to ensure affirmation, clearing and reporting via CMRS to the repositories. Monitored fixes and retested until ACKs or appropriate messages were received. • Managed working relationship with stakeholders through daily meetings to review testing and ensure issues were highlighted quickly, work arounds were agreed, documented all issues in JIRA and updated scrums.• Attended twice daily scrums to report test progress and sign off, defects, defect resolution and work arounds that had been agreed with middle office stakeholders. Liaised closely with the PMO to prioritise and escalate issues.• Raised defects and change requests in JIRA and linked them to tests and user stories, ensured that JIRA status was correct i.e. open, re-opened, resolved, closed. • Used Visio, Word and PowerPoint to create current and target operating models for processes impacted by the Murex implementation including hedge accounting, cash flows, credit risk limits and fixings.

London, United Kingdom

• Liaised with spend wise unit (SWU) business partners to ensure monthly submissions were received on time with appropriate commentary, and variances to budget explained and supplied with evidence when necessary.• Used SAP to Produce monthly flash and actual expense submissions for the business executive committee (BEC), ensuring all SWU numbers were correct, and that commentary provided suitable explanations of variances to budget. Wrote high level commentary on trends and highlighted areas of concern for senior management and BEC.• Reconciled the different TSB and Lloyds accounting methodologies (TSB SWUs to Lloyds business costs units) to ensure all costs were captured and correctly accounted.• Agreed a methodology with Lloyds Bank to ensure costs incurred for TSB IPO were accounted as business as usual or as the project cost of creating the TSB as a challenger bank.• Posted monthly journals from flash numbers, and quarterly true up corrections from actual numbers, to ensure that the agreed methodology was maintained and costs were correctly apportioned.

Edinburgh, United Kingdom

• Developed FSR reports, sections and objects populated with Word text and Excel tables.• Linked Excel objects to the FSR account hierarchy and to Excel spreadsheets.• Wrote section variables to maintain table of contents and note headings.• Wrote object variables to cross reference and validate financial data in the principle financial statements to the accounting notes.• Led team to agree standard accounting templates for subsidiary reporting.• Tagged objects for XBRL submission.

Edinburgh, United Kingdom

• Coordinated testing of Simplification Project to move HBoS data from ACBS v5.3 to v6.01, created test plans, logged test defects on Quality Centre and resolved test issues.• Ensured all systems (ACBS, Summit, PARIS, CRESTOW, Oracle, SAP) were integrated in testing process and that each ‘end of day’ phase was correctly undertaken and signed off.• Analysed and documented accounting processes and managed the hand over of tasks to newly created LIBOR team in Edinburgh.• Wrote training material for tasks brought into the LIBOR team and trained staff in their new tasks.

Edinburgh, United Kingdom

Business Analyst – Regulatory Reporting Project implementing Moody’s Risk Authority calculator for risk weighted assets• Designed Visio flow charts for current and target processes to implement Moody’s Risk Authority and an upgraded SAP system. • Documented work processes and maintained departmental project plan. • Maintained working group presentations and documentation.

London/Edinburgh

Project Development Manager – ABN AMRO bank integration to RBS 6 month contract extended to 1 year• Built and controlled the relationship between project staff (London), systems teams (Edinburgh) and regional centres (worldwide) to ensure change deadlines were understood and BAU schedules complied with.• Ensured that ABM AMRO data mapped correctly into RBS GL, consolidation and reporting hierarchies ensuring all reporting requirements were met.• Managed the static data change requests ensuring that accounting data was correctly set up in Walker GL and Hyperion consolidation system. • Managed stakeholder involvement to ensure all accounting, reporting and currency needs were correctly reflected.• Acted as single point of contact to resolve data problems as they arose through quick and effective communications with stakeholders.• Resolved testing issues as they arose in Walker GL and wrote Business Objects reports to show accounting postings.• Prepared slides and presentations for meetings, kept minutes and action logs and reported on RAID status.

Edinburgh, United Kingdom

Business Analyst HFM Reporting 3 month contract extended to 1 year• Agreed account, dimension and layout specifications with accounting staff to create new reports on P&L, BS, ROCE, cash flow, assets employed. • Analysed, wrote and tested reports in Hyperion Financial Manager and ensured that correct financial data was reported.

Edinburgh, United Kingdom

Change Team Systems Administration Manager (2007 – 2009)• Managed a new section of 5 staff taking responsibility for the Walker general ledger, Essbase and Cognos reporting systems and Cartesis Magnitude consolidation system.• Ensured that all KPIs were met, reporting and consolidation functions were correctly undertaken and system security was maintained.• Used good working relationships with customers to negotiate a unified approach to tighter period close timetables and developed reports allowing managers greater control over the close process.Walker System Manager (2005 – 2007)• Managed a team of 3 staff ensuring 30 source systems were interfaced to Walker, accounting structures were correctly maintained and system access was granted in accordance with authorization.• Improved control over the period and annual general ledger close by creating individual groups of accounts to be closed at separate times.• Initiated a project to automate the daily Walker held account clearing process. This involved held account data being sent straight to the reporting teams for them to clear rather than coming through the central control team. This gave the responsible teams greater control over the process, cut down on unnecessary communications and helped reduce the number of posting to held accounts. • Created new reports and processes to ensure that the monthly Multifonds investment interface to Walker was better managed and that problems were more quickly identified.System Accountant (2004 – 2005)• Maintained Essbase to ensure that the accounting structures correctly reflected the company’s requirements and that the system was populated daily with general ledger data.• Undertook source systems interface controls to ensure financial integrity and maintained security of the Walker general ledger.• Tested the outsourced Multifonds investment interface to Walker to ensure that accounts were correctly populated.• Created Cognos reports to meet customer needs.

Edinburgh, United Kingdom

(until 31/07/2001 Scottish Provident Insurance)Left because of redundancy due to Abbey National closing the Scottish Provident office in EdinburghSenior Business Analyst (2000 to 2004)• Led the construction and testing of the new Walker accounting structure as part of the Scottish Provident’s integration project to Abbey National.• Created automated bank reconciliations and reports using Business Objects.• Created new accounting structures on Millennium and tested interfaces to ensure that the new accounts were correctly populated in the Scottish Provident demutualization project. Control Accountant (1993 – 2000)• Managed a small team ensuring the financial integrity of the Millennium general ledger through daily controls of source system interfaces, maintenance of accounting and reporting structures and system security.• Created reports using the Millennium reporting facilities to meet customer specifications.

Edinburgh, United Kingdom

Milan Area, Italy

London, United Kingdom

London, United Kingdom

Wellington, New Zealand

London, United Kingdom

Edinburgh, United Kingdom

Government And Modern History, History, Politics, Economics, Upper Second

Certificate In Accountancy

Education record

Education record