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

Abstract

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