Rene - Business Analyst ACCESS

Ref : 160818P001
Photo de Rene, Business Analyst ACCESS
Compétences
ORACLE SQL
SHELL UNIX
AB INITIO
APACHE HADOOP
Expériences professionnelles
  • Customer : Lidl
    Jan 2018 - aujourd'hui

    Project :
    Integration KPI data to Teradata
    Integration Real Estate data to Teradata
    Job description : Analysis of Excel VBA for business rules requirements
    Impact Analysis for integration with Teradata and Abinitio
    Extending Datawarehouse Datamodel
    Developing Data feed for XML to Teradata using Abinitio
    Developing Data feed for SAP HANA to Teradata using Abinitio
    ODBC certification setup to SAP HANA
    Generating graphs to support impact analysis.
    Resources : Excel Visual Basic for Applications,
    Abinitio, Teradata/bteq, Powerdesigner, Unix, Graph tools, Jira, Confluence

  • Project : Datawarehouse for Retail and Wholesale

    Customer : KPN
    Jan 2015 - aujourd'hui

    Job description : ETL Developing within a scrum team.
    Resources : Microsof SQLServer 2012
    Cygwin, OSQL, SQLcmd
    Powercenter 9.5
    Teradata
    Teradata Fastload

  • Project : DWH Migration to Teradata
    Jan 2015 - Jan 2018

    Project : DWH Migration to Teradata
    Job description : Wholesale Retail Datawarehouse Migration sqlserver to Teradata
    Powercenter Windows to Unix/Python
    Migration Pushdown Powercenter mapping for Teradata
    Datawarehouse Decommisioning of obsolete parts.
    Design Datamodel for ETL model Teradata (Contracts/Products/Customers) for
    loading with Powercenter(Unix).
    Resources : Airflow Directive Acyclic Graphs, Powercenter, Python, Unix, Teradata, Jira,
    Confluence, Windows, SQLServer

  • Customer : Vodafone
    Jan 2014 - Jan 2015

    Metadatadriven Ab Initio ETL processflows.
    Job description : ETL Developing within a scrum team.
    Resources : Abinitio GDE
    Oracle Warehousebuilder
    Teradata
    Teradata Fastload

  • Customer : KPN
    Jan 2014 - Jan 2014

    Project : Datawarehouse for Retail and Wholesale
    Job description : ETL Developing within a scrum team.
    Resources : Microsof SQLServer 2012
    Powercenter 9.5
    Teradata
    Teradata Fastload

  • Project : PLCC project

    Customer : Honda Europe
    Jan 2013 - Jan 2014

    Job description : ETL Developing within a scrum team
    Realtime environment
    Synchronizing two masters by reading and writing XML messages from and towards subscriber and message queues.
    Using Micrographs.
    Introducing changes for better performance concerning opensource database drivers towards SQLServer to avoiding DB2 via's
    Balancing process flows to avoid Multiple Active Resultsets.
    Resources : Ab Initio GDE, Micrographs
    Kornshell
    DB2
    SQLServer
    XML(messaging system)
    Easysoft odbc driver on UNIX
    FreeTDS odbc driver on UNIX
    C-compiler

  • Project : Datawarehouse for Retail and Wholesale

    Customer : KPN
    Jan 2013 - Jan 2013

    Job description : ETL Developing within a scrum team.
    Resources : Microsof SQLServer 2012
    Powercenter 9.5
    Teradata
    Teradata Fastload

  • Customer : Honda Europe
    Jan 2012 - Jan 2013

    Job description : Development support/Architecture/Design advise and Operational Support
    Proof of Concept Operational Console, Conduct>It
    Sandbox analysis: Generate reports processes per fase by scripting
    Logfile resource monitoring/reporting.
    Performance tuning/advice
    Installation/configuration
    Resources : Windows 2003, AIX 6.1
    Ab Initio CoOp 2.15, 3.1.2.5, 3.1.4.4
    Batch/Realtime/Webservices
    Kornshell, Cygwin
    Operational Console, Conduct>IT
    Elementum.
    DB2 Databases
    Solarwinds

  • Project : Value Based Management reporting

    Customer : A1 Telekom
    Jan 2012 - Jan 2012

    Job description : Setting up ETL environment. Develop ETL mapping Prototype for target tables in Teradata. Analysing surrogate key Abinitio component/graph. Tutoring new trainee Ab Initio developers.
    Resources : LINUX Bash/KornShell
    Ab Initio 3.0 ETL (CoOp 3.0.2.6),
    Teradata 13.0.0.6 (Fastexport/Multiload)

  • Project : n.a.

    Customer : n.a.
    Jan 2012 - Jan 2012

    Job description : Developing control/taskflows for importing private Call Detail Records from pdf invoices.
    - Setting up secure shell/ftp with plink and psftp using keyfiles.
    - Conversion from pdf to text with opensource xpdf, compiled C on DEBIAN.
    - Conversion of raw xpdf data into several columns with pattern matching by
    regular expressions with kornshell commands (sed, grep, cat, awk).

    the C# environment for the used script component.
    Resources : Windows XP
    plink, psftp, WinSCP, Kornshell, DEBIAN 8CPU, SSIS 2008, SSERVER2008, cgautil

