SQL Server Integration Services Experts in Germany

Further Development of the Integrated Capacity Management Platform InKa

Rail Infrastructure

• Power BI shared datasets and reports via DirectQuery on Amazon Redshift (timetable, construction and capacity data)
• Automated report testing with Playwright in Docker containers, version control with GitLab
• Concept and implementation of user communication (information page, changelog, known bugs)

Initial Situation:

The integrated capacity management platform (InKa) is a monitoring and analysis platform for data from timetable and capacity management: customer orders, infrastructure, timetable operations, construction, as well as route capacity and width. The data is stored and linked in a structured data warehouse. This makes it possible to create complex KPIs across different source systems and display current and future route utilization as well as construction activity across the network. The goal is to improve strategic, medium-term and intra-year planning and provide users with easy access to capacity management analyses.

Measures:

• Enablement: Introduction of Power BI with training and workshops for development teams.
• Consulting & Design: Problem analysis, concepts and solution consulting for reporting requirements; implementation of reporting solution plans.
• Data Model: Development of shared datasets with DirectQuery on Amazon Redshift and import tables; DAX measures for utilization and capacity KPIs.
• Development: Data analysis, data transformation and visualization in Power BI; extension and migration of business applications to Power BI; AI-supported development in VS Code with GitHub Copilot.
• Test Automation: Automated testing of Power BI reports with Playwright; setup of the test environment in Docker containers.
• User Communication: Concept and implementation of a central information page with hot news, changelog and known bugs, access from reports with report filters, updates via Power Automate.
• Deployment: Management of Power BI Deployment Pipelines across the DEV, TEST and PROD environments.
• Agile Working: Work in an agile team according to SAFe (Scaled Agile Framework); refinement of user stories and features including effort estimates in Jira; version control with Git and GitLab.
• Quality & Documentation: Reviews for quality assurance, error analysis and resolution, technical documentation in AsciiDoc and Confluence.

Technologies: Power BI, DAX, Power Query, DirectQuery, Amazon Redshift, Git / GitLab, Deployment Pipelines, Playwright, Docker, AsciiDoc, Power Automate, Jira, Confluence, VS Code with GitHub Copilot, SAFe

Results:

• Capacity management KPIs from multiple source systems combined on one platform
• Transparency regarding current and future route utilization and construction activity across the network
• Easy access to analyses for users
• Automated regression testing of Power BI reports
• User communication implemented: central information page with hot news, changelog and known bugs, directly accessible from the reports

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.

• Setting architectural standards for Informatica Power Center development teams
• Maintenance-performance-health for DWH (Exadata) environments
• Qlik Sense / BO reports architectural standards
• Implementing best practices in ETL tasks
• Documentation ETL standards on Confluence
• Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
• DWH Data model Power Designer
• Upgrade Qlik Sense versions
• Merge all Informatica server's repository databases on one Oracle DB

• Development of Power BI reports, measures, and KPIs for sales, purchasing, materials management, warehousing, and production
• Analysis of the proALPHA database (Progress OpenEdge) and high-performance SQL queries for extraction and transformation
• Data models, ETL processes, and pipelines including automated refresh via Power BI Service and Data Gateway
• Gathering requirements and implementation in close coordination with the specialist departments

Selected projects:

• Sales report: revenue, incoming orders, and order status
• Purchasing report with automated purchase suggestions (Power Automate)
• Monitoring of missing parts for production and materials management
• Production bills of materials on Microsoft Fabric including deployment pipeline (Dev → Prod)
• Forecast comparison report
• Central Power BI apps that bundle all reports by department

Technologies: Power BI, DAX, Power Query (M), SQL, proALPHA, Progress OpenEdge, Microsoft Fabric, Power Automate, Python

• Led end-to-end delivery of complex international customer-facing IT and system transformation projects across mobility, retail, life sciences, and product development domains.

• Managed project opportunities and delivery initiatives from concept development, planning, execution, migration, validation, deployment, and final customer acceptance.

• Acted as the primary point of contact for project stakeholders, ensuring alignment between customers, business units, suppliers, and delivery teams.

• Ensured timely project execution through proactive monitoring of milestones, deliverables, dependencies, risks, and resource requirements.

• Led and coordinated global cross-functional teams of 20+ members across multiple time zones. Served as the central coordination point for project activities, ensuring accountability, milestones, progress tracking, and timely resolution of issues across multiple stakeholders. Managed status reporting with all the stakeholders, providing clear and timely updates to ensure alignment on project goals.

• Provided functional leadership, mentoring, coaching, and issue resolution support to project team members. Worked closely with senior leadership and executive stakeholders to define project charter and project scope, priorities, milestones, manage dependencies, success criteria and achieve project goals.

• Collaborated closely with senior leadership, business stakeholders, suppliers, operations teams, and external partners to define project objectives and ensure successful execution.

• Managed stakeholder communication through executive dashboards, KPIs, governance reviews, steering committee meetings, and project status reporting.

• Anticipated business needs and provided effective technical solutions in a timely manner to improve business satisfaction.

• Led and supported sub-project management structures, ensuring consistent execution, reporting, and escalation across complex initiatives.

• Managed supplier relationships and service providers to ensure compliance with contractual obligations, service levels, timelines, and quality expectations.

• Supported vendor selection processes, RFP evaluations, delivery governance, cost monitoring, and performance reviews.

• Controlled project budgets, forecasts, resource allocations, and financial tracking to ensure delivery within approved constraints.

• Scheduled workshops explaining the business requirement, prioritizing project goals and managing change.

