Freelance Oracle : Repérez les savoir-faire qui vous manquent

Aperçu d'expériences d'Olivier,
freelance ORACLE résidant dans ?

Role/Responsibilities
Oracle Solution Architect & Analyst SABAM
décembre 2012 - janvier 2013
Functional analysis & technical specs (Oracle ), Oracle Database Modelling & Implementation.
Application development (Oracle Forms & APEX)

I’m developing several small sized and mid sized projects (from 10 men/days to 60 men/days). All aspects in the project lifecycle are under my responsibility.
I’m also providing third line support for running applications.

Here is a brief description of one of the most exciting project achieved:

My client is a famous company active in the right owner’s payment for musical work, film or anything that requires authorization to be played in Belgium. At the same time, other companies that are active in the same area -but outside Belgium- are providing, on a regular basis, listing of works and payments that need to be paid to Belgian authors. Unfortunately there are sometimes errors that need to be corrected as soon as possible in order to ensure that authors will be paid as quick as possible.
Until now this process was made manually a took lot of time and resources.
My role consist of providing a new tool that resolve those errors automatically.

Role/Responsibilities
Career History
septembre 2012 - aujourd'hui
Ongoing Oracle Solution Architect
& Analyst Confidential
Functional analysis & technical specs (Oracle ), Oracle Database Modelling & Implementation.
Backend & Frontend Web Application development (based on pl/sql technology), Database Administration, Third line support

I joined a team responsible for the development, enhancement and administration of a web oriented Platform. This tool is fully based on Oracle technologies (Oracle database, PL/SQL packages, XML DB, OC4J). This tool can be seen as a big data HUB/Cloud as its goal is, with high level of security, to get, keep, enrich, transfer & provide data (either one of those steps or more of them depending on the type of customer’s contract) through various kind of network protocols (web services, https, ftp, in house secure protocol…). I this context my job consist of developing new components (ETL packages, containers, publishing tools).

Role/Responsibilities
Oracle Solution Architect & Analyst NSI
novembre 2010 - novembre 2011
Functional analysis & technical specs (Oracle & .Net), Oracle Database Modelling & Implementation. Database Administration. Tuning. PL/SQL scripting. Testing.

My customer has developed a brand new application for social housing management in Brussels based on .Net technology and Oracle database. Because the new data model they designed was completely different from the original one, they were facing big troubles when trying to migrate old data into a completely different data model.
As an Oracle expert, I developed a migration tool based on Apex technology as frontend and pl/sql packages, database modeling, implementation and administration to implement the business logic. This application was a kind of ETL tool, but end-user oriented.
Functionnaly, the business focuses on following parts
- Social housing patrimony's management (infrastructure)
- Candidates and Tenants management
- Accounting management
- Techincal management
Technical environment : PowerDesigner 11.1.x, Toad pro 9.x, Oracle Database 9.x/10.x/11gR2, Oracle APEX 4.x on Oracle 11gR2, Oracle Enterprise Manager 11g – Database Control

Role/Responsibilities Oracle Senior Consultant Huxley Associates
janvier 2010 - octobre 2010
Oracle Application analysis, programming & reporting Oracle Database Design

PERSGROEP PUBLISHING KOBBEGEM (BELGIUM) 12 MONTHS

As an Oracle senior consultant, I’ve provided my expertise in developing modules and reports for their sales management application. Project lifecycle focused on following parts:
- Analysis of customer needs
- Translation of business rules into technical specs
- Design and implement database objects
- Design and implement front- end application (Oracle Designer, Oracle forms) and reports (Oracle Reports)
- Design and implement BO universe & BO reports
Technical environment : Oracle Designer, Oracle Forms, Oracle Reports, BusinessObjects XI, Toad pro

Oracle Senior Consultant Role/Responsibilities
Sword Group
décembre 2005 - aujourd'hui
Oracle Application analysis, programming & reporting Oracle Database management (ETL design & implementation) Application support users support.

Oracle Consultant (ETL & BI) CSB consulting Role/Responsibilities
décembre 2001 - décembre 2005
Oracle Application Server Administrator & Application Support Oracle database administrator for Developers.

EUROPEAN COMMISSION (AGRI) BRUSSELS (BELGIUM) 12 MONTHS

As Oracle Application Server Administrator & Application Support, I was in charge of the Oracle Application Server installation, administration, patching & update. It was recently migrated to 10g release 1 (9.0.4).
I was also in charge of supporting web application created with Oracle Developer suite 10g (Forms / Report ) and hosted by the application server
Daily tasks:
• Oracle Application Server Installation/Upgrade/Patching
• Maintain Application Server Repository
• Technical support to the development team

