Change is constant

Digitalisation is today's buzzword. And all areas of our lives are affected by it. Economy, industries, society. But technical developments do not only change how we live together. They change the world we live in. We see this as a chance. This is why we at Nagler & Company shape the future – together with our clients.

Project summary

Creation of a central "SPOT" (Single Point of Truth) for bank management and regulatory purposes in the SMART DWH, where all required information is provided as the single source of truth. The following requirements, among others, must be taken into account:

  • Highest information density - single transaction level
  • All transaction data at individual institution level and at group level (group views according to different consolidation groups, such as CRR, IFRS, state, federal, etc. should be supported)
  • Presentation of basic data and results data from calculation kernels
  • Data available for dispositive applications and for SMART reporting
  • Technical and logical data model follows uniform semantics independent of source systems
  • Technical modeling takes into account a quick and easy extension of the data model and scalability

Currently, separate data sets are kept for the various evaluation purposes for bank management and regulatory purposes (in the SMART Data Warehouse, Bank Basis, ...). As a result, the individual evaluations and external reports are not comparable with each other and in some cases show inconsistencies, which was also objected to in regulatory audits.

The SPOT (Single Point of Truth) is a separate database in the data warehouse based on the ZDW (Central Data Warehouse). This means that data from the ZDW is pulled onto a common database. This was done in a first step for two clients with the aim of FINREP reporting. SPOT arises from the functional requirements for FINREP and COREP reporting. With its neutral and atomic overall data model, SPOT is to be provided in the long term with all data required for dispositive bank management and regulatory reporting in a prepared form.

Nagler & Company tasks

  • Defect management in the context of the SPOT extension
  • Support during the rollout of SPOT to additional clients

Approach

Part 1 - Defect management:

  • Subject matter experts check and clarify possible causes of defects:
    • Missing definition (specifications)
    • Missing or incorrect data (dependency, reloading in DWH)
    • Wrong sourcing (requirement specification, DP concept, software development, control tables)
    • Implementation errors (DP concept, software development, control tables)
  • Remediation of the identified errors or coordination of the remediation by software development

Part 2 - Rollout of the SPOT database to additional clients

  • Support in the coordination within the project (kickoff meetings with clients, setup of the test infrastructure, data connections, loading of the test environment, etc.)
  • Support in the analysis and/or the technical mapping by the clients
  • Technical implementation or coordination of the technical implementation by the software development department
  • Elaboration of the test strategy and execution of technical tests

Client benefit

  • Optimized SPOT through defect and test management
  • Increased customer satisfaction through reduction of defects
  • Coordination of defect removal
  • Technical support in case of defects in the specification
  • Multi-tenant capability of the SPOT

With the help of a DevOps platform the efficiency was supposed to be increased – and a bank also wanted to fulfil the higher financial supervisions. We have made our goal clear from the beginning and reached it in the end: thanks due Agile project management respectively Scrumban and elements of Design thinking. The dynamic and transparent project structure has also helped us to meet all requirements.

We have automated nearly a fifth of all applications. This translates into an autmatisation rate of 80 per cent of all release activities. The requirements of DevOps in relation to Agile project management have also been addressed – as well as the composition of a mindset for DevOps for digitalisation of this essential IT activity.

Our task was to develop innovative solutions for the digitalisation of a sales and distribution department. And this is what we did – from an idea to the concept (for example design of user experience) until implementation (with the aid of Design thinking aspects, tests and productive use).  For technical execution we applied Azure Machine learning technology and NLP components.

The fully automated solution consists of a distribution platform with daily reports: for new opportunities and automated detection of available resources. The result: a significant extension of existing distribution channels, a fundamental increase of capacities and a detailed overview of the market. Everything we have planned with our clients at the beginning of the project.

Project summary

Support the technical system integration of several regional cooperative banks into the central cooperative state bank. Introduction of NCDiff as a test tool to ensure data completeness and correctness in the IT landscape of the Landesbank. By means of before and after comparisons and a high degree of automation in report generation, the highest possible test coverage is to be achieved.

Nagler & Company tasks

  • Definition and subdivision of the established technical system landscape
  • Analysis and investigation of qualitative requirements
  • Analysis of data quality and starting points for data migration
  • Establishment of the data basis and support during data migration
  • Test management after data migration
  • Test execution: ensuring completeness and correctness of data
  • Before and after comparisons and report generation to reduce the error rate
  • Documentation of the result types

Approach

Stage 1: Initialization

  • Identification of the relevant systems to be tested
  • Subdivision of the system architecture
  • Analysis of the requirements

Stage 2: Conception

  • Test conception
  • Definition of test phases
  • Organizational framework (contact persons, processes, data collections, execution)

Stage 3: Introduction

  • Establishment & expansion of the NCDiff infrastructure
  • Establishment of the data basis (access to data/reports)
  • Test phase planning
    • Creation: analysis of data, data preparation
    • Setup: Creation of configurations
    • Test: before and after comparisons
  • Report generation

Client benefit

  • Time and resource savings through (partial) automation of before-and-after tests
  • Increase in data accuracy through the use of NCDiff
  • Before-and-after comparisons (comparative reports) through clear results
  • Automated preparation of test results and increase of test iterations, due to the reduced time needed for test execution
  • In the end, a test coverage (system-wide) of 85-95 % could be achieved

An efficient recruiting process was needed. We have overseen the project throughout its complete development life cycle – from brainstorming to design of user experience until implementation. The optimised process was realised under specific Design thinking elements, tests and productive use.

The increased efficiency in recruiting was reached with the help of a Voice assistant (Amazon Alexa), that asks the Top 100 questions to applicants. Another communication channel for Gen Y and the best way to filter qualified applicants. Without needing more resources.

The adjustment of a business strategy – with a focus on digitalisation – required the set-up of a new platform for “Deposit A” trading within the Sparkassengruppe. Our tasks: the connection of all trading systems, design and implementation of user experience. To do all this we have involved the users early on and developed the solutions together in workshops.

Nagler & Company has implemented an online platform with fully automated front-to-back workflow, that stretches across all trading system of Sparkasse. So Sparkasse can put in a request for a bond and gets a binding price as an answer. This means: The bond is – right to Sparkasse's SymCorp Dimension System – transacted fully automated and booked. A costumer loyalty of 70 per cent was reached – an absolute showcase!

Thomas Gebhard Nagler & Company
Contact Person

Thomas Gebhard

Location Graz

+43 (676) 5868089

E-Mail

Expertise