PostGres Training / Update

• EDB PostgreSQL administration and performance tuning.
• Setting up test scenarios.

• ISTBQ Foundation certificate – study and exam.
• Python update.

• Setting up new Docker files and Hyper-V for development environments.
• Initial introduction to Kubernetes.
• Maintenance tasks in the Delphi-UniGUI area.
• Office renovation.

• Assigned as Data Analyst / Data Engineer.
• Migrated SAS mainframe to SAS BI for the Mathematics 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 overviews.
• In collaboration with colleagues, did technical and business re-documentation in source code and Word for very long-lived reports (handover relics).
• Agile work with Scrum sprints and iterative approach.
• Created KPIs for costs and volumes of contract types and insurance types for private and public health insurance.
• Tools: DB2, SAS, ISPF, PL/I, PowerShell, MS Office, Confluence.

• Redevelopment of a Delphi Accounting -Applikation in C# and partly in JavaScript with TMS-WebCore-Components, Data-Exchange with Tesseract OCR.
• Technologie: C# - WinForms / Lazarus-/ Delphi / TMS-WebCore Oracle 12c / Oracle SQL-Developer / Tesseract.

• Implementing a layer of VIEWS and SYNONYMS as an abstraction layer for exchanging the data model under related applications.
• Use of VIEWS in Oracle packages and Postgres packages.
• Extension of the business VIEW layer (PL/SQL) with supply from the department data mart.
• Project documentation and tracking in JIRA.

The Association of Statutory Health Insurance Physicians in Lower Saxony supports around 40,000 doctors and ensures medical care in all regions.

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

• Documentation and regulatory compliant production release of multiple SAS BI program packages.
• Creating user documentation in professional testing with HPQC, handling the web frontend for business users.
• Documentation for business and system developers: developer guide, permission concept, report creation.
• Technical HPQC tests and logged deployment of business-tested programs to production.
• Creation of EUC for the report system context.
• Re-documentation of SAS macros.
• Technologies used: HPQC, SharePoint, MS Office, EUC database, SAS BI.

• Database development with z/OS-DB2 and Windows MS SQL Server for data delivery to VMware ITBM and Bissantz DeltaMaster.
• Task was to create a z/OS-DB2 application that standardizes and delivers proportional billing data from various formats to the downstream system on time.
• Porting the application from z/OS to MS SQL Server, taking into account the import structure for DeltaMaster reporting.
• The task also included creating application documentation with data flow and procedure analysis of the new system.
• Supporting clarification of customer inquiries with the created and other internal systems.
• Creating import routines in VMware ITBM, creating Excel sheets with SQL statements for DB re-import.
• Reports on application runtimes with the 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).

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

• CalRes SAS-CodeLib. Program for managing SAS routines in multi-user operation. Integrating statistical routines with MySQL and VFront connection for data exchange over the internet. Technologies used: SAS.

• CalRes Central. Program for data management in occupational therapy and physiotherapy practices - 1st prototype. Technologies used: C++, Delphi, Oracle.

• Analyses for clinical trials (Kaplan-Meier, risk tables, clinical data sets).
• SAS 9.2, SAS-Graph + Annotate.
• Pharmaceutical reporting.
• Technologies used: SAS 9.2, SAS-Graph/Annotate, Windows, UNIX AIX.

• Plausibility checks (Basel II) during data import with report output using Excel XP tagset (Excel controls the host).
• Systematica / Commerzbank.
• SAS on z/OS / Excel as input frontend.
• Technologies used: SAS, z/OS, Excel.

• 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, DevExpress OLE.

• SAS statistics and reporting: economic KPIs / econometric calculations, physical computations / unit conversions, project scoring methods.

• 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, PostgreSQL, XML.

• SAS statistics: regional models with factor / cluster / 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 involved state banks, ministries, and approval authorities.

• Technologies used: Excel VBA, XML.

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