Projects

Open Source Database Migration : : : Open Usability : : : Open Source Advocacy : : : UNIX Administration : : : Content Management : : : Oracle Data Warehouse : : : Informix DBA : : : Database Applications : : : Web Applications : : : Technical Design
Web Applications

Base CMS for Fliesen Discount
Development of base CMS functionalities to drive the website of Fliesen Discount: Separation of content and layout, dynamic setup of menus and sitemap, contact form, glossary (PHP, MySQL). Project lead and design: hexabinær.
Link: http://www.fliesendiscount.de

Base CMS for DEK Berlin
Development of base CMS functionalities to drive the website of Deutsche Extrakt Kaffee GmbH (DEK) Berlin: Separation of content and layout, dynamic setup of menus and sitemap, contact form, support for multiple languages in content and interfaces (PHP). Project lead and design: hexabinær.
Link: http://www.dek-berlin.de

Info Screen and Content Management System, Social Science Research Center Berlin (WZB)
Technical project lead and programming of a content management system for managing event data in a database as well as the scheduled output of events on a 47" display (PHP, Javascript, MySQL).
Link: http://www.wz-berlin.de

Greasemonkey Userscript: Touchscreen solution for Museum Koenig (ZFMK), Bonn
Adaptation of the ZFMK website for use on a Touchscreen Terminal in the exhibition area. Technologies: Greasemonkey (Firefox Extension), Javascript.
Link: http://www.zfmk.de

Competition web application for mediapeers AG
Programming of a web form with database backend and data export (PHP, MySQL).
Project lead and design: Daniel Braunschweig Text - Redaktion - PR.
Link: Offline (seasonal competition).

TOP


Content Management & Knowledge Management

Drupal: FREELENS Portal
Consulting and programming of functions, templates and module extensions of the Open Source content management system Drupal (PHP, Javascript, CSS).
Project lead, content and design: DesignWork, Cologne.
Link: http://www.dwork.de (FREELENS portal not yet online)

Drupal: Fixies Website
Implementation of the Fixies website with Open Source Content Management System Drupal. Installation, configuration and customizing, programming: PHP, Javascript, CSS.
Project lead, content and design: MSH AND MORE.
Link: http://www.fixies.de, http://www.zarte-babyhaut.de

Nodevision: Website "Zoologisches Forschungsmuseum Alexander Koenig (ZFMK)"
Programming of the ZFMK site and editorial system, using the Nodevision Content Management System.
Link: http://www.zfmk.de

GForge, Plone/Zope: OpenUsability.org
Technical project lead, administration, programming and customizing of a GForge collaboration platform, currently relaunch using Plone/Zope.
Link:: http://www.openusability.org (GForge platform, new Plone site not yet in production)

Plone/Zope: OSDBmigration.org
Administration and customizing of Plone as a knowledge base.
Link:: http://www.osdbmigration.org

PostNuke: Website Synthax Audio AG
Programming and customizing of PostNuke for company and product presentation.
Link:: http://www.synthax.de (New Website, Postnuke site is offline)

TOP


Technical Design

Requirement Engineering for papaya Software GmbH
Participated in technical design and requirement engineering for papaya Software GmbH.

TOP


Migration to Open Source Databases

Information Portal "Open Source Database Migration"
A comprehensive knowledge base on everything related to migrating to Open Source databases.
Link: http://www.osdbmigration.org

Migration to Open Source Databases: diploma thesis, computer sciences, TU Berlin
Provides a migration guide for switching to Open Source databases. Covers migration strategies, evaluation and comparison of Open Source databases. Proposes a process model for database migrations. Also covers the conceptual design and implementation of a migration case study (Informix to PostgreSQL).
Links: HTML   PDF

TOP


Open Usability

Launch and relaunch of OpenUsability.org
Conceptual design, implementation and administration of the OpenUsability.org web portal. Adapting the Gforge codes (PHP, PostgreSQL) to the Open Usability workflow.
Currently: Technical lead of the portal relaunch based on Plone/Zope.
Link: http://www.openusability.org

Open Source Consulting at relevantive AG
Set-up and conceptual design of the „Open Source Software“ unit of Berlin-based Usability agency Relevantive. Team lead, responsible for technical project management and consulting.
Link: http://www.relevantive.de/linux

Linux Usability Report 2003
Technical lead and co-author of the Linux Usability Study in 2003. Configuration of the testing environment, conceptiual design, project management.
Link: http://www.relevantive.de/Linux-Usabilitystudy_e.html

TOP


Data Warehousing

Data warehouse and business Intelligence on Oracle at ImmobilienScout GmbH
Developing PL/SQL Stored Procedures for ETL processing.
Schema design, performance optimizations of Oracle 8i and 9i. Business intelligence with Microstrategy. Evaluation of Open Source strategies for the data warehouse, introduction of JasperReport for a hoc reporting. Introduction of a documentation wiki (MediaWiki) for the software development unit.
Link: http://www.immobilienscout24.de

TOP


System Administration Linux/UNIX

Solaris Administration, Social Science Research Center Berlin, Library
Administrating a SUN Enterprise 450 running Solaris 2.6. Upgrade to v.8. Maintaining the Apache webserver, the databases (BRS, Informix) and the applications.
Link: http://bibliothek.wz-berlin.de

Web hosting, Linux administration
Hosting and administrating of several domains. Installation, adaptation and administration of web applications (e.g. blogs, CMS, wikis)

TOP


Informix: Database administration and development

Informix DBA, Social Science Research Center Berlin, Library
Informix database management, Informix 4GL application development.
Link: http://bibliothek.wz-berlin.de

TOP


Implementing database-backed applications

User management with MySQL, Social Science Research Center Berlin
Implementing a MySQL based user authentication with pam_mysql and libnss_mysql. Programming (C), integration, documentation, patching.
Link: http://www.weltraumsofa.de/pamnssmysql.php

TOP


Open Source Advocacy

Linux in Ethiopia
„Linux Advocacy“ trip to Addis Abeba, presenting Open Source opportunities for developing countries. Presentations, talks, networking.
Link: http://www.relevantive.de/ethiopia

Linux New Media Award
Member of the jury in 2003 - 2006.
Link: http://www.linuxnewmedia.de/Award_2004

TOP



Languages