• Data management and governance (SQL, data cleansing, ETL ( SSIS), DWH (MS SQL), API usage for data extraction, data visualization, data
  governance)

Data management and governance expert for following topics:

• Define the DWH architecture based on MS SQL
• Define data cleansing routines in ETL (SSIS)
• Develop ETL (SSIS) jobs for many APIs (startups, cloud platforms), Eurostat data, master data
• PoC for data quality tool selection
• data visualization
• data governance
• support for tool assessments

• Product Owner/manager for German DWH and Big data platform
  Topics:
  Operation /process stabilization & data quality monitoring system Implement new clearing supporting and performance reporting processes for real time campaigns, partner coupon assignment , PÜ-Weather data implementation
• Part of core team for Data Hub implementation
• Product Owner/manager for new analytics data platform (D ata Hub,Data C atalog)

Projects:
Data analytics platform (Programmatic Exports, AdS erver teaser evaluation): Product Owner/manager

• 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

• Define final requirements for data quality monitoring and data lineage in DWH (Oracle) and Smart data platform (Hadoop)
• Data model definition

Clearing reports and performance reporting for real time campaigns: Product Owner/manager

• Define final requirements for clearing reporting and performance reporting
• Process optimization analysis
• Improve communication with customers

Weather data integration for real time campaigns: Product Owner/manager

• Define final requirements
• Clarify the internal processes for external APIs (first use of external APIs for DWH team)

• Responsible for the projects in BI/Big data Container, from the requirements engineering part till operations overtaking (architecture,source system integrations, data marts, building up/extensions of new functionalities).
• Taking care of biz requirements and vendor quality/control management
• Define a data architecture for Data lake and DWH
• Define final architecture for all project phases
• Member of P7S1 architecture community board and P7S1 big data board.
• Product Owner of data integration framework (Hadoop, Spark, Spark SQL, Scala, Hive, MID I nnovator, Data vault)
• BI/Big Data architecture internal consultant for diverse projects (MediaFacts, Sales Information System,
  PortfolioCheck/CustomerFactSheet, Raw Data Hub, Analytics Cube, One Lake, etc.)
• Support Enterprise Architecture Management

Projects:
Project Pharos – Data integration framework (Hadoop, Spark, Spark SQL, Scala, Hive, MID Innovator, Data vault): Product Owner/ Lead Architect

• 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 Vault, Biz Vault, Data Marts)): Lead Architect

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

DWH Operation stabilization: Lead Architect

• Define stabilization activities
• Define architecture changes
• Support infrastructure and ETL adjustments

Staging implementation: Extend existing DWH: Technical Lead/Project Lead

• Define requirements and final architecture
• Review Solution design
• Coordinate project/development activities with external development team
• EUT definition and execution

Profil replacement (Frontend replacement of MS OLAP based Sales Information System): Technical Lead

• 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

MediaFacts – ProMefo replacement (TV coverage and rating analysis system): Technical Lead

• 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

Sales/CRM Reporting - PortfolioCheck/CustomerFactSheet (Internal project leader/Requirements analyst)

• End User requirements analysis
• Create a prototype based on 20 main customers
• Create detailed interface specifications and define transformation rules (Sales Force (CRM), ProCommit (Commitment system, Informix DB), Nielsen data (Advertising/Programming monitoring), Oracle DB)
• Support development phase, EUT, TRR/PRR
• Quality assurance
• Create End Reports (Business Objects)

Data Stage (ETL tool) migration (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)

• Project lead and architect for diverse IT projects: EBS replacement PDF solutions: New test data DB (Oracle) and frontend (Tibco Spotfire), Implement Master Data Process & System, EWIS electronic wafermap integrated system, Middleware
• Building up Microsoft based BI Suite (SSIS, Sharepoint, MS SQL DB, Power Pivot , Theobald ), Master data management (Master data services), Enterprise Service Bus (BizTalk)
• Building up Data Analytics Suite for data management of semiconductor test data (Tibco Spotfire, Oracle, Linux, PDF Solutions)
• Building up electronic wafermap integrated system ( SAP MD/SD, ABAP, Linux)
• Support Enterprise Architecture Management

Product cost calculation (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)

BizTalk middleware (Program manager)

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

Enterprise Architecture Management (Project leader)

• 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

SAP2Cloud (Project member)

• Unix/Linux data/scripts migration
• Label printer: SAP/Unix installation/setup

Master data management: Implement Master Data Process & System (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

EWIS – electronic wafermap integrated system (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)

EBS replacement - PDF solutions: New test data DB (Oracle) and frontend (Tibco Spotfire) (Project leader)

• 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 (based on Tibco Spotfire)
• Conduct administration training
• Organize end user training (worldwide)
• Data migration (from old to new database)
• Setup future IT operations for PDF Solutions

EBS Replacement Feasibility Study (Project team member from IT side)

• Define Lantiq specific requirements regarding new test data DB and application
• Identify potential software providers
• Evaluate potential software providers offers, create requirement profiles
• Define pilot candidates
• Decide which software will be taken (as pilot outcome)

B2B - Test Data Transfer Cleanup (Project leader)

• 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

Middleware replacement: IBM WebsphereMQ and Fujitsu OpenFT (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

B2B Supplier integration IFX (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

IT carve out project (team member)

• Central contact for all manufacturing/BI IT topics

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

• 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

• 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