Keywords
Skills
IT Experience since 1979
Business areas:
Banks, insurances, public services
Functions:
Application Developer, Database Designer, Programmer
Operating systems
MVS (z/OS), VM/CMS, VSE, Unix (AIX und HP-UX), Windows
Programming languages:
COBOL (IBM, MicroFocus, AcuCobol), REXX, 370/Assembler,
PL/1, Fortran, SQL, JCL, Natural, Unix-Shell, HTML, XML
Databases:
DB2 (SQL & DDL), IMS-DB (application and system),
DL/1 (application and system), VSAM, Oracle
Online Environments:
TSO/ISPF, CICS (application and system), IMS/DC, MQ-Series
Editors:
ISPF/PDF, XEDIT, VI
Utilities:
Panvalet, Librarian, ChangeMan
SORT, IDCAMS, SPUFI, QMF, SDF II,
Abend-Aid, File-Aid, Xpediter, MF-Animator
CA MAT (Mainframe Application Tuner), Strobe
HP-QC, HP-SC
PC standard software:
MS-Word, MS-Excel, MS-Access, MS-Visio, Rumba
Miscellaneous:
BranschData Converter (VSE/MVS migration tool)
IBM MS-Migration System (VSE/MVS migration tool)
IBM Advanced Function Printing
Acu4GL
Business areas:
Banks, insurances, public services
Functions:
Application Developer, Database Designer, Programmer
Operating systems
MVS (z/OS), VM/CMS, VSE, Unix (AIX und HP-UX), Windows
Programming languages:
COBOL (IBM, MicroFocus, AcuCobol), REXX, 370/Assembler,
PL/1, Fortran, SQL, JCL, Natural, Unix-Shell, HTML, XML
Databases:
DB2 (SQL & DDL), IMS-DB (application and system),
DL/1 (application and system), VSAM, Oracle
Online Environments:
TSO/ISPF, CICS (application and system), IMS/DC, MQ-Series
Editors:
ISPF/PDF, XEDIT, VI
Utilities:
Panvalet, Librarian, ChangeMan
SORT, IDCAMS, SPUFI, QMF, SDF II,
Abend-Aid, File-Aid, Xpediter, MF-Animator
CA MAT (Mainframe Application Tuner), Strobe
HP-QC, HP-SC
PC standard software:
MS-Word, MS-Excel, MS-Access, MS-Visio, Rumba
Miscellaneous:
BranschData Converter (VSE/MVS migration tool)
IBM MS-Migration System (VSE/MVS migration tool)
IBM Advanced Function Printing
Acu4GL
Project history
Since 10/11 (still current) Leading bank, Frankfurt
Development of a new application for the collection and preparation of data for the Bundesbank Regulatory Reporting modules SolvV und GroMiKV (Solvency Regulations and Large Exposure Reports). The data to be formatted and delivered as XML-Files in Ascii to the server-based reporting software ABACUS/DaVinci (Bearing Point), with the intent of replacing the mainframe-based reporting software SAMBAplus.
- Design and development of a new database-partition management application including an automatic rotational historizing concept
- Database design
- SQL-Optimization
- MVS (z/OS), COBOL, DB2, XML, XBRL
Since 01/10 (still current) Leading bank, Frankfurt
Mentoring younger, less experienced Commerzbank employees, in particular in the areas of programme structure, programme design and SQL.
Since 05/07 (still current) Leading bank, Frankfurt
Development and subsequent maintenance, enhancement and production-support of a new application for the collection and preparation of data for the Bundesbank Regulatory Reporting modules SolvV und GroMiKV (Solvency Regulations and Large Exposure Reports). The data to be formatted and delivered as sequential files to the standard reporting software SAMBAplus (Logica) within the framework of the project to implement BASEL II.
- Conception and implementation of new standards regarding programme structuring
- Design and development of the principal main programmes
- Database optimization (also in SAMBAplus itself)
- MVS (z/OS), COBOL, DB2, SAMBAplus
01/97 – 12/09 Deutsche Landwirtschafts-Gesellschaft e.V., Frankfurt
(German Agricultural Society) Ongoing support as needed.
- Technical support in the areas of Unix and Oracle database administration
- Maintenance and enhancement of various batch- and online-applications in AcuCobol (now Micro Focus Extend)
- Porting of a batch- und online-application from HP-UX to WindowsXP
- HP-UX, Oracle, AcuCobol, Acu4GL
03/08 – 06/08 Commerzbank AG, Frankfurt
Redesign und optimization of the processing of the feedback files from the Bundesbank.
- Replacement of a Unix-based Java application with a new COBOL application running on the mainframe
- Reading, processing and writing various XML data files direct in Ascii
- MVS (z/OS), COBOL, XML
08/05 – 04/07 Commerzbank AG, Frankfurt
Redesign und optimization of the central programme for the daily valuation of the bank’s own securities portfolio.
- MVS (z/OS), COBOL, DB2, IMS/DB
06/02 – 07/05 Commerzbank AG, Frankfurt & Hamburg
Maintenance and enhancement of the central credit limit system.
- 2nd Level Support, analysis and repair of errors in the production environment, database analysis, consistency checks and correction
- Development and implementation of a concept for the technical optimization of the credit- and overdraft-limit calculations (reworking of the algorithms, database design and SQL optimization
- Quality assurance (code review & acceptance tests)
- MVS(OS/390, z/OS), COBOL, DB2, IMS/DC
06/03 – 06/04 Landschaftsverband Rheinland (LVR), Köln
Local government organisation.
Completion of a feasibility study for a system migration from MVS (OS/390) to Windows 2000 and technical support of the subsequent migration project.
- Selection of the software components
- Conception of the technical solution process
- Migration from DB2 to Oracle
- MVS, COBOL, DB2, Oracle, PL/1, JCL, Windows
05/01 – 05/02 BHF-Bank AG, Frankfurt
Supervision and maintenance of an interface between the mainframe and a portfolio analysis system running on Unix, including the changeover to the use of ISIN.
- Analysis and correction of errors in the production environment
- Development of online DB maintenance programmes, SQL optimization
- Programme and interface extensions for the WKN/ISIN migration
- MVS(OS/390), COBOL, DB2, IMS/DB, IMS/DC
01/98 – 04/01 Commerzbank AG, Frankfurt
Maintenance, enhancement and optimization of the central credit limit system, including Year 2000 changes and the introduction of the euro.
- MVS, COBOL, DB2, IMS/DB, IMS/DC
06/97 – 12/97 Commerzbank AG, Frankfurt
Conversion and reorganization of the cost centre database.
- MVS, COBOL, DB2, IMS/DC
01/97 – 05/97 Commerzbank AG, Frankfurt
Design and implementation of a central credit limit system.
- MVS, COBOL, DB2
Development of a new application for the collection and preparation of data for the Bundesbank Regulatory Reporting modules SolvV und GroMiKV (Solvency Regulations and Large Exposure Reports). The data to be formatted and delivered as XML-Files in Ascii to the server-based reporting software ABACUS/DaVinci (Bearing Point), with the intent of replacing the mainframe-based reporting software SAMBAplus.
- Design and development of a new database-partition management application including an automatic rotational historizing concept
- Database design
- SQL-Optimization
- MVS (z/OS), COBOL, DB2, XML, XBRL
Since 01/10 (still current) Leading bank, Frankfurt
Mentoring younger, less experienced Commerzbank employees, in particular in the areas of programme structure, programme design and SQL.
Since 05/07 (still current) Leading bank, Frankfurt
Development and subsequent maintenance, enhancement and production-support of a new application for the collection and preparation of data for the Bundesbank Regulatory Reporting modules SolvV und GroMiKV (Solvency Regulations and Large Exposure Reports). The data to be formatted and delivered as sequential files to the standard reporting software SAMBAplus (Logica) within the framework of the project to implement BASEL II.
- Conception and implementation of new standards regarding programme structuring
- Design and development of the principal main programmes
- Database optimization (also in SAMBAplus itself)
- MVS (z/OS), COBOL, DB2, SAMBAplus
01/97 – 12/09 Deutsche Landwirtschafts-Gesellschaft e.V., Frankfurt
(German Agricultural Society) Ongoing support as needed.
- Technical support in the areas of Unix and Oracle database administration
- Maintenance and enhancement of various batch- and online-applications in AcuCobol (now Micro Focus Extend)
- Porting of a batch- und online-application from HP-UX to WindowsXP
- HP-UX, Oracle, AcuCobol, Acu4GL
03/08 – 06/08 Commerzbank AG, Frankfurt
Redesign und optimization of the processing of the feedback files from the Bundesbank.
- Replacement of a Unix-based Java application with a new COBOL application running on the mainframe
- Reading, processing and writing various XML data files direct in Ascii
- MVS (z/OS), COBOL, XML
08/05 – 04/07 Commerzbank AG, Frankfurt
Redesign und optimization of the central programme for the daily valuation of the bank’s own securities portfolio.
- MVS (z/OS), COBOL, DB2, IMS/DB
06/02 – 07/05 Commerzbank AG, Frankfurt & Hamburg
Maintenance and enhancement of the central credit limit system.
- 2nd Level Support, analysis and repair of errors in the production environment, database analysis, consistency checks and correction
- Development and implementation of a concept for the technical optimization of the credit- and overdraft-limit calculations (reworking of the algorithms, database design and SQL optimization
- Quality assurance (code review & acceptance tests)
- MVS(OS/390, z/OS), COBOL, DB2, IMS/DC
06/03 – 06/04 Landschaftsverband Rheinland (LVR), Köln
Local government organisation.
Completion of a feasibility study for a system migration from MVS (OS/390) to Windows 2000 and technical support of the subsequent migration project.
- Selection of the software components
- Conception of the technical solution process
- Migration from DB2 to Oracle
- MVS, COBOL, DB2, Oracle, PL/1, JCL, Windows
05/01 – 05/02 BHF-Bank AG, Frankfurt
Supervision and maintenance of an interface between the mainframe and a portfolio analysis system running on Unix, including the changeover to the use of ISIN.
- Analysis and correction of errors in the production environment
- Development of online DB maintenance programmes, SQL optimization
- Programme and interface extensions for the WKN/ISIN migration
- MVS(OS/390), COBOL, DB2, IMS/DB, IMS/DC
01/98 – 04/01 Commerzbank AG, Frankfurt
Maintenance, enhancement and optimization of the central credit limit system, including Year 2000 changes and the introduction of the euro.
- MVS, COBOL, DB2, IMS/DB, IMS/DC
06/97 – 12/97 Commerzbank AG, Frankfurt
Conversion and reorganization of the cost centre database.
- MVS, COBOL, DB2, IMS/DC
01/97 – 05/97 Commerzbank AG, Frankfurt
Design and implementation of a central credit limit system.
- MVS, COBOL, DB2
Local Availability
Only available in these countries:
Germany
Available from 01.08.2018 for a full time engagement. Small projects and programming tasks at any time