Dariusz - Consultant INFORMATICA

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 and implementation of advanced replication data flow between Oracle/server and Oracle_Lite (off-line and on-line mode + automatic bi-directional update when connected)
Design, creation and implementation of maintenance procedures for exchange of production data between Oracle server and DB400 (on AS/400)
Design, creation and implementation of maintenance procedures for advanced replication on Oracle
Concept and implementation bidirectional updating between Oracle server and Oracle Lite (development and implementation of Visual Basic application using transfer operations and maintenance on remote system)
Training sessions and reference guide on installation and administration of Oracle server, Oracle Transparent Gateway, Oracle Lite
Training sessions and reference guide on examples of coding in PL/SQL language
Training sessions and implementations concerning application maintenance in Oracle production environment
Environment and tools : AS/400, Netware, UNIX, ORACLE, Oracle Transparent Gateway for AS400, Oracle advanced replication, Oracle Lite, PL/SQL, Visual Basic

>Novartis Poland
2 weeks (1999)
Project : Multidimensional dynamic querying solution for accounting data on AS/400
operational reporting
Carrying out :
Development and roll-out of reporting systems based on several Cognos solutions
Optimizations of ETL procedures for reporting querying tools
Optimisation of data processing on AS/400 for multidimensional analysis
Environment and tools : DB400 (DB2 AS/400), Impromptu, PowerPlay

>La Henin vie (Assurance) – Direction of Information Systems
6 months (1998-1999)
Project : Development of insurance management application
Technical development
Carrying out :
Design and modelling data (Oracle databases)
Extraction from databases (PL/SQL advanced techniques)
Administration of the database
Implementation of query tools
Development of PowerBuilder and Crystal Report modules
Environment and tools : UNIX, PC/Windows, ORACLE, Designer 2000, Power Builder, Seagate Crystal Report (actually part of Business Object)

>EDF – Direction of Information Systems
5 months (1998)
Projet : « Steller » - application for monitoring power plant equipment
Développeur
Carrying out :
Application development
Concept for migrating data for multi-platform operation and database systems
Environment and tools : IBM 3090, COBOL, MVS/DB2, UNIX/ORACLE, Sybase (Transac SQL), Power Builder

>Procter & Gamble – DARE - European Data & Reporting Center (Warsaw, Poland)
13 months (1997-1998)
Project: « Sales Work Station » (DataWarehouse) and « ETPD »
Support technique et maintenance
Carrying out :
Maintenance of Job flow of JCL (mainframe batch) for production DataWarehouse loading
On-line support of « SWS » application (DataWarehouse on MVS). DataWarehouse was producing a set of PowerPlay files which were “pushed” to Sales sites in European countries.
Development of monitoring system of JCL job flow using Control-M scheduler macro language
Environment and tools : IBM 3090 (MVS / Mainframe), COBOL, EasyTrieve, Endevor, Rexx, ControlM, ConnectDirect, MVS/DB2, UNIX/ORACLE, PowerPlay

>OTH Rhône–Alpes – Auvergne – Bourgogne (Construction) (Warsaw, Poland – Lyon, France)
10 months (1996)
Project: Implementing supermarkets for « Casino » French retail in Poland.
Technical coordination and survey
Carrying out :
Coordination and technical supervision of construction of 2 commercial buildings in Warsaw :
Project planning
Contractor bid control
Technical conformity control
IT environment & tools : PC/Windows, AutoCad, MS Project, Robot

>ESPEBEPE Holding S.A. Poland (Construction – Project Management)
4 years (1991-1995)
Position: Manager of Information Systems
Carrying out :
Implementation of environment, tools and network
Internal developments
Implementation of methods for project management
Implementation of reporting tools
Analysis of methods MRP and MRP2
Implementation of COMET (Siemens-Nixdorf integrated ERP solution for accounting, payroll, stock management, ...)
IT environment & tools : PC/DOS/Windows, NetWare 3.11, Sinix (unix of Siemens Nixdorf), KornShell, Dbase, Clipper, Crystal Report, C/C++, PertMaster Advance, Primavera Project, Artemis Project, MS Project