UCO Bank Educational Loan Case Study

UCO Bank is a Government of India Undertaken commercial bank. They handle finance operations in various fields, such as, Agriculture, Industry, Trade & Commerce, Service Sector, Infrastructure Sector etc. The bank has a well developed website to provide customers with the option of online banking.

Project Requirements

The bank required a system to process online requests from customers for UCO Education Loan. The bank wanted the visitors (surfers) to be able to submit the education loan application online. The head office users had to have the ability to manage zonal offices, other head office users and state/district details. The zonal office users required the ability to initially approve/reject user applications, assign/re-assign approved request to respective branches, update current status of requests and manage branch details of the respective zonal office. The bank also required a daily status generator engine to generate status reports and forward those automatically to the head office and zonal offices every day at a pre-scheduled time.

Solution

The module created by Allindia Technologies provided the perfect solution to the requirements of the bank. The use of ASP.Net (2.0 framework) with SQL Server in the back end provided ample security and flexibility to the bank in its online operations. The use of separate modules for each operation provided ease of understanding of the system for bank employees.

The Visitor (Surfer) module enabled visitors to submit their loan applications through an online form. On submission, the visitor would receive an acknowledgement mail on his/her specified e-mail id. Later, another mail sent from the bank would inform him/her about the In-principle sanction or rejection of the request.

The Head Office module helped the UCO Bank Head Office users to manage admin users and zonal office details. It enabled them to view online request details and zone wise summary reports. They were also able to perform advanced search and export online request details into a comma-separated-value (.CSV) file.

The UCO Zonal Office module helped UCO Bank Zonal Office employees to manage branch, view details of online requests and forward those details to a branch for further processing. They could also re-assign and re-forward the online request details to another branch, if necessary. They could update the current status of a request, view branch summary report and also perform advanced search.

A daily status generator engine was provided in the system to generate daily status reports and forward those to the head office and zonal offices at pre-scheduled intervals, without any human intervention.

The modular structure of the project simplified the debugging process, hence providing a bug-free product.