EUROPEAN COMMISSION (ADMIN) BRUSSELS (BELGIUM) 36 MONTHS

As Oracle DBA for developers, I joined a team responsible for the management of the telephony within the European Commission. At first, the task turned around 4 axes:
- Technical support to the users
- Management of the production
- Upgrade/Development of new modules following needs
- Database administration (at developer side)
In a second time, further to the analysis of the existing, a complete revision of the application was asked by the customer. This new version allows, among others, the visualization of certain data on the intranet. For that issue, various solutions were chosen according to the wished type of interface:
- PEREGRINE (SCAuto SDK, JBuilder) for the helpdesk part of the application
- BO Webintelligence and Oracle Report 6i/9i for the reporting part
- Coldfusion mx/dreamweaver mx For the on-line publishing of certain customer’s informations
- Forms 6i/9i for the operational part
- PL/SQL and UNIX scripting for all that concern operational and technical management at Oracle database/Unix level.
Daily tasks:
• Analysis, Programming & Reporting Database management Tuning Testing Documentation Application support.
Technical environment:
Oracle 7.3.4 / Oracle 8.1.x / Oracle 9.2.x Toad OEM, Oracle DBA Studio Oracle Developer/2000 Forms server 6i,9i Report server 6i,9i Oracle 9iDS Oracle Designer/2000,6i,9i Business Objects 5.x, 6.x, Coldfusion mx
Technical environment: Oracle 9.2.0.7 SQL Navigator 4 Oracle Application Server 9i Rel 2 Oracle Application Server 10g Rel 1 Oracle Developer Suite 10g

Oracle Developer Role/Responsibilities
Contraste Europe
août 2001 - novembre 2001
Oracle Application Developer.

I participated in different small and medium sized in-house projects in the Oracle area
One of the most exciting was the realization of a framework intended to configure a data warehouse. I handled the customer part of this framework. It had to be available on the intranet of the company. The development part was made with Forms 6i and turned on an IIS application server.

Technical environment: Oracle Forms, Oracle WebDB, Oracle 7.3/8i, Toad, vi, shell ksh.

December 2000 – August 2001 Oracle developer ONSITE

Role/Responsibilities
Oracle Application Developer Junior DBA database modeler

LEVI STRAUSS & CO BRUSSELS (BELGIUM) 3 MONTHS

As a PL/SQL developer, I participated in the realization of a data warehouse project by writing PL/SQL packages and Unix scripts for the data warehouse’s ETL part.
Daily Tasks: Analysis, Development
Technical environment: Oracle 7.3/8i, Toad, vi, shell ksh.

DUFERCO LA LOUVIERE (BELGIUM) 3 MONTHS

As an oracle application developer, I joined the IT department of DUFERCO an industrial company specialized in the steel industry.
The first part of the project consisted in automating certain process, by implementing packages and triggers on the DB.
The second part consisted in rewriting the existing applications concerning the data stream by adopting a 3T architecture.
Daily Tasks were structured around following steps: Functional analysis, Data modeling, Database administration (DB modelling, DB creation, Users management), Programming

Technical environment: Oracle 7.2.3/8i, Developer2000, WebDB

KPN BELGIUM BRUSSELS (BELGIUM) 3 MONTHS

I participated in the realization of an experimental project by writing PL/SQL packages and shell scripts for the data warehouse ETL part.
Development tools: SQL+, Procedure Builder,VI.

MRBC – MINISTÈRE DE LA RÉGION BRUXELLOISE BRUSSELS (BELGIUM) ONGOING
aujourd'hui
As an Oracle Forms Certified Professional expert, I’m in charge of ensuring service, maintenance and further development for a sensitive application.
It consists of following punctual tasks mainly done remotely:
• Providing quick and efficient solutions in case of service failure
• Providing expertise in case of new forms/packages/procedures buildings
• Ensuring day to day availability
Technical environment : Oracle Forms, Oracle Reports, Toad pro

SNCB-NMBS (BELGIAN RAILWAYS) BRUSSELS (BELGIUM) 12 MONTHS
aujourd'hui
As Oracle senior consultant, I was in charge of providing solutions for managing lifecycle of train drivers performances (scheduler, real-time management, post treatment for third parties) .
The project has been divided into three main parts:
The first part has consisted of providing to train drivers -on A4 document- a detailed description of their daily performances (such as schedule, perf...