Sven Mader - SAP BW Berater

Baar, Switzerland

Experience

Mar 2020 - Present

5 years

SAP BW Developer and Consultant

Rafi Berg

Extended planning application for annual and rolling planning
Improved navigation and filtering with master data
Administered planning InfoProviders: selectively deleted unnecessary data, generated 0 records
Fixed issues from open items list

May 2019 - Present

5 years 10 months

SAP BW Developer and Consultant

SwissLife

Processed support tickets
Made minor adjustments from change requests
Modified ABAP program/class for automatic query transport
Modified ABAP class for MS Excel upload Office365
Created ABAP program/class for copying BEx structures and queries
Created Excel planning via RFC function module in workbook
Created new interface for customer balance list (BW export of FSCD invoices)

Dec 2018 - Dec 2019

1 month

SAP BW Developer and Consultant

Europipe

Adapted data model for purchasing controlling

Aug 2018 - Nov 2018

4 months

SAP BW Developer and Consultant

Weber Maschinenbau GmbH

Data model for cost center accounting
Adjustments to SD data model regarding sales office, delivery date changes and throughput times
Adaptation of data model for material inventory controlling
FI: Correction for determining open items

Sep 2017 - Dec 2017

4 months

SAP BW Developer and Consultant

Geberit

Migration of various data models to 7.5 on HANA and reporting to BO Analytics
Testing of result data and adjustments to data model and transformations

Apr 2017 - Dec 2019

1 year 9 months

SAP BW Developer and Consultant

Klöckner Pentaplast

Data model for Japanese subsidiary: Material inventory management, production controlling, quality management and deliveries
Reporting/calculation of manufacturer discounts
Purchasing spend

Dec 2015 - Nov 2016

1 year

SAP BW Developer and Consultant

Merkle GmbH

Data model for Japanese subsidiary: Material inventory management, production controlling, quality management and deliveries
Reporting/calculation of manufacturer discounts

Mar 2015 - Jul 2015

5 months

SAP BW Consultant

Premium AeroTec

Adapted reporting and planning WebDynpro for personnel data
Migrated data model from 3.5 BW system to 7.0 BW system
Data upload to DSO objects using WebDynpro
Created data model for production controlling

Oct 2014 - Dec 2015

3 months

SAP BW Consultant

Commerzbank

Go-live of a large project
Planning and conception
Execution and comparison of results
ABAP developments for creating work schedule
Loading and validation of data

Jul 2014 - Present

10 years 8 months

SAP BW Developer and Consultant

BWF Group

Extended data model
Development planning
CO and PP key figures for actual, plan and target views
Distribution according to material calculations and material mixtures
ABAP developments in ERP and BW
Coordinated and planned with specialist departments
Ongoing support

Jul 2014 - Present

10 years 8 months

SAP BW Developer and Consultant

CeramTec

Development planning
Planning of material safety stocks in BW
Retraction into ERP material master
ABAP developments in ERP and BW
Coordinated and planned with specialist departments
Ongoing support

Jul 2014 - Present

10 years 8 months

SAP BW Developer and Consultant

GEZE

Extended data model
ABAP developments in ERP and BW
Provided BW data for QLIK
Ongoing support

Jul 2014 - Present

10 years 8 months

SAP BW Developer and Consultant

Sortimo

Extended data model
ABAP developments in ERP and BW
Ongoing support

Jul 2014 - Present

10 years 8 months

SAP BW Developer and Consultant

Stadtwerke Karlsruhe

Extended data model
ABAP developments in ERP and BW
Ongoing support

Jul 2014 - Present

10 years 8 months

SAP BW Developer and Consultant

Stuttgart Airport

Extended data model
ABAP developments in ERP and BW
Ongoing support

Jul 2014 - Jul 2014

1 month

SAP BW Developer and Consultant

IT Informatik GmbH

Support in planning project
Creation of custom planning function to distribute plan data by working days
Embedded as planning sequence in web template
Filtering by marking individual rows
ABAP developments in BW

Jun 2013 - Jun 2014

1 year 1 month

SAP BW Developer and Consultant

EGO Oberderdingen

Conception of disaggregation
Implementation of data model for planning and reporting
Implementation of BEx and web
ABAP developments in BW
Ongoing support

