ETL/DWH BI Consulting

3/2020 – offen

1. Develop and maintain Architecture and Data Models for non-traditional data structures and technologies for corporate and project specific initiatives, including the identification of data most valuable to the department, the integration of this data, and the development of core relating data models.
2. Project #1 : Extract CRM SalesForce data to feed OpenText Documentum objects
• Define JSON schema to be used for mapping and validation ( json-schema.org rules)
• Extract SalesForce data ,validate it against reference DWH and map it to JSON structures
• Mapping the Structured Relational schema fields to Unstructured JSON schema members to be consumed by Documentum REST APIs
• Design authentication/authorization flow against Azure cloud security (using IBM Infosphere DataStage connectors and POSTMAN )
o Authenticates users with the specified provider
o Validates, stores, and refreshes tokens
o Manages the authenticated session
o Injects identity information into request headers
• Build data flows to query the Documentum database to validate the document metadata ( GET )
• Build process to create storage trees and store the binary documents(pdf,img,txt) to OpenText Documentum endpoints (POST/PUT)
• Transfer metadata and binary documents
3. Project #2 : Build Data Pipeline between Structured Relational Data and Unstructured JSON data
• Design Data Pipeline between on-perm applications and Azure cloud using IBM Infosphere Hierarchical stage to consume Web Services
• Design Generic processes to receive data into flat file CSV format and generate JSON file to be consumed with REST API
o Validate CSV files against schema file
o Create JSON schema libraries to be used for transformation
o Deliver JSON data conform to consumer contract
• Data flow to populate SQL Graph Database from JSON files
• Test API REST with POSTMAN

Datenbankentwicklung

7/2018 – 3/2019

BI Solution Analyst

Datawarehouse / DWH

1/2015 – 6/2018

Projekt #1 : Legacy Migration
• Perform all phases of the Software Development Life Cycle (SDLC) including requirements analysis, application design, code development, testing and deployment
• Design and code legacy migration processes using IBM DataStage and SQL queries
Projekt #2 : Data Mart
• Design and code programming templates to load Slow Changing Dimensions( Type 1,2 and 3) using DataStage SCD stage and implementing DataStage best practices
• Design and code template to load Fact tables with Late Arriving Facts and complex aggregation using DataStage Lookup stage , DataStage Transformer Loops and analytical functions to aggregate metrics
Projekt #3 : Three Systems Data Reconciliation Indicators

• Design and code the DataStage process to load a mega Fact table (150 fields) that integrates data from 3 different systems , conform dimensions and many other Fact tables

Business Intelligence (BI)