CV/Mission de Développeur PowerBuilder Sybase freelance

Exemple de missions de Dariusz,
Développeur PowerBuilder Sybase habitant Paris (75)

• integration EA of CLEVA ERP

  >SPB Insurances
  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
  Jan 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

• >Aventis Pharma (France) – Direction of Information Systems – Business Intelligence Data Warehouse
  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