Menu

Aurelien BERTEAU

Paris

En résumé

Spécialiste du Décisionnel, 5 ans d'expériences sur les technologies Business Objects et Qlikview particulièrement. Expérience dans la Collecte, Traitement et Organisation des données, ainsi que la mise en place d'infocentres permettant aux utilisateurs de visionner les données consolidées de l'entreprise indispensables aux managers pour l'aide à la prise de décision.

Actuellement à l'écoute du marché dans la région Asie-Pacifique.

Mes compétences :
Business Objects

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

Réseau

Annuaire des membres :