Dariusz - Consultant INFORMATICA

Ref : 070329B003

Profil

Consultant, Développeur, Consultant technique (61 ans)
Domicile

75011 PARIS
Mobilité

Ile-de-France
Tarif Journalier Moyen
Voir le tarif

Compétences

MVS

Unix

Db2

AS400

Business Objects

Oracle

J2EE

Informatica

Décisionnel

Expériences professionnelles

SPB Insurances – integration EA of CLEVA ERP
2008 - aujourd'hui
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)
2008 - aujourd'hui
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
>DANONE
juin 2007 - aujourd'hui
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
BOUYGUES-Telecom
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
>Gaz de France – Connexion to Gas Network
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
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
2002 - aujourd'hui
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
Business Intelligence Data Warehouse

Aventis Pharma (France) – Direction of Information Systems –
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
2001 - aujourd'hui
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
2001 - aujourd'hui
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

Études et formations

Master degree in "Management of Industrial Systems"

Ecole Centrale de Paris + Ecole Centrale de Lyon + Ecole des Mines de Saint-Étienne (France)
Technical University of Szczecin – Civil Engineering (Poland)

Langues

Anglais - C2

Autres compétences

EXPERIENCED MARKETS
Industrial activities :
Bank / Insurance
Manufacturing (automotive, medical supply, construction…)
Retail and Wholesale
Telecommunication

Occupations :
IT – Information Technologies (Databases ; ETL ; J2EE ; Internet ; Programming ; Unix, MVS)
Civil Engineering (Labor, Technical Supervision, Technical design, Project management)
Industrial management (ERP Analyst, Process Modeling & Operational research, Marketing, Accounting, Controlling)

Operating positions :
End user Requirement analyst
Technical Architect / System Modeler
Project manager
Technical expert
Technical auditor
DataWarehouse and DataMart - Designer and Developer
ETL (Extraction-Transforming-Loading) Designer and Developer
J2EE Developer
Optimizations - Concept / Development / Environment (OS, DBMS)
On-line application support
Technical support

TECHNICAL KNOWLEDGE
Databases
ORACLE V7-8-9-10 (Unix/Windows/Netware), DB2 (MVS, AS400, Unix, Windows), MySql, PostgreSQL, Sybase

Querying tools
Business Objects - Crystal Report, Cognos PowerPlay, MicroStrategy

Languages
C/Pro*C, C++, Cobol/ProCobol, SQL, PL/SQL, HTML/XHTML (with XML, CSS, Web Services), JavaScript, Java/J2EE/Java EE, PHP, Perl, TCL/TK, Python, Rexx, SAS, PowerBuilder

OS (Operating Systems) OS390 (MVS), Unix (IBM-AIX / Sun-Solaris / HPUX / Sinix / Linux), AS/400, Windows

Methods and Tools
MDD (Model Driven Development), MERISE, UML (IBM Rational, Visual-Paradigm, MagicDraw+AndroMDA, Dia, Visio, PowerAMC, EMF), Eclipse, MicroFocus, Agile/XP (Extreme Programming) concepts

ETL/EAI
(Extract-Transform-Load data / Enterprise-Application-Integration) Informatica, ETI Extract, ETL not-bundled (coding in PL/SQL, C, Cobol, Java, PHP, Database utilities), ESB (Enterprise Service Bus) proprietary (IBM WESB&WPS) and open sourced (JBoss, Mule, Apache ServiceMix, Sun CAPS).

Java Enterprise Edition
/ J2EE UML2, XML, Design Patterns, Websphere, JBoss, Glassfish, Ant, Xdoclet, MVC, Java core, Servlets, JSP, Struts 1.x/2.x, Persistence (JDBC, OJB, JPA, Hibernate), Spring 2, EJB2, EJB3, Seam, Web Services (SOAP, REST), BPM, toolsets, frameworks

Recommandations reçues

Recommander Dariusz

Dariusz n'a pas encore reçu de recommandations.

D'autres freelances
Consultant MVS

Ces profils pourraient vous intéresser !

Ingénieur de développement COBOL

LILLE

COBOL COBOL II MVS OPC JCL SQL AS400 Micro Focus Visual Studio Db2

Administrateur système UNIX

SALMIECH

Unix CFT Ethernet HTTP Cisco Firewall HP OpenView DHCP LAN MVS

Consultant MVS

CARRIÈRES-SUR-SEINE

MVS COBOL JCL Db2 SQL

Administrateur système LINUX

Tubize

Linux VM/CMS REXX SQL Python Django MVS VTAM VMware VM/VSE

Disponible

Analyste programmeur COBOL

IVRY-SUR-SEINE

COBOL Db2 MVS JCL SQL TSO HP ALM IMS

Consultant informatique

PARIS

COBOL Pacbase MVS TSO ENDEVOR

Consultant Senior

SAINT-CLOUD

PMO Excel Agile Db2 GED MVS ITIL DevOps PeopleSoft Murex

Consultant Senior HR ACCESS

CHELLES

HR Access SQL Shell Unix COBOL JavaScript Excel MVS Oracle MySQL

Testeur DB2

CARCASSONNE

Db2 MVS Jira Quality Center SQL Agile

Chef de projet MAINFRAME

PARIS

Mainframe Oracle Windows SQL Server Linux SQL WebSphere Db2 MVS Java

Mme

Prénom ^*

Nom ^*

Email ^*

Téléphone ^*

Ville ^*

Avez-vous trouvé une mission ? ^*

J'accepte d'être contacté par nos partenaires, experts en portage salarial et j'accepte la politique de confidentialité du site www.freelance-informatique.fr

Domaines d'expertise liés

CV en rapport

Dariusz - Consultant INFORMATICA

Consultant, Développeur, Consultant technique (61 ans)

75011 PARIS

Vivendi-Universal Interactive Publishing (France) – Direction of

Business Intelligence Data Warehouse

Master degree in "Management of Industrial Systems"

Technical University of Szczecin – Civil Engineering (Poland)

D'autres freelances Consultant MVS