SK

Sören Koschel

available

Last update: 06.09.2022

SAP BW BI BO HANA ABAP SQL UI5 ITIL Service Hub Application Transition Change Release Management

Company: RUBIQ Consulting GmbH & Co. KG
Graduation: Bank Economist
Hourly-/Daily rates: show
Languages: German (Native or Bilingual) | English (Full Professional)

Skills

central competences

SAP BW 7.x consulting and development, development on HANA, ERP, analysis, data modeling and housekeeping, design and documentation, Testing, mappings, interface conception, Permission Management, customizing, permission management
(partly ) project lead (controlling, evaluation & steering), Hub Management, Application Management, Service Management (Change, Documentation, Release, Requirements & Transition Management), SLAs
conception of (finance ) specifialist applications, e.g. for internal and external Risk Management

examples of professional competence Regulatory Reporting:

balance sheet statistics (incl. BilMoG), margin statistics, liquidity regulations
Leverage Ratio, disclosure
Large Exposure, major and million Credit regulation
Basel II, Basel III, Basel IV, AnaCredit, BIRD, SA-CCR

examples of professional competence Risk Controlling:

Market risk controlling: Value-at-Risk procedure according to historic simulations
Credit risk controlling: Credit risk control (branches, regions, size classes etc.), CVaR, MaRisk, rating, securities, risk adjusted margin system
internal controlling according to § 11 KWG
Operational risk
Management Information Systems (MIS)

successful finished projects

HSH Nordbank, HELABA, LfA, ILB, Deutsche Bank, Volkswagen Financial Services, Deutsche Bank, Varengold Bank, Landwirtschaftliche Rentenbank


project experiences (excerpt)

05/2021 – today           Constructive Consulting Regulatory & Risk:
                                     implementation of a Data Warehouse on DB2 with data source of ERP system EFDIS as interface to government reporting software BAIS,
                                     developing on Oracle DB with PL/SQL, implementation of Cash Flows calculations, build of BAIS interface tables, Testing, documentation

12/2020 – 04/2021       Landwirtschaftliche Rentenbank:
                                     interface draft SAP to BAIS for topic SA-CCR (Counterparty Credit Risk) at a state development bank, requirements engineering in SAP BW on 
                                     HANA and SAP FRDP, automated ETL binding of source data via (UC4-) process chains triggered DataSources, Data Layer implementation and
                                     supply, extraction programs for XML data in ABAP, result storage on SAP application server, supply program of BAIS interface from HANA views 
                                     in ABAP transaction SE80 mostly, implementation of necessary Calculation Views (Outbound) in HANA Studio, communication and arrangement
                                     with IT control and project lead
 
10/2020 – 12/2020       Varengold Bank:
                                     Data Warehouse draft in Amazon Cloud AWS for reporting to BAIS interface at a direct bank, test conception, test automation and test data
                                     builds in MS Access and Excel mostly, analysis of existing databases and software solutions, strong teamwork with customers IT and relevant
                                     specialists

02/2020 – 09/2020       VWFS - Volkswagen Financial Services:
                                     Hub & Application Management of 19 bank specific applications in SAP BW 7.x, BW on HANA, BW/4HANA and HANA native at a retail bank,
                                     there professional and organizational control and support of the Spanish support teams, agile requirement consultation and recording, design 
                                     and implementation, prioritization, escalation instance, ticket fallback, head of knowledge transition from customer to Spanish Support
                                     team, monitoring & controlling of Automic (UC4-) process chains, part project lead and budget responsibility

08/2019 – 02/2020       Deutsche Bank:
                                     Hub, Application & Problem Management of KPI Reporting solutions in SAS 9.4 and Hadoop Data Lake applications at a Major bank, data    
                                     migration responsibility, there professional and organizational control and support of the Indian and European support teams, prioritization, 
                                     escalation instance, ticket fallback, strategy consultation and technical analysis of patch and Tech-Refresh-Agendas, part project lead, 
                                     implementation of permission levels in agreement with specialists analogous to the AGDLP principles, Problem Management for all Hubs from 
                                     Oracle DWH over SAP to SAS, DR: planing, steering and tracing of the half year Desaster Recovery Tests along with Stakeholder Management
                                     of all affected CIs and specialists

