PostgreSQL Experts in Germany

Reporting and controlling with Power BI for a productive ERP system

• Analysis of ERP data and interfaces for use in Power BI dashboards
• Evaluation and migration of existing reports (e.g. Excel) to Power BI
• Development of an access rights concept for selective data access
• Documentation and training on how to use and adapt the Power BI dashboards

Label: Power BI, Excel, SelectLine ERP, Microsoft SQL, SQL Server Management Studio

• AI product development: Design of an AI-supported GRC platform to automate compliance processes.
• AI expertise: Strategic deepening in Agentic AI and GenAI as a core asset for modern IT governance
• IT interim management and strategic consulting

• Building a scalable nearshore IT developer hub (Croatia, Czech Republic, Poland) as an independent company using a BOT model (Build – Operate – Transfer)
• Identifying, selecting, and managing full-service agencies; introducing governance and control mechanisms including KPIs, SLAs, and regular service reviews
• Creating and reviewing data processing agreements and framework contracts in coordination with Legal & Compliance; integrating regulatory requirements (including KRITIS) into process design
• Advising on cloud-vs.-on-premise strategies, data storage, and authorization concepts; supporting procurement with tendering and vendor evaluations
• Change management and process harmonization between internal teams and nearshore partners; reporting to management board, CFO, and CIO

Result: Scalable IT developer hub with an audit-proof governance model, lower operating costs, and faster product development.

• Development of a production-ready Enterprise AI solution for the automated processing of invoices and business documents
• Integration of Azure AI Document Intelligence and LLM technologies into existing business processes
• Development of robust REST APIs for automated document processing and system integration
• Extraction, validation, and storage of structured invoice data in Azure SQL as a base for analytics and machine learning models
• Development of an AI-based recommendation engine with machine learning and deep learning to generate personalized product recommendations based on historical purchase data
• Implementation of logging, monitoring, error handling, and validation mechanisms for stable production use
• Collaboration with business teams to define business rules and integrate the solution into existing enterprise processes

Technologies: Python, Azure AI Document Intelligence, Azure OpenAI, Azure SQL Database, REST APIs, Machine Learning, Deep Learning, OCR, Pandas, JSON, Workflow Automation

• Proactive support of management in business field development & innovation management

• New development of a suite of business applications for analyzing valuation, P&L, and market price risk data

• Automation of all internal and external business and work processes

• Development of AI-based and AI-supported ETL processes as well as data analysis

• Business use-case development

• Business and work process optimization

• Enterprise architecture management

• Sales data analysis and forecasting as well as capture

• Inventory management & reordering

• Supplier management and communication

• Customs processing & clearance

• Shipping handling & warehouse coordination

• Interface management

• Technologies used: Microsoft Office 365, Microsoft Teams, JTL-Wawi, JTL-WMS, OTTO Partner Connect (OPC), Amazon Seller Central, DHL Global Forwarding, Jira, Draw.IO, Java (8,17,21,25), Jenkins, SonarQube, Git, Gitea, Spring Boot, Spring Batch, Vaadin, H2, PostgreSQL, Docker, Local LLMs, Postman, JasperSoft Studio, JasperReports

Product:

• Built a production-ready AI platform for generating brand-aware marketing images and videos from product data, user requirements, and uploaded media.
• Own the platform architecture, technical roadmap, API design, security, deployment workflow, operational reliability, and model-provider strategy.
• Developed the core platform in .NET and built supporting AI and workflow prototypes in Python, applying language-independent API contracts and structured interfaces between services and model providers.
• Implemented reliable background processing with RabbitMQ, persisted workflow state, idempotent handling, retries, failure recovery, logging, secure storage, authorization, and credit accounting.
• Made pragmatic build-versus-buy and model-routing decisions based on reliability, latency, cost, and maintainability rather than novelty.

Agent Orchestration & RAG Systems

• Built and compared agent workflows using Microsoft Agent Framework, LangGraph, and LangChain, including tool use, conditional routing, clarification steps, state management, and hand-offs between agents.
• Implemented reusable .NET components for agents, prompts, tools, model providers, structured responses, and retrieval with pyvector, making it easier to change AI providers without rewriting the core workflow.

Developed a CPU monitoring application using Spring Boot and React, containerized with Docker Compose, with automated infrastructure provisioning using Terraform on AWS.

Stack: Spring Boot, React, PostgreSQL, REST API, Docker Compose, Terraform, AWS

AI telephone assistant platform

Claude Code, Google AI Studio, Python, LLM / Voice-AI, PostgreSQL

