Udo W.-Performance Improvements

Application ownership and further development of test user management (TUM)

Areas of responsibility: Application ownership (Application Ownership / ITSO), application management, incident management, deployment / release management, requirements management, prioritization, further development, automation, and interface management

Technologies: SQL Server, Python, GitLab, UC4, Lieberman, Linux

Responsible for the operation and continuous development of a central application for managing more than 5.000 technical test users and their data.

Gathered and assessed business requirements, independently prioritized further development, and planned and coordinated implementation using agile methods and PI Planning, in close collaboration with the relevant business units and IT teams.

Expanded the central SQL Server database with additional information about test and real users, and integrated further applications through defined interfaces. The modular application used Python-based processing components, with execution and workflows controlled through UC4. This enabled data from different source systems to be automatically transferred, processed, and made available, as well as new test users to be created automatically.

Ensured reliable application operations and continuously optimized and automated existing processes.

Application ownership, modernization, and migration of incident management (TRANT)

Areas of responsibility: Application ownership (Application Ownership / ITSO), application management, incident management, deployment / release management, requirements management, software modernization, migration, interface integration, and quality assurance

Technologies: UC4, Jira, SQL Server, Oracle, Java, Python, Lieberman, Linux, Jai

Responsible for the operation and development of an application that automatically records, processes, and forwards technical incidents in various test environments.

Automated the creation of Jira incident tickets when UC4 workflows were blocked, including routing them to the relevant application managers.

Modernized the application by migrating from Java to Python, moving the database from Microsoft SQL Server to Oracle, and replacing the Jenkins scheduler with UC4.

Integrated the Jira API and used the bank's internal AI solution Jai to support code migration and subsequent validation. Independently and critically reviewed AI-generated results for business and technical accuracy.

Shift lead for operations control in test environments

Areas of responsibility: Monitoring various test systems

Technologies: UC4, TSO, HOST, Azure-Cloud

Responsible for monitoring and controlling automated processing workflows in various test environments, including systems running in the Azure-Cloud.

Monitored UC4 and HOST workflows and analyzed and handled incidents. When processing workflows were blocked, Jira tickets were automatically created through TRANT and assigned to the relevant application owners. In coordination with them, affected jobs were restarted or stopped as needed. HOST processes were also monitored and controlled through OPC.

A multi-shift operation was introduced to ensure stable and as continuous as possible testing.

Test data anonymization manager

Areas of responsibility: Planning/anonymizing/publishing production data for test systems

Technologies: UC4, Informatica (PowerCenter and IDMC)

To ensure test environments could run with real data, production databases were cloned regularly. Production data had to be untraceable in test environments. For this reason, the cloned databases were first anonymized with Informatica PowerCenter and later with Informatica IDMC. Critical tables and columns in the various databases (Oracle, SQL-Server, MongoDB) had to be identified and analyzed at the data level. Rules for handling critical data were agreed with the application owners.

Areas of responsibility: Agile requirements planning, PI Planning, Sprint Planning, PL/SQL development, Oracle Forms development, testing, and quality assurance

Technologies: Oracle 12c, SQL Navigator, Oracle Forms, UC4

Extended and further developed an existing Oracle-based insurance application to automatically assign mandatory reinsurance to active insurance policies.

Analyzed existing application logic and adapted and developed program modules and reports using Oracle Forms and PL/SQL.

Further developed interfaces to transfer reinsurance-related postings to the connected SAP system and AIG main system, taking business posting rules and posting periods into account.

Implemented requirements using agile methods, including PI Planning and Sprint Planning. Analyzed complex business requirements, broke them down into manageable development tasks, and conducted business and technical testing of adapted and newly developed components before launch.

Areas of responsibility: Development, architecture

Technologies: Microsoft SQL Server 2014, Microsoft SQL Server Management Studio, Oracle 12c, ODI

Migrated an existing Microsoft SQL Server database to Oracle 12c as part of a strategic technology change.

