Selected Work · 1992–today

Two decades of projects. Most still in production.

A selection from the last twenty years — ERP systems still running after thirty years, treasury platforms moving billions a day, and engineering firsts in automated typesetting. (Earlier work goes back to 1985.)

Highlights

Built to last — and to scale.

KLARA ERP

245,000 lines of Informix 4GL. Complex address, product, stock and third-party billing with DATEV, SIMBA, Lexware and Navision interfaces. In production since 1992 across multiple companies.

E.ON Treasury (TREMA)

Technical maintenance of a treasury platform processing €2.5 billion in transactions per day, where failure is not an option — across Perl, Python, Java, Oracle, CORBA and SOx compliance.

A typesetting first

To the best of our knowledge, the first automatic page-breaking process without widow & orphan lines — solving a problem with no known mathematical optimum, built on PhotoTeX.

The track record

Selected projects, 1992–today.

Enterprise IT, database engineering, file-transfer, automated publishing and data mining — delivered end to end.

1992 – today

KLARA — ERP Platform

A 245k-line Informix 4GL ERP with hierarchical product schemes, multi-stock keeping, consignment, third-party billing and full financial-bookkeeping interfaces. Rolled out across Hausleiter, Neeb, Faber, Döring, Schnädelbach and others.

  • AIX
  • Linux
  • Informix 4GL
  • PhotoTeX
  • C
  • Perl/DBI

1993 – 2005

Reger Studios — FOTO & Goldina Loy — RIBBON

Industry-specific ERP systems built on the KLARA platform, tailored for studio and manufacturing operations.

  • AIX
  • Linux
  • Informix 4GL
  • TeX
  • C

1999 – 2009

RT-Reprotechnik — COPY

KLARA extended with asynchronous database replication for architectural copies: 22,000 sheet-sizes and products across 35 subsidiaries.

  • Informix 4GL
  • DB replication
  • Linux

2000

GKN Aerospace — Prepreg Data Repository

Data extraction from SAP R2 via ABAP, complete database design and application redesign for prepreg airplane components.

  • Solaris
  • MySQL/InnoDB
  • DB2
  • Perl (DBI/CGI)

2000 – today

eltric K. Heckel — Marketing Automation

Full-colour product catalogue, image archive, asset management, format conversion, web catalogue and shop, plus web-to-ERP integration. Later: PasseParTout online typesetting with font upload.

  • Informix
  • PostgreSQL
  • TeX
  • ImageMagick
  • Java
  • JavaScript

2001 – 2004

CROSSIT & Matthews — ERP / PPS

A from-scratch integrated ERP/PPS system, plus business-process analysis and fit4web ERP design, including order-management extranets for major consumer-goods brands.

  • Informix
  • MySQL/InnoDB
  • Perl
  • Java
  • JavaScript

2003 – 2004

Media & Press Distribution

Web solutions to distribute press photos with archive, index and scheduler, plus image archives and online typesetting for leading automotive, industrial and cultural organisations.

  • Perl (CGI-AJAX/DBI)
  • TeX
  • MySQL
  • ImageMagick

2004 – today

Scholler — Global Asset Replication

Database-replication methodology to consolidate worldwide data repositories across subsidiaries for asset and order management, on cloud infrastructure.

  • Linux
  • Perl
  • PHP
  • MySQL/InnoDB
  • Amazon EC2/S3

2006 – today

VGF — Collective Rights Management (Film)

Full application redesign and Informix→MySQL migration of a clearing & settlement system for directors and producers — plus data-mining across 130,000+ TV broadcasts on 25 European stations using unified surrogate keys.

  • OO-Perl (DBI/CGI-Ajax)
  • TeX
  • JavaScript

2008

Texas Instruments — Galileo

Member of the Galileo development team: an Oracle web platform for TI Business Units, projects, products and finance/yield. Built an MVC solution in JavaScript and transposed Oracle PL/SQL into Perl DBI/CGI with SQL optimization.

  • Perl
  • JavaScript
  • Oracle SQL/SQLX

2008 – today

Cinterion / Siemens-Bosch & PersonalNovel

International online business cards with two-phase procurement and full UTF-8 (Korean, Chinese, Arabic, European scripts) — and online personalized children's books generated automatically with PhotoTeX.

  • PhotoTeX
  • Perl
  • UTF-8
  • Online typesetting

2008 – today

E.ON — Treasury, Connectivity & Reporting

Long-running engagement across the E.ON treasury landscape: the TREMA V6→V7 migration, AXWAY SecureTransport (UK go-live and worldwide rollout), the CRIPER report generator, market-data systems and automated brochure typesetting — handling €2.5 B/day under strict SOx governance.

  • Perl
  • Python
  • Oracle 11g
  • CORBA
  • AXWAY SecureTransport
  • PhotoTeX

Where this leads

Thirty years of taming enterprise data.

Every project here is, at heart, the same craft: imposing order on complex, redundant, real-world data. That craft is now the foundation of ConnectSphere — our venture turning messy enterprise data into one logical, AI-ready truth.