Jean - DBA ACCESS

from 1985
08/05 – 02/07 ING Belgium ODS / BI Technical Architect & Developer

ODS architecture, design, development and software release management
Service management & operations definition and documentation
Integration into existing DWH architecture and infrastructure
Oracle Warehouse Builder development and deployment
Developer coaching
Database tuning
Skills: banking and finance, Oracle Warehouse Builder 10.1, DWH Oracle programming (SQL, PL/SQL, warehousing, distributed), Data analysis, Oracle-based DWH / ODS architecture and design, Sybase PowerDesigner 11 (DataArchitect). Serena Dimensions. Mercury TestDirector.



02/05 – 08/05 Mobistar DWH DBA / ETL developer

Team management
Datamart architecture, design, development and, troubleshooting
Very Large Database management (nearly tera, more than 109 rows in tables)
Oracle Warehouse Builder development
OWB deployment
Oracle performance tuning and monitoring
Skills: Oracle DBA, Oracle Warehouse Builder 9ir2, DWH Oracle programming (SQL, PL/SQL, warehousing, distributed), Data analysis, DWH architecture



04/04 – 01/05 Carlson Wagonlit Travel Europe DWH DBA / eBI developer

Business Intelligence at CWT – World Wide Web Reporting with Cognos
User requirement analysis and change request management
Oracle 9i administration for DWHing (development and integration DBs)
Oracle migration, tuning and monitoring
Cognos development and deployment
Skills: Oracle DBA, Oracle Designer, DWH Oracle programming (SQL, PL/SQL, warehousing, distributed), Data analysis, Cognos BI 7.3



01/04 – 03/04 Puilaetco (part-time) Data Warehouse consultant

- Audit of current system
- Elaboration of scenarios for data warehousing and business intelligence
- DWH Architecture
- Project definition
- Data Warehouse internal marketing
- Requirement collection
- Audit of existing decisional reporting



10/03 – 10/03 Lombard Assurance International (Lux) Data Warehouse consultant

- Audit of current system
- Elaboration of scenarios for data warehousing and business intelligence
- Data Warehousing Project definition
- Data Warehouse internal marketing
- Requirement collection
- Audit of existing decisional reporting



03/03 – 03/04 Amsit/ING (part-time) Analytic Application Designer

- Development of an analytic application for Service Desk performance measurement (Pergrine, Avaya)
- IT helpdesk and service desk modelling
- BI Architecture
- Project definition
- Data Warehousing
- Requirement collection
- Design and implementation of an analytic application using BusinessObjects Application Foundation
Skills: DWH architecture, DWH design, Oracle programming, communication, analysis, BusinessObjects, BusinessObjects WebIntelligence, BusinessObjects Application Foundation (AF)



01/03 – 02/03 Isabel (banking software) Data Warehouse consultant

- Audit of current system
- Elaboration of scenarios for data warehousing and business intelligence
- BI Architecture
- Project definition
- Data Warehouse internal marketing
- Requirement collection
- Auditing



04/02 – 12/02 Mobistar Data Warehouse Architect

- DWH and Data Staging Principal Architect
- SLA definition
- Standards for development and operations
- Data and ETL Quality management
- Team coaching
- Database management
- Data Staging Design and operations (ETL)

Skills: DWH architecture, DWH design, communication, analysis, Oracle Warehouse Builder 9i, Oracle Designer 6i




10/01 – 03/02 ACIST eBI/DWH Pre-Sales

eBI project definition for several large accounts
Several commercial offers in the field:
- Staffing
- Architecture
- SLA definition
- Standards for development and operations
- Quality management
- Project management.

Several short ORACLE 7 and ORACLE 8 tuning missions for customers

Skills: DWH architecture, communication, analysis, …



05/01 – 09/01 Merck Sharp Dohme Belgium eBI/DWH Auditor

