Gerd K. - Database and Software Developer

Hamburg, Germany

Experience

May 2021 - Sep 2023

2 years 5 months

Database and Software Developer

Information Technology Center Federal

Database and software development with Oracle PL/SQL
Data modeling
ATLAS (Automated Tariff and Local Customs Processing System)
SumA: General declaration
Interfaces: SumA – ZELOS, SumA – Impost, SumA – EAS/EKS
Development of modules to process messages between companies (so-called participants) and customs administration.
Operating systems: Unix, Linux, Windows
Database: Oracle 19
Programming languages: Oracle SQL, PL/SQL, Bash
Tools: PL/SQL Developer, CASE/4/0, MPS, Synergy, Git, Jira, Confluence

Oct 2017 - Aug 2020

2 years 11 months

Database and Software Developer

Adesso Health Solutions GmbH

KVAI – Billing and information system for physicians’ associations
Development of processing steps for Billing Area 2, per the service description, in parallel for Sybase (Transact-SQL) and Oracle (PL/SQL) databases.
Contributing to documentation, development specifications, aligning with requirements, estimating implementation effort, creating test plans, generating test data.
Topics: Call quotas, pain therapy regulations, dialysis material costs per EBM 40.14, regular service volume (RLV, QZV), fee distribution scale HVM, X-ray contrast agent regulation RKM, telematics infrastructure TI, and more.
Performance tuning.
Operating system: Windows 10
Databases: Sybase ASE 15.0, Oracle 12.2
Programming languages: Sybase Transact-SQL, Oracle PL/SQL, Perl
Tools: AccuRev, SVN, PowerDesigner, SQL Developer, SQL*Plus, Jira, Confluence, MS Office

Feb 2012 - Sep 2017

5 years 8 months

Developer and Client-Server Application Support, Second-Level Support, Administration and Application Management

R+V Insurance

Data modeling, development of procedures and PL/SQL packages
Enhancing applications for managing unit-linked life and pension insurance, managing agents and agent contracts with conditions and condition packages, commission billing.
Data preparation for pension benefit notifications.
Loading street and place directories from Deutsche Post.
Automating processes and interfaces via shell scripts, crontab, Oracle jobs.
Ad-hoc reports via SQL and PL/SQL.
Performance tuning.
Optimizing Perl modules with embedded SQL serving as ETL modules for the data warehouse.
Operating systems: Windows XP, Windows 7, Windows 10, Linux
Databases: Oracle 11.x, Greenplum 11.3 (based on PostgreSQL 8.4)
Languages: Oracle PL/SQL, PowerBuilder 12.5, shell scripting, Perl
Tools: T.O.A.D., SQL*Plus, SQL Developer, Eclipse, AQT, PgAdmin, InstallShield, PuTTY, VMware, Citrix Client

Jun 2011 - Jan 2012

8 months

Data Warehouse Developer

Advertising Agencies Service Provider

Data modeling, development of procedures and packages for ETL processes and data reconciliation
Automating processes via shell scripts and crontab
IVW data (auditing association for circulation of advertising media)
Profitability calculation
Media buying, competitor data: merging data from subsidiaries in several countries
Performance tuning.
Operating system: Windows XP
Database: Oracle 10.2
Languages: Oracle PL/SQL, shell scripting
Tools: PL/SQL Developer, T.O.A.D., PowerDesigner 11.1, PuTTY, vi, gvim, bash/ksh scripts, SQL Central, SQL Advantage, CVS, Tortoise, QVCS, MS Office

Apr 2010 - May 2011

1 year 2 months

Database and Software Developer

Management Systems GmbH (now Adesso Health Solutions GmbH)

KVAI – Billing and information system for physicians’ associations
Developing processing steps for Billing Area 2 in parallel for Sybase (Transact-SQL) and Oracle (PL/SQL) as per service specs.
Contributing to development specs, aligning with requirements, estimating effort, creating test concepts, generating test data.
Enhancing processing step control.
Reorganizing system components so calculations can be simulated in temp tables for testing.
Topics: regular service volume (RLV), qualification-based additional volume (QZV), convergence regulation, job sharing, part-practice communities, time-limited capacity limits, social psychiatry regulation, pain therapy rules, Euro calculator, point calculator, quota model, VDX (unified data exchange), recourse and follow-up billing, processing step control, parallel processing
Doctor registry – default modules
Developing and maintaining default modules in parallel for Sybase and Oracle. These recalculate or carry over billing-relevant master data for doctors and practices per billing rules for the next quarter.
Topics: specialties, focus areas, VGK flat rates, audit groups, practice budget, case numbers, lab budget, fee group, doctor group, number of doctors, GOP catalogs, cutting validity periods, RLV: start of activity, various exemptions
Performance tuning.
Operating system: Windows XP
Databases: Sybase ASE 12.5, Oracle 10.2
Languages: Sybase Transact-SQL, Oracle PL/SQL
Tools: AccuRev, DbVisualizer, T.O.A.D., PowerDesigner, CAST SQL Developer, SQL*Plus, SQL Advantage, PowerDesigner 11.1, PuTTY, vi, gvim, bash/ksh scripts, SQL Central, CVS, Tortoise, QVCS, MS Office

