Most of the bank out-sources pre-loan process to loan agencies to reduce the burden and let the agencies pickup the information from customers and verify it before it is being forwarded to the actual bank for approval of loan. Lending Tree is an interface which facilitates a customer to apply for a loan from on-line and to track the status from time-to-time along with aiding the loan approval agency to verify and accept/reject the customer file. Lending Tree is unique in such a way, it not only helps the customers but also the loan agency to check the pending, assign it to a departments, complete the formalities and procedures between the departments and  arrive at decisions to very fact in addition to providing a transparency system for every one. The project Loan Approval System developed using JSP and Oracle.

The customer can directly apply for a loan by selecting a bank and loan type from the list available. The application is received by loan agency who will have three departments- PickUp, Verifiaction and Legal. This system can be controlled by the administrator. First he will look at the application received and allot the application for a particular employee of pickup department. The employee will go and make a physical verification of the documents at the customers and receives the documents necessary for the loan. Then he logs into this system and forwards the application to the verification department which will verify the whereabouts of the person, his organization, his salary particulars etc. and then forwards the application with a status verified. Then application reaches the legal department. The legal department people will verify the builder details and when satisfied sends their report to the administrator.

The administrator or final approving authority views both types of reports, Viz, the reports from verification department and the report legal department. This will help him to take a decision regarding whether to forward it to the bank or not. The same is communicated to the customer.

The customer can at any time view the status of his application and can send any messages to the administrator and can get clarifications from him. Thus the lending tree s/w helps to simplify the loan system along with making the work easy.

There are 5 types of users who can get immense benefits from system:

• The customer – seeking the loan and information related to banks and loans
• The administrator of loan agency who will take track the decision of bank to approve or disapprove and also controls the overall system functionality
• The PickUp department users who picks up the details and documents from customers
• The verification department user who make a physical verification of the details submitted by the customer
• The legal department user who verifies the legality of the documents of the builder and construction.

Software Requirments:

• Operating System             :Windows
• Technologies                    :Java/J2ee(JDBC, Servlets, JSP)
• Web Technologies             :Html, JavaScript
• Web Server                       :Tomcat
• Database                          :Oracle
• Softwares                          :J2sdk6.0, Tomcat 5.0, Oracle 9i

Hardware Requirements:

• Hardware :Pentium based systems with a Minimum of p4
• RAM  :256MB (min)

Installation steps:

A)INSTALLATIONS:

1.Install   java-1.5

2.Set environmental variable for java.

3.Install Tomcat 6.0

4.Install Oracle9i (or) Oracle 10g

B)PROCEDURES:

i)place  soe folder on ——> C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps

ii)How to import database dump file in to oracle9i (or)10g

startàAll Programsàoracle Database 10gàRun SQL Command Line

a)Enter as a administrator.

connect system/teng;

b)create a new username and password(soe/soe)

create user soe identified by soe;

c)grant permissions to user.

grant dba to soe;

d)connect soe/soe;

e)startàAll Programsàoracle Database 10gàstart database

//type the following command

imp soe/soe full=y file=c:\bestowsteer.dmp(database dump file path)

iii)Create DSN(login)

start à control panel àAdministrative toolsàDataSourcesàAddàOracle in XE(if it is Oracle 10g)à

Data Source Name     –  soe

TNS Service Name      –  XE

User id                         –  soe

Click test connection

Password   –  soe

Click ok ……ok….ok…

iv)start tomcat server

v)type  http://localhost:8081/soe  on browser.

U can look at the Home Page of this application

Download project code: