Sven Mader - SAP BW Berater

Baar, Schweiz

Erfahrungen

März 2020 - Bis heute

5 Jahren 4 Monaten

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

Mai 2019 - Bis heute

6 Jahren 2 Monaten

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)

Dez. 2018 - Dez. 2019

1 Monate

SAP BW Developer and Consultant

Europipe

Adapted data model for purchasing controlling

Aug. 2018 - Nov. 2018

4 Monaten

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

Sept. 2017 - Dez. 2017

4 Monaten

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 - Dez. 2019

1 Jahr 9 Monaten

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

Dez. 2015 - Nov. 2016

1 Jahr

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

März 2015 - Juli 2015

5 Monaten

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

Okt. 2014 - Dez. 2015

3 Monaten

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

Juli 2014 - Bis heute

11 Jahren

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

Juli 2014 - Bis heute

11 Jahren

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

Juli 2014 - Bis heute

11 Jahren

SAP BW Developer and Consultant

GEZE

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

Juli 2014 - Bis heute

11 Jahren

SAP BW Developer and Consultant

Sortimo

Extended data model
ABAP developments in ERP and BW
Ongoing support

Juli 2014 - Bis heute

11 Jahren

SAP BW Developer and Consultant

Stadtwerke Karlsruhe

Extended data model
ABAP developments in ERP and BW
Ongoing support

Juli 2014 - Bis heute

11 Jahren

SAP BW Developer and Consultant

Stuttgart Airport

Extended data model
ABAP developments in ERP and BW
Ongoing support

Juli 2014 - Juli 2014

1 Monate

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

Juni 2013 - Juni 2014

1 Jahr 1 Monate

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

März 2013 - Juni 2014

1 Jahr 4 Monaten

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

Dez. 2011 - Mai 2012

6 Monaten

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

Okt. 2011 - März 2012

6 Monaten

SAP BW Developer and Consultant

Plansee SE

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

Sept. 2011 - Mai 2012

9 Monaten

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

Juli 2011 - Dez. 2011

6 Monaten

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 - Dez. 2013

2 Jahren

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 Monate

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 Monaten

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

Okt. 2010 - Feb. 2011

5 Monaten

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

Okt. 2009 - Okt. 2011

2 Jahren 1 Monate

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

Okt. 2009 - März 2010

6 Monaten

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

Juni 2009 - März 2010

10 Monaten

SAP BW Developer

Saint Gobain Oberland

Creation of queries and workbooks

Apr. 2009 - März 2010

1 Jahr

SAP BW Developer

Saint Gobain Oberland

Creation of queries and workbooks

März 2009 - Dez. 2011

2 Jahren 10 Monaten

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

Okt. 2008 - Jan. 2010

1 Jahr 4 Monaten

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

Okt. 2008 - Jan. 2010

1 Jahr 4 Monaten

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

Sept. 2008 - Feb. 2009

6 Monaten

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

Sept. 2008 - Feb. 2009

6 Monaten

SAP BW Developer and Consultant

CeramTec

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

Juni 2008 - Feb. 2009

9 Monaten

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

Dez. 2007 - Apr. 2011

3 Jahren 5 Monaten

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

Okt. 2007 - Sept. 2008

1 Jahr

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

Okt. 2007 - Juli 2008

10 Monaten

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

Okt. 2007 - Juni 2008

9 Monaten

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

Juli 2007 - Juni 2014

7 Jahren

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

Juli 2007 - Nov. 2007

5 Monaten

SAP BW Developer

ZF Friedrichshafen

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

Juli 2007 - Juli 2007

1 Monate

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

Okt. 2005 - Juni 2006

9 Monaten

SAP BW Developer

Commerzbank

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

Mai 2005 - Sept. 2005

5 Monaten

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 - Dez. 2005

1 Jahr

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

Okt. 2004 - Feb. 2005

5 Monaten

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

Okt. 2004 - Dez. 2004

3 Monaten

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

Juli 2004 - Feb. 2005

8 Monaten

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

Juli 2004 - Dez. 2004

6 Monaten

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

März 2004 - Okt. 2004

8 Monaten

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 Monaten

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 Monaten

SAP BW Developer

Commerzbank

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

Feb. 2003 - Dez. 2004

11 Monaten

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 - Juni 2003

6 Monaten

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

Dez. 2000 - Juni 2007

6 Jahren 7 Monaten

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

Dez. 2000 - März 2001

4 Monaten

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

Zusammenfassung

SAP BW

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