Projekte
Sales History for APO DP – Data model re-design | |
Project | APO DP for business A |
Language | English, German |
Project assignment | Since 01/2015 |
Go-live | 03/2016 |
Responsibility | Technical lead in data model landscape Quality management Switch existing daily full loads to delta mode Complex custom error stack handling Know-How transfer to maintenance team |
BI Reporting for APO DP – changes in Henkel organisation
Project • HORIZON – organisational consolidation of source systems, move of plants and sales organisations in APO for Henkel Laundry/Beauty Care
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, German
Project assignment • Since 05/2016
Go-live • 07/2016 (wave 3) & 12/2016 (wave 4)
Responsibility • Cut over manager for BI reporting landscape of Beauty Care and Laundry
• Switch of reporting landscape to new organisation without changing/ corrupting output of reports
Release Upgrade BI 7.3
Project • Upgrade Enterprise Data Warehouse from BI 7.0 to BI 7.3
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 07/2015
Go-live • 07/2015
Responsibility • Technical lead consultant
• Lead offshore team
SCOUT reporting with MS BI
Project • Supply chain optimisation reporting for Henkel processes ‘Order to Cash’ and ‘Physical Distribution’
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 01/2014 – 12/2015
Go-live • 01/2015
Responsibility • Project lead for EDW part of SCOUT project
• Re-design and move of old BW3.5 reporting application SCORE to SCOUT reporting with MS BI via EDW
• Implementation of 90% of logic in EDW
• Connecting requested and confirmed order schedule lines with deliveries for Adhesives
• Connecting order item lines with deliveries for Beauty Care and Laundry
• Deliver enriched data structure to MS BI for reporting including most important KPIs like ‘perfect’, ‘fully delivered’, ‘in time’
• GoLive support and enhancement management
• Know-how transfer to maintenance team
SCOUT – Inventory Management
Project • Inventory Management for all Henkel businesses
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 01/2013 – 12/2015
Go-live • 01/2014
Responsibility • Project manager
• Complex data flow to harmonise Henkel stocks for reporting
• Using copy of standard extractor 2LIS_03_BX to get daily full stock information
• Stock calculation for harmonised stock per posting date
• Material movement harmonisation
EDW - Enterprise Data Warehouse – minor Roll-Outs for BI Applications
Project • Harmonisation landscape for different data flows in EDW
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 01/2010 – 12/2015
Go-live • successive
Project list • HORIZON – enhancement of existing landscapes for new source systems due to organisational changes within Henkel, extractor development on ECC side
• PURIS – implementation of purchasing data flows (2LIS_02)
• PP – production planning environment (2LIS_04)
• CO – controlling overhead-cost management (0CO_OM)
• CO – controlling product costing (0CO_PC)
• Financial Accounting General Ledger (0FI_GL)
• Account receivables (0FI_AR)
• Quality management (2LIS_05)
EDW - Enterprise Data Warehouse – Future Sales
Project • Global Enterprise DataWarehouse – development of new Future Sales concept, integration into existing landscape of COLOR
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 01/2011 – 07/2012
Go-live • 01/2012
Responsibility • Technical lead of EDW development in BI 7.x
• Template roll-out for all Business using same Future Sales function module
• Development of generic extractor for open orders and corresponding order conditions based on existing ECC report
• Consolidation into existing template of Profitability Analysis
• Harmonisation of all open order extracts into EDW template, re-calculation of open values of order items
Microsoft BI reporting using SAP BI extractors
Project • Provision of SAP BI extractors for several end customers, coaching and implementation
Client • pmOne AG, Unterschleißheim
Language • German
Project assignment • Since 04/2010
Responsibility • Analysis and consulting of SAP BI extractors based on end customer requirements using MS BI applications for reporting
• Provision of BusinessContent (LIS, CO, COPA, FI) and generic extractors
• Coaching
EDW - Enterprise Data Warehouse – enhancements for new BI strategy with Microsoft Business Intelligence
Project • Global Enterprise DataWarehouse – data harmonisation of Roll-outs of CO-PA, Controlling, SD, Purchasing and CRM for CPG business
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 01/2009 – 07/2012
Go-live • 01/2011 and more
Responsibility • Technical lead of EDW development in BI 7.0
• Connection of 14 R/3 systems and third party tools, provision of BusinessContent extractors, UserExits, generic extractors via function modules
• Global harmonisation of all CO-PA environments of Adhesives, Beauty Care and Laundry into one SAP BI 7.0 template for reporting applications GLOBIS and COLOR with MS BI
• Including all non-SAP companies into profitability analysis via file establishing delta functionalities
• Development and implementation of Overhead-cost Management and Product Costing data harmonisation
• Development and implementation of order items, invoice items, deliveries, schedule lines
• Switch from period data to year-to-date data and currency conversion
• Development and implementation of delta management with MS BI using Open Hub Destinations and web services
• Analyse Process Designer
EDW - Enterprise Data Warehouse
Project • EDW - Enterprise Data Warehouse – redesign of enterprise wide reporting landscape using one harmonized single point of truth
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 07/2007 – 01/2009
Go-live • 01/2008
Responsibility • Technical lead of EDW development in BI 7.0
• Development of conventions and methods for an Enterprise DataWarehouse
• Implementation of a tool set to implement and run an Enterprise DataWarehouse like own delta mechanism, InfoObject generator, hierachy copy functionality, flexible KPI mapping, text collector
• Global harmonisation of all CO-PA systems of Adhesives for new U-A reporting application OneLocalise (BW3.5)
• Special CO-PA topics like key generation, dirty flag, delta process for realignments, profit center derivation, BOM explosion and other complex logics of data harmonisation and consolidation
• Including all non-SAP companies of U-A via flat file
• Master data provision, BusinessContent, multiple classifications, complex sales partner derivation process
ToPlan – short-term profit planning with SAP BW/ SEM
Project • Global roll-out of planning application ToPlan for all Henkel business’ using SAP BW3.5/ SAP SEM
Client • Henkel Deutschland AG & Co. KgaA, Düsseldorf
Language • English, german
Project assignment • 01/2007 – 08/2008
Go-live • 04/2007 & 08/2007 & 08/2008
Responsibility • Technical lead of BW development in SAP BW 3.5
• Support in Strategic Enterprise Management, planning layouts and planning functions
• Complex data modelling for actual data and distribution of plans to several reporting systems
•
Support and operation of German reporting systems
Project • Support of German reporting systems - Sales Reporting Unilever Best Foods (UBF), CRM Reporting Best Foods, Sales Reporting Unilever Ice Cream and Frozem Food (ICF)
Client • Unilever Deutschland Services GmbH, Hamburg
Project assignment • 06/2006 – 12/2006
Responsibility • Technical lead of support, optimisation and enhancements in SAP BW 3.x
• Invoice items and order items, overhead-cost management, product costing
Enterprise DataWarehouse
Project • Implementation of an Enterprise DataWarehouse
Client • Barilla G.R. F.lli S.p.A, Parma, Italy
Language • English
Project assignment • 01/2006 – 06/2006
Responsibility • Implementation of methods for an Enterprise DataWarehouse in SAP BW 3.5
• Roll-out of LIS and CO BusinessContent extractors
• Roll-out of BusinessContent master data extractors•
Forecast Accuracy
Project • Development of a Forecast Accuracy Reporting of short- and middle-term sales planning and integration into EDW
Client • Barilla G.R. F.lli S.p.A, Parma, Italy
Language • English
Project assignment • 01/2006 – 05/2006
Go-live • 06/2006
Responsibility • Lead Consultant of special supply chain data mart architecture
• Development of function module for KPI calculation using historical data and plan data
• Implementation of extraction layer and consolidation layer
• Support of build phase
Trade Promotion Management Europe
Project • Development and Implementation of Trade Promotion Reporting, roll-out of German trade promotion planning using CRM application Siebel and data provision for European reporting with Business Objects.
Client • Unilever Deutschland Services GmbH, Hamburg
Project assignment • 08/2005 – 05/2006
Go-live • 20.12.2005
Responsibility • Lead consultant of BW development in SAP BW 3.5
• Conception and implementation of Trade Promotion Management for UBF (Unilever Best Foods) Germany reporting using BEx
• Data provision for European reporting using Business Objects, Integration into existing reporting landscape and enterprise wide KPI definitions
• Wave 2: roll-out TPME to HPC (Health & Personal Care) und ICF (Icecream und Frozen Food)
• Connection to Business Objects via Business Objects Data Integrator
• Consolidation with sales data process of invoice items, integration of baselines, promotional rebates and plan data
Real Estate controlling with SAP Business Warehouse
Project • Development and Implementation of a real estate reporting for Real Estate Management of Berliner Flughäfen (Non-Aviation)
Client • Berliner Flughäfen, Berlin
Language • German
Project assignment • 02/2005 – 06/2005
Go-live • 06/2005
Responsibility • Development and Implementation of data model for classical R/3 real estate controlling
• Provision of predefined reports using BEx Query Designer
• Revenue controlling (rental revenue, permissions), cost controlling (costs per real estate, service and maintenance), vacancy controlling
Sector integration with SAP Business Warehouse
Project • Integration of gas sector in reporting landscape of E.ON Edis (utility industry) and unbundling of network customers due to new legal situation
Client • E.ON e.dis, Teltow
Language • German
Project assignment • 12/2004 – 06/2005
Go-live • 06/2005
Responsibility • Identification, development and implementation of monitoring process of utility industry data using SAP Business Warehouse (SAP BW 3.x)
• Integration of gas sector
• Unbundling (split of power network customers and utility customers)
• Development of concession granting calculation and eco tax controlling
• Data modelling, IS-U extraction
Implementation of project system with SAP PS
Project • Implementation SAP PS
Client • VINCI Energies Deutschland, Ludwigshafen
Language • German
Project assignment • 07/2004 – 12/2004
Go-live • 01.01.2005
Responsibility • Development and Implementation of SAP PS
• Customizing of operative structures, status management, OS cash management, cost element percentage method, project rate, Easy Cost Planning
• Specification of development requirements (validation substitution)
• Project settlement, stock activation, results analysis
Management Information System – prototype for project cash flow reporting
Project • Development of prototype in SAP Business Warehouse for project cash flow reporting
Client • Eliniki Technodomiki AE, Athen, Greece
Language • English
Project assignment • 05/2004 – 11/2004
Responsibility • Lead Consultant
• Development of complete data flow and reports with BEx Query Designer to report costs/revenues and payments per project, customer or sub-contractor
• Customizing PS cash management
• Generic extractor to provide relevant project line items
• Process chains
Order processing and accounting using SAP SD
Project • Order processing of external sales for all operative units in Germany
Client • PeinigerRöRo GmbH, Gelsenkirchen
Language • German
Project assignment • 01/2004 – 04/2004
Go-live • 01.04.2004
Responsibility • Partial project leadership
• Analysis of processes
• Design, development and customizing of process flow of order and invoice processing in SAP SD
• Invoicing and invoice printing including service specifications, reversal of tax debts
• Integration of credit and risk management
• Training of operative units in Germany
• Authorizations
Equipment Tool Management
Project • Design and implementation of SAP ETM (CEM, part of EC&O) for logistic processing of devision falsework
Client • PeinigerRöRo GmbH, Gelsenkirchen
Project assignment • 09/2003 – 01/2004
Go-live • 01.01.2004
Responsibility • Design, customizing, identification of development efforts, documentation
• Change management
• Data migration of third party system CONCORDE (stocks)
• Customizing and migration of equipment master data, integration of MM máster data
• Customizing: stock definition, delivery notes, stock movements, ressource planning, equipment demands, calculative rental pricing, invoicing
• Training of operative units in Germany
• Invoice printing
Outsourcing IT-infrastructure
Project • Service specification, design of service level agreements,support of tender procedure and negotiation with Siemens Business Services as party tendering
Client • Siemens Building Technologies, Fürth, Germany
Project assignment • 06/2003 – 11/2003
Responsibility • Design, specification of service level agreements for service notebooks
• Design, specification of service level agreements for workstations, thin clients
• Outsourcing scenarios