Francesco - Consultant technique ORACLE PL

Expérience professionnelle


FREELANCE ORACLE DATABASE EXPERT
07/2010
BNP PARIBAS FORTIS
Technical Oracle Consultant
Database Analyst-Programmer
Technical Environment : Oracle 11g, SQL Server : Pl-sql, sql, TOAD, Windows XP, UNIX, Office Pack
06/2010 – 07/2010

Technical Oracle Consultant
Migrating data from a source database to a target database . SQL Tuning.
Technical Environment : Oracle 9i : Pl-sql, TOAD, Windows XP, UNIX, Office Pack

SOCIETE ALTRAN
02/2009 – 04/2009 MOBISTAR - BRUXELLES
Technical Oracle Applications Consultant
Developments and debugging of applications in 11.5 version.
Approach and responsibilities : Design, analyze and develop the technical solutions to integrate the 170Systems MarkView e-Invoice application with Oracle Applications.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

01/2009 – 02/2009 INBEV – LEUVEN
Technical Oracle Consultant
Migration to a new Oracle environment
Approach & Responsibilities : Migration from Oracle 8i to Oracle 10g, Migration from Oracle Application Server 9i to 10g, Migration of Forms, Reports and C/Pro C programs and SQL scripts. Setup of the new environment.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

10/2007 – 12/2008 FORTIS BANK - MERCHANT BANKING BRUXELLES
Technical Oracle Consultant
Developments and debugging of specific applications
Approach & Responsibilities : Analyzing, developing and debugging internal applications in order to feed the database used by the Customer Internet portal. Insure the correct running of the applications. Suggest and put in place technical and architectural improvements.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, TOAD, Windows XP, UNIX,Office Pack

10/2006 – 10/2007 INTER PARTNER ASSISTANCE BRUXELLES
Technical Oracle Applications Consultant
Developments and debugging of applications in 11.5.5 version.
Approach & Responsibilities : The purpose of this mission is to maintain the interfaces applications between the external applications and the financial modules of OEBS.
Modules : AR – AP – PO – GL.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

SOCIETE SOPRA GROUP
11/2005 – 09/2006 ADT TYCO LYON
Technical Oracle Applications Consultant
Developments and debugging of applications both in 10.3 and 11.5.5 version.
Approach & Responsibilities : Developments and debugging on two differents environments of the Enterprise Business Suite – 10.03 – 11.5.5.
Modules : AR – AP – PO – GL – OKC – OKS.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

05/2005 – 10/2005 COMAREG LYON
Technical Oracle Applications Consultant
Migration between a version 10.3 of Oracle Applications to version 11.5.10 of the Enterprise Business Suite.
Approach & Responsibilities : Specifications and developments for the migration from the version 10.3 of Oracle Application and the version 11.5.10 of the Enterprise Business Suite.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack
03/2005 – 05/2005 CIRAD MONTPELLIER
Technical Oracle Applications Consultant
Implementation of the HRMS module of the Enterprise Business Suite version 11.5.10
Approach & Responsibilities : Specifications and developments for the interfaces between the Enterprise Business Suite and others applications (among wich scientifics qualifications of the agents of CIRAD around the world, and an LDAP directory) for the implementation of the HRMS module of the Enterprise Business Suite.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, LINUX,Office Pack

01/2005 – 02/2005/10/2003 – 03/2004 SANOFI-AVENTIS BORDEAUX
Technical Oracle Applications Consultant
Implementation of the GPAO module of the Enterprise Business Suite version 11.5.10
Approach & Responsibilities : Specifications and developments for the interfaces between the Enterprise Business Suite and others applications, development of specifics Reports for the implementation of the GPAO module of the Enterprise Business Suite.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

9/2005-12/2005 OCPA GENÈVE - SUISSE
Development of specifics reports in AR module
Approach & Responsibilities : Specifications and developments of specifics Reports for the implementation of the Financials modules of the Enterprise Business Suite.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

09/2005 (10 DAYS) MESSIER DOWTY GLOUCESTER – ENGLAND
Technical Oracle Applications Consultant
Development of specifics reports in AR module
Approach & Responsibilities : Specifications and developments of specifics Reports.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

04/2004 – 06/2004 LYONNAISE DES EAUX PARIS
Technical Oracle Applications Consultant
Customer invoicing for services different from water supplies
Approach & Responsibilities : Specifications and developments of specifics Reports.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

06/2003-10/2003 HOSPICES CIVILES LYON
Technical Oracle Applications Consultant
Implementation of financial modules
Approach & Responsibilities : Development of specifics programs to import parameters in financial modules. Development of specifics programs for interfaces.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

12/2002-06/2003 RHODIA LYON
Technical Oracle Consultant
Migration from Oracle to SAP
Approach & Responsibilities : Development of specifics programs to extract data from old environment.
Technical Environment : Windows XP & Unix,Office Pack, TOAD

10/2002 – 11/2002 SOITEC CROLLES - GRENOBLE
Technical Oracle Applications Consultant
Implementation of GPAO Modules
Approach & Responsibilities : Development of specific Form.
Technical Environment : Windows XP & Unix, Office Pack, TOAD, Oracle Developer Suite

09/2002 TMA EULER SFAC LYON
Technical Oracle Applications Consultant
Development and debugging of specifics developments in financial modules
Approach & Responsibilities : Specifications and developments of specifics tools.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

03/2002 – 09/2002 INSERM PARIS
Technical Oracle Applications Consultant
Implementation of financial modules
Approach & Responsibilities : Specifications and developments of specifics tools.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

02/2001 – 02/2002 HOSPICES CIVILS DE LYON LYON
Technical Oracle Consultant
SIM Project – Medical System of Information
Approach & Responsibilities : Specifications for debugging and evolution of specifics tools.
Technical Environment : Oracle 10 g, Oracle Developer Suite : Pl-sql, Forms, Report, TOAD, Windows XP, UNIX,Office Pack

11/2000 – 02/2001 ASI LYON LYON
Approach & Responsibilities : Development of specific programs.
Technical Environment : Windows NT, Office Pack, SQL Server, Visual Basic

11/1999 – 11/2000 SOCIETY : SOLERI (ACTUALLY T-SYSTEMS)
CUSTOMER : FRANCE TELECOM - APAVE LYON
Approach & Responsibilities : Development of specific programs in Visual Basic for France TELECOM and APAVE.
Technical Environment : Windows NT, Softwares : Pl-sql, Office Pack, Oracle, Visual Basic, Informix, SQL-C

01/1993 – 01/1997 ETUDE CHAINE ET ASSOCIÉS – LAWYERS LYON
Approach & Responsibilities
Clerk