Menu

Florent SEBILEAU

NAPIER

En résumé

Mes compétences :
Business Objects
Oracle 10G
Mantis
Microsoft SQL Server
Informatica PowerCenter
XML
PowerBuilder
BusinessObjects Data Integrator
UNIX
Sybase
SQL
ETL
BusinessObjects Web Intelligence
Teradata
Talend
PRINCE2 methodology
Microsoft SQL Server 2008
Informix
DB2
BusinessObjects XI-R 2 et XI3
Microsoft Windows NT
Informatica Analytics Package > Informatica PowerC
PostgreSQL
Oracle
project planning
Project Management
Pentaho Data Integrator
Informatica
BusinessObjects XI-R 2 and XI3
Business Objects XI-R 2

Entreprises

  • Hawke's Bay District Health Board - Business Intelligence Analyst/Developer

    2017 - maintenant - Support the delivery of relevant KPIs, including MOH targets, internal targets, quality and safety indicators, service plan and project KPIs, population health indicators and other HB health sector measures.
    - Support the Business Intelligence team produce high quality reporting by providing an effective information management service.
    - Champion the presentation of data analytics.
    - Development of Business Objects universes and other semantic layers to provide an information management platform to enable reporting.
    - Deliver quality data warehouse design solutions, ETL build and management for delivery of consolidated data warehouse information into the HBDHB environment.
  • CAPGEMINI - Business Intelligence Consultant

    SURESNES 2008 - 2016 2 years Business Intelligence Expert - SIMMAD (DEFENCE)
    iAéro data warehouse fed with consolidated data from French military aircraft: logistics, maintenance, flight data among
    other operational information. Due to rapid data growth in its iAéro data warehouse and a strong reporting development
    demand, SIMMAD required a complete review of its Business Intelligence technical architecture and processes.

    * Health assessment of current database modelling, data flows & reporting solutions ;
    * Improving data modelling, ETL workflows and reports ;
    * Migration to a multi-server architecture to deliver more maintainability, flexibility, scalability and data quality capability
    * Migration of BusinessObjects XI3 to BI4 & PostgreSQL to SQLserver 2012 ;
    * Development and Release process implementation ;
    * Workflow monitoring reporting development
    * BusinessObjects & ETL expertise

    Technical Environment: SQLserver, PostgreSQL, BusinessObjects BI4 & XI3, Pentaho Data Integrator, Mantis

    3 years Business Intelligence Project Manager - AGENCE DE SERVICE ET DE PAIEMENT (FRENCH ADMINISTRATION)
    ASP is a government entity responsible for the payment (40 billion EUR p.a.) and follow-up of financial transactions made to
    sustain numerous projects in Agriculture, Employment & Professional training.

    * Coordinating and managing Capgemini consultant team (6 consultants)
    * Business Intelligence Project Management in a multi-project environment
    * Conception, development and release follow-up and review
    * Quality insurance process implementation ;
    * Participation in Steering Committee
    Technical Environment: Oracle 10g, BusinessObjects XI3, Informatica PowerCenter, Talend OS, $U, Mantis

    6 months Business Intelligence Project Manager - LVMH (LUXURY GOODS)
    The division PCIS (Perfume & Cosmetic Information and Services) required dashboards for the operational monitoring of the
    On Time / In Full logistics indicators.

    * Management of the Capgemini development team (4 consultants)
    * Project inception (business & technical scope), project and quote management
    * Data warehouse modelling & data flow conception ;
    * Implementation Quality Insurance processes with HP-QC to improve the delivery quality and the release follow-up
    Technical Environment: Oracle, Datastage, Cognos, SAP, HP - Quality Center, Mantis

    12 months Data warehouse Team Leader - CDiscount (E-BUSINESS)
    CDiscount is the leader in French E-Business (turnover: 1.5 billion EUR p.a.)
    * Data warehouse team management (9 developers) ;
    * Project management in a multi-project, dynamic and competitive environment
    * SDLC implementation to comply with CDiscount release procedures
    * Data warehouse modelling and technical conception ;
    * BusinessObjects expertise
    Technical Environment: MS SQL server, Talend, Datastage, BusinessObjects XI-R2 and XI3, Mantis

    6 months Business Intelligence Expert - EDF (ENERGY)
    EDF needed to implement new KPI in the data warehouse to monitor the security and safety of their nuclear plants.
    * Data flow technical conception ;
    * Universe and report development with BusinessObjects ;
    * Informatica & BusinessObjects expertise ;
    * Planning and development coordination
    Technical Environment: Informatica PowerCenter, Business Objects XI-R2, Oracle 10g

    Other CapGemini consulting activities:
    Drafting applications in response to various calls for tender with the CapGemini team, including the successful renewal of
    the Agence de Service et de Paiements contract in 2009, 2011 & 2013 (300k EUR p.a.)
  • LANDSBANKI - ETL Expert

    2008 - 2008 The project aims were to create and populate the Exposure Data Mart (EDM) which will provide the input for risk exposures to the Basel 2 project.

    • Design and implementation of enhanced product DataMart populated from 15 source systems
    • Design and development of new counterparty DataMart using the standardized Common Customer View
    • Provide technical guidance on Data Integrator

    Technical Environment: Business Objects Data Integrator XI, Oracle, SQLserver
  • INFOSYS AUSTRALIA - Business Intelligence Architect

    2003 - 2007 1 month Business Intelligence Architect - GAPBUSTER (MARKETING)
    To maintain its leadership in a very competitive market, GAPbuster needed a complete business processes and underlying
    technology overhaul. The objective of the Infosys team was to conduct a process and application landscape assessment to
    identify enhancement opportunities enabled by outsourcing and technology enhancement initiatives.

    * Health assessment of current reporting, multidimensional and mining solutions
    * Assess operational sources and data quality in the various data sources
    * Prepare high-level functional architecture and high-level gap analysis to help define the strategic roadmap
    * Recommendation for the implementation of a centralised data warehouse supported by Microsoft Business Intelligence
    toolset to deliver more maintainability, flexibility, scalability, data quality and integrity capability
    * Deliver a high level architecture document including a detailed planning (Development cost: $600kAUD)
    Technical Environment: SQL server, Microsoft Business Intelligence Office 2005, PowerBuilder

    2 months Business Intelligence Consultant - NATIONAL AUSTRALIA BANK (BANK)
    The CSCM (Customer Strategy & Cross Marketing) project aim was to provide an integrated approach to sales opportunity
    management through 4 key dashboards designed for local, regional and state sales leaders and relationship bankers
    throughout Australia: Growth & Run Off Report, Portfolio Performance Forecast & Pipeline, Financial Performance and
    Portfolio Insight.

    * Perform audit of data requirements and associated data sources for the required portals
    * Identify tools of choice and create prototypes using Business Objects XI (WebI, Crystal Excelsius)
    * Perform the usual unit, system and UAT testing and rectify problems
    Technical Environment: Windows NT, Teradata, Business Objects XI

    2.5 years ETL Expert - NATIONAL AUSTRALIA BANK (BANK)
    IMS (Institutional & Market Services) needed a new data warehouse (Wholesale Data Warehouse Enhancement) to migrate
    all 45 interfaces feeding the current warehouse to flow into the new XML Data Store, allow reporting on revenue generated
    from the Lending, Transactional Money Markets & Foreign Exchange lines of business, and feed the GDW (Global Data
    Warehouse) Credit Risk Engine which will provide the input for risk exposures to the Basel 2 project.

    * Develop WDW ETL jobs (~300) to agreed specifications ;
    * Elaborate system requirements and design for each system
    * Execute unit, integration and system testing and document results
    * Contribute to the review and redesign of implementation processes to deliver improved WDW team productivity ;
    * Provide technical advice on Data Integrator
    Technical Environment: Business Objects Data Integrator 6.5 & XI, XML, MQSeries, Autosys, SQLServer, Sybase
  • DP EUROPE - GROUPE ALTRAN - IT Consultant

    2000 - 2003 18 months Business Analyst & Technical Program Coordinator - FAT (WORKPLACE ACCIDENT ADMINISTRATION)

    Technical coordination of the largest project at the FAT (“Claims & Attestations”) in the context of the implementation of the Network LEA (Liaison Electronique secteur Assurance). The FAT needed to build a reliable system based on a complex platform (S/390-VM/VSE, CICS, NT, Lotus Notes, MQSeries, MQSI) to enable reception, control, storage, treatment and automatic emission of electronic messages covering various activities from policies to national security numbers and claims.

    • Development of business requirements and solution design for the workshop “Claims & Attestations”
    • Development supervision and test follow-up
    • Architecture prototyping (system process specification, database modelling, workflow standardization)
    • Development of business requirements of Document Management & Data Glossary system (Lotus Notes)
    • Technical program coordinator: Insurance companies (AXA, AGF, Fortis AG), Social Security public services.
    • Risk management, project planning and status reporting

    Technical Environment: Windows NT, S/390-VM/VSE, CICS, DB2, Lotus Notes, MQSeries Integrator, Cobol, XML

    12 months Project Management - CAAMI (PUBLIC HEALTH CARE)

    Project Leading and Business/System analysis of a large scale system to enable reception, treatment and automatic emission of electronic messages concerning hospitalisations and insurability data within the 12 regional offices of the CAAMI (for the CareNet network of health insurers & hospitals in Belgium).

    • Development of business requirements and solution design
    • Process reengineering of the application Hospitalisation to fit the new CareNet environment
    • Follow up, guide and coordinate the development team across the whole SDLC
    • Technical supervisor: system administrators, external consultants, service providers (gateway)
    • Project coordination: end users, administrative personnel, doctors

    Technical Environment: Windows NT, Informix, SQL, Visual Basic, COM Components, TCP-IP
  • DP EUROPE - ALTRAN (CONSULTING) - Business Analyst & Technical Program Coordinator

    2000 - 2003 Technical coordination of the largest project at the FAT (``Claims & Attestations)'' in the context of the implementation of the
    Network LEA (Liaison Electronique secteur Assurance). The FAT needed to build a reliable system based on a complex
    platform (S/390-VM/VSE, CICS, NT, Lotus Notes, MQSeries, MQSI) to enable reception, control, storage, treatment and
    automatic emission of electronic messages covering various activities from policies to national security numbers and claims.

    * Development of business requirements and solution design for the workshop ``Claims & Attestations'' ;
    * Development supervision and test follow-up ;
    * Architecture prototyping (system process specification, database modelling, workflow standardization)
    * Development of business requirements of Document Management & Data Glossary system (Lotus Notes)
    * Technical program coordinator: Insurance companies (AXA, AGF, Fortis AG), Social Security public services. ;
    * Risk management, project planning and status reporting
    Technical Environment: Windows NT, S/390-VM/VSE, CICS, DB2, Lotus Notes, MQSeries Integrator, Cobol, XML

    12 months Project Management - CAAMI (PUBLIC HEALTH CARE)
    Project Leading and Business/System analysis of a large scale system to enable reception, treatment and automatic
    emission of electronic messages concerning hospitalisations and insurability data within the 12 regional offices of the
    CAAMI (for the CareNet network of health insurers & hospitals in Belgium).

    * Development of business requirements and solution design
    * Process reengineering of the application Hospitalisation to fit the new CareNet environment
    * Follow up, guide and coordinate the development team across the whole SDLC
    * Technical supervisor: system administrators, external consultants, service providers (gateway) ;
    * Project coordination: end users, administrative personnel, doctors
    Technical Environment: Windows NT, Informix, SQL, Visual Basic, COM Components, TCP-IP
  • SOCIÉTÉ GÉNÉRALE - Data warehouse Administrator

    PARIS 1998 - 2000 * Data warehouse and Business Objects administration and maintenance ;
    * Migration of BO v3 to BO v4 then of BO v4 to BO v5 ;
    * Administration and maintenance of SQUAD (Simple Query for Users to Access MIE Data) management: Migration
    process of the data of the central system of the bank (MIE) to a dynamic database (Sybase).
    * Development of reports and applications aiming at the management and the dealing room
    Technical Environment: UNIX, NT, Sybase 11, SQL, PowerBuilder 6.0, BusinessObjects 3, 4, & 5, BusinessQuery 5
  • DASSAULT AVIATION - Analyst Programmer

    Saint-Cloud 1997 - 1998 Participation in the development of the SAPACE military simulator analysing the survivability of a fighter entering into hostile
    territory.
    Technical Environment: Unix, Silicon Graphic, RS6000, Fortran, GL, Motif

Formations

Réseau