Martin S. - PostGres Training / Update

Go to Website

Hanover, Germany

Experience

Jun 2025 - Jul 2025

2 months

Frankfurt, Germany

Lorem ipsum dolor sit amet

KFW-Frankfurt

Code review, quality assurance in SAS, DB2 and VBA.
Ensuring standards for documentation and source code rules for BaFin controls.
Keywords: MS Office, NIS, BaFin, GitLab, IdGard.

May 2025 - May 2025

1 month

PostGres Training / Update

EDB PostgreSQL administration & performance tuning.
Setting up test scenarios.

Feb 2025 - Apr 2025

3 months

Migration Project

End Customers

From Delphi MS SQL Windows application to a C#-Wisej-.NET MS SQL web application.

Oct 2024 - Dec 2024

3 months

Training

ISTBQ Foundation certificate – course and exam.
Python update.

Apr 2024 - Sep 2024

6 months

Frankfurt, Germany

Lorem ipsum dolor sit amet

Sparkassen Financial IT, Regulatory Reporting

Working in the area of CCR III, participating in 2 production rollout packages/deadlines, agile development in direct contact with the business department.
Programming to specification, code review of team source code, ticket handling for customers (branches) under the guidance of senior colleagues.

Netting packages and risk allocation:

Consolidation of individual papers into netting packages under an existing netting framework agreement. Go-live: July 2024.
Calculation of RWA (Risk Weighted Assets) for credit risk, using the internal approach based on probability of default (PD), loss given default (LGD) and exposure at default (EAD). Go-live: Sept. 2024.
Tools: Unix shell, SAS 9.4, MS SQL, DB2, testing with HP ALM / HP QC, IBM code pipeline, WinSCP, Confluence and MS Office.

Jan 2024 - Mar 2024

3 months

Lorem ipsum dolor sit amet

End customer projects

Set up Docker files and Hyper-V for the development environments.
Gained first hands-on experience with Kubernetes.
Performed maintenance work on Delphi-UniGui.
Renovated the office.

Feb 2023 - Dec 2023

11 months

Frankfurt, Germany

DevOps Engineer and Tester

Deutsche Bank

Worked as a DevOps Engineer and tester in infrastructure mainframe job monitoring, ad-hoc error analysis, code reviews, and documenting Oracle, VBA, and SAS source code.
Version control with Git.
SAS 9.4 z/OS / SAS PC / PL/I / ISPF / B92 / SFDF / TSO / VBA.
Confluence / Office 365 (MS Access / MS Excel / MS Word).
Time-shifted work model with colleagues in Bangalore.
Training: Risk Awareness, Anti-Financial Crime, Compliance, Market Participation & Banking Rules, Sanctions Essentials, Market Abuse & Antitrust, Data Protection & Privacy.

Feb 2022 - Dec 2022

11 months

Munich, Germany

Data Analyst / Data Engineer

Bayerische Versicherungskammer

Worked as a Data Analyst / Data Engineer.
Migrated from SAS mainframe to SAS BI for the math and controlling departments.
Converted Host-SAS, REX, and PL/I programs into SAS BI stored processes.
Helped analyze existing reports on insurance contracts and cost summaries.
Collaborated with colleagues to create business and technical documentation in source code and Word for very long-lived reports (handover relics).
Used an agile approach with Scrum sprints and iterative processes.
Created KPIs for cost and volume of contract types and insurance categories for private and public health insurance.
Tools: DB2 / SAS / ISPF / PL/I / PowerShell / MS Office / Confluence.

Feb 2021 - Dec 2021

11 months

Frankfurt, Germany

Data Analyst

Commerzbank

Worked as a Data Analyst.
Performed data analysis and reporting with SAS 9.4 and SAS Viya in MS Office and Power BI.
Created documentation (end-user computing / manuals) and simulations for controlling.
Supported setting allocation keys.
Generated KPI, status, and ad-hoc reports.

May 2020 - Dec 2020

8 months

Hanover, Germany

Lorem ipsum dolor sit amet

CalRes DV

Redeveloped a Delphi accounting application in C# and partly in JavaScript using TMS WebCore components, data exchange with Tesseract OCR.
Technologies: C# WinForms / Lazarus / Delphi / TMS WebCore / Oracle 12c / Oracle SQL Developer / Tesseract.

Apr 2019 - Mar 2020

1 year

Eschborn, Germany

Lorem ipsum dolor sit amet

Deutsche-Bank

Management reporting in the Identity and Access Management area.
Documenting data flows and time windows of data paths.
Creating Oracle VIEWS / MVIEWS and PL/SQL routines to retrieve data from the central data warehouse.
VBA in a PowerPoint report.
Team language is English.
Time-shifted work model with colleagues in Bangalore and London.
Technologies used: SQL, PL/SQL, ORACLE 12c / Oracle SQL Developer.

Jul 2017 - Dec 2018

1 year 6 months

Hanover, Germany

Lorem ipsum dolor sit amet

Kassenäztliche Vereinigung