eBI project audit at the request of EMEA Information Services director
Give recommendations for increasing performance and competence of EMEA DSS/infocentre:
- Staffing
- Architecture
- SLA definition
- Standards for development and operations
- Quality management
- Project management.

Skills: DWH architecture, communication, analysis, …



08/00 – 04/01 Carlson Wagonlit Travel France eBI Project Leader

eBI project management
Business Intelligence at CWT – EMEA Web Reporting with Cognos
Design and implementation of a data mart for Sales, Finance, Customer Care and major customers
Preparation for Data Warehouse requirements
Implementation of Web Intelligent Reporting
Skills: Cognos BI Suite (Web PowerPlay server + DecisionStream + Impromptu) 7.3, Oracle 8 programming (SQL, PL/SQL).



05/00 – 07/00 Swiss Life Group Belgium Business Intelligence consultant

Business Intelligence at Swiss Life / Zelia
Design and implementation of a datamart for finance
Preparation for Data Warehouse requirements
Design of reports for management
Skills: Oracle programming (SQL, PL/SQL), Cognos BI Tools (PowerPlay + Impromptu) 7.3



10/99 – 04/00 Landbouw krediet/Credit agricole Oracle consultant

Oracle7 Performance and Tuning
As Oracle expert, I had to review the design of both new OLTP (500 users client/server) and DWH/OLAP databases. I had to identify performance problems. After that, I had to provide recommendations for better retrieval, updating and loading operations. Finally, I provided recommendations for a secure evolution of the databases: volume growth, connectivity expansion, DB upgrades, …
Skills: Data Analysis, Oracle7 DBA, SQL tuning, Oracle7 performance and tuning, Multi-Threaded Server, DWH design, replication option



08/99 – 02/00 Mercedes Belgium (part-time) Oracle and cognos consultant

Infocenter and data warehousing
As Oracle 7 and Oracle8 advisor, I had to review the design of the several reporting databases; I had to spot performance problems. After that, I had to provide recommendations for better retrieval and loading operations. Finally, I provided recommendations for a secure evolution of the reporting system: volume growth, connectivity expansion, DB upgrades, …
Skills: Data Analysis, Oracle8 DBA, Oracle8 server programming, Oracle 7 and oracle8 monitoring and tuning, Cognos Impromptu and Powerplay



02/99 - 07/99 Curver SA (part-time) IT integration and co-ordination

After it has been purchased by Canadian EURO UNITED motherhouse, CURVER has to define and manage its own IT infrastructure. As there is no IT competence in house, ACIST provides a set of services and accomplishes several missions to achieve objectives defined together with CURVER. In this context, the activities of Jean are:
 Definition of the IT architecture. As CURVER has sites in France, UK, Spain and Belgium, international networking is included in the architecture.
 Project management
 User education and coaching
 Co-ordination of several missions: networking study, system administration, ORACLE DBA, EIS
 Assistance for implementation of an ERP CINCOM - CONTROL and a GL package CODA
Skills: Project management, business analysis and reporting, Data Analysis, Oracle DBA
Business Objects, integration of technical skills



10/98 - 05/99 Mobistar SA Team leader

Data Warehouse analyst and Infocenter team leader.
Relations with DW users, specification refinement, business analysis.
Oracle advisor.
Skills: Project management, rapid change management, business analysis and reporting, Data Analysis, Data Warehousing techniques
Tools: Oracle server programming (packages, triggers, ...) with PL/SQL, SQL*Plus programming
Business Objects



02/98 - 09/98 Glaverbel Project leader

Data Warehouse project leader.
DW client tool evaluation and selection.
Relations with DW users, specification refinement, business analysis.
DW system architect.
Tools support.
Skills: Business analysis, Sales and Commercial reporting, Data Analysis, Data Warehousing techniques
Tools: Oracle server programming (packages, triggers, ...) with PL/SQL, SQL*Plus programming, Oracle tuning, Oracle Designer 2000 rel. 1
Cognos Impromptu and Powerplay



11/97 - 01/98 Groupe S (social secretary) Data Analyst

