Portfolio Management
The application is to manage customer’s transaction in a small finance house; it should track customer details, investments
such as fixed deposit and loan.please find the requirements below. Kindly provide me with a detail proposal, system
requirements and deliverables to deliver.
Note: For customers to caryyout any transaction with the finance house, his or her details must have been captured and stored
in the company database. Such information are:
*Title (Mr, Mrs, Miss, Dr, etc), *Gender (Male or Female), *Branch Office, *FirstName, Middle Name, *Surname, Date of Birth,
Marital Status (Single, Married, Divorced, Separated, Window), Residential Address (street, city, state) Mailing / Postal
Address (street, city, state), Telephone Numbers (office Telephone-1, Home Telephone-2), fax number, mobile number, email,
nationality, preferred means of contact (post, email, phone/sms) next of kin (title, gender, relationship, first name, middle
name, surname, date of birth, email, office telephone, home telephone, mobile number.
Application Process
Customers can either apply online or fill and submit paper application to open an account with the finance house. If online,
customers fill application from the company secure site online, attached all the necessary forms (such as customer reference
form, signatory form and passport photograph), and submit application. If application is filled on a paper form and submitted
to customer care officer, who inturn fill all the details into the application and attach scan copies of necessary forms into
the application and submit.
Once submitted, application details are automatically stored on company database (on internal network), and alert the
administrative officer via SMS and email of applications awaiting his or her review.
The administrative officer logon to the application, and he or she is automatically taken to his or her inbox. Once the
administrative officer clicks on a particular customer’s application, the details of the application is open up to the
administrative officer for her/his review. The administrative staff can either accept the application by clicking the accept
checkbox or put the application onhold. If acepted, an SMS and email is automatically sent to the applicant that application
is under review, If on-hold, administrative officer shall enter a comment into the application to alert applicant of action
to be taken for his/her application to be processed.
Once the application is accepted, the administrative staff shall assign a routing code to the application for review of the
applicant application. The application is then routed to the next reviewer (Account Officer).
Account officer reviews the application and the application is routed to the next reviewer (supervisor or manager).
Upon the manager or supervisor’s approval, the application automatically generate account number for the applicant and an SMS
and email is automatically sent to the applicant for collection of his/her account number.
Note: Routing code should be configured and generated in a central location by the administrator, and assign to application
by administrative staff. By default, after submission of application by applicant or customer care officer, it should go
straight to administrative officer inbox.
When application is routed for review, it should notify reviewers via SMS and email of application awaiting their review.
Reviewer should have the capability to delegate to other personnel for review and should be able to add or attach comments
Applicant should have the capability to check status of application online, an application code is generated online or
assigned by customer care if paper application is submitted. The code shall be used to track status online.
The application should store customer forms in a folder structure like window explorer, and all form should be associated to
the customer accounts. Attached forms should have reference title and numbers assigned to each form and arranged
alpabetically.
User’s should have the capability to search for customer details through account number, or last name and first name. But
only authorized users should be allow to view customers details and attached forms.
Loan Process.
Customers can apply for loan, once he/she has an account with the finance house. Application can either be submitted online
or through customer care officer by submitting a paper application.
The application should carry the following:
Loan details:
Customer Type of Account (Joint or Individual)
Account Number & Account Name
Type of loan (Individual, Corporate, Others)
Amount requested
Interest Rate (this is base on type of loan, it is automatically display after selecting type of loan).
Number of months (periods)
Payment frequency (Monthly, Quarterly, Yearly)
Payment month (start month for repayment)
Payment month due
Purpose of loan
Equity Contribution
Management Fee
Arrangement Fee
Maximum Monthly debt burden
Age at expiration of loan
Documentation to be supplied by applicant are: Proof of Income, Employeer’s confirmation letter, bank account statements,
register title of property, proof of date of birth.
Applicant details:
The application will move to the next page for applicant to fill his/her details as follows:
i. employer/self employed.
ii. position.
iii. years employed.
iv. employer’s address.
employer’s contact.
v. salary per month.
vi. Previous employer.
vii. Position.
viii. years employed.
ix. previous employer’s address
Collateral details:
The application will move to the next page for applicant to fill collateral details as follows:
i. address
ii. year built
iii. date purchased
iv. present value
v. balance owing
vi. title in names of
vii. address of title holder
viii. name and address of insurance carrier.
5. ASSET & DEBT INFORMATION
The application will move to the next page for applicant to fill ASSET & DEBT INFORMATION details as follows:
ASSETS OWNED
DESCRIPTION OF ASSETS NAME IN WHICH THE ACCOUNT IS CARRIED VALUE
CHECKING ACCOUNT NUMBER(S)
SAVINGS ACCOUNT NUMBER(S)
CERTIFICATE OF DEPOSIT(S)
MARKETABLE SECURITIES( issuer, type, no. of shares)
REAL ESTATE(location, date acquired)
LIFE INSURANCE(issuer, face value)
AUTOMOBILES(make, model, year)
OTHER
TOTAL ASSETS
Once the application is completed online, and applicant have attached all the necessary documents and click ok, The
application should calculate amortization base on these parameters: Amount, Interest, periods, and payment frequency. once
the applicant click submit, this detail should be stored in the company database.
The credit unit staff assigned to receive applications, automatically receive alert via SMS or email of application awaiting
his or her review.
The review process is same as above.
Report shall be in portrat and landscape.
The application should be developed with Visual studio 2008 (VB.net) and SQL Server 2005. Please note that client does not
have the resources for sharepoint.
The application shall interface with other applications.
Kindly provide a detail proposal to capture your deliverables and system specification including sample screen shot.
I would appreciate your prompt response so as to agree on the cost and proceed to executing the project.
Related Projects
Comments
Email Subscriptions
-