SQLite Experts in Germany

AI Readiness - Part 3: Creating an e-book on the use of AI in software testing

• Designed and created an e-book on the sensible and safe use of AI in software testing from the perspective of an experienced test expert.
• Used generative AI (ChatGPT, Perplexity Pro) as a sparring partner for structuring, wording suggestions and creating variations, with all content finally reviewed and approved using my own expertise.
• Developed practical insights into the opportunities and risks of AI in testing, with a special focus on collaboration between testers and AI instead of “tester vs. AI”.
• Title: “11 starke Gründe: Dream-Team statt Rivalen - Tester und KI sind gemeinsam unschlagbar”
• Subtitle: “Wie Mensch und Maschine im Softwaretest das perfekte Team bilden – und warum reines KI-Testing riskant ist.”
• Planned use of the e-book as a basis for workshops, customer meetings or internal training.
• Technology: Generative AI, ChatGPT, Perplexity Pro, Microsoft Word, Adobe Acrobat, many years of hands-on professional testing experience, common sense.

• Development of scalable backend applications with C#/.NET and Java
• Design and implementation of distributed microservice architectures
• Development and integration of REST APIs for industrial applications
• Development of modern web applications with React, Angular, and TypeScript
• Implementation of MQTT-based communication solutions
• Integration of industrial protocols such as OPC UA and Modbus TCP
• Development of batch, process control, and HMI components
• Containerization and deployment of applications with Docker
• Conducting code reviews and supporting architecture decisions
• Close collaboration with Product Owners, QA, and interdisciplinary teams
• Analysis of business requirements and implementation of technical solutions
• Further development of existing software architectures with a focus on maintainability and performance

Technologies: C#, .NET, ASP.NET Core, Java, C++, React, Angular, TypeScript, Vue.JS, MQTT, OPC UA, Modbus TCP, Docker, GitLab, MariaDB, MySQL, Linux

• Taught ML, BI, and Big Data to Master's students.

Tech: Python, Power BI, SQL, ML, SnowflakeDB, databricks, MS Fabric, MongoDB, LLM

Reporting and controlling using Power BI for a production 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 authorization concept for selective data access
• Documentation and training on the use and customization of Power BI dashboards

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

Project: Defect Generation on Test-Bench Images of Metal Surfaces Environment: Automated Visual Inspection (AVI), Metallurgy & Manufacturing

• Objective & Implementation: Designed, architected, and trained Generative Adversarial Networks (Pix2PixHD / SPADE) for image-to-image transformation. Targeted generation of synthetic material defects (e.g., cracks, inclusions, scale) on rough metal surfaces under real test-bench lighting conditions for privacy-compliant and efficient dataset expansion (data augmentation).
• Technical Design: Implemented robust Generative AI and computer vision pipelines in Python and PyTorch. Used semantic segmentation approaches for mask-controlled defect synthesis and subsequent evaluation with EfficientDet object detection models.
• Business Impact: Massive dataset upscaling (10x) without time-consuming and costly physical test-bench runs, while significantly improving the detection performance of automated inspection systems.

Technologies & Skills Used: Python | PyTorch | SPADE | Pix2PixHD | EfficientDet | Machine Learning | Semantic Segmentation | Computer Vision

Maturing their API practices on both a business and technology level. My role covers strategy, architecture, developer advocacy as well as hands-on software engineering, enabling both technical teams and business leadership to adopt and act on API-centric principles effectively. Coincidentally, we also establish GitOps, DX and platform best practices with this project.

Highlights:

• Aligning executives with the initiative by clarifying strategy, replacing misconceptions and myths with facts, clarifying the value of existing assets and enabling informed decision-making
• Formulating a way forward for API Lifecycle Management at OTTO
• Driving platform progress and fostering developer engagement by hands-on engineering work towards strategic goals

API Lifecycle Management, Team Topologies, Organizational Evolution, Regulatory, Platform Advocate, Developer Platform, Communities of Practice, Terraform, Kotlin, Kafka, Kong, WSO2, Apigee, Gravitee, Backstage, AsyncAPI, OpenAPI, API Design, AWS, React, Node.js, TypeScript, Redocly, reactive programming, CDC, Golang, Gin, GitOps, DX (developer experience), stakeholder management, roadmaps, workshops, discovery.

• Consulting, design, analysis, software architecture and development
• Design, development and implementation of a Pimcore environment and connection of several external API systems in a Kubernetes environment, as well as various PIM and ERP systems
• Technologies: Unix environment, design, Symfony development, design, PHP 8+, software architecture, MySQL/SQL, Shell Script, Git Dev Ops tasks, AI coding assistance, Pimcore 12, Shopware 6
• Team size: >10 people

• 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

• Implementing and extending an Electron app based on TypeScript, React and Node.js to display stream content and technical data
• Extending a Kotlin backend for message processing via Kafka
• Extending various React modules
• Programming custom solutions for customers, including testing
• Creating documentation
• Development in accordance with Scrum processes

Used skills: React, React Hooks, Jest, Vitest, Typescript, Electron, IntelliJ, Vite, Github, Jira, Node.js, yarn, npm, pnpm, Swagger, OpenAPI, Storybook, Docker, Prettier, Eslint, tailwindcss, i18n, GraphQL, CoPilot, Postgres, JSON, Sqlite, trpc, influxdb, Java, Spring, Kotlin, Kafka, Git, Sonarcube

Gronic Ident & Sign

Core technologies: Android, Jetpack Compose, Retrofit, Regula Document Reader, Adobe Sign

Android app on dedicated devices for identifications and electronic signatures at the PoS

• Automated analysis of test script repositories using Python
• Set up a SQLite database for signal and value tracking
• Identified critical inconsistencies through ad hoc SQL queries
• Technologies: Python, SQLite, Excel/ODBC

• Fine-tuned and evaluated alternative backbone architectures for the AFFGAN handwriting style encoder to better capture writer-specific features, benchmarking against the original baseline architecture and replacing the legacy VGG19 architecture with a custom Transformer-based encoder.
• Extended the system beyond word-level synthesis to line-level handwriting generation, integrating and adapting an existing line-generation architecture to support full-sentence output.
• Deployed the handwriting generation pipeline as a web application, enabling users to select a writing style, input custom text, and instantly generate a corresponding handwriting image.
• Integrated TrOCR into a teacher–student distillation framework to evaluate and improve readability of generated handwriting, improving OCR accuracy by 20% over the baseline.
• Boosted user-study pick-rates by 40%, demonstrating a significant leap in the perceptual quality and realism of the generated handwriting compared to the baseline model.

Tech: PyTorch, Python, GANs, CNN, ViT, TrOCR, Streamlit, CUDA.

• SPA for automated communication of medical findings with role-based access (Sanctum)
• Server-side LLM integration (OpenRouter) with structured processing
• Automated sending via SMS/voice call (Twilio, ElevenLabs) with queue + status retry
• Full test coverage with 80+ documented test cases

Technologies: PHP, Laravel, LLM API (OpenRouter), Twilio, ElevenLabs, Laravel Sanctum, PHPUnit, Playwright, Docker, REST

• Adding/creating test specifications
• Performing regression tests
• Performing release tests
• Analyzing Jira tickets
• Identifying software defects and fixing them with C#