John McGahan

Business Analyst Finance(Fixed Term Contract) Working on large SAP migration project in Finance IT in the Integrated Application team.

CONSULTANT-Business Analyst working in Change Management of Investor Services.In charge of the Analysi and Implementation of Multifonds Payment Module. Includes • Writing of Business Requirements and Functional specifications • Analysis of current payment processing system • Design of interfaces for generation and reconciliation of Swift MT202, MT210 and MT103

IT CONSULTANT-Business Analyst – Working in technology department on major Global KYC migration project. This project was for the migration of data from current legacy systems in EMEA, Asia and US, to a third party developed system. Worked also in technology department for the Credit team on a project introducing an interface to book loans and mortgages in Olympic Banking system.

IT CONSULTANT-Business Analyst – Working in technology department. Specifically working on the area of Credit Risk on a project for automating Securities based lending. I worked on 3 seperate projects which involved the development of an automated CPR process(Credit Proposal and Relationships Summary); a centralised system for security approval giving default weightings for advance,maintenance and concentration levels ; Enhancements to the current Margin call system.

IT CONSULTANT-Business Analyst – Working in technology department in the Products team Working on large migration project and also the introduction of the Chinese Offshore currency (CNH) to the banks products. • Responsable for System testing of development changes and UAT coordination. Specifically for the trading of OTC Derivative products including FX Options, Equity Options, Cross Currency Swaps, Interest Rate Swaps, Structured products(including Dual Currency Contract, Equity Linked Notes).

IT CONSULTANT-Business Analyst. Working in the IT section for the Transfer Agency department. Responsable for Business Requirements Analysis; Functional Requirements Documentation; Writing Functional Specifications for development teams; System testing using Quality Center; Co-ordination of UAT testing and developments Offshore in India and Portugal; Analysis and design of the database using logical and physical data modelling techniques(UML and SSADM) ; Impact analysis for Multifonds releases; Analysis

IT CONSULTANT- Systems Analyst working for the Application Development Department. Working within Transfer Agency specifically wrote Oracle Forms, Reports and pl/sql to allow transfer agency team to use IBAN accounts in GFAS 2;Wrote Visual Basic program to allow automatic generation of Excel spreadsheets from Oracle Database;Used expertise in Oracle to redevelop pl/sql code which were causing performance problems

Worked in a team which developed a Crime Intelligence system for the Pennsylvania State Police Department. Specifically responsible for the analysis, specification and development of the reporting system for the system and the pl/sql backend development within the system, using Reports 6i, Forms 6i and Oracle 9i. Responsible for changes to the data model

IT CONSULTANT-Systems Analyst Working for the Application Development Department. Working with the Transfer Agency and Fund Accounting teams, worked as part of a team, which analysed, designed and developed a datawarehouse system. Worked with the development team on performance problems within the databases and advised on appropriate redevelopment of pl/sql code and changes needed to the physical data model.Worked with the release teams to build systems and releases

Computer based information systems