Mar 2013 - Jun 2014

1 year 4 months

SAP ABAP WebDynpro / BW Developer

MTU Friedrichshafen

Complex programming with ABAP-WD / ABAP-OO
Integration into SAP Enterprise Portal (KM, portal content)
Automatic email dispatch with workflow and status network
ABAP developments in BW
Ongoing support

Dec 2011 - May 2012

6 months

SAP BW Developer and Consultant

EGO Oberderdingen

Creation of a cockpit with company key figures (actual and plan values, period and YTD values)
Hichart representation
Custom developed web item
ABAP developments in BW
Ongoing support

Oct 2011 - Mar 2012

6 months

SAP BW Developer and Consultant

Plansee SE

Creation of reporting for personnel administration, time, costs and personnel development
ABAP developments in ERP and BW

Sep 2011 - May 2012

9 months

SAP BW Developer and Consultant

MTU Friedrichshafen

Extension of data model and reports
Material consumption, bills of material, order costs
ABAP developments in ERP and BW
Implementation of BEx and web
Ongoing support

Jul 2011 - Dec 2011

6 months

SAP BW Developer and Consultant

EGO Oberderdingen

Creation of a cockpit with company key figures (actual and plan values, period and YTD values)
Hichart representation
Custom developed web item
ABAP developments in BW
Ongoing support

Jan 2010 - Dec 2013

2 years

SAP BW Developer and Consultant

EGO Zug

Creation of data model (header, item and allocation/delivery data)
Implementation of BEx and web
Reporting of purchasing key figures
Variance analysis
ABAP developments in ERP and BW
Ongoing support

Jan 2010 - Jan 2011

1 month

SAP BW Developer and Consultant

Sortimo

Copying of SD data models and reports from 3.5 BW system to 7.0 BW system
Optimization of data models
Migration to 7.0 data flows
ABAP developments in ERP and BW
Ongoing support

Nov 2010 - Apr 2011

6 months

SAP BW Developer and Consultant

EGO Oberderdingen

CO and PP key figures for actual, plan and target views
ABAP developments in ERP and BW
Ongoing support

Oct 2010 - Feb 2011

5 months

SAP BW Developer and Consultant

BWF Group

CO and PP key figures for actual, plan and target views
Distribution according to material calculations and material mixtures
ABAP developments in ERP and BW
Ongoing support

Oct 2009 - Oct 2011

2 years 1 month

SAP BW Developer and Consultant

GEZE

Installation + setup of BW system (operating concept, naming convention)
Training/induction of IT staff
Migration of MIS cockpit from database+insight to BW (extension + creation of DataSource, creation of data model and reports)
Key figures from COPA, SD, HR and CO
ABAP developments in ERP and BW
Ongoing support

Oct 2009 - Mar 2010

6 months

SAP BW Developer

Rieter Machine Works Ltd

Installation + setup of BW system (operating concept, naming convention)
Training/induction of IT staff
Extension of data model and reporting from ERP template
ABAP developments in ERP and BW

Jun 2009 - Mar 2010

10 months

SAP BW Developer

Saint Gobain Oberland

Creation of queries and workbooks

Apr 2009 - Mar 2010

1 year

SAP BW Developer

Saint Gobain Oberland

Creation of queries and workbooks

Mar 2009 - Dec 2011

2 years 10 months

SAP BW Developer and Consultant

Stuttgart Airport

Extension of data model
Creation of planning application for analysis of cost forecasts and calculation of replacement investments
Calculation of throughput times of orders and notifications
ABAP developments in ERP and BW
Ongoing support

Oct 2008 - Jan 2010

1 year 4 months

SAP BW Developer

Alcan Singen

BW standard DataSources for purchasing only provide key figures that are also created in the purchasing module
Goal: Customer also wants to see key figures that are only available as invoices in FI
Restrict FI data to display purchasing data
Enrich FI data with MM-EK data
ABAP developments in ERP and BW

Oct 2008 - Jan 2010

1 year 4 months

SAP BW Developer and Consultant

Sortimo

