Profileimage by Andreas Loescher SAP BW / SAP NetWeaver Portal Consultant from Wattenbek

Andreas Löscher

available

Last update: 09.05.2020

SAP BW / BI Consultant

Company: Lutra Solutions GmbH
Graduation: Dipl.-Wirtschaftsinformatiker (FH)
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional) | Spanish (Elementary)

Attachments

LumiraDesignerDeltaZertifikat.jpeg
Zertifizierung BW4HANA.jpeg
Lebenslauf.docx
Projektliste_250523.docx

Skills

SAP BW/BI

Reporting:
- BEx Query Designer 3.5, 7.0
- BEX Analyzer 3.5, 7.0 (Queries, Workbooks, Query-Views)
- BEx Web Application Designer 3.5, 7.0
- BEx Broadcaster
- MIME - Repository (custom methods via JavaScript, design optimizing via CSS)

ETL:
- ABAP 4 / ABAP Objects
- Data-Warehouse-Layer BW 3.5, 7.0
- XML-Import for automatic generation of BW-elements (e.g. InfoObjects)
- Take over of Business-Content-DataSources
- Creation and connection fo generic DataSources (SAP, Non-SAP)
- Enhancement of Business-Content-DataSources

Planning:
- SAP BW Integrated Planning

Administration:
- Useradministration (local, central via CUA)
- Authorisation Concept 3.5, 7.0 (Analysis Authorisations)
- Performance-Optimizing3.5, 7.0 (standard-precalculation, individual scripts for , aggregates, line-Items, cube-partiotions)
- Processchainmanagement
- Transportsystem


SAP Netweaver Portal

- Roleadministration
- Worksets
- Iviews
- Pages
- Motives
- Portal-Monitoring
- Transportsystem


ECC Process Knowhow
- Material Management
- Inventory Management
- Sales and Distribution
- Profitability Analysis


comprehensive qualifications

- Windows 7, XP, Vista
- SUSE Linux 9.3
- Microsoft Office
- Adobe Dreamweaver
- Adobe Photoshop
- GIMP
- SAP Solution Manager
- ARIS for SAP NetWeaver
- HTML
- CSS
- JavaScript
- MySQL


Educations
- SAP BW 310 Enterprise Data Warehousing
- SAP TBW 45 Integrated Planning
- ICT Assistant Web SIZ (swiss information technology centre)

Project history

//Technical project management of \\\\\\\"Purchase monitoring\\\\\\\"
//Implementation of a reporting environment for purchases and monitoring of various Migros industries

• Use of standard data sources (MM-PUR for purchase documents and contract reporting, MM-INV for
inventory analysis) and generic data sources (for goods expenditure analysis)
• Data flow modelling using BW 7.0 tools (DSO, transformations, DTPs)
• Automation of the loading selection in info packages and DTPs via a control table and routines
• Development of reporting using BW 7.0 queries and BW 7.0 web applications
• Publication via the Netweaver Portal
• Authorisation concept in accordance with BW 7.0


//Technical project management of \\\\\\\"IT service key figures\\\\\\\"
//Development of a reporting and planning environment for the head of IT

• Connection of the IT service management system \\\\\\\"OTRS\\\\\\\" using UD Connect
• Data flow modelling using BW 7.0 tools (DSO, transformations, DTPs)
• Development of planning architecture using BW IP
• Development of reporting using BW 7.0 queries and BW 7.0 web applications with a planning
function to record target values
• Authorisation concept in accordance with BW 3.5


//Technical project management of \\\\\\\"substances reporting\\\\\\\"
//Development of a reporting environment for the R&D sector of the company

• Automatic generation of over 2000 information objects using Perl script and XML importing
• Use of standard data sources (EH&S for the evaluation of substances and their characteristics)
• Data flow modelling using BW 7.0 tools (DSO, transformations, DTPs)
• Development of reporting using BW 7.0 queries and BW 7.0 web applications
• Publishing via the Netweaver Portal
• Authorisation concept in accordance with BW 3.5


//Technical project management of “Authorisation migration from BW 3.5 to BW 7.0”
//Change in the authorisation concept for the whole group reporting system (approx. 150 roles)

• Authorisation changeover via analysis authorisations
• Removal of existing weaknesses
• Restructuring via composite roles
• Standardisation of the naming convention


// Technical responsibility for \\\\\\\"Migration of logistics reporting from BW 3.5 to BW 7.0”

• Change from database links to database connection
• Incorporation of generic data sources from the statistics database of the Migros Verteilzentrum Suhr
[Suhr Migros distribution centre] (MVS)
• Replacement of transfer and update rules by means of transformations
• Adaptation of the programming logic within routines

//Technical responsibility for the \\\\\\\"Replacement of the management cockpit with the Netweaver Portal”
//Implementation of reporting environments of the 11 Migros industrial plants on the Netweaver Portal

• Development of portal architecture (with external partners) via roles, worksets, pages, iviews,
motives, rule sets
• Migration of existing BW 3.5 web applications to BW 7.0 web applications
• CSS creation for design optimisation
• Java script creation for the realisation of blocking logic (Bex variable requests)


//Technical project management of \\\\\\\"Purchase monitoring\\\\\\\"
//Implementation of a reporting environment for purchases and monitoring of various Migros industries

• Use of standard data sources (MM-PUR for purchase documents and contract reporting, MM-INV for
inventory analysis) and generic data sources (for goods expenditure analysis)
• Data flow modelling using BW 7.0 tools (DSO, transformations, DTPs)
• Automation of the loading selection in info packages and DTPs via a control table and routines
• Development of reporting using BW 7.0 queries and BW 7.0 web applications
• Publication via the Netweaver Portal
• Authorisation concept in accordance with BW 7.0


//Technical responsibility for \\\\\\\"Migration of turnover deviation analysis from BW 3.5 to BW 7.0”

• Replacement of transfer and update rules by means of transformations
• Adaptation of the programming logic within routines
• Automation of the loading selection in info packages and DTPs via a control table and routines (data
basis CO-PA data sources)

Local Availability

Only available in these countries: Germany, Austria und Switzerland
actually not available
Profileimage by Andreas Loescher SAP BW / SAP NetWeaver Portal Consultant from Wattenbek SAP BW / BI Consultant
Register