T-SQL Experts

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide context-based business information.

Development of an AI agent with Function/Tool Calling for the secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Building automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and Service Principal, and integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

• Ride-sharing and bus platform, live and fully functional. Backend Spring Boot 4.1 on Java 21, PostgreSQL with Flyway, Testcontainers integration tests. Operation in my own AWS account (ECS Fargate, ALB, ECR, IAM least privilege) with CI/CD via GitHub Actions and OIDC federation without static credentials. Development throughout AI-assisted with Claude Code, including my own skills and project-specific memory. Spring Boot · Java 21 · PostgreSQL · Flyway · Docker · AWS ECS/ALB/ECR · CI/CD · GitHub Actions · Claude Code

I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.

I delivered following projects and engagements as a freelancer.

• Data Migration of CRM System for AL-FA Objekt Service Gmbh
• Microsoft Software Resales Partnership

I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer

Technical Focus Areas

• Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
• DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
• Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
• MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
• Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.

• Led enterprise reporting modernization by migrating legacy SSRS reporting solutions to Power BI, supporting 500+ business users while ensuring full GDPR/DSGVO compliance.
• Designed and optimized Power BI and Microsoft Fabric semantic models using star schema, dimensional modeling, advanced DAX, and performance optimization techniques, reducing query latency by 25%.
• Delivered 20+ executive and operational dashboards featuring KPI scorecards, drill-through, bookmarks, and row-level security, improving reporting efficiency by 20%.
• Enabled self-service analytics through governed Power BI datasets, dataflows, and gateway architecture, increasing business-led reporting adoption by 35%.
• Configured an incremental refresh policy and query folding for a 50+ million row sales dataset, reducing daily report refresh times by 85%.
• Deployed automated ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric, and Snowflake, reducing reporting delivery timelines by 40% through workflow automation.
• Spearheaded Microsoft Fabric analytics modernization initiatives including lakehouse architecture, OneLake integration, and centralized data platform development, reducing data latency from 2 hours to 20 minutes.
• Translated business requirements from 15+ stakeholders into scalable Power BI semantic models and dashboards, improving reporting consistency and reducing ad-hoc reporting requests by 25%.
• Applied Microsoft Copilot and generative AI tools to accelerate SQL development, DAX authoring, technical documentation, and testing activities, reducing development effort by approximately 15 hours per week.

Temporary employment

• System black-box integration tests (BBIT, IVVQ): Execution of regression, release, acceptance, and compliance tests for safety-critical brake control units in the rail industry
• Software test application & integration: Runtime configuration of software components and libraries, validation of interfaces, configuration dependencies, and component interactions
• Test automation (FEAT framework): Co-development and further development of an automated test framework for test execution, reporting, and result analysis
• Functional safety (SiL4, FuSi): Ensuring compliance with safety requirements, traceability and coverage, as well as standards compliance according to EN50126/28/29
• Test automation for communication components: Configuration and validation of fieldbus (CAN) and Ethernet-based TCMS data communication interfaces (TRDP and CIP)
• Requirements analysis & shift-left (PTC Windchill ALM): Analysis of software and system artifacts to identify gaps, ambiguities, and redundancies early in the SDLC
• Test design & test case development: Derivation of test conditions, coverage strategies, and implementation of data-driven test cases (DDT), including reusable test data fixtures
• CI/CD & automation (Python, PowerShell, Jenkins, SVN): Automation of build, test, and HIL deployment processes as well as integration into CI/CD pipelines
• Test data & configuration management (XML): Maintenance and adaptation of XML test vectors and system configurations with automated integration into test environments
• Non-functional testing: Execution of performance and load tests to assess stability and system behavior
• Agile development & defect management (JIRA, Confluence): Participation in Scrum teams, test coordination, review of test artifacts, as well as defect tracking and root-cause analysis
• Error analysis & debugging (CANoe, CANalyzer): Analysis of errors and message flows across multiple system layers (application to bus)
• Model-based analysis (UML, Enterprise Architect): Specification of SUT/SOW and support for systematic test control
• Process & test documentation: Creation of integration and test documentation according to internal quality and certification requirements

Project, Strategic Consulting – building the Data Strategy and Data Governance Policy for the German branch, client (private bank Julius Bär, headquarters Zurich), March 2026 – present

• Design and negotiation of the data strategy with key stakeholders, including obtaining board sign-off (strategic consulting) – in this context, regulatory advice on data regulations in the EU and specifically for Germany. The data strategy includes: Data Lifecycle Management: data capture, data storage, data usage, data retention policy, data quality incident management
• Definition of milestones and technical feasibility for implementing TOM for the data strategy, data quality checks, metrics, and a metadata inventory to ensure the bank’s compliance with DORA, BCBS239, and MaRisk requirements.

Core project data change, client: (ING Bank, Frankfurt am Main), March – December 2025

• Concept development and solution design for new end-to-end processes including technical interfaces
• Definition of synchronization logic and data flows between legacy and target systems (decommissioning of legacy systems)
• Analysis and validation of data models
• Stakeholder communication with product owners, feature engineers, UX designers, and operational teams for decision-making
• Analytics and impact assessments, e.g. to assess downstream effects and regulatory requirements
• Documentation and comments on technical and business requirements to support implementation in agile squads

Project digitalization of a user group, client: (ING Bank, Frankfurt am Main), as Interim Product Owner, Jan 2025 – present

• Co-shaping key decisions on data architecture and process logic in the context of historized data and user login functionality
• Development of business solution concepts for migration to the target system, including system integration and data flows
• Support with analytics and impact analyses, especially regarding the ability to provide information to law enforcement authorities
• Active coordination with stakeholders from different squads to support decision-making and ensure regulatory requirements are met
• Creation of test scenarios for operational teams and backend systems in the area of API management using Postman and Bruno.