Analyzed the existing database structures and transferred the data, stored procedures, functions, and triggers to the Oracle target environment.

Ported the existing T-SQL program logic to PL/SQL, taking into account the differences between the database architectures and optimizer behavior.

Reviewed and adjusted existing indexes for their suitability and performance in the Oracle database. Loaded the data using Oracle Data Integrator (ODI).

Areas of responsibility: subproject management, development

Technologies: Windows XP, Oracle 10g, PL/SQL, Toad, PL/SQL Developer, Oracle Data-Integrator, Oracle Warehouse Builder OWB

A centralized authorization management system for network drives and SAP was developed for a global chemical company. The system coordinates and manages data for over 8500 companies and over 20000 organizations, managing permissions for over 450000 users across over 700000 roles. Permission approvals were managed through the SAP workflow. Permission requests were transferred to the target systems using Oracle Data-Integrator. Approval and revocation of permissions were securely stored in a way that could be traced for financial audits. SAP WEB Dynpro was used for the interface to manage approvals. The data interface between the Oracle database and the SAP frontend was managed using PL/SQL packages, which returned data through open cursors.

Areas of responsibility: data preparation for reports

Technologies: Windows XP, Oracle 10g, PL/SQL, Toad

For executive reports presented as balanced scorecards, database elements had to be combined and bundled before being sent to the frontend. To do this, data had to be selected using PL/SQL and returned as table values. These values were combined in VB .Net and displayed as a report.

Areas of responsibility: Technical subproject leadership, requirements management, software development, data and interface integration, application modernization, functional and technical specifications, testing and error analysis

Technologies: Windows (XP, 2000), MS-Projekt, Oracle 8i/10g, Java, Forms/Reports 5/6i, PL/SQL, Toad, SftTree 2/5, Citrix, Eclipse

Further development and customer-specific customization of an Oracle-based CRM system for EnBW's special customers, connected to SAP-IS-U billing.

Analysis and implementation of business requirements, as well as enhancement of existing application functions using Oracle Forms/Reports, PL/SQL and Java.

Integration of external applications and data sources through defined interfaces, including a Java-based pricing tool and the SAP-IS-U address database.

Preparation of functional and technical specifications in close coordination with the customer.

As technical subproject lead, responsible for a defined release area, including planning, assigning and coordinating development tasks, as well as monitoring their implementation.

Ongoing development of the application over several releases and technological modernization through migration of the Oracle database from version 8i to 10g and upgrade from Oracle Forms 5 to Forms 6i, including SftTree 2 to version 5.

Areas of responsibility: Further development of a power grid control system, customer-specific software customization, testing and installation support, time synchronization, trial operation

Technologies: DEC-OSF, C, C++, FORTRAN 95, Unix-Shell, Oracle

Customer-specific further development of a power grid control system for monitoring and controlling PreussenElektra's power grid.

Analysis and customization of existing software components, in particular enhancement of existing FORTRAN applications to meet the customer's business and technical requirements.

The control system was based on DEC workstations and a real-time system and was designed as a high-availability solution with a target availability of 99,95 %.

Supported installation, testing and trial operation, and took on special tasks in the area of time synchronization.

Technologies: MS-DOS, OS/2, C++

Developed an installation program for bank employees so they could install software packages independently without assistance.

Technologies: Unix (UTS, SINIX, Solaris), Rosi-SQL, UNIX-Shell, UNIX-Tools, C, Informix, Informix-OnLine

Consolidation of the databases from over 100 computer systems onto a mainframe. The computer type, Informix version, and programming language version were changed in the process. The program and data storage were adapted to the new environment. A contingency plan was developed.

Technologies: MS-Dos, C, Retrieve

Technologies: MS-Dos, GEM, C, Fortran, SPICE

Technologies: MS-Dos, Fortran, SPICE

Analyzed the program flow and used the results to create a suitable overlay structure for the program code