Rene - Business Analyst ACCESS

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

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
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

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

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

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

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

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

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.

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