Jan 2010 - Sep 2023

13 years 9 months

IT Consultant and Managing Director

Kock IT-Service GmbH

Sep 2008 - Jan 2009

5 months

Database and Software Developer

MS Management Systems GmbH (now Adesso Health Solutions GmbH)

KVAI – Billing and information system for physicians’ associations
Developing processing steps for Billing Area 2 in parallel for Sybase and Oracle (e.g., lab economic bonus, job sharing, pain therapy, point limits, point valuation, fee reclamation after plausibility check, generating journal entries, SAP export, VDX generation).
Maintaining and extending a tool for migrating procedures (Oracle → Sybase).
Performance tuning.
Operating systems: Windows XP, SUSE Linux, HP-UX
Databases: Sybase ASE 12.5, Oracle 10.2
Languages: Sybase Transact-SQL, Oracle PL/SQL
Tools: AccuRev, DbVisualizer, T.O.A.D., PowerDesigner, CAST SQL Developer, SQL*Plus, SQL Advantage, PowerDesigner 11.1, PuTTY, vi, gvim, bash/ksh scripts, SQL Central, CVS, Tortoise, QVCS, MS Office

Oct 2007 - Aug 2008

11 months

Lübeck, Germany

Database and Software Developer

LHG, Lübeck Port Company mbH

IHS – Integrated port logistics system
ISS – Integrated freight forwarding system
Developed an algorithm for optimal container slot finding on the port site (Sybase stored procedures).
Maintaining and enhancing ISS and IHS with PowerBuilder and Sybase DB/procedures.
Maintaining and improving reports/print programs using Hyperion SQR Developer.
Reverse-engineered database model with PowerDesigner.
Organized and ran a training course “Unix/Linux Intro: Shell, vi, shell scripting”.
Introduced QVCS version control for PowerBuilder source.
Operating systems: Windows XP, SUSE Linux, HP-UX
Database: Sybase ASE 12.5.3
Languages: Sybase Transact-SQL, Sybase PowerBuilder 10.5/11.0, Hyperion SQR Developer 8.5
Tools: PowerDesigner 11.1, QVCS Professional 3.1

Nov 2006 - Dec 2009

3 years 2 months

Freelance IT Consultant

Self-employed

Nov 2006 - Dec 2007

1 year 2 months

Bern, Switzerland

Database and Software Developer

RTC AG

KBUS – Credit advisor support system
Migrated Forms and Reports from Oracle Developer 6i to Oracle Developer Suite 10g.
Developed a metadata database to manage multilingual, multi-tenant application texts.
Built PL/SQL packages to import data from external systems into KBUS.
Operating systems: Windows XP, RedHat Linux
Databases: Oracle 9i, 10g
Languages: SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g
Tools: Oracle Developer Suite, T.O.A.D., Oracle Designer, Oracle Application Server 10g, MS Office, Serena Dimensions, Subversion, Tortoise, PuTTY, shell scripts, XML, XSLT

Sep 2005 - Oct 2006

1 year 2 months

Hamburg, Germany

Database and Software Specialist

Hamburg Süd

Accounts Receivable reporting system
Database design and development, data management routines, Oracle Forms and Reports
Developed a simple read-only replication mechanism to merge decentralized data from seven databases on four continents into HQ in Hamburg.
Integrated a document management system (HYPARCHIV) linking invoices to scanned documents.
Operating systems: Windows XP, Reliant Unix
Databases: Oracle 8i, 10g
Languages: SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g
Tools: T.O.A.D., Oracle Designer, Oracle Application Server 10g, Oracle Developer Suite, MS Office, HYPARCHIV

May 2005 - Jun 2005

2 months

Database Developer

etc Software

Developed stored procedures for booking and releasing vacancy periods in room inventory
Operating systems: Windows XP, SUSE Linux 9.0
Databases: MySQL 4.0, 5.0
Languages: SQL, PHP
Tools: mysql, phpMyAdmin, WS_FTP, vim

Jan 2005 - Aug 2005

8 months

Lübeck, Germany

Database Specialist

IMS, Individual Media Service GmbH

POS system for selling music tracks, ringtones and printing digital photos via kiosks and connected terminals
Database design, administration, performance tuning, stored procedures, triggers, functions
Evaluated a schema comparison tool
Introduced version control and change management for database development
Developed batch and SQL scripts using osql, isql, bcp to create/alter structures and load data
Designed and operated software modules to dynamically update top lists based on sales and release dates
Used SQL Server Agent for daily tasks
Operating systems: Windows XP, SUSE Linux 9.0
Database: MS SQL Server 2000
Languages: SQL, Transact-SQL, batch scripts
Tools: Enterprise Manager, Query Analyzer, Import & Export, bcp, isql, osql, ssh, PuTTY, vim, gvim, CVS, Tortoise CVS, Apex SQL Diff, NetOp, VNC

