Frank Welk - Software Development

Recommended expert

Vienna, Austria

Experience

Apr 2024 - Present

1 year 10 months

Vienna, Austria

Software Development

REI and EMI

Code reviews, bug fixes, and new code development in PL/SQL and Oracle Forms
Upgraded the database version to Oracle 12/19 and migrated the Oracle Forms environment from client-server to web (6i → 12c)
Resolved blocking sessions and implemented new workflow requirements
Used PL/SQL packages, procedures, functions, database triggers, batch files, and Java applications
Redesigned screens based on Oracle Forms and client-side PL/SQL code
Handled the business process of issuing and processing vouchers (REI = Reimbursement; EMI = Emission), including billing with acceptance partners
Agile development based on SCRUM with monthly sprints and weekly meetings

Oct 2023 - Present

2 years 4 months

Braunschweig, Germany

Development and DBA

Modernization of UNISOLO-POESY GUI

Continued the modernization of the user interface of the UNISOLO-POESY practice management system using APEX 23, PL/SQL, and Oracle Forms

Sep 2022 - Dec 2023

1 year 4 months

Essen, Germany

Software Development

Relex and Narab

Created interfaces for exporting master data and transaction data (.csv UTF-8 encoded) from a pharmacy wholesaler's merchandise management system
Implemented the interfaces as PL/SQL packages
Conducted extensive developer tests and smoke tests in the AI application Relex for order proposals
Developed screens for maintaining and assigning post-discount configurations in the RX/OTC product area
Used partitioning for importing VSE mainframe data
Agile development based on SCRUM with monthly sprints

Jan 2020 - Dec 2022

3 years

Braunschweig, Germany

Development and DBA

Modernization of UNISOLO-POESY GUI

Modernized the user interface of the UNISOLO-POESY practice management system
Migrated single-form and multi-form screens from Oracle Forms technology to APEX (service chains, text templates, fee schedules, cash data, patient master data, electronic medical record)

Jan 2020 - Dec 2020

1 year

Hamburg, Germany

Development

DWH Anonymization

Developed PL/SQL procedures, functions, and packages for anonymizing personal data in an insurance data warehouse
Implemented algorithms based on specification requirements and created test plans
Used the extended waterfall model

Jan 2016 - Dec 2019

4 years

Hanover, Germany

Sub-project Lead, Software Development

MAS (Modernization of Billing and Master Data)

Modernization of billing and master data at the Lower Saxony Association of Statutory Health Insurance Physicians
Switching direct master data access to business abstractions for an external application
Performing extensive developer tests and smoke tests
Agile development based on SCRUM and project planning using Kanban boards

Sep 2011 - Dec 2011

4 months

Braunschweig, Germany

System Analysis and Development

System Analysis

Handling development tasks using VBA, Java and StreamServe Persuasion on Windows for the output management of a PSD bank in the automotive sector

Jan 2007 - Jun 2010

3 years 6 months

Gifhorn, Germany

Sub-project Lead, Software Development

Data Record Management in Engine Control Units

Developing a software product for quality assurance in engineering services for the automotive supplier industry
Managing software variants, labels and user permissions
Developing the graphical user interface with VB and ADO
Implementing replication mechanisms for winter/summer testing and multi-master replication

Jan 1995 - Present

31 years 1 month

Braunschweig, Germany

Project Management, Software Development and DBA

UNISOLO®-POESY

Design, implementation and ongoing project management of the practice management system for doctors, hospitals and clinics
Maintenance and update coordination with the legally required hotline
Managing over 300 screens and over 200,000 lines of code for 50 main screens
Features: patient master data management, statutory health insurance billing (KVDT), private billing (GOÄ, DKGNT, PAD), accident insurance billing (BG), ICD-10 diagnosis codes, interfaces to medical devices, certified medication database
Administration of about 50 Oracle databases including backup and recovery via RMAN and OEM