CV/Mission d'AMOA Thinkfolio freelance

Exemple de missions de Christophe,
AMOA Thinkfolio habitant les Hauts-de-Seine (92)

• IT Project Manager and Senior IT Analyst/Tester

  BNPPARIBAS INVESTMENT PARTNER
  Jan 2013 - Jan 2017

  Context: Sensible Market Data Processing migration - Market Data flow Integration / big Data migration
  
  Achievements: -Migrated Exchange flow processing from VB6 to ETL AB-INITIO of DQC [Database for Listed instruments, characteristics, issuers, Ratings, economic sectors, Prices, Issuers and benchmarks of BNPP-IP] receiving data flows from Bloomberg, Reuters, Markit, Telekurs, Barclays, JPMorgan, StamData, Fastnet (Prices ABS/MBS)
  -Mapped, Specified, Tested, Delivered all publications from database DQC (listed instruments, ratings, prices…), BKGN (Benchmarks), BKFB (Benchmarks), RFGN (exchange rates) in pivot format CSV (Graph, Scheduling) dedicated to ThinkFolio, Minerva, Sophis, CRGE [Compliance], COPAL[Risk], Decalog,Asset Arena…
  
  Team: PMO, Analyst, BNPP developers x3 and IBM Giscours developers (Romania) x2
  Project Data Center migration - Market Data flow Integration / Technology and big Data migration
  responsible for managing project plan, designing, deploying and testing IT solutions during CMMi evaluation
  Mapped all fields Bloomberg, Listed Intruments, Prices, Ratings, Economic Sector, Benchmarks, exchanges rates, Issuers, scheduler (Alfred Berg Stamdata)
  deploying a complete migration from all Data flow batches in VB6 to ETL Ab-initio Soft graphs,
  Delivered 31 pivot publications for DQC in .csv (Instruments_Characteristics, Prices, Ratings, Issuers, Analystics, Economic_Sector, Instruments_Schedule, Vehicles and Technical Acknowledgement in .xml; plus delivered flow publications for BKGN and on BKFB, delivered Benchmark characteristics, composite and TimeSeries and studied/ delivered Composite relation flat pivot (3 levels only on recomputed weights) and one daily publication for the exchange rate from REUTERS (RFGN)
  plus Operation Processes Improvements, Bloomberg Data enhancements
  Set-up new provider flows (FACTSET /Cornerstone) for Benchmark data and DEXO for Ratings.
  Client Joeri Sempels (+32 2 274 86 55)– IT Data Management & Referential

  TECHNICAL ENVIRONMENT/METHODOLOGIES Database DQC, BKGN, BKFB, RFGN, MS SQL Server Management Studio 2007 (Microsoft) user, MS SQL, PLSQL Server (Oracle) 2007 user – IQGN Data Quality user, FBA_Net user, DECALOG Asset arena SunGard (testing), Ab-Initio EME, FileZilla 3.14.1, Clarity, Clarity Open Workbench, Geade, QualityCenter ALM PRO, ReleaseMe, DoReMe, Visio2010, Beyond Compare 3 - CMMi level II, MUSIQ (internal method), ITIL

• Senior Business Analyst on Project “Collateral Funding and Strategy”

  FINSYS Financial Systems
  Jan 2012 - Jan 2013

  Context of the project: Build a new business line for a SME
  Achievements: delivered Project specification dedicated on a new collateral offer for Corporate society and support SME to build a new offer
  
  Company a Collateral funding expert to build a complete offer about Collateral core banking services, organization and technical support : (Setting strategies, Optimizations, Process review, analysis and search for available assets, provide soft comparisons ),
  requirement, specification, Marketing documentation, 2013 Euroclear Collateral Conference
  Client Stéphane Panzani – Co-founder and manager of FINSYS - Financial Systems

  TECHNICAL ENVIRONMENT/METHODOLOGIES MS OFFICE

• DEXIA DCL Treasury dealing room
  Jan 2012 - Jan 2012

  “Front requirement review” commando mission Senior Business Analyst
  
  Context of the project: DEXIA bank dismantling
  Achievements: Review and consolidate Business requirements from Finance department and Treasury dealing room (Cash & Liquidity Management and Long Term Funding) in a very short deadline (dismantling end of the Dexia group)
  
  Document review, Optimisation, priority and reinforcement of Business requirements on BASMATI (data ware house), Reconsolidation of business requirement from Finance and Treasury, Delivery of new requirements for legal reporting SCP BNB (bank liquidity)
  Client Frédéric Guillemot - Head of Transversal & Harmonization Projects - Strategy, Portfolios and Capital Markets at Dexia

  TECHNICAL ENVIRONMENT MS OFFICE

• Senior IT Analyst and Production support

  aujourd'hui

  Context: Maintenance of exchange Platform Mercury / Business Data Processing
  Achievements: redesign of data exchange flow monitoring tool SIMONV2, Support level I on the exchange Platform and data flows plus BAU on thinkFolio (evening check)
  
  Team: PMO, Analyst x2, BNPP-IP developers x2, Giscours developers (Romania)x3
  
  Project Mercury - Exchange Platform / Business Data Processing - Mercury is an internal tool in Ab initio, Oracle 11G, MQ queue, .NET for all applications of BNPP-IP group),
  
  Set-up, monitor and maintain flow parameters (more 1500 semi - flows in all environments), Set-up CFT (by Formal form) for Alfred Berg, CamGestion, Italian desks
  Deployed.dml delivered from MOA team, take in charge the publication release upgrade
  Designed and delivered the Alerting tool allowing that a customer receives an email when the publication is not received
  
  Tested the web service and the data offering by the Cache of Mercuy, Ab-Initio external component for filtering the data of one publication in .CSV based on Jurisdiction column, File data compressioning, Restore the whole database Mercury INT after an error from DBA
  Run various sessions in $U (Restarting the system for example)
  
  Complete redesign of the flows publication monitoring including new data model, user management, Track down and locate all files coming in and out of Mercury (multiple level views, top to bottom approach), Analysis tool (provide all details on message failures, file routing details (retrieve the contents of an .xml file or location of a .csv file), Segregate information according the user profile (based on applications catalog)
  
  Designed and tested the reconciliation tool allowing the check a publication in .CSV from the output bridge Mercury and data stocked in the publisher database.

  TECHNICAL ENVIRONMENT/METHODOLOGIES Database MERCURY, MS SQL Server Management Studio 2007 (Microsoft) user, MS SQL, PLSQL Server (Oracle 11G) 2007 user, MQ queue, $U Univiewer, Ab-Initio EME, FileZilla 3.14.1, Clarity,Geade, ReleaseMe, DoReMe, Monitoring SIMON exchange platform – ThinkFolio Markit v 2.149.3721.0 (May16), VBA, .NET, Webservice WSDL