Healthcare

City Bamberg

Development of the Corona rapid test portal

The Client

Bamberg, a city that masterfully combines tradition and modernity, has distinguished itself in recent years as a dynamic hub for future technologies. With its forward-thinking investment policy, Bamberg has not only invested in innovative technologies, but has also implemented effective solutions for managing the coronavirus pandemic. By using cutting-edge technology in the areas of health monitoring and data analysis, the city has been able to significantly contain the spread of the virus while ensuring the public safety and well-being of its citizens. This proactive approach demonstrates how Bamberg uses technology to respond to challenges and continuously improve the quality of life of its residents. The city’s commitment to innovation and technology makes it an exemplary model for other cities worldwide. Bamberg’s pioneering role in technological development and its successful handling of the pandemic have demonstrated the resilience and progressive spirit of this historic city.

General information

Objective

  • Implementation of a browser-based software solution for the efficient processing of corona rapid tests in test centres.
  • Development of a comprehensive system to support various process stations within the test centre.
  • Maximisation of throughput of test subjects to increase efficiency and reduce waiting times.
  • Ensuring fast and secure delivery of test results to the test subject.
  • Automatic notification of the health department in case of positive test results.
  • Ensuring data security without incidents.
  • Introduction of a user-friendly system for citizens to make appointments.

Challenge

  • Adaptation to a dynamic legal situation that requires a quick response and compliance within days.
  • Significant reduction of user interactions (clicks/actions) within the software to maximise user-friendliness.
  • Intuitive display and navigation through different regions and test sites, as well as efficient management of available time slots.
  • High data security requirements to ensure the protection of medical and personal data.

Result

  • Secure management of sensitive medical data without security incidents.
  • Over 2 million tests successfully conducted.
  • High acceptance rate and positive feedback across all user groups.
  • More stable user experience through continuous optimisation of the software.
  • High level of satisfaction among staff at the test sites, facilitated by the efficient design of the software.
  • Development of a redundant and scalable infrastructure to support growing demands and user numbers.

Technical details at a glance

Connection to the T-Systems / IBM Systems

As part of the project, an efficient interface to the T-Systems and IBM systems was implemented. This enabled the integration of the official Corona-Warn-App, through which test results are transmitted directly and automatically signed certificates are created. The certificates could then be downloaded directly in the app and served as official proof of the test results.

  • Implementation of a secure API connection to ensure reliable data transmission.
  • Use of modern encryption technologies to ensure data integrity.
  • Integration of OAuth2 for secure authentication and authorisation of access.

Integration of the EU-DCC Certificate

The software supported the implementation of the EU-wide Digital COVID Certificate (DCC) standard. This allowed for seamless transmission of test results, which were recognised in all EU countries and other associated states.

  • Use of JSON Web Tokens (JWT) for certificate generation and validation.
  • Adaptation to various national healthcare system regulations within the EU and associated countries.
  • Implementation of cross-border healthcare interoperability standards.

Implementation of the Test Centre Processes

To optimise the capacity and efficiency of the test centres, existing manual processes were digitised and automated. This included the development of a user-friendly, browser-based software that was continuously improved in an agile process. On-the-job coaching supported employees in implementing the new processes.

  • Development of a modular system to facilitate adaptation to future requirements.
  • Introduction of a dashboard system to monitor and control test capacities in real time.
  • Implementation of a robust database architecture to manage test data and user information.

Appointment System

The appointment system allowed for intuitive and efficient planning of test appointments, based on the regional availability of test centres. Automated rules avoided overbooking and maximised capacity utilisation.

  • Implementation of an interactive calendar system to visually display appointments.
  • Integration of geographic information systems (GIS) for optimal display and selection of test locations.
  • Use of advanced algorithms to dynamically adjust appointment slots based on demand.

Transfer of Test Results

The results of the rapid coronavirus tests were communicated automatically via email and SMS, ensuring immediate and secure transmission of information to the tested individuals. The integration of a REST API from Twilio supported the seamless transmission of the SMS.

  • Development of a highly available messaging system to support peak load times.
  • Integration of international SMS gateways to ensure accessibility abroad.
  • Implementation of a feedback system to continuously improve the quality and speed of the notification service.
This site is registered on wpml.org as a development site.