Gerd Kock

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