Mathieu Pignon

Background

About Mathieu Pignon

Validation of the BI sources' data accuracy, improvement in processing time, development of new concepts and datamarts in the data warehouse, coaching in Business Objects XI for Business Analysts, audit for Business Requirements in a new Data Warehouse project. Main aspects of the job: • Optimization in PL/SQL packages for BI, in order to reduce the execution time. • Analysis and development of a way to compute the Interconnect Cost & Revenue of the Traffic. • Creation of a new datamart to analyze the Product Profitability. • Installation a visual tool to control the Data Accuracy of the different datamarts. • Coverage of the migration BOXI Release 2 towards Release 3. • Migration of BO6 reports towards BOXI r3. • Creation of reports Web Intelligence and improvement of the existing reports. • Creation and optimization of universes. • First steps and advanced coaching for Business Objects tools. • Audit Business users to produce the requirements for a new Data Warehouse. Specialties: Data Warehouse, Oracle database 9g, PL/SQL, TOAD, Business Objects tools (Designer, BO XI Web Intelligence and Deski)