SAP BW, BI, BO, IP, BPC, HANA, Query-Design, WEBI, Analysis, FI, CO, IFRS, P&L, Plan, Budget, Forecast,
Aktualisiert am 23.02.2019
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.04.2019
Verfügbar zu: 100%
davon vor Ort: 100%
Deutsch
Muttersprache
Englisch
schriftlich und mündlich sehr gut, schon viele Projekte in Englisch, u.a. UK, Croatia, Norway

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz

Gerne auch europäisches Ausland, wenn Englisch die Projektsprache ist.

nicht möglich

Projekte

Projekte

1 Jahr 5 Monate
2017-04 - 2018-08

Extension of SAP BW 7.5 and BPC 10.1

Extension of SAP BW 7.5 and BPC 10.1 Embedded applications for S/4 HANA for ENGEL, Manufacturer of plastics machines, Schwertberg (Austria)

  • Sales Planning 2.0, Personal Planning 2.0 and Investment Planning 2.0: Extension of all 3 planning lines from 1-year-planning (ENGEL-Version 1.0, already built) to 3-year-planning (my part); more different workflows for bottom up- and top down-planning, more dialogue- and approval-steps
  • New BPC application for central control cockpit to monitor all planning processes: check list with tickboxes, maintaining master data, planning-participants and authorisations, calendar for planning-phases and deadlines, Version Management, starting workflow- and processchains for simple ‘events’ by key-user in the Central Controlling department
  • Redesign of Version Management to keep all planning lines on same level and to integrate latest approved planning figures;
  • Remodeling data model, extension and new Composite Providers, some more aDSO’s, adapting and building new data flows
  • Adapting and building more reports by BEx Query Designer, BO Analysis for Office and Design Studio in Eclipse-environment
  • Training, user test and go-live preparation
  • Working as Senior Consultant in SAP BI Competence Center for internal client Central Controlling
ENGEL
Schwertberg (Austria)
10 Monate
2016-05 - 2017-02

Greenfield implementation of BW 7.5 for S/4 HANA