Études et formations
  • EDUCATION
    • HTS Technical Computer Science (Bachelor degree) (1996)
    • MTS Electronica
    • Microsoft Certified Solution Developer (1997)
    - MSAccess
    - MSVisual Basic
    • Data Warehouse Lifecycle in Depth (Kimball University)
    • Cibit Masterclass Business Intelligence & Data warehousing

    • PROGRAMMING LANGUAGES
    • Unix Kornshell
    • Ab Initio PDL, DML
    • UNIX Kornshell
    • Regular Expressions (sed, awk)
    • C-Language
    • R-Language
    • SQL / MDX
    • VBA - VISUAL BASIC for Applications
    • VB - VISUAL BASIC
    • Java
    • Turbo Pascal
    • Clipper
    • Basic
    • C++
    • C#

    • OPERATING SYSTEMEN
    • UNIX (HP-UX, AIX, FreeBSD)
    • LINUX(Debian, Ubuntu, RedHat)
    • WINDOWS 2k, 7, 10, NT
    • Sun SOLARIS

    • TOOLS
    • Ab Initio GDE
    • Informatica Powercenter
    • Microsoft Excel
    • Microsoft Access
    • Microsoft Visual Studio
    • Microsoft SQL Server Management Studio
    • Microsoft SSIS
    • Toad 8.6 (Oracle)
    • Putty
    • WinSCP
    • SQL Asistant Teradata
    • SQL Developer (Oracle)
    • vi
    • R-Studio
    • awk
    • sed
    • Notepad++
    • Teradata Fastload
    • Teradata Multiload
    • Hadoop Streaming

    • DATABASES
    • NCR Teradata 13.0.0.6
    • Oracle 11 / Oracle Express Edition
    • Microsoft SQL Server 2008/2012
    • DB2
    • Microsoft Access

Autres compétences
EDUCATION
• HTS Technical Computer Science (Bachelor degree) (1996)
• MTS Electronica
• Microsoft Certified Solution Developer (1997)
- MSAccess
- MSVisual Basic
• Data Warehouse Lifecycle in Depth (Kimball University)
• Cibit Masterclass Business Intelligence & Data warehousing

• PROGRAMMING LANGUAGES
• Unix Kornshell
• Ab Initio PDL, DML
• UNIX Kornshell
• Regular Expressions (sed, awk)
• C-Language
• R-Language
• SQL / MDX
• VBA - VISUAL BASIC for Applications
• VB - VISUAL BASIC
• Java
• Turbo Pascal
• Clipper
• Basic
• C++
• C#

• OPERATING SYSTEMEN
• UNIX (HP-UX, AIX, FreeBSD)
• LINUX(Debian, Ubuntu, RedHat)
• WINDOWS 2k, 7, 10, NT
• Sun SOLARIS

• TOOLS
• Ab Initio GDE
• Informatica Powercenter
• Microsoft Excel
• Microsoft Access
• Microsoft Visual Studio
• Microsoft SQL Server Management Studio
• Microsoft SSIS
• Toad 8.6 (Oracle)
• Putty
• WinSCP
• SQL Asistant Teradata
• SQL Developer (Oracle)
• vi
• R-Studio
• awk
• sed
• Notepad++
• Teradata Fastload
• Teradata Multiload
• Hadoop Streaming

• DATABASES
• NCR Teradata 13.0.0.6
• Oracle 11 / Oracle Express Edition
• Microsoft SQL Server 2008/2012
• DB2
• Microsoft Access

D'autres freelances
Développeur ACCESS

Ces profils pourraient vous intéresser !
CV Développeur Sénior
Julien

Développeur Sénior

  • HUDIMESNIL
PHP SQL C# SQL SERVER JAVASCRIPT MYSQL .NET ACCESS
Disponible
CV Ingénieur de développement EXCEL ACCESS VBA
Christian

Ingénieur de développement EXCEL ACCESS VBA

  • ISSY-LES-MOULINEAUX
VBA EXCEL ACCESS
Disponible
CV Ingénieur de développement SQL
Eric

Ingénieur de développement SQL

  • VELAUX
SQL ACCESS VBA SSIS SSRS SQL SERVER ORACLE EXCEL SSAS TALEND
Disponible
CV Développeur C#, VBA, Office 365
Dominique

Développeur C#, VBA, Office 365

  • HERNICOURT
C# SQL .NET MS OFFICE VBA EXCEL ACCESS
CV Développeur VBA
Patrick

Développeur VBA

  • NICE
EXCEL VBA ACCESS
CV Développeur EXCEL / ACCESS / VBA
Alexis

Développeur EXCEL / ACCESS / VBA

  • SAINT-DENIS
EXCEL ACCESS VBA SQL SERVER
CV Développeur Oracle Apex - PL/SQL - VBA
Thierry

Développeur Oracle Apex - PL/SQL - VBA

  • ROUJAN
ACCESS SQL PL SQL VBA EXCEL ORACLE APPLICATIONS
Disponible
CV Développeur VBA
Yves

Développeur VBA

  • YERRES
ACCESS VBA EXCEL MYSQL
CV Développeur
Abderrahmane

Développeur

  • VILLEURBANNE
JAVA SQL JAVASCRIPT EXCEL POWERPOINT WORD ACCESS PHP LARAVEL DJANGO Kotlin
CV Développeur VBA, Access
Thomas

Développeur VBA, Access

  • LES MARTRES-DE-VEYRE
SQL SQL SERVER VBA EXCEL ACCESS