THE PROJECT
In the context of its digitalization strategy, a renowned Swiss retail bank requires reliable and up-to-date information on authorizations and powers of attorney for customer positions across all central customer channels. The information is to be delivered directly from the core banking system to the peripheral systems using data streaming architecture. The authorizations and powers of attorney are primarily required in personal advice, in e-banking and in the call center to determine which positions and assets may be displayed or being used for transactions. Correctness at all times is crucial.
OUR CONTRIBUTION
abaQon employees were involved in the specification, design and implementation steps of the solution. To assert the correctness of the output data we developed a validation model. The model, written in SQL, was validated on an anonymized data set covering basic and edge cases. Using this model and a larger data set which also includes synthetic and load data we then developed the streaming solution, asserting correctness in every step. The input data was fed to both the validation model and the streaming solution. Then the output was compared and confirmed to be identical. After developing a correct solution we then tackled performance. The validation model allowed us to make changes to the solution while being sure that the correctness is not affected.
REALISED ADDED VALUE
With the SQL-based validation model in place we have a tool that allows changes to be implemented more easily and with correctness as highest priority. Any change to the streaming architecture will be tested for correctness for a wide range of scenarios with every build. Code maintenance and extensions can be validated to work with the expectations on the output data at development time. Developers can iterate faster and test extensively even before deploying to test stages.
Author
