finance managment

ABSTRACT

The system mainly deals with the automation of the activities performed at Andhra Pradesh State Finance Corporation (APSFC), which issued various kinds of loans to their Customers and accepts monthly installments from them.

All the master information is gathered pertaining to the employees working in the organization, Industries to whom the loans are issued.  Different types of loans available are designed and the interest rates applicable are set in the master tables.

Initially after registering the customer, loan is sanctioned according to his requirement and eligibility.  Details of a particular loan are gathered such as loan number, customer number, loan code, amount, interest, and number of months, monthly installment and date of sanction.

When the Industries pay the loan installments, details of loan number, payment id, amount and date of payment are gathered and stored.

Simply choosing the appropriate menus such as Employee details report, Customer details report, generates various reports, Loans detail report, Interest report, Customer-loan details report & Payment details report.

The system security is taken care of by a login form, which is allows only authorized users to utilize the system.

The main aim/objective is to develop an effective system, which is fast, accurate, consistent, reliable, and flexible enough so that in can accommodate any further expansion.

Modules

The current project integrates the following and centralizes all the activities into a single application.

MASTER INFORMATION MODULE:  

This module gathers all the master information regarding:

v  The employees working in the firm such as employee number, name, organization, designation, monthly salary and address.

v  Industries who take loans from the firm such as customer number, name, organization, designation, monthly salary and address.

v  Various types of loans available with loan code and description.

v  Different categories of interest rates applicable for loan amount with interest code and rate of interest.

v  Users maintenance details such as user name and password.

LOANS MANAGEMENT MODULE:  

v  Firstly after registering the customer, loan is sanctioned according to his requirements and eligibility.  Details of a particular loan are gathered such as loan number, customer number, loan code, amount, interest, number of months, monthly installment and date of sanction.

REPORT GENERATION MODULE:  

The system is designed to display and print the following reports, which are called by selecting the appropriate menus:

A)                Employee-details report

B)                Customer details report

C)                Loans details report

D)                Interest report

E)                 Customer-loan details report &

F)                 Payment details report. Etc.

G)                 

SOFTWARE AND HARDWARE SPECIFICATIONS

APSFC is a network-based application.  When we talk about hardware and software, we have to mention requirements on both the Client and Server part.

·         Internet connection with 33.6 KBPS Modem.

·         Pentium 233 MHz. 42 GB HD, 256 MB RAM (Server).

·         Any P.C with Windows/Unix compatibility, 12 MB RAM (Client).

·         JDK 1.4.1, Web Server, running on any platform.

·         JDBC/ODBC drivers installed.

·         Servlets 2.0 and JSP

·         Functional Java enabled browser.

·         Data Base (Oracle 8i).

·         Operating System (Windows/Unix/Linux).