Rudy Delouya

AXA Group Solutions (Senior Consultant)
Design and development of global BI solutions with high amount of data (billions of rows). Business requirements definition.
Training of French and Spanish developers on the group reporting platform (GRP).
Technical environment : Microsoft SQL Server 2008 R2 (database engine, SSIS, SSAS, SSRS), Microsoft Sharepoint 2010 with Excel Services, Microsoft PowerPivot.

Hollister (Senior Consultant, Business Planning)
Definition of business needs.
Design of SAP BPC entry schedules and reports to meet business needs, development of custom SSIS packages for high-speed inter-application data transfer/aggregation, Application Modeling.
Training of internal resources on BPC/SSIS.
Technical environment : SAP BPC 5.1, MS SQL Server 2005 (Database, SSIS, SSAS), Source data from SAP BW and CO-PA.

AXA GIE (Project Manager, PerformancePoint Implementation) :
Responsible for the implementation of PerformancePoint Server 2007 Analytics
From defining the business needs to impact analysis and cube optimization, to training users
Environment: SQL Server 2005 Analysis Services, Microsoft SharePoint 2007, Microsoft PerformancePoint Server 2007
Duration : 5 months, team : 2 persons

Expanscience Laboratories (Project Manager, Datawarehouse Implementation) :
Business Analysis, Conception and Modeling, Implementation and Development of a whole Datawarehouse
Data integration from the main ERP and all foreign subsidiaries, creation of many analysis cubes and reports
Developments: from ETL packages to automatic Reports delivery. Users training on ProClarity
Environment: MOVEX, Exact 2000, SQL Server 2005 (SSIS, SSAS, SSRS), ProClarity
Duration: 8+ months, team: 4 persons

Altana Pharma / Nycomed (Scorecarding):
Implementation of Microsoft Office Business Scorecard Manager 2005
Scorecards development for medical visitors and regional managers
Implementation of security/data restriction
Users training on MOBSM 2005 and ProClarity
Environment: MOBSM 2005, MS SharePoint, MS SQL Server Analysis Services 2005, ProClarity
Duration: 1 month, team: 3 persons

AXA France (commercial reporting) :
Mass reporting (10,000+ users)
Dashboards, and reports conception, development, publication, scheduling
Migration from Microstrategy to Hyperion
Reports and SQL optimization
Developed scripts for mass report generation (push)
Knowledge of the Hyperion Performance Suite (Intelligence Server, Designer, Dashboard Builder)
Troubleshoot reporting issues
Environment: HPS (formerly Brio, currently Oracle/Hyperion System 9 Interactive Reporting), Oracle 9I
Duration: 18 months, team: 20 persons

Aéroports de Paris (operational and financial reporting):
Supported the Controlling Directors
Consulted on reports and dashboards conception/optimization
Reported to President and Vice-President
Environment: HPS, Oracle 9i/SAP-CO, Hyperion Essbase
Duration: 1 month, no team

Chanel Corp. (feasibility study):
Study on whether using Hyperion System9 BI+ and Hyperion System 9 Applications+ with SAP-BW and Oracle data
Duration: 1 month, team: 3 persons

Developed web customer support access in PHP
Delivered customized drivers and updates to each client
Updated internet site graphics and ergonomics

Developed internal tools in VBA
Created the company’s main product commercial presentation used by sales team
Re-established and updated intranet