Function Senior BI Project Manager / Senior BI Consultant
Sector Tyre industry
octobre 2007 - janvier 2008
Project Total Fleet Management - Tyre management reporting system.
Project Description and Activity Enhancement of the Tyre management reporting system :
• Gap analysis between existing reporting system and business requirements.
• Assessment of the workload for the implementation of change requests.
• Follow-up of the project workload and deliverables.
• Training and Coaching of the ETL consultants for the integration of changes requests into the ETL process.
• Restructuring of the metadata infrastructure into classical multilayer star schemas levels.
• Coordination between the report owner and the report writer to decrease the number of reports (merge existing reports).
• Definition of standards for the definition of new reports
• Setting up of an external multi-lingual ad-hoc application to manage the reporting interface.
• Definition of a customized business oriented user guide.
• Coordination with the DBA, Network and Infrastructure department to resolve report performance issues.
Function Senior BI Project Manager / Senior BI Consultant
Sector Electronics retail industryProject Business Intelligence Competency Center
octobre 2007 - aujourd'hui
Project Description and Activity Business Intelligence Competency Center:
• Assessing Business Process and Data Solution responsible in strategic choice of BI tools and architecture
• Provision of methodological and technical consulting for BICC set up
• Coordination of project actors (IT responsible and business owner) for the definition of the project scope and project feasibility.
• Project planning and management of decisional lifecycle implementation process (time schedule, bottleneck, deliverables etc…)
• Upgrade of the target architecture and Translation of business requirements into a technical architecture design.
• Coaching of the modelers for the enhancement of existing metadata models and the integration of new modules.
• Coaching and support of the report writers for complex graphs and dashboards creation.
• Drafting step-by-step user guide report for end users.
Project Description and Activity
Enhancing visual report formatting and inter system data navigation to increase analytical abilities, fit business requirement and speed up decision making.
Financials
Project Description and Activity
• Audit of the decisional process and all ongoing BI projects.
• Analysis on implementation methodology lacks.
• Proposition of improvement solutions and Definition of the target architecture.
• Coordination between projects actors and coaching of the internal staff about strategic move and technical solutions for BI’s ROI
Project Performance Management & SOX Compliance Report Implementation
Project Description and Activity
• Definition of the Metadata extension for Sales, Purchasing, Inventory, Production and Human Resources modules.
• Based on Business requirements, proposition of operational changes in the source systems (ex: BOM Explosion)
• Design of reports, olaps and dashboards to fulfill SOX compliance requirements.
• Training and Coaching of the internal staff for the implementation of the changes.
• Design of the security system.
Function Senior BI Project Manager / BI Deployment & Transition Architect
Sector Pharmaceutical
juillet 2006 - septembre 2006
Project Description and Activity
• Definition of the strategy for the BI Deployment
• Design of the BI Deployment & Transition Architecture
• Assessment of the workload.
• Definition of the project deliverables and project risks
Applications
Project Description and Activity
Data Warehouse infrastructure migration :
• Design of a Data Warehouse and a BI infrastructure.
• Automation of the Data Warehouse lifecycle development.
• Definition of standards for the BI maintenance.
• Coordination of the project actors and coaching of the infrastructure teams for the Data Warehouse maintenance plan, ongoing support and future evolutions
Function Senior BI Consultant for Security and Architecture
Sector Banking
novembre 2005 - aujourd'hui
Project Data Warehouse implementation
Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay, Acxess Manager
Project Description and Activity
• Setting up of a common LDAP security module for Cognos Powerplay and Reportnet using Sun Java System Directory Server.
• Proposition of different servers architecture deployment solutions for web tier, data tier and application tier, based on Cognos series 7 and Reportnet applications.
Function Senior BI Architect / Project Manager
Sector Wireless Network
mars 2005 - septembre 2005
Cognos Powerplay, SQL SERVER 2000, DTS
Project Description and Activity
• Collection of business requirements for invoice, purchase, inventory and operation modules.
• Definition of the project scope and assessment of the workload.
• Definition of the project deliverables.
• Definition and Follow-up of the Data Warehouse project plan.
• Design of the technical architecture on SQL Server database.
• Design of the ETL process and definition of standards for the development of the ETL process.
• Training and Coaching of the internal staff for the development of the ETL process using Microsoft DTS tool.
• Design of the Meta data model with Cognos Framework Manager tool.
• Creation of the Cubes with Cognos Transformer.
• Definition of the security strategy and implementation of the security layer with Sun Java System Directory Server.
• Deployment cubes and Meta data for reporting through Reportnet Portal.
Project Description and Activity The purpose of this project consisted in finding gaps in data-flow between the legacy system and new ERP applications by elaborating report comparison between and across both systems :
• Gathering comparison requirements from legacy Data Mart and creating Meta Data for ERP modules.
• Designing technical architecture on Oracle database.
• Defining ETL process for the programmer and coaching.
• Meta data modeling with Cognos Impromptu.
• Report comparison creation between applications.
1 Experience Summary
• Project Management / coaching and Trainer expertise
- Large experiences within Team Technical Leading, Coordination between
projects actors and Coaching.
- Management of a BICC during 3 years for ECI TELECOM.
- Trainer expertise
• Technical expertise :
Over 10 years of extensive Data Warehouse and Business Intelligence experience implementing as senior technical architect:
- Set up of Business Intelligence Competency Centers
- Migration Projects ( Cognos 7 -> Cognos 8 )
- Full lifecycle Datawarehouse/Data Mart projects
- High level competences in architecture, design
- Large expertise in technical integration and security aspects ( SSO, profile
definition, authorization)
- Expertise in Meta Data modeling
- Large expertise within Cognos tools, Oracle and Microsoft Databases .
• Source system expertise :
Olivier has operated within different functional areas: order management, Sales &Marketing, CRM, inventory, procurement, accounting, financial services, quality assurance and infrastructure management over a large scale of source system as SAP , Oracle Application , Siebel , BPCS, Baan, SmartStream Financials, Reuters Kondor Plus and JD Edwards
• Business expertise :
Olivier is able to understand the business dynamics and translating business performance management needs into specific performance indicators and supporting technical solutions.
• Proven experience by project achievements :
- Successfully implemented dimensional lifecycle projects by project
management, business requirement definition, technical architecture design and
deployment for CERAGON and FRUTAROM, involving Ralph Kimball
methodology, Cognos Reportnet, Powerplay Web, DTS and SQL Server
technologies.
- Successfully implemented gap analysis project for ECI TELECOM.
- Design of a high level business intelligence architecture and security
architecture for Société Générale Bank & Trust.
- Successfully implemented meta data models and multidimensional cubes for
more than 14 customers
2 Technical Skills
Programming Languages
T/SQL
Oracle PL/SQL
SQL
UNIX script
Development Tools
Cognos Impromptu (Version 5,6,7)
Cognos Powerplay (Version 5.2,6,7)
Cognos Transformer (Version 5.2,6,7)
Cognos Access manager (Version 6,7)
Cognos ReportNet (Version 1.0 , 1.1)
Business Intelligence Cognos 8 (Version 8.1,8.2)
Cognos Framework manager (Version 1.0,1.1,8.1,8.2)
Microsoft DTS
SQL Navigator
TOAD
Toptier data navigation
ERWin
Source System
SAP
SIEBEL CRM
Oracle Application
BPCS
Baan
SmartStream Financials
Reuters Kondor Plus
JD Edwards
Database
SQL Server 2000
Oracle 8i Enterprise Edition
Oracle 9i
DB/400
Informix
Sybase
Functional Area
Datawarehouse Modeling
Method / Technique
Data Modeling
Operating Systems
MS Windows OS
Sun Solaris 2.X
