Services

Modernisation of existing applications

Code review, refactoring, reverse engineering and modularisation of grown VBA, Excel, Access and PowerShell applications, together with documentation your team can rely on.

The usual starting point is an assessment: what carries on, what gets replaced, what stays. The result is a prioritised recommendation with effort and benefit for each measure.

Software architecture

Structures built to last rather than quick one-off solutions: clear layers, separation of data and evaluation, configurable rather than hard-wired processes, reusable modules.

This is what allows an application to be run and adapted in house without a developer once the project ends. Where useful, binding coding guidelines are produced for your team.

Automation

Recurring processes in Excel, Access, SharePoint and system administration. Interfaces to ERP, SAP BW via SAP BO, ODBC, REST, CSV and XML.

Reporting and data warehousing

From the single evaluation through to automated loading into PostgreSQL or MS SQL, including stored procedures, views and safeguarding of data quality.

Fifteen years in general management taught me what a report is ultimately needed for. So we talk about which indicators matter just as much as about the technology.

E-invoicing in existing applications

Since January 2025 every company in Germany must be able to receive electronic invoices in business transactions, with the obligation to send them following in stages.

Many legacy applications cannot do this, and the original vendor no longer develops them. I assess whether retrofitting or replacement is more economical and implement it. An XRechnung tool for Access is in use, an ERP tool with integrated e-invoicing is in development.

Quality assurance

Test automation with Pester, BDD, unit, integration and system tests, complemented by smoke, functional and regression tests. Version control with Git and GitHub.

AI-assisted code analysis

In current engagements I use Claude and GitHub Copilot productively to analyse and modernise large, historically grown code bases. This mainly shortens the phase that otherwise consists of reading and understanding alone.

Training and knowledge transfer

Onboarding and training of teams, remote and on site, in German, English or French. Enabling business departments and fellow developers to work independently in the Access environment, including the transfer of my own coding and architecture standards.