Web Development for Bank Statement Analysis: Technologies, Challenges, and Innovations

Web Development for Bank Statement Analysis: Technologies, Challenges, and Innovations

Nayan N. Mhatre , Siom P. Rajput,  Satyam S. Suryawanshi, Uday V. Tawde, Hariom D. Mishra

Under the Guidance of Prof. Y. R. Bhalerao

Computer Science and Engineering

Sandip University Nashik

Abstract

Purpose

The purpose of this project is to fulfill the requirements of a bachelor’s degree in Cloud Technology and Information Security. The project aims to design and develop a Bank Statement Analysis system that provides a more secure approach to managing bank customers' statements, strengthening the relationship between banks and their customers by offering solutions with multi-level security to improve customer satisfaction.

Methodology

The project utilizes a range of technologies, including:

·         Python Flask Framework

·         Computer Vision (Google's Tesseract OCR)

·         PDF to Image Python package (pdf2image)

·         Machine Learning (Scikit-Learn) to predict transaction categories

·         Azure SQL Database to store transaction data and user login details

·         Power-BI for data visualization

·         Docker and AWS EC2 for service hosting.

Findings

The Bank Statement Analysis system developed in this project offers a secure and efficient solution for managing bank customers' statements. The use of multi-level security measures, such as Azure SQL Database and Power-BI visualizations, enhances the overall security and user experience, strengthening the relationship between banks and their customers.

Conclusion

This project demonstrates the successful design and development of a Bank Statement Analysis system that leverages various technologies, including cloud computing, computer vision, and machine learning, to provide a more secure and user-friendly solution for managing bank customers' statements.

Keywords

Azure SQL Database, Power-BI Tool, AWS EC2 Service