data/dwh expert/product owner

7/2014 – 1/2015

Internal project leader; Quality assurance/Test manager:
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)

Datawarehouse / DWH

1/2014 – 7/2014

Project leader:

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

Microsoft Business Intelligence (BI)

11/2013 – 3/2014

Program manager:

- Mapping Biz Functions to IT applications
- Logical data flow charts per functional domain
- Document IT infrastructure and link to functional applications
- Biz evaluation of current tool support
- IT Roadmaps / needs for action list

Microsoft BizTalk Server

1/2013 – 9/2013

Project leader:
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

Microsoft Business Intelligence (BI)

6/2012 – 11/2012

Project leader, SAP based solution with 6 modules:

 Inbound module (with integrated data monitoring)
 E-map content module (content check, one setup per basic type and site). Only validated maps will be sent to the next site
 Outbound module (with enabled partial delivery capability)
 User interface (e-map hunter)
 Reporting module
 Archiving module (Saperion)

SAP Entwicklung (allg.)

9/2011 – 4/2012

Project leader, 1TB of data:
- Support installation of Application (dataPower)
- Prepare requirements documentation
- Define project team and coordinate with carve out activities
- Setup Data Loading/Preprocessing (ETL) together with software provider
- Standard Reports/scheduled jobs creation
- Conduct administration training
- Organize end user training (worldwide)
- Data migration (from old to new database)
- Setup future IT operations for PDF Solutions

TIBCO Spotfire

9/2011 – 3/2012

Project co-leader:
- 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

Projektmanagement (IT)

7/2011 – 10/2011

Project co-leader:
- 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

SAP PI

10/2010 – 2/2011

Data management activities (data consistency, optimisation, reporting, etc) for projects Ruwais 2 and Ruwais 3 (Oracle, MS Access, SQL, VB and Jasper Reports)