Martin (Dr.) Schaefer - Measurement Data Provision via LoRa
Experience
Measurement Data Provision via LoRa
End Customer Project
- Measurement data provisioning via LoRa Things Network to PC.
- Technologies: Python, PostGres, C#, Eagle
Quality Assurance, Code Review
KfW
- Quality assurance and code review in SAS, DB2, and VBA and R.
- Internal review of compliance with documentation and source code standards regarding BaFin regulations.
- Keywords: ISTBQ, MS Office, NIS, Dora, Idgart, Git.
Training: PostGres SQL
- Instructor-led training.
- EDB PostgreSQL administration & performance tuning.
- Setting up backup and failover scenarios.
Software Developer
End customer - migration project
- Migrated a Delphi MS-SQL Windows application to a C# Wisej .NET Azure web application.
Training
- ISTBQ Foundation certificate – study and exam.
- Python update.
Regulatory Reporting
Savings Banks Financial IT
- Working in the CCR III domain.
- Participated in two production go-live packages/events.
- Agile development in direct contact with the business department.
- Programming according to specifications.
- Code review of source code from the team.
- Answering tickets for customers (branches) under the guidance of subject matter experts.
- Netting packages and risk allocation: Consolidation of 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
- Recreated Docker files and Hyper-V for development environments.
- Initial familiarization with Kubernetes.
- Maintenance work in the Delphi UniGui area.
- Office renovation.
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 with Git.
- Time-shifted working 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 z/OS / 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, and PL/I programs into SAS BI stored processes.
- Collaboration on the analysis of existing reports on insurance contracts and cost overviews.
- Professional and technical documentation in source code and Word of long-lived reports in collaboration with subject matter experts.
- Agile working method with Scrum sprints and an iterative approach.
- KPI creation regarding 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.
Data Analyst
Commerzbank
- Data analysis & 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.
Software Developer
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.
Management Reporting
Deutsche Bank
- Worked in identity and access management.
- Documented data runs and time windows of data flows.
- Created Oracle VIEWS/MVIEWS and PL/SQL routines for data retrieval from the central data warehouse.
- Used VBA in a PowerPoint report.
- Team language is English.
- Worked in a time-shifted work model with colleagues in Bangalore and London.
- Technologies used: SQL, PL/SQL, Oracle 12c / Oracle SQL Developer.
Software Developer
Association of Statutory Health Insurance Physicians in Lower Saxony
- Implemented a layer of VIEWS and SYNONYMS as an abstraction layer for exchanging the data model with downstream applications.
- Used VIEWS in Oracle packages and Postgres packages.
- Extended the view layer (PL/SQL) with data from the department data mart.
- Handled project documentation and tracking in JIRA.
- Used agile development with 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.
Time off / training
- Training in SAS-DI / SAS VA Reporting / GIT / C# / R / Markdown.
SAS-BI Developer / Documentation Specialist
Commerzbank
- Documented and ensured regulatory-compliant production deployment of multiple SAS-BI program packages.
- Created user documentation for functional testing with HPQC and for using the web frontend.
- Prepared documentation for business and system developers: developer handbook, authorization concept, and report creation.
- Performed technical HPQC tests and recorded deployments of functionally tested programs.
- Created EUCs for the report system context.
- Documented existing 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 (on Unix/Windows).
- Integration into the new data warehouse / customization and alternative development.
- Testing and further development of a technical template that wraps the new system environment.
- Modification of about 280 legacy programs and embedding them into the new system template within the team.
- Incorporation of new data from the cross-departmental data warehouse / data lake.
- Deployment of the programs into the stored-process web environment.
- Targeted delivery of result and run-time reports via email.
- Conversion of a VBA/SAS combined 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.
- Development of a zOS-DB2 application that standardizes 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 re-import.
- Reports on application runtimes with Pacific-Systems SMF Writer.
- Technologies used: zOS-DB2, JCL's, 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.
Application-Owner / SAS Developer
Volkswagen-AG
- Took over a legacy SAS application and updated its documentation.
- Created a user manual.
- Researched cost drivers, revenue shortfalls, and causes of faulty data.
- Prepared technical application documentation with analysis of data flow and procedures.
- Took over the SAS accounting system as application owner, ensuring monthly billing.
- Updated the SAS-MXG system to the current 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.
SAS Data Management / Analyst
Santander Consumer Bank
- Created data sets for statistical analysis.
- Managed data for the statistics department and ad hoc analyses for products and segments.
- Performed frequency and occurrence analyses.
- Integrated data with verification using Proc Compare with ODS / ODS Trace.
- Documented existing code in the 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 / KPI Calculation
Santander Consumer Bank
- Calculated key figures for the valuation allowance according to HGB and compared them to the corresponding IAS figures.
- 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 and check macros.
Software Developer / Product Development
CalRes DV
- Maintenance and product development of the CalRes SAS-CodeLib (program for managing SAS routines in multi-user operation).
- Integration of statistical routines with MySQL and VFront connection for internet data exchange.
- Development of CalRes Central (program for data management in occupational therapy and physiotherapy practices - first prototype).
- Technologies: SAS, C++, Delphi, Oracle.
Product Development
CalRes DV
- CalRes Central: program for data management in occupational therapy and physiotherapy practices - first prototype.
- Technologies: Delphi, Oracle.
SAS Developer
DASTA-GmbH
- Analyses for clinical trials (Kaplan-Meier, risk tables, clinical datasets).
- 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 during Data Import
Commerzbank AG
- Plausibility checks (Basel II) during data import with report output using Excel XP tagset.
- SAS on z/OS / Excel as input frontend.
- Systematika / Commerzbank.
- Technologies: SAS, z/OS, Excel.
Product Development
CalRes DV
- CalRes – Simulate: program to generate SAS DataSteps from an Excel workbook.
- Enabled SAS command generation without macro knowledge.
- Technologies: SAS, Delphi ADO, Access, Delphi OLE.
Software Developer
Thünen-Institut
- Frontend built in Delphi for the SAS evaluation system for project grants.
- 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 for preparing SAS reports.
- Mondrian project: OLAP using 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 conversions.
- Project scoring methods.
- Technologies: SAS Base, SAS Macro, SAS/Connect, XML, SAS SQL.
Software Developer
Thünen-Institut
- Management system for project sheets in Excel with import and export routines for SAS XML/CSV.
- Template management; client/server.
- Technologies: Delphi, DevExpress, Zeos, Firebird, PostgreSQL, XML.
Writer / Documentation
Various
- No programming.
- Writing articles in Word.
- Word mail merges.
SAS Developer
Thünen-Institut
- SAS statistics: regional models with factor / cluster / variance analyses.
- New edition of a survey form: import macro system with XML output.
- Excel VBA, CSV import following guidelines of the participating state banks and authorities.
- Technologies: SAS Base, Forecast, Excel VBA, XML.
SAS-TemplateSystem Reporting
Thünen-Institut
- PROC Tabulate / PROC Report.
- Learning EU reporting requirements.
- Technologies: SAS, SAS Base.
Web Developer
Thünen-Institut
- 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
Originally, I worked in public administration in data management for operational benchmarking and investment evaluation, and then I moved to the private sector where I've now been active for almost 20 years. My past work areas include KPI reporting, data management, and technical and regulatory documentation. For some local clients, I maintain VBA and Delphi projects. I enjoy working in an international team and am familiar with parallel and coordinated workflows as well as time-shifted work processes. I've worked agile in several Scrum projects. 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 Macro, 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 Stations
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 Measurement Data Provision via LoRa
Nearby freelancers
Professionals working in or nearby Hanover, Germany