06/2017 – 12/2019       Deutsche Bank:
                                     3rd Level Support (incident fixing, system maintenance and care, data and user handling, performance monitoring and improvement) and
                                     Change, Documentation & Release Management for controlling and performance reports in SAP BW 7.4 at a Major bank, Scrum based
                                     requirements fulfillment for result analysis of all German departments with target device iPad via SAP BI mobile, Fiori (UI5) and BI Launchpad, 
                                     backend development in SAP BW and on the SAP HANA native, based on data storage and modeling on native HANA, there conception and 
                                     implementation  of permission control in the Administration Console of the BI Launchpads and the Fiori Launchpads for the SAP BO objects / 
                                     OData and implementation of data permission rights in SAP BW with transactions RSECADMIN, PFCG, SPRO and SE54, privileges definition, 
                                     restrictions and granted roles in HANA Studio and in the SE38, design, implementation & tracking of Automic (UC4-) process chains, Scrum 
                                     Master per pro., Problem Management for all Hubs from Oracle DWH over SAP to SAS, DR: planing, steering and tracing of the half year     
                                     Desaster Recovery Tests along with Stakeholder Management of all affected CIs and specialists

03/2016 – 05/2017       ib-bank-systems:
                                     head of internal SAP BI/BW competence centre of a consulting company, prototyping and employee ‘s training, draft of a Manage­ment 
                                     Information System, draft of a project sketch for requirements implementation and docu-mentation process Credit reporting due to AnaCredit 
                                     especially customer data (KYC), BCBS 239 and BIRD (Banks Integrated Reporting Dictionary) at a state development bank

03/2016 – 05/2017       ILB – Investitionsbank des Landes Brandenburg:
                                     developer for implementation of reporting duties on EFRE and ESF grants to the MASGF at a state development bank in SAP BW 7.4 with XML 
                                     and WSDL services and ABAP OO methods in SE80 und RSA1 mostly, conception and extraction of indicators from SAP source system and 
                                     BW DSOs or Data-Sources, adjustments and requirements engineering of Analysis for Office reports and Crystal Reports and Fiori Apps     
                                     (development on WebIDE and with UI5)  including rolls, permissions and access maintenance (LDAP authentication, Fiori Area Management) on 
                                     reports following customers restrictions, GoLive support et al. in SolMan

01/2015 – 03/2016       LfA - Bayerische Landesanstalt für Aufbaufinanzierung:
                                     introduction and development in SAP BW 7.31 with source system SAP CML at a state development bank, 3rd Level Support for SAP BW
                                     reports of all departments, especially for risk, controlling and Major customer reporting, including according to § 18 KWG, architecture, 
                                     maintenance and documentation of the SAP BW objects, reporting design for CIP / EIF, EFRE / ESF and risk adjustment, customizing of extrac­-
                                     tors and system parameters, permission management in strong teamwork with the departments analogue the ERP source system specifications 
                                     in SAP CML (loan management module) in SAP BW with transactions PFCG, SPRO and SE54, permission control in CML and BW via 
                                     transactions SUIM, SU02 et seqq., SU21 et seqq., SU53 and SQVI and via User Exits, acquisition, design, concept and implementation of 
                                     Change Requests of several specialist areas, GoLives operations

09/2014 – 01/2015       ib-bank-systems:
                                     knowledge gaining and employee´s training and responsible for all topics regarding SAP HANA and SAP BW on or /4HANA, technical and           
                                     economic assistant of unit lead insurance & building savings and of the Senior Manager SAP BI/BW

02/2014 – 08/2014       HELABA - Landesbank Hessen-Thüringen:
                                     design and implementation of an object-oriented calculation core in the SAP FI module for grants according to HIAP and HALM 2014 regulations 
                                     at a state bank, development, customizing, test and documentation, intensive exchange with lead specialist on the necessary rules and 
                                     conditions of the guidelines for agricultural grants

07/2013 –01/2014        HSH Nordbank - Hamburgisch-Schleswig-Holsteinische Nordbank:
                                     developer of procedural and object-oriented solutions in SAP DM 8.0 as part of release switch, there data migration, optimization of the D-E-R
                                     via parallelization of processing processes of bottom lines, adjustments of BNKA on SEPA, program development of Whitelisting, adjustments on 
                                     different programs like Cash Pooling, 3rd Level Support, QuickViewer analyzes, Customizing, third party connection via Unixcom, testing,
                                     documentation and conception of requirements and changes, permission control via transactions SUIM, SU02 et seqq., SU21 et seqq. and 
                                     SU53, permission granting according specialist´s concept in transactions PFCG, SUUM and SUPC and via User Exits


