Co-operative Banks have been playing a pivotal role in the socio-economic upliftment of the poor and the downtrodden in our Country. Co-operative banks provide services in three-tier approach - SCB (State Co-operative Bank), DCCB (District Central Co-operative Bank) PACS (Primary Agricultural Co-operative Society). The flow of money takes the route from NABARD to Rural via SCB, DCCB and PACS. The Bihar State Co-operative Bank Ltd. was established in Patna way back in 1914 and since inception, the entire activity of Bank was being carried out manually. For each activity of the bank the responsibilities have been predefined and assigned to the designated Officer/ Staff for smooth functioning of the branch. With competition in the financial sector increasing day by day the manual process is not able to sustain in long term in the larger interest of the co-operative bank.

Various activities of the Co-operative Bank include : ? Interest rate calculations ? Management of various types of fixed deposits ? Management of loans/ advances with respect to Agriculture and non-agriculture. ? Debit/ Credit with respect to all Accounts ? Management of demand/ collection branch wise and / or month wise. ? Generation and maintenance of Scroll/ Ledger for all accounts. ? Preparation of Balance sheet & Profit and loss account ? Management of entire establishment. More of these are being managed manually. Bihar State Co-operative Bank has a total of 8 branches in Patna under its administrative control.

COIN as the Answer.... To overcome the above challenges, NIC has developed a specialized software named COIN (Cooperative Banking in Place) . The Beauty of this software lies in its customer-oriented approach. It provides complete mechanism of every kind of transaction that it handles.

The benefit of computerisation is manifold. A computerized system can reduce the transaction cost and bring benefit to the bank by serving more customers with the existing manpower and resources. An efficient way of proper bookkeeping after business hours has been introduced. COIN is designed to provide better monitoring of agricultural loans and advances, the core activity of Cooperative Bank. The scope of computerisation of COIN is to automate the entire range of banking activities. This system in addition to its implementation at Bank Head Quarters can be implemented in remote branches as well. The extent of replacing the manual system with the new automated system will be a step forward in providing better and error free service to its customers.

The gamut of services to be covered by automating the entire processes of banking activities will benefit in managing the key activities of Accounts, Finance, Administration and Developing the Human Resources for the Bank Head Quarters as well as its branches. In addition, the developed system will act as a single window platform for the Management in controlling and monitoring various resources of the bank under disposal.

On completion of the computerisation of all the three SCB, DCCB and PACS and connected through Net, then request for loan amount can be made from remote villages by PACS to DCCB and after scrutiny, DCCB will be in a position to raise the request to SCB from their respective districts. All these loan requests will be available to SCB instantly for their processing.

Technical Details Computing Model : Client-Server Operating System : Windows Server Family RDBMS : SQL Server 2000 Front End Tool : Visual basic 6.0

COIN is developed following modular approach of development, so that it can be easily maintained. COIN exploits features of the Component Object Model (COM). It incorporates object-oriented architecture. COM provides a standard protocol for connecting objects together, even if they are designed in different programming languages. An arbitrary number of OLE custom controls (OCX) are made and used as prefabricated components to aid in building the project that smoothen the functioning of project. A dynamic-link library (DLL) file named BSCB.DLL is developed which groups many functions and class modules that are compiled, linked and stored separately from the project that uses them. Using DLL saves memory and reduces swapping . The software provides quick and comprehensive MIS reports and various conciliatory reports that can be generated at the end of the day. Software can pinpoint any type of errors during handling of transactions

?| Important Features ? Better monitoring of agricultural and non- agricultural loans. ? Demand Draft disbursement Analysis and monitoring with respect to CC banks ? Timely compliance of various reports to the designated authorities ? Elimination of manual process, thus making the system fast, responsive and error free ? Timely analysis of bank wise target achievement for better inspection and decision making ? Timely reconciliation of Head Office accounts