Automation of business processes

Background

A cantonal bank was faced with the challenge of modernizing its IT infrastructure in the course of digitalization. The aim was to consolidate existing APIs from Avaloq and other partners and replace them with clear, technologically standardized APIs. This should enable scaling with partners and increase the efficiency of internal processes.

Project goals

• Acceleration of MariaDB provisioning: Reduction of provisioning time from 10 to 1 hour.
• Automation of database comparisons: Development of clone scripts for reconciliation between production and test environments.
• Resolution of Camunda dependencies: Elimination of dependencies on Camunda variables in the database.
• Optimization of business processes: Implementation of Camunda for process automation.

Procedure

1. Analysis and requirements definition: Detailed recording of business processes and technical requirements.
2. Software architecture design: Design of a scalable architecture using microservices and service-oriented design.
3. Backend development: Implementation of server-side logic with Java EE and the Spring Framework.
4. API development: Creation of REST APIs with RAML to standardize the interfaces.
5. Database optimization: Revision of the MariaDB structures and optimization of the queries.
6. Revision of the HTTP connectors: Improvement of the communication interfaces to increase performance.
7. Introduction of dynamic environment variables: Development of a new class for dynamic reading of environment variables per service task.
8. Testing and quality assurance: Execution of unit, integration and system tests using SonarQube.
9. Documentation and training: Creation of technical documentation and implementation of workshops for the internal team.

Results

• Time saving: The provision of MariaDB has been reduced from 10 to 1 hour.
• Increased efficiency: Automated clone scripts relieve the IT team and speed up database synchronization.
• Stabilization of the systems: Automation has minimized sources of error and increased system stability.
• Flexibility: The systems can now be scaled more easily and adapted to new requirements.