The purpose of Loanalytic-Web is to make the life of the borrower easy by simply registering to an online portal and get a loan approval. The application deals with 3 kinds of loans: Mortgage, Personal and Education loan. The user can quickly choose the kind of loan he wants and the amount he wants to borrow. Loan request would be validated by the application automatically as soon as the user answers few questions based on the kind of loan. The feasibility of loan approval would be displayed immediately. If the criteria is not met the user would be notified immediately else a background check is performed by the admin and a manual notification is sent by the admin. The application gives an opportunity to the admin to verify the user by validating the documents he has uploaded and doing some criminal/background check. Above all, we hope to provide a comfortable user experience along with the best pricing available.
| Team Members Names | Roles | Email Address | Phone Numbers |
|---|---|---|---|
| Vamsee Krishna Gangapatnam | Project Manager | S533908@nwmissouri.edu | +16605281049 |
| Gangadhar Adusumalli | Senior Architect | S533704@nwmissouri.edu | +16605280325 |
| Keerthi Sree Kukunoor | Software Engineer | S533570@nwmissouri.edu | +12159617144 |
| Gouthami Pasham | Team Lead | S533491@nwmissouri.edu | +12032158224 |
| Taraka Raviteja Peddi | Software Trainee | S533904@nwmissouri.edu | +16608530466 |
| Himabindu Poshala | Software Engineer | S533727@nwmissouri.edu | +14694121091 |
| Meghana Putta | Software Engineer | S533909@nwmissouri.edu | +14243979577 |
The major features of Loanalytic database system as shown in the below diagram.
The above figure gives a complete description of all the entities used in the application. The description of each entity and the relation between them is specified below:
The user entity has all the attributes to store the information related to the user. It stores the information provided by the user during the registration phase.
The admin entity stores the details related to the employees working for the application. The attributes include the employee id, first name, last name, email and designation.
Document entity stores the required documents uploaded by the user and later the admin can view these documents.
Application table has all the information related to the application. ##Loan Type: Loan type is a master table, it has all the in information related to loans. Admin can introduce new loans into the system through the interface.
Credit score is a master entity, it stores the basic information of Credit score and the range associated with it.
Social security number is the mandatory for the loanalytic.
Address proof is must should for the user to verify his/her existence in same country.
User can mail his query to supp.lonaltyics@gmail.com
User can give feedback to the after completing the loan. User can rate his/her over all.