SQL Server Analysis Services Expert

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.

Evidence-led health intelligence platform turning published research into personal health protocols. It scores 430 habits, foods, and supplements against the studies behind them, and moves the score when the evidence moves. Built solo.

• Built the daily ingestion pipeline across PubMed, bioRxiv, and medRxiv: 43,000+ papers from 3,400+ journals processed into 230,000+ typed evidence claims, each one traceable back to the study it came from.
• Designed the six-factor evidence scoring model and the public changelog behind it, so no recommendation ever appears without the papers underneath it. 23,000+ grade changes recorded and explained to date.
• Shipped an entity information model connecting every intervention to its mechanisms, biomarkers, and outcomes: 118 biomarkers with region-specific reference ranges, 77 mechanisms, 32 graded outcomes.
• Built the personalisation layer: blood panel ingestion that reads lab PDFs with a vision model and corrects results for draw time against the user's wake anchor, plus Oura, WHOOP, and Withings integration for daily readiness context.
• Operate eleven specialised review agents over the corpus and codebase, covering paper curation, retrieval quality, health-claim compliance across EU and US regimes, and security.
• Shipped the Evidence Assistant, a RAG assistant that answers from the claim database and cites the underlying papers, plus a B2B practitioner tier, an Expo React Native app, and localisation across 3 languages and 7 markets.

Stack: Next.js 16, TypeScript, Supabase, pgvector, Anthropic Claude, Vercel, DeepInfra.

• Enterprise WMS customisation for Albert Heijn and EDEKA.
• Owned end-to-end test planning, automation, and performance validation for logistics automation software serving high-volume grocery warehouse operations.

Architected and maintained data products for renewable energy operations, covering wind turbine, grid-meter, and weather data. Built scalable ETL/ELT pipelines in Azure Databricks using Delta Lake (bronze/silver/gold layers) and processed data in various formats, including structured and semi-structured data. Contributed to a data quality framework supporting table and column documentation, outlier detection, and completeness metrics across all datasets within a data product. In addition, implemented a DORA KPI Databricks dashboard used across all data products. Optimized CI/CD processes in Azure DevOps to streamline deployment across development, test, and production environments.

Technology stack: Azure Databricks, PySpark, SQL, Delta Lake, Unity Catalog, Azure Data Lake, APIs, Dremio, Azure DevOps, YAML, Git, Databricks Workflows, Application Insights, Terraform, OpenAI API, Codex, LLM-assisted workflows

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

• 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

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.

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

Task

• Further development of a new ERP system with Blazor
• Creation of e-invoices with the XRechnung and ZUGFeRD format
• UI/UX design Client-server system
• Windows 11 Technology
• Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
• C#, MVVM Development tools
• Microsoft Visual Studio .NET 2022 Database
• MSSQL Industry
• Other

• Data Management of Oracle based Data Warehouse
• Operational monitoring of DWH
• ETL Processes in Oracle SQL
• Consulting in reporting and DWH development
• Developing Dynamic List, Grid, Jxls, Pivot Reports in Report Server
• Data visualization in Report Server

• Energy Management (2023-08-01 – today):

• Designing a planning solution to increase energy efficiency

• Creating a concept for an energy management system

• Planning a component for action planning to gradually reduce energy consumption

• Evaluating planned measures based on opportunities, risks, and effectiveness for inclusion in the planning process

• Designing requirements for a data model to compare planned and actual data in the dashboard

• Consulting (2023-05-01 – today):

• Extending the accantec PerCon authorization management system to IBM Planning Analytics

• Analyzing authorization requirements and comparing them with IBM Cognos Analytics and Tableau

• Extending accantec PerCon with IBM Planning Analytics via REST API

• Printing (2023-04-01 – today):

• Supporting the introduction of a data warehouse solution with IBM Cognos Analytics 11

• Supporting the introduction of a reporting system based on a standard data warehouse

• Supporting report developers and developing custom controls to optimize the user interface

• Healthcare (2020-08-01 – 2023-03-31):

• Optimizing, extending, and operating a historically grown BI planning environment

• Updating the Jedox solution from version 2019.1 to 2022.2

• Optimizing ETL processes and reports, and implementing automated ETL processes

• Connecting different accounting and administration systems

• Writing completed plans back to source systems and implementing complex allocation logic

• Building and maintaining dimensions and hierarchies (corporate structure, P&L)

• Developing planning scenarios for FP&A and creating reports to monitor the budget

• Designing and implementing new OLAP cubes and reporting

• Providing user training according to customer requirements

• Industrial Sector (2020-04-01 – 2020-12-31):

• Migrating and optimizing an existing Jedox solution

• Combining the reporting system and planning system in Jedox

• Building a central group reporting system with plan-versus-actual comparisons for FP&A

• Optimizing KPI calculations and existing reports, and creating new reports

• Creating forecast reports, managing authorizations, and providing user training in an international environment

• Finance (2020-05-01 – 2023-03-31):

• Further developing and operating an existing Jedox solution

• Designing and developing new OLAP cubes for controlling

• Building hierarchies in dimensions (e.g. P&L) and updating the Jedox system in a Linux environment

• Providing user training on report creation

• Trade Fair (2020-06-01 – 2023-03-31):

• Designing and developing a BI planning solution in Jedox with a data warehouse structure

• Creating ETL processes to load dimensions and OLAP cubes

• Building reports and plan-entry forms, and implementing business logic (P&L, allocation logic)

• Implementing planning and analysis reports as well as a security concept in Jedox

• Industrial Sector (2021-03-01 – 2023-03-31):

• Migrating and optimizing an existing Jedox solution

• Updating the Jedox solution and migrating ETL processes from Pentaho Kettle to Jedox Integrator

• Optimizing SQL queries, analyzing the system, eliminating redundancies, and developing new ETL processes

• Analyzing and adapting existing reports

• Staffing Services (2022-07-01 – 2022-10-31):

• Migrating a Jedox solution from version 5 to 2022.2

• Updating the system, adjusting configurations, and analyzing performance issues

• Optimizing the OLAP database by streamlining dimensions and removing unused cubes/data

• Finance (2021-10-01 – 2022-02-28):

• Creating OLAP cubes in Microsoft SSAS

• Building dimensions and hierarchies and calculating KPIs with MDX

• Supporting users with Power BI requests

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

• 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

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