• Oversaw cloud migrations (Azure/ AWS), database migrations/upgrades, system upgrades, infrastructure & application modernization, data management, legacy decommissioning initiatives, AI solutioning, transition plan of 2000+ applications etc.

• Coordinated execution, deployment, integration, commissioning, data migration and handover activities to ensure production readiness.

• Led a cross-functional team proactively managing dependencies and resolving project issues to closure, while maintaining delivery timelines.

• Proactively managed project risks, dependencies, issues, change requests, and escalations to ensure predictable project outcomes.

• Ensured compliance with GxP, ITIL, corporate governance standards, validation requirements, and audit controls.

• Led internal and external audit support activities, validation documentation, CAPA coordination, and regulatory compliance initiatives.

• Drove process standardization, automation, and governance improvements across project delivery functions.

• Led application rationalization initiatives resulting in the retirement of more than 50 legacy applications, improving operational efficiency and reducing maintenance costs.

• Currently driving Generative AI initiatives to automate project documentation, reporting, knowledge management, and delivery processes.

• Facilitated lessons learned workshops and implemented continuous improvement actions to enhance project execution effectiveness.

Engaged as an independent BI consultant for a FinTech SaaS platform, building and maintaining the end-to-end Microsoft Azure and Fabric analytics stack behind a multi-tenant accounting product used by business owners to track their own financial performance.

• Partnered with finance stakeholders to translate complex accounting workflows into real-time BI dashboards (P&L, Cash Flow, Balance Sheet), helping 2000+ business owners track cash flow and overall financial health effortlessly.
• Developed 10+ interactive dashboards, giving each business owner personalized, real-time visibility into their own sales performance, accounts receivable aging, and operational costs.
• Enforced strict enterprise data governance by implementing dynamic Row-Level Security (RLS) via DAX to isolate each business owner's data within the shared multi-tenant model.
• Maintained and extended an Azure ELT pipeline (Azure Data Factory, Azure SQL Database, Azure Synapse) that automated data ingestion and transformation.
• Contributed to a team-wide platform migration from Azure to Microsoft Fabric to optimize capacity licensing costs.
• Designed and implemented a Microsoft Fabric ELT pipeline (Lakehouse, Pipelines, PySpark) that automated data ingestion and transformation, replacing the prior Azure pipeline.
• Modeled cleansed data into a Star Schema within the data warehouse using T-SQL, powering the Power BI Semantic Model.
• Leveraged AI tools, including Copilot and Claude, as development partners across the entire ELT pipeline, from data ingestion to KPI reporting and visualization.
• Supported agile delivery processes, using Jira to track development tasks and Confluence to maintain technical and project documentation.

• Developed a new web app to manage and configure counting devices for large events
• Technologies: .NET 10, C#, Blazor, MudBlazor, MySQL, Git

Building an observability and alerting solution for Business Central Job Queue Monitoring

• Built a central monitoring solution to monitor the Business Central Job Queue in a multi-organization environment in Azure DevOps
• Integrated Azure Application Insights and Log Analytics for the structured collection and analysis of job runtimes and error events
• Developed KQL queries for targeted analysis of failed jobs and detection of error patterns
• Connected Grafana and Power BI to visualize operational metrics and job statuses in real time
• Implemented an automated alerting workflow with Power Automate – an email notification is triggered immediately when a job fails
• Ensured transparency into the status of productive background processes during ongoing operations

Result: Full transparency into failed Business Central jobs · Significant reduction in response time through automated email alerting · Stable foundation for the proactive operation of productive background processes

Technologies: Azure DevOps | Application Insights | Log Analytics | KQL | Grafana | Power Automate | Power BI | Business Central | Azure Monitor

• Built a Python pipeline that converts lectionary web content into structured daily JSON, applying liturgical-calendar rules for accurate weekday and Sunday coverage.
• Shipped a read-only FastAPI REST API with shared Pydantic models and delivered a Kirundi-first web client for browser and mobile use.
• Owned the data layer and backend architecture, collaborating closely on system architecture and interfaces while automating refreshes with GitHub Actions and validating the ETL with pytest.
• Impact: Created a reliable, API-driven source of truth for daily Bible readings in Kirundi, enabling consistent access to previously unstructured content.

• Led the migration of the existing DWH, including HR data, application processes, project business and time tracking, from an MS SQL Server environment to Azure Databricks
• Refactored existing data models and ETL processes and extended them with new objects and functionalities
• Used Azure Databricks (Unity Catalog, Notebooks, Spark SQL, Databricks Dataflows) and Power BI
• Technologies: MS SQL Server 2019 (SSMS, SSIS), Power BI, Delta Lake, Azure Databricks

DWH for customer and financial data

• Expansion of the DWH to include new data sources
• Report development
• Data quality management

Methodology: Scrum

Tools: Atlassian Confluence & Jira

Databases: Microsoft SQL Server

Programming languages: SQL, T-SQL

ETL: Microsoft SQL Server Integration Services (SSIS)

Frontend platform: PowerBI, Microsoft Reporting Services

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.

• Support and further development of a complex process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD)
• Automation of operational processes, process development and optimization
• Development of frontend applications with MS Power Apps
• Porting SQL Server 2016 to SQL Server 2022
• SQL Server database administration

• Migration of the platform to X systems
• Analysis of changes related to TCP/IP communication
• Handling error tickets
• Installation and configuration of Xypro Security 1 attack detection
• Setting up an SNMP.v3 connection to send alert traps to Netcool (Tivoli)
• Installation and configuration of the RemoteAnalyst software
• Migration of master data and timetable data
• Setting up and monitoring MQ pipelines to external partners