Frank Welk
Software Development
Experience
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
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
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
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)
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
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
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
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
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
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Healthcare (31 years), Insurance (5 years), Automotive (3.5 years), Information Technology (2.5 years), Pharmaceutical (1.5 years), and Banking and Finance (0.5 years).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (31 years), Product Development (31 years), Project Management (31 years), and Quality Assurance (8.5 years).
Summary
My main drive in software development is the ambitious realization of business requirements into a product.
My passion is to create solutions that are not only efficient but also ergonomically optimized.
Through this combination, I strive to shape not only the technical aspects but also the user experience at the highest level.
Skills
- Software Development
- Requirements Management
- Database Design/architecture
- Database Administration (Oracle Databases Version 6 To 19)
- Oracle Developer (Forms, Reports, Graphics)
- Pl/sql Developer
- Apex 19 And 23
- Vba, Office Vba
- Project Management
Languages
Education
Technical University of Braunschweig
Diploma in Computer Science, minor in Statistics and Operations Research (Econometrics) · Computer Science · Braunschweig, Germany · very good
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Frank based?
What languages does Frank speak?
How many years of experience does Frank have?
What roles would Frank be best suited for?
What is Frank's latest experience?
What companies has Frank worked for in recent years?
Which industries is Frank most experienced in?
Which business areas is Frank most experienced in?
Which industries has Frank worked in recently?
Which business areas has Frank worked in recently?
What is Frank's education?
What is the availability of Frank?
What is the rate of Frank?
How to hire Frank?
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 Software Development
Nearby freelancers
Professionals working in or nearby Vienna, Austria