Reporting Software Development

Automating reports and payment calculations for the rescue service

Case study

ERP

MVP

The client is a non-profit search and rescue service. The customer's sphere of activity is to search and rescue operations in the mountains. The company is represented in different countries of the world. The structure of the company is divided into administrative and rescue personnel.

Rescue operation algorithm:

A person in distress calls the central office.
The central office contacts the station closest to the person.
The station manager is looking for rescue team leaders.
The leaders assemble teams depending on the conditions of the emergency.
The teams come and conduct a rescue operation.
As the operation ends, each team member and their leaders write reports on the rescue operations performed.
The station manager compiles all the reports in one and sends them to the central office.
The remuneration is calculated according to the reports.

Initially, mission reports were written in the form of MS Word files. Various tables, photos from the scene were attached. All document exchange was implemented through email. According to the client, reporting on a single operation for the central office could take up to 6 months.

Project goal

Reduce errors and speed up the work of the rescue service administrative staff.

Client tasks

Registration of reports on each mission from all participants.
Aggregation of records from all participants.
Record's compilation in a single document.
Calculation of payments to each operation participant based on reports and current rates.

Solution

Started a project with basic functionality for testing it on end-users. The purpose of the approach is to collect feedback for the further development of the product. We developed and tested the project in stages. It helped to study and implement customer's wishes for the product timely. We took task boards from Kanban, daily calls with the customer with tasks assignment - from SCRUM. The time to complete the task was estimated by the developer, then agreed with the client. If the client was satisfied with everything, the task was sent to development. It was up to the client to prioritize features in different stages.

Integrated with SAP. The system calculates the payments to the participants of the rescue operation, then this data is integrated into SAP ERP.

Integrated with the Daylight service. Daylight is a platform for organizing training for lifeguards. It was necessary to configure the exchange of user data. Thus, the rescuer could log in to the training system through his user account in our system.

Automated the process of exporting reports. Reports can be generated in different slices, downloaded as CSV, XLS, or PDF files and printed.

Results

Reduced reporting time. After the introduction of the system, the reports generation time was reduced from 6 months to 2 weeks.
The Agile workflow of the reports generation process. We have implemented the ability to return to any steps during the work with the report. The interface has become more convenient: if the users want to change something, they can return to the desired section and make adjustments without losing data.
Automated reward calculation. The system calculates rewards to rescuers automatically. It reduces errors and speeds up processing.