Gerhard Haunstetter - Application Developer

Donauwörth, Germany

Experience

Aug 2024 - Dec 2024

5 months

Germany

Application Developer

Lila Logistik

Supported the application
Developed applications in COBOL
Extended customer and in-house requirements
Assisted in ensuring smooth operation
Methods/tools: COBOL, HP3000, MPE/XL operating system, IMAGE database, Whisper (development interface)

Apr 2024 - Dec 2024

9 months

Donauworth, Germany

Application Developer

HDIW UG (limited liability)

To simplify work processes, various workflows were created
Automatically scanned an RSS feed for suitable projects and stored them in an Airtable table for monitoring and evaluation
Created a table in Airtable to record projects
Built a workflow that reads the Airtable table and fills a Google Docs template for each record as a basis for a profile (including filter options for methods like UC4)
Set up a workflow to scan saved web pages in Pocket tagged #share, summarizing them in German with OpenAI
Output the summaries to a Google Sheet and then stored them in an Airtable table with link generation
Methods/tools: Airtable, Google Docs, Google Sheets, Make, OpenAI, Pocket

Jun 2023 - Dec 2024

1 year 7 months

Germany

Application Developer

ADAC IT Service GmbH

Provided qualified support of a host system for managing and sending invoices, reminders, and ADAC memberships
Made necessary adjustments and developments to the system
Analyzed and resolved production errors
Analyzed integration test failures to support business unit tests
Implemented critically required software changes
Methods/tools: CRM, DELTA-PL/1, TSO, z/OS

Jun 2023 - Dec 2024

1 year 7 months

Germany

Application Developer

ADAC SE

Supported the shipping service for handling mailings through Deutsche Post
Developed programs in the legacy system until the current shipping system was replaced
Changed procedures 1078/1088 for mailings
Methods/tools: CRM, DELTA-PL/1, TSO, z/OS

May 2021 - Oct 2023

2 years 6 months

Salzburg, Austria

Application Developer

City and State of Salzburg

Supported the custom application IPIS for personnel management and payroll of the state of Salzburg
Developed applications with ADABAS/Natural in the IPIS project
Created programs for the migration of IPIS to SAP
Handled tickets until the custom application was replaced by SAP
Methods/tools: ADABAS/Natural, Citrix, Jira, Eclipse, Software AG Designer

Feb 2021 - Dec 2021

11 months

Rain, Germany

Application Developer

Dehner Holding GmbH & Co. KG

Supported the inventory management area with development services
Application development in COBOL on the inventory management system project
Development of general COBOL applications
Testing the created software and logging the results
Performing acceptance testing of the created software
Complete software documentation according to provided standards (inline/external)
Handing over program source code, documentation and test logs
Deliverables: requirements analyses, detailed designs, source code, object code, test logs
Methods/tools: Citrix, COBOL, Eclipse, IT Workbench, Jira, Subversion, PuTTY, Oracle, XBM

Oct 2017 - Dec 2023

6 years 3 months

Würzburg, Germany

Application Developer

Deutsche Rentenversicherung Würzburg

Redesigned the validation service applications for the database conversion to DB2 (from VSAM)
Created requirements analyses and detailed designs
Developed COBOL applications and COBOL applications with DB2 access (CRUD) in a z/OS environment
Developed complex SQL queries for DB2 version 9/10 in a z/OS environment
Optimized SQL queries and performed performance analysis
Tested the software, performed acceptance tests and fixed bugs
Integrated applications into the CUP-D infrastructure
Completed documentation and delivered source code and test logs
Migrated the DB2 application to Oracle and Linux after the DB2 conversion
Replaced Oracle with PostgreSQL
Methods/tools: 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, PostgreSQL

Aug 2017 - Dec 2017

5 months

Stuttgart, Germany

Application Developer

DZBW

Supported the Meisterbafoeg project
Analyzed production errors
Created handover documents from existing materials to ease the transition for successors
Methods/tools: COBOL, CICS, VSAM, JCL

Jul 2017 - Dec 2019

2 years 6 months

Munich, Germany

Application Developer

Bayerische Landesbank

Supported the BILDAMAN project (balance data management system): development, testing, design with COBOL and databases
Supported the Business Partner project: development, testing, design with PL/1 and databases
Implemented various requirements and change requests based on technical specifications
Created IT concepts, test logs and complete documentation
Applied the four-eyes principle in the application at the request of internal audit
Methods/tools: COBOL, PL/1, CICS, DB2, SAS, JCL

Jan 2017 - Dec 2017

1 year

Frankfurt, Germany

Application Developer

DEKA Bank