• Conception and hands-on development of an AI-supported telephone assistant platform (voice AI / LLM) – from idea and architecture to MVP/product.
• Built agentic workflows and full automations with Claude Code and Google AI Studio.
• Also delivered AI-supported work in client engagements: used Claude Code for governance documentation, requirement drafts, and automations.

• Task Engineering: Evaluating Coding Agents.
• Asset Creation: Building realistic task environments using datasets and files in German. Crucially, these assets must remain in the target language to genuinely measure multilingual handling.
• Prompting & Translation: finding failure points where AI does not work, in German.
• Implementation & Verification: Supporting the development of robust solutions (reference implementations) and write highly reliable, deterministic verifier scripts (using rubric-based judging only when strictly necessary).
• Calibration & Execution: Analyze execution logs and calibrate task difficulty (Easy to Very Hard) using standard Terminal-Bench run configurations against various model tiers (Haiku, Opus).
• Quality Assurance: Participation in a rigorous, 4-layer human quality control process (creation, human review, calibration review, and audit) alongside automated LLM-based checks to ensure fairness, grammatical accuracy, and benchmark integrity.
• Linguistic Review: Reviewing AI benchmark tasks across Hindi, Arabic, Japanese, Chinese, Czech and Turkish.

• A recurring problem in my own AI-supported projects: requirements analysis, use cases, and architecture decisions can be created quickly with AI support, but they remain hard to trace and scattered across Markdown files – knowledge is lost as soon as it is no longer in the context window. arknet turns requirements engineering and architecture knowledge into structured, verifiable data instead of plain text: requirements, use cases, and architecture decisions as a continuously linked knowledge graph, traceable from the requirement to the architecture decision – queryable for both people and AI agents alike. Technically based on RDF/OWL and its own MCP server.

• Result: MCP daemon running, Docker image automatically published on GHCR, nine hexagonal modules, eleven ADRs (including an open-core licensing model). Requirements engineering and ubiquitous language hexagon active. Publicly available since 07/2026 as a Community Edition under Apache-2.0 (github.com/kogn-io/arknet), together with the Claude Code plugin and the GHCR image; open-core model.

• Label: Java, Maven, RDF, RDF4J, OWL, SPARQL, Model Context Protocol, Spring AI, Docker, GitHub, Git, Claude Code, Obsidian, DDD, Hexagonal Architecture, ArchUnit, JUnit, AssertJ

Most mid-sized companies already have their numbers. What is missing is the translation: a dashboard with forty tiles does not answer a single question that is actually asked in management.

Analysis

• Evaluation of existing data with Python and SQL
• Checking data quality and methodology before making a statement
• The result is an analysis that leads toward a concrete decision

Preparation

• Reports in Power BI and Tableau
• Interactive calculators and visualizations on the web
• Presentations and specialist texts for customers, sales and the public
• Analysis and communication from one source — that

• Analysis of the existing CAN communication between microcontrollers
• Analysis of the sensors used and the measured values collected
• Planning the CAN messages for transmitting the measured values
• Iterative adjustment of the microcontroller code to the new CAN messages
• Cross-compilation from x64 to arm64

• Optimizing and accelera­tion of our Gitlab CI pipeline

• Conceptual work for the PoC of the Zero Trust system

• Extension of the policy-engine backend in Go

• Extension of the policy-testing mechanism in Python

• Architectural design of the PEP component of Zero Trust

• Documentation of the product

• Technologies: Zero Trust, Go, Python, Gitlab CI, Docker, JWT, Domain-Driven Design

• Further development of the existing e-commerce platform based on SAP Commerce (Hybris) to meet the growing demands of digital commerce.
• Ensuring the scalability and performance of the backend, so the platform remained stable and efficient even under heavy user load.
• Development and integration of new OCC REST APIs and services for modular extensions and flexible adjustments, to implement new features quickly.
• Optimization of data flows and interfaces, which significantly improved platform efficiency and system performance.
• Ensuring a maintainable and scalable code base by using Clean Code principles, proven design patterns, and a future-proof architecture.
• Reduction of errors through extensive testing with JUnit, Mockito, and load tests with Gatling, supported by the introduction of automated test processes.
• Improved system performance through targeted refactoring measures and efficient database queries, especially to handle peak loads.
• Use of modern cloud and monitoring tools such as Kubernetes, Google Cloud Platform (GCP), and Grafana to ensure a stable and monitored infrastructure.
• Clear improvement in efficiency, scalability, and reliability of the platform, which now meets the demands of a dynamic and growing e-commerce market.