Project Jaguar Landrover: Extension/Adjustment of the existing DWH
Munich, Germany
Experience
Project Jaguar Landrover: Extension/Adjustment of the existing DWH
Consors Finanz
Data modeling in DWH
Implementation of data objects and data marts
Definition of job chains
Coordination of requirements with analytics
Performance optimization
Create Operational data store (from scratch; 8 sources) as a basis for new CRM system and future DWH: Architect, Main developer
EIT Health
Support ODS implementation (incl. detailed architecture definition)
Operational data source with 8 sources: MS SQL DB; rest API, csv files.
ETL tool: SSIS, DB: MS SQL
Support the infrastructure decisions for data tools and CRM. Define architecture picture for the data interfaces
Support rule/process/role definitions for data governance (incl. definition of data catalog structure/features)
Analyse data quality issues and define (if possible automatic) processes for data standardisation/profiling/normalization
Fuzzy matching created for central objects (contact and organization)
Support the definition of agile team and agile project management (SCRUM) incl. DevOps standards
Support CRM data model definition
ODS data model defined
Support the definition of operational/maintenance processes for data topics and CRM
Gitea, GIT, bookstack for docu
Create central data Quality Tool (DQT) based on Oracle Apex as frontend and SSIS: Architect, Developer
EIT Health
Deduplication (via SQL Server: Fuzzy algorithm)
Matching (manual “classification” done in APEX)
Import/export: loading of csv file, export to Oracle / SQL Server DBs
Collaborative cleaning of data: 1st stage (Different users can access and transform the same dataset)
Technical Documentation
User manual and help embedded into the App
Data normalization with the linking of new values to standard values
Basic data profiling
Log, changes tracking
Basic data transformation (marked for deletion, merge fields)
Data management and governance expert
EIT Health
Lead the development of the whole data architecture for all central data systems (ODS, MDM, DQ, DWH)
Define the actions for the improvements of data quality in source systems
Develop architectural strategies for data modelling, design and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
Interface with IT and Operations teams to ensure proper coordination of efforts
Develop ETL data ingestion pipelines (Sources: relational databases and Rest APIs)
Define continuous integration/development rules and pipelines
Define operational setup for all central data systems (ODS, MDM, DQ, DWH)
Define data government rules and processes
Create and test physical/business data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
Research and properly evaluate sources of information to determine possible limitations in reliability or usability
ODS extension and operation definition: Architect, Main developer
EIT Health
Create ETL processes which will support (if possible automatic) ODS operations
Define data maintenance processes for central objects/lookups and create Apex applications for Data enrichments.
Support ETL implementation (regular automatic job) of MDM data into ODS
Support implementation of CRM (CRM interface) data into ODS
Work on technical improvements (reengineering) in ODS
Düsseldorf, Germany
Media monitoring expert (Croatia, Kosovo)
European Institute for the Media
Definition of media monitoring strategy
Training of local media monitoring teams
Creation of simple software solutions for the specific media monitoring
Reporting of the monitoring results
Munich, Germany
Senior data management expert
Infineon Technologies AG
Definition and implementation of the business processes together with partner company via supplier enabling qualification
Installation/testing of data transfer routines together with local and partner’s IT (OpenFT, RossetaNet, MQseries, etc.)
Installation/programming of local data transfer routines (Shell, Perl)
Standardisation & optimisation of supply chain business processes
Definition/implementation of logistic/supply chain processes with partners (IT Part)
Creation/maintenance of automatic reports & analysis (LOG, Quality, Data monitoring) (Business objects)
Creation/implementation/maintenance of data monitoring system (Oracle - PLSQL, ASP, Business objects)
Data management trainer (Germany, Singapore)
Documentation of internal processes
Participation in major IT projects, leading small IT projects
Munich, Germany
LCI Data management expert
LINDE AG
Data management activities (data consistency, optimization, reporting, etc.) for projects Ruwais 2 and Ruwais 3
Technologies: Oracle, MS Access, SQL, VB, Jasper Reports
Munich, Germany
B2B - Test Data Transfer Cleanup (Project leader)
Lantiq GmbH
Data format and data structure definition
Data flow definition
Middleware implementation with subcons (automatic data transfer)
Data conversion and loading (ETL) in current DB (LINUX, Oracle)
Support business regarding Data system integration documentation
Munich, Germany
B2B Supplier integration IFX (Project co-leader)
Lantiq GmbH
Establish automatic logistical data exchange (Idocs for PO, PO confirm, shipinfo, WIP)
Establish automatic data transfer of test data and e-maps
Data conversion (based on SAP PI/XI) of IDOC files used for automatic lot creation
SFTP/FTP setup
Munich, Germany
BizTalk middleware (Program manager)
Lantiq GmbH
Align installation requirements with external partner and local IFR team
Support project manager and align activities between different teams (IFR, external partner, project manager, etc.)
Setup test and productive flows (MDM→SalesForce; BI, SalesForce<->XML Filer)
Munich, Germany
EBS Replacement Feasibility Study (Project team member from IT side)
Lantiq GmbH
Define Lantiq specific requirements regarding new test data DB and application
Document IT infrastructure and link to functional applications
Biz evaluation of current tool support
IT Roadmaps / needs for action list
Munich, Germany
IT carve out project (team member)
Lantiq GmbH
Central contact for all manufacturing/BI IT topics
Munich, Germany
Master data management: Implement Master Data Process & System (Project leader)
Lantiq GmbH
Provide MDM based on Microsoft MS-SQL 2012 Master Data Services
Configure master data entities comparable to existing prototype
Support definition of corporate LQ taxonomy and register => Check (unique) and clear nomenclature
Preparation of sample data for each MDM entity
Integrate MDM with SAP ERP master data elements: Material Master, Bill of Material, Source list, Purchase Info Record, Quota Arrangement, weekly/daily loads
Define Access Control to MDM
Support data stewards in loading and cleansing master data objects
Implement and manage MDM round table and change management process with data stewards (CR process)
Provide necessary MDM Base for product cost calculation
Munich, Germany
Middleware replacement: IBM WebsphereMQ and Fujitsu OpenFT (Project co-leader)
Lantiq GmbH
Analysis from existing middleware connections and scripts
Setup and configuration of the new middleware environment incl. accessibility for external partners
Switch of middleware environment from Infineon to Lantiq
Munich, Germany
Product cost calculation (Project leader)
Lantiq GmbH
Calculate product cost forecast as input to product margin reporting
Automatic computation of future product cost on FGR Level in order to feed the product margin reporting process based on consistent master data, future price roadmaps from PUR, yield plans from PT, production/supply plan from SC (SAP ERP MRP)
Provide reports about historical material movements and production plan per vendor, per technology, per material and product hierarchy in qty and value USD
Provide cost (purchase prices and yield) overview per possible manufacturing flow in one sheet
Support production cost analysis (based on volumes from supplier; taken the in-/out qty + EOL etc. into consideration)
Munich, Germany
SAP2Cloud (Project member)
Lantiq GmbH
Unix/Linux data/scripts migration
Label printer: SAP/Unix installation/setup
Clearing reports and performance reporting for real time campaigns: Product Owner/manager
Payback GmbH
Define final requirements for clearing reporting and performance reporting
Process optimization analysis
Improve communication with customers
Data analytics platform (Programmatic Exports, AdServer teaser evaluation): Product Owner/manager
Payback GmbH
Define final requirements for data analytics use cases (DWH (Oracle), Smart data platform (Hadoop), Onedata platform (based on Spark)
Define the basis for agile project management
Data quality and data dependency monitoring: Product Owner/manager
Payback GmbH
Define final requirements for data quality monitoring and data lineage in DWH (Oracle) and Smart data platform (Hadoop)
Data model definition
Weather data integration for real time campaigns: Product Owner/manager
Payback GmbH
Define final requirements
Clarify the internal processes for external APIs (first use of external APIs for DWH team)
Move from IBM DataStage 8.1 to IBM DataStage 11.3 (Prepare/Plan Migration, HW/OS installation, Install DataStage Service & Engine Tier, Migration, Deployment to Production, Performance comparison, Deploy to DEV, Deprovisioning DS 8.1)
MediaFacts – ProMefo replacement (TV coverage and rating analysis system): Technical Lead
ProSiebenSat.1 Applications GmbH
IS/SHOULD analysis for Backend and Middleware part
Create logical data model
Define future system architecture
Support requirements analysis (IT counter apart)
Technical lead for all 3 modules (Frontend/Middleware/Backend)
Member (IT counter apart) of tool/partner decision team
Profil replacement (Frontend replacement of MS OLAP based Sales Information System): Technical Lead
ProSiebenSat.1 Applications GmbH
Main counter apart for all technical topics/issues
Define final architecture (Backend: SSAS/new Frontend: Arcplan/user rights DB: MS SQL DB)
Support requirements analysis (IT counter apart) and backend/frontend mappings
Coordinate development activities
Create authorization concept (matrix)
Member (IT counter apart) of tool/partner decision team
EUT for Admin Console
Project Pharos – Data integration framework (Hadoop, Spark, Spark SQL, Scala, Hive, MID Innovator, Data vault): Product Owner/
ProSiebenSat.1 Applications GmbH
Product owner tasks for new data integration platform (via Jira)
Data model definition for the first use cases (from Landing Zone till Raw Vault)
EUT and quality assurance
Project architecture decisions
Hard/soft rules definition
Define Continues Integration process and setup
Project Pharos – Rough architecture concept for new data integration platform (Data Lake(Raw Lake, Standard Lake) & DWH(Raw
ProSiebenSat.1 Applications GmbH
IS/SHOULD requirements analysis
Architecture model definition with the requirements and concerns
Business use cases: ratings and selection
Roadmap definition
PoC: Data Vault on Spark (Spark, Spark SQL, Scala, Hive)