Martin Schaefer - Measurement data provisioning via LoRa

Recommended expert

Hanover, Germany

Experience

Sep 2025 - Sep 2025

1 month

Measurement data provisioning via LoRa

End customer project

Measurement data provisioning via LoRa Things Network to PC.
Technologies: Python, PostGres, C#, Eagle

Jun 2025 - Aug 2025

3 months

Frankfurt, Germany

Quality assurance, code review

KfW

Quality assurance and code review in SAS, DB2, and VBA, R.
Internal audit of compliance with documentation and source code standards according to BaFin rules.
Keywords: ISTBQ, MS Office, NIS, DORA, Idgart, Git.

May 2025 - May 2025

1 month

Training: PostgreSQL

Instructor-led training.
EDB PostgreSQL administration & performance tuning.
Setting up backup and failover scenarios.

Feb 2025 - Apr 2025

3 months

Software Developer

End customer - migration project

Migration from Delphi – MS-SQL Windows application to C#-Wisej.NET, Azure web application.

Oct 2024 - Dec 2024

3 months

Training

ISTBQ Foundation certificate – study and exam.
Python update.

Apr 2024 - Sep 2024

6 months

Frankfurt, Germany

Regulatory Reporting

Finanz-IT der Sparkassen

Working in the CCR-III area.
Involvement in 2 go-live packages / releases.
Agile development in direct contact with the business department.
Programming based on specifications.
Code reviews of team source code.
Responding to tickets for customers (branches) under guidance of business colleagues.
Netting packages and risk allocation: combining individual instruments 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 model based on probability of default (PD), loss given default (LGD) and exposure at default (EAD) (go-live: September 2024).
Tools: Unix shell, SAS 9.4, MS SQL, DB2, testing with OpenText ALM / OpenText QC, IBM code pipeline, WinSCP, Confluence and MS Office.

Jan 2024 - Mar 2024

3 months

Software Developer

Endkundenprojekte

Set up Docker files and Hyper-V for the development environments.
Initial familiarization with Kubernetes.
Maintenance work on the Delphi-UniGui.
Renovating the office.

Feb 2023 - Dec 2023

11 months

Frankfurt, Germany

DevOps Engineer and Tester

Deutsche Bank

Assigned to the infrastructure area.
Mainframe job monitoring / ad-hoc error analysis.
Code reviews.
Documenting Oracle, VBA, and SAS source code.
Version control with Git.
Working in a time-shifted model with colleagues in Bangalore.
Trainings: Risk Awareness, Anti-Financial Crime, Compliance, Market Participation & Banking Rules, Sanctions Essentials, Market Abuse & Antitrust, Data Protection & Privacy.
Technologies: SAS 9.4 on z/OS / SAS-PC / PL/I / ISPF / B92 / SFDF / TSO / VBA, Confluence / Office 365 (MS Access / MS Excel / MS Word).

Feb 2022 - Dec 2022

11 months

Munich, Germany

Data Analyst / Data Engineer

Bayerische Versicherungskammer

Migration from SAS mainframe to SAS BI for the Mathematics and Controlling departments.
Converting Host SAS, REX, and PL/I programs into SAS BI stored processes.
Contributing to the analysis of existing reports on insurance contracts and cost overviews.
Creating functional and technical documentation in source code and Word for long-term reports in collaboration with business colleagues.
Agile working with Scrum sprints and an iterative approach.
Creating key figures (KPIs) for costs and volumes of contract types and insurance categories for private and statutory health insurance.
Tools: DB2 / SAS / ISPF / PL/I / PowerShell / MS Office / Confluence.

Feb 2021 - Dec 2021

11 months

Frankfurt, Germany

Data Analyst

Commerzbank

Data analysis and reporting with SAS 9.4 and SAS Viya in MS Office as well as Power BI.
Documentation (EUC / manual).
Simulations for controlling.
Support in defining allocation keys.
KPI and status / ad-hoc reporting.

May 2020 - Dec 2020

8 months

Hanover, Germany

Software Developer

CalRes DV

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

Apr 2019 - Mar 2020

1 year

Eschborn, Germany

Management Reporting

Deutsche Bank

Area of identity and access management.
Documentation of data runs and time windows of data flows.
Creating Oracle VIEWS / MVIEWS as well as PL/SQL routines for data retrieval 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

Software Developer

Association of Statutory Health Insurance Physicians

Implementation of a layer of VIEWS and SYNONYMS as an abstraction layer to exchange the data model beneath the applications to be maintained.
Use of VIEWS in Oracle packages and PostgreSQL packages.
Extension of the business view layer (PL/SQL) with data supply from the department data mart.
Project documentation and tracking in JIRA.
Agile development using Scrum methodology.
The Association of Statutory Health Insurance Physicians in Lower Saxony supports around 40,000 doctors and ensures medical care.
Technologies used: SQL, PL/SQL, Oracle 11g / Oracle 12c / Oracle SQL Developer.

