Learn Uttara Bank Computer Application Legal Procedures Guide

view with charts and images

A Term Paper on The Computer’s Application in Uttara Bank Limited

Introduction

Uttara Bank Limited is one of the largest and oldest private-sector commercial bank in Bangladesh, with years of experience. Adaptation of modern technology both in terms of equipment and banking practice ensures efficient service to clients. 207 branches at home and 600 affiliates worldwide create efficient networking and reach capability. Uttara is a bank that serves both clients and country.

• UBL is one of the largest private banks in Bangladesh.
• It operates through 207 fully computerized branches ensuring best possible and fastest services to its valued clients.
• The bank has more than 600 foreign correspondents world wide.
• Total number of employees nearly 3,562.
• The Board of Directors consists of 13 members.
• The bank is headed by the Managing Director who is the Chief Executive Officer.
• The Head Office is located at Bank’s own 18-storied building at Motijheel, the commercial center of the capital, Dhaka.

Organizational Hierarchy

$

$

$

$

$

$

$

$

$

Activities of Uttara Bank Limited

From the beginning,Uttara Bank Ltd. is working relentlessly for the development of our economy and for the betterment of the shareholders. The bank gives different types of services and earns profit. The activities of Uttara Bank Ltd. are given below:

Deposits:

The bank collects deposits to create fund for investment. In the prevailing situation mobilizing of deposits had become very competitive and as a result the average cost of fund of the bank in private sectors had increased compared to the previous year. The bank has given stress on procurement of low cost fund including cost free funds for bringing down the average cost of fund. The bank’s different types of deposits are as follows:

1) Current and other deposits.

2) Savings bank deposits.

3) Monthly profit scheme.

4) Fixed or term deposits.

5) Pension savings Prakalpa.

6) Bills payable account.

7) Others.

Loans and Advances:

The bank’s another major function is to provide loans and advances to different sectors. The bank earns a lion’s share of revenue from providing loans and advances. The advance portfolio of the bank is well diversified and covers funding to a wide spectrum of business and industries including agro-based and agro processing, paper and paper products, chemicals, constructions, real estate and loans under consumers’ credit schemes, various trading business, service holder’s loan and women entrepreneurs of the country.

Special Schemes:

Other than the normal banking business the bank has the following special schemes:

1) Small and medium scale entrepreneurs credit scheme.

2) Scheme for loans to employees.

3) Loan scheme for women entrepreneurs.

4) Customers credit scheme.

5) Pension deposit scheme for small saver.

6) Monthly deposits and profit scheme.

7) Interest free deposits.

8) Lifetime savings scheme.

Recovery:

The bank has a huge amount of bad loan. These loans have no security, even no proper record of particulars of borrowers. As a result, recovery of these loans has become a very difficult job. The bank works hard to collect these bad loans.

International Trade:

The International Trade constitutes a significant business activity conducted by the bank. The bank earns a handsome amount of revenue from International Trade Business.

Guarantee Business:

The bank also earns revenue from Guarantee Business. The guarantees are issued in favour of different Govt. authorities, Autonomous bodies, Corporations, Multinational Companies etc. against proper securities on behalf of the clients of the Bank.

Investment:

The bank has always given emphasis on investment of funds in high yield areas and maintains Statutory Liquidity Requirement (SLR) as fixed by Bangladesh bank. The portfolio of investment included Govt. Treasury Bills, Prize bonds, Shares in Public Limited Company etc.

Computer Application in Uttara Bank Limited

Uttara Bank Limited is one of the private sector banks having wide network of branches in the country .In 2007 the bank further expanded its operational network by opening six new branches ,bringing the total number of branches to 207. All the branches of the bank are operating under computer network using the bank’s own software and manual banking system in day to day banking. Above all in order to ensure speedy services in International business E-mail is in operation in Head office and in almost all branches. At present International division of Head office and 38 branches is under SWIFT operation. As a result the bank has been able to transmit letter of credit, fund and message instantly throughout the world at low cost. In accordance with the demand of the day shifting of branches to the newly decorated premises in more important and commercially potential places, renovation and decoration of old branches with modern amenities are also being continued. Bank has introduced its own web site the address of which (Address) is: www.uttarabank-bd.com.

Web Site of Uttara Bank Limited

Web site of Uttara Bank Limited is much more informative but some links do not work. Such as, online banking, ATMs, card services, locker services etc .This bank should introduce these services and activate these links as soon as possible.

Software of Uttara Bank Limited

Uttara Bank Limited does not use any own made or purchased software to provide prompt services to the customers. But most of the commercial banks use software where they manage their customers’ accounts easily, accurately and automatically. At this competitive situation, Uttara Bank Limited should purchase any software. Such as, PC Bank 2000. It will accelerate this bank’s services and help the bank to grow its market share and get high relative competitive position.

