-
Kompass
- Senior Database Administrator / Architect
Bruxelles
2012 - maintenant
Kompass.com
---------------------
- Migration of the Development, Test and Production databases from the head office datacenter to the local servers.
- Administration (upgrade/patching, backup/recovery, performance watch/tuning…) of the migrated Oracle databases.
- Data model changes, production releases and support to the developers’ community through queries and procedures rewrite/tuning.
Environment : Oracle 11g, Linux, Oracle Enterprise manager, Oracle rman, Toad, Oracle RAC
New Kompass.com
----------------------------
- Migration of the Development, Test and Production databases from the local servers (Oracle/Linux) to SQL Server 2012 on the Microsoft Cloud environment AZURE.
- Administration of the windows server virtual machines and the SQL Server databases on the Azure Cloud.
- Data model changes, production releases and support to the developers’ community through queries and procedures rewrite/tuning.
Environment : The Microsoft AZURE Cloud, Microsoft SQL Server 2012, Windows Server 2012, Microsoft SQL Server Management Studio, AllwaysON High Availability and disaster recovery solution.
-
Lapeyre
- Senior Database Administrator / Architect
Courbevoie
2011 - 2012
Project: P2
Migration of the 40+ business applications to the central group datacenter, the size of the databases involved varied from for few gigabytes to several terabytes.
Database Migration:
- Migration planning and organization of the different application databases
- Database setup and configuration on the target datacentre servers
- Database migration from the current RAC servers to the target datacentre servers
Qualification:
- Data preparation for the applications qualifications on the target datacentre servers
- Database and applications performance tuning on the target servers
Administration:
- Day to day database administration of the current and the datacentre databases.
- Support to the different applications development teams
Environment : Oracle 10g/11g, RMAN, Oracle Datapump, Oracle Enterprise Manager, Linux, AIX, Toad.
-
Marsh
- Senior Database Administrator / Architect
Puteaux
2011 - 2011
- Design of an insurance data warehouse to feed a Hyperion environment for the Business Intelligence and the production reporting.
- Design and development of interfaces between CLEVA (an insurance ERP running on an Oracle database) and the core financial system EUROSYS (running on a main frame).
- Day to day administration and support of the CLEVA interfaces
Environment : Oracle 10g/11g, PL/SQL, CLEVA, Linux, Windows 2003, Toad.
-
Quod Financial
- Database Team Manager / Architect
Puteaux
2009 - 2011
Manager of the Database Team Responsible for
- Design of the Application’s multi-vendor Databases architecture (Oracle and SQL Server)
- Production Databases administration and performance tuning (internal and on client sites)
- Databases maintenance and evolutions design and developments (Oracle and SQL Server)
- Implementation of RAC for client’s Oracle database platform
- Implementation of Dataguard for client’s Oracle database platform
- Implementation of Transactional peer-to-peer replication for client’s SQL Server platform
- Clients and developers third line support
Environment: Oracle 10g/11g, SQL Server 2005/2008, RAC, Dataguard, PL/SQL, Unix, Linux, Windows 2003, Case Studio, Toad,.
-
Pitney Bowes
- Senior Database Administrator / Architect
Saint Denis
2008 - 2008
- Administration of the development, test and production databases
- Oracle Setup and patching of existing and new servers (Linux, Solaris and AIX)
- Design, creation and deployment of the databases
- Deployment of an Oracle Enterprise grid control to monitor the different databases
- Databases monitoring and optimisation (both server side and application side)
- Design and development of production control and business intelligence applications and Reports
Environment: Oracle 9i/10g, PL/SQL, AIX, Solaris, Linux, Toad, Insider
-
IBM France
- Database Team Manager / Architect
Bois-Colombes
2008 - 2008
Project: Laratransfo
Re-design of the invoicing system in order to facilitate the maintainability and to meet the new client’s performance requirements. In fact the number of users of the new invoicing module will grow from 2500 to 10000+ in a short period (1 year) due to the client’s exceptional growth.
- Design and validation of the different solutions with the Validity Design team, the clients database administration team and infrastructure team.
- Edition of the Design Architecture documents and the detailed Specifications document used by the development team.
- Lead of the development (performed in a client subsidiary company in DUBAI).
- Code review and performance tuning.
Environment: Oracle 10g, PL/SQL, Forms, Reports, AIX, Toad, UML,
-
ESSEC Business School
- Senior Database Administrator / Architect
CERGY
2006 - 2007
Project: Banner STC / Alumni
An Oracle based ERP used for the management of the university’s different resources (students, Alumni, fund raising, contributors etc.)
- Design and lead development of interfaces between STC Banner and third party applications. Including:
- Data loading of online payments (students subscriptions and fund raising)
- Data loading of students information from newly acquired institutes
- Generation of the students and Alumni paper directory information
- Generation of the subscription lists used by the mass mailing department.
- Performance tuning of the database and the applications.
- Administration of the Banner databases and lead of the technical support to the development community.
Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, UNIX (Linux)
-
Accenture
- Database Team Manager / Architect
Paris
2004 - 2006
End Client : CARREFOUR
Project: Mandala
Multi-terabytes datawarehouse of the core business data (sales, stocks, receptions.) used by the business intelligence tools Microstrategy and Business Objects
- Administration of the development and acceptance databases.
- Migration from a hash 8 to a hash 16 Oracle 10R2 database on HP Itanium and deployment of a parallel run between the old and new databases model in order to evaluate the performance improvements.
- Design and development of interfaces to load the data warehouse from the daily received countries flat files.
Project: RSR
A datawarehouse centralizing the general expenses data of the business units of 25 countries, the data is extracted from the different PeopleSoft modules (PO, AP, AR and AM). The RSR datawarehouse is used by the business intelligence platforms (Microstrategy, Business Objects and SQR) for analytical reporting
- Lead development of the ETL modules
- Performance tuning of the RSR architecture including:
- Partitioning and summery materialized views
- Redesign of the extractions modules to improve the data loading.
- Administration of the RSR development and acceptance databases.
Project: PAT (Analytical Procurement Tool)
A star datawarehouse used by Hyperion Essbase to provide different reports and dashboards to facilitate the negotiations with the products suppliers worldwide. The data is extracted from the PeopleSoft modules and reorganized into a star model database.
- Development team leader responsible for:
- Project planning, team stuffing and the development day to day management
(Workload estimation and dispatch)
- Design of the PAT star model to meet the functional specifications.
- Design and performance tuning of the ETL procedures.
- Administration of the development and acceptance databases.
Environment: Oracle 10g, PL/SQL, Toad, AIX, Shell script, PeopleSoft, Precise
-
UNC Finance
- Database Team Manager / Architect
2002 - 2003
- Technical manager of the development team (4 developer/DBA)
- Design of financial calculators used by the loan/mortgages applications
- Design of an application to manage the client’s management database.
- Administration of the client’s and the mortgages databases.
Environment: Oracle 9i, PL/SQL, Forms, Java, UNIX, Toad
-
Groupe ETAM
- Database Team Manager / Architect
Clichy
2001 - 2002
- Technical manager of the core team (3 developers, 2 DBA). The core team was responsible for the development and the maintenance of the main business database applications including Sales, Pricing, Stock, Suppliers and Shops replenishment.
- Development of different modules of the core system (pricing and currency conversions)
- Development of modules of the overnight batch system responsible for the sales and stocks data load from the shops to the central database
- Database administration and applications support
Environment: Oracle 8i, PL/SQL, UNIX, Shell Script, Pro*C, Toad
-
Aviva
- Senior Oracle Developer
BOIS COLOMBES
2000 - 2001
Project: medical claim system
- Development of different modules of the new medical claim system
- Development of different interfaces between the medical claim system and the clients and suppliers
modules.
Environment: Oracle 8i, PL/SQL, Forms, Reports, UNIX
-
Nestor Healthcare Group PLC
- Database Team Manager / Architect
1998 - 2000
- Management of the interfaces development team (5 Developers, 1 DBA) responsible for the development of different interfaces between the agencies databases, the payroll system and the finance databases.
- Management of the operational team (1 developer, 2 DBA, 2 operators) responsible for the daily data delivery from the agencies to the head-office central database.
- Design and development of different reports for the finance department (Accruals, Commissions, missing invoices etc).
- Design and development of a helpdesk application used to fix the most common agencies databases problems
Environment: Oracle 7/8i, PL/SQL, Forms, Reports, Agresso, Toad
-
Deutsche bank
- Senior Oracle Developer
Paris
1996 - 1998
Project: Redevelopment of the Reuters Assets data feed interfaces system from a C application on an ICL mainframe to a C/Oracle application on UNIX.
- Design and development of different interfaces between Reuters Assets data feed and the Morgan Grenfell databases, the row data was processed through a complex set of financial rules and used to populate the different databases of the company core system.
Environment: UNIX, Windows NT, Oracle 7, Pro*C, SQL, PL/SQL
-
BBC News
- Test Manager
Londres
1995 - 1996
Project: The BBC Payroll System
- Management of the test team (5 peoples)
- Design of the test cases and scripts for the system testing and the user acceptance
- Data preparation for the volume testing.
- Management of the issues list and bug fixing allocation to developers
Environment: Windows, Access, Progress, UNIX
-
IFG
- Oracle Team Leader / Developer
Paris
1992 - 1995
- Technical manager of the development team (4 developers)
- Audit of the IT system with recommendations to improve efficiency and cost-effectiveness.
- Development of interfaces between the invoicing, the payroll and the financial modules.
- Design of “PROPAYE” a payroll system for the freelance teachers, in addition to the payroll calculations the system provide automatic interfacing with the financial module on VAX/VMS and the Oracle invoicing module.
Environment: PC/Windows, VAX/VMS, Oracle, PL/SQL, Turbo C, Windev
-
Aerospatiale
- Developer
1990 - 1992
Project: SET for AUTOCAD (Part of the European space shuttle project ‘Hermes’)
SET (Standard Exchange and Transfer) consists of an interface between CAD databases. It is a standard set up by AFNOR to normalise CAD database formats to exchange designs and sketches between different platforms.
- Technical manager of the development team (5 developers and 2 CAD designers)
- Development of the Artificial Intelligence engine of the SET application.
- SET application demonstration at major CAD exhibitions.
Environment: IBM PC/DOS/Windows, LISP, C, AutoCAD Development System
-
Groupe Bull
- Developer
Les Clayes-sous-Bois
1990 - 1990
- Design and development of different of programs to connect cheque readers to electronic cashier used in supermarkets and stores for credit clearance purposes.
Environment: IBM PC/DOS, C, UNIX
-
Groupe testut
- Developer
1988 - 1990
- Technical Manager of the development team (5 developers and 2 hardware technicians).
- General design of the architecture of the application.
- Development of communication drivers to connect a network of electronic scales to PC’s through multi-ports RS 232C (used by the main application)
Environment: IBM PC/DOS, Turbo Pascal, Assembler, PC SOFT Hyper Pack (development tool)
