Pascal - Architecte SQL SERVER

March 2008 - Freelance Consultant
DWH Architect, Data & Infrastructure Governance
Euler-Hermes (Allianz)
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.

December 2006 – March 2008 Freelance Consultant
BI Architect
Fortis Retail Bank
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

September 2006 – December 2006 Freelance Consultant
Service Architect
ING Bank
Architecture of Service Management
Design of Change Management process and CMDB to support cross borders activities within a DWh team

January 2006 – Augustus 2006 Freelance Consultant
Project Manager
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)

July 2005 – End 2005 Freelance Consultant
Project Manager / Data warehouse Advisor
Belgian Post
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

November 2001 – June 2005 Freelance Consultant
Datawarehouse Architect and Project Manager / Methodologist
Euler-Hermes (Allianz)
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.

From November 1999 till Augustus 2001 Pricewaterhouse Coopers Management Consultants
Senior Data Warehouse Consultant
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.

From 1998 till 1999 Valoris Belgium
Datawarehouse Consultant
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.

From 1997 till 1998 Integrated Network Solutions
Project Leader
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)

From 1993 till 1997 Selligent (ex Aramis Software)
System Engineer, DBA
Novartis (Europe Pharmacy)
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.