Online Banking in Uttara Bank Limited

Uttara Bank Limited does not give online banking facility considering its huge number of branches (207)surrounded all over the country .But, most of the commercial banks give online banking facility in spite of having more branches. So, Uttara Bank Limited should introduce online banking facility as early as possible to give prompt service and compete with other banks.

Deficiencies Considering Online Banking

Online banking means the performance of banking activities via the Internet. Uttara Bank Limited does not give online banking facility .So, it has following deficiencies considering online banking services:

1. Paying Bills Online:

Customers can use online banking to pay their bills. This will eliminate the need for stamps and protect them from the check being lost in the mail. Most banks will have a section in which they set up payees. Customers will need to fill out the information once, and then they can simply choose that profile every time they pay a bill online. Uttara Bank Limited does not give this service preferring manually paying the bills (gas, electric, water, cable, phone, and other utility-type bills).

2. Viewing Transactions:

Online banking allows customers to access their account history and transactions from anywhere. This is the quickest way to check and see if a transaction has cleared account. This can help customers to find out the amount of a transaction after they have lost their receipts. It also allows finding out about unauthorized transactions more quickly. This can help customers to resolve the issues more quickly. Uttara Bank Limited does not give this service.

3. Transferring Money between Accounts:

Online banking also allows customers to transfer money between accounts much more quickly. It is more convenient than using the automated phone service, and can save customer a trip to the bank. Uttara Bank Limited does not give this service.

5. Continuous Transactions:

Unlike customer corner bank, online banking sites never close; they’re available 24 hours a day, seven days a week and they’re only a mouse click away which is not possible for Uttara Bank Limited.

6. Ubiquity:

If customers are out of state or even out of the country when a money problem arises, they can log on instantly to their online bank and take care of business; 24/7.Uttara Bank Limited does not have this facility.

7. Transaction speed:

Online bank sites generally execute and confirm transactions at or quicker than ATM processing speeds. So, Uttara Bank Limited has transaction speed for its manual banking system.

8. Effectiveness:

Many online banking sites now offer sophisticated tools, including account aggregation, stock quotes, rate alerts and portfolio managing programs to help customers manage all of their assets more effectively. Most are also compatible with money managing programs such as Quicken and Microsoft Money. So, Uttara Bank Limited is backward from these modern services.

So, Uttara Bank Limited should save time and money by taking advantages of online banking. It must need to introduce online banking to compete with other banks effectively and efficiently.

Database of Uttara Bank Limited

Uttara Bank Limited does not maintain any database for its employees, customers etc. So, data are not maintained in a systematic way. They can not show enough data together to anybody at any time. They can create and maintain database using Microsoft Access easily which may be very much helpful for their operations. We have created central database and other additional database for Uttara Bank Limited according to the segregated data we have got from the bank.

Central Database of Uttara Bank Limited

Uttar Bank Limited can maintain central database in MS Access. We have prepared a central database for Uttara bank Limited based on corporate information.

Corporate Information – 2007

Date of Registration 3/26/1972

Authorized Capital 1000000000

Paid-Up-Capital 399329600

Total Capital 2746737827

Total Asset 52860332730

Total Deposit 43586356057

Total Loans & Advances 28477407266

Profit after tax & Provision 409535557

Branches 207

Tatal Officers & Staffs 3,562

Foreign Correspondents 600

Members of Board of Directors 13

Face Value of Share 100.00

Employee Table

A table is a collection of data about a specific topic, such as employees or contacts. Using a separate table for each topic means that we store that data only once, which makes our database more efficient, and reduces data-entry errors. We have created employee table using the data of all employees of Uttara Bank Limited, Shyamoli Branch, Dhaka.

Query of Employee

As tables grow in size they can have hundreds of thousands of records, which makes it impossible for the user to pick out specific records from that table. Queries were designed to combat this problem. With a query we can apply a filter to the table’s data, so that we only get the information that we want. We have created query on employee table of Uttara Bank Limited, Shyamoli Branch, and Dhaka. . This query can be run by the help of fields such as Employee ID, Designation, Mobile Phone, Address, Country/Region etc.

Form of Employee

A form is nothing more than a graphical representation of a table. We can add, update and delete records in our table by using a form. Although a form can be named different from a table, they both still manipulate the same information and the same exact data. Hence, if we change a record in a form, it will be changed in the table also. A form is very good to use when we have numerous fields in a table. This way we can see all the fields in one screen, whereas if we were in the table view (datasheet) we would have to keep scrolling to get the field we desire. We have created form of employee table.

Report of Employee

A report is an effective way to present data in a printed format. Because we have control over the size and appearance of everything on a report, we can display the information the way we want to see it. We have created report on employee table.

Employee Salary Table

A table is a collection of data about a specific topic, such as employees or contacts. Using a separate table for each topic means that we store that data only once, which makes our database more efficient, and reduces data-entry errors. We have made employee salary table with the data of employee salary.

