Online Loan Management System with SMS Notification
Abstract
Loan Management System is an online platform designed and developed in PHP, MySQL and Bootstrap, the said project aimed to convert the manual process of loan management into an automated systems that stores and organizes the records in a database driven application. Core functions of the system are to provide a fast, accurate and secure transaction between the customers and the management. Specifically, the system can manage the payments and accounting, contract management, report generation, and notification through SMS or text. The study was conducted in a cooperative with 10 employees and more than 100 members that serve as the respondents of the study. Rapid Application Development was used as the model for the development of the system, with this model; the researchers/developers developed a prototype in the early stage of the project. Testing was done in two ways; (1) the system was evaluated and reviewed by IT experts to make sure that the project is of high quality and meets the standards, (2) after it was tested by the IT experts, revisions were made and then it was presented to the client for beta testing. The main purpose of the beta testing is to test the efficiency and accuracy of the project in the live environment before it will be implemented. Proper training to the end-users was also conducted and the developers provided a technical support to make sure that the implementation will proceed as planned.
How the system works
The member will apply for the membership at the cooperative; then user will register the member using the system. If a particular member will apply for a loan the system will determine if the member can avail a particular type of loan or not then the Office Administrator or Manager will approved or disapproved the transaction. For the loan payment process the exact amount to be paid by the member will be recorded. All transaction will be stored in the database and the system will send SMS to the member about all the transactions made.
Programming environment
In software development, the development environment is a set of processes and tools that are used to develop a program and is sometimes used synonymously with integrated development environment (IDE) which is the software development tool used to write, build, and test and debug a program. The program use as front end of the system is Bootstrap, it is an open source platform used for designing and development of web based systems using HTML, CSS and Javascript. The software use as back end of the system is MySQL/MariaDB that is a relational database management system; this makes working with the data faster and easier. Once entered into the database the data may be manipulated or viewed in various ways such as by sorting or by specially set up queries.
System Features
Administrator
- Login, Change Password, Logout
- Can Add, edit, delete employee / member
- Can Request Loan for walk-in employee
- Can Process payment
- Can Notify the payment overdue
- Can create, update and delete staff
- Can View logs
- Can Add, edit and delete Loan Types
- Can Send SMS notification for overdue payment
Employee/Member/Customer
- Login, Change Password, Logout
- Can update profile
- Can Upload Profile Photo
- Notification for payment overdue
- Can Request Loan depends on monthly Salary
- Can View payment History
CONCLUSIONS
The main target was to design, develop and implement a loan management system that can be accessed online and information can be disseminated through SMS or text. The cooperative wants to automate the process in the application, approval, and payment and monitoring of loan transactions. As an IT or technology innovators, this is an opportunity to incorporate the use of technology and software in real-world of business application especially in a cooperative type of business.
Both parties cooperated well in order to achieve the main goal, and that is to convert the manual process into an information systems. The result of the study based on the rating proves that the Online Loan Management System with SMS Notification provides an easy and convenient way of processing the loan transactions. With the implementation of this project the company can now provide a better service to their clientele.
RECOMMENDATIONS
Based on the findings, the following recommendations are suggested:
- The system was evaluated by IT experts, end-users are satisfied with the output of the program, and in other words the researchers/developers strongly recommend implementing the system in a parallel manner.
- Upon implementation, the company should hire technical working people for the maintenance of the information system.
- The cooperative should also allocate budget for the implementation and maintenance of the said system.
- Further study should also be done in order to enhance and incorporate additional features to the system.
Complete documentation is available and we can also revised it based on your preferred format.
visit our facebook page for more information.
for the sourcecode and documentation you may contact the developer of the system
Patrick Tandoc Sarmiento
09999637980
https://web.facebook.com/ptsarmiento