Implementing a layer of VIEWS and SYNONYMS as an abstraction layer for exchanging the data model to downstream applications.
Using VIEWS in Oracle packages and PostGres packages.
Extending the business view layer (PL/SQL) with data supplied from the department data mart.
Project documentation and tracking in JIRA.

The Kassenärztliche Vereinigung in Lower Saxony supports about 40,000 doctors and ensures medical care in all regions.

Agile development using Scrum.
Technologies used: SQL, PL/SQL, ORACLE 11g / Oracle 12c / Oracle SQL Developer.

Feb 2017 - Jun 2017

5 months

Planned break / training

Training in SAS-DI / SAS-VA Reporting / GIT / C# / R / Markdown.

Jan 2016 - Jan 2017

1 year 1 month

Frankfurt, Germany

Lorem ipsum dolor sit amet

Commerzbank

Documentation and regulatory-compliant deployment of several SAS BI program packages.
Creating user documentation for business testing with HPQC, and managing the web frontend for business users.
Documentation for business and system developers: developer guide, authorization concept, report creation.
Technical HPQC tests and logged deployment of business-tested programs into production.
Creation of EUC for the reporting system context.
Documentation of SAS macros.
Technologies used: HPQC, SharePoint, MS Office, EUC database, SAS BI.

Jul 2015 - Dec 2015

6 months

Frankfurt, Germany

Lorem ipsum dolor sit amet

Commerzbank

Program migration from SAS z/OS to SAS BI (Unix/Windows).
Integration into new DWH / adjustments and alternative development.
Initial task was testing and further development of a technical template that encapsulates the new system environment.
Adapting about 280 legacy programs and embedding them into the new system template within the team. Integrating new data from the cross-domain data warehouse / data lake.
Integrating the programs into the stored process web environment. Targeted delivery of results and runtime reports via email.
Converting a VBA/SAS combined application to the new system and ensuring result consistency.
Technologies used: SAS z/OS, SAS BI, Stored Process Server / Workspace Server, VBA.

Apr 2014 - Jun 2015

1 year 3 months

Wolfsburg, Germany

Database development with zOS-DB2 and Windows MS-SQL Server

Volkswagen-AG

Database development with zOS-DB2 and Windows MS-SQL Server to deliver data to VMware ITBM and Bissantz DeltaMaster.
The task was to create a zOS-DB2 application that normalizes partial billing data from different formats for the follow-up system and delivers it on time.
Converted the application from zOS to MS-SQL Server, considering the import structure for DeltaMaster reporting.
Task also included application documentation with data flow and procedure analysis of the new system.
Supported the resolution of customer inquiries about the created and other in-house systems.
Created import routines in VMware ITBM and Excel sheets with SQL statements for DB re-import.
Generated reports on application runtimes using Pacific Systems SMF Writer.
Technologies used: zOS-DB2, JCL, OFTP, BETA92/93, QMF, IBM Data Studio, IBM QMF, PL/I, PostgreSQL, MS-SQL Server, MS-SSIS, MS-VBA, DeltaMaster, Perl script, Bash, VMware ITBM, Cobol, Pacific Systems SMF Writer, Excel (Pivot/Macro/VLOOKUP, SQL via ADO).

May 2012 - Mar 2014

1 year 11 months

Wolfsburg, Germany

Takeover of a legacy SAS application, SAS documentation

Volkswagen-AG

Created a user manual to enable new employees to operate the application.
Researched cost drivers, revenue losses, and root causes of incorrect data.
Technical application documentation including analysis of data flows and procedures, and created a guide for handling job failures and faulty data deliveries.
Took over the SAS accounting system as the application owner, ensuring monthly statements within set timeframes with data handover to follow-up processes.
Updated the SAS MXG system to the latest version, including VW-specific customizations.
Technologies used: SAS Windows and remote on z/OS, IBM Host on Demand, ISPF, JCL, BETA92/93, PL/I, MS Office and MS Visio for documentation, SAS MXG, OFTP/RVS, DB2 host tools.

Jan 2012 - Mar 2012

3 months

Mönchengladbach, Germany

SAS dataset creation for statistical analysis

Santander Consumer Bank

Data management for the statistics department, ad hoc analyses for products and segments.
Frequency and occurrence analyses.
Data integration with verification using Proc Compare with ODS / ODS Trace.
Data is sourced from a data warehouse and must be reconciled.
Re-documented existing code in source files and in MS Office.
Technologies used: SAS Windows and remote on Unix, SSH access to logs and programs. Dynamically included SAS macros, directory-independent (relocatable). Documentation with MS Office, MS Visio, MS PowerPoint. SQL.

Sep 2011 - Dec 2011

4 months

Mönchengladbach, Germany

SAS data management, key figure calculation

Santander Consumer Bank

Calculated key figures for impairment according to HGB and compared them to the corresponding IAS figures.
Developed macros for the monthly production run for controlling.
Extensive pre-tests due to multiple data sources.
Excel VBA front end for SAS routines, parallel remote processing.
Technologies used: SAS Windows and remote on Unix, SSH access to logs and programs, integration of sasautos routines and check macros for log analysis. Documentation with MS Office and MS Visio, MS PowerPoint.

