Martin (Dr.) Schaefer-Measurement Data Provision via LoRa
Check rate
Experience
MS Fabric Certification
MS Fabric certification with creation of pipelines and notebooks in Fabric using data from Azure, Azure Repos, Azure Boards, and GitHub. Data ingestion via OneLake Explorer, direct IP connection, and API (REST) are the main topics
Measurement Data Provision via LoRa
End Customer Project
- Measurement data provision from LoRa Things Network to PC.
- Technologies: Python, Postgres, C#, Eagle
Quality Assurance, Code Review
KfW
- Quality assurance and code review for SAS, DB2, VBA, and R.
- Internal audit of compliance with documentation and source code standards according to BaFin rules.
- Keywords: ISTBQ, MS Office, NIS, DORA, Idgart, Git.
Postgres SQL Training
- Instructor-led training.
- EDB PostgreSQL administration and performance tuning.
- Setting up backup and failover scenarios.
Software Developer
Client Migration Project
- Migration from a Delphi–MS-SQL Windows application to a C# Wisej.NET Azure web application.
Further Training
- ISTQB Foundation Certificate – study and exam.
- Python update.
Reporting
Savings Banks Finance IT
- Working in the CCR-III area.
- Participated in 2 production release packages / go-live events.
- Agile development in direct contact with the business unit.
- Programming to specification.
- Code review of source code from the team.
- Responding to tickets for customers (branches) under guidance of specialist colleagues.
- Netting packages and risk allocation: merging 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 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 OpenText ALM / OpenText QC, IBM Code Pipeline, WinSCP, Confluence and MS Office.
Software Developer
End-Customer Projects
- Set up Docker files and Hyper-V for development environments.
- Gained initial experience with Kubernetes.
- Performed maintenance work on Delphi-UniGui.
- Renovated the office.
DevOps Engineer and Tester
Deutsche Bank
- Assigned to the Infrastructure area.
- Mainframe job monitoring / ad-hoc error analysis.
- Code review.
- Documenting Oracle, VBA and SAS source code.
- Version control in Git.
- Time-shifted work 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-zOS / SAS-PC / PL/I / ISPF / B92 / SFDF / TSO / VBA, Confluence / Office 365 (MS-Access/MS-Excel/MS-Word).
Data-Analyst / Data-Engineer
Bavarian Insurance Chamber
- SAS mainframe to SAS BI migration for the Mathematics and Controlling departments.
- Conversion of Host-SAS, REX, PL/I programs into SAS-BI stored processes.
- Assisted in analyzing existing reports on insurance contracts and cost overviews.
- Functional and technical post-documentation of long-running reports in source code and Word, in collaboration with specialist colleagues.
- Agile working with Scrum sprints and an iterative approach.
- KPI creation around costs and volumes of contract types and insurance categories for private and public health insurance.
- Tools: DB2 / SAS / ISPF / PL/I / PowerShell / MS Office / Confluence.
Data Analyst
Commerzbank
- Data analysis and reporting using SAS 9.4 and SAS Viya in MS Office and Power BI.
- Documentation (EUC / manual).
- Simulations for controlling.
- Support in defining allocation keys.
- KPI and status/ad-hoc reporting.
Software Developer
CalRes DV
- Redevelopment of a Delphi accounting application in C# and partly in JavaScript using TMS WebCore components.
- Data exchange with Tesseract OCR.
- Technology: C# (WinForms) / Lazarus / Delphi / TMS WebCore, Oracle 12c / Oracle SQL Developer / Tesseract.
Management Reporting
Deutsche Bank
- Area of Identity and Access Management.
- Documentation of data runs and time windows of data flows.
- Creating Oracle VIEWS / MVIEWS and PL/SQL routines for retrieving 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.
Software Developer
Kassenärztliche Vereinigung
- Implementing a layer of VIEWS and SYNONYMS as an abstraction layer for exchanging the data model under downstream applications.
- Use of VIEWS in Oracle packages and PostgreSQL packages.
- Extension of the business view layer (PL/SQL) with data provided 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 looks after about 40,000 doctors and ensures medical care.
- Technologies used: SQL, PL/SQL, Oracle 11g / Oracle 12c / Oracle SQL Developer.
Time-out / Training
- Training in SAS DI / SAS VA reporting / Git / C# / R / Markdown.
SAS-BI Developer / Documentation Specialist
Commerzbank
- Documentation and regulatory-compliant deployment of several SAS-BI program packages.
- Creating user documentation for functional testing with HPQC and using the web frontend.
- Documentation for business and system developers: developer guide, permission concept, report creation.
- Technical HPQC tests and logged deployment of functionally tested programs.
- Creation of EUC for the context's reporting system.
- Post-documentation of SAS macros.
- Technologies used: HPQC, SharePoint, MS Office, EUC database, SAS-BI.
SAS-zOS to SAS-BI Migration Specialist
Commerzbank
- Program migration from SAS-zOS to SAS-BI (Unix/Windows).
- Integration into new DWH / customization and alternative development.
- 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 result and runtime reports via email.
- Conversion of a VBA / SAS combo application to the new system.
- Technologies used: SAS-zOS, SAS-BI, Stored-Process-Server / Workspace-Server, VBA.
Database Development
Volkswagen-AG
- Database development with zOS-DB2 and Windows MS SQL Server for data delivery to VMware-ITBM and Bissantz DeltaMaster.
- Building a zOS-DB2 application that standardizes proportional billing data and delivers it on time.
- Porting the application to MS SQL Server, taking into account the import structure for DeltaMaster reporting.
- Application documentation with data flow and procedure analysis of the new system.
- Support in resolving customer inquiries.
- Creating import routines in VMware-ITBM and Excel sheets with SQL statements for database re-import.
- Runtime reports for applications using Pacific Systems SMF Writer.
- Technologies used: zOS-DB2, JCL, OFTP, BETA92/93, QMF, IBM Data Studio, PL/I, PostgreSQL, MS SQL Server, MS SSIS, MS VBA, DeltaMaster, Perl scripting, Bash, VMware-ITBM, COBOL, Pacific Systems SMF Writer.
Application-Owner / SAS Developer
Volkswagen-AG
- Taking over a legacy SAS application and doing post-documentation.
- Creating a user manual.
- Researching cost drivers, revenue losses, and analyzing causes of bad data.
- Technical application documentation with data flow and procedure analysis.
- Taking over the SAS accounting system as application owner: ensuring the monthly billing.
- Updating the SAS-MXG system to the current version while keeping 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.
SAS Data Management / Analyst
Santander Consumer Bank
- Creating datasets for statistical analysis.
- Data management for the statistics department and ad-hoc evaluations for products and segments.
- Frequency and occurrence analyses.
- Data integration with verification via Proc Compare using ODS / ODS Trace.
- Post-documentation of 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.
SAS Data Management / Key Figure Calculation
Santander Consumer Bank
- Calculation of key figures for valuation allowances under HGB and comparison to the corresponding IAS key figures.
- Development of macros for the monthly production run for controlling.
- Extensive pre-tests on multiple data sources.
- Excel VBA frontend for SAS routines and parallel remote processing.
- Technologies used: SAS Windows and Renote on Unix, SSH, sasautos routines, and check macros.
Software Developer / Product Development
CalRes DV
- Maintenance and product development of the CalRes SAS-CodeLib (program for managing SAS routines in a multi-user environment).
- Integration of statistical routines with MySQL and VFront connection for data exchange on the internet.
- Development of CalRes Central (program for data management in occupational and physiotherapy practices - 1st prototype).
- Technologies: SAS, C++, Delphi, Oracle.
Product Development
CalRes DV
- CalRes Central: program for data management in occupational and physiotherapy practices - 1st prototype.
- Technologies: Delphi, Oracle.
SAS Developer
DASTA-GmbH
- Analyses for clinical studies (Kaplan-Meier, risk tables, clinical data sets).
- Pharmaceutical reporting.
- Technologies: SAS 9.2, SAS/GRAPH/ANNOTATE, Windows, UNIX-AIX.
Software Developer
Druckerei Görich & Weiershäuser
- Conversion of an address management system to UTF-8.
- Technologies: Delphi, UTF-8.
Plausibility Checks for Data Ingestion
Commerzbank AG
- Plausibility checks (Basel II) during data ingestion with report output in Excel XP tagset.
- SAS on z/OS / Excel as the input frontend.
- Systematika / Commerzbank.
- Technologies: SAS, z/OS, Excel.
Product Development
CalRes DV
- CalRes – Simulate: Program to generate DataSteps for SAS from an Excel workbook.
- Enabled SAS command generation without any macro knowledge.
- Technologies: SAS, Delphi ADO, Access, Delphi OLE.
Software Developer
Thünen-Institut
- Delphi-based frontend for the SAS project grant evaluation system.
- Market analysis at the Thünen Institute.
- Technologies: SAS, Delphi, XML, OLE, DevExpress, Zeos, FastReport.
Software Developer
Thünen-Institut
- Automated data import system and code management for SAS.
- Excel macro to prepare SAS reports.
- Mondrian project: OLAP with Mondrian and Firebird for market analysis.
- Technologies: SAS, Oracle 10g, Delphi, OLE, Excel VBA, OLAP, Mondrian, Firebird.
SAS – Statistics and Reporting
Thünen-Institut
- Economic indicators / econometric calculations.
- Physical calculations / unit conversion.
- Project scoring procedures.
- Technologies: SAS-Base, SAS Macro, SAS-Connect, XML, SAS-SQL.
Software Developer
Thünen Institute
- Management system for project sheets based on Excel with import and export routines for SAS-XML/CSV.
- Template management; client/server.
- Technologies: DELPHI, DEVEXPRESS, ZEOS, FIREBIRD, POSTGRES, XML.
Writer / Documentation
Various
- No programming.
- Writing articles in Word.
- Word mail merge letters.
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 following guidelines of the involved state banks and authorities.
- Technologies: SAS-BASE, FORECAST, Excel VBA, XML.
SAS-TemplateSystem Reporting
Thünen Institute
- PROC Tabulate / PROC Report.
- Getting familiar with EU evaluation regulations.
- Technologies: SAS, SAS-BASE.
Web Developer
Thünen Institute
- Web development with Mambo (now Joomla).
- Creating manuals.
- Technologies: Joomla, JS, CSS, MySQL, MS Office.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Agriculture, Banking and Finance, Automotive, Information Technology, Healthcare, and Government and Administration.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Information Technology, Business Intelligence, Research and Development, Quality Assurance, Finance, and Accounting.
Summary
Nearly twenty years of experience transitioning I have from public administration to the private sector, working in data management, KPI reporting, and software development. There is deep expertise in technical documentation and agile methodologies while being comfortable working with international teams.
I have successfully handled complex tasks using technologies like Python, C#, Delphi, and SAS in Finance, Automitive and Insurance. My work consistently delivers clear and reliable solutions by transforming data processes and adapting to varied industry needs including documentaion an presentation.
kind regards
Martin Schaefer
Skills
Technical Documentation Development, Project Reporting, Quality Control
Sas, Rex, Pl/i, Vba, Delphi, C++, Python, R
Sas Macro, Sql, Xml, Xbrl, Powershell, Bash, Jcl, Perl, Fortran
Sas 9.4, Viya, Ms-sql T-sql, 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
Using Oscilloscopes, Measurement Devices, Frequency Generators, Volterra V-one, Soldering Station
Controls With Miac And Controllino
Knowledge In C, Flowcode, Codesys
Languages
Education
Dr. rer. hort., Production Horticulture with specialization · Production Horticulture
Certifications & licenses
ISTBQ Foundation Certificate
ISTBQ Foundation Tester
Postgres Specialist
SAS Advanced Programmer
SAS Certified
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Martin based?
What languages does Martin speak?
How many years of experience does Martin have?
What roles would Martin be best suited for?
What is Martin's latest experience?
What companies has Martin worked for in recent years?
Which industries is Martin most experienced in?
Which business areas is Martin most experienced in?
Which industries has Martin worked in recently?
Which business areas has Martin worked in recently?
What is Martin's education?
Does Martin have any certificates?
What is the availability of Martin?
What is the rate of Martin?
How to hire Martin?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a MS Fabric Certification
Nearby freelancers
Professionals working in or nearby Hanover, Germany
Most recent projects
FRATCH works with many companies and recruitment agencies. Here you will find our recently posted projects and opportunities.
