CV/Mission Fermat freelance

Résumé des missions de Sebastien,
freelance FERMAT résidant dans le Nord (59)

Professional Experiences

January 2019 until now Banque Publique d’Investissement (BPI) Paris

Project : RAY upgrade 5.0 to 6.1 : Technical and functional Analyst

• Performed technical upgrade, studied impacts and realised technical and functional tests.

June 2017 Until December 2018 Banque Populaire Caisse d’Epargne (BPCE) Paris

Project : New sourcing of Risk Authorities : Business Analyst

• Modelized expectations in terms of data : netting agreement, securitization and the distribution of On/Off balance data.

• Defined the non regression tests and performed tests of the new data flow by data provider: validated the data in the data warehouse, in the input stream of RAY, in the contract tables and in the result tables of RAY.
• Animated the workshops of anomalies follow-up and business workshops,

• Drafted the new data flow of a subsidiary: this flow has to source directly RRT.

June 09 Until 2017 Dexia Bank/Belfius (2009-2014 in Brussels, 2014-2017 in Paris)

Project « Fermat: Risk Management» : Technical Analyst

Limit Management,
Specified, developed, provided my PL/SQL expertise to the developer team and tested an in-house development for the limit management on the bank counterparties (PL/SQL development). This in-house development came in replacement of Fermat Gem.

Architecture simplification,
Due to the new limit management system, the global architecture has been reviewed and modified.
Defined the planning,
Organized and animated meeting with business team to follow the testing process,
Followed the corrections of issues,
Attributed tasks to the developpers,
Participated to committee,

Basle III:
Adjusted the parametrizations, the system in order to product Basle III reports. (PL/SQL and SQL scripting)

Fermat upgrades:
V5.3 to V8.2 in 2009, V8.2 to RAY 1.2.2 in 2012, RAY 1.2.2 to RAY 4.1:
Defined the planning, the project cost, resources to plan on the project,
Organised meeting to define the technical, functional and business testing process,
Studied the Datamodel impact of the new version: new objects, not listed objects,
Drafted the analysis of the custom impacts,
Performed the technical upgrade and defined the optimization method,
Adjusted components in PL/SQL to correct the behaviour or added new functionalities,
Tested the tools: BII, Reporting, Large Exposure runs,
Followed the corrections,

Dexia splitting between Belfius/BIL/DSA/SFIL
Managed the splitting and cleaning of the Fermat Databases (BII/Stress Testing/GEM) in order to limit the DB content to data owned by the company,
Duplicated the Credit Risk Dexia's platform for Belfius,
Created the credit risk environment for the new banks,

Stress Testing:
Project management: schedule and cost definition,
Defined the technical architecture,
Drafted the specifications for data import, access management, calculations,
Managed and performed tests,

Archiving:
Parametrization and rewriting of the archiving process

March 2012 RBC (15 days of expertise mission)

Project « Fermat: Risk Management»

Performance issue: Studied the system and provided best practice in order to improve performance.

February 08 – June 09 Fortis Bank
Project « Fermat: Risk Management»
FERMAT evolutions and supporting on the environment,
Drafted the rewriting of the loading program analysis (current program was developed in vb6),
Adjusted the Fermat parametrizations and the custom PL/SQL in order to answer to the user change requests,
Rewrote the loading program in PL/SQL,
Supported on the Fermat environments during the testing period,
Fermat functional analysis,

February 07 – February 08 Caisse des Dépôts et Consignations
Project « Consignations Management »
Replacement of the existing General Treasury application by the new Consignations Management system: Coresi,
Carried out additional functional specifications,
Checked the technical specifications,
Prepared the test plan, identified data resumption and studied Coresi functionality compatibility with the General Treasury work methodology.

September 06 – February 07 Société Générale
Project « Developments testing in Oracle E-Business Suite: Customer Relationship Management ».
Test strategy definition (test organisation, test system selection, test case rules…),
Using Test Director:
• Requirements,
• Test plan,
• Test execution,
• Defect and regression management,

April 06 – September 06 Caisse des Dépôts et Consignations
Project « CAD and Facility Management ».
CAD distribution and enrichment optimization and follow up of building occupation.
Administered the business application BDP from ADELIOR and defined the functional parameter settings,
Tested parameter settings and Excel importation software,
Carried out the functional specifications and tested the portable building management module,
Drafted user guides,
Trained users on additional modules,
Organized data resumption in the extended geographical perimeter,
Analyzed ADELIOR’s ability to meet project deadlines.

February 04-march 06 Informatique Caisse des Dépôts et Consignations
Project « CAD and Facility Management ».
Created files for financial negotiations and made the contract with the chosen solution supplier: BDP,
Defined the most appropriate technical architecture for material /software constraints,
Analyzed priorities for documented elements,
Carried out the test plan using: « Test director »,
Recommended validation process,
Technical tool installation with the supplier,
Tested the tool and listed defects,
User training,
Organized the data resumption in the initial geographical perimeter,

Project « Office applications ».
Studied tools to replace the existing mail management application,
Tested under Windows XP applications used under Windows NT,
Drafted the technical specifications and developed a workflow in Outlook with a database in Excel,
Technical environment : VB, VBscript, eVB, Autocad (ADT)

March 03-january 04 Informatique Caisse des Dépôts et Consignations
Engineering Internship
Project « CAD and Facility Management ».

Analyzed and defined user needs,
Drafted the specifications for validation by the steering committee,
Studied the existing application trade PEN Access and Active Manager from Vizelia and analyzed their new product: Facility Online and the standard of drawingC,
Looked for tools on the market to meet the facility management requirements,
Launched a request for proposal to the main editors (ADELIOR, VIZELIA, GEOMAP, ARES…) and carried out test cases to decide which editor was the most adapted to needs.

Project “Documentary management: Data Migration”.
Studied and carried out the migration,
Installed the automation processes for data recovery.
Tested and validated with the users.
Project “Internet Eulia”.
Web master: updated the site and dealt with the incidents.
Technical environment: VB, Perl, ASP, SQL, Autocad (ADT)

July 2002 U.D.A.P.E.I. Val d’Oise (1 month)
Technical training course
Created an Internet site presenting the U.D.A.P.E.I. and local associations. This site was destined for the parents and friends of handicapped people.
Technical environment: PHP, Apache, Flash, MYSQL.