Installation + setup of BW system (operating concept, naming convention)
Training/induction of IT staff
Creation of data model (header, item and allocation/delivery data)
Reporting (e.g. price trends) of purchasing key figures
ABAP developments in ERP and BW
Ongoing support

Sep 2008 - Feb 2009

6 months

SAP BW Developer and Consultant

CeramTec

Planning of material safety stocks in BW
Retraction into ERP material master
ABAP developments in ERP and BW
Ongoing support

Sep 2008 - Feb 2009

6 months

SAP BW Developer and Consultant

CeramTec

Adoption of business content
Extension of data model
ABAP developments in ERP and BW
Ongoing support

Jun 2008 - Feb 2009

9 months

SAP BW Developer

Balluff

Migration of VIS structures to BW DataSources
Mapping of VIS customizing in extraction and transformation logics
ABAP developments in ERP and BW

Dec 2007 - Apr 2011

3 years 5 months

SAP BW Developer and Consultant

Plansee SE

CO and PP key figures for actual, plan and target views
Enriched with MM data
Goal: Detailed at operation/work center level
Only possible through custom developed extractors and major performance optimization efforts
New structure not possible in one step. Concept creation for partial structure.
ABAP developments in ERP and BW
Ongoing support

Oct 2007 - Sep 2008

1 year

SAP BW Developer

ZF Friedrichshafen

Concept creation
Adoption and extension of business content QM, MM
Implementation of reporting with BW web reporting/BEx
International rollout
ABAP developments in ERP and BW

Oct 2007 - Jul 2008

10 months

SAP BW Developer and Consultant

CeramTec

Goals: Minimization of production order throughput times and analysis of average scrap quantity to optimize produced scrap rate in material master
For this it was necessary to calculate throughput time in detail: waiting, idle, operation and production time
Retraction of scrap rate into ERP material master
ABAP developments in ERP and BW
Ongoing support

Oct 2007 - Jun 2008

9 months

SAP BW Developer and Consultant

Alcan Packaging Singen

Adoption of business content
Extension of data model
Calculation of key figures such as order backlog, open balance, delivered quantity etc.
International rollout
ABAP developments in ERP and BW

Jul 2007 - Jun 2014

7 years

SAP BI Consultant

eNovation GmbH/HighCoordination GmbH

Development planning
Support of IT and specialist departments in daily work, such as:
Process chain monitoring
Error analysis
Performance optimizations
Creation of ad hoc evaluations
Creation of standard reports
ABAP developments in ERP and BW
Coordination and planning with specialist departments
Ongoing support

Jul 2007 - Nov 2007

5 months

SAP BW Developer

ZF Friedrichshafen

Creation of DataSource and update to DSO
Generation of analysis authorizations
ABAP developments in ERP and BW

Jul 2007 - Jul 2007

1 month

SAP BW Developer

ZF Friedrichshafen

Creation of report to analyze load requests in one report
With exceptions to detect aborted load processes
ABAP developments in BW

Oct 2005 - Jun 2006

9 months

SAP BW Developer

Commerzbank

RampUp project
Created over 200 OSS messages in total
ABAP developments in BW

May 2005 - Sep 2005

5 months

SAP BW Developer

Commerzbank

Introduction of ACTUATE frontend software
Use additional reporting options
Display of organizational structure as organization charts
Enrichment of external data in a report
ABAP developments in BW

Jan 2004 - Dec 2005

1 year

SAP BW Developer

Commerzbank

The BW system should now also be made available to English-speaking employees, such as the numerous employees in London
Connecting new user groups
Translation of BW objects
ABAP developments in BW

Oct 2004 - Feb 2005

5 months

SAP BW Developer

Commerzbank

Introduction of reporting for travel management data
Extension of business content (inclusion of additional InfoObjects)
Inclusion of rail data, as this is not included in business content
ABAP developments in ERP and BW

Oct 2004 - Dec 2004

3 months

SAP BW Developer

Commerzbank

Introduction of reporting for loan data reconciliation
Commerzbank manages loans and KfW (Kreditanstalt für Wiederaufbau) issues them
The data of both credit institutions is compared with BW and differences are shown
ABAP developments in ERP and BW

Jul 2004 - Feb 2005

8 months

SAP BW Developer

Commerzbank

