WEB BASED PAWN BROKING AND AUCTION PROCESS FOR HATTON NATIONAL BANK PLC.

Abstract

The Hatton National Bank PLC. is one of the pioneer commercial bank in Sri Lanka. It’s well recognized in the banking sector for its unique products as well as quality customer services. At present pawn broking is done with standalone system which controls by the central database. Since then some procedures are still done manually such as payment process, sending notices to customers etc. The current auction procedure is done completely manually which is taking much time of the bank staff as well as authorized bidders as staff has to manually finalized the items fallen for auction category, inform customers to make part payment if they wish to redeem their items in future, bidding for items etc. Currently authorized bidders can bid for items but not the interested outside customers. Moving to online auction procedure will save time of staff and it will create opportunity for customers to bid and purchase jewelries at lower cost. Since the popularity of the bank has increased during past years, improve and maintain good quality services to the customers with much efficiency and effectively is essential to retain standard in the banking industry. To overcome above mention problems, a web based system will be implemented and the entire system will be divided in to five main systems namely, Registration (Staff/ Customers/Bidders), Billing, Payment procedure, Notice generation (Email/SMS/Paper Notices), Online Bidding, Report Generation for Management. This will completely replace the standalone pawn broking system as well as auction procedure to provide speedy and convenient service to both customers and the bank staff. System will be developed using three-tier Model, View and Controller (MVC) model architecture with Apache HTTP Server, MySQL, PHP (XAMPP) technology. Jquery will also be used to handle critical user interface functionalities. Object oriented concept will be used to draw use case diagrams. Microsoft Visio 2007 will be used as the modeling software at the analyzing and the designing stage of the project.