Menu

John MCGAHAN

  • societe generale securies services
  • Business Analyst

luxembourg

En résumé

Experienced Consultant and Business Analyst with over 25 years experience in IT with 15 years experience in Finance and 2 Years in Retail and Supply Chain. IT expert with 15 years experience as an Oracle Consultant and 10 years as a Business Analyst and Project Manager. Certified as a Software tester, Business Analyst, Project Manager and Efront Consultant.
Very experienced in working in an International environment (Onshore and offshore) and in the areas of
Asset Management and Wealth Management.
Fund Administration(Transfer Agency and Fund Accounting),
Credit Risk and Security based Lending
Customer on boarding (KYC and AML)
Private Equity and Real Estate
OTC Derivatives
Migration and IT integration projects.

Entreprises

  • societe generale securies services - Business Analyst

    Informatique | luxembourg 2019 - 2019 IT CONSULTANT- Senior Business Analyst. Working in the IT section for the Transfer Agency department on a Migration Out of funds to another Institutional Transfer Agency and also a migration of Private Equity funds from MFTA to the Efront platform. Working as part of an Agile team
    Responsible for
    • Data extracts from MFTA of Static data, trades and positions.
    • Data Analysis of migration data
    • Writing User stories based upon Business Requirements for the development team
    • Functional testing of developments
    • Workshops , Mapping and Analysis of Migration flows
    • Analysis and extraction of the KYC/AML documentation from the EXP AG document management system for the funds which were being migrated
  • BNP Paribas Securities Services - Functional Analyst

    Informatique | Luxembourg 2018 - 2018 IT CONSULTANT-Functional Analyst. Working in the IT section on both Fund Accounting and Transfer Agency projects for the Private Equity and Real Estate Department
    Responsible for
    • Writing Functional specifications
    • Development of EFRONT Invest interfaces and Report writing in EFRONT.
    • Setting up Instrument Types and associated tranasaction types
    • Setting up loans through FrontLoan
    • Setting up new workflows
    • Migration of new client data via Data Import Tool
    • Analysis and development of interfaces for Viager instruments for Paris office
    Key Software used EFRONT Frontinvest FrontLoan, FrontAnalytics, FrontReport, Frontscript, Windows, Javascript , Oracle, SQL Developer, HP Application Lifecycle Management 11, SVN , Microsoft Visio
  • world intellectual Property Organisation - Business Analyst

    Informatique | Geneva 2017 - 2018 Working in RSD(Registry Support Division) as a Business Analyst on MIRIS(Madrid International Registries Information system) system. This is the business applications that allows WIPO to administer the Madrid Agreement and Protocol

    Responsable for
    • Project planning of enhancements
    • The analysis and design of enhancements to the system
    • Formulation of Technical specification from Business Requirements provided by the business,
    • System testing of developments
    • Data analysis and adhoc reporting for the business
    • Re-design of the current data model

    Key Software used Windows XP, Java, Oracle, SQL Developer, HP Application Lifecycle Management 11, Jira, Maven , Eclipse , Microsoft Visio
  • Ralph Lauren Europe SARL - Business Analyst

    Finance | Geneva 2015 - 2017 Working on large SAP migration project in Finance IT in the Integrated Application team.

    Responsable for
    • Creating the Functional Designs of Finance flows in and and out of SAP.
    • Planning for testing and build
    • Analysis of ‘As-is’ process flows and design of ‘To-be’ flows
    • Management of external vendors and developers.
    • Managing implementation of designed solutions.
    • Documentation including Business Process, Functional Design, Test Strategy & Test Scripts
    • Providing Status Reports to the PMO and ensuring all required documentation and reports are kept up to date.
    • Technical Interface Design (file formats, field mapping, interface protocol, transfer method, integration method) between many external systems and SAP via SAP PI.

    Key Software used Windows XP, Oracle,SQL Developer, SAP ECC 6,SAP FICO, HP Application Lifecycle Management 11, Microsoft Visio, Reconnet, Fintrax, CoStar
  • Brown Brothers Harriman - Business Analyst

    2014 - 2014 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
    • Implementation of set up in MFTA for new payment cash flows
    • UAT of new flows
    • Creation of BRD for Transfer Agency data for AIFMD Reporting
    Key Software used Windows XP, Oracle,SQL Developer, Multifonds MFTA, HP Application Lifecycle Management 11, Jira, IBM Blueworks Live, TLM



  • JP Morgan Private Bank - IT CONSULTANT-Business Analyst - Working & technology department

    Paris 2014 - 2014 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. This was a very hands on role as we had extremely tight deadlines due to a regulatory and business needs
    * Coordinating with the business the creation of the Business Requirements document
    * Coordinating with IT Risk and compliance processes for extracting sensitive PI data from legacy systems, in compliance with regulatory authorities.
    * Project management of change requests from conception to implementation
    * Writing of Functional specifications for third party supplier
    * Data Analysis and data mapping of the data to be migrated
    * Development of extraction scripts in Transact-SQL for upload into the 3rd party system
    * System Integration testing and project management of User acceptance testing
    * Co-ordination of releases into production for EMEA, Asia and US platforms
    * Management and co-ordination of Issue Log
    Key Software used Windows XP, Transact-SQL, Sybase, Sqlserver, Olympic, Java, HP Application Lifecycle Management 11, Agile development, Jira,SVN
  • JP Morgan Private Bank - IT CONSULTANT-Business Analyst - Working & technology department

    Paris 2013 - 2013 IT CONSULTANT-Business Analyst - Working in technology department for the Credit team on a project introducing an interface to book loans and mortgages in Olympic Banking system.
    * Writing of Business Requirements and Functional specifications including changes required to physical data model for Mortgage and Loan ticket and Credit Checks functionality
    * Writing User Stories in Jira for offshore developments in India
    * Project management of change requests from conception to implementation
    * Development of system test plans and test cases ;
    * Project management of User acceptance testing ;
    * Analysis of Business Process flows using UML techniques such as Use Cases, Sequence diagrams and Activity Diagrams
    * Implementation of Olympic Retail Credit Module
    Key Software used Windows XP, Transact-SQL, Sybase, Olympic, Java, HP Application Lifecycle Management 11, Agile development, Jira
  • Julius Baer - IT CONSULTANT-Business Analyst - Working & technology department

    Zurich 2012 - 2012 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 4 separate 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 ; Creating reports for RUBIK prepayment UK Tax agreement
    * Responsible for System testing of development changes and UAT coordination
    * Analysis of Business Process flows using UML techniques such as Use Cases, Sequence diagrams and Activity Diagrams
    * Writing of Business Requirements and Functional specifications including changes required to physical data model
    * Co-ordination of developments in India and the USA ;
    * Data analysis and Data Mining for Rubik prepayment UK Tax agreement ;
    * Project management of User acceptance testing
    Key Software used Windows XP, Oracle 10.2.0.5.0, PL/SQL Developer, Prospero, Magic, Java, HP Quality Center 10, JIRA
  • JP Morgan Private Bank - IT CONSULTANT-Business Analyst - Working & technology department

    Paris 2011 - 2011 JP Morgan Private Bank(Private Banking - Wealth Management) -
    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.
    * Writing of Business Requirements and Functional specifications including changes required to physical data model
    * Project management of change requests from conception to implementation
    * Co-ordination of offshore developments in India and UAT between Geneva and Hong Kong offices
    * Development of system test plans and test cases ;
    * Project management of User acceptance testing for new Asian platform
    * Responsible 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).
    * System testing of equity, FX and Fixed Income trade flows for CNH currency
    * Creating Business Flow Diagrams to analyse impact of changes
    * Analysis of Business Process flows using UML techniques such as Use Cases, Sequence diagrams and Activity Diagrams
    * Implementing setups in JP systems, Murex and Olympic. ;
    * Testing trade flows within Murex, Finiq, JP Systems and Olympic
    Key Software used Windows XP, Transact-SQL, Sybase, Murex, Olympic, Finiq, Java, HP Quality Center 10
  • BNP Paribas Security Services - IT CONSULTANT & Business Analyst

    Paris 2004 - 2010 IT CONSULTANT-Business Analyst. Working in the IT section for the Transfer Agency department.
    Responsible 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 and Design of Business Process flows using UML techniques

    Specifically worked on the following projects
    * The design of a Dynamic Reporting System from the TA front end into Multifonds infocenter;
    * The analysis and design of Cash Flow and Simulation cash flow reports for Fund Managers
    * The design and development of a system to create XML files from Multifonds data using Oracle reporting for regulatory reporting of security positions for the Swiss and Italian Authorities;
    * Implementation of the NAV, Register and Order STP interfaces into Multifonds
    * SWIFT interfacing into Multifonds Transfer Agency(MT502,MT509,MT515) and Olympic(MT202,MT103)
    * Creation of SWIFT messages for statements (MT535 and MT536)
    * Analysis and design of the STP interface between NSCC(Comserv and Fundserv) and BNP Paribas
    * Flow for sending of XML to printing company to generate statements and contract notes
    * Analysis and design reporting for KYC and AML purposes
    * Development of System test plans and test cases using HP Quality center 9.2(formerly TestDirector)
    * Involved in the migration of ING funds to BPSS systems
    * Creation of Business Objects Universes for Operations and Reporting teams
    Key Software used Oracle 9.2.0.2.1,Oracle 10G, UNIX(AIX), Windows XP, Oracle Reports 6i,10G,PL/SQL,Designer 2000 2.1.2 , T.O.A.D, Starteam 6.0, Oracle Report server. Business Objects XI , Multifonds
  • JP Morgan Chase Bank - IT CONSULTANT

    Paris 2003 - 2004 JP Morgan Chase Bank(Investment Banking - Asset Management) -
    IT CONSULTANT- 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 spread sheets from Oracle Database; used expertise in Oracle to redevelop pl/sql code which were causing performance problems
  • ABM UK Ltd - IT CONSULTANT & Business Analyst

    2002 - 2003 IT CONSULTANT-Business Analyst - 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
  • JP Morgan Chase Bank - IT CONSULTANT

    Paris 2001 - 2002 JP Morgan Chase Bank (Investment Banking - Asset Management) - Luxembourg. IT CONSULTANT-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
  • HBOS Bank - IT CONSULTANT-Working

    2000 - 2001 HBOS Bank(Corporate Banking) - on 2 separate projects.
    First of all, worked for the Application Development Department on a System that processes commission and fee payments to financial intermediaries(MIMS Mortgage Intermediary Management System). The system was written in Visual Basic 6 with an Oracle 8.0.5 back end. Specific tasks included The Analysis and Design of the Oracle Database Using data modelling techniques(Physical and Logical) to design databases and Universe building and report writing in BUSINESS OBJECTS(4.1.4) .
    For the second project, worked for the Information Systems department for the Corporate Business division. Was part of a team which Designed and developed a new All Employee Sharesave System for the department.
  • Card Protection Plan - IT CONSULTANT & Systems Analyst

    2000 - 2000 IT CONSULTANT-Systems Analyst -Worked in the Information Systems department for the International Team. Responsible for the Development and support of the companies PROTECTOR International systems. Using Oracle forms and reports (Forms 4.5, Reports 2.5). Pro*Cobol .PL/SQL.
  • HBOS Bank - IT CONSULTANT & Systems Analyst

    1999 - 1999 HBOS Bank(Corporate Banking) - . Worked for the Information Systems department for the Corporate Business division. Designed and developed a new International Sharesave System for the department using Designer 2000 and Developer 2000(Forms 4.5 and Reports 2.5) and created a Universe in BUSINESS OBJECTS (4.1.2) for report querying.
  • Dupont Chemicals - IT CONSULTANT & Analyst Programmer

    1997 - 1999 IT CONSULTANT-Analyst Programmer Working for Tioxide Europe Ltd ,a division of Dupont Chemicals. Designed and developed a new Stock control system for the Stores Department and a new Purchasing System for the Purchasing Department using Developer 2000(Forms 4.5 and Reports 2.5).
  • Motherwell Information Systems - SENIOR ENGINEER -Working

    1997 - 1997 Motherwell Information Systems(Software Company) -
    SENIOR ENGINEER -Working in the Pharmaceuticals department. Duties included: Oracle Database builds ; Technical support of existing UNIX(hp-ux)/Oracle systems on client sites at Glaxo Welcome: The Analysis, Design and implementation of an Oracle based configuration and reporting system for measuring the manufacturing performances of a factory for British Gypsum using Developer 2000 development work(Forms 4.5 and Reports 2.5) ;The design and implementation of a dispensary reporting system for Glaxo Welcome using Developer 2000 development work(Forms 4.5 and Reports 2.5) ;
  • Bacon & Woodrow - ANALYST/PROGRAMMER

    1996 - 1997 ANALYST/PROGRAMMER - Employed in the Development department. Responsible for the technical and Application support of all the companies internal UNIX(HP-UX)/Oracle system.
  • Quality Software Products - TECHNICAL CONSULTANT

    1992 - 1996 TECHNICAL CONSULTANT- employed in the Product Distribution Division. Responsible for system builds and level releases for all Mid Range UNIX / Oracle based systems. .Previous to this I was Team Leader in the QA department and a Computer Programmer in COBOL and DB2.
  • Jarvis Porter Group - SENIOR ACCOUNT & MANAGER

    1988 - 1991 SENIOR ACCOUNT MANAGER- Employed in Account Handling capacity, for a large print and design company, based in Leeds.
  • Jarvis Porter Group - SENIOR ACCOUNT & MANAGER

    1988 - 1991 SENIOR ACCOUNT MANAGER- Employed in Account Handling capacity, for a large print and design company, based in Leeds.
  • Jarvis Porter Group - SENIOR ACCOUNT & MANAGER

    1988 - 1991 SENIOR ACCOUNT MANAGER- Employed in Account Handling capacity, for a large print and design company, based in Leeds.

