Go to Website
  • en
  • de

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
Sep 1996 - Sep 1996
1 month
Düsseldorf, Germany

Software Developer / Consultant

Financial Authority Data Center

  • Process control for various modules
  • OS: HP-UX 10.x
  • Languages: shell programming, KornShell
Jul 1996 - Jun 1998
2 years
Norderstedt, Germany

Software Consultant and Developer

Softprojekt GmbH

Feb 1995 - Jun 1996
1 year 5 months
Lübeck, Germany

Software Developer

Reteco Datentechnik GmbH

  • Database design, implementation, tuning
  • Developed modules for freight forwarding software
  • Ported legacy apps, shell scripting
  • OS: HP-UX, SCO-UNIX
  • Databases: Informix SE 5.0, Informix Online 6.0
  • Language: ROSI-SQL 3.2.x

Languages

German
Native
English
Advanced

Education

Lorem ipsum dolor sit amet

Dipl.-Ing. (FH) · Communications Engineering

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Henok A.

Founder and Managing Director

View Profile
Klaus-dieter P.

Senior Project Manager, Senior Process Consultant

View Profile
René P.

New development of a component-based complete solution for efficient workflows in municipal institutions

View Profile
Finn malte H.

Data Architecture

View Profile
Martin T.

Freelance, Interim Controller

View Profile
Pascal S.

Power BI Report Development

View Profile
Werner M.

IT Support

View Profile
Timo B.

Business Analyst

View Profile
Peter A.

IT Consultant

View Profile
Denis H.

Architect & Senior Cloud Developer - NEO OCR

View Profile
Dominik P.

Head of IT

View Profile
Ulrich C.

Java Architect/Developer – Freelancer

View Profile
Ben S.

Data Engineer

View Profile
Danial S.

Managing Partner

View Profile
Germo G.

BI Development

View Profile
fratch Part of Bitkom logo
linkedIncrunchbaseyoutube
  • English
  • Deutsch

2025 © FRATCH.IO GmbH. All rights reserved.