Aurelien BERTEAU

En résumé

Entreprises

• Caisse Primaire des Assurances Maladies - Analyste BI

  Paris 2013 - maintenant Client : CNAM (Health, public sector)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  Setting up an infocentre to CPAM (Healthcare Insurance Office) Managers, centralizing local CPAM offices dashboards and national comparatives.
  --------------------------------------------------------------------------------------------------------------------
  [Technologies : Oracle, BO XI R3, QaaWS (Web Services), Dashboards 4.0]
  --------------------------------------------------------------------------------------------------------------------
  * Developing dashboards (via Dashboards 4.0) receiving real-time data via web services, integrating local CPAM offices french map
  * Defining Business Objects users access rights, depending on their position and their visibility perimeter (local, national or both)

• IBM Global Services - Business Analyst

  Bois-Colombes Cedex 2012 - 2012 Ho Chi Minh, Vietnam
  --------------------------------------------------------------------------------------------------------------------
  Client : Geodis (Transportation & Logistics)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  Updating the IBM Supply Chain Management product to provide Geodis users a relevant tool, according to their needs.
  [Technologies : SQL, DB2, AS/400, RPG4, Adelia]
  --------------------------------------------------------------------------------------------------------------------
  * Collecting & Analyzing customers' needs, Defining the perimeter in question, Estimating the cost/scope and Creating a planning for each demand
  * Writing Functional and Detailed Specifications, then Functional Tests
  * Coordinating with DBA about the DB2 Database Updates and SQL Optimization

• Geodis - Technical Project Manager

  Levallois-Perret 2010 - 2012 Paris, France
  --------------------------------------------------------------------------------------------------------------------
  Client : Geodis (Transportation & Logistics)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  1/ Creating a datamart gathering candidatures/hirings inside HR Division. 2/ Creating a tool to steer Project Management
  [Technologies : SQL Server 2008, Oracle, BODI 11.7, BO XI R2]
  --------------------------------------------------------------------------------------------------------------------
  * Participating in technical workshops in order to analyze and define the functional needs
  * Developing & updating Data Integration flows then online portal Reports
  * Assigned to Help Desk once reports are officially accessible to all customers

• Geodis -  Business Intelligence Analyst

  Levallois-Perret 2009 - 2011 Paris, France
  --------------------------------------------------------------------------------------------------------------------
  Client : Geodis (Transportation & Logistics)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  Setting up a reporting bundle to permit to Geodis operationals follow up IBM activity.
  Technologies : SQL Server 2008, Oracle, BO DI, BO XI R2, Xcelsius
  --------------------------------------------------------------------------------------------------------------------
  * Developing reports (BO XI R2) and dashboards (Xcelsius), to follow up shipment flows
  * Creation and updating the universe (BO Designer)
  * Responsible for the relationship with international users in Hungary, Germany and Spain

• SQLi - Business Objects Developer

  Levallois-Perret 2009 - 2009 St Denis, France
  --------------------------------------------------------------------------------------------------------------------
  Client : H.A.S. (Public Health sector)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  Replication of operational system and setting up an applicative infocenter.
  [Technologies : MySQL, Talend, BO XI 3.1]
  --------------------------------------------------------------------------------------------------------------------
  * Creating specific rules to load the datawarehouse with an ODS step (Talend Open Studio 3.0)
  * Developing BO XI 3.1 reports, to follow doctors affiliation into a public informatics program
  * Updating the universes (BO Designer)

• Business Intelligence Consultant - Ingénieur d'études (Étude de faisabilité)

  2008 - 2009 La Défense, Paris, France
  --------------------------------------------------------------------------------------------------------------------
  Client : Lyxor A.M. Business Units (Finance, Asset Management)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  Feasibility study to a datawarehouse creation for a Societe Generale subsidary.
  [Technologies : Oracle, Talend, BO XI R2]
  --------------------------------------------------------------------------------------------------------------------
  * Responsible for the collection, analysis and support of the business user requirements
  * Responsible for evaluating and selecting the BI tools
  * Prototyping and setting up of a datawarehouse (Talend 3.0, Business Objects XI R3)

• SG Consumer Finance (SGCF) - Business Objects Developer (Internship)

  2008 - 2008 Rueil-Malmaison 92500, France
  --------------------------------------------------------------------------------------------------------------------
  Clients : SGCF & PSA Peugeot-Citroën (Automobile Industry)
  --------------------------------------------------------------------------------------------------------------------
  --------------------------------------------------------------------------------------------------------------------
  Deployment and setting up an infocenter to manage data exchange between PSA & SG.
  [Technologies : Cobol, Oracle, Informatica, BO XI R2]
  --------------------------------------------------------------------------------------------------------------------
  * Updating the universes (BO Designer)
  * Developing reports (BO XI R2) under specifications, to follow up the vehicles stocks and
  outstanding amounts
  * Responsible for the relationship with international users set up in Croatia, Slovenia

Formations

• Ecole Internationale Des Sciences Du Traitement De L'Information

  Cergy 2006 - 2009

• Ecole Internationale Des Sciences Du Traitement De L'Information EISTI

  Cergy 2006 - 2009 Option : Business Intelligence

Réseau

• Christophe AUCLAIR

• Christopher BIGOZZI

• David JAYASEELAN

• Deborah CLAVELL

• Gaelle DAVID

• Kamel AMIROU

• Nicolas GALLAND

• Olivier JEANNEAU

• Philippe PAROT

• Yves COINTRELLE