Selected case studies

MES / .NET 8 / AI / ERP

MES system with an AI cascade

A free-text order description from the ERP is turned into production data and a realistic delivery date. A cascade of six layers combines rules, a memory of approved resolutions, a local model, and a language model invoked only conditionally.

99%

local model accuracy

6

cascade layers

532

automated tests

.NET 8 · Blazor Server · C# · SQL Server 2022 · EF Core · Dapper · ML.NET · Domain SSO · LLM API

MICROSOFT 365 / .NET 10 / DATA PROTECTION

Evidence mail finder in Microsoft 365

Accounting needed the e-mail where the terms with a customer were agreed, and it sat in one of dozens of sales mailboxes. I built an application that points to the mailbox, date, subject and folder, and cannot show the message body because it has no permission to read it.

0

message-body fields in the database

4

fields reach the screen

1250

automated tests before every change

.NET 10 · Blazor · C# · Microsoft Graph · Exchange Online · SQL Server · IIS · Active Directory · domain SSO

ERP / DOCUMENT AUTOMATION / .NET

Export invoice specifications published automatically from the ERP

Every export invoice needs a printed specification. It used to be prepared and located by hand, and the PDFs bloated the ERP database. Today a background process generates it, and the link stored in the invoice does not change after a correction.

0

PDF files in the ERP database

1

permanent link per invoice, whatever the corrections

5

panel iterations with no downtime

.NET Framework 4.7.2 · .NET 10 · Blazor · C# · SQL Server · IIS · Windows Authentication · gMSA · Windows Task Scheduler · PowerShell 5.1 · Ghostscript

BUSINESS APPLICATION / INTEGRATIONS / DATA

Business intelligence and counterparty risk assessment platform

Counterparty data was scattered across registers, financial statements and paid APIs. I built a single application that combines registry and financial data, calculates indicators, shows relationships and monitors changes.

5

data sources in one card

6

architecture layers

24h

data refresh cycle

.NET · SQL Server · API integrations · XML/XSD · on-premise

ERP / SQL SERVER / AUTOMATION

Transport document automation for ERP invoices

Files from the carrier landed in a network folder and users searched for them manually. The integration cyclically matches each document to the right invoice in the ERP, archives the file and makes it available in one click.

SQL Server · T-SQL · scheduled jobs · PowerShell · transactional e-mail · lightweight HTTP service

ERP / .NET 8 / API / LOGISTICS

ERP integration platform for carrier APIs

A .NET 8 platform cyclically communicates with logistics operators' APIs, downloads shipping labels, matches them to sales documents and saves them in the ERP through the vendor's official API. Differences between carriers are isolated in adapters.

449

automated tests

2

carriers, carrier-agnostic core

.NET 8 · C# · Blazor Server · SQL Server · SOAP/API · ERP API · background services · domain authentication · retry / circuit breaker

SQL SERVER / PERFORMANCE / ERP

Optimizing a production database with no downtime risk

A production SQL Server database needed performance changes, but the environment tolerated no downtime and no experiments. Every change goes through measurement, proof, approval and a controlled deployment.

SQL Server 2022 · T-SQL · ERP · monitoring · change control