Guillaume Jaudouin

o In charge of developing new Cognos content for Financial, Comercial and Logistic areas.
• User Requirements gathering
• Dimensional, Relational and DMR modeling with Cognos 8 Framework Manager
• Oracle datawarehouse modeling
• Advanced report development in Report Studio and Analysis Studio

o Definition of BI Governance
• Defining BI strategy and best practices
• Building of an automated glossary listing current BI metadata
• BI Process optimization and rationalization

o Responsible for the Cognos BI platform across the company
• Training
• Maintenance and optimization
• Problem solving

o Presale activities for Cognos projects (Migrations and Implementations)
o Setting up of DB and BI test servers within the company (SQL Server, Oracle 10 and Cognos)
o Self-training to Business Object XI (Designer, Desktop Intelligence, Web Intelligence)

Altadis project – Madrid (12 months):
o Involvement in 3 different projects for Accounting, Fiscal and Financial areas.
• Development in Cognos 8 (FrameWork Manager, Report Studio, Query Studio) of reports based on SAP BEX Reports.
• Cognos Conexion management (Security, Data Connections, Scheduling …)
• Migration from Cognos 8.1 to Cognos 8.3
• Development in Sap BW Business Explorer (BEX) - Query Designer and Report Designer
• Requirement gathering for the design of new reports


Ludendo project - Paris (6 months):
o Project for Accounting and Financial areas.
• Development in Cognos 7 (Impromptu, PowerPlay)
• Development of an ETL in PL/SQL for an Oracle-based datawarehouse
• Extensive use of Oracle DB for ad hoc querying

o Maintenance of Cognos 7 Series cubes and reports
• Developed Cognos 7 cubes using Transformer, PowerPlay and Impromptu in Spain-based projects. MS SQL 2000 server.
• Investigated and cube optimized to improve end-users' experience
• Investigated possible migration to Reportnet

o Forecasting tool setting up and tuning

o Development in projects within .Net framework (C#.Net)
o Development in VB6