Projektbeispiele
Some of the projects I managed in the past (selection)
Design and maintenance of an Internet travel agency
From the conceptual design of the business model to the custom
programming of the CRM and the internet booking engine (IBE) I was
involved in all aspects of the business.
-
Preparation of specifications
-
PHP/HTML/Java-Script Frontend
-
mySQL database on Apache/Linux server
-
XML-interface to the reservation systems of various tour-operators
-
ODBC connection to local CRM
-
Individual CRM based on MS Access/VBA and MS SQL-Server backend
-
Interfaces to Exchange, Outlook, Excel and Word
-
CTI-interface to AGFEO telephone system / ISDN over IP
-
Data-import of tour-operator data in XML-, XL- or CSV-format
-
Semi-automatic bid proposal management via email and fax
-
Integrated TOMA-form for touristic bookings
-
Point & click user interface
-
Customer management
-
Payment tracking, dunning
-
Automatic printing of travel documents (cover letter / voucher /
travel-guide)
-
Support for electronic franking (Stampit)
-
Installation of Home-Office workstations via Remote Desktop / MS
Terminal-Server
-
Multi-screen systems (at least 3 screens per PC)
-
Installation of a call center (centralized / decentralized)
-
Coordination with external service providers (logistics,
infrastructure, debt collection)
Setup and maintenance of a Webhosting-Provider
During this project for a small internet web-space provider, founded as
many of today's well-known large providers didn’t even exist, I could
immerse myself into the management of Sun- and Linux web-servers.
-
Setup and maintenance of various Webserves (Sun, Redhat, Suse)
-
Server maintenance with Parallels / Plesk, Webmin, Yast and others
-
Mail-server administration, virus protection, Anti-SPAM (SpamAssassin,
Greylisting...)
-
Registration and care for over 100 domains
-
Customer-care and support
- Programming of a local CRM
with MS Access / VBA
Setup for several Web-Shops
For several clients I was involved in the planning and realization of
their own e-commerce solution – ranging from a few dozen to several
thousand items.
-
Installation, configuration and customization of various e-commerce
systems for car accessories, tuning, toys, services - B2C and B2B
-
Programming of import filters for data acquisition from existing ERP
systems
-
Optimizing pages/shops for search engines (SEO), online marketing
Programming of online tools, "Web 2.0"
For a personal project I programmed several interactive tools - mostly
based on PHP / mySQL
-
FAQ-database with PHP/mySQL with MS-Access front-end for easy data
maintenance
-
Online-encyclopaedia /calendar in PHP with mySQL
-
Interactive online Photo Tour
-
graphical guestbook (dynamically generated images instead of text
entries)
-
Setup and maintenance for an interactive fan-portal
Design and programming of a human resource database
For a large bank in Frankfurt, the
administration of training activities for the employees had to be
systematized and simplified. As a solution, a custom MS Access database
was programmed
-
Seminar Management
-
Resource planning
-
Trainer-Management
-
Participant Management
-
printing of lists of participants, spatial plans and certificates
-
cost control
- statistics
Migration to IBM POS Systems
Migration to an IBM POS and ERP-System for a nation-wide retail chain
with over 600 branches.
-
Intensive seminars for branch managers
Author of several correspondence course instruction materials
For a large correspondence course institute, with whom I still
collaborate regularly, I wrote several training materials
-
Computer Basics
-
Internet Basics
-
Internet browser
-
HTML
-
Marketing / Sales