Greenfield implementation of (SAP ECC, IS-Retail and) BW 7.5 for S/4 HANA

  • Developing data extraction and data flows on HANA database, especially from FI New General Ledger, CO-CCA (Cost Center Accounting, CO-PA (Profit Analysis), LIS-Structures and Non-SAP-Systems (e.g. ADABAS, POS);
  • Implementing backend-objects: Advanced DSO’s, Composite Provider, HANA-optimized InfoCubes, using Business Content adapting/ extending to customer-needs, using latest modelling-tool Eclipse
  • Developing more than 60 main reports and workbooks,  using Design Studio 1.6 and BEx Query Designer to deliver BO Advanced Analysis-reports (MS Excel) for Finance and Logistic; BO Web Intelligence Reports (HTML) as interface for central Hyperion consolidation system
  • Sometimes adaptions/programming directly in SQL and HTML to improve performance
  • Testing (UAT, Regression, Performance) using SAP Solution Manager and HP-Qualitysystem
  • Training more than 50 Business User in different departments direct on BO-AA-Reports
  • Go Live-support, especially solving authorisation- and performance-problems
  • Working within PRINCEII- and ITIL-Project-Framework for planning, change-requests  and weekly project-reporting
  • Working as functional and technical Consultant in a BW-Team of 4 full members, in cooperation with several Key Users from the client
Grand Vision/NL (Soesterberg) and Apollo/Germany (Schwabach) and Go Live-Support
8 Monate
2015-09 - 2016-04

Migration of International Cost Center- and Regional Center-Reporting

Migration of International Cost Center- and Regional Center-Reporting and -Planning from BW7.1/ BPC7.4 on BW7.4/BPC10.1 Embedded for S/4 HANA

  • Functional Design in cooperation with Lidl-Department for International Controlling
  • Redesign Reports, planning applications and -functions and data model
  • Technical Design within SAP Competence Center (IT): Techn. Data Model, data sources and data flows due to LSA++, using ADSO and Composite Provider
  • Specification parameter for planning sequences and -functions
  • Support BW and HANA Migration for technical migration team
  • Implementation of new data flows using Advanced DSO and Composite Provider
  • New implementation of planning applications within BPC 10.1 Embedded
  • Copy BEx Analyser reports, building new reports using BO Analysis and Design Studio
  • Building process chains for data loading
  • Different test procedures up to UAT and training of key user
  • Go-live-Support (March 2016), documentation
Lidl Stiftung (HQ)
Neckarsulm
11 Monate
2014-10 - 2015-08

BO-BPC Local Planning Applications and BO/MS-Analysis Reports

  • Adapting  BPC Planning and Forecast Templates for ABS- (Asset Backed Securities)
  • Investment Packages in USA (Detroit) using BPC Netweaver 10.0
  • Writing technical description for  implementation of local BPC Data Model and Data Flows within LSA++ Layers using performance benefits of HANA database
  • Developing special ABS-Reports for American market using BO/MS-Analysis Frontend: Vintage Loss Curves, Rating Reports and Forecast of payment streams
  • Working on local design guidelines to consider and hold general IT-Standards by small local, business-own developments/ changes in delivered BO-BPC applications
  • Training key user, supporting testing procedures (UAT), Go-Live and after Go-Live support
Daimler Financial Services in ABS area
Stuttgart, Detroit
1 Jahr 1 Monat
2013-09 - 2014-09

BO-BPC developments

Working with BO 4.1 and BPC 7.3, using Web Intelligence (WEBI) to configure Web Templates for Financial Reports  (Balance Statement, P&L) and Balance Scorecard Reports (using SKF KPI Handbook):

  • Import data from heterogeneous sources and HANA driven database
  • Adjustments within BI data access layer (BICS) to use BEx Analyser reports from other systems;
  • Adapting dataflows due to new LSA++ standards
  • Design and implement new BO Web Intelligence (WEBI) reports and import given BEx-Queries
  • Adding queries and other data providers (e.g. report-report-interfaces for drill-down analysis, combined queries, subqueries)
  • Configure custom templates, layouts, toolbars and table properties
  • Extending query panel functionality: nested query filters, ranking and hierarchy-charts
  • Conditional formatting, sections and breaks, grouping functions, snapshots, filters and variables
  • Linking to other portal documents with WebViewer, inserting hyperlinks for report distributions
  • Testing and go-life support
SKF Ball Bearings
Gothenburg and Schweinfurt
1 Jahr 5 Monate
2012-02 - 2013-06

Rollout ABS-templates (BI)

ABS = Asset Backed Securties, i.e. special kind of car-leasing- and car-credit-backed treasury bonds

  • Modelling of cash flow- and payment-streams, especially dataflows and Multiprovider, as extension of BI-Finance- and BI-CFM-templates, especially from data sources of  Cash Management(CM), Loans Management (CML) and Liquidity Planning (LP)
  • Working as Business Analyst: Conducting local workshops for gap-analysis and local change requests within FI- and CFM-area
  • Specification of country-driven adaptations of European Checks Conduit Workbooks, Vintage Loss Curves Work-books, Investor Reports, Risk Management Reports and other Workbooks
  • Consultation of local ABS-Operation-Teams for implementation of BI-templates (in FI- and CFM-area) as well as planning- and monthly reporting-processes using CM-, CML- and LP-data streams for BI-IP procedures and BEx-reports
  • Quality assurance of local project phases in FI- and CFM-area, considering international and local report-standards, delivering reliable, in-time Investor- and Management-Reports
  • Training: distribute and keep specific knowledge and experiences within VW Bank Group and their local sites: typical case-studies, writing and presentation of how-to-papers, conducting workshops and seminars
  • Reporting to central Auditor-Steering-Committee: activities, milestones, tests, certifications
  • Go-live-support (for escalated 3rd-level-cases, 1st-priority-failures) and preparing “Lesson learnt”-training-elements
VW-Bank mainly prepared from VW-Headquarters
Germany, Austria, France, Italy, Spain, Portugal, Milton Keynes
1 Jahr
2010-10 - 2011-09

Working on daily support-tickets

Support for BI 7.1
Support for BI 7.1

their SAP Support Center is outsourced and driven by Accenture Consulting, Denmark

  • Working on daily support-tickets: analyse and solve problems on 2nd and 3th level (using OSS)
  • Developing and change BI-Webreports, embedded at Velux-Portal, by Web Appl. Designer
  • Monitoring data-uploads, solving dataload-problems (especially within delta-uploads)
  • Maintenance of distribution- and calculation-routines within data source CO-PA
  • Maintenance process-chains for data-uploads
  • Maintenance of user, profiles, roles and authorisation-objects
  • Working on HP Quality Center (database and administration of test- and support-tasks)
VELUX (Manufacturer for Window-Frames)
Copenhagen
8 Monate
2009-11 - 2010-06

Go-live support for BI 7.1 and BI-IP within comprehensive SAP implementation

  • Analysing problems of developed Planning Applications using in collaboration with business departments and clients
  • Refinishing and corrections in Data Slices, Aggregation Levels and Filter; overhaul of some conditions andCharacteristic Relationships within Planning Parameters; some detailed corrections within Planning Functions; Documentation in Planning Handbooks
  • Quality assurance and adjusting data fields from main source CO-PA and within Transformation routines for data-upload into BI Info Provider
  • Corrections and extensions of calculation procedures in CO-PA
  • Specification and correction of KPI calculations (especially in cases using non-cumulative Key Figures)
  • Documentation in KPI Handbook
  • Version Mgmt. of Budget and Forecast Versions with special customer ABAP-programs
  • Training Enduser
  • Administration of running live system: maintenance of processchains and data uploadings, solving problems and planning locks, maintenance of BI-User and authorisations
  • Working on HP Quality Center (database and administration of test- and support-tasks)

Testing of developed Planning Applications in collaboration with Key Users:

  • Profit Center Sales Planning (using data from CO-PCA)
  • Joint Venture Planning (using data from CO-PA)
  • Cost Center Planning (using data from CO-CCA)
  • Balance and P&L Planning (using data from FI-GL New General Ledger)
  • Working Capital Planning (using data from CO-PA)

Mouchel Construction Company Group
Manchester, Woking, Milton Keynes
1 Jahr 3 Monate
2008-05 - 2009-07

Migration from BW 3.5 to Netweaver BI 7.0

Implementing planning applications with BI-IP;  web-dialogues and web-reporting within dot.Net-Portal

  • Project planning of migration-steps, especially changes of data flows and migration of historic actual data
  • Introducing design- and development-guidelines
  • Introducing layout-standards for planning and reporting (templates and formats)
  • Revision and optimization of data models and InfoCubes, implementation of several Multi-Provider, adaptation of data flows (e.g. Alpha conversion, DSO)
  • connecting to more Non-SAP data sources (using DB-connect, flat-files)
  • Specification of Cost Center Budget Planning and Sales Planning
  • Implementation of planning-areas, planning-functions, planning-sequences, planning-Layouts and  planning-roles using BI-IP (Integrated Planner) for Cost Center Budget Planning (using data from CO-CCA) and Sales Planning (data from CO-PA)
  • Specification of personalised planning-variables and User-Exits (ABAP-routines)
  • Conversion and adaptation of existing BEx-Analyser reports into web-reports
  • Implementation of new web reports due to planning templates with dialogue functions
  • working together with dot.Net experts for embedding report and planning applications into Yazaki dot.Net-Portal
  • Implementation of process-chains for data-upload (full- and delta-upload) and planning-procedures
  • Revision authorisation concept and customizing user roles and user profiles
  • Activation and using BI accelerator for performance tuning;
  • Go-live concept: area by area, training key user, administration and 2nd level-support after go live
  • Working as project lead with 2 internal BW developers and several key users
Yazaki Automotive-Supplier
Hemel-Hempstead, UK, and Cologne, Germany
8 Monate
2007-08 - 2008-03

BI and IP templates for European consolidated IFRS Reports

  • working on version Netweaver BI 7.0
  • Balance Statement and Profit&Loss reports due to IFRS: development of temp-lates. Using InfoSpokes due to audit and SOX requirements: unchangeable reports / figures after quarterly deadline and uploading quarterly reports by Holding-HQ at Munich (uploading local flat files produced by local InfoSpokes)
  • Support to build local FI and CO solutions to upload figures into local InfoCubes, after reconciliation into local Standard IFRS InfoCubes, then producing local flat files by InfoSpokes
  • Blueprint and implementation of European dataflow: upload local flat files into country-separated, but central InfoCubes (with same structure due to the Standard Data Model). Using MultiCubes to get consolidated IFRS-reports over all European Allianz Companies, including Segment Reports
  • Extension of IFRS Consolidation for Cash Flow Figures, Actuarial and Statistical Figures as well as Sales Figures: Implementing similar procedures for other InfoAreas (pattern: feed local Info Cubes, produce flat files by local InfoSpokes, upload flat files into central InfoCubes at deadline, get the whole picture by MultiCubes)
  • - Implementing Planning and Forecast functions, using BI Integrated Planning (BI-IP) for IFRS figures
  • Implementing Templates for Planning Folders and Planning Layouts
  • Allianz-specific variables (custom-made, with user-exits, i.e. ABAP routines) to feed special Characteristics and Key Figures
  • Dynamic BI Web Reports (input queries) to work on and reconcile plan data
  • Planning Functions to consider typical trends from the past
  • Support for Roll Out in several European Countries: Presentation, Training and 2nd level support during local development and Go-live
Allianz Insurance Holding
Munich
11 Monate
2006-08 - 2007-06

BW and BPS solutions to control Oil Production Fields and Credit Management

  • Specification of planning and report requirements to control Oil Production Fields: History of Production Licenses given by Scandinavian governments; Volumes of Oil Fields and Areas; Shareowners and quotes of shares; geologic realities; contracts, conditions and deadlines; yearly planning of investments and licenses fees; quarterly forecasts of volumes; monthly actual reports of flow rates
  • Specification of requirements for Credit Management: ABC classification of customers; Volumes and values of running orders; credit lines and backstops; using data from SAP Retail, SAP Finance and other Non-SAP-applications
  • Complete development cycle in both areas from backend to frontend: data sources, uploading, reports, planning areas and planning functions

More detailed:

  • Blueprint of planning and report processes, functional specification and data modelling (Characteristics and Key Figures); Presentation to project lead and directors for “GB-DB”-approval (“Go and build within deadline and budget !”);
  • Constructing data transfer structures and update rules by BW workbench
  • Constructing InfoCubes and MultiCubes
  • Implementation dataflow, using Full Upload as well as Delta Upload
  • Implementation of planning functions and dialogues
  • Designing of around 50 BW reports by Web Application Designer for different user-groups
  • Working together with dot.net-developers to publish BW reports in Statoil Global Management Portal, as well as BPS dialogues within same portal
  • Go live activities: authorisation-concept (within given frame), testing, training, start-up of data loading and maintenance-routines
  • working on latest 7.0 Netweaver-BW-release
Statoil
Norway, Stavanger, Bergen
5 Monate
2006-02 - 2006-06

BW Financial Report developments due to SOX

  • Functional specifications of BW Financial Reports and KPI’s in workshops with financial departments, e.g.
  • Account balances and calculations for levelling time-lags and special effects due to SOX
  • Rebates and Discounts
  • Blocked and late payments
  • Using data sources from SAP R/3 General Ledger, Special Ledger, Accounts Payable, Accounts Receivable and flat files
  • Activating Business Content and customisation of dataflow, info providers and web reports within given Shell Standards, using always PSA, ODS, MultiCubes and Web Templates. Specification of user-exits for ABAP developments
  • Assigning roles to Shell Authorisation Profiles.
  • Within Global Standard SAP Rollout 2nd level support for Hungarian BW Web Reports
Shell Oil and Gas
London
8 Monate
2005-05 - 2005-12

Implementation of BW and SEM-BPS

  • My team did Blueprint, Detailed Design and implementation of BW Reporting for Financial and Controlling Area
  • We activated mostly Business Content, customised PSA, ODS, InfoCubes, data flow, data transfer rules and update rules
  • We designed Web Reports using Web Application Designer and publishing Web Reports on INA Intranet
  • In BPS we implemented planning areas, planning functions and planning layouts for Balance Statement Planning and Profit Centre planning, summarised to business segment planning
  • We used these plan figures and actual figures in deeper levels for IFRS Reporting 
  • As Team lead of 6 members I was responsible for concept and guidelines, how to picture Oil and Gas Business in BW and BPS
  • I was responsible for detailed project-steps, capacities, budget-controlling and quality assurance
  • Furthermore I did interviews to choose appropriate external BW consultants and INA-internal team members
  • Along with these typical team lead-tasks I did hands-on customising and report-design during some peak-phases to reach given deadlines
  • After GoLive we did training of Key Users and supported BW monitoring by INA IT Department
  • We implemented BW-Release 3.5
INA d.d. (Croatian Oil & Gas Company)
Zagreb
1 Jahr
2004-03 - 2005-02

Implementation of BW and SEM-BPS Templates in different European countries

For Planning, Consensus Forecast and Corporate Reporting of Sales and Cost Figures we implemented BW InfoCubes and Web Reports together with BPS Planning Functions. Starting with GSK European Standard Templates of first implementation in Italy we prepared Roll Out for Denmark, Poland, Netherlands and Germany. For each country we used the same project cycle of workshops, country-side adapting and enhancements, training and testing and final Go Live. We made specifications for ABAP-, HTML- and iViews-Programming for User Exits and Layouts. We designed Report Layouts and Planning Folders by SAP Web Application Designer for publishing on SAP Enterprise Portal 6.0.

 

We worked on following InfoCubes and assigned Web Reports:

  • CO-PA Data
  • Cost Center Accounting
  • ENS Planning (external data)
  • (Country-side) Planning Data
  • Consensus Planning
  • Adjusted Volume Forecast
  • History Actuals

 

In SEM-BPS we adapted following Planning Area Templates to each country:

Sales Planning:

  • Country Sales Targets
  • Top Down Distribution – Plan Year
  • Sales Manager – Following Year
  • Sales Manager – Current Year
  • Plan Prices – Current Year
  • Calculation Rolling Planning
  • Quantities – Following Year
  • Distribution Rolling Planning
  • Calculation Rolling Planning
  • Forecast
  • Adjustment Plan – Actual

 

Cost Planning:

  • Statistical Key Figures
  • Cost Center Accounting
  • Cost Driver
  • Prices
  • Primary Costs
  • Secondary Costs
  • Core Planning

 

As Team Leader for Consensus Forecast I maintained Data Models and Data Flow of InfoCubes as well as Planning Levels of Planning Areas. Furthermore I advised 2 colleagues of my team how to adapt GSK European Templates to country-side requirements, using BW Administrator Workbench and BPS Planning Workbench. Furthermore I developed standard procedures for Change Requests in Design of Business Requirements (BR), country-side Local Additional Developments (LAD), Training Key User (TKU) and User Acceptance Tests (UAT). I developed a lot of country-side Web Reports by BW Web Application Designer.

We used SAP Releases BW 3.1 A and SEM-BPS 3.1 B

GlaxoSmithKline Pharmaceutical Group
London
3 Monate
2003-12 - 2004-02

Analysing of Italy-Templates

  • Kuwait Petroleum Italy went live with all SAP Financial-, Logistic modules, IS-Oil and BW 3.1 (with 32 Info-Cubes) at 2003. It is now to Kuwait Petroleum Benelux to follow up, using Italy-templates, adapted to additional Benelux business requirements
  • These additional requirements are analysed and specified in workshops with Benelux staff
  • For my part I have to discuss with responsible controller the Italy BW data model to enhance to Benelux business, even to enhance the "Italy"-InfoCubes
  • Finally the blueprint, project plan and budget for BW 3.1 implementation would be determined
IS-Oil- and BW-Implementation
Kuwait Petroleum Benelux, Rotterdam

Aus- und Weiterbildung

Aus- und Weiterbildung

1982
Abitur

1989
Examen als Diplom-Kaufmann an der Universität Köln
Schwerpunktfächer: Informatik, Organisation, Versicherungsbetriebslehre

seit 1990
zahlreiche DV- und SAP-Seminare

12/1997
FI/CO-Zertifizierung in Walldorf

06/2002
BW-Zertifizierung in Walldorf

Kompetenzen

Kompetenzen

Produkte / Standards / Erfahrungen / Methoden

Main skills:

  • Profound knowledge in conceptional design and implementation of BW/BI/BO and Business Planning applications with BI-IP and BO-BPC at all stages of the project lifecycle, especially in Finance and Controlling, as well how to integrate other SAP- and Non-SAP-applications
  • MBA-education and practical knowledge of Accounting and Controlling business processes, as well as planning and reporting procedures, from theoretical approaches to functional implementation (e.g. IFRS, SOX, KPIs, MbO, top down and bottom up);
  • Working on HANA in-memory Database, modelling and building data layers due to LSA++
  • Building reports by Design Studio, BEx Query Designer, BO Advanced Analysis and BO Web Intelligence (WEBI)
  • Strong business background as Business Analyst: strong workshop facilitation skills, gathering requirements and mind-mapping
  • Coordination and review of impact assessments, good attention to relevant details, nevertheless strong ability to get the big picture
  • In-depth understanding of the functional and technical processes in FI, CO, CFM, BI Netweaver, BI-IP and BO-BPC on HANA environment
  • Highly evolved interpersonal, communication and project management skills and practical experiences in Prince II, ITIL and Agile with Scrum
  • Ability and experience in leading, mentoring and training team members and key user
  • Working already more than 21 years in Finance, Controlling, BI and IT within SAP environments, nearly 20 years as freelance and certified SAP consultant

Career:

1990 - 1992

Junior consultant of Debis House of Systems (Daimler Group), Stuttgart:

Working on IT-projects for Deutsche Bank Life Insurance AG, Wiesbaden (near Frankfurt-Main) and for IBM London: Participation in development of new platform Insurance Application Architecture (IAA) in London and Brussels, in cooperation with Hoskyns plc., London

03/1992 - 03/1996

Deutscher Ring Insurance Group, Hamburg, Cologne

Controller and team lead, responsible for Cost Center Accounting and controlling of IT projects; reporting directly to executive board, Hamburg;

 

04/1996 - 09/1997

Deutscher Ring Insurance Group, Hamburg, Cologne

Head of department for Finance and Accounting at OVB AG, Cologne, an international distribution  and sales company group, owned largely by Deutscher Ring.

Due to this function also project lead for implementation of SAP R/3 FI and CO.                        

since 11/1997

Freelance, certified SAP R/3-Consultant for FI and CO

 

since 06/2002

Freelance, certified SAP-Consultant for BW and BPS

Betriebssysteme

MS-DOS
Grundkenntnisse
Windows
Grundkenntnisse

Programmiersprachen

ABAP4
Grundkenntnisse für Programmierung von Reports, einfache User-Exits
Basic
Grundkenntnisse
Cobol
Grundkenntnisse
PL/1
Grundkenntnisse
PL/SQL
Grundkenntnisse

Datenbanken

Access
Grundkenntnisse
DB2
Grundkenntnisse
MS SQL Server
Grundkenntnisse
Oracle
mittlere Kenntnisse (u.a. Clusterung)
Kenne auch Methoden der Datenmodellierung, u.a. Entity-Relationship-Diagramme; ebenso Normalisierung, performante DB-Abfragen (z.B. mit SQL), usw.
Gerade in BW ist die Datenmodellierung der Merkmale und Kennzahlen von hoher Bedeutung, u.a. für die spätere Performance und Antwortzeiten von Queries.

Datenkommunikation

RFC
Datenanforderung für Upload in SAP-BW

Hardware

FileNet
Grundkenntnisse Image-Verarbeitung
Grundkenntnisse IXOS-Archivsystem

Design / Entwicklung / Konstruktion

BI Architecture
Blueprint
Data Modeling
Dataflow Diagrams
Functional Design
Specification of User Exits and other ABAP-Routines
Technical Design
Workshops

Branchen

Branchen

Pharma, Mineralöl, Handel (grosse Handelsketten), Industrie (Elektronik, Gußeisen, Papier), Versicherungen, Banken, Automotive

Einsatzorte

Einsatzorte

Deutschland, Österreich, Schweiz

Gerne auch europäisches Ausland, wenn Englisch die Projektsprache ist.

nicht möglich

Projekte

Projekte

1 Jahr 5 Monate
2017-04 - 2018-08

Extension of SAP BW 7.5 and BPC 10.1

Extension of SAP BW 7.5 and BPC 10.1 Embedded applications for S/4 HANA for ENGEL, Manufacturer of plastics machines, Schwertberg (Austria)

  • Sales Planning 2.0, Personal Planning 2.0 and Investment Planning 2.0: Extension of all 3 planning lines from 1-year-planning (ENGEL-Version 1.0, already built) to 3-year-planning (my part); more different workflows for bottom up- and top down-planning, more dialogue- and approval-steps
  • New BPC application for central control cockpit to monitor all planning processes: check list with tickboxes, maintaining master data, planning-participants and authorisations, calendar for planning-phases and deadlines, Version Management, starting workflow- and processchains for simple ‘events’ by key-user in the Central Controlling department
  • Redesign of Version Management to keep all planning lines on same level and to integrate latest approved planning figures;
  • Remodeling data model, extension and new Composite Providers, some more aDSO’s, adapting and building new data flows
  • Adapting and building more reports by BEx Query Designer, BO Analysis for Office and Design Studio in Eclipse-environment
  • Training, user test and go-live preparation
  • Working as Senior Consultant in SAP BI Competence Center for internal client Central Controlling
ENGEL
Schwertberg (Austria)
10 Monate
2016-05 - 2017-02

Greenfield implementation of BW 7.5 for S/4 HANA

Greenfield implementation of (SAP ECC, IS-Retail and) BW 7.5 for S/4 HANA

  • Developing data extraction and data flows on HANA database, especially from FI New General Ledger, CO-CCA (Cost Center Accounting, CO-PA (Profit Analysis), LIS-Structures and Non-SAP-Systems (e.g. ADABAS, POS);
  • Implementing backend-objects: Advanced DSO’s, Composite Provider, HANA-optimized InfoCubes, using Business Content adapting/ extending to customer-needs, using latest modelling-tool Eclipse
  • Developing more than 60 main reports and workbooks,  using Design Studio 1.6 and BEx Query Designer to deliver BO Advanced Analysis-reports (MS Excel) for Finance and Logistic; BO Web Intelligence Reports (HTML) as interface for central Hyperion consolidation system
  • Sometimes adaptions/programming directly in SQL and HTML to improve performance
  • Testing (UAT, Regression, Performance) using SAP Solution Manager and HP-Qualitysystem
  • Training more than 50 Business User in different departments direct on BO-AA-Reports
  • Go Live-support, especially solving authorisation- and performance-problems
  • Working within PRINCEII- and ITIL-Project-Framework for planning, change-requests  and weekly project-reporting
  • Working as functional and technical Consultant in a BW-Team of 4 full members, in cooperation with several Key Users from the client
Grand Vision/NL (Soesterberg) and Apollo/Germany (Schwabach) and Go Live-Support
8 Monate
2015-09 - 2016-04

Migration of International Cost Center- and Regional Center-Reporting

Migration of International Cost Center- and Regional Center-Reporting and -Planning from BW7.1/ BPC7.4 on BW7.4/BPC10.1 Embedded for S/4 HANA

  • Functional Design in cooperation with Lidl-Department for International Controlling
  • Redesign Reports, planning applications and -functions and data model
  • Technical Design within SAP Competence Center (IT): Techn. Data Model, data sources and data flows due to LSA++, using ADSO and Composite Provider
  • Specification parameter for planning sequences and -functions
  • Support BW and HANA Migration for technical migration team
  • Implementation of new data flows using Advanced DSO and Composite Provider
  • New implementation of planning applications within BPC 10.1 Embedded
  • Copy BEx Analyser reports, building new reports using BO Analysis and Design Studio
  • Building process chains for data loading
  • Different test procedures up to UAT and training of key user
  • Go-live-Support (March 2016), documentation
Lidl Stiftung (HQ)
Neckarsulm
11 Monate
2014-10 - 2015-08

BO-BPC Local Planning Applications and BO/MS-Analysis Reports

  • Adapting  BPC Planning and Forecast Templates for ABS- (Asset Backed Securities)
  • Investment Packages in USA (Detroit) using BPC Netweaver 10.0
  • Writing technical description for  implementation of local BPC Data Model and Data Flows within LSA++ Layers using performance benefits of HANA database
  • Developing special ABS-Reports for American market using BO/MS-Analysis Frontend: Vintage Loss Curves, Rating Reports and Forecast of payment streams
  • Working on local design guidelines to consider and hold general IT-Standards by small local, business-own developments/ changes in delivered BO-BPC applications
  • Training key user, supporting testing procedures (UAT), Go-Live and after Go-Live support
Daimler Financial Services in ABS area
Stuttgart, Detroit
1 Jahr 1 Monat
2013-09 - 2014-09

BO-BPC developments

Working with BO 4.1 and BPC 7.3, using Web Intelligence (WEBI) to configure Web Templates for Financial Reports  (Balance Statement, P&L) and Balance Scorecard Reports (using SKF KPI Handbook):

  • Import data from heterogeneous sources and HANA driven database
  • Adjustments within BI data access layer (BICS) to use BEx Analyser reports from other systems;
  • Adapting dataflows due to new LSA++ standards
  • Design and implement new BO Web Intelligence (WEBI) reports and import given BEx-Queries
  • Adding queries and other data providers (e.g. report-report-interfaces for drill-down analysis, combined queries, subqueries)
  • Configure custom templates, layouts, toolbars and table properties
  • Extending query panel functionality: nested query filters, ranking and hierarchy-charts
  • Conditional formatting, sections and breaks, grouping functions, snapshots, filters and variables
  • Linking to other portal documents with WebViewer, inserting hyperlinks for report distributions
  • Testing and go-life support
SKF Ball Bearings
Gothenburg and Schweinfurt
1 Jahr 5 Monate
2012-02 - 2013-06

Rollout ABS-templates (BI)

ABS = Asset Backed Securties, i.e. special kind of car-leasing- and car-credit-backed treasury bonds

  • Modelling of cash flow- and payment-streams, especially dataflows and Multiprovider, as extension of BI-Finance- and BI-CFM-templates, especially from data sources of  Cash Management(CM), Loans Management (CML) and Liquidity Planning (LP)
  • Working as Business Analyst: Conducting local workshops for gap-analysis and local change requests within FI- and CFM-area
  • Specification of country-driven adaptations of European Checks Conduit Workbooks, Vintage Loss Curves Work-books, Investor Reports, Risk Management Reports and other Workbooks
  • Consultation of local ABS-Operation-Teams for implementation of BI-templates (in FI- and CFM-area) as well as planning- and monthly reporting-processes using CM-, CML- and LP-data streams for BI-IP procedures and BEx-reports
  • Quality assurance of local project phases in FI- and CFM-area, considering international and local report-standards, delivering reliable, in-time Investor- and Management-Reports
  • Training: distribute and keep specific knowledge and experiences within VW Bank Group and their local sites: typical case-studies, writing and presentation of how-to-papers, conducting workshops and seminars
  • Reporting to central Auditor-Steering-Committee: activities, milestones, tests, certifications
  • Go-live-support (for escalated 3rd-level-cases, 1st-priority-failures) and preparing “Lesson learnt”-training-elements
VW-Bank mainly prepared from VW-Headquarters
Germany, Austria, France, Italy, Spain, Portugal, Milton Keynes
1 Jahr
2010-10 - 2011-09

Working on daily support-tickets

Support for BI 7.1
Support for BI 7.1

their SAP Support Center is outsourced and driven by Accenture Consulting, Denmark

  • Working on daily support-tickets: analyse and solve problems on 2nd and 3th level (using OSS)
  • Developing and change BI-Webreports, embedded at Velux-Portal, by Web Appl. Designer
  • Monitoring data-uploads, solving dataload-problems (especially within delta-uploads)
  • Maintenance of distribution- and calculation-routines within data source CO-PA
  • Maintenance process-chains for data-uploads
  • Maintenance of user, profiles, roles and authorisation-objects
  • Working on HP Quality Center (database and administration of test- and support-tasks)
VELUX (Manufacturer for Window-Frames)
Copenhagen
8 Monate
2009-11 - 2010-06

Go-live support for BI 7.1 and BI-IP within comprehensive SAP implementation

  • Analysing problems of developed Planning Applications using in collaboration with business departments and clients
  • Refinishing and corrections in Data Slices, Aggregation Levels and Filter; overhaul of some conditions andCharacteristic Relationships within Planning Parameters; some detailed corrections within Planning Functions; Documentation in Planning Handbooks
  • Quality assurance and adjusting data fields from main source CO-PA and within Transformation routines for data-upload into BI Info Provider
  • Corrections and extensions of calculation procedures in CO-PA
  • Specification and correction of KPI calculations (especially in cases using non-cumulative Key Figures)
  • Documentation in KPI Handbook
  • Version Mgmt. of Budget and Forecast Versions with special customer ABAP-programs
  • Training Enduser
  • Administration of running live system: maintenance of processchains and data uploadings, solving problems and planning locks, maintenance of BI-User and authorisations
  • Working on HP Quality Center (database and administration of test- and support-tasks)

Testing of developed Planning Applications in collaboration with Key Users:

  • Profit Center Sales Planning (using data from CO-PCA)
  • Joint Venture Planning (using data from CO-PA)
  • Cost Center Planning (using data from CO-CCA)
  • Balance and P&L Planning (using data from FI-GL New General Ledger)
  • Working Capital Planning (using data from CO-PA)

Mouchel Construction Company Group
Manchester, Woking, Milton Keynes
1 Jahr 3 Monate
2008-05 - 2009-07

Migration from BW 3.5 to Netweaver BI 7.0

Implementing planning applications with BI-IP;  web-dialogues and web-reporting within dot.Net-Portal

  • Project planning of migration-steps, especially changes of data flows and migration of historic actual data
  • Introducing design- and development-guidelines
  • Introducing layout-standards for planning and reporting (templates and formats)
  • Revision and optimization of data models and InfoCubes, implementation of several Multi-Provider, adaptation of data flows (e.g. Alpha conversion, DSO)
  • connecting to more Non-SAP data sources (using DB-connect, flat-files)
  • Specification of Cost Center Budget Planning and Sales Planning
  • Implementation of planning-areas, planning-functions, planning-sequences, planning-Layouts and  planning-roles using BI-IP (Integrated Planner) for Cost Center Budget Planning (using data from CO-CCA) and Sales Planning (data from CO-PA)
  • Specification of personalised planning-variables and User-Exits (ABAP-routines)
  • Conversion and adaptation of existing BEx-Analyser reports into web-reports
  • Implementation of new web reports due to planning templates with dialogue functions
  • working together with dot.Net experts for embedding report and planning applications into Yazaki dot.Net-Portal
  • Implementation of process-chains for data-upload (full- and delta-upload) and planning-procedures
  • Revision authorisation concept and customizing user roles and user profiles
  • Activation and using BI accelerator for performance tuning;
  • Go-live concept: area by area, training key user, administration and 2nd level-support after go live
  • Working as project lead with 2 internal BW developers and several key users
Yazaki Automotive-Supplier
Hemel-Hempstead, UK, and Cologne, Germany
8 Monate
2007-08 - 2008-03

BI and IP templates for European consolidated IFRS Reports

  • working on version Netweaver BI 7.0
  • Balance Statement and Profit&Loss reports due to IFRS: development of temp-lates. Using InfoSpokes due to audit and SOX requirements: unchangeable reports / figures after quarterly deadline and uploading quarterly reports by Holding-HQ at Munich (uploading local flat files produced by local InfoSpokes)
  • Support to build local FI and CO solutions to upload figures into local InfoCubes, after reconciliation into local Standard IFRS InfoCubes, then producing local flat files by InfoSpokes
  • Blueprint and implementation of European dataflow: upload local flat files into country-separated, but central InfoCubes (with same structure due to the Standard Data Model). Using MultiCubes to get consolidated IFRS-reports over all European Allianz Companies, including Segment Reports
  • Extension of IFRS Consolidation for Cash Flow Figures, Actuarial and Statistical Figures as well as Sales Figures: Implementing similar procedures for other InfoAreas (pattern: feed local Info Cubes, produce flat files by local InfoSpokes, upload flat files into central InfoCubes at deadline, get the whole picture by MultiCubes)
  • - Implementing Planning and Forecast functions, using BI Integrated Planning (BI-IP) for IFRS figures
  • Implementing Templates for Planning Folders and Planning Layouts
  • Allianz-specific variables (custom-made, with user-exits, i.e. ABAP routines) to feed special Characteristics and Key Figures
  • Dynamic BI Web Reports (input queries) to work on and reconcile plan data
  • Planning Functions to consider typical trends from the past
  • Support for Roll Out in several European Countries: Presentation, Training and 2nd level support during local development and Go-live
Allianz Insurance Holding
Munich
11 Monate
2006-08 - 2007-06

BW and BPS solutions to control Oil Production Fields and Credit Management

  • Specification of planning and report requirements to control Oil Production Fields: History of Production Licenses given by Scandinavian governments; Volumes of Oil Fields and Areas; Shareowners and quotes of shares; geologic realities; contracts, conditions and deadlines; yearly planning of investments and licenses fees; quarterly forecasts of volumes; monthly actual reports of flow rates
  • Specification of requirements for Credit Management: ABC classification of customers; Volumes and values of running orders; credit lines and backstops; using data from SAP Retail, SAP Finance and other Non-SAP-applications
  • Complete development cycle in both areas from backend to frontend: data sources, uploading, reports, planning areas and planning functions

More detailed:

  • Blueprint of planning and report processes, functional specification and data modelling (Characteristics and Key Figures); Presentation to project lead and directors for “GB-DB”-approval (“Go and build within deadline and budget !”);
  • Constructing data transfer structures and update rules by BW workbench
  • Constructing InfoCubes and MultiCubes
  • Implementation dataflow, using Full Upload as well as Delta Upload
  • Implementation of planning functions and dialogues
  • Designing of around 50 BW reports by Web Application Designer for different user-groups
  • Working together with dot.net-developers to publish BW reports in Statoil Global Management Portal, as well as BPS dialogues within same portal
  • Go live activities: authorisation-concept (within given frame), testing, training, start-up of data loading and maintenance-routines
  • working on latest 7.0 Netweaver-BW-release
Statoil
Norway, Stavanger, Bergen
5 Monate
2006-02 - 2006-06

BW Financial Report developments due to SOX

  • Functional specifications of BW Financial Reports and KPI’s in workshops with financial departments, e.g.
  • Account balances and calculations for levelling time-lags and special effects due to SOX
  • Rebates and Discounts
  • Blocked and late payments
  • Using data sources from SAP R/3 General Ledger, Special Ledger, Accounts Payable, Accounts Receivable and flat files
  • Activating Business Content and customisation of dataflow, info providers and web reports within given Shell Standards, using always PSA, ODS, MultiCubes and Web Templates. Specification of user-exits for ABAP developments
  • Assigning roles to Shell Authorisation Profiles.
  • Within Global Standard SAP Rollout 2nd level support for Hungarian BW Web Reports
Shell Oil and Gas
London
8 Monate
2005-05 - 2005-12

Implementation of BW and SEM-BPS

  • My team did Blueprint, Detailed Design and implementation of BW Reporting for Financial and Controlling Area
  • We activated mostly Business Content, customised PSA, ODS, InfoCubes, data flow, data transfer rules and update rules
  • We designed Web Reports using Web Application Designer and publishing Web Reports on INA Intranet
  • In BPS we implemented planning areas, planning functions and planning layouts for Balance Statement Planning and Profit Centre planning, summarised to business segment planning
  • We used these plan figures and actual figures in deeper levels for IFRS Reporting 
  • As Team lead of 6 members I was responsible for concept and guidelines, how to picture Oil and Gas Business in BW and BPS
  • I was responsible for detailed project-steps, capacities, budget-controlling and quality assurance
  • Furthermore I did interviews to choose appropriate external BW consultants and INA-internal team members
  • Along with these typical team lead-tasks I did hands-on customising and report-design during some peak-phases to reach given deadlines
  • After GoLive we did training of Key Users and supported BW monitoring by INA IT Department
  • We implemented BW-Release 3.5
INA d.d. (Croatian Oil & Gas Company)
Zagreb
1 Jahr
2004-03 - 2005-02

Implementation of BW and SEM-BPS Templates in different European countries

For Planning, Consensus Forecast and Corporate Reporting of Sales and Cost Figures we implemented BW InfoCubes and Web Reports together with BPS Planning Functions. Starting with GSK European Standard Templates of first implementation in Italy we prepared Roll Out for Denmark, Poland, Netherlands and Germany. For each country we used the same project cycle of workshops, country-side adapting and enhancements, training and testing and final Go Live. We made specifications for ABAP-, HTML- and iViews-Programming for User Exits and Layouts. We designed Report Layouts and Planning Folders by SAP Web Application Designer for publishing on SAP Enterprise Portal 6.0.

 

We worked on following InfoCubes and assigned Web Reports:

  • CO-PA Data
  • Cost Center Accounting
  • ENS Planning (external data)
  • (Country-side) Planning Data
  • Consensus Planning
  • Adjusted Volume Forecast
  • History Actuals

 

In SEM-BPS we adapted following Planning Area Templates to each country:

Sales Planning:

  • Country Sales Targets
  • Top Down Distribution – Plan Year
  • Sales Manager – Following Year
  • Sales Manager – Current Year
  • Plan Prices – Current Year
  • Calculation Rolling Planning
  • Quantities – Following Year
  • Distribution Rolling Planning
  • Calculation Rolling Planning
  • Forecast
  • Adjustment Plan – Actual

 

Cost Planning:

  • Statistical Key Figures
  • Cost Center Accounting
  • Cost Driver
  • Prices
  • Primary Costs
  • Secondary Costs
  • Core Planning

 

As Team Leader for Consensus Forecast I maintained Data Models and Data Flow of InfoCubes as well as Planning Levels of Planning Areas. Furthermore I advised 2 colleagues of my team how to adapt GSK European Templates to country-side requirements, using BW Administrator Workbench and BPS Planning Workbench. Furthermore I developed standard procedures for Change Requests in Design of Business Requirements (BR), country-side Local Additional Developments (LAD), Training Key User (TKU) and User Acceptance Tests (UAT). I developed a lot of country-side Web Reports by BW Web Application Designer.

We used SAP Releases BW 3.1 A and SEM-BPS 3.1 B

GlaxoSmithKline Pharmaceutical Group
London
3 Monate
2003-12 - 2004-02

Analysing of Italy-Templates

  • Kuwait Petroleum Italy went live with all SAP Financial-, Logistic modules, IS-Oil and BW 3.1 (with 32 Info-Cubes) at 2003. It is now to Kuwait Petroleum Benelux to follow up, using Italy-templates, adapted to additional Benelux business requirements
  • These additional requirements are analysed and specified in workshops with Benelux staff
  • For my part I have to discuss with responsible controller the Italy BW data model to enhance to Benelux business, even to enhance the "Italy"-InfoCubes
  • Finally the blueprint, project plan and budget for BW 3.1 implementation would be determined
IS-Oil- and BW-Implementation
Kuwait Petroleum Benelux, Rotterdam

Aus- und Weiterbildung

Aus- und Weiterbildung

1982
Abitur

1989
Examen als Diplom-Kaufmann an der Universität Köln
Schwerpunktfächer: Informatik, Organisation, Versicherungsbetriebslehre

seit 1990
zahlreiche DV- und SAP-Seminare

12/1997
FI/CO-Zertifizierung in Walldorf

06/2002
BW-Zertifizierung in Walldorf

Kompetenzen

Kompetenzen

Produkte / Standards / Erfahrungen / Methoden

Main skills:

  • Profound knowledge in conceptional design and implementation of BW/BI/BO and Business Planning applications with BI-IP and BO-BPC at all stages of the project lifecycle, especially in Finance and Controlling, as well how to integrate other SAP- and Non-SAP-applications
  • MBA-education and practical knowledge of Accounting and Controlling business processes, as well as planning and reporting procedures, from theoretical approaches to functional implementation (e.g. IFRS, SOX, KPIs, MbO, top down and bottom up);
  • Working on HANA in-memory Database, modelling and building data layers due to LSA++
  • Building reports by Design Studio, BEx Query Designer, BO Advanced Analysis and BO Web Intelligence (WEBI)
  • Strong business background as Business Analyst: strong workshop facilitation skills, gathering requirements and mind-mapping
  • Coordination and review of impact assessments, good attention to relevant details, nevertheless strong ability to get the big picture
  • In-depth understanding of the functional and technical processes in FI, CO, CFM, BI Netweaver, BI-IP and BO-BPC on HANA environment
  • Highly evolved interpersonal, communication and project management skills and practical experiences in Prince II, ITIL and Agile with Scrum
  • Ability and experience in leading, mentoring and training team members and key user
  • Working already more than 21 years in Finance, Controlling, BI and IT within SAP environments, nearly 20 years as freelance and certified SAP consultant

Career:

1990 - 1992

Junior consultant of Debis House of Systems (Daimler Group), Stuttgart:

Working on IT-projects for Deutsche Bank Life Insurance AG, Wiesbaden (near Frankfurt-Main) and for IBM London: Participation in development of new platform Insurance Application Architecture (IAA) in London and Brussels, in cooperation with Hoskyns plc., London

03/1992 - 03/1996

Deutscher Ring Insurance Group, Hamburg, Cologne

Controller and team lead, responsible for Cost Center Accounting and controlling of IT projects; reporting directly to executive board, Hamburg;

 

04/1996 - 09/1997

Deutscher Ring Insurance Group, Hamburg, Cologne

Head of department for Finance and Accounting at OVB AG, Cologne, an international distribution  and sales company group, owned largely by Deutscher Ring.

Due to this function also project lead for implementation of SAP R/3 FI and CO.                        

since 11/1997

Freelance, certified SAP R/3-Consultant for FI and CO

 

since 06/2002

Freelance, certified SAP-Consultant for BW and BPS

Betriebssysteme

MS-DOS
Grundkenntnisse
Windows
Grundkenntnisse

Programmiersprachen

ABAP4
Grundkenntnisse für Programmierung von Reports, einfache User-Exits
Basic
Grundkenntnisse
Cobol
Grundkenntnisse
PL/1
Grundkenntnisse
PL/SQL
Grundkenntnisse

Datenbanken

Access
Grundkenntnisse
DB2
Grundkenntnisse
MS SQL Server
Grundkenntnisse
Oracle
mittlere Kenntnisse (u.a. Clusterung)
Kenne auch Methoden der Datenmodellierung, u.a. Entity-Relationship-Diagramme; ebenso Normalisierung, performante DB-Abfragen (z.B. mit SQL), usw.
Gerade in BW ist die Datenmodellierung der Merkmale und Kennzahlen von hoher Bedeutung, u.a. für die spätere Performance und Antwortzeiten von Queries.

Datenkommunikation

RFC
Datenanforderung für Upload in SAP-BW

Hardware

FileNet
Grundkenntnisse Image-Verarbeitung
Grundkenntnisse IXOS-Archivsystem

Design / Entwicklung / Konstruktion

BI Architecture
Blueprint
Data Modeling
Dataflow Diagrams
Functional Design
Specification of User Exits and other ABAP-Routines
Technical Design
Workshops

Branchen

Branchen

Pharma, Mineralöl, Handel (grosse Handelsketten), Industrie (Elektronik, Gußeisen, Papier), Versicherungen, Banken, Automotive

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.