data processing skills

SAP ERP und Module        SAP R/3 6.0, BCA, CML, DM, FI, CO, FSBP, FRDP, S/4HANA, SAP HANA, Business Explorer, Business Objects
SAS                                    SAS 9.4, SAS Visual Analytics 7.4
operating systems             Windows, Linux Ubuntu
reporting systems              SAP BI Suite BEx, SAP AfO Analyse for Office, BO/BI (mobile), SAP BW 7.x, BW on HANA, BW/4HANA, Crystal Reports, Bank Analyzer,
                                           sAFI
basic software                    MS Office especially Access, Excel, Word und PowerPoint
data bases                          HANA, DB2, Oracle, MaxDB, MS Access, SQL (tools e.g.: DBeaver, Eclipse, HANA Studio)
reporting software               BAIS
tools and communications  Adobe, Confluence, JIRA, HP ALM, HPQC, Lotus Notes, SAP Solution Manager, SAP Fiori, SAP PowerDesigner, NetWeaver, ServiceNow, 
                                            StarUML, UltraEdit, WebIDE
programming languages     ABAP/4, ABAP Objects, Javascript, SAPUI5, VBA
certifications (excerpt)         ISAQB, ISTQB, ITIL, PRINCE2, SAP ABAP Developer, HANA, SAP BI 7.x

Project history

05/2021 - Present
development Data Warehouse DWH as interface to legal regulatory plattform BAIS based on the ERP EFDIS in PL/SQL on Oracle DB & DB2
Constructive Consulting GmbH (Banks and financial services, 50-250 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please

12/2020 - 04/2021
SAP Entwickler BW on HANA PowerDesigner HANA Studio Calculation Views
Landwirtschaftliche Rentenbank (Banks and financial services, 50-250 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


10/2020 - 12/2020
Business Analyst MS Access DBeaver SQL Testing data model design DWH for BAIS reporting
Varengold Bank AG (Banks and financial services, 50-250 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


02/2020 - 09/2020
Hub & Transition Management BW on HANA, BW/4HANA, BW 7.31, L3 Entwicklung, Change & Release Management, Requirements, Consulting, Stakeholder Management
Volkswagen Financial Services VWFS (Banks and financial services, 500-1000 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


06/2017 - 02/2020
Hub & Transition Management BW on HANA, HANA native, BW 7.5, L3 Entwicklung, Change & Release Management, Anforderungsanalyse, Consulting, Stakeholder Management
Deutsche Bank AG (Banks and financial services, >10.000 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


03/2016 - 05/2017
SAP ABAP OO Entwicklung im SAP BW 7.5 - development of WSDL interface for deep XML as interface to ministry MASG to report EFRE & ESF loans
Investitionsbank des Landes Brandenburg ILB (Banks and financial services, 50-250 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


01/2015 - 03/2016
SAP BW 7.31 roll-out based on SAP CML, appliation development and ETL and reports implementation for all specialist areas
Förderbank Bayern LfA (Banks and financial services, 50-250 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please

02/2014 - 09/2014
SAP ABAP OO development in SAP FI - implementation of a calculation engine for agricultural state subsidies
HELABA (Banks and financial services, 1000-5000 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


06/2013 - 01/2014
SAP ERP development in module Deposits Management DM Release change from 6.0 to 8.0, SEPA, parallization daiyl end run, whitelisting, reports, ABAP prozedural and OO
HSH Nordbank (Banks and financial services, 500-1000 employees)

Refer to chapter Skills - Fähigkeiten, Kenntnisse, Erfahrungen please


Local Availability

Only available in these countries: Germany, Austria und Switzerland
yes

Other

ANÜ oder Dienstvertrag o.ä. über Constructive Consulting GbmH möglich
Profileimage by Soeren Koschel SAP BW BI BO HANA ABAP SQL UI5 ITIL Service Hub Application Transition Change Release Management from Frankfurt SAP BW BI BO HANA ABAP SQL UI5 ITIL Service Hub Application Transition Change Release Management
Register