Supported DBD Support FISP: development, testing, design with COBOL and databases
Implemented various requirements in requirements analysis and detailed design
Created source code, object code, test logs and documentation
Methods/tools: COBOL, Adabas, Natural, JCL, Xpeditor, Endevor

Mar 2016 - Dec 2016

10 months

Graz, Austria

Application Developer

Merkur Versicherung

Redesigned ATÜ (interface representative/application)
Developed the ATÜ application on a new foundation as part of a complete redesign
Created requirement analyses, detailed concepts, and source code
Performed tests and created complete documentation
Methods/Tools: ADABAS, NATURAL, NATURAL ONE, JASON, AJAX, JIRA

Jul 2015 - Dec 2016

1 year 6 months

Würzburg, Germany

Application Developer

Deutsche Rentenversicherung Würzburg

Redesigned inspection service applications aiming to migrate the database from VSAM to DB2
Created requirement analyses and detailed concepts
Developed applications in a z/OS environment
Tested the software, conducted acceptance tests, and fixed bugs
Integrated applications into the CUP-D infrastructure
Provided full documentation and handed over source code and test protocols
Methods/Tools: Visual-COBOL, DB2, VSAM

Feb 2015 - Oct 2016

1 year 9 months

Munich, Germany

Application Developer

IT&M (Stadt München Bereich Kfz)

Led the project in the KfzCS dialog area
Extended the short-term license plate topic to meet legal requirements
Supported ticket processing and the I-KFZ area
Methods/Tools: ADABAS, NATURAL, Natural Studio, Natural One, LINUX, Shellscript, SAG dialog framework

Jan 2015 - Mar 2015

3 months

Munich, Germany

Application Developer

IT&M (Stadt München Bereich Einwohnerwesen)

