Gerhard H.
Application Development
Experience
Lila Logistik
Application support
Application development:
- Cobol
- Enhancements based on customer or in-house requirements
- Support in ensuring the ongoing operation
Cobol, HP3000, MPE/XL operating system, IMAGE database, WHISPER (development environment)
Application development
HDIW UG (limited liability)
To simplify work processes, various workflows are created.
- automatically searching an RSS feed for suitable projects. The results are stored in an Airtable table. This table is used to monitor the projects and rate them accordingly.
- created a table in Airtable to record the projects. Based on this table, a workflow was built that reads it and fills a Google Docs template for each entry, which then serves as a basis for a profile. You can also display the profile in a condensed form by applying a filter to the Methods field, for example 'UC4'. This then outputs all projects where UC4 is a topic.
- a workflow that searches saved web pages tagged #share in Pocket. In OpenAI, the web page is summarized. This summary is generally done in German. The first output appears in a Google Sheet. In the second step, this Google Sheet is read and finally stored in an Airtable table. A link to the results can be generated, which can be shared if needed.
Airtable, Google Docs, Google Sheets, Make, OpenAI, Pocket
Application development
ADAC IT Service GmbH
The project involves the qualified support of a host system that manages and sends invoices, reminders, and ADAC memberships. Necessary adjustments and developments are also to be made on the respective system.
- analysis and correction of production errors
- analysis of integration test errors to support functional testing
- analysis and implementation of mandatory software changes
CRM, DELTA-PL/1, TSO, ZOS
Application development
ADAC SE
Support for the 'Mailing Service' for handling postal mailings via Deutsche Post.
- program development in the legacy system until the current mailing system is replaced
- modifying procedures 1078/1088 for mailing
CRM, DELTA-PL/1, TSO, ZOS
Application developer
City and State of Salzburg
Support for the custom application 'IPIS' for personnel management and payroll of the State of Salzburg.
Application development with ADABAS/NATURAL in the 'IPIS' project
- program development for migrating IPIS to SAP
- handling IPIS tickets until the custom 'IPIS' application is replaced by SAP
ADABAS/NATURAL, CITRIX, JIRA, ECLIPSE, SOFTWARE AG DESIGNER
Application Developer
Dehner Holding GmbH & Co. KG
Support in the area of inventory management through development services
Application development in COBOL in the 'Inventory Management System' project
- Development of general COBOL applications
- Testing the developed software and logging the results
- Conducting acceptance of the developed software
- Complete documentation of the developed software according to the given standards and forms (inline/external)
- Full handover of the developed program source code, documentation, and software test logs
Outcome:
- Requirements analyses
- Detailed designs
- Source code, object code (COBOL)
- Test logs
- Complete documentation
CITRIX, COBOL, ECLIPSE, IT-WORKBENCH, JIRA, SUBVERSION, PUTTY,ORACLE, XBM
Deutsche Rentenversicherung
Redesign of the audit service applications
Application development in COBOL in the 'Redesign of the audit service applications' project, aiming to migrate the database to DB2 (from VSAM)
- Creating requirements analyses and detailed designs
- Developing general COBOL applications as well as COBOL applications with DB2 access (CRUD) in a z/OS environment
- Developing complex SQL queries adapted to the technical capabilities of DB2 subsystem version 9/10 in a z/OS environment
- Optimizing SQL queries (version 9/10, DB2) and the necessary performance analysis methods
- Testing the developed software and logging the results
- Conducting acceptance testing of the developed software
- Implementing necessary bug fixes and, if needed, updating the relevant requirements documents
- Integrating the developed applications into the CUP-D infrastructure
- Complete documentation of the developed software according to the given standards and forms (inline/external)
- Full handover of the developed program source code, documentation, and software test logs
- After a successful migration to DB2, a further migration of the DB2 application to Oracle and Linux followed.
- PostgreSQL replaced ORACLE
Outcome:
- Requirements analyses
- Detailed designs
- Source code, object code (COBOL)
- Test logs
- Complete documentation
COBOL, DB2, ORACLE, VSAM, JCL, REXX, VISUAL-COBOL, GIT, BITBUCKET, JENKINS, JIRA, UCD, IBM RATIONAL DEVELOPER FOR Z SYSTEMS, KANBAN, MF-WORKBENCH, DB-VISUALIZER, SQL-DEVELOPER
Application Developer
DZBW
Master craftsman grant
Because the two people responsible for this area were unavailable, I analyzed production errors and created handover documents from the existing materials to make it easier for a successor to get started.
COBOL, CICS, VSAM, JCL
Application Developer
Bayerische Landesbank
Support in the 'BILDAMAN' project (Balance Data Management System): development, testing, design, COBOL, databases, and support in the 'Business Partner' project: development, testing, design, PL/1, databases
Implementation of various requirements in the area of
- Implementation of change requests based on technical specifications
- IT concept
- Test logs
- Complete documentation
- Requirement from auditors to implement the four-eyes principle in this application
COBOL, PL/1, CICS, DB2, SAS, JCL
Application Developer
DEKA Bank
Support DBD – FISP support, development, testing, design, COBOL, databases
Implementation of various requirements in the area
Outcome:
- Requirements analyses
- Detailed designs
- Source code, object code
- Test logs
- Complete documentation
COBOL, ADABAS, NATURAL, JCL, XPEDITER, ENDEVOR
Merkur Insurance
Redesign of ATÜ (Interface representative / application)
The existing ATÜ application is to be completely rebuilt on a new foundation as part of an overall redesign of the insurer's applications.
Result:
- Requirements analyses
- Detailed designs
- Source code, object code
- Test reports
- Complete documentation
ADABAS, NATURAL, NATURAL ONE, JASON, AJAX, JIRA
German Pension Insurance
Redesign of the audit service applications
Application development in COBOL in the project Redesign of the audit service applications aiming to migrate the database to DB2 (from VSAM)
- Creation of requirements analyses and detailed designs
- Development of applications in the z/OS environment
- Testing of the software produced and logging the results
- Carrying out acceptance testing of the software produced
- Performing required bug fixes and, if necessary, updating the respective requirements documents
- Integration of the developed applications into the CUP-D infrastructure
- Complete documentation of the software produced according to the given standards and forms (inline/external)
- Full handover of the program source code, documentation, and test reports
Result:
- Requirements analyses
- Detailed designs
- Source code, object code (COBOL)
- Test reports
- Complete documentation
Visual COBOL, DB2, VSAM
Application Developer
IT&M (City of Munich – Vehicle Registration Department)
Area of work: Kfz-CS Dialog
The main task is to implement legal requirements for the temporary license plates topic in the Kfz-CS Dialog module. Additionally, support ticket processing and, if needed, assist in the I-Kfz area.
ADABAS, NATURAL, NATURAL Studio, NATURAL One, LINUX, shell scripts, SAG Dialog Framework
Application Developer
IT&M (City of Munich – Citizen Services Department)
Supported the client for about 2 months in the PAMELA project (resident registration, naturalization) due to absences from illness.
The main task was to take on pending tasks in the PAMELA project (resident registration) in order to carry out the migration to OK-EWO. Within this project, changes had to be made mainly in the following areas:
- Resident registration
- Naturalization
- Driver’s licenses
- Elections
- Authorization management
ADABAS, NATURAL, NATURAL Studio, operating systems BS2000, LINUX, shell scripts
Application Developer
Church Computing Center Foundation of Southwest Germany
Application in church registration services.
The main task is to take on pending tasks in the DaviP project (church registration services). Within this project, changes must be made mainly in the following areas:
Functions, tasks, and results of the DaviP project:
- Providing information and certificates
- Creating reports and statistics
- Archive management and history
- Preparation of XKirche
- User management (authorization management)
XKirche: The OSCI-XMeld standard defines a common language for data exchange in registration services. Messages exchanged between systems then have the same basis. This way, registration offices can exchange data securely and without media breaks with each other, as well as with third parties – even when using different data processing systems. Currently, the church data centers receive files with registration changes from all providers, which are then processed into the existing procedures. From 1.11.2015, these messages will come in XML format.
ADABAS, NATURAL, NATURAL Studio, operating system z/VSE under VM/CMS
Raiffeisen Solution
As part of a bank merger, the entire software of one of the two banks is migrated to the software of the other bank.
The task is to convert newly created interfaces into the format of the old interfaces so that customers using these interfaces do not have to make any changes.
ADABAS, NATURAL, NATURAL Studio, NATURAL One, LINUX, Shellscript, SAG dialog framework
Developer, concepts, testing
DZBW
Took on upcoming tasks for the statewide resident information system DB2. I also supported the migration from LEWIS to KMEWO, especially the migration of any pending XMELD messages. In this project, changes had to be made mainly in the following areas:
LEWIS-BASIS registry. Managing resident data
- Providing information and certificates
- Applying for ID documents and certificates of conduct
- Preparing elections and votes
- Creating income tax cards and maintaining the master list
- Creating messaging services
- Political and postal division of the municipality area
- Electronic communication with citizens and authorities
- Creating reports and statistics
- Archive management and history
- Supplying portals and other systems
- Archiving XMELD messages into an Excel process
- User management
LEWIS-XMELD: The OSCI-XMeld standard defines a common language for data exchange in registration services. Messages exchanged between systems then have the same basis. This allows registration authorities to exchange data securely and without media disruptions among themselves and with third parties – even with different data processing systems. One example is the handover of data for issuing income tax cards to the Federal Central Tax Office (BZSt) (§39e para. 9 EStG) (OSCI-XMELD (Release D – Chapter 13, Message 0527)). The changes in the applications listed above are based on legal requirements as well as user requirements.
Cobol, Delta Cobol, DB2, CICS, CMS, Oracle Developer, Ossy dialog development, SAS, TSO, XML, XPEDITER
HypoVereinsbank (Unicredit)
As part of a bank merger, the EUROSIG 9000 project was launched to migrate the entire software of one bank to the software of the other bank.
The task was to write unloaded DB2 tables into a memory structure using standardized programming, then create files whose contents would be loaded into new DB2 tables. Additionally, modules were created to verify the plausibility of the generated data.
Cobol, DB2, ENDEVOR, standardized programming
Fiducia
An existing securities application was replaced by a new system. This change was not implemented for all participating banks at once; instead, banks were converted one after the other. The old application used an IMS database, while the new one used a DB2 database.
In every module that included database accesses, these were replaced with calls to a program. The central module first checked whether the bank had already been switched. If yes, data accesses were run on the DB2 database; if not, they were executed on the IMS database. In addition to the code changes, very extensive testing was needed.
CICS, Cobol, DB2, Endevor, IMS, IMS-DC, SWT02, z/OS
BHF Bank
An existing securities application was replaced by a new system. This was done not for all participating banks at once but one after the other. The old application used an IMS database, the new one a DB2 database.
In all modules where database accesses were present, these were replaced by a call to a program. In this central module, a check was done first to see if the bank had already been switched. If yes, the data accesses were executed on the DB2 database; if not, they were run on the IMS database. Besides the code changes, very extensive testing was required.
Cobol2, DB2, IMS-DB, IMS-DC, IMS-GSAM, JCL, UC4, Xpediter
HSBC Trinkaus & Burkhardt (ITS Service GmbH)
Order sets should be generated from incoming external data.
The corresponding modules were created to process and prepare this external data, so that order sets can be generated.
CICS, Cobol2, DB2, IMS-DB, IMS-DC, IMS-GSAM, JCL, UC4, Xpediter, z/OS
TxB
Assigned tasks in a banking environment, where I gained a lot of experience through various projects, were completed according to specifications.
The main tasks were in the area of order routing, forward transactions and customer forms
Adabas, Assembler, CICS, Cobol, Cobol2, MQSeries, Natural, PL/1, Predict-Case
HSBC Trinkaus & Burkhardt (ITS Service GmbH)
A securities application of a bank was to be migrated to the GEOS securities system.
The task was to analyze the application and determine what adjustments were necessary in the GEOS system to perform the migration.
CICS, Cobol2, DB2, ROCHADE, TSO, UC4, WebSphere, z/OS
TxB
Assigned tasks in a banking environment, where I gained a lot of experience through various projects, were completed according to specifications.
The main tasks were in the area of order routing and corporate actions
Adabas, ADASQL, Assembler, Cobol, Endevor, MQSeries, Natural, PL/1, Predict-Case, z/OS
Kassenärztliche Vereinigung Baden-Württemberg
Assigned tasks at a statutory health insurance physicians' association were completed according to specifications.
For EBM 2005, new OIII services were defined. This required extensive changes to the online data entry
Adabas, Natural, SCO-Unix, Shell-Scripts, Sun Solaris, Windows 2000
TxB
Assigned tasks in a banking environment, where a lot of experience was gained through various projects at this bank, were completed according to specifications.
The main tasks were in the area of order routing, order entry, and developing a new online "Savings Plan" function.
Adabas, ARTEMIS, Assembler, CICS, Cobol, ENDEVOR, IBM390, ISPF, MQSeries, Natural, PL/1, Predict-Case, TCP/IP, TSO, VTAM
TxB
Tasks in a banking environment. An existing securities application was to be replaced by a new one.
The main tasks were in order routing, order entry, and developing a new online "Savings Plan" function.
Adabas, ARTEMIS, Assembler, CICS, Cobol, IBM390, ISPF, MQSeries, Natural, PL/1, Predict-Case, TCP/IP, TSO, VTAM, ENDEVOR
Kassenärztliche Vereinigung Nordwürttemberg
Tasks at a physicians' association were completed according to specifications.
Project support in the DAS project (Diskette Billing System)
Adabas, Natural, SCO-Unix, Shell-Scripts, Sun Solaris, Windows 2000
Bayerische Landesbank
Tasks in a banking environment. An existing securities application was to be replaced by a new one.
New developments in Discount Brokerage - securities business over the internet. Specifically securities position and securities orders.
Adabas, ADASQL, CICS, Cobol, DB2, MVS, Natural, Predict-Case, TSO, Windows 2000
Kassenärztliche Vereinigung Nordwürttemberg
Tasks at a physicians' association were completed according to specifications.
Year 2000 conversion. In addition, various new developments regarding legal changes in the federal doctors' register.
Adabas, Natural, MVS, SCO-Unix, Siemens, Sinix, Sun Solaris, Windows NT
Fricke Abfülltechnik GmbH & Co.
Participated in developing a Batch Monitoring System (BMS). Controlled bottling lines
Created various dialog programs
C++, SQL, Sybase, Windows 95, Windows NT
Sanacorp AG
New development for selling products to doctors and pharmacists
Developed modules for adding new products and updating existing ones. Created diskettes and reports for each state pharmacy association. The application was developed on a PC, using ADABAS as the development database. In production it ran on ORACLE. In the development phase on PC, PARADOX was used as the database.
Adabas, OLE, Oracle, Paradox, NATURAL LightStorm
Kassenärztliche Vereinigung Bayern
Handled assigned tasks at a physicians' association following specifications.
Implemented various updates for legal changes in the federal doctors' register.
Adabas, Cobol, MVS, Natural, Windows NT
Weka Verlag
Made adjustments to the address import process
Designed and implemented address import/mailings and duplicate detection.
Unix, VSE, NATURAL for WINDOWS, OSF/1
Papier Haindl
Project support for migrating from Tandem to HP-UNIX
In 1992/93, developed the UNIX-PPS system. The existing system was expanded to integrate a high-bay warehouse and a packing line. The development environment was INFORMIX 4GL with support from the Fourgen tool.
HP, HP-UX, Informix, Informix-4GL, Tandem, Unix, Fourgen
Weka Verlag
Project support for postal code extension
As part of the postal code conversion, changes to the affected modules, in particular postage optimization, UPS optimization, importing external addresses with address verification, and adjustments for Infopost.
Adabas, Natural
Papier Haindl
Project support for PPS system
Development of a UNIX-based PPS system based on the existing IBM/Tandem application. The development environment used Informix 4GL with support from the Fourgen tool.
C++, HP, HP-UX, Informix, Informix-4GL, Tandem, DPPX/SP (IBM operating system), Fourgen
Landeszentralbank Nordrhein-Westfalen
Creating tape software
Creating CFE applications. Creating tape software on the PET-MAESTRO system that reads files that can then be loaded into an IBM system.
Maestro, Maestro II, CFE
Summary
Mr. Haunstetter's consulting focus is on software development. He has been working in the mainframe environment since 1992.
Languages
Education
Munich University of Applied Sciences
Diploma in Business Administration · Business Administration · Munich, Germany
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.