Expertise / BI & Database

BI and Database

Database and Decision Support Solutions

This section specialises in the management and processing of structured data: operational/decision support.

Expertise

  • Relational database design
  • Database administration
  • Performance analysis and optimisation
  • Data quality management
  • Data transformation and  migration
  • Decision solutions design
  • Reporting

Specific solutions and skills

  • Products
  • Databases: Oracle, Microsoft SQL Server, IBM DB2, MySQL, Sybase, MS Access, MS Olap
  • ETL : Informatica, IBM DataStage, Microsoft SSIS, Oracle Data Integrator (Sunopsis), Talend
  • Analysis and reporting: Business Object (BO), Cognos, Microsoft SSRS et SSAS, Oracle Report, Crystal Report, Actuate, Jasper, Birt, Pentaho
  • Design : Oracle Designer, Win Design, PowerDesigner, Enterprise Architect, IBM Rational
  • Miscellaneous tools: Toad, Informatica Data Quality (Athanor), Optim
  • Methods
  • Modelling methods (Merise, UML)
  • Optimisation and analysis methodology for implementation plans
  • Dimensional modelling
  • Technologies
  • SQL, PL-SQL, Transact-SQL
  • OLAP, ROLAP, multidimensional hypercubes