SENIOR CONSULTANT
BUSINESS AREA
Banking (Mortgage & Loans)
Insurance
Telecom (Technical, Order Management System)
International and Governmental Institutions, Public Services
Clearing and settlements, trade, custody
Tourism (Portugal , Belgium)
Public Health, Medical & Veterinary
Construction
SKILLS
Account and Project Management
Mainly based on PMI principles and best practices
Audit
Projects co-ordination, planning and reporting
Risk and issue management
Resource planning
Cost assessment and budget control
Quality and Test management (system, integration and UAT)
Change management
Training plan , documentation and lecture
Analyst-Programmer
Project and Scope analysis
Data analysis, conversion or transfer
Application design and modelling
Technical expertise and database design
Documentation
Mainly based on experience
Team building and leading
Functional analysis
Technical analysis
Benchmarking
Knowledge management
Technical documentation
Technical skills
• Databases and languages Oracle, Adabas, Natural, COBOL, DB2, CICS, MySQL, Informix, Lotus Notes,
VB, Powerbuilder, Access, Paradox,
• Windows skills Project, Office, Money
• Internet – Intranet PHP, CSS, XML, Dreamweaver MX, SGML, XHTML.WEB2.0
• Operating systems BS2000, Unix, VMS/CICS, Solaris, NT.
• Data warehouse
• Hardware knowledge IBM, Sun, Compaq, Siemens, Amdahl, PC, TI.
Methods and tool cases
UML (Rational rose, Modelmaker)
MERISE
Structured languages
AMC designer
Ab Initio
LANGUAGES
French mother tongue
English fluent (12 months Illinois, 6 months California)
Dutch fluent (48 months work in Flanders)
German fluent (second mother tongue)
Spanish conversational (16 months immersion Dominican Republic)
Luxembourg fluent
PERSONAL DETAILS
Married, living in Frankfurt am Main , Germany.
Luxemburg. Born in Brussels the 23rd of October 1952
Lived and worked in Los Angeles (USA), Europe (Benelux, Germany, France, UK and Spain), Dominican republic.
EDUCATION
2005-6 WEB 2.0, Ajax
2003 AB INITIO
2002 Dreamweaver MX, MySQL, PHP
1997 Bank Kredits (Kredietbank), BBL
1995 SGML, HTML
1995 Lotus Notes: Administration, design & programming
1995 AMC design & Powerbuilder – Powersoft
1994 Oracle
1990 Management (Telinfo)
1985 Specialisation in database management and 4GL in Los Angeles USA
1981 Analyst-Programmer degree, COBOL, BULL Brussels
Other Project management, Accountancy, Communication
PROFESSIONAL EXPERIENCES
Consultant by [MALTEM France]
Kredietbank (Brussels - Belgium)
02/2007- 04/2007 CHANGE MANAGEMENT – MUREX
• MUREX CC – Investment management software.
• Service Centre : Change management, Call centre, Incident management
• Definition of workflow
Consultant by [TCS Germany]
DWS/Deutsche Bank (Frankfurt am Main - Germany)
07/2006- 01/2007 QUALITY ASSURANCE MANAGEMENT – YEAR ACCOUNT STATEMENT
Test cases definition for the new taxes rules.
• IAM2000 – Interface application for FUNDS management (4.500 Modules)
• Requirements management (High quality applications deployment)
• Test plan (Priority), Test cases design, UAT, IAT, Test follow-up.
• SilkTest [Segue], industry’s leading functional and regression testing product for enterprise applications.
• TeDIM – internal tool developed to create, manage and run Test cases.
Consultant by [SIV Belgium]
11/2004- 03/2006 Website - ONLINE QUOTATION SYSTEM
• Design, implementation of online quotation system(WEB 2.0)
• User receives instant price after completing different template.
• Database design
10/2003- 10/2004 Website - PORTUGAL-VIRTUAL, BELGIUM VIRTUAL
• Tourism
• Hotel and reservation Database design.(PHP/MySql)
• Reservation Follow-up.
Consultant by [ALTRAN Europe , 11/1996-08/2003]
BELGACOM – Brussels OMS-PILA Conversion Manager (4.800 M/D)
(06/2001-08/2003) ORDER MANAGEMENT SYSTEM (OMS). AMDOCS.Technical and financial Customer databases conversion towards a unique database (Oracle)
28 months Project .
The OMS conversion is a real complex process.
(See complete description below)
BBL - Brussels
(11/1999-05/2001) PROJECT FOR MORTGAGE LOAN SYSTEMS (MLS)
• Co-ordinator of the Technical Team (5).
• Design of the database (Oracle): Product Model, Dossier, Events management.
• Functional Analysis Guidelines.
• Technical Project management.
- Oracle & Java Naming & structures white book
- Functional analysis > Technical Analysis
- Technical design
- Developer management
GIB - Brussels
(02/1999-11/1999) PROJECT FOR CUSTOMER RELATIONSHIPS MANAGEMENT
• Definition of the customer relationships policy
• Assistant to a Member of the steering committee for the company re-organisation
• Creation of a tool for contract management and edition
- Functional analysis
- Technical design
- Developer management
• Financial flow management
PROJECT FOR PRODUCTION AUTOMATION
• Project management
• Team management
• Command Post Tool
ING-BBL - Brussels
(06/1999 – 07/1999) PROJECT : “ CONDITIONS BANQUIERS EN FCO”
• Coaching of the DP Europe Consultant on:
- The migration of de Bankers Conditions from BCOR to FCO
- The integration of new conditions for foreign products, bonds…
- The design of the new database
- The functional analysis
ASSUBEL - Brussels
(08/1999 - 02/2000) PROJECT: “IT DEPARTMENT ACCOUNTING SYSTEM”
• Coaching of the DP Europe Consultant on:
- Functional Analysis
- Project management
EUROCLEAR - Brussels
(10/1997-02/1999) YEAR 2000 PROJECT
The Y2K project consisted in following the status of 14 000 items. The scope was divided in 14 groups. Creation of a database dedicated to the Y2K project management: Control of the status of the IBM development squad (60 people) and coordination of the testing team (40 analysts, 80 testers)
Clearing, settlements, custody, customer.
KREDIETBANK.
(11/1996-09/1997) INTEGRATION OF BANK VAN ROESELAERE, CREDITS
• Analysis of the BVR credit products
• Analysis of the KB credit products
• Integration of the two models
EUROPEAN MARKET Luxembourg
(05/1996-11/1996) IT PRODUCTION DEPARTMENT
• Official Newspapers production
• Team management
• Integrated Document Management
SILIDUR (Construction) Account manager
(01/1995-05/1996)
• 13 months project.
• Preparation of specifications
• Technical assistance in the evaluation of calls for tender.
• BPR of the IT department (Germany, Great Britain, Netherlands, France and Belgium).
• Global network & Internet integration: 10 sites, 41 stations & 86 remote-7 programmers: 3 in Liège, 4 in Koln – Migration Banian & Novell upward to Sun, Lotus Notes, NT, SQL, Internet, intra-net.
• Redesign of the database.
W.B.B. (stock exchange) senior consultant – Düsseldorf
(03/1994-12/1994)
• Organisation and computerization of the client’s portfolio in the international Division. Database design.
TELINFO – « European Institutions, Public & International Administrations »
(01/1989-02/1994)
- Eurocontrol
• Report of the technical data analysis of the European air traffic control.
• Creation of the database.
- EC Luxembourg
• Project manager of the EC « Steel » database (DG IX).
• Worldwide statistics program to collect the steel production data’s.
• Quotas calculation for EC commissionnaires.
G.I.M. – Brussels, France (Gestion & Informatique Médicales). Self-made company
(01/1985-12/1988)
• Creation & commercialisation of a complete veterinarian clinic management package. Multi-post & multi-task system.
• 20 % Market Coverage (Large Clinic). Prospecting. Promotion: Publicity and Fair (Paris, Toulouse).
• Bookkeeping, inventory, clinical and financial customer follow-up, statistics by doctor, acts, etc.
• As a specialist, courses of database management and 4GL in Belgium, France, Spain and Germany.
• February 2007 : 20 years anniversary of a customer in France
Sopama – Groupe « S » - Brussels
(02/1981-12/1984)
• From Analyst / programmer to customer responsible, I started my career in Sopama. They developed a complete construction management system.
• Knowing bookkeeping and Dutch, I took the lead of the customer department of the project. We had more than 70 customers, as well as in the North (Dutch speaking) as in the southern part of Belgium (French), companies from 5 people to 5.000 (projects in the whole world).
• The different modules: from bookkeeping to People management, HR, tariff, inventory, etc.
BELGACOM mission
Belgacom has started 4 years ago a general restructuration of the company (BEST = Belgacom e-Strategic Transformation: 5.000 people were put in pre-pension), and on the ITG side a new Order Management System (OMS)(sold by AMDOCS) is implemented. One of the most important and strategic projects of OMS, is the conversion of more then 250.000.000 of records from the legacy to the new system. Another issue is the Data Quality of the legacy system: project CASPER (Cleaning).
• Analysis of the Legacy systems:
Conversion scope definition: The process will only convert the PILA products: PSTN, ISDN, LLU and ADSL. It represents about 120 different products families
Interview of the managers responsible of the different databases to convert: The purpose is to define how each of the 3900 products is documented in the 9 different databases as well as the Customer databases (name, address, zip, etc).
Definition of all the conversion impacted items from the different databases, so that all information’s are in the new OMS system.
Data warehouse used to define and generate statistics on the families and products to convert.
• Analysis of the new OMS database:
Exhaustive study of the OMS Database structure, Product catalogue and the Product catalogue engine.
Mapping: For each feature, structure, information of the OMS, an equivalent had to be determined in the legacy. (If not, Conversion rules had to be defined)
• Product Catalogue (PC) study: The PC is a database (part of OMS), where the structures of the products sold by Belgacom are stored. The conversion process uses these structures to convert the existing data into the new OMS data.
• Conversion strategy development
Constraints study
o Huge amount to convert: 8.000.000 phone numbers + 56.000.000 of associated products (composed each of 26 technical or financial records) + customer information’s + installations addresses
o Impossible to convert during open hours or to convert in one weekend session: Belgium was divided in 8 regions.
The Roll-out strategy defined:
• Pre-Pilot
• Pilot
• 6 regions
Each conversion of a region was defined in an 11 days timeframe. The major conversion part is done off-line during the 9 first days: from Thursday till the next Friday. The last part: Activation, delta minus and delta plus is done from Friday till Monday morning.
o The Belgacom customer’s bill may not change...
Strategy presentation to Belgacom management
Technical needs definition: tools and environments (sizing, tuning, extracts)
o ITT tests
o UAT tests
o Dress rehearsal, Pre-Pilot and Pilot
Functional and technical analysis of the conversion process
o Process definition: flows, documentation for every product family
o Statistics module: Data Input, Throughput, Output, and Rejection. Timing, tuning, performance, enhancements
o Business rules definition of the product families in the Legacy system
o Conversion rules strategy definition for the asynchrony information’s between the different legacy databases. Only one fourth was well documented in all the systems at the start of the project
o Study and rejection management (99% data quality goal)
o Pending orders (PO) Management: the PO are rejected and followed until conclusion, so that they go through the conversion process again
o Tests planning with all the legacies, billing and OMS.
Development team management (5 people)
o Task assignment
o Input development
o Mapping develop
o Rejection analysis
CASPER (cleaning of the Legacy database 6 people)
o Defects study
o Cleaning batches
Follow-up meetings