Re-engineering and validation of the enterprise data model.

Skills: Personnel management, Data Analysis, ER modelling



09/97 - 10/97 Croix Jaune et Blanche Analyst programmer

ORACLE Belgium.
Croix Jaune et Blanche (national organisation of nurses providing a wide range of cares to people at home).
Oracle Forms 4.5 programming. Automatic generation from Designer 2000 (tables, views, modules) to Forms 4.5.

Tools: Oracle Forms 4.5, Oracle Designer 2000 rel. 1, Oracle Report 2, PL/SQL Programming (triggers and stored procedures)



03/97 - 08/97 SOGESMA Data Warehouse Analyst

SOGESMA (Trafic stores in Wallonie, Brussels, France, Luxembourg and Spain).
Assistant for the specification, conception and implementation of a Data Warehouse/OLAP system for distribution/logistics services. Jean has worked with a French consultant (EDS) specialised in distribution/logistics and an American consultant (EDS) in Data Warehousing and OLAP. This project was a success.

Skills: Distribution/logistics, Data Analysis, Data Warehousing techniques, Oracle DBA (coping with huge volumes).
Tools: Oracle server programming (packages, triggers, ...) with PL/SQL, SQL*Plus programming, oracle tuning, S-Designor, Oracle Express.



01/96 - 02/97 VDAB (Vlaamse Dienst Arbeidsbemideling en beroepsopleiding) Analyst

EDS.
Analysis and programming of an optimised interface for Oracle database report printing. PostScript files interpretation. Oracle development and maintenance.

Skills: Dutch environment.
Tools: Pro*C, C++, Windows programming, Oracle 2000 designer, Oracle 2000 developer, Forms 4.5, Oracle server programming (packages, triggers, ...) with PL/SQL, SQL*Plus programming, oracle tuning.




07/95 - 12/95 BBL bank Analyst programmer

Visual Basic client development of a client/server application for incoming invoices processing. This application is Workflow oriented. Invoice data and invoice images (pages) are treated as a whole in a global document management system.

Skills: Object oriented Analysis, Windows debugging, database design, Oracle queries tuning.
Tools: Visual Basic, ODBC, ORACLE 6, ORACLE 7.



09/94 - 08/95 CCE commission - directorate XX (financial control) Analyst programmer

CGI Systems
Client (windows, MS-Access 2.0) / server (ATT,UNIX,ORACLE 7) application analysis, development and running-in. Prototyping with users.
 Windows hypertext help file generation and maintenance
 Text of law analysis, organisation of these texts in hypertexts
 Writing of standards for developing Ms-Access client applications with Oracle, and standards for constructing and maintaining windows help systems.
Skills: ORACLE 7 database design (sql*Plus, PL*SQL), UNIX V.4, Ms-access 2.0 + ODBC + Microsoft, LanManager, Microsoft help compiler



10/93 - 08/94 Canal+ TVCF Oracle advisor

Canal+ (Belgian private TV network)
 Technical advisor for starting distributed ORACLE applications. These applications are used for managing client information, subscriptions, and accounts. Jean had to write and correct pieces of programs (SQL*Forms, PRO*C, SQL*Plus and PL/SQL scripts) to increase performance and response times on huge volumes (tables containing between 10 and 30 mio occurrences) and on distributed ORACLE databases.
 Installation of ACCESS on PC's as client of an ORACLE server to
 Produce nice reports for the financial department,
 Produce documentation upon the financial database, using the ORACLE catalogue itself.
 Use of CASE*DICTIONARY to document data analysis and design.
Skills: Object oriented analysis.
ORACLE (distributed) database design, ORACLE tuning (tablespaces, clusters, rollback, ...) and performance optimisation
Tools: ORACLE 6 tools (Forms 3.0, SQL*Menu 5.0, SQL*NET, PL*SQL...).
ACCESS as client for ORACLE server, CASE*DICTIONARY, UNIX V.4 (ksh shell scripts), C and PRO*C language.