• Advising companies on building, migrating and optimising BI and reporting landscapes (Power BI, SQL, Python, ETL)

• 5 client engagements in real estate and finance since 05/2025: taking over and stabilising existing reporting, automating recurring standard and management reports, building cash-flow models

• Proposal and feasibility assessments for BI and reporting projects

• Using AI-assisted development (Claude Code) to accelerate automation, tooling and web/app development

• Custom ERP system

• Problem: A client's core processes ran on scattered, siloed Excel files with no central data storage – error-prone, hard to scale and impossible to analyse end-to-end.

• Approach: Captured the business processes and requirements, modelled the data and developed iteratively together with the business team.

• Implementation: Built a tailored, web-based ERP system with a central database, role-based modules and automated reporting – delivered using AI-assisted development in Claude Code.

• Timesheet app

• Starting point: Time tracking based on an overgrown, macro-heavy Excel template – maintenance-intensive, single-user and error-prone.

• Implementation: Migrated all functionality and VBA macros into a standalone web app with central data storage, multi-user support and automated reporting.

• Cash-flow modelling

• Starting point: The existing cash-flow model covered standing investments only; project developments were missing from steering.

• Implementation: Built and extended the CF model to include project-development cash flows.

• Optimisation: Reviewed and optimised existing CF models and expanded the KPI outputs for reporting and steering.

• Developing the infrastructure and improving existing infrastructure: Jenkins, Gitlab Pipeline, OpenShift, Docker, Helm Chart, Kubernetes, Artifactory, CodePipeline, CodeArtifact, Python
• Documenting solutions in Jira/Confluence
• Supporting other colleagues in different technical areas

• AI Integration (LLM & RAG): Design and build of an internal intelligent RAG system (Retrieval-Augmented Generation) based on LLMs, n8n, and vector data for the automated analysis of technical documents and error logs.
• Design & Implementation: Design of a robust RS-232/UART communication interface for an SBC-based embedded device to control medical shaker systems.
• Architecture & Protocol Design: Implementation of a highly maintainable software structure (OOP, SOLID) and definition of hardware-close, resilient communication protocols including multithreading and advanced error handling.
• Quality Assurance & DevOps: Test automation using xUnit, integration tests directly on the hardware target, and maintenance of technical documentation according to strict medical technology standards via Azure DevOps.

Label: C#, .NET, LLMs, RAG, n8n, RS-232, UART, Multithreading, async/await, xUnit, gRPC/protobuf, Blazor, MudBlazor, EF Core, Visual Studio 2026, Azure DevOps

• IT Senior Consultant (bank infrastructure, Active Directory, Azure, security, PKI)
• Planning, design, and implementation of cloud solutions based on Microsoft Azure / M365
• Teams, M365, and cloud services
• Vulnerabilities, threats, attacks
• Security analysis, security policy, security architecture
• Conducting meetings and presentations at various management levels
• Organizing and leading team meetings to improve internal communication
• Tools: PowerShell, Active Directory, GPO, DNS, DHCP, scripting

• Structured analysis and evaluation of business processes

• Gathering, documenting, and prioritizing requirements

• Creating business-friendly and technically executable process models

• Use of Camunda tools

• Deriving requirements and interfaces from BPMN diagrams

• Coordination with stakeholders and business units

• Translating business requirements into technical solution designs

• Implementing efficient and tailored applications

• Systematic collection, analysis, and documentation of requirements

• Prioritizing and validating requirements in close collaboration with stakeholders

• Alignment between business and development to ensure shared objectives

• Creating use cases, user stories, and acceptance criteria

• Continuous requirements and change management throughout the project lifecycle

• Define project goals and create project plans

• Delegate tasks and monitor project progress

• Monitor budgets and inform stakeholders

• Mendix: Architecture, development, and maintenance of custom applications (Microflows, Domain Model, Security, XPath)

• Modeling Mendix workflows for process optimization

• Develop scalable apps with Mendix including REST/SOAP integration with SAP, SQL, Azure & SharePoint

• UI design for Mendix using Atlas UI, Fluent UI, HTML, CSS, JavaScript

• Develop web & mobile apps with Mendix using agile methods (Scrum, Kanban)

• Implement business logic with Mendix Microflows and Nanoflows

• Performance optimization and architecture improvements for Mendix applications

• Conduct Mendix training

• Create technical documentation and best practices for Mendix

• Coaching and mentoring for low-code development with Mendix

• Development of ETL pipelines with Talend (7/ Enterprise)
• Development/adaptation of database schema/database functions (PostgreSQL)
• Development of GIT CI pipelines

Technologies: Talend Enterprise, Git, PostgreSQL, Dbeaver, SQL, PL-SQL, Liquibase

• Partner with commercial, sales, and medical affairs teams to translate business questions into structured analyses and interactive Power BI dashboards, enabling data-driven decisions in a regulated pharma environment.
• Design and maintain Power BI dashboards that integrate data from Veeva CRM, SharePoint and Databricks, providing real-time visibility into sales trends, territory performance, and commercial KPIs across multiple markets.
• Query and join multiple tables in Databricks using SQL to build clean, analysis-ready datasets, applying transformations such as filtering, aggregation, and window functions to prepare data for reporting.
• Implement Power Automate flows to automate data refresh processes and trigger alerts for KPI thresholds, improving the timeliness and reliability of commercial analytics reporting.

• Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
• Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
• Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
• Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
• Designed scalable data foundations suitable for downstream analytics and AI workloads.
• Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.