Feb 2017 - Jun 2017

5 months

Sabbatical / Further Training

Further training in SAS-DI / SAS VA reporting / GIT / C# / R / Markdown.

Jan 2016 - Jan 2017

1 year 1 month

Frankfurt, Germany

SAS-BI Developer / Documentation Specialist

Commerzbank

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

Jul 2015 - Dec 2015

6 months

Frankfurt, Germany

SAS-zOS to SAS-BI Migration Specialist

Commerzbank

Program migration from SAS-zOS to SAS-BI (Unix/Windows).
Integration into new DWH / adaptation and alternative development.
Testing and further development of a technical template that encapsulates the new system environment.
Adapting around 280 legacy programs and embedding them into the new system template within the team.
Integration of new data from the cross-departmental data warehouse / data lake.
Embedding the programs in the stored process web environment.
Targeted delivery of results and runtime reports via email.
Migration of a VBA / SAS combination application to the new system.
Technologies used: SAS-zOS, SAS-BI, Stored-Process-Server / Workspace-Server, VBA.

Apr 2014 - Jun 2015

1 year 3 months

Wolfsburg, Germany

Database Development

Volkswagen-AG

Database development with zOS-DB2 and Windows MS-SQL-Server for data delivery to VMware-ITBM and Bissantz DeltaMaster.
Development of a zOS-DB2 application that normalizes proportional billing data and delivers it on time.
Implementation of the application on MS-SQL-Server considering the import structure for DeltaMaster reporting.
Application documentation including data flow and procedure analysis of the new system.
Support in clarifying customer inquiries.
Creation of import routines in VMware-ITBM and Excel sheets with SQL statements for DB reimport.
Reports on application runtimes with Pacific Systems SMF Writer.
Technologies used: zOS-DB2, JCLs, OFTP, BETA92/93, QMF, IBM Data Studio, PL/I, PostgreSQL, MS-SQL-Server, MS-SSIS, MS-VBA, DeltaMaster, Perl script, Bash, VMware-ITBM, Cobol, Pacific Systems SMF Writer.

May 2012 - Mar 2014

1 year 11 months

Wolfsburg, Germany

Application Owner / SAS Developer

Volkswagen-AG

Took over a legacy SAS application and created SAS documentation.
Created a user manual.
Researched cost drivers, revenue shortfalls, and root causes of data errors.
Technical application documentation with analysis of data flow and procedures.
Took over the SAS accounting system as application owner: ensured monthly billing.
Updated the SAS MXG system to the latest version, including VW-specific adjustments.
Technologies used: SAS Windows and remote on z/OS, IBM Host on Demand, ISPF, JCL, BETA92/93, PL/I, MS Office, MS Visio, SAS-MXG, OFTP/RVS, DB2 host tools.

Jan 2012 - Mar 2012

3 months

Mönchengladbach, Germany

SAS Data Management / Analyst

Santander Consumer Bank

Created data sets for statistical analysis.
Data management for the statistics department and ad-hoc reports for products and segments.
Frequency and count analyses.
Data integration with verification using Proc Compare with ODS / ODS Trace.
Documented existing code in source and in MS Office.
Technologies used: SAS Windows and remote on Unix, SSH, SAS macros, 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 metrics for value adjustments under HGB and compared them to corresponding IAS metrics.
Developed macros for the monthly production run for controlling.
Conducted extensive pre-tests on multiple data sources.
Created an Excel-VBA front end for SAS routines and parallel remote processing.
Technologies used: SAS Windows and remote on Unix, SSH, sasautos routines, check macros.

Jun 2011 - Aug 2011

3 months

Hanover, Germany

Software Developer / Product Development

CalRes DV

Maintenance and product development of the CalRes SAS-CodeLib (program for managing SAS routines in multi-user mode).
Integration of statistical routines with MySQL and VFront connection for data exchange over the internet.
Development of CalRes Central (program for data management in occupational and physical therapy practices - 1st prototype).
Technologies: SAS, C++, Delphi, Oracle.

Feb 2011 - Mar 2011

2 months

Hanover, Germany

Product Development

CalRes DV

CalRes Central: program for data management in occupational and physical therapy practices - 1st prototype.
Technologies: Delphi, Oracle.

Apr 2010 - Dec 2010

9 months

Heddesheim, Germany

SAS Developer

DASTA-GmbH

Analysis for clinical trials (Kaplan-Meier, risk tables, clinical datasets).
Pharmaceutical reporting.
Technologies: SAS 9.2, SAS-GRAPH/ANNOTATE, Windows, UNIX-AIX.

Feb 2010 - Mar 2010

2 months

Software Developer

Druckerei Görich & Weiershäuser

Conversion of an address management system to UTF-8.
Technologies: Delphi, UTF-8.

Aug 2009 - Dec 2009