Jun 2011 - Aug 2011

3 months

Hanover, Germany

Maintenance and product development

CalRes DV

CalRes SAS CodeLib. Application to manage SAS routines in a multi-user environment. Added statistical routines with MySQL and VFront connection for internet data exchange. Technologies used: SAS.
CalRes Central. Application for data management in ergotherapy and physiotherapy practices - first prototype. Technologies used: C++, Delphi, Oracle.

Feb 2011 - Mar 2011

2 months

Hanover, Germany

Product Development

CalRes DV

CalRes Central. Program for data management in physiotherapy and occupational therapy practices - first prototype.
Used technologies: DELPHI, ORACLE.

Apr 2010 - Dec 2010

9 months

Heddesheim, Germany

Analyses for clinical trials

Dasta-GmbH

Analyses for clinical trials (Kaplan-Meier, Risk-Tables, Clinical DataSets).
SAS 9.2, SAS-Graph+Annotate.
Pharmaceutical reporting.
Used technologies: SAS 9.2, SAS-GRAPH/ANNOTATE, WINDOWS, UNIX-AIX.

Feb 2010 - Mar 2010

2 months

Migration of address management to UTF-8

Druckerei Görich & Weiershäuser

Migration of an address management system to UTF-8.
Used technologies: DELPHI, UTF-8.

Aug 2009 - Dec 2009

5 months

Plausibility checks for data import

Commerzbank AG

Plausibility checks (Basel II) during data import with report output using Excel-XP-Tagset (Excel controls host).
Systematika / Commerzbank.
SAS on z/OS / Excel as input frontend.
Used technologies: SAS, z/OS, EXCEL.

May 2009 - Jun 2009

2 months

Hanover, Germany

CalRes – Simulate - Product Development

CalRes DV

A program for generating DataSteps for SAS from an Excel workbook. It allows someone without macro knowledge to generate SAS commands.
Delphi ADO on Access.
Delphi OLE on SAS.
Used technologies: SAS, DELPHI ADO, ACCESS, DELPHI OLE.

Jan 2009 - Apr 2009

4 months

Braunschweig, Germany

Lorem ipsum dolor sit amet

Thünen-Institut

Frontend based on Delphi for the SAS evaluation system for project grants.
Market analysis at the Thünen Institute, Braunschweig.
Delphi / XML files / OLE components: DevExpress / ZEOS / FastReport.
Technologies used: SAS, DELPHI, XML, OLE DEVEXPRESS.

Jun 2008 - Dec 2008

7 months

Braunschweig, Germany

Lorem ipsum dolor sit amet

Thünen-Institut

Automated data import system and code management for SAS. Technologies used: SAS, ORACLE 10G, DELPHI, OLE.
Excel macro for formatting SAS reports. Technologies used: EXCEL-VBA.
Mondrian project: OLAP with Mondrian and Firebird. Market analysis. Technologies used: OLAP, MONDRIAN, FIREBIRD.

Feb 2007 - May 2008

1 year 4 months

Braunschweig, Germany

Lorem ipsum dolor sit amet

Thünen Institut

SAS statistics and reporting: economic metrics / econometric calculations, physical calculations / unit conversion, project scoring process. Technologies used: SAS-BASE, SAS MACRO, SAS-CONNECT, XML SAS-SQL.
Management system for project sheets: Excel-based management system for project sheets with import and export routines to SAS-XML/CSV, Excel-XLS with template management; client/server. Technologies used: DELPHI, DEVEXPRESS, ZEOS, FIREBIRD, POSTGRES, XML.

Dec 2006 - Jan 2007

2 months

Lorem ipsum dolor sit amet

Diverse

No programming.
Writing articles in Word / Word mail merges.

Mar 2006 - Nov 2006

9 months

Braunschweig, Germany

Lorem ipsum dolor sit amet

Thünen Institut

SAS statistics: regional models with factor, cluster, and variance analyses. Technologies used: SAS-BASE, FORECAST.
New edition of a survey form: import macro system with XML output. Excel VBA, CSV import according to guidelines of the participating state banks, ministries, and approval authorities. Technologies used: Excel VBA, XML.

Jan 2006 - Feb 2006

2 months

Braunschweig, Germany

SAS-TemplateSystem Reporting

Thünen Institute

PROC-Tabulate / PROCReport.
Getting familiar with EU analysis guidelines.
Technologies used: SAS, SAS-BASE.

Jun 2005 - Sep 2005

4 months

Braunschweig, Germany

Web development Mambo (now Joomla)

Thünen Institute

Creating manuals.
Technologies used: Joomla, JS, CSS, MySQL, MS Office.

Summary

Originally, I worked in public administration on data management for benchmarking and investment evaluation and then moved to the private sector where I have now been working for almost 20 years. My previous work areas include KPI reporting, data management, technical and regulatory documentation, testing (HPQC / Python) and documentation with Word and Confluence. I also support Delphi projects for some local clients. I enjoy working in international teams and am familiar with parallel and coordinated processes as well as staggered work processes. I have worked in several Scrum projects in an agile way. Tasks that don't directly fit into my previous work profile are also welcome.