Expérience professionnelle
>SPB Insurances – integration EA of CLEVA ERP
1 month (2008)
Project: PEPSIA – scoping phase – development of technical architecture and integration phases of CLEVA™ ERP software (of ITM™)
- Technical Architect
Carrying out :
Technical architecture J2EE/SOA :
Collecting elements and describing target EA
Analysis of inter-application interfacing and working out SOA integration phases of new system wrapped up by Informatica™-Web Services.
Defining HA (High Availability) solutions for target topology
Environment and tools: J2EE, n-tier SOA, Eclipse, Spring 2, Hibernate 3, Informatica PowerCenter with PowerConnect for WS and Real Time options, JBoss
>FNTP (Fédération Nationale des Travaux Publiques)
2 months (2008)
Project: FNTP – Web2 / J2EE Application for Management of Contacts, Institutions, Bids and Events related to activities of French National Federation of Civil Engineering
Technical Stage
Carrying out :
J2EE development:
Implementation of Search module for filtered lists of Persons and Institutions
Trainings and knowledge transfer for further development handover
Environment and tools: J2EE, Eclipse, Websphere Rational Application Developer, Servlets, JSP, JavaScript, AJAX, DOJO v1.1, CVS
>BOUYGUES-Telecom
5 months (2007-2008)
Project: JADE/BSCS – hand over / integration of CRM modules (in Siebel) – migrating of application data - Informatica™ development
Technical Stage
Carrying out :
Application modules using ETL :
ETL development of complex application modules (Customers, Contracts) using Informatica™
Technical optimizations (ETL, Oracle, Unix); advising, knowledge exchange
Trainings and knowledge transfer for further development handover
Environment and tools: Windows, Oracle v8-v9i-v10g, Informatica™, PL/SQL, VBS
>DANONE
1 month (June 2007)
Project: Component/ingredients reports – Informatica™ development
Technical Stage
Carrying out :
ETL developement :
Recovery and corrections of development in Informatica™ ETL, Transact-SQL
Technical optimizations (ETL, Sybase IQ / Transact-SQL); advising, knowledge exchange
Trainings and knowledge transfer for further development handover
Environment and tools: Windows, Sybase IQ, Informatica™, Transact-SQL, Java
>Gaz de France – Connexion to Gas Network
18 months (2006-2007)
Project : PRISCA – application of CRM type (in Selligent), used by GRD (Network Development) concerning prospective customer connections to gas of GDF
Technical Stage
Carrying out :
Modular ETL system :
Recovery and corrections of development of existing modules in Informatica™ ETL , Unix scripting and PL/SQL packages
Concept and implementation of « marketing dashboard » module
Technical restructuring and functional specification of inter-application data exchange modules : 2 modules PRISCA-DIAMANT (direct access methods), module MARK (automated send-reception of data enrichment files between external GDF partners)
Concept and implementation of Informatica™ ETL solutions with external modular reuse of elements in Unix shell, Java, PL/SQL
Technical optimizations (ETL, Oracle, Unix); advising, knowledge exchange
Creating of programs and scripts for selective / non-regular data maintenance actions
Trainings and knowledge transfer for production and maintenance handover
Environment and tools : Unix, Windows, Oracle 8i-9i, Informatica™ , PL/SQL, Java
>FRANFINANCE (France) – Infocenter and DataWarehouse
2.5 years (2003-2005)
Project : DataWarehouse and Datamarts data supply for contract management of credit system for individuals
Technical Stage
Carrying out :
Project 1: DataWarehouse – Tuning/Optimizations, Data enrichments, Maintenance :
Concept and implementation of ETL for DataWarehouse (Oracle/Unix) from DB2/MVS and Oracle using ETi™, PL/SQL, MicroFocus™ Cobol
Technical specifications
Master User ETI™ (customization and maintenance of code generator)
Oracle optimisations, advising, knowledge exchange
Introduction, implementation and trainings on many ETL solutions for use on MVS and Unix
Industrializations and Production integration of programs and WorkFlows
Maintenance, modifications and technical support of ETL workflows for DataWarehouse in production environment
Project 2 – ETL MIGRATION :
Feasibility analysis
Architecture
Development and target models modularization
Introduction of software versioning / modification management
Integration procedures and automated migration DEV-->REC-->PROD
Concept and implementation of large scale program migration – the handover of 160 Eti™-Extract generated programs into MicroFocus™ Cobol IDE (for Corrections, Tests and Rebuild,)
Complete implementation (redesign following new models included) of 80 Cobol programs into production environment
Trainings and knowledge transfer for development and maintenance handover
Environment and tools : NT, Oracle 8i & IBM AIX, DB2 & OS390(MVS), ETI-Extract™, PL/SQL, MicroFocus™ Cobol (NetExpress™, ServerExpress™, Publishing inter-platform), C, Unix shell scripting, Java, Visual SourceSafe™, PowerAMC™
>Vivendi-Universal Interactive Publishing (France) – Direction of Information Systems – Business Intelligence
1 month (2002)
Project : Analysis and Recommendations on DataWarehouse Oracle – Video Games
- Audit
Carrying out :
Audit on logical and physical data model
Audit on ETL processes
Audit / Check-list on Oracle database
Environment and tools : Oracle 8i & Unix, Power Designer v9
>Aventis Pharma (France) – Direction of Information Systems – Business Intelligence Data Warehouse
8 months (2001-2002)
Project : Integration of many databases (multi-site distributed) into one common DataWarehouse and DataMart
Project : CTI (CleanTrial-Impact – databases of Clinical Study on Patients)
Technical Stage
Carrying out :
Concept and implementation of dynamic access to distant databases sources
Concept and implementation of non-homogeneous data integration
Installation and development ETL – Informatica™ PowerCenter
Concept and implementation of specific execution log system on all ETL activity (in C language, PL/SQL et shell scripting)
Functional and technical documentation
Deployment and tunning of Oracle databases (many instances)
Environment and tools : Informatica™ PowerCenter/PowerMart, Unix HP & Solaris, Oracle 8i, C, PL/SQL
>BOUYGUES TELECOM (France) – Direction of Information Systems
4 months (2001)
Project: Network traffic monitoring
Programmer
Carrying out :
Real time data file flow treatment
-Implementation in C language of two modules which treat data
-Integration / automating of whole project treatments with Unix shell
Oracle database tunning for parallel loading of big target tables of 400GB
Environment and tools : Unix AIX RS10000, Oracle 8i, C
>AXA Insurance (France) - Direction of Information Systems
4 months (2001)
Project: Implementing DataWarehouse and Datamart for accounting
Technical Stage
Carrying out :
Concept of ETL Work Flow
Customization ETI™
Code generation of ETL programs using ETI™
Trainings ETI™
Technical documentation for operators
Environment and tools : MVS OS390, Unix AIX RS10000, Oracle 8i, ETI-Extract™, Cobol, C, Pro C
>Hapag-Lloyd Container line (Hamburg, Germany) – Direction of Information Systems
6 months (2000-2001)
Project: ETL architecture for DataWarehouse of maritime container transport logistic
Technical Stage
Carrying out :
Participation in concept of star model of DataWarehouse
Concept of ETL Work Flow
Customization ETI™
Code generation of ETL programs using ETI™
Trainings ETI™
Technical documentation for operators
Environment and tools : MVS OS390, DB2 OS390, ETI Extract DA, Cobol
>Toyota Europe (Brussels, Belgium) – Direction of Information Systems
14 months (1999-2000)
Project : Architecture ETL implementation of 2 DataWarehouses « Vehicles » and « Parts »
Technical Stage
Carrying out :
Datawarehouse technical architecture
Development of DataWarehouse loading programmes using ETI generator
Customisation on ETI
Automation of development handling processes (background ETI generation), and multi-platform transfers
Creation of batches and scripts – using proprietary solution generator tools (various JCL, PARMLIBs, PROCLIBs)
Creation of reports and « job flow » diagrams on all ETI programmes for Datawarehouse and DataMart.
Creation and implementation of reporting systems on generated programs using proprietary solution and using « ETI Impact Analyst »
Optimisation of DB2 (tables, indexes, constraints)
Environment and tools : MVS OS390, DB2 OS390, ETI Extract, Cobol, DB2 NT
>Roneo (Fabrication de mobiliers de bureau) (France) – Direction of Information Systems
6 months (1999)
Project: Implementing ERP-like system for furniture manufacturing and sales management
complete advanced and working solution
Carrying out :
Installation of Oracle server on Novell Netware
Optimization Oracle on Unix
Configuring SQL/Net and activation multi server connexions
Design, creation and installation of a SQL call layer between AS/400 and the Oracle server via Oracle Transparent Gateway
Design, creation and implementation of scheduled PL/SQL stored procedure data flow between two databases: Oracle/server and DB400 (AS/400)
Design, creation an...