Automating Bank Report Formats Conversion and Validation

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.

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.