Systems Programming and Networks
Database Importer for Oracle
Planning and coding of a robust automatic database importer for a proprietary data warehouse under Oracle
- import from diverse ASCII-datasources
- import profiles allow further expandability for additional data streams and adaptation of time behaviour
- coding in PERL
- documentation and testing book
Versioning module
Implementation of a versioning module for an ASCII-database interface to Oracle
- enhancement of Oracle-database with history tables and corresponding triggers
- visualization under MS-Access with full insert/update/delete history
- reporting of database updates, filter extensions for time dimension
- information about last changes in data input forms
Metering data interface Oracle
Development and implementation of a metering data interface to a proprietary Oracle data warehouse of a utility control system.
- programming the PERL module for import of datafiles, handling the import ASCII files and conversion into the target database structure
- project coordination with data warehouse vendor, adaptation of database importer to Oracle
- development of a test program and execution of module- and integration tests
Linux-Printserver
Setup and installation of a print server under Linux for mass mailings, because the former windows printing solution could not handle data traffic reasonably. Print data will now be sent through a specially configured Barebone-PC running Linux.
MT940 Interface
MT940 SWIFT interface for the automated import of bank statements from ELBA into a relational database system. Handling of prior transfers and integration into an existing payment system. The interface and the MT940 module were implemented in PERL 5, the payment system is running on PHP5/MySQL.
Servercluster
Installation and parameterization of a high availability cluster of 2 webservers. Automatic failover to standby server in case of errors without significant delays Details »
Export interface for control system network
Development of a redundant real-time interface between a high availability process control system and office applications. Realization by means of shell and PERL programming. Details »
Secure Webserver
Setup of a secure web server based on the open-source operating system OpenBSD. OpenBSD is a UNIX operating system optimized for strict security-policies ("secure by default" i.e. highest protection level for default installations).