5 months

Frankfurt, Germany

Plausibility Checks for Data Import

Commerzbank AG

Plausibility checks (Basel II) during data import with report output using the Excel XP tagset.
SAS under z/OS / Excel as input front end.
Systematika / Commerzbank.
Technologies: SAS, Z/OS, Excel.

May 2009 - Jun 2009

2 months

Hanover, Germany

Product Development

CalRes DV

CalRes – Simulate: Program to generate DataSteps for SAS from an Excel workbook.
Enabled SAS command generation without macro knowledge.
Technologies: SAS, DELPHI ADO, ACCESS, DELPHI OLE.

Jan 2009 - Apr 2009

4 months

Braunschweig, Germany

Software Developer

Thünen-Institut

Delphi-based frontend for the SAS evaluation system for project grants.
Market analysis at the Thünen Institute.
Technologies: SAS, DELPHI, XML, OLE, DevExpress, ZEOS, FastReport.

Jun 2008 - Dec 2008

7 months

Braunschweig, Germany

Software Developer

Thünen-Institut

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

Aug 2007 - May 2008

10 months

Braunschweig, Germany

SAS – Statistics and Reporting

Thünen-Institut

Economic key figures / econometric calculations.
Physical calculations / unit conversion.
Project scoring methods.
Technologies: SAS-BASE, SAS MACRO, SAS-CONNECT, XML, SAS-SQL.

Feb 2007 - Jul 2007

6 months

Braunschweig, Germany

Software Developer

Thünen-Institut

Excel-based management system for project sheets with import and export routines to SAS XML/CSV.
Template management; client/server.
Technologies: DELPHI, DevExpress, ZEOS, Firebird, Postgres, XML.

Dec 2006 - Jan 2007

2 months

Writer / Documentation

Diverse

No programming.
Writing articles in Word.
Word mail merge.

Mar 2006 - Nov 2011

5 years 9 months

Braunschweig, Germany

SAS Developer

Thünen Institute

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

Jan 2006 - Feb 2006

2 months

Braunschweig, Germany

SAS-TemplateSystem Reporting

Thünen Institute

PROC-Tabulate / PROCReport.
Getting familiar with EU reporting requirements.
Technologies: SAS, SAS-BASE.

Jun 2005 - Sep 2005

4 months

Braunschweig, Germany

Web Developer

Thünen Institute

Web development with Mambo (now Joomla).
Creating manuals.
Technologies: Joomla, JS, CSS, MYSQL, MS-OFFICE.

Summary

Originally, I worked in data management for public administration on business benchmarking and investment evaluations, then moved to the private sector where I have now been working for almost 20 years. My areas of work so far are KPI reporting, data management, technical and regulatory documentation. For some local clients, I support VBA and Delphi projects. I enjoy working in an international team and am familiar with parallel and coordinated processes as well as time-shifted work processes. I have worked in several Scrum projects in an agile way. I also welcome tasks that don't directly fit my previous work profile.

Skills

Technical Documentation Development, Project Reporting, Quality Control
Sas, Rex, Pl/i, Vba, Delphi, C++, Python, R
Sas Macros, Sql, Xml, Xbrl, Powershell, Bash, Jcl, Perl, Fortran
Sas 9.4, Viya, Ms-sql - Tsql, Ms-access, Mysql, Db2, Postgres, Oracle, Sqlite, Firebird
Excel, Access [Vba], Power-bi 2020 [Dax], Linear Optimization, Skr03, Kpi, Kci
Opentext (Formerly Hp), Opentext-alm, Opentext-qc, Opentext™ Alm Octane
Tso, Ispf, Tso-beta92, Tso-beta93, Tso-rvs
File Management, Log Manager, Output Management, File Transfer
Jcl-iebgener, Jcl-dsntiaul, Jcl-dfsort, Jcl-rex
Xinfo, Twgraph, Jcl-iebcopy, Pacific-smf Writer
Sas-9.4 Foundation, Sas-enterprise Guide, Sas-viya, Sas-mxg, Sas-stat, Sas-access, Proc Report, Proc Sql, Datastep
Qmf-z/os, Qmf-win, Db2-admin, Data-studio, Db2-load-utility, Db2-unload
Pgadmin, Pgdash (Monitoring), Pgmodeller
Visual Studio, Ms Project, Ms Office, Ms-sql Server Management Studio, Ms Visio, Power Bi, Azure, Powershell
Oracle Sql Developer, Oracle Virtualbox
Opentext-alm, Opentext-qc, Opentext™ Alm Octane
Github, Git, Svn
Python, Delphi, Ollama, Zeta Producer, Inno Setup
Embedded Development With Msp430 And Arduino Iot
Handling Oscilloscopes, Measuring Devices, Frequency Generators, Volterra V-one, Soldering Station
Controls With Miac And Controllino
Knowledge Of C, Flowcode, Codesys