|
CV and Skills |
SAP BI/BW(ABAP4 OO) NetWeaver 2004s Consultant SAP BI/BW All-Rounder von Frontend bis Backend SAP BI Enterprise Portal Developer SAP Web Dynpro for ABAP Developer |
|
IT - Experience since |
1975 |
|
Nationality |
German |
|
Aspiring position/role |
SAP BI/BW / APAP4- / Web Dynpro for ABAP development |
|
Preferred Regions/Locations |
Germany: Complete area Favourite areas: Düsseldorf, Essen, Cologne, Duisburg Europe: All German speaking countries German or bilingual GE/EN speaking projects are preferred |
|
Availability 100 % |
September 2012 |
|
Rate per hour |
85 – 105 EUR depending on Location and Duration |
|
Professional focuses |
|
mySAP 08.2006 |
SAP NetWeaver 2004s- und ABAP4 OO - Development Certificated knowledge of ABAP4 OO Architecture BI 7.3 Business Information Warehouse 2004s Experience with Data staging Administration / Installation / Configuration BI 7.0 Analytical Authorization BW 3.5 Business Information Warehouse Admin Workbench, Modelling and ETL (Extract Transform Load) Processes BW Data loading Extraction source systems SAP BEx Business Explorer BEx -Administration, -Reporting, -Analyzer SAP WAD Web Application Designer BEx Broadcaster SAP NetWeaver BI Enterprise Portal SAP BW Consultant for BW Reporting Requirements BW BI/BW BPS Development (Junior) SAP BI/BW Consultant for 2nd line Support in BW Requirements Admin Workbench, BEx -Administration, -Reporting, -Analyser SAP APD Analysis Process Designer SAP Web Dynpro for ABAP (Junior), since Feb. 2012 |
|
Host/Mainframe 02.1975 |
IMS-DB/DC-Specialist DB-Design, Online-Programming(MPP,BMP), Cobol-, PL1-, C-, Easytrieve-Developer Project manager for IMS Online - Requirements |
|
School |
1966 - 1972 Secondary Technical School |
|
Business Education |
09.1972-01.1975 as IT - Developer |
|
Further Education |
Courses at IBM for Specialisation in IMS-DB/DC, JCL, Cobol, PL1 2004 PL-SQL-, Oracle- Specialisation 2005 SAP ABAP4 OO Specialisation 2006 SAP BW 3.5 Specialisation |
|
Certification 02/2006 |
SAP NetWeaver '04 Development Consultant - Web Application Development Focus ABAP |
|
Languages useable in Projects |
German as mother tongue English fluent Croatian fluent (place of birth was Zagreb in Croatia) |
|
Further Languages |
Dutch basic knowledge French basic knowledge |
|
Personal qualifications |
Customer oriented and independent working Motivated and efficient Ability to install and configure software with minimum supervision Ability to understand customer requirements without extensive Documentation from the customer Readiness to travel |
|
SAP Business activities regarding Roles/Functions/Tools |
|
· SAP BI/BW(ABAP4 OO) NetWeaver 2004s Developer · Administration Workbench Modeling All rounder · Planning Workbench(Junior) · BW developed solutions using custom data targets and generic Extraction · BW ETL (Extract Transform Load) Processes of data sources(oracle, flatfile, host) incl. Start-, End- and Expert-Routines · Ensuring integration of data from both SAP and non-SAP sources: Modules FI, CO, SD, CRM and Mainframe · Creation of process chains and data loading strategies · Administration Actual data - and Planning - Data in Cubes, ODS, InfoSets, Virtual InfoProvider and MultiProvider · Developing Concepts and Query layouts in cooperation with the Stakeholder dep. Marketing, Purchase and Controlling · Migration analytical authorizations from BW version 3.5 to SAP BI version 7.0 · Creation of reporting solutions using BEx Query Designer/Analyzer, BEx Query Analyzer, WAD Web Application Designer and BEx Broadcaster · Processing BEx Broadcaster via process chain · SAP BI Enterprise Portal: Co-operation in Intranet-/Internet portal Team Developing user manual portal administration System-Administration, Monitoring, Authorizations, Content-Administration, Portal-Content, Roles, Worksets, User-Administration, Identity Management, Knowledge Management (KM), Collaboration Management · Realizing Queries using Structures, Variables for texts and characteristics, Hierarchies, Selections in Cell definitions, Calculated and Restricted Key Figures · Analyzing APD-Processes and installing enhancements of new key figures · Implementation of performance improvement using aggregate and query cache strategies · Performance analysis and improvement of long running queries · Managing Roles, Authorizations and Users using Profile Generator (transaction PFCG) and User Management (Transaction SU01) · Fixing report results using transaction LISTCUBE via MultiProvider · Analyzing and repairing of BI Objects using TA RSRV. · Implementation logical names in DTP: Creating logical names for CSV-Data source using TA FILE and AL11 · Using Semantic Groups and Error Stack while loading transaction data · Generating DataSources from Business Content (transaction SBIW) on source system (ERP) for Update - modes Delta and Full · Integration of non-SAP data using flat files · Generating DataSources from transparent Z-Tables and Info Objects · Generating from Business Content (transaction RSA1) on BI-System · Customizing structures and DataSources (SBIW) via LO - Cockpit (transaction LBWE) · Customer-Exits for Append-Structures(RSAP0001) regarding SAP enhancement RSAP0001 for transaction data (exit_saplrsap_001) and for attributes, texts (exit_saplrsap_002), enhancing the extraction structure of the DataSource with additional fields (RSA6) · Using Extractor checker (transaction RSA3) · Realizing Maintenance of Z-table via SM30 and generate transaction using SE93 · Using Transport Connection using Transactions: SE09, SE10 and STMS · Developing layouts and realizing requests in BW BPS (transaction BPS0) Business Planning and Simulation. · Handling planning maps BPS (transaction UPSPM) and using Transaction UPSPL for execution. · Coordinating activities in coop. with the Stakeholder dep. |
|
Mainframe Business activities regarding Roles/Functions/Tools |
|
IMS – DB/DC Specialist, Programmer: Cobol, PL-SQL, C Analysis, conception, development and maintenance systems in Fields of customer master file data, debtors, billing and table content Support/Hotline – Supervision in scopes of: IMS – DB/DB2 COBOL, C JCL, BTS, MFS Datamanager, IBM Debugger, XPEDITER Easytrieve – Plus |
|
Building Enterprise, Energy, Banking, Steel, Automobile, Trading, Machinery, Chemistry, financial service provider |
|
IT Skills |
|
MySAP |
SAP R3 SAP ABAP4/ ABAP OO SAP CA Cross Application components SAP BI/BW (Business Information Warehouse) SAP ETL (Extract, Transform, Load) SAP OLAP, OLTP SAP ODS - Dataset SAP BI/BW Administrator Workbench SAP BW BEx Query Analyzer (Excel) SAP BW BEx Query Designer/Analyzer (Web) SAP WAD Web Application Designer SAP APD Analysis Process Designer SAP SAPConnect und Information Broadcaster SAP NetWeaver BI Enterprise Portal SAP NetWeaver 6.20 Basic components SAP Workbench Konzepte SAP Open SQL (High-performance Programming) SAP LUW’s und Client/Server – Architecture SAP Dialog programming SAP Logical Data bases SAP Interactive Lists SAP Locking Concept SAP Authorization check SAP Number assignment SAP Dynamic Programming SAP Personalization and Transaction variants Junior SAP Web Dynpro for ABAP, since Feb. 2012 Junior SAP BPS Business Planning and Simulation Junior SAP XI (Exchange Infrastructure) Junior SAP XI (Integration Builder: Design, Configuration) Junior SAP XI (System Landscape) Junior SAP XI (Integration Monitoring) Junior SAP Enhancements and modifications Junior SAP Append- and CI-Structures Junior SAP Customer Exits (Functions, Menus, Dynpros) Junior SAP ALE = Application Link Enabling Junior SAP IDoc = Intermediate Document Junior SAP BTE = Business Transaction Events Junior SAP BAdI = Business Add Ins Junior SAP EDI = Electronic Data Interchange |
|
Hardware |
i686, IBM Mainframe |
|
Operating System |
Linux, zOS, OS-VS, MVS, WINDOWS-4.0 bis WINDOWS-XP, MS-DOS, CMS, VMS, DOS-VSE |
|
Programming Languages |
ABAP4 OO, Cobol, Java, Easytrieve Plus, PL/1, HTML, C, RPG/CPG, Clist, REXX, PL/SQL, Assembler, JCL |
|
Data bases |
SAP- Application Server, ODBC, JDBC, Oracle, DL/1, IMS, VSAM, Access, Excel, Oracle, DB2 |
|
Further tools |
MS Office 2003/XP, Internet, Lotus Notes, Outlook, MS Visio |
Business activities and projects since 02.1975 until today
from 05.2012 – today
Company Hays for RWE IT GmbH in Dortmund
Role SAP BI/BW ABAP4 OO Developer
Branche Energy- and Water- Supply & Disposal
Project SAP BW/BI-Project Enhancements
Tasks in project SAP BI 7.3
Enhancements in actual SAP BI System
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Analyzer (Excel), BEx Broadcaster, WAD, SAP BI, BW, APD, ABAP4 OO – Workbench, MS Outlook, ScreenShot, FTP, Change Management using Solution Manager
Module: BI, CO, CRM, FI
from 02.2012 – 03.2012 (2 months)
Company Meder-Mainframe GmbH
Role SAP ABAP4 oo Developer
Branch Consulting
Project SAP Web Dynpro for ABAP
Self-study and training Web Dynpro for ABAP using DVD Video2Brain
· Basics Web Dynpro-development: Layouts, Views and programs
· Web Dynpro- development tools: Debugger and SAP-Documentation
· Program using two views and window control
· Extended UI-control
· Drop Down Box, Check Box and Dynamic field values, Radio Button and dynamic view control
· GRID-Layout development
· Import and bind graphic objects
· Tables and table control
· Roadmap: main program, Component Controller, Views, Global Methods and View-Methods, Eventing of View-control, Navigation control
· Handling PDF-files and Interactive Forms
· Integration of Web Dynpro into Portal
· Dynamic UI-Handling at runtime
· Model/View Controller (MVC) paradigm: creating data model and bind with DDIC-Object, realize Supplier-Function, creating UI-Component Controller, creating View, binding data of model and view, embedding views into Windows-Control, realizing Control-Program
Tools: NetWeaver 2004s Administrator Workbench, ABAP4 oo – Workbench, SE80, SE11
from 10.2011 – 01.2012 (4 months)
Company MLP in Wiesloch 2nd engagement
Role SAP BI/BW Developer and ABAP4 oo Developer
Branch financial service provider
Project SAP BW/BI-Project Enhancements
Tasks in project SAP BI 7.3
Enhancements in actual SAP BI System
· Analyzing APD-Processes for area performance measurements(PM) key figures "Line of business coverage consultant" and " Line of business coverage agency"
· Upgrading der Analysis processes and depending target data provider with key figures for family and single customer
· Generating historical data for new key figures for all DSOs data sources and Cube-targets
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Analyzer (Excel), WAD, SAP BI, BW, ABAP4 OO – Workbench, APD, Lotus Notes 7, ScreenShot, Putty, FTP, Solution Manager
Modules: BI, CO, CRM, FI
from 09.2011 – 09.2011 (1 month)
Company IBM for Boehringer in Ingelheim
Role Technical SAP BI Consultant
Branch Chemical/pharmaceutical industry
Project Installation new EDWH Pilot 2
Tasks in project Installation new EDWH
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Analyzer (Excel), SAP BI, BW, ABAP4 OO – Workbench, ScreenShot
Modules: BI, CO, CRM, FI
from 12.2010 – 08.2011 (9 months)
Company UNIORG for profine in Troisdorf
Role Technical SAP BI Development Consultant
Branch Plastic Profiles for doors and windows
Project SAP BI: Country- and BU-Reporting
Tasks in project Country and BU Reporting
- Splitting data into separate Cubes for complete years
- Generating aggregates
- Setting provider specific properties of InfoObjects for relevant MultiProvider
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Designer/Analyzer (Excel), BEx Broadcaster, WAD, SAP BI, BW, ABAP4 OO – Workbench, ScreenShot, Business Objects Data Integrator
Modules: BI, CO, CRM, FI
from 09.2010 – 11.2010 (3 months)
Company IBM for Fernuniversität in Hagen
Role Technical SAP BI Development Consultant
Branch Education
Project SAP BI: SAP Launching Uni Hagen
Tasks in SAP BI 7.0 Launching new SAP System BI
· - Reporting - "Dataflow" - conception and realization of reports using BEx Query Designer/Analyzer and WAD
Inventory list after unit of organization
Quarterreport (budget)
Balance actual/actual comparison
Profit and loss account actual/actual comparison
Commercial report after PSP-elements
Developing user manual portal administration
System-Administration, Monitoring, Authorizations, Content-Administration, Portal-Content, Roles,
Worksets, User-Administration, Identity Management, Knowledge Management (KM),
Collaboration Management
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Designer/Analyzer (Excel), BEx Broadcaster WAD, SAP BI, BW, ABAP4 OO – Workbench, Lotus Notes 7, ScreenShot, FTP, Portal Content Studio
Modules: BI, AM, CO, CRM, FI, HR
from 06.2010 – 06.2010
Company HP for Otto in Hamburg
Role SAP BI/BW Developer und ABAP4 OO Developer
Branch Trade
Project Concept for Strategic Reorientation of BI-IT
Designing Business Blueprint for Strategic Reorientation of BI-IT
Collecting of general requests to install Core DWH for IT and business
Scheduling and conducting workshops and interviews
Definition of actual IT environment and target state of IT
Process definition
BI function definition
Layer model
Selection and definition of source systems
from 03.2010 – 05.2010 (3 months)
Company Deloitte for Nord/LB in Hannover
Role SAP BI/BW Developer und ABAP4 OO Developer
Branch bank
Project SAP BI Accounting Reports
Tasks in SAP BI 7.0 optimization of existing BI Systems
accounting: Realizing Modern Balance Law (BilMoG)
· Installing Balance-Dependent Account via virtual InfoProvider
· Update transformation routines, DTPs and process chains
· Analyzing load processes with too long process time
· Performance analysis and improvement load processes
· Upload flat files to application server
· Installing routine spooling output during load processes
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Analyzer (Excel), BEx Broadcaster
WAD, SAP BI, BW, ABAP4 OO – Workbench, Lotus Notes 7, ScreenShot, Putty, FTP,
Change Management unter Verwendung des Solution Manager,
SAP BW WiKi Dokumentation
Modules: BI, BA
from 09.2008 – 02.2010 (18 months)
Company HP for MLP in Wiesloch 1st engagement
Role SAP BI/BW Developer und ABAP4 OO Developer
Branch financial service provider
Project SAP BI Redesign 7.0
Tasks in SAP BI 7.0 optimization of existing BI Systems
· Developing queries of divisions ”financing and home purchase savings” and ”money”
· Monitoring of pilot installation and fixing of load processes
· Performance analysis for long data load processes via debugging
· Installing process chains per division and relevant staging and consolidation areas
· Data Harmonization of master data of divisions ”pension funds” and ”property insurance” in staging step 1, assigning alphabetic into numeric keys
· Management of product and business hierarchies
· Using error-stack and assigning semantic groups
· Installing Virtual Provider loaded direct by error-stack to provide collection report via query. Use of report-report connectivity to show errors of records which were not accepted in load stream.
· Debugging load process for divisions ”pension funds” and ”property insurance”
· Developing InfoSets/MultiProvider to consolidate InfoProvider objects (F_PARTNER and BIPARTNER)
· Analyzing data flow and load processes of division ”pension funds” and ”property insurance”
· Analyzing data flow and load processes of Infoprovider BIPARTNER and F_PARTNER
a) Which data sources belong to InfoCubes
b) Which DSOs are load by Analysis Process Designer
c) Analyzing assignment of queries to dependant infoprovider
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Analyzer (Excel), WAD, SAP BI, BW, ABAP4 OO – Workbench, Lotus Notes 7, ScreenShot, Putty, FTP, Solution Manager
Modules: BI, CO, CRM, FI
from 06.2008 – 08.2008 (3 months)
Company Siemens for Evonik/Degussa in Frankfurt
Role SAP BI/BW Developer and ABAP4 OO Developer
Branch chemical industry
Project 12to6 SAP BI 3.1 to 7.0 / BI/BW
Tasks in SAP BI/BW 3.1 to 7.0
Implementation of the new management structures in all IT systems after Business Units merger
(12->6) of Evonik Degussa
· Generating space statistics report using table ZBW002, ZBW002D
Generating ALV list for entries in table ZBW002 or ZBW002D
a) Show first screen to fill date and choose display all or only distribution relevant data
b) Generate 2nd screen to display all via Screen 100 using table ZBW002
c) Generate 2nd screen to only distribution relevant data via Screen 200 using table ZBW002D, this table will be created internal only for the use of ALV functionality. The contents of ZBW002D remains in table until next run of the report for this version.
· Generating space statistics of PSA, ODS and Cubes in BW/BI
a) Mapping work area names from table ZBW001 against names in DD02L
b) Mapping work area names from table ZBW001 against description in DD02T
c) Mapping owner short text from table ZBW001 against description in DD02T
Infocube:
Version via tables DD02L, DD03L: control see RADIOBUTTON group p_versa
Determine Cube names via table DD02L for following selection criterias:
WHERE ( tabname LIKE '/BIC/D%'
OR tabname LIKE '/BIC/E%'
OR tabname LIKE '/BIC/F%'
OR tabname LIKE '/BIC/H%'
OR tabname LIKE '/BIC/I%'
OR tabname LIKE '/BIC/J%'
OR tabname LIKE '/BIC/K%'
OR tabname LIKE '/BIC/M%'
OR tabname LIKE '/BIC/P%'
OR tabname LIKE '/BIC/Q%'
OR tabname LIKE '/BIC/S%'
OR tabname LIKE '/BIC/T%'
OR tabname LIKE '/BIC/X%'
OR tabname LIKE '/BIC/Y%' )
AND as4local = 'A'
AND tabclass = 'TRANSP'.
-Get Cube layout information "count of rows" by
Selection technical name of PSA from table DD02L
-Read table DD03L to get "size of line"
-Compute Bytes = "count of rows"
* "size of line", stored into table ZBW002
PSA:
Determine PSA names via tables RSTSODS, DD02L, DD03L
-Selection alls active PSAs ODSNAME > " " and VERSION = "A"
-Get PSA layout information "count of rows" by
Selection technical name of PSA from table DD02L
-Read table DD03L to get "size of line"
-Compute Bytes = "count of rows" * "size of line",
stored into table ZBW002
ODS:
Determine ODS names via table DD02L, DD03L:
-Selection via field tabname LIKE '/BIC/A%' AND AS4LOCAL = 'A'
-Get list of all active dso from table DD02L,
that means get ODS layout information "count of rows"
-Read table DD03L to get "size of line"
-Compute Bytes = "count of rows"
* "size of line", stored into table ZBW002
· Tasks in BW authorization and roles regarding new hierarchical structures
-Changing node names for object Profit Center (0profit_ctr)
-Assigning new node names into roles and matching them in composite roles
-Changing APAP4 transformation routine of Info Package to maintain the new node names
-Loading actual node names from production system using Infosource 0PROFIT_CTR and giving Sourcesystem FLATFILE as source
· Tasks in BW BEx and WEB: Validation the use of Business Unit variable ZVC_BU
-Checking FI- and HR- WEB Templates, Query Views and Queries
· Tasks in BPS0 main planning classes: Validation of SPRINT 2008 / CS records
Customizing ABAP4 -Functions
-Checking values of characteristics: item accounts, countries, etc.
-Checking assignment between quantity- and amount values for given item positions
-Checking identifier of partner companies
· Create Z-table to maintain old new Profit Center
-Connect field ‘profit center’ to reference table CEPC for validation of user input
-Load field ‘profit center description’ via include function respectively external ABAP4 -Routine
-Realizing Maintenance of Z-table via SM30 and generate transaction using SE93
-Provide Z-table text headlines in Portuguese language
· Changing Report CS REPORT concerning 5 Queries and SPRINT conc. 4 Queries for Evonik Brazil
- Changing old node names to new node names
· Load SPRINT Cube data from STAR-FLATFILE data using ABAP4 -Functions
-Creating Z -table which contains reference item accounts old of STAR and new of SPRINT inclusive -Realizing Maintenance of Z-table via SM30 and generate transaction using SE93
-Determine path of filename for data source using CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
-Fetching data from FLATFILE and table which references items old of STAR and new of SPRINT
-Loading Cube SPRINT using FLATFILE records while building new items
· Unload STAR Cube data to FLATFILE using ABAP4 -Report
-Determine path of filename for data target using CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
-Fetching data from Cube zbu4_work using field selection for characteristics as Select Options:
Company, Business Unit, Position, STEP STAR III, Sourcesystem STAR III, Value type for reporting
via CALL FUNCTION 'RSDRI_INFOPROV_READ'
-Fixed values taken for selection of following characteristics:
STEP STAR III : A1
Value type for reporting: 10
-Fixed values not taken (excluded) for selection of following characteristics:
Sourcesystem STAR III : FIRST
-Writing data into internal table i_zbu4_work using structure zbu4_work
-Download data into FLATFILE if user let checkbox unchanged using
CALL FUNCTION 'WS_DOWNLOAD'
otherwise only fetching data and counting records
-Writing inactive companies if user let checkbox unchanged otherwise skipping these records, only display them
Tools: NetWeaver 2004s Administrator Workbench, BEx Query Analyzer (Excel),
WAD, SAP BI, BW, ABAP4 OO – Workbench, Lotus Notes 6.5, HyperSnap 5.62.6
Modules: BI, AM, CRM
from 02.2008 – 05.2008 (4 months)
Company braunconsult in Freilassing for Siltronic AG in Burghausen and Wacker Chemie
Role SAP BI/BW Developer and ABAP4 OO Developer
Branch Siliciumwafer Production
Project SAP BI 7.0 / BW
Performed Tasks in SAP BI 7.0
· Realizing shipping reporting
Complete development from ETL to realization reports using LO-Cockpit on ERP - System and RSA1 Modelling Workbench on BI - System
- Logistic Extractions Structures using Customizing Cockpit
- Logistic Application 12: change structures for existing transactional DSOs
- Extractor Checker: Checking changed and new structures
- Defining Generic DataSources for transparent Z-Tables and InfoObjekts
- Replication of DataSources on BI-System
- Defining DSO Objects, Transformations and Info Packages
- Initiate new transfer for new structure LIS_12 using transaction SBIW:
- Delete the Contents of the Setup Tables
- Filling new tables using Setup for new load of LE - deliveries
· Realizing concept for migration analytical authorizations from SAP 3.n to SAP BI 7.0
Load basic table for new authorization concept using entries of tables agr_users, usrbf2, usr02 and ust12.
· Developing Dynpro for maintaining authorization objects and master data keys
This ABAP-Dynpro provides the maintenance of all relevant key objects for requested InfoArea and User.
All relevant objects and Key Values must be entered. Some values may get “*“. The maintained table provides the use for generating analytical authorization using transaction RSECADMIN.
· Installation from Business Content two DSO authorization objects 1 and 3
These DSO datasets are loaded via transformation and contain two tables with the relevant data: Master data key, InfoAreas, Usernames and Objects. These DSO Dataset are the basis to create analytical authorization using transaction RSECADMIN.
Tools: NetWeaver 2004s Administrator Workbench,
BEx Query Analyzer (Excel),
BI-BPS,
ABAP4 OO – Workbench
Modules: BI, MM, CRM
11.2007 – 01.2008 (3 months)
Company fleetwood Personal & Marketing GmbH in Ottobrunn/München for Lohmann and Rauscher
Role SAP BI/BW Developer and ABAP4 OO Developer
Branch Medical Supply
Project SAP BI 7.0 / BW 3.5 Sales Planning
Performed Tasks in BPS
· Ascertaining main planning class for business volume
· Developing Report to ascertain percentage of sales for articles regarding sales organisation, distribution channel and planning class
· Ascertaining main planning class for receiving factory
Developing new info cube (technical name ZLRDCT110), as copy from disposable - Cube ZLRDCB110.
Panning area Admin - Global Main Planning class (PK) ZLRA110
Panning layer Admin - Global Main PK receiving factory ZLRL110
Panning function Ascert. Main PK for receiving factory ZLRPF110
Parameter group Ascert. Main PK for receiving factory ZLRPG110
Source function ZLR_WITH_HPKW
· Developing Report for checking authority concept
The Report checks the article data primary keys against the transparent tables RSECVAL, RSECUSERAUTH and rsecvalview. If there are no corresponding references the primary keys are listed.
· Customising automatic planning for loading target figures
Changing automatic planning in two areas; both related among automatic loading target figures.
Change request 1: Planning class (PK) 2 / disposition horizon (DH)
Panning area L&R Spinning operation for Sales Planning ZLRA100
Panning layer Admin – incl. PK ZLRL111
Panning function Stat. Forecast -> Plan outside DH ZLRPF191
Parameter group PK 2 (fill up) ZLRPG192
PK 3 (overwrite) ZLRPG191
Source function loading statistic forecast into planning target figure depending on PK outside disposition horizon
Z_UPF_PLAN_AUS_PROGNOSE
Change request 2: Replacing statistic forecast while loading target figure „Plan for Dispo“
Panning area L&R Spinning operation for Sales Planning ZLRA100
Panning layer Admin ZLRL110
Panning function Plan for Dispo ZLRPF190
Parameter group 190 ZLRPG185
Source function plan for dispo
Z_UPF_PLAN_FUER_DISPO
Tools: NetWeaver 2004s Administrator Workbench,
BEx Query Analyzer (Excel),
BI-BPS,
ABAP4 OO – Workbench
Modules: BI, CRM
07.2007 - 12.2007 (6 months)
Company bebit Informationstechnik GmbH for Bilfinger and Berger Mannheim
Role SAP BW 3.5 Consultant and ABAP4 OO Developer
Branch Trading
Project Fast Close System Implementation
Performed Tasks in BEx Query Analyser
· Developing Report roles and user authorities for hierarchies and consolidation groups
· Managing Pickups in Reporting demands on Approval System.
· Copying and modulating Queries and Workbooks for Joint Venture project.
I analyzed the bilingual workbooks, copied queries to new names and embedded Queries into new workbooks.
Then I started of the old and new workbooks in German and English language.
I verified the results on the Developing System.
· Developing Report roles for customer user.
Grouping Reports for customer departments and transportation to approval system.
· I verified the Report resuts using the Multiprovider and Transaction LISTCUBE.
Then I started the old and new workbooks in German and English language.
I verified the results on the Approval System.
· Analysis and Repair of BW Objects using Transaction /nrsrv.
Tools: Administrator Workbench,
BEx Query Analyzer (Excel),
BEx Query Designer/Analyzer (Web),
BEx Web Application Designer,
ABAP - Workbench,
Lotus Notes, HyperSnap, IrfanView
Modules: BI, CO, CRM, FI
08.2006 - 06.2007 (11 months)
Company T-Systems for Klingel
Role SAP BW 3.5 Consultant and ABAP4 OO Developer
Branch Trading
Project SAP BW and BPS Integrated Solution for Marketing, Purchase and Controlling
Performed Tasks in Administrator Workbench and BPS Planning workbench
· Managing of process chains
Scheduling Data - Extraction from Modules SAP R/3 FI, CO, CRM and using InfoSources and InfoPackages for FLATFILE -Transferring Actual Data from Mainframe - Environment
· Administration Actual data and Planning Data Cubes
Developing Stakeholder Key Figures using Update Rules while Loading Update data
Loading Basic data from FI/CO and purchasing department into Actual Data Cube
Generating relevant Items from Actual data Cube into ODS - Dataset
Running Batch Job for Reading ODS Dataset records and Loading Actual data Cube while using update rules
· Debugging update rules, Simulation and Delete Booking
· Deleting loaded Data from Cube using Delete with Request number or Selective Delete
· Optimizing long running queries by Developing aggregates for relevant Key Figures and Characteristics
· Error handling after installation new InfoPackages: Replication of Cube or ODS -Object necessary
· Analysis and Repair of BW Objects using Transaction /nrsrv.
· Designing of Reports Layout for the departments Controlling, Purchasing and Marketing
Creating Request descriptions and Report Layout documentations in cooperation with the Stakeholder departments
· Developing Planning requirement: ”Managing indicators” for dep. Purchasing
Developing Planning Area using Transaction BPS0,
Creating Planning Layer, Package, Ad-Hoc Package for request
Assigning Characteristics, Key Figures and Selection to Planning Layer
Preparing Planning Function for execution using Planning Function and Manuel Planning Creating Planning Folder and developing with Transaction /nupspm
Generating Planning Folder using Transaction /nupspl and executing it from persons responsible
Performed Tasks in BEx Query Analyser, Web Application Designers and WAD -Administration
· Publishing Exception Reports using SAPConnect and Information Broadcaster
· Scheduling Reports using limit value variables. In Case of exceeding the limit value, a message or the complete report is sent to the person responsible
· Report Contence Validitation Check against Multiprovider using Transaction LISTCUBE
· Developing Formula to Caculate Percetagefunctions % (Percetage variance) and %A (Percetage share)
· Developing Queries using Data Functions: COUNT, NODIM
· Developing Queries using Boolean Operators
· Handling Formula Collision in columns and rows (Competing Formula)
· Developing Structures for multiple use
· Checking technical tables RSRREPDIR (Queries) and RSZGLOBV (Query-Variables)
· Using Parameters in Queries
Handling variables using Variables-Wizard and Variables-Editor
Developing Text variables and Charcteristic variables incl. Replacement Path
· Managing, Arranging and Grouping Reports for the persons responsible using Profile Generator in Transaction Administration Roles (PFCG) and User Management (SU01)
· Developing Variables using Enhancements for global variables in reporting called Customer -Exit
Realisation of Customer -Exit using Customer Modification(CMOD), creating Project.
Inserting ABAP – Source code into Copy ZXRSRU01 using SAP-Enhancement RSR00001.
· Testing/Debugging the Functionality of Customer -Exits using Transaction /nrsrt2
General Tasks
· Using Transport Connection using Transactions: SE09, SE10 and STMS
· Coordinating activities in cooperation with the Stakeholder departments
Tools: Administrator Workbench
Planning Workbench
BEx Query Analyzer (Excel), BEx Query Designer (Web)
Web Application Designer
BEx Broadcaster, BEx Browser
ABAP4 OO
Lotus Notes
Modules: BI, CO, CRM, FI, SD
02.2006 until today
Company Meder-Mainframe GmbH
Role Trainee
Branch Consulting
Projects SAP NetWeaver 2004 ABAP4 OO Development
SAP IDES BW Business Information Warehouse
ABAP4 OO- and Java Development
Tools: SAP NetWeaver 6.40
SAP BW/BI
SAP BW/BI Content
ABAP-Workbench
J2SE Java 2 Standard Edition
TextPad 4.7.3 32-bit Edition
11.1980 - 01.2006
Company RWE Energie AG and from1996 at ifs GmbH and RWESYSTEMS for RWE
Role IT – Consultant, Project manager
Branch Energy- and Water- Supply & Disposal
Projects EAV Energy Billing System
MDE Mobile Collection of Data
AVANZA Credit Card System
BIS Equipment Information System
STRASO Street lightning Billing System
HKA Heating Costs Billing System
RESY Travel Booking System
Tools: COBOL
C
Easytrieve Plus
PL/SQL
Oracle
Toad
MFS
IMS – DB/DC batch/online
zOS
TSO
ISPF
IMS – DB2
BTS
JCL
11.1979 - 10.1980
Company BHF-Bank in Frankfurt
Role Programmer
Branch Banking
Projects Development for Department Currencies and Shares
Customer- und Company Engagement (online)
Modification Online-Security-System from COLONIA to BHF-Bank standard
Accounting Program for Currencies (BMP)
Tools: COBOL
PL/1
VM
CMS
MFS
IMS – DB batch/online
01.1977 - 10.1979
Company RWE Energie AG
Role Programmer
Branch Energy- and Water- Supply & Disposal
Projects Realizing for Purchasing Department
MAIS HV-EK Material Billing- and Information System
Administration and Reporting for Supplier-, Customer- and Master File Data Bases
Tools: COBOL
JCL
OS-MVS
IMS – DB batch
02.1975 - 12.1976
Company Mannesmann Roehrenwerke (Now Vodafone)
Role Programmer
Branch Metal Industry
Projects Realizing Reports (Batch-Programs) for Material Department
Inventory List, Unbilled Revenue Reporting Div. Statistics
Tools: PL/1
JCL
DOS-VS
CPG (PL/1-Generator)