Schleupen.CS 3.0 – Architecture and Framework
The Schleupen.CS software solution is a distributed application with numerous functional and technical components, aimed at providing a standardized and configurable software solution for the energy and water sector across different market roles. The "Architecture and Framework" team works directly with the enterprise architect and handles all cross-cutting concerns of the backend. The team's tasks involve creating cross-team best practices, design patterns, and a framework for over 100 developers, so that the architecture is implemented as consistently as possible across the many different applications.
- Development and consolidation of the application architecture
- Reducing dependencies between teams through better modularization of the framework
- Development of SOAP services for platform components
- Analysis, design, and implementation of a new deployment solution based on Puppet
- Writing and automating CoffeeScript (a JavaScript dialect) unit tests
Persistence Problems
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.
- 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
Case and Process Window
Greenfield development of the central workspace of the debt collection software (IKAROS V4). The project encompassed the redesign of the case and process window to display complex case information in a clear and performant way. By using Event Sourcing, a modern and auditable data storage approach was realised for the processing steps. The efficient loading of events required optimised data loading logic.
- Implementation of the process window view
- Implementation of the business logic for displaying processes
- Calling and displaying values from the claim calculation and claim statement
- Performance optimization of data queries through highly efficient SQL queries (bypassing NHibernate to maximize loading speed)
- Ensuring functionality through automated tests (unit tests)
Billing
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.
- 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
Marketplace for Debt Collection Field Agents
Design and implementation of a B2B web portal as a marketplace solution for receivables management. The system enables debt collection companies to submit claims digitally, which are automatically assigned to freelance field agents for on-site contact. The platform acts as an efficient, private-sector alternative to traditional bailiff services and optimizes the process chain between back-office and mobile field staff.
- Full-stack development of the portal and the underlying business logic
- Implementation of import interfaces for automated transfer of claims data
- Implementation of an export functionality for billing documents (invoices)
- Multiple manual deployments of the web portal
- Analysis of penetration test results and consultation on deriving action strategies
- Ongoing further development and technical and functional support of the marketplace after the initial release