Fachlicher Schwerpunkt dieses Freiberuflers
Consulting, Project Management, Databases (Access, mySQL), Software-Developement, Web, PHP, Training, Administration4
D0
D1
D2
D3
D4
D5
D6
D7
D8
D9
Austria
Switzerland
All others
Deutschland: Schwerpunkt Rhein-Main-Gebiet
Position
Project History
Below is a selection of some of my projects. Since most of these projects were supervised by me for several years in varying intensity, they sometimes overlap.
10/2014 - today
Auditor for IT system security at various medium-sized enterprises
As an auditor it's my mission to analyze, evaluate and optimize the complex interplay between business processes and IT systems as well as a company’s internal control system. I take a close look at IT systems relevant to financial reporting in terms of not just their proper operation for the purposes of annual financial statements, but their compliance with requirements of law. I discover weak points, evaluate risks to the clients company and thus ensure that the IT system is both safer and more reliably available.
6/2014 - 9/2014
Interim team-manager in a DAX company (Pharma)
Teamleader of the File & Print Team, implementation of JIRA, employee management, monitoring migrations and outsourcing projects, goal tracking in the PMP framework
2/2014 - 5/2014
Operations Manager in Software Development Project
Design, implementation and documentation of failure- and stress tests of servers, firewalls, load balancers and data center throughput for an international IT software project before delivery to the customer. Impementation and extension of monitoring tools based on Nagios / Icinga, implementation and support of a ticket system based on OTRS, introducing a knowledge base based on XWiki and statistical tools such as Jarmon. Documentation of the SOP (Standard Operating Procedures) for upcoming handover of server operation to the client.
01/2014 - 02/2014
Auditor for IT system security at various medium-sized enterprises
As an auditor it's my mission to analyze, evaluate and optimize the complex interplay between business processes and IT systems as well as a company’s internal control system. I take a close look at IT systems relevant to financial reporting in terms of not just their proper operation for the purposes of annual financial statements, but their compliance with requirements of law. I discover weak points, evaluate risks to the clients company and thus ensure that the IT system is both safer and more reliably available.
10/2013 - 12/2013
Project-Manager for a server migration project (Tourism)
Relocation of the website and IBE (Internet Booking Engine) based on Linux web servers for a travel agent to a new data center while optimizing the e-mail server and implementing of up-to-date of anti-spam and intrusion detection tools
- Planning, supervision and acceptance of new and reconstruction measures in collaboration with the architects commissioned, technical planners and electricians
- Project management for e.g.
- restructuring the network core with relocation of the main data center and renewal of the network hardware
- implementation of NAC
- Planning , installation and configuration of campus-wide WLAN infrastructure
- Implementation of Open Source network monitoring system NAGIOS with monitoring of switches , Linux and Windows servers, environmental parameters and more
- Implementation of Open Source helpdesk / ticket system OTRS
- Installation and tailoring of a knowledge management system based on MediaWiki
- Evaluation, installation and configuration of an asset database to manage servers, workstations, printers, switches, mobile devices and other hardware and software and their licenses
- Pilot project "iPad-4-Docs" (testdriving the useage of mobile devices in a clinical-enviroment with connections to KIS and PACS)
- Setup and configuration of VPN connections for mobile devices and external service Providers
- Planning and configuring the IP and vLAN structure
- Configuration of ASTARO and Palo Alto firewalls
- Installation, customization and extension of a virtual telephone system based on Asterisk and VoIP phones for a field office
- Adaptation and Extension of the Intranet-Service, based on Nexus Curator and Joomla
- Installation and administration of Windows and Linux servers - mainly in an VMware enviroment
- Support for the implementation of SAP and KIS medico
- Layout for the negotiation with potential service-Partners for Outsourcing of hardware-service and Output-Management
- Preparation of the hospital-wide migration from XP to Windows 7 and Office 2010 to 1500 devices
-
- Representing the hospital on IT-conferences with lectures for a 700+ audience (in English)
7/2010 - 02/ 2011
Server-Administrator in a marketing-Research company
Management of virtual and physical mail-, web-, proxy-, FTP- and application-servers for a leading international market research firm . Within the project, the decentralized data centers of different countries subsidiaries are consolidated in Germany for central management.
- Hardware installation of servers in the data center
- Installation of virtual servers on VMware ESX
- Installation of Linux operating systems from Redhat and Suse ( SLES and OpenSUSE )
- Adaptation to customer requirements as Web-/FTP-/Proxy-/Mail-/Applikations-Servers
- Establishment of Controlling-/Monitoringtools (eg Jazzey , Nagios , Scom etc.)
- Administration, evaluation, planning and implementation of updates and patches
- Documentation in SharePoint, Visio, among others MediaWiki
- Change management with HP Service Manager
- Design and planning for international migrations and contingency plans
- Troubleshooting , fault finding and elimination disorders
- Programming tools for administration purposes in PHP , Javascript and Perl
03/2010 - 6/2010
Migration XP -> Windows 7 and Office 2003 -> Office 2007
Migration of Windows XP clients to Windows 7, including migration from Microsoft Office 2003 to Microsoft Office 2007
• project plan with MS-Project
• Test of different hardware platforms with MS-ACT under 32/64 bit
• procurement and test replacesment systems where necessary
•Inventory and documentation of special applications/ macros / drivers
•Setting up a test environment for driver and application tests
•Image Creation with Microsoft Windows Automated Installation Kit AIK
•system testing
•Migration of user data with Microsoft User State Migration Tool USMT
•Rollout
•Adaptation of Office macros
•Documentation
•Transfer and training
12/2009 - 5/2010
Migration data center Microsoft Hyper-V / Exchange 2010
Migration of Exchange, Terminal Server, File Server, Print Server and SQL-server of a medium-sized company to a virtual server environment with Microsoft Server 2008 R2 Hyper-V
• project plan with MS-Project
• License management
• Hardware upgrade to 64-bit optimized systems / BIOS Upgrade
• Installation and configuration of Windows Server 2008 R2
• Extension of the domain in Active Directory by an additional domain controller
• Relocation of the Operations Master (FSMO) roles
• Backup the old systems (as files or ISO images)
• Establishment of virtual servers running Microsoft Server 2008
• Migration from Exchange 2003 to Exchange 2010
• Migration from MS-SQL Server 2005 on MS-SQL Server 2008
• system tests
• Documentation
• Transfer and Training
2006 -2007
Connectivity of field offices in Germany and abroad for IT infrastructure
For a pan-European internet-based tourism company, the local branches were connected to central databases for sales, reservation and KM along with an update of the communication Infrastruture.
• Project Plan with MS-Project
• Procurement of hardware and software
• Setting up Microsoft Terminal Server
• Expansion of the AGFEO-PBX to ISDN over IP virtual leased lines
• Establishment of remote workstations via Microsoft Remote Desktop
• Connecting the LAN via VPN
• Database replication of accounting information MS-SQL Server
• ODBC connectivity to central vacancy mySQL database
2007 - 2009
Setup of a data warehouse for Tourism / eCommerce
The data of the customer management, pricing and service records as well as the accounting were centralized, consolidated and structured and synchronized with the online e-commerce system for distribution, resource planning and accounting to optimize and facilitate data exchange with suppliers.
• Project Plan with MS-Project
• Migration from MS-Access and Excel databases and applications to MS-SQL Server 2003
• Programming of import filters for data content in XML, CSV and XL format
• Integration of e-commerce databases via ODBC
• Automated, bi-directional data synchronization for deals and vacancies
• Installing Backup Server
• Authorization Concept
• connection to call center CRM / ERP
• Statistical analysis of the data with MS-Access, MS Excel and Crystal Reports
1999 - 2010
Construction and maintenance of Internet discount travel agency
From the selection and purchase of the hardware to the design and programming of the CRM and the online booking engine (IBE) all the workflow was in my responsibility.
• Preparation of specifications
• Advice on the procurement of hardware and software
• Installation and configuration of Windows XP (local and Home Office) and Windows Vista (some in a virtual environment on Mac / Parallels)
• Installation, configuration and maintenance of Windows Server 2003, MS Exchange Server (with integrated Tobit DAVID for voice mail), MS SQL Server, MS Terminal Server, resource management and user permissions in Active Directory
• Web-based CMS Joomla with individual HTML / CSS templates and various extensions
• PHP (3.x/4.x / last 5.x) / HTML / Java Script IBE (Internet Booking Engine) real-time retail bookings, partly based on Zend Framework
• mySQL database under Apache / Linux
• XML interface to the reservation systems of various tour-operators
• Bi-directional ODBC connection to local CRM
• individual CRM based on MS Access / VBA and MS SQL server backend
• interfaces with Exchange, Outlook and Word
• CTI interface to AGFEO PBX / ISDN over IP
• Data import interface for XML and CSV
• Modular quotation tool via e-mail and fax
• Integrated TOMA Mask (Travel Industry Standard)
• point and click booking interface
• Customer data management with two level duplication warning
• payment tracking, dunning
• automatic printing of travel documents (cover letter / voucher / guide)
• Support for electronic franking tool (Stampit)
• integrated staff resource planning
• setup of home-office workstations
• Multi-screen setup (at least 3 screens per PC)
• Building a call center centralized / decentralized
• Coordination with external service providers (logistics, infrastructure, debt collection)
1997 - 2002
Construction and maintenance of web hosting provider
In a small internet provider, which was set up as many of today's well-known large providers didn't exist, I could completely immerse into the management of Sun and Linux webservers.
• Creation and maintenance of various webservers Linux (Redhat, Suse)
• Server maintenance with Parallels / Plesk, Webmin, Yast Others
• mail server setup, virus protection, Anti-spam (SpamAssassin, Greylisting, ...)
• Administration of Web, mail, FTP and database servers
• Application and maintenance for more than 100 domains
• Customer support
• Developement of a local CRM with MS Access / VBA
2002 - Present
Installation of various WebShops
For several customers I was involved in planning and realization of their own e-commerce solution. From a few dozens to several thousand articles all kinds of shops had to be created.
• Installation, configuration and customization of various e-commerce systems for car accessories, tuning, toys, services - B2C and B2B
• Programming of import filters / interfaces for data import from existing ERP systems
• Optimizing pages for search engines (SEO), online marketing
Used Systems:
• Caupo Shop
o Server setup
o Installation
o adaptation of templates
o Data conversion and import via XL Macros
• osCommerce
o Server setup
o installation of osCommerce
o adaptation of templates to the customer's CD
o extension addons by third party
o Programming of additional functionality to customer requirements
o connection to the customer's ERP system
o Programming of an import interface for consolidation, conversion and acquisition of large amounts of data based on MS-Access
May 2001/2002/2003
Mannheimer Maimarkt fair presence
For a booth at the largest fair in South-Germany with over 500,000 visitors, a representative exhibition appearance for a tour operator had to be realized
• Stand design with CAD system
• Design, tendering and contracting for advertising, printing products and lettering
• Coordination of exhibitions and Logistics
• Selection, training and motivation of the staff
• Planning and installation of communication infrastructure for telephony and Internet
• analysis and reporting
1997 - today
Programming of online tools, "Web 2.0"
For a very personal project I created some interactive tools - mostly based on PHP / mySQL
• FAQ database in PHP / mySQL with MS-Access front-end for easy data maintenance
• Online-encyclopedia/calendar in PHP with mySQL
• Interactive online Photo Tour
• graphical guestbook (dynamically generated images instead of text entries)
• creation and maintenance of an interactive Fan-portal
1997 - today
Creation, Maintenance & Care for Website [URL available on request]
In order to communicate my services and provide an extra service to my partners, I am using a website at [URL available on request] on dedicated webservers. During the long years it's existence, many techniques and tools were in use.
• Operating on a dedicated Linux server (Redhat / Suse)
• Administration of the (Apache) web, mail and database server
• Softwareinstalation, Anti-Spam (Spam Assassin, Greylisting)
• HTML / PHP / CSS / Java Script / mySQL
• Web page design with text editor, MS Frontpage, MS Expression Web and others
• migration between different servers and operating systems
• Resource database with dynamic graphical calendar with real-time-interface in PHP/mySQL
1997
Arcor Launch
Motivation and customer orientation seminars nationwide as an accompanying activity to the transition from DBKom to the newly formed Arcor Company.
• Paradigms
• Customer Orientation
• Conflict-free conversation
• Employee Motivation
• Team building
1995
Introduction of IBM POS Systems
Conversion to IBM POS systems and materials for a nation-wide retail chain with over 600 branches.
• Training of staff
• power-seminars for branch managers
1992 - 1995
Design and programming of a human resource database
For a large bank in Frankfurt, the administration of training activities for the employees 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
1995 - 2000
Author of several correspondence course instruction materials
For a large correspondence course institute, with whom I still collaborate regularly, I wrote several training materials
• Internet Basics
• Internet browser
• HTML
• Marketing / Sales
References
Projekt als Consultant und Interims-Co-Abteilungsleitung, 03/11 - dato
Referenz durch IT-Leiter, Klinikum, vom 25.07.13
"Der Consultant hat die ihm gestellten, teilweise sehr komplexen Aufgaben stets zu unserer vollsten Zufriedenheit erfüllt. Dabei hat er sich durch größte Flexibilität, absolute Zuverlässigkeit, Eigenständigkeit und hohes persönliches Engagement ausgezeichnet und neue Impulse eingebracht. Seine Arbeitsergebnisse hat er stets sehr umfangreich und nachvollziehbar dokumentiert, so dass unsere Abteilung nachhaltig davon profitiert. Die Integration in unser Team und die Zusammenarbeit mit dem Consultant waren in jeder Hinsicht tadellos und wir werden im Bedarfsfall jederzeit gerne wieder mit dem Consultant zusammenarbeiten. "
Projekt Move-IT, 07/10 - 02/11
Referenz durch Bereichsleiter Rechenzentrum, Marktforschungsunternehmen, vom 28.02.11
"[...] Der Consultant hat die ihm gestellten komplexen Aufgaben stets zu unserer vollsten Zufriedenheit erfüllt. Dabei hat er sich durch absolute Zuverlässigkeit, Eigenständigkeit und hohes Engagement ausgezeichnet. Seine Arbeitsergebnisse hat er stets sehr gut und effektiv dokumentiert, so dass das Team, in dem er tätig war, nachhaltig davon profitiert. Die Integration ins Team und die Zusammenarbeit mit dem Consultant waren in jeder Hinsicht tadellos. Unser Unternehmen würde im Bedarfsfall jederzeit wieder gerne mit dem Consultant zusammenarbeiten."
Projekt Dozententätigkeit in diversen Fernlehrgängen, 07/94 - 10/09
Referenz durch Leiterin Seminare/Prüfungen, Fernlehrinstitut, vom 19.10.09
"[...] In unseren institutsinternen Prüfungen wirkt er seit langem mit am Prüfungserfolg unserer Absolventen. Unsere Kunden erfahren durch ihn eine zielgerichtete Vorbereitung auf ihre Abschluss- und Zertifikatsprüfungen. Die fachlichen, pädagogischen und die sozialen Aspekte einer erwachsenengerechten Weiterbildung werden von dem Dozenten stets in hervorragender Weise berücksichtigt und didaktisch fundiert umgesetzt. Persönlich kann ich den Dozenten jederzeit für eine Tätigkeit in der Aus- und Weiterbildung empfehlen. Es gelingt ihm stets, unsere erwachsenen Lerner zu einer selbstgesteuerten und -bewussten Vorgehensweise zu animieren. Er ist ein Moderator, der schnell die Sprache seiner diversen Zielgruppen findet, sich sehr gut zurücknehmen kann und so der individuellen Entwicklung seiner Lerngruppen Raum zu geben vermag. Der Dozent ist ein überaus engagierter und versierter Trainer. Die Evaluierung unserer Veranstaltungen bestätigt täglich, dass dies von Kundenseite jederzeit so eingeschätzt wird. Ich bestätige gerne, dass der Dozent die an ihn gestellten Anforderungen stets zu meiner vollsten Zufriedenheit erfüllt und ich freue mich, wenn wir weiterhin so gut und vertrauensvoll zusammen arbeiten."
Projekt Personalentwicklungs-Datenbank / ERP + eCommerce u.a., 01/92 - 12/04
Referenz durch Geschäftsführer, IT-Dienstleister, vom 23.10.09
"[...] Durch seine kaufmännische Ausbildung, langjährige IT-Erfahrung und dem Talent auch komplizierte Sachverhalte verständlich und unterhaltsam zu vermitteln, erhielten wir stets ein sehr positives Feedback von unseren Kunden. Wir bestätigen dem Consultant gerne, dass er stets die auftragsbezogenen Anforderungen zu vollster Zufriedenheit erfüllt hat. Gerne werden wir auch in Zukunft auf die Dienste des Consultants zurückgreifen. [...] Mit seinen Leistungen war unser Auftraggeber vollstens zufrieden. Seine außerordentlich schnelle Auffassungsgabe und sein interdisziplinäres Denken und Handeln trug dabei entscheidend zum Erfolg dieses komplexen Projekts bei. [...] Der Consultant verfügt über ein sehr umfangreiches Wissen im Bereich Webserver-Administration, PHP, mySQL und allen Bereichen des Internets. Er hat das Projekt in allen Phasen von der Spezifikation über die Entwicklungs- und Testphase bis hin zur Inbetriebnahme begleitet. Die installierten bzw. entwickelten Module sind umfangreich dokumentiert, laufen fehlerfrei und performant. Die besondere Schwierigkeit der Integration in die vorhandene IT-Infrastruktur hat der Entwickler hervorragend gemeistert. Neben seiner fachlichen Qualifikation ist sein besonderes Engagement hervorzuheben. Wir möchten uns an dieser Stelle dafür bedanken und den Consulter anderen Projektanbietern weiterempfehlen. [...]"
Industries
tour operators
banks
financial services
IT
Event Management
Insurance
Industry
Sales
Airport
Authorities
Telecomunications
Fairs
Skills
Office solutions for data import and export
Workflow Optimization
Template Management
(Paul Watzlawick)
My "tool box":
Hardware:
=========
PC (construction, diagnosis, repair, upgrade, conversion)
Apple Macintosh
Network Infrastructure
Printers
Print Servers
Scanners
NAS Storage
Routers
WLAN
Smartphones (Symbian S60, Apple iPhone ...)
POS systems
Phone Systems
Windows Skills
==============
NT 4.0 Server
Windows SBS
Windows 2003 Server
Windows 2008 Server
Microsoft Exchange Server
Microsoft SQL Server
Microsoft Terminal Server
Microsoft IIS
Installation
Configuration
Maintenance
Installation of appropriate service packs and updates
Migration
Debugging
Windows 3.1
Windows 95
Windows 98
Windows ME
Windows 2000
Windows NT 4.0 client
Windows XP
Windows Vista
Windows 7
Installing Microsoft Windows Workstations in Networks on multiprocessor and RAID systems
Service Pack Installation
Installations of several additional applications and Admin-Tools
All Office applications (all versions) for example:
MS-Word,
MS Excel
MS-Access
MS Powerpoint
MS Frontpage
MS Expression Web
MS Outlook
MS Internet Explorer
Firefox
Safari
CorelDraw
Lotus AmiPro
Lotus 1-2-3
Lotus Freelance
Lotus Notes
Corel Draw
Corel PhotoPaint
Connection to the intranet and internet servers, routers and proxy servers
Installation of various backup solutions
Administration User Administration in one or more domains or ADSs under the consideration of the following topics:
RAS access and authorization
Network printer installation and access control
Planning and creating structures in networks and allocation of rights for groups and users
Terminal Server / Remote Desktop
Voice over IP / ISDN over IP
Active Directory Services
Software-Development:
=====================
Basic (various dialects)
VBA
Java / Java Script
Assembler
PHP
Objective-C
Internet / Intranet
=================
Apache Webserver
Parallels / Plesk / YAST / Webmin
html / xml / CSS
mySQL / Microsoft SQL Server
Content Management Systems CMS (Joomla, Typo3, Postnuke, etc.)
Webshops (Caupo, osCommerce and others)
e-Commerce
SEO Search Engine Optimization
Google Adwords Optimization
Internet Explorer
Firefox
Chrome
Safari
Consulting & Development Skills
Moderation of planning teams
project planning
Creating documentation and manuals
Creating requirement specifications
Basic hardware and software layout
Team leadership
consulting for customers and partners in listed topics
Soft-Skill-Seminars:
====================
How to get a good memory
Communication Training
Rhetoric on the phone
How to set goals and achieve them
Successful salesmanship
Customer Orientation
Team building
Presentation Techniques
Training History
IHK „Ausbildung der Ausbilder“
Einzelhandelskaufmann
Fachhochschulreife Wirtschaft, Verwaltung und Rechtspflege (~ vocational diploma in economy, administration and judicature)
Continuous training through seminars, conferences and workshops as with Anthony Robbins, Vera F. Birkenbihl, Dirk Treusch, Gregor Staub, Robert Bergman, Axel J. Bertling, Rolf H. Ruhleder, Carsten Maschmeyer, Monika Matschnig, Henry Maske, Bill Clinton, Dr. Bertrand Piccard and others
ITIL V3 Foundation Certified