Projects

Built, not just recommended.

14 projects from our own products and engagements, each with situation, solution and an honest status. We do not name clients or holdings; we are happy to share details in conversation.

Architecture

Operations at a listed company

Situation
A listed media company with a system landscape that grew over time and an interface between holding and operating company.
Solution
Operations leadership focused on system architecture and governance. Automation where it removes routine work; responsibilities and reporting lines put in order.
Status
External leadership role, working with management and teams.
Systemarchitektur · Governance · Automatisierung
Architecture

Agent architecture with allow-list and approval

Situation
AI agents are to write code, run tests and analyse data on their own, without access to production or credentials.
Solution
Own control server with an allow-list, jobs with checksums, separate execution, network lock for analysis jobs, tests in throwaway copies.
Status
In operation: agents work through jobs overnight; changes are merged after review and approval.
Python · MCP · systemd · git · Linux-Firewall
Read the case study (German)
Data and monitoring

Financial data from mandatory filings

Situation
Key figures for thousands of European issuers, without an expensive data licence and with traceable sources.
Solution
Ingesting regulatory XBRL filings, reconciling two sources, provenance per field, a quality gate before every publication.
Status
First sector report finished as a PDF, typeset automatically and checked against the calculation logic; further sectors in progress.
Python · XBRL/ESEF · SQL · PDF-Rendering
Data and monitoring

Traceable portfolio monitoring

Situation
Assessment of securities portfolios that can be explained and checked at any time.
Solution
Rule-based, deterministic scoring across five pillars, a confidence score per security, a review queue for human oversight, a log of every run, external timestamps.
Status
Web application with PDF export; also a research artefact on algorithmic accountability.
Python · Web-App · PDF · Zeitstempeldienst
Processes

Tender radar with bid preparation

Situation
Public tenders in the German-speaking region are scattered and hard to monitor continuously.
Solution
Weekly retrieval, scoring against our own profile with exclusion criteria, extraction of deadline and contract value, first stage of automated bid preparation.
Status
Summary by email every Monday.
Python · Scoring · systemd-Timer · Tests
Programming

Automated review of indexation clauses

Situation
Index-linked price adjustments in contracts are often forgotten or miscalculated, costing revenue year after year.
Solution
Reading clause parameters from the contract text, calculating against the official consumer price index, showing missed adjustments.
Status
Web application with a report per contract, in trial.
TypeScript · Textextraktion · Indexdaten
Architecture

A single schema for scattered market data

Situation
Price and tariff data sit in many formats with many sources and cannot be built into products as they are.
Solution
Normalisation into a common schema, delivered through an API that customers embed in their own products.
Status
Data product with paying customers.
API · Datennormalisierung · Schema-Design
Processes

Bookkeeping reconciliation against the ERP

Situation
Annual accounts for several companies, bank accounts and receipts that do not match.
Solution
Reconciliation scripts via the ERP interface; every script runs as an analysis first and only books afterwards. Every correction is documented.
Status
Accounts prepared, four banks connected.
Python · Odoo-API · Trockenlauf/scharf
Programming

Google Sheets add-on

Situation
Cleaning data in spreadsheets takes hours and is error-prone.
Solution
Add-on for catching error values, cleaning data and exporting to calendars; processing stays within the Workspace environment.
Status
Published in the Google Workspace Marketplace.
Google Apps Script · Workspace Add-on
Data and monitoring

Scientific data catalogue from mission data

Situation
Raw data from a space mission spread across large tables, without a citable form.
Solution
Pipeline with model fitting, cross-matching with external catalogues and quality flags; 128,885 objects, 162 attributes.
Status
Published with a DOI; journal article under review.
Python · große Tabellendaten · DOI
Data and monitoring

Monitoring public announcements

Situation
Municipal decisions and zoning changes appear scattered and without notification.
Solution
Automatic retrieval, analysis of new zoning decisions and resolutions, screening by district.
Status
Recurring report as a basis for decisions.
Python · Web-Scraping · Berichte
Architecture

Server operations and alerting

Situation
Several applications on our own servers, grown over time, with silent failures and false alarms.
Solution
Services under systemd with dedicated users, firewall open only where needed, checks every five minutes, alerts only after a confirmed failure.
Status
In operation; alerts reach the people who read them.
Linux · systemd · nftables · nginx
Data and monitoring

Market analysis from software marketplaces

Situation
Product decisions need figures on demand, prices and gaps, not gut feeling.
Solution
Automated analysis of marketplaces for software extensions and automation building blocks, isolated on our own server.
Status
Basis for choosing new products.
Python · Scraping · Analyse
Programming

Interactive visualisation in the browser

Situation
A physics thought experiment that is hard to convey in words.
Solution
Web application with three interactive views, rendered smoothly in the browser, without server logic.
Status
Finished web application, deployable on its own.
TypeScript · React · Vite · Canvas 2D

Which process costs you the most time?

Send us two or three sentences about it. In a first call, 30 minutes and without obligation, we work out whether and how it can be solved; a fixed-price proposal follows within a week.

Book a first call vienna@esox-media.com