2.1 Preliminary Investigation:
The objective of the project is to
develop Loan Management System for Bangladesh Shilpa Bank, which will maintain
the total system in computerized way and generate required report that are very
essential in every single manner. Beximco Computers assigned this module to me.
One of the major activities of
Bangladesh Shilpa Bank is to provide financial assistance to projects in
different sector for industrialization. From different branches huge amount of
loan information comes to the Loan Department (LD). LD maintains all the
information. At present they are keeping the entire information manually. LD is
using some application software’s like MS Excel, MS Word but the use is very
limited and do not fulfill their all requirements. So the new system will
flexible and time consuming.
project is to develop a computerize Loan management System for BSB, which will automate the process of
scope of the proposed solution contains:
Providing security to the
loan information data.
Minimizing the large
Making calculations easy.
Easy maintains of Data
Reducing the extra
manpower and overhead work.
are some constraint on this project, those are:
the current system is completely manual, making it automated need lot of time by
realizing the existing system. The time limitation is one of the greatest
problems in this regard.
The system will process lots of transaction. So the calculation part must
be reliable as much as possible.
In this organization, there are so many senior employee, who are not
familiar with computerized system and they are not interested to develop a
Most of the employee does not have good knowledge about computer. That’s
why some of there expectations are unrealistic.
It’s a government
organization. So most of the information is scattered.
Functions of the information system:
system function is an activity or process.
The proposed system is composed of the following components:
The loan department keeps detail information about loan. So the key input
for the proposed system will be Loan number, Project information (Id, Name,
Branch), Sanction amount, Disbursement information (Amount, Date), Cycle code,
Interest amount, Repayment information (Amount, Date), Receive information
(Amount, Date), Re-phased information (Old loan no, New Loan no, Debit amount,
Credit Amount) etc. Which comes from the user.
After collecting data, they
classify those data into separate files for each Loan. There are lots of
calculations for every single transaction. If a transaction occur than they
maintain the balance by debiting and crediting. They also perform calculation of
sanction amount, receive amount etc and keep this information in day-to-day
basis report and also create monthly and yearly reports.
Loan Department produces different types of daily, monthly, quarterly and
yearly branch wise reports about How much money is given as loan, How much money
will be received, how much money is received and how much money is left etc.
The system that I have designed is
for network environment. So many user can use this application but the data
storage will in the server pc only. The server pc will contain the database and
the user will use their own password to enter the database from their pc for
In their information system they
try their best to keep accurate data to maintain their standard and level. Also
they provide a facility of data security and changing of data. They always
verify the project’s information. Like they check whether the address or
contact no of project is correct or valid. They also verify the transaction.
They confirm that all the Balances are figured out accurately. They also ensured
that information saved in files is kept consistent by some special naming
system. They also make sure that important files are kept in a secured place.
Methodology is a systematic
description of the sequence of activities required to solve a problem. In other
word, Methodology is a collection of procedure, technique, tools and
documentation aid which helps the system developers in their effort to implement
a new information system.
For the system development, I have
used structured system development – Software Development Process. In system
development I used the Structured Analysis methodology, which is based on
process modeling. Here I used Fact Finding Techniques for requirement analysis.
For process modeling Data Flow Diagram (DFD) was used. My DFD is based on Gene
and Sarson method. I used Entity Relationship Diagram to do Data modeling.
have used the traditional system development technique. For my system
development I have used different phases of system development process:
this Stage I had to perceive the problem and opportunities. I went to the Loan
Department to review existing system. I had to find out initially what the Loan
Department’s activities and problem have been, and whether those could be
resolved through available techniques known to me. Then I established the scope,
preliminary requirement and constraints of the proposed system and project
schedule. I found out that, such proposed system would be possible to make
within given scope and it might be a feasible solution for the company.
At this stage of System Development
Process I studied the existing system and tried to find out the requirements of
the proposed system in details. I found out what is the purpose of the Loan
department’s activity, what are the steps performed in loan department, how,
where, how long and how often are they performed, how great the volume of
transaction, who use the resulting information, what are the constraints, what
is the input of each process and what are the outputs. I found out whether the
proposed system would be feasible or not, what will be user requirements, report
requirements. There are three types of fact-finding techniques-
perform requirement analysis, I used the first two fact-finding techniques.
Interview is a formal meeting where
the analysis can obtain information about the operation of the present system
and the requirement for the new system. This is the most common method used to
verify the proposed system design and gather fact about the procedure. For
interview I went to the Loan department section and asked my selected question
to different employee of that section.
My candidates to be interviewed were senior officer, General Manager and
Deputy General Manager. For the interview purpose I used both structured and
unstructured questions. I used both structured and unstructured questions based on my system. I had to carefully ask
the question so that they must relevant to the interviewee and appropriate to
his level and status. My supervisor and the project manager provided different
kinds of information and requirements during the interview.
Minutes for interview is given in Appendix A at the end.
Record review is to review the documents that represent formal information flow in the organization. Record includes written policy manuals, regulations and standard operating procedures. The loan department is divided into two main section they are the not due section and over due section, both section maintain ledger book to keep regular entry. I reviewed both the ledger book and also reviewed some report, which they produced by Ms Access or Ms. Excel
Not Due Loan Ledger
This ledger book keeps most of the
information of Not Due section. The project name, address, loan no, Amount
sanctioned, Repayment schedule information, Disbursed information all are
recorded in this ledger book. This section maintains one ledger book for one
branch. Same kind of ledger book is used for foreign currency and Taka loan.
Due Ledger Card
ledger Card is used in Over Due Section. All kinds of pay-received information
are recorded in this ledger card like- Principal receive, Other charge receive,
Interest on loan balance, Value date, Transaction date etc.
This is a computerized report, which shows the sections wise balance of amount due. They produce it using Ms. Excel.
This is an annual conformation, which is send to the client. It contains both not due and over due balance of closing date.
Its shows Branch wise Local Currency Disbursement. Ms. Excel is used to generate this report.
Some Record review documents are given in Appendix A at the end.
finishing the analysis part, I started the designing phase of System Development
Process. In this part I used both logical and physical design. For logical
design – I used process modeling by DFD (Data Flow Diagram) and data modeling
by ER-D (Entity-Relationship Diagram). I also used Data Dictionary and Rich
Picture for my design part.
I tried to implement my findings, which I got in System Analysis phase by DFD
and ER-D. How the system would work and how the output will be given was the
main concern at this level. In logical design part-for the-I used Oracle 8i for
the database design and for front-end design, I used developer 6i.
Coding is the heart of software
development. After the designing phase, I got up to coding. For Development of
my project I choose Oracle, as it is very much suitable for building database
applications quickly and effectively. The total project took up 18 windows
After the development of the
software had been finished, it went for testing. There are two types of
testing-White Box and Black Box testing. I had done only Black Box testing for
my software. After testing I found a test report and later on, I fixed those
error according to report. Some new requirements were imposed and enhancement
request was made. My development process was stopped after testing.