Query of Employee Salary

We create a query on employees salary by this employees can easily find any kinds of information about the employees salary. This query is run by the help of criteria such as employee’s Name, Designation, Basic, Total Allowance, Total Reduction Net Salary etc. If they want to get all the information about the employees of that branch together they can find it by the help of query using run command in standard tool bar in query sheet.

Form of Employee Salary

Microsoft Access forms provide a quick and easy way to modify and insert records into database. It offers an intuitive, graphical environment easily navigated by anyone familiar with standard computer techniques. Creating a form is a quite simple, pleasant experience. We have created form of employee salary.

Report of Employee Salary

Employee report represents one of the most important ways of presenting the data in database. Report can incorporate data from multiple tables and can be formulated in wide variety of ways. The report can represent all the information in a systematic manner. Thus every one can understand the database easily. Anyone can use the employees report for their consideration. This report is easy to print out. That’s why; we made a report in Microsoft Access for the employees of Uttara Bank, Shaymoli branch, Dhaka.

Employee Salary Report

Name Designation Basic pay Total allowance Total Reduction Net Salary

Md. Mizanur Rahaman Manager 18300 17500 15695 20105

Md. Reaz Uddin Ahmed P.O 14450 13000 9750 17700

Mrs. Afroza Khatun P.O(2nd officer) 12500 13000 4865 20634

Md. Fazlur Rahaman OG-I 9650 9600 16100 3150

Md. Anisur Rahaman OG-I 9100 9600 2445 16255

Md. Shamsul Islam OG-I 9650 9600 2360 16890

Sk. Mehebub Hasan OG-I 8000 9600 835 16765

Md.Sayedul Islam OG-I(Cash) 9100 9850 4945 14205

Ms. Fatema Shahanaz A/O (Gen) 5625 7675 588 11712

Faisal Ahmed Chy. OG-II 7500 7900 3815 11585

Msmir Akter OG-II 6300 7180 655 12825

Ms. Sanwa Khandaher A/O (Gen) 5625 6975 588 11712

Ms. Sharmin Akter A/O(Cash) 5500 6900 575 11725

Md. Abdul Bashar A/O(Cash) 5000 6900 575 11725

Md. Tafsir Uddin SK A/O(Cash) 6000 6700 10595 2105

Md. J.Uddin Sardhar A/G 5100 5660 2905 8155

Md. Hossenuzzaman A/G 5100 5660 7245 3815

Ms.Nusrat Jhhan Chy. Money Sorter 3250 4050 1360 6240

Borrower Table

A table is a collection of data about a specific topic, such as employee or contacts. Using a separate table for each topic means that you store that data only once, which makes your database more efficient, and reduces data-entry errors. We have prepared borrower table.

Query of Borrower

Query can be used to separate some data and present these data quickly. We have created query on borrower by which employees can easily find any kind of information about the borrowers. This query is run by the help of fields such as IBP No., Issuing date, IBP amount in taka, Maturity date, Name of the borrowers, Days of interest, Rate of interest, Amount of interest. If they want to get all the information about the borrowers of that branch together they can find it by the help of query using run command in query sheet at standard tool bar.

Form of Borrower

A form is very good to use when you have numerous fields in a table. This way you can see all the fields in one screen, whereas if you were in the table view (datasheet) you would have to keep scrolling to get the field you desire.

Report of Borrower

Borrower report represents one of the most important ways of presenting the data in database. Report can incorporate data from multiple tables and can be formulated in wide variety of ways. The report can represent all the information in a systematic manner. Thus, every one can understand the database easily. So, we have prepared a report for the borrower as follows:

Borrower Report

IBP No 37/08

Name of The 3S Accessories

IBP Amount in 534898.00

Amount of Interest 6679

Issuing Date Maturity Date Days of interest Rate of Interest

19/02/09 19/06/08 31 14.50%

IBP No 40/08

Name of The M. H. Enterprise

IBP Amount in 483647.00

Amount of Interest 6039

Issuing Date Maturity Date Days of interest Rate of Interest

09/01/08 07/05/08 31 14.50%

IBP No 42/08

Name of The Zerintex

IBP Amount in 412056.00

Amount of Interest 5145

Issuing Date Maturity Date Days of interest Rate of Interest

21/01/08 20/05/08 31 14.50%

IBP No 464/07

Name of the Endeavor Fashion

IBP Amount in 369806.00

Amount of Interest 4617

Issuing Date Maturity Date Days of interest Rate of Interest

11/10/07 11/04/08 31 14.50%

IBP No 505/08

Name of The Amin Embroidery

IBP Amount in 316218.00

Amount of Interest 3948

Issuing Date Maturity Date Days of interest Rate of Interest

03/02/08 01/06/08 31 14.50%