Formations

  • British Computing Soceity / ISEB ISEB (Swindon)

    Swindon 2011 - 2011 Certificate

    STQB-BCS - Certified Tester Foundation Level
  • British Computing Soceity / ISEB ISEB (Swindon)

    Swindon 2011 - 2011 Certificate

    STQB-BCS - Certified Tester Foundation Level
  • British Computer Society (London)

    London 2011 - 2011 Certificate in Business Analysis
  • British Computing Soceity / ISEB (Genève)

    Genève 2011 - 2011 Certificate

    ISEB - Certificate in IS Project Management
  • British Computing Soceity / ISEB (Genève)

    Genève 2011 - 2011 Certificate

    ISEB - Certificate in IS Project Management
  • British Computer Society (London)

    London 2011 - 2011 Certificate in Business Analysis
  • ISEB (Londres)

    Londres 2011 - 2011 Certificate

    ISTQB-BCS - Certified Tester Foundation Level


    LANGUAGES SPOKEN
  • ISEB (Londres)

    Londres 2011 - 2011 Certificate

    ISEB - Certificate in IS Project Management
  • Université Bordeaux 3 Montaigne

    Pessac 2002 - 2002 French language course intermediate level
  • University Of Sunderland (Sunderland)

    Sunderland 1991 - 1992 Master of Science

    Computer based information systems
  • University Of Sunderland (Sunderland)

    Sunderland 1991 - 1992 Master of Science

    Computer ased information systems
  • Leeds Metropolitan University Leeds University Business School (Leeds)

    Leeds 1984 - 1988 Ba(Hons) Business Studies

    Skills acquired, subjects covered, extracurricular activities.
  • Leeds Metropolitan University (Leeds)

    Leeds 1983 - 1988 Bachelor of Arts

    Business Studies
  • Leeds Metropolitan University (Leeds)

    Leeds 1983 - 1988 Bachelor of Arts

    Business Studies
  • Leeds Metropolitan University (Leeds)

    Leeds 1983 - 1988 Bachelor of Arts

    Business Studies

Réseau

Annuaire des membres :