Skip to content
OrtmannConsulting

Projects

Projects that made it into production

Each one with the situation, the approach and a number. I delivered them in an employed role for internal departments — not under external consulting contracts. The organisations are not named; the numbers are real.

Filter by field

Group customer service, construction chemicals

2026
11Countries on one platform

One contact centre for eleven countries — one platform, not eleven islands

Customer service across eleven countries over voice and SMS, with data from SAP, Salesforce and the product system surfaced directly in the agent workspace. Country differences are configuration, not separate installations.

  • Twilio Flex
  • Twilio TaskRouter
  • Twilio Studio
  • SAP

Group compliance, construction chemicals

2026
10,872Documents generated

10,872 EU declarations of conformity, not copy-paste

New EU packaging regulation required declarations of conformity in 12 languages for around 900 packaging materials. Instead of filling them in one by one, a pipeline generates and files them in a single run.

  • Python
  • docxtpl / Jinja2
  • Microsoft Word COM
  • Microsoft Graph API

Customer service, construction chemicals

2026
114 → 18Widgets in the call flow

From a 114-widget phone menu to a voice assistant

Callers say what they need in their own words instead of tapping through three menu levels. The language model is never allowed to name a destination — it picks from a list, and the phone system dials.

  • TypeScript / Node.js
  • Azure OpenAI
  • Twilio ConversationRelay
  • Azure App Service

Sales & inside sales, construction chemicals

2026
1 + 3Orchestrator and specialist agents

One orchestrator, three specialist agents for product questions

Instead of one agent with three knowledge sources, a parent agent routes to three specialists — one each for ERP article data, product content and SharePoint documents.

  • Microsoft Copilot Studio
  • Azure AI Search
  • Azure Functions
  • SharePoint

IT operations, building materials

2026
1Working session

One afternoon, one AI agent, one mail server with no expert left

The administrator who knew the Postfix server had left the company. Instead of buying that expertise back in, the IT team learned to approach the system themselves with an AI agent.

  • Ubuntu
  • Postfix
  • AI agent with shell access

Supply chain, construction chemicals

2026
~334,000Documents in the search index

Stock, replenishment and documents per article on one page

Around 334,000 article documents from the data warehouse and the product information system, rebuilt daily. Stock is derived from the movement log rather than the ready-made inventory view — which never reports a zero balance.

  • Python
  • Azure AI Search
  • Azure Functions
  • Databricks SQL

Cloud governance, building materials

2026
9Connected data sources

Cloud costs by owner, not by resource ID

A portal shows what cloud usage actually costs, broken down by the people and projects responsible. Shared resources are deliberately not charged to one project, even though that makes the savings look smaller.

  • Python / Flask
  • Azure Cost Management API
  • Azure Resource Graph
  • Azure SQL

Service desk, construction chemicals

2026
4 → 1Source systems on one screen

Four systems, one screen — correcting contact data during the call

The agent sees who is calling, assembled from four systems. Corrections sit as an overlay on top, without anything being changed in SAP or Salesforce.

  • Python / Flask
  • Azure SQL
  • Databricks SQL
  • HubSpot API

Group IT, building materials

2026
4 yearsGrown in production

Four years of an IT admin portal — one form instead of five consoles

Leaver processing, password resets, licence cleanup and phone numbers run through one internal portal rather than several Microsoft consoles. The job queue is a table in the database that was already there.

  • Python / Flask
  • Microsoft Graph API
  • Azure SQL
  • Azure Functions

Sales & customer service, construction chemicals

2026
81Columns in the largest export layout

Customer article lists — without a second, customer-safe index

Customers assemble their own article lists and export them with the product data their systems need. Stock, prices and internal figures live in the same index — the separation is enforced by a server-side allow-list.

  • Python / Flask
  • Azure AI Search
  • Azure SQL
  • Databricks SQL

Service desk IT, building materials

2025
0Automatic reconnects during a call

Turning a browser tab into a contact centre desktop application

Calls ring audibly and come to the front, the headset button works, and the connection repairs itself — with exactly one thing it deliberately never does, namely reconnect during a live call.

  • Electron
  • JavaScript
  • Twilio Flex SDK
  • Jabra SDK

Telephony administration, building materials

2026
hourlyAutomatic synchronisation

Call queue overview as self-service for department heads

Department heads see for themselves how their call flow is configured and who is currently available, instead of having to ask someone. The data model was built generically even though only one menu tree was known.

  • Python / Flask
  • PowerShell
  • Microsoft Teams
  • Microsoft Graph

Sales / CRM, construction chemicals

2026
0Writes to the CRM

Researching missing address data in CRM leads automatically

Without a postcode and town, an enquiry cannot be assigned to a sales territory. The system reads the address from the company website's legal notice — and deliberately writes nothing back to the CRM.

  • Python
  • Salesforce API
  • Claude API
  • httpx / BeautifulSoup

IT licence management, building materials

2026
47Fields joined per licence holder

Finding unused AI licences — without revoking them automatically

A weekly report sorts every licence holder into keep, coach, reclaim or review. Someone who does not use Copilot but is otherwise active counts as a training problem, not a cost problem.

  • Python
  • Azure Functions
  • Microsoft Graph API
  • Azure Blob Storage

Cloud operations, building materials

2026
8 → 1Portals in one weekly email

Eight admin portals in one weekly email

Expiring certificates, planned maintenance and retirement notices are scattered across eight portals. A weekly report bundles them — and ownership deliberately comes from a maintained file rather than the directory.

  • Python
  • Azure Functions
  • Microsoft Graph
  • Azure Resource Graph