IBP No 51/08

Name of the Digonto Printers

IBP Amount in 1606854.00

Amount of Interest 20063

Issuing Date Maturity Date Days of interest Rate of Interest

14/02/08 06/06/08 31 14.50%

IBP No 510/08

Name of the Dhaka Needle Crafts

IBP Amount in 159833.00

Amount of Interest 1996

Issuing Date Maturity Date Days of interest Rate of Interest

31/01/08 28/05/08 31 14.50%

IBP No 521/05

Name of The New Nice Fashion

IBP Amount in 276567.00

Amount of Interest 3453

Issuing Date Maturity Date Days of interest Rate of Interest

10/02/08 16/04/08 31 14.50%

IBP No 523/08

Name of The Adnan Fashion Ltd

IBP Amount in 122424.00

Amount of Interest 1529

Issuing Date Maturity Date Days of interest Rate of Interest

19/12/07 19/04/08 31 14.50%

IBP No 53/08

Name of The Amin Embroidery

IBP Amount in 331610.00

Amount of Interest 4141

Issuing Date Maturity Date Days of interest Rate of Interest

26/02/08 25/06/08 31 14.50%

IBP No 542/07

Name of the Jaya Accessories

IBP Amount in 312862.00

Amount of Interest 3906

Issuing Date Maturity Date Days of interest Rate of Interest

28/01/08 22.05.08 31 14.50%

IBP No 56/08

Name of the Endeavor Fashion

IBP Amount in 434895.00

Amount of Interest 5430

Issuing Date Maturity Date Days of interest Rate of Interest

11/12/07 11/06/08 31 14.50%

IBP No 572/07

Name of the 3S Accessories

IBP Amount in 948625.00

Amount of Interest 11845

Issuing Date Maturity Date Days of interest Rate of Interest

14/02/08 13/05/08 31 14.50%

IBP No 583/07

Name of the 3S Accessories

IBP Amount in 289042.00

Amount of Interest 3609

Issuing Date Maturity Date Days of interest Rate of Interest

30/01/08 29/05/08 31 14.50%

IBP No 586/07

Name of the Iris Corporation

IBP Amount in 482952.00

Amount of Interest 6030

Issuing Date Maturity Date Days of interest Rate of Interest

29/01/08 24/06/08 31 14.50%

IBP No 59/08

Name of the Fair Design

IBP Amount in 1460292.00

Amount of Interest 18233

Issuing Date Maturity Date Days of interest Rate of Interest

19/02/08 16/06/08 31 14.50%

IBP No 591/08

Name of the Adnan Fashion Ltd

IBP Amount in 162836.00

Amount of Interest 2033

Issuing Date Maturity Date Days of interest Rate of Interest

17/02/08 12/06/08 31 14.50%

IBP No 70/08

Name of the M. H. Enterprise

IBP Amount in 980725

Amount of Interest 12245

Issuing Date Maturity Date Days of interest Rate of Interest

09/01/08 07/05/08 31 14.50%

IBP No 79/08

Name of the Amin Embroidery

IBP Amount in 129217.00

Amount of Interest 1613

Issuing Date Maturity Date Days of interest Rate of Interest

19/12/07 19/04/08 31 14.50%

IBP No 84/08

Name of the S. S. Accessories

IBP Amount in 749840.00

Amount of Interest 9363

Issuing Date Maturity Date Days of interest Rate of Interest

14/01/08 11/05/08 31 14.50%

IBP No 89/08

Name of the Vision Embroidery

IBP Amount in 220889.00

Amount of Interest 2758

Issuing Date Maturity Date Days of interest Rate of Interest

24/01/08 24/05/08 31 14.50%

Worksheet of Uttara Bank Limited

Uttara Bank Limited does not maintain any worksheet to analyze data, create financial statements, transaction register, business forecast etc. But it can easily and quickly maintain these in Microsoft Excel using several functions and formulas. We have prepared worksheet for Uttara Bank Limited according to the data we have got from the bank.

Financial Health Worksheet

We have created a worksheet based on total financial health of Uttara Bank Limited and shown percentage change considering previous and current year. Here, we have used two formulas, = (C4-D4)/D4 and =E4*100 to do our calculation promptly.

Employee’s salary Work Sheet

Uttara Bank Limited in Shaymoli branch has eighteen employees and they maintain their salary sheet in manual system. But they can maintain it in computer system by using Microsoft Excel. It will accelerate their activities reducing the time of calculation frequently with the touch of automation. This work sheet will much more reliable too. Enormous calculation can be easily maintained. It also decrease the paper cost. So, we have prepared worksheet on salary for employees of Uttara Bank, Shaymoli branch, Dhaka.

Total Salary Worksheet

We have prepared total salary worksheet on the basis of salary data of Uttara Bank Limited, Shyamoli Branch, Dhaka.