Andrés - Formateur EXCEL
Ref : 050307M001-
Profil
Formateur, Consultant fonctionnel, Business Analyst (60 ans)
-
StatutFreelance
-
Independent Expert-Council in Olympic Banking System
TATA Consultancy ServicesAmsterdam - BudapestJan 2005 - Jan 2005Involved in the “Tata Consultancy Services” negotiations team for the concluding of an Olympic Banking System implementation and outsourcing contract between “TATA Consultancy Services” and “ABN AMRO Bank Luxembourg”, my role was mainly to take an active part and contribute to the good course of the negotiations by getting the most important technical and functional information, such as :
User Guide: General level – technical and functional, in order to help a new team to read and to be able to work in an Olympic related development for ABN AMRO Bank.
Training Manual : Intended to the development team, technical material has been required
Testing : Both parameterization and development testing procedures
Challenges with ERI Bancaire: How to be aware and resolve forseen issues.
For references purposes:
Mr. Mani S.V. – General Manager, Tata Consultancy Services - Hungary Branch /
tel. +36 18868010 -
Jan 2004 - Jan 2005
Involved in a personal project regarding financial business.
-
Chase – JP Morgan Geneva / Switzerland (multi site)Jan 2004 - Jan 2004
Olympic Specialist & Business Analyst as independent consultant
Attached to the Paris Olympic project team as independent consultant, my various tasks are much diversified and interesting in helping and supporting the project team and futures users and they are mainly such as:
Business Analyst on Periodic Fees, Overdrafts and Forex
Banking knowledge support
Olympic knowledge support
Olympic parameterisation
Periodic Fees, Overdrafts and Forex process
Tests of new developments
Personalised users documentation
Topaz, Apollo and Apollo Fees support and council
For references purposes:
Mr. Philippe Fromaigeat – Independent consultant, PHFR Consulting / tel. +41 79 789 9263
Mrs Nadia Ben Amira – Paris Olympic Team, JP Morgan Geneva / tel. +41 22 744 12 79
Mr. Marc Assaraf – General Manager, Eri Bancaire / tel. + 41 22 342 12 29
Mr. Graham Ridgway – AS400 specialist, Eri Bancaire / tel. + 41 22 342 12 29 -
Medical Break due to an accident
BSCT – Banca dello Stato Cantone TicinoBellinzona / Switzerland (multi site)Jan 2004 - Jan 2004Olympic Specialist & Business Analyst as independent consultant
Attached to the Olympic project team as independent consultant, my various tasks are much diversified and interesting in helping and supporting the project team and futures users and they are mainly such as:
Business Analyst
Banking knowledge support
Olympic knowledge support
Olympic parameterisation
Olympic Training to the project team and futures users
Tests of new developments
Personalised users documentation
Banking training
Olympic and non Olmypic banking telecommunications (Swift, Sic, Secom, Telekurs, Bancomat, etc.) training, support and council
For references purposes:
Mr. Philippe Fromaigeat – Independent consultant, PHFR Consulting / tel. +41 79 789 9263
Mr. Ralph Levy – Independent consultant /tel. +41 79 679 87 14
Mr. Marc Assaraf – General Manager, Eri Bancaire / tel. + 41 22 342 12 29
Mr. Graham Ridgway – AS400 specialist, Eri Bancaire / tel. + 41 22 342 12 29
Mr. Claudio Mozzini – T.P. Olympic Project Manager, BSCT Banca dello Stato Cantone
Ticino / tel. : + 41 91 803 75 19
Mr. Nicola Petrucciani – Org. Olympic Project Manager, BSCT Banca dello Stato
Cantone Ticino / tel. : + 41 91 803 71 11 -
Olympic Specialist & Business Analyst as independent consultant
BDL – Banca di Lugano(A private bank of the UBS Group) Lugano / SwitzerlandJan 2002 - Jan 2002Attached to the Olympic project team as independent consultant, my various tasks where very diversified and interesting in helping and supporting the project team and futures users and they where mainly such as:
Business Analyst
Olympic knowledge support
Olympic parameterisation
Olympic Training to the project team and futures users
Tests of new developments
Personalised users documentation
Olympic and non Olmypic banking telecommunications (Swift, Sic, Secom, Telekurs, Bancomat, VDF, etc.) training, support and council -
Telecommunications and Financial Transfers adviser product-specialist
ERI Bancaire SAJan 2000 - Jan 2002Attached to the Hot-Line and Deployment service, my knowledge allowed me to take part of various Olympic projects implementation such as SSP Salomon Smith Barney Prime London, Morgan Stanley London, BDL Banca di Lugano, Lugano (a private bank of the UBS Group), etc.
My various tasks within these services were mainly:
Hot-Line
Quality tests before and after setting into production
Parameter setting of the various tables, switches and id
Installation of the telecommunications module and interfaces related to software package OLYMPIC
Support in the technical field, telecommunications, securities, forex and money markets, treasury, client file, interrogation and transfer modules with the various customers all over the world
Customers and internal Training in the field of telecommunications + Olympic modules
Planning and coordination of the Swift 2000 project
Participating and advising the telecommunications projects which have to be planned and developed, following the modifications of standards, rules and laws referring to telecommunications. -
Assistant to the person in charge of the Telecommunications service
UNION BANCAIRE PRIVEE – UBPJan 1998 - Jan 1998Attached to the telecommunications service and back office department of the bank and its branches in Switzerland and abroad, my professional knowledge allowed me to take part of the implementation of a new telecommunications system ‘STELINK', (in replacement of 'STACHEM'), platform including Swift, Telex, Sic, Fax, telegraphic key and Bilateral keys exchange (swift authentication – encryption)
My functions within this service were mainly:
To supervise the means of telecommunications, as well the Geneva headquarters as for the branches in Switzerland and abroad.
Relation, exchange and control of telegraphic keys and/or swift authenticator (BKE) between the bank, its branches and its various correspondents.
Ensure the technical support of various specific networks in the telecommunications area.
Assistance and training to users of various telecommunication systems.
Encoding, checking and sending of all type of swift, sic and telex messages.
Participated to the tests of the year 2000.
Organization and classification of micro-cards and signature books of the various correspondents of the bank as well signatures control of the various correspondents for all banking services.
Back office tasks -
TRAVELLED ABROAD BANQUE BRUXELLES LAMBERT (SUISSE) S.A. (BBLS)Jan 1989 - Jan 1997
Person in charge of Telecommunications department
Establishment of various softwares, technical means and/or telecommunications systems including swift Alliance (Risc 6000 – Secure X25L), TMS, R.3.2.0 VSAM of Dataware, UTA (Universal Telex Adaptor), Server etc.…
My task consisted mainly in:
Organizing and managing the team (schedules, planning of work and training), the material and logistics
To supervise the means of telecommunications: Swift, Sic, Telex, and Fax, being directly linked to telecommunications service and/or other users of the bank.
Relations and exchange of telegraphic keys and/or swift authenticators (BKE/SAK) between the bank and its various correspondents.
To ensure the technical support of the various specific networks within my sector, (control and follow-up of technical means available to detect the possible breakdowns and to solve them.
Training courses within the different services of the back-office of the bank (Money transfers, reconciliation, nostri controls, stock exchange, etc.) -
CANADIAN IMPERIAL BANK OF COMMERCE (SUISSE) S.A.Jan 1987 - Jan 1989
Installation of swift st200 system
Encoding, checking, correcting, sending and receiving messages going through swift, telex and fax, then sending to the concerned services.
Relations and exchanges of swift authenticator keys (sak) within the various correspondents. -
Telex operator, Telephone operator, Receptionist
SOPARCHIMJan 1986 - Jan 1987To ensure the telex traffic and telephone of all the company, as well as welcoming the customers at the reception.
TRAINING SKILLS
SWIFT
o All Swift ISO 15022 messages type
o SWIFT for Investment Managers & Brokers
o Interest Rate Swaps & Confirmation Match
o Payments and Cash Management
o Customer Credit Transfers
o Current Msgs for Settlement & Reconciliation
o Swift Module 4 Collection and Documentary Credits
o Alliance
o Basics – Systems Operations – Payment and Statements
DATA PROCESSING - TELECOMMUNICATIONS
o Programmer 1/A
o Olympic Banking System (training on various modules)
o Datasphère Sic – Secom – Swift
o Datasphère (Bali)
o Windows 95/98/WinMe/NT/2000/XP
o Word, Excel, PowerPoint, Access, Outlook, Project
o Adobe Acrobat, Frame viewer, Frame Maker, Illustrator
o Alliance
o Merva (IBM)
o Stachem
o Stelink
o PC Installation and maintenance
o Architecture and installation of various Telecommunications products
o Knowledge AS400
Languages
o French (Mother Tong)
o Spanish (Mother Tong)
o English (Excellent Knowledge)
o Italian (Excellent Knowledge)
o German (Good Understanding)
o Portuguese (Good Understanding)
SWIFT
o All Swift ISO 15022 messages type
o SWIFT for Investment Managers & Brokers
o Interest Rate Swaps & Confirmation Match
o Payments and Cash Management
o Customer Credit Transfers
o Current Msgs for Settlement & Reconciliation
o Swift Module 4 Collection and Documentary Credits
o Alliance
o Basics – Systems Operations – Payment and Statements
DATA PROCESSING - TELECOMMUNICATIONS
o Programmer 1/A
o Olympic Banking System (training on various modules)
o Datasphère Sic – Secom – Swift
o Datasphère (Bali)
o Windows 95/98/WinMe/NT/2000/XP
o Word, Excel, PowerPoint, Access, Outlook, Project
o Adobe Acrobat, Frame viewer, Frame Maker, Illustrator
o Alliance
o Merva (IBM)
o Stachem
o Stelink
o PC Installation and maintenance
o Architecture and installation of various Telecommunications products
o Knowledge AS400
Languages
o French (Mother Tong)
o Spanish (Mother Tong)
o English (Excellent Knowledge)
o Italian (Excellent Knowledge)
o German (Good Understanding)
o Portuguese (Good Understanding)