Case study

Automating Bank Report Formats Conversion and Validation

An enterprise-ready application to automate the processes of banking reports conversion and validation enabled to execute the procedures faster with less workload and fewer errors

Software Automating Banking Reports Processing And Conversion Thumb

Client

Software Innovation Labs
United States

Project Duration

3 months
2 people

Client Challenge

Our client - a BI Consultancy from California - engaged us to implement a software solution for their FinTech client. The client needed to convert BAI files files to CSV format files manually, which was very time-consuming and error-prone. They expected the service provider to design and implement an application that would enable the personnel to move from the hand-made conversion procedure to a fully-automated process, with fully-automated verification and validation of input and output files. The solution was also meant to be scaled to handle large data sets.

Service Process

We designed and developed an enterprise-ready application that enabled the client to move from a handmade BAI file conversion to a fully-automated process that encompassed conversion itself, as well as the verification and validation of both input and output files. The software application enabled to fully automate the processes involved and thus reduced both the time needed to conduct the procedure as well as the number of errors generated in the process.

Project Results

The delivered solution can automatically adjust to handle the formats of a few public banks and can easily be modified to handle other banks’ formats if such a need arises in the future. What is more, the tool developed enabled to create a binary version of the converter that can be installed on workstations without access to the internet; the files can thus be processed in an offline mode if need be. Importantly, the automated processes can be scaled to handle large data sets. Last but not least, a mundane or even frustrating manual procedure has been eliminated and the company employees are now free to focus on other higher-value tasks.

Features

  • BAI files conversion to CSV, including offline conversion, i.e. without access to the internet
  • automated input and output files verification and validation
  • unified CSV export of balance reporting
  • processing balance report formats from different banks

Benefits

  • substantially decreased time for file conversion, verification and validation
  • substantial reduction / elimination of errors in the processes involved
  • personnel responsible for the manual tasks reallocated to perform more productive and/or more rewarding tasks
  • flexibility to easily handle formats from different banks