10/92-09/93 Commission of European communities (GD IX) Data Analyst

ORDINA (Antwerp).
The project aimed at documenting the contents of the SYSPER personnel database. It was a kind of data reverse engineering processing. The result is a data dictionary and a relational database containing a thesaurus, showing relations between administrative rules and the contents of SYSPER, and describing the interfaces with other information systems. Users have validated this work.
 Jean has defined the structure of this database in terms of chapters, objets, description items, cross-references, validation rules, ...
 The relational database was rapidly designed using ACCESS (prototyping and incremental properties extension). Some objects were Excel spreadsheets (informal validation rules). Long descriptions were under WordPerfect.
The study might be used as the description of the existing data and procedures, to design a new information system for the personnel management.
Skills: European community environment, personnel management, interview techniques, documentation systems
Tools: Microsoft ACCESS, EXCEL, WordPerfect



07/92-09/92 Law Courts Brussels Analyst programmer

ACSE (associated consultants and software engineers).
As programmer, Jean has developed a translator of SGML tagged descriptions into wordperfect texts. This translator was later integrated in a larger application comprising a database, windows user-interface and text generator.
Tools: SGML, C language



07/91-06/92 Belgian Foreign Trade Office Analyst programmer

UNISYS Belgium
Jean had was to refine the functional specifications into modules (SQL*Forms, and C) and a relational database schema (nearly 100 tables) to be implemented on the ORACLE database management system. He has developed some modules, almost in PRO*C and a few in SQL*Forms 3.0, part of a complex SQL query and delivery system integrated in a huge database/mail user-friendly application.
Tools: UNIX - C language - ORACLE : SQL*PLUS 6.0, PRO*C, PL/SQL 1.0, SQL*Forms 3.0, SQL*Load - PROGRESS 4GL version 6, WordPerfect on UNIX



01/90-06/91 Cap Gemini Sesa Belgium Analyst programmer (employee)

Jean began as analyst on a starting turn-key project, and three months later he really was surprised to become project manager at the demand of the clients Unisys and OBCE/BDBH. He continued to write functional specifications in parallel. Unfortunately, for several reasons, Cap Gemini was ask to nullify its contract with Unisys Corp. Unisys proposed him to continue on the project at the OBCE/BDBH, and the only way was to work as subcontractor (free-lance). He actively contributed to the choice of a 4GL environment (ORACLE - PROGRESS - UNIFACE).
Skills: Good knowledge of public markets contracts - Projet management.
Tools: Design tools EXCELERATOR and SDW - Planning tools SuperProject and PMW.



01/88-12/89 University of Namur Researcher (employee)

As researcher in the field of artificial intelligence, Jean had to refine a methodology for the design of Prolog logic programs. Jean had to find out techniques for the transformation of logic specifications, and finally to build an interactive tool giving advise for the transformation of these specifications. He wrote an article published in 89 in the United States (North American Conference on Logic Programming).
Skills: Logic Programming - English - Software engineering - KEE knowledge base
Tools: UNIX - SUN STATION - C language - Prolog language - SUN user interface (Xwindows-like) - SYBASE.



04/87-12/87 Tractebel Holding Analyst programmer (employee)

Jean had to report on the state of the art of software engineering methodologies and tools. This report gave advice for the choice of a design tool and a database manager system for development of future applications.
He also wrote technical documentation for some existing applications in financial and treasury services, and studied an advise-giving tool for financial experts.
Skills: MERISE, NIAM and IDA methodologies - Large accounting and treasury system - RDB database system



07/85-03/87 Biological laboratory (Nivelles) Analyst programmer (employee)

Jean had to design a new information system for the administrative tasks such as accounting, treasury, mailing system. It was on a Digital Vax-VMS system. Later he has has migrated some applications on UNIX.
Skills: methodology IDA.
Tools: VAX/VMS - VAX Pascal language, UNIX - C language.