SQL Server Integration Services Expert

• 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.

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.

DWH for customer and financial data

• Extension of the DWH with 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

• Implemented the BI solution and replaced the old BI landscape
• Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
• Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
• Expanded the relational DWH database
• Developed ETL processes using SSIS
• Developed the multidimensional database (OLAP Cubes/SSAS)

• 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

• Consulting and creation of various web applications based on SharePoint and the React framework for different clients
• Development and testing of accessible apps for SharePoint
• Creation of various test cases for test automation
• Development of various solutions based on Azure
• Creation of various web services based on .NET
• Development of various SharePoint Framework solutions
• Development of various UI solutions based on SharePoint
• Consulting and creation of various Power Apps applications and Power Automate for the steel industry and an IT consulting company
• Support, consulting, and development with offshore teams for SharePoint 2013, 2016, and microservices for a logistics company
• Consulting, concept design, and development of microservices and web applications based on Microsoft technology and the React framework for a logistics company
• Consulting, concept design, and development of various SharePoint Framework solutions on SharePoint 2016 for logistics
• Consulting for the migration from SharePoint 2010 to 2016 for an IT consulting company

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.

• Replacement of a Java application and the Oracle DB for loading the internal WerWasWo system using SSIS.
• Development of SSIS packages to load text files into the database (SQL Server)
• Development of a database project for deployment on various servers
• Creation of queries to monitor the loading runs
• Development of a PowerShell script to automate the deployment of the SSDT projects.
• Oracle, SQL Developer, Microsoft SQL Server 2022 on-premises, SQL Server Management Studio v21, Visual Studio 2022, SSIS, SSDT, PowerShell.

• The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.

• Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.

• Analyzing the company's current situation and developing the best possible solution together with the client.

• Using both agile and classical IT project management methods to deliver projects on time and within budget.

• Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.

• Considering the dependencies between IT and business to achieve sustainable positive effects.

• Employing modern strategies and tools specifically tailored to the company's needs.

• Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.

• Objective: streamlining management and enabling well-founded, data-driven decision-making.

• As part of the project, I was responsible for operating a Citrix farm for 600 users, including optimizing the user experience and ensuring high availability.

• I managed and optimized the entire application landscape of a major customer, evaluated and implemented application updates, and ensured the compatibility and security of the software in use.

• I managed user accounts, implemented security policies, and monitored system performance.

• I administered Azure Entra ID to control identities and access rights, implemented security policies, and synchronized on-premises directories with the cloud.

• I implemented and managed Microsoft Intune for central management of client devices, including the configuration and management of BitLocker for disk encryption.

• I managed file servers and NTFS permissions to ensure secure and efficient data access management.

• I handled change requests and last-level support tickets efficiently to solve complex system issues and improve user satisfaction.

• I supported and advised the customer team on various topics and projects, identified areas for improvement, and implemented best practices.

Technologies used:

• Citrix XenApp and XenDesktop
• Microsoft Windows Server 2012R2 and 2022
• Exchange 2016 and Exchange Online
• Entra ID (Azure AD)
• Entra ID Connect
• BitLocker
• PowerShell scripting
• Microsoft Intune
• LDAP (Lightweight Directory Access Protocol)
• DNS services (Domain Name System)
• Active Directory Certificate Services (AD CS)

• Many years of work in different roles within the MES product area, with technical development, agile leadership, and strategic product responsibility for key MES components.
• As C# Fullstack Developer / Scrum Master (2018–2020): further development of a programming system for laser machines, introduction and moderation of Scrum processes, quality assurance through automated tests and documentation.
• As Product Owner Cloud Services (2019–2020): leadership of two AWS-based cloud services for providing laser data and legal documents, definition of the product vision, backlog maintenance, and stakeholder communication.
• As Product Owner Infrastructure & Core Services / Head of DevOps / Product Security (2020–2025): responsibility for core MES components such as Service Orchestrator, Licensing Service, IAM, and AppLauncher, building and maintaining Azure DevOps pipelines for over 70 components, and introducing security standards (CRA).
• Company-wide contact for Azure DevOps and largely responsible for its introduction.
• Standardized versioning of all components.
• Structuring of CI/CD and release pipelines.
• Building an agent scale set with special software configuration.
• Connecting Azure DevOps with ServiceNow.
• Standardizing the integration of security tools such as SonarCloud, Dependency Track, and digital signing.
• Technologies & tools: .NET (C#, 4.8 / Core 3.x / 8), WPF, WCF, REST, OData, JSON, DevExpress, Duende IDP, Azure DevOps, AWS, PowerBI, SonarCloud, Dependency Track, Visual Studio Pro.
• Method: Scrum.
• Project language: German / English.

• Designed a future-proof client database for marketing purposes
• Analyzed requirements, designed, and modeled an entity-relationship model
• Consolidated and optimized a client file from various data sources for targeted marketing campaigns
• Worked closely with marketing and IT in an agile environment to iteratively develop the solution
• Technologies and methods: MS Office (mainly Excel), MS Dynamics CRM, MS SharePoint