CV/Mission Data Warehouse freelance

Aperçu d'expériences de Pascal,
freelance DATA WAREHOUSE résidant dans ?

Architect, Data & Infrastructure Governance
Euler-Hermes (Allianz)
mars 2008 - aujourd'hui
Responsible for Architecture of 3rd iteration of the DWH described below. Including Claims & Collection, Sales, Marketing.
Architect in charge of setting up the platform to support deployment worldwide of new subject area.

BI Architect
Fortis Retail Bank
décembre 2006 - mars 2008
Business Intelligence Architect. Design of functional and Application Architecture to support a new cross-borders, CRM data management and BI platform.
Manage and organize Prove of Concept sessions with leading vendors.
Help PM to organize activities related to project initiation (Business Case, PID, WBS, Schedule, resources planning…)
Data architecture, definition of Data architecture methodology.
Meta Data, sub-project definition, meta data architecture.
Security & compliance. Risk identification of compliance & legal impact on the architecture (data and application)
Design Process & Method for IS deployment

Service Architect
ING Bank
septembre 2006 - décembre 2006
Architecture of Service Management
Design of Change Management process and CMDB to support cross borders activities within a DWh team

Project Manager
Volvo Trucks ab
janvier 2006 - août 2006
Volvo Trucks ab
Redesign of some reports for Parts division
Automation Extraction process from a DW to SAP, implementation of a search pattern engine to detect anomaly
Study of BI deployment for Volvo Logistic (A4D)

Project Manager / Data warehouse Advisor
Belgian Post
juillet 2005 - aujourd'hui
Design, create and manage a Branch profitability model for the overall group.
Project Definition, budget management, staffing
Complex financial project (Frango, Oracle Apps GL, A/P, A/R, Self Build apps,…)
Get buy-in on SAS within the group
Participation on early Data warehouse architecture definition (as-is & to-be definition for 2007)
Manage migration from BO (various version 5, 6 Webi) to 6.1.3 and design / create a management platform.
Tools set: Business Objects 6.1, Oracle Warehouse Builder 9i, Oracle 9i, Linux on Sun system, Power AMC 10, ITIL, CMM, J2EE (jkit), MSProject

Datawarehouse Architect and Project Manager / Methodologist
Euler-Hermes (Allianz)
novembre 2001 - juin 2005
Creation of a team structure and methodology to start a first data warehouse for a global – cross domain data warehouse in a major credit insurance company.
Project Definition, budget appraisal. Value chain definition, initial scoping, project phasing.
Interviews leadership and consolidation, interviewees challenge, consolidation meeting.
Functional analysis, Functional & Physical Design of a data warehouse. The first iteration is based on risk and information domains.
Second iteration: functional enhancement of the data warehouse to cover commercial, contract production and premium assessment/calculation. Internationalisation and localization.
Global roll-out, Business Oriented data marts design and development.
Meta data management and data quality management. Rejects handling.
Optimisation (technical and functional)
Tools set: Cognos (Decision Stream, Power Play, Impromptu), IBM UDB 7.3, IBM UDB 8.1, PowerAMC (6, 10), EMC² DMX2000 (BCV technology), PowerPC/AIX 4 & 5 Unix scripting and admin.

Senior Data Warehouse Consultant
Pricewaterhouse Coopers Management Consultants
novembre 1999 - août 2001
Astrazeneca (Global Pharmacy)
Functional analysis of the integration of various business units across the world into a unified financial reporting framework.
Design and building of a data warehouse to cover the financial data flows coming from 153 countries and delivered to a financial consolidation system.
Collection and design of KPI for the reporting system.

Dolphin Telecom (UK Telco)
Belgian taxes administration and legal requirements analysis to implement a telco operator in Belgium.
Legacies analysis in France, UK and Germany
Building of a master plan in order to adapt / reuse Data and IT infrastructure in order to deliver quick-win with regards of legal prescriptions.
Multi language support consideration.

Sunrise (Switzerland Telco)
Legacy business process analysis and review.
Design of a fast-track plan to deliver a quick-win and self-sale prototype in order to give business intelligence functionalities to business users.
Technical and data architecture analysis and assessment to ensure the coherency and stability of the platform for the coming years.
Business users’ interviews and consolidation.
Establishment of a ROI methodology in order to valuate the financial impact of the introduction of a BI system.
Staffing and workgroup design.
Definition of a phasing / iterated project plan to build a DWH.
Logical and physical modelling of a conformed DWH.

Datawarehouse Consultant
Valoris Belgium
1998 - 1999
Quality Manager
System Manager

EXXON (Global Oil Company)
Analysis and Design of 2nd and 3rd iteration of a marketing / Cost oriented data mart.
Data extract from SAP and storage within an UDB based DM.
Building and feeding of Rolap cubes (Oracle Express)
Project management (planning, quality, budget, staffing, check points …)

Mobistar (Belgium Telco)
Knowledge management, user training and functional assessment of a CDR (Call detail records) based DWH.
Design and optimisation of VLDB (Oracle 7.1.4, 2.5 Tb)
Optimisation and functional enhancement of BO universe in order to improve response time of the DWH.
Mobile network re-engineering based on spatial dataset located within the DWH as a “prove of concept” / efficiency of the DWH structure.

Toyota Motor Europe
Vehicles parts and components. Data sources analysis in order to design a feeding interface for a European market data warehouse.
Data quality interface design and development in order to implement a data cleansing engine.

Project Leader
Integrated Network Solutions
1997 - 1998
CMI (Belgium Mechanical industry)
Design and building of 500 users based network in order to integrate the company value chain through Lotus Notes Knowledge sharing / Workflow, Exchange with SAP/R3
Project management including budgeting, staffing, tools definition/assessment, prototyping, follow-up and project steering.

Sonaca (Belgium Aeronautic)
Supply chain integration from SAP to external sub-contractors.
Information Systems re-engineering in order to integrate the back office system (based on Microsoft / Citrix TS) with the ERP (SAP/R3) system
Extra Net / Application Server deployement
SAP/R3 over EMC² optimisation (Oracle based rDBMS)

System Engineer, DBA
Selligent (ex Aramis Software)Novartis (Europe Pharmacy)
1993 - 1997
Design and implementation of CRM/SFA system within 8 countries across Europe.
Real-time and Offline replication of data from user’s system into a European DWH.
Modelling of an ODS in order to integrate localised database structure
Data marts functional and physical modelling.

Solvay (Global Chemical)
Design and implementation of CRM based solution for any representative around the world.
Project management – scoping, phasing, budget control, execution follow-up, steering.

Omron (Global Electronics)
Design and implementation of CRM based solution at the European level.
Project management – scoping, phasing, budget control, execution follow-up, steering.
Integration with BO and design of a template Universe including KPI and conformed dimensions for sales management level reporting