Medical Device Monitoring Platform Migration to Cloud

Siemens Healthineers launched a multi-year project aimed at migrating all their CT scanners monitoring solutions into Azure Cloud. Hence, they were looking for ECIF-compliant Microsoft partners who could support them through the project.

Sigma Software team joined the project in April 2023 and embarked on migrating a platform component responsible for data collection and CT scanner usage analysis, including typical user flows, underutilized features, typical errors, etc. Our specialists have assisted in diverse areas within the project and helped to:

• Envision the new Cloud Architecture Design in joint collaboration with experts from Siemens Healthineers, Microsoft, Databricks, and other service providers involved in the project
• Migrate analytics business logic and ETL pipelines that transform raw data into data products tailored for Qlik and Power BI applications
• Develop a unified template for ETL pipelines using Azure Databricks and Spark
• Configure data visualization via interactive BI dashboards

Today, our collaboration with Siemens Healthineers goes beyond the Usage Analytics component migration. We assist the Client in establishing and promoting an agile culture. Our Scrum Master works together with the in-house experts and contributes to implementing agile practices across multiple teams.

Sigma Software engineers also support other teams in developing different functionalities within the scope of the migration project and are involved in:

• Development, performance enhancement, and integration of Pattern Detection Engine that allows Siemens Healthineers to reduce time-to-detect for issues and ensure effective resource management
• Equipment reliability monitoring configuration, including the development of Qlik Dashboards to reduce defects across product lines and ensure optimal maintenance costs
• Featuring a self-service BI platform with data pre-aggregation, Microsoft ODBC, and diverse data services (e.g. event messaging) to ensure higher performance, faster reporting, and seamless integration with existing systems

Siemens Healthineers uses the open Data Lakehouse platform by Databricks as an additional layer on top of Azure Cloud. It offers rich functionality and streamlines the processing of diverse data types. Yet, it puts some limitations on the new Azure-based platform.

Our experts made a set of adjustments to make sure the solution both uses all the advantages of Databricks solution and copes with existing constraints. The changes included:

• Improvement of the existing duplicate removal functionality to utilize parallel computation and increase processing speed
• Applying the Structured Streaming method to ensure data integrity and minimize data processing costs across all the data, not only the added ones (by default the method can be used on the added data only, but we found a way how to apply it using replaced and updated data)