Francesco - Consultant technique ORACLE PL
Ref : 090911D001-
1050 IXELLES (Belgique)
-
Développeur, Consultant technique (61 ans)
-
Freelance
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
1. SECTORS
Ten years experience in Oracle database development : sql, pl-sql, Forms, Report
Financial Services, Technical Services
Pharma industry
Public Sector
Insurance
Banking
2. SPECIFIC BUSINESS KNOWLEDGE
Banking
o Asset Pricing
o Asset Liablility Management
o Credit Risk Management
o Treasury
o Corporate Finance
3. TECHNICAL SKILLS
Databases
Oracle 8i, 9i, 10g, 11g - DML - DDL-DCL-TCL, Sql Loader, Import Export, Basic administration
MySql, Access
Languages
Pl-sql, Forms, Reports, Java (JDK, Servlets, JDBC, etc.), Visual Basic, SHELL, HTML, JavaScript, C, SQL, XML
Application Servers / Servers
Oracle Application Server, Tomcat, Apache
Oracle eBusiness Suite v10.x and v11.x
Modules AR – AP – PO – GL – OKC – OKS – HRMS – IC – OM – ONT – GME – GMD – WIP –GME – GMD
Tools
CVS, TOAD, Visual Source Safe
Platforms
UNIX, Linux, Windows (XP, 2000, NT),
Documentation
o Technical documentation
o End-user manuals
Operation procedures, all of these in English and/or French
4. METHODS & METHODOLOGIES
UML, Design patterns, MERISE
5. LANGUAGE SKILLS
Language Spoken Written
English Fluent Fluent
Italian Mother tongue Mother tongue
French “Native speaker” level “Native speaker” level
2. Education, Training & Certifications
18/02/2013
01/10/2012
2011-2012
2008 - 2009
Oracle Weblogic : Online training.
1Z0-053 : Oracle Database 11g: Administration II - Score : 75%
Oracle Testing ID : OC0815433 – Registration : 251329217 Center ID : 63857
Solvay Business school : Executive master in finance
Université St Louis (Bruxelles) : Master complémentaire en gestion des risques financiers
1999 - 2005
Conservatoire National des Arts et des Métiers (Lyon)
System Engineer
19-04-2010 – 21-04-2010
Oracle Database 11g: SQL Tuning Workshop
Instructor-Led Training 3 Days - Oracle University Enrollment 5153673
01-03-2010
1Z0-052 : Oracle Database 11g: Administration I - Score : 87%
Oracle Testing ID : OC0815433 – Registration : 234498891 Center ID : 29154
04-02-2010
1Z0-141 : Oracle Forms: Build Internet Applications- Score : 76%
Oracle Testing ID : OC0815433 – Registration : 234073494 Center ID : 29154
24-11-2009
1Z0-146 : Advanced PL-SQL 11g- Score : 96%
Oracle Testing ID : OC0815433 – Registration : 233071079 Center ID : 29154
28-10-2009
1Z0-147 : Program with PL-SQL - Score : 81%
Oracle Testing ID : OC0815433 – Registration : 232606545 Center ID : 29154
14-10-2009
1Z0-051 : Oracle Database 11g : SQL Fundamentals 1 - Score : 76%
Oracle Testing ID : OC0815433 – Registration : RID6559 – Non proctored
2007
PRINCE 2 Training (Foundation)
2002
DEST Informatique Cnam (Conservatoire National des Arts et Métiers)
1998 – 1999
Association pour la formation professionnelle des adultes (AFPA)
Diplôme de Technicien supérieur en Informatique de Gestion, option Etudes
2006-2007
2011
Six months of courses at the Thema Language School in Brussels (English)
First level Dutch – Berlitz School.