Supported the PAMELA area (residents' registration, naturalization)
Took on tasks to prepare the migration to OK-EWO
Made changes in the areas of residents' registration, naturalization, driving licenses, elections, and authorization management
Methods/Tools: ADABAS, NATURAL, Natural Studio, BS2000, LINUX, Shellscript

Mar 2014 - Dec 2014

10 months

Germany

Application Developer

Stiftung Kirchliches Rechenzentrum Südwestdeutschland

Supported the church registration system (Project DaviP)
Provided information and certificates
Created reports and statistics
Managed archives, history, and user administration
Prepared XKirche to define a standard for data exchange in registration based on XML
Methods/Tools: ADABAS, NATURAL, Natural Studio, z/VSE under VM/CMS

Jun 2013 - Dec 2013

7 months

Vienna, Austria

Application Developer

Raiffeisen Solution

Conducted a migration project as part of a bank merger
Transformed newly created interfaces into the old interface format to avoid customer adjustments
Methods/Tools: ADABAS, NATURAL, Natural Studio, Natural One, LINUX, Shellscript, SAG dialog frames

Mar 2009 - Jan 2014

4 years 11 months

Stuttgart, Germany

Application Developer

DZBW

Took over tasks for the state-wide resident information system DB2 (LEWIS)
Supported the migration from LEWIS to KMEWO, especially migrating XMELD messages
Maintained resident data, provided information, and handled applications for identity documents
Prepared elections, created income tax cards, and managed notification services
Implemented electronic communication with citizens and authorities
Created reports, statistics, and archived XMELD messages in Excel
Implemented the OSCI-XMeld standard for secure data exchange between registration offices
Methods/Tools: Cobol, Delta Cobol, DB2, CICS, CMS, Oracle Developer, Ossy dialog development, SAS, TSO, XML, XPEDITER

Oct 2008 - Dec 2009

1 year 3 months

Munich, Germany

Application Developer

Hypovereinsbank (Unicredit)

Worked on the Eurosig 9000 migration project: syndicated loan in a bank merger
Wrote unloaded DB2 tables into a structure using standardized programming
Created files for loading into new DB2 tables
Developed modules for data validation
Methods/Tools: Cobol, DB2, ENDEVOR, standardized programming

Mar 2008 - Oct 2008

8 months

Munich, Germany

Application Developer

Fiducia

Conducted a migration project in the securities area to replace an IMS database with DB2
Replaced database accesses in all modules with program calls
Developed a central module to check the bank's migration status and control database accesses
Performed extensive testing of the program changes
Methods/Tools: CICS, Cobol, DB2, Endevor, IMS, IMS-DC, SWT02, z/OS

Jan 2008 - Oct 2008

10 months

Frankfurt, Germany

Application Developer

BHF Bank

Supported the withholding tax project
Replaced an existing securities application with a new one, converting from IMS to DB2
Replaced database accesses with central program calls that check migration status
Performed extensive testing as part of the program changes
Methods/Tools: Cobol2, DB2, IMS-DB, IMS-DC, IMS-GSAM, JCL, UC4, Xpediter

May 2007 - Nov 2007

7 months

Düsseldorf, Germany

Application Developer

HSBC Trinkaus & Burkhardt (ITS Service GmbH)

Carried out a migration project to generate order sets from delivered external data
Created modules to process and prepare external data for order set generation
Tools/Methods: CICS, Cobol2, DB2, IMS-DB, IMS-DC, IMS-GSAM, JCL, UC4, Xpediter, z/OS

Jan 2007 - Nov 2007

11 months

Munich, Germany

Application Developer

TxB

Project work in the banking environment focused on order routing, derivative transactions, and customer forms
Tools/Methods: Adabas, Assembler, CICS, Cobol, Cobol2, MQSeries, Natural, PL/1, Predict-Case

Nov 2006 - Apr 2007

6 months

Düsseldorf, Germany

Application Developer

HSBC Trinkaus & Burkhardt (ITS Service GmbH)

Supported a migration project to transfer a securities application to the GEOS system
Analyzed the existing application and identified necessary adjustments in the GEOS system
Tools/Methods: CICS, Cobol2, DB2, ROCHADE, TSO, UC4, WebSphere, z/OS

Jul 2005 - Oct 2006

1 year 4 months

Munich, Germany

Application Developer

TxB

Project work in the banking environment focusing on order routing and corporate actions
Tools/Methods: Adabas, ADASQL, Assembler, Cobol, Endevor, MQSeries, Natural, PL/1, Predict-Case, z/OS

Feb 2005 - May 2005

4 months

Stuttgart, Germany

Application Developer

Kassenärztliche Vereinigung Baden-Württemberg

Defined new OIII services for the EBM 2005
Made extensive changes to online data entry
Tools/Methods: Adabas, Natural, SCO-Unix, Shell scripts, Sun Solaris, Windows 2000

Jul 2004 - Jun 2005

1 year

Munich, Germany

Application Developer

TxB

Project work in the banking environment in the areas of order routing and order entry
New development of the online savings plan function
Methods/Tools: Adabas, ARTEMIS, Assembler, CICS, Cobol, ENDEVOR, IBM390, ISPF, MQSeries, Natural, PL/1, Predict-Case, TCP/IP, TSO, VTAM

Jul 2002 - Aug 2004

2 years 2 months

Munich, Germany

Application Developer

TxB

Support for replacing an existing securities application with a new one
Tasks in the areas of order routing and order entry
New development of the online savings plan function
Methods/Tools: Adabas, ARTEMIS, Assembler, CICS, Cobol, IBM390, ISPF, MQSeries, Natural, PL/1, Predict-Case, TCP/IP, TSO, VTAM, ENDEVOR

Jan 2002 - Jan 2003

1 year 1 month

Stuttgart, Germany

Application Developer

Association of Statutory Health Insurance Physicians North Württemberg

Project support in the DAS project (Diskette Billing System)
Methods/Tools: Adabas, Natural, SCO-Unix, Shell scripts, Sun Solaris, Windows 2000

Oct 1999 - Jun 2002

2 years 9 months

Munich, Germany

Application Developer

Bavarian State Bank

Support for replacing an existing securities application with a new one
New developments in discount brokerage for securities trading over the Internet
Specialization in securities disposition and securities orders
Methods/Tools: Adabas, ADASQL, CICS, Cobol, DB2, MVS, Natural, Predict-Case, TSO, Windows 2000

Mar 1999 - Mar 2000

1 year 1 month

Stuttgart, Germany

Application Developer

Association of Statutory Health Insurance Physicians North Württemberg

Implementation of the Year 2000 conversion
Development of various new features due to legal changes in the federal doctors' register
Methods/Tools: Adabas, Natural, MVS, SCO-Unix, Siemens, Sinix, Sun Solaris, Windows NT

Sep 1998 - Sep 2000

2 years 1 month

Minden, Germany

Application Developer

Fricke Abfülltechnik GmbH & Co.

Worked on creating a Batch Monitor System (BMS) to control filling lines
Created various dialog programs
Methods/Tools: C++, SQL, Sybase, Windows 95, Windows NT

Mar 1996 - Mar 1998

2 years 1 month

Planegg, Germany

Application Developer

SANACORP AG

New development for sales of products to doctors and pharmacists
Created modules for entering and changing items
Prepared disks and lists for state pharmacists' associations
Developed on PC using ADABAS as development database and Paradox
Deployed the application in production against ORACLE
Methods/Tools: Adabas, OLE, Oracle, Paradox, NATURAL LightStorm

Sep 1995 - Jun 1999

3 years 10 months

Munich, Germany

Application Developer

Kassenärztliche Vereinigung Bayern

Implemented various developments related to legal changes in the federal doctors registry
Methods/Tools: Adabas, Cobol, MVS, Natural, Windows NT

Dec 1994 - Oct 1996

1 year 11 months

Kissing, Germany

Application Developer

WEKA Verlag

Made adjustments for address import
Designed and implemented address import/mailings and duplicate detection
Methods/Tools: Unix, VSE, NATURAL for WINDOWS, OSF/1

Nov 1993 - Nov 1994

1 year 1 month

Schongau, Germany

Application Developer

Papier Haindl

Supported project for migrating from Tandem to HP-UNIX
Extended an existing UNIX PPS system to integrate a high-bay warehouse and packing line
Used the INFORMIX 4GL development environment with support from Fourgen tool
Methods/Tools: HP, HP-UX, Informix, Informix-4GL, Tandem, Unix, Fourgen

May 1993 - Dec 1993

8 months

Kissing, Germany

Application Developer

WEKA Verlag

Project support for the postal code expansion
Changes to the affected modules as part of the postal code conversion, especially postage optimization and UPS optimization
Importing external addresses with address verification and adjustments for InfoPost
Methods/Tools: Adabas, Natural

Jul 1992 - Apr 1993

10 months

Augsburg, Germany

Application Developer

Papier Haindl

Project support for a PPS system
Development of a UNIX PPS system based on the existing IBM/Tandem application
Use of the INFORMIX 4GL development environment with the Fourgen tool
Methods/Tools: C++, HP, HP-UX, Informix, Informix-4GL, Tandem, DPPX/SP (IBM operating system), FOURGEN

Jan 1992 - Jul 1992

7 months

Düsseldorf, Germany

Application Developer

Landeszentralbank Nordrheinwestfalen

Developing tape software
Developing CFE applications
Development of tape software on the PET-MAESTRO system for reading files for import on an IBM system
Methods/Tools: Maestro, Maestro II, CFE

Summary

Mr. Haunstetter's consulting focus is in software development.

He has worked in the mainframe area since 1992.

Skills

Programming Languages: 4gl, Abap, Adasql, Assembly, Basic, Borland, Borland Delphi, C, C++, Cobol, Cobol-delta, Cobol2, Csp, Db2/6000, Delphi, E-sql, Fortran, Html, Ims, Ims-db, Ims-gsam, Informix, Informix-4gl, Java, Jcl, Ms Access, Ms Sql Server, Ms Visual Basic, Mysql, Natural, Oracle, Paradox, Pascal, Php, Pl/1, Pl/1-delta, Pl/sql, Powerbuilder, Python, Rexx, Rochade, Sybase, Sas, Tandem Nonstop Sql, Uml, Visual Cobol, Vsam, Shell Scripts, Sql, Xml
Components/technologies/products: Mqseries, Ibm Cics, Ims Dc
Hardware: Hp, Hp3000, Ibm 390, Ibm 370, Ibm, Pc, Sun, Siemens
Development Tools: Adobe Indesign, Adobe Photoshop, Airtable, Apache, Artemis, Ajax, Bitbucket, Ca-endevor, Coldfusion, Confluence, Crm, Csp/ad, Csp/ae, Data Warehouse, Delta, Dhtml, Dialog Frames Sag, Eclipse, Edt, Git, Google Docs, Google Sheets, Ibm Rational Developer For Z Systems, Ispf, Jam, Json, Jbuilder, Jdk, Jenkins, Jira, Kanban, Ksh, Macromedia Dreamweaver, Macromedia Flash, Maestro, Maestro Ii, Make, Mf-workbench, Mqseries, Ms Frontpage, Ms Internet Explorer, Ms Office 2003, Ms Office, Ms Project, Ms Visio, Natural Studio, Naturalone, Odbc, Ole, Openai, Oracle Jdeveloper, Oracle Tools, Pagemaker, Pc Anywhere, Platinum, Pocket, Predict-case, Qmf, Racf, Rochade, Spufi, Sql Forms, Sql Report, Sql Windows, Staroffice, Swt, Telnet, Tomcat, Tso, Uc4, Ucd, Websphere, Whisper, Xbm, Xpediter
Test Tools: Hp Quality Center, Silenium
Databases: Oracle, Db2, Access, Mysql, Sybase, Adabas, Informix, Image, Postgresql
Operating Systems: Dppx, Unix, Linux, Hpux, Mpe/xl, Aix, Solaris, Windows (Current Versions), Mac Os, Os/2, Dos
Industry Knowledge: Plant Engineering, Stock Exchange, Banking, Building Society, Government Agencies, Consulting Firms, Services, It Services, Financial Services, Trading Group, Manufacturing, Health Insurance, Software House, Management Consulting, Publishing, Insurance