Introduction of reporting for CO data
Extension of business content (inclusion of additional InfoObjects)
Creation of hierarchy authorizations from source system profiles
ABAP developments in ERP and BW

Jul 2004 - Dec 2004

6 months

SAP BW Developer

Commerzbank

Creation of a projection InfoCube
Personnel expenses for the current year are forecast using salary data and customizing tables
ABAP developments in ERP and BW

Mar 2004 - Oct 2004

8 months

SAP BW Developer

Commerzbank

Goal: Save storage space
Use of BW loading mechanisms
Copy HR InfoCubes annually to other InfoCubes and aggregate in the process
Delete the old year from the detail cube

Aug 2003 - Feb 2004

7 months

SAP BW Developer

Commerzbank

Improvement of time expenditure and resource requirements for loading processes
Optimization of ABAP source codes
Modification of SAP extractors
Better utilization of process chain possibilities
ABAP developments in ERP and BW

Aug 2003 - Feb 2004

7 months

SAP BW Developer

Commerzbank

Adoption and extension of business content PS
Implementation of reporting
ABAP developments in ERP and BW

Feb 2003 - Dec 2004

11 months

SAP BW Developer

Commerzbank

Create web templates from existing queries and workbooks
Create a BSP page that serves as an "entry/portal"
Create the CSS file
Provision of single sign-on. i.e. no login is required for the portal, as the login to the operating system is used for issuing the ticket
Installation of the IGS server for graphical preparation

Jan 2003 - Jun 2003

6 months

SAP BW Developer

Commerzbank

Provision of an InfoCube that provides the company's personnel data from different sources
Actual data from CO (original data comes from payroll)
Subsidiary companies report their data as they are not connected to SAP.
ABAP developments in ERP and BW

Dec 2000 - Jun 2007

6 years 7 months

SAP BW Application Developer

Commerzbank

Support for all objects related to the BW system
DataFlow (extractors, updates, InfoProviders)
Job control (jobs, InfoPackages, process chains, Tivoli)
Basic support (transport management, job cancellations, database growth, SysLog, patching, OSS notes)
Support for specialist departments
ABAP developments in ERP and BW

Dec 2000 - Mar 2001

4 months

SAP BW Developer

Commerzbank

Go-live of the BW system
Completion of requirements
Optimization of ABAP programs due to runtime problems
ABAP developments in ERP and BW

SAP BW Developer

Commerzbank

Extension of reporting for the "Fluctuation" InfoCube
ABAP developments in ERP and BW

SAP BW Developer

Commerzbank

Creation of a test concept
Goal: Reduce error probability and susceptibility in a BW project or maintenance project
Automated test execution
Errors are quickly detected and do not only occur in productive operation
Further improvement occurs through "systematic test case determination" with SQSTEST, because this improves the quality of test data

SAP BW Developer

Commerzbank

Release change from 2.0B to 3.0B
Discovered many SAP errors
Regularly created and processed up to 20 OSS messages
Long project duration

SAP BW Developer

Commerzbank

Compare salary data from infotype PA0008, PA0014 and PA0015
Mix with employee's measures (PA000 and PA0302)
ABAP developments in ERP and BW

SAP HR Developer

Commerzbank

Extraction of data from SAP HR and SAP BW
Modification of data using BODI
Retraction into SAP HR
ABAP developments in ERP and BW

Summary

SAP BW - Datenmodellierung - Reporting mit den BEx Tools - SAP-Berechtigungen, Rollen, Analyseberechtigungen - ABAP-Programmierung - Fehlersuche, Optimierungen, Performanceverbesserungen

Languages

German

Native

English

Advanced

Education

Oct 1996 - Oct 2000

Westsächsische Hochschule für Technik und Wirtschaft in Zwickau

Diplominformatiker · Zwickau, Germany · gut

Sep 1994 - Jun 1995

Fachoberschule Altenburg

Fachhochschulreife · Altenburg, Germany · 1,5

Aug 1981 - Jun 1991

Polytechnische Oberschule Altenburg

mittlere Reife · Altenburg, Germany · 1,8

Certifications & licenses

Diplom-Wirtschaftsinformatiker FH

Senior Projekt Manager | Programm- und Interimsmanager

View Profile