Projects
Current engagements
Public-sector IT service provider, critical infrastructure
Since 02/2024 · public sector, 1,000 to 5,000 employees · client name on request
Support of client administration for around 17,000 workstations through application development and automation. Development of an MECM provisioning tool for single and bulk records via CSV. Code review and reverse engineering of existing scripts, supported by Claude and GitHub Copilot. Build-up of test automation with Pester.
Outcome: Ten previously manual procedures turned into configurable standard processes for around 50 users. Administrative effort fell by around 90 per cent.
WinTourS AG
Since 11/2023 · software for tour operators, 10 to 50 employees
Ongoing adaptation of the application and its reports on a complete ERP system with more than 100 users and over 100 objects. Modularisation to clean-code principles, analysed with AI support.
Outcome: New reports are produced considerably faster, existing ones can be adapted without touching the application logic.
E-invoicing in existing applications
Ongoing · various clients
Implementation of the German e-invoicing obligation inside existing Access applications, independently of the original vendor. An XRechnung tool is in use, an ERP tool with integrated e-invoicing is in development.
Completed projects
Winkler AG
09/2024 – 12/2024 · wholesale of truck parts, 500 to 1,000 employees
Application for automated access to online catalogues, in use by around 50 users across several locations. Settings and credentials managed via INI files so the business department can work without a developer.
Outcome: Five separately maintained scripts were consolidated into one configuration-driven launcher; maintenance effort fell by around 80 per cent.
Stadtwerke Güstrow
06/2023 – 12/2024 · energy and utilities, 250 to 500 employees
Full absorption costing across around 400 cost centres in seven divisions, including the tools and the documentation.
Outcome: Hourly rates can be recalculated in house at any time on the basis of the complete management accounts.
AVJS
02/2021 – 03/2024 · staffing services, 500 to 1,000 employees
Advising the management on the build-up of a data warehouse. Excel add-in for the standardised filing of ERP evaluations, table structure, stored procedures and views, migration from Firebird SQL to PostgreSQL, accompanying training.
Outcome: 20 report objects from 30 branch offices converge in a central data warehouse. Reporting time fell by around 80 per cent.
Edeka, Minden
11/2012 – 12/2023 · food retail
Eleven years of continuous development of two databases for around 15 users. Migration and refactoring, user-oriented menu control, automated import from SAP, menu-driven reporting.
Outcome: Considerably simpler handling in daily operations, and the business department can make most adjustments itself.
DB Systel
11/2019 – 12/2023 · IT subsidiary of Deutsche Bahn
Workforce planning tool in Excel with Cognos TM1 as the back end, around 50 users, five instances. Watchdog, backup and system checks via PowerShell, consistent logging as the basis for monitoring, coding guidelines including software architecture.
Outcome: Incidents involving an abort and subsequent recovery fell from several per month to roughly one per quarter.
Deutscher Fachverlag
12/2020 – 07/2023 · media and publishing, 50 to 250 employees
Migration of 20 Access databases from a wide range of versions to Microsoft 365 in 64 bit, each measure decided on a cost-benefit basis.
Outcome: The template database developed here has since served as the blueprint for all further conversions in house.
JC NewRetail
06/2022 – 08/2022 · holding company of the Peek & Cloppenburg group
Central SharePoint Online portal with 30 site collections for fashion retail, including a role-based permission concept rolled out via PowerShell.
Aldi Süd, via Capgemini
08/2017 – 05/2020 · food retail
Lead developer of three Excel planning solutions comprising four tools, accompanying an S/4HANA implementation, connected to SAP BW via SAP BO. Coding guidelines and facilitated requirements workshops with the business side.
Deutsche Bank, Frankfurt
03/2014 – 06/2018 · banking
Central database serving as the back end that automatically administers the lists of ten SharePoint sites. Four years as co-user-admin of several site collections, security and user concepts, agile development in a team of ten distributed internationally.
Further projects
Unilever in Hamburg and Stockholm, pbb Deutsche Pfandbriefbank in Munich, Cologne Tourism, a fulfilment provider with a REST connection to a parcel carrier, a document generator for contract texts in the insurance sector, and a parts database for an automotive manufacturer.
The complete project profile is available as a PDF download.