Cyril Arachequesne

For the Viking project, implementation in SimCorp Dimension of interfaces for various OTC (FX forward, IRS, CDS, CCS, ILS, ...). • Development of various exports and imports with multiple partners such as State Street Bank for record keeping, reportings for Portfolios Controlers in Asia, … • Modifications and support on various communication servers for instance to mirror OTC positions from Sophis Value to SimCorp Dimension, … • Advises / Consultancy on architecture, utilization of various functionalities such as translations, formulas, formulas matrix values, … • Upgrade v6.1 to 6.3.1: coordination for OTC non-regression testings • Implementation of various reportings for MIFID/MIFIR through the Trade Repository Pool and Reporting Pool modules

For the GAIA project, implementation in SimCorp Dimension of workflows and interfaces for various securities (Equities, Fund certificate, FX forward, OTC, ...) with multiple partners (custodians, fund admin, …). Support of IT teams and other streams. • Development and customization of SWIFT messages MT304, MT396, MT502, MT509, MT515, MT535, MT54x, MT54y, MT940, MT950, … • Development of interfaces and/or workflows for OTC: CDS index, CDS single name, IRS basis, IRS fixed float, IRS OIS, TRS, Swap Inflation, Asset Swap Inflation, … • Development and customization of non-SWIFT messages: PEKT502, ACK PEKT, PDF tickets sent through emails, flat files for Markit, fund admins, …

In parallel with my mission for Fédéris Gestion d’Actifs (2 days per week), in a context with pressure, my job consists in making critical or minor modifications in the Data (Parties + ratings) management.

I'm in charge of designing reports for the various business departments, provide some support for the IT departments of our prospects/customers in Western Europe : - help them designing their architecture - tune the various performances, in particular the ones from the DB: statistics gathering, analysis of the explain plan, ... - setup some archiving or audit projects - upgrade their version of SimCorp Dimension from a technical point of view - ... - IT presentations including some workshops on various topics

For almost 4 years, I was: - Team leader, allocating from 4 to 8 engineers to maintain the level 2 support for 11 sites of pharmaceutical production among which 5 are outside France (Hungary, England, Brazil and Spain). This support consisted in around 60 requests per week with a daily pool around 30 requests going from installing an Oracle patch, to a question on a remote file not being integrated properly or AQ questions related to an external audit for example. - Expert PL/SQL: I was developing and tuning complex PL/SQL algorithm for Oracle DB in 9i, 10g and 11i in an international environment with a huge quality aspect because of pharmaceutical regulatory.

I've been in charge of teaching a class with an average of 30 students the concept of ERP and in particular the solution of Oracle named Oracle Application (aka OeBS). This job implied to entertain a class with theorical lessons but, as well, to prepare practical exercises, build simplified situations from the daily life of a consultant working on ERP.