Projects with the use of MsSQL

To see all projects, clear the filter

Insurance Calculation for Nursing Homes

Period: 06/2023 – 06/2024
Role: Software Developer
Client: cover.mesh
Team size: 10
Person days: 150

cover.mesh is part of the SCHUNCK GROUP and develops digital solutions for it. The SCHUNCK GROUP is a company of the Ecclesia Group and the largest German insurance broker for businesses and institutions. The task of the project was to provide a web platform that performs calculations based on domain-specific rules.

My contributions to the project::
  • Building the web portal with Blazor Server Pages
  • Creating the CI/CD pipeline in Azure DevOps
  • Implementation of the business logic

Persistence Problems

Period: 12/2018 – 09/2019
Role: Software Developer
Client: Schleupen SE
Team size: 5
Person days: 250

The newly introduced Continuous Delivery pipelines exposed non-reproducible persistence problems. Distributed transactions could not be completed under load. Since Schleupen.CS 3.0 has only a single database, no distributed transactions should have occurred at all. The task of the project was to analyze and resolve these problems.

My contributions to the project::
  • Analysis of log entries, error messages, and code to systematically narrow down the issue
  • Analysis of NHibernate and its internal handling of transactions
  • Concept and implementation of a clean but complex solution for new applications
  • Concept and implementation of a quick but somewhat hacky solution for existing applications
  • Documentation of both solutions
  • Training sessions on the solutions
  • Implementation of the clean solution in the platform components

Stabilization of Asynchronous Communication – Business Components

Period: 11/2017 – 01/2018
Role: Software Developer
Client: Schleupen SE
Team size: 5
Person days: 100

When distributed systems communicate asynchronously and messages are lost, it is very difficult to find out where they go missing. Since the previous project had shown that the errors were no longer in the platform components, the team's task was to provide solutions within the framework to support the business developers.

My contributions to the project::
  • Concept and implementation of the Transaction Outbox Pattern in the framework
  • Documentation of the Transaction Outbox Pattern
  • Training sessions on idempotency and the Transaction Outbox Pattern

Billing

Period: 01/2014 – 12/2014
Role: Software Developer
Client: Ferber-Software GmbH
Team size: 7
Person days: 240

Ferber-Software is the market leader in Germany with its debt collection software IKAROS. As part of the IKAROS V4 project, various modules were modernized. The billing module involved extracting existing business logic from the MsSQL database and migrating it into a business logic layer.

My contributions to the project::
  • Analysis of existing T-SQL stored procedures and mapping the logic to C#
  • Design and implementation of the new business logic layer
  • Data modelling and mapping using NHibernate
  • Optimisation of database queries to ensure performance during billing runs