Dec 2002 - Dec 2004

2 years 1 month

Stuttgart, Germany

Software Developer

debitel AG

Maintained and enhanced in-house claims management system
Backend: modified and developed interfaces and reporting modules
Performance tuning, advised DB admin on reorganizations; partly technical project lead
IVR: built PL/SQL package to provide daily customer IDs/phones for call routing to agents
TAL delayed actions: designed and integrated delayed internal actions
Added ability to defer actions and built scheduler procedure via Oracle jobs
ETL (Informatica PowerCenter): built central daily load process for customer data, payments, chargebacks
Created reusable mappings, transformations, workflows
Integrated workflows into overall ETL process with control handoff to shell scripts
Frontend (PowerBuilder): updated per requirements
Migrated DB system to Oracle 9.2.0.4: updated PL/SQL, shell, Perl scripts, frontend, PowerCenter mappings/workflows
Replication/history purge: maintained and enhanced replication objects and PL/SQL packages for archiving in data warehouse
Operating systems: Sun OS 5.8, Windows NT 4.0, Windows XP
Databases: Oracle 8i, 9i
Languages: PL/SQL, SQL, shell (ksh, bash), Perl, Awk, PowerBuilder, Informatica 6.2
Tools: T.O.A.D., Oracle Designer, WinCVS, RCS, jCVS, MS Office, Lotus Notes, Visio

May 2001 - Aug 2002

1 year 4 months

Lübeck, Germany

Database Administrator / Consultant / Trainer

Erasco GmbH (now Campbell’s Germany GmbH)

Database administration across Oracle environments
Installed test databases
Export/Import, automated data transfer from production to test
Tuning: instance and SQL
Taught SQL and PL/SQL basics
Operating systems: Windows NT/2000
Databases: Oracle 8.0.6, 8i
Languages: PL/SQL, SQL
Tools: T.O.A.D.

Apr 2001 - Jun 2002

1 year 3 months

Hamburg, Germany

Software Developer / Consultant

Logica pdv

Insurance claims processing software
Developed client-server app for claims handlers
Implemented interfaces: workflow for claims app, data for contract, sales info, reinsurance systems, stats preparation
Operating systems: Windows NT/2000
Database: Oracle 8i
Languages: PowerBuilder 7.0, PL/SQL
Tools: How (Riverton CASE), SQL Navigator, T.O.A.D.

Jul 2000 - Oct 2006

6 years 4 months

IT Consultant and Managing Director

Baltic IT Service GmbH (BITS)

Jan 1999 - Jul 2000

1 year 7 months

Freelance IT Systems Consultant

Self-employed

Jul 1998 - Dec 1998

6 months

Hamburg, Germany

IT Consultant

CSC Ploenzke Financial Services North

Apr 1998 - Mar 2001

3 years

Hamburg, Germany

Software Developer, Database Administrator

Condor Versicherungen

Integrated a life insurance management system
Operating systems: Sun Solaris 2.6/2.7, Windows 95/98
Database: Oracle 7.x
Languages: PowerBuilder 5.x, PL/SQL
Tools: Oracle Reports, Oracle Designer 2000

Oct 1997 - Mar 1998

6 months

Hamburg, Germany

Software Developer, Database Administrator

Spedition Süderelbe

Warehouse management software for high-bay warehouse/distribution center
Performance tuning, DBA, module programming
Operating systems: HP-UX 10.x, Windows 3.11
Database: Oracle 7.x
Languages: PL/SQL, Oracle Forms 4.5
Tools: Enterprise Manager, S-Designor 5.x

Jun 1997 - Sep 1997

4 months

Effretikon, Switzerland

Software Developer, Database Administrator

Zürich / Züritel Insurance

Quote system for direct auto insurance
Data modeling, implementation, administration, application development, installation
OS: Windows NT Server/Workstation 4.0
Database: Sybase SQL Server 11.x
Languages: PowerBuilder 5.x, stored procedures
Tools: S-Designor 5.x, Powersoft DataArchitect 6.0

Oct 1996 - May 1997

8 months

Frankfurt, Germany

Software Developer / Consultant

IMS / Dental Association Hessen

Billing system for transactions between health insurers, dental association, dentists
Migration/data import (SQL Loader, PL/SQL)
DBA (Oracle Parallel Server 7.3.x), replication from three other associations to Frankfurt
Temp backup concept implementation, diskette loader setup, staff coaching
OS: HP-UX 10.x, Windows NT 3.51/4.0
Database: Oracle 7.3.x
Languages: PL/SQL, ksh