TERM PAPER
ON
Information System of Standard Bank Limited
[pic]
Submitted To:

Dr. Md. Mosharraf Hossain
Professor
Department of Management
University of Dhaka

Submitted By:

Sabbir Ahmed
3-11-21-065
Department of Management
University of Dhaka

Date of Submission
09.11.2014

Preface

Theoretical knowledge, what we learn through our academic activities, is not sufficient to prepare ourselves for the life battle. Academic knowing is needed to be backed up by practical experience.
In business studies, besides their usual theoretical course works, students are required to fulfill some practical assignments which are set by the course teachers to examine the depth of knowledge learned by the students. Most of the time, the students are required to study a practical working environment of any organization or industry to critically examine ‘what is actually going on’ in the real world.
This document is prepared as a result of an assignment set by the honorable course teacher of the course “Fundamental of MIS”. .My duty was to describe “Information System of My Organization.” and report what I found. This is how this assignment paper titled “Information System of Standard Bank Limited.” was emerged. I believe this paper is a reflection of accumulation of my effort, learning and dedication.

Letter of Transmittal

November 8, 2014

Dr. Mosharraf Hossain

Professor

MBA (Evening) Program

Department of Management Studies
University of Dhaka Subject: Submission of term paper on Information System of Standard Bank Limited.

Dear Sir,
With due respect, it is my immense pleasure to present the term paper entitled “Information System of Standard Bank Limited.” In the process of preparing the report, I have consulted your hand notes, different referred books and other related papers. I have collected all relevant updated information available over internet. I believe that the objective is going to be fulfilled to your desired level. Obviously, the paper will provide you a clear idea about the organization I work for and the usual practices in it.

Thank you for your sincere support.

Sincerely Yours,
| |
| | |

Sabbir Ahmed
ID# 3-11-21-065
Department of Management Studies,
University of Dhaka

Executive Summary:
In this age when management requires proper flow of accurate information to run an Organization successfully than the banks way of information handling is quite outdated from the view point of sophisticated management information science. Banking sector of Bangladesh is playing an important role in the socio economic situation of the country. There are large numbers of banks operating for many years in Bangladesh successfully. Today, most of these banks are now automated. So now days to operate their activities and operations efficiently and effectively, Banks are using latest technologically improved and updated banking solution soft-wares or ERP (Enterprise Resource Planning) system. ERP system also helps to provide effective and quick services to the bank’s customer’s .ERP- three letters that represent, a system that is multiple in scopes, tracks a range of activities including finance, management, accounting, MIS and human resource systems. It is integrated, when data is added in one area, information in all related areas and functions also changes. An ERP system is modular in structure. The system provides industry specific solutions that enhance standard systems by providing best practices for key business processes. That’s why we took the opportunity to know about the ERP system of the “STANDARD BANK LIMTED Limited.”. We had the opportunity to study into the procedures of Information Technology Management of STANDARD BANK LIMTED. Therefore, we will be describing in this report about the ERP system of STANDARD BANK LIMTED specifically about their computing resources, banking solution and processing systems, TPS and MIS activities, business processes, supply chain management system, database management system, security and control. The deliberation of this report is impounded in exploring and explaining ERP system of banks in Bangladesh. So our report will be a combination of different aspects of the banking activities and operations rely on information technology under general banking activities and a comprehensive view on IT division’s ERP system usages.

Content • INFORMATION SYSTEM IN AUTOMATION OF STANDARD BANK LIMTED

• ORGANIZATION COMPUTER RESOURCE

• ORGANIZATION TRANSACTION PROCESSING SYSTEM

• DATABASE MANAGEMENT SYSTEM

• Data Application Development Features

• Database Connection Features

• Distrusted Database Features

• Backup and Recovery

• NETWORKING SYSTEM

• CONCLUSION

INFORMATION SYSTEM IN AUTOMATION OF STANDARD BANK LIMTED:
STANDARD BANK LIMTED limited has implemented Centralized online Banking system in the year 2004 through its developed software. The bank will also extend services to its customers through internet Banking and mobile phone bank phase wise shortly. The bank has developed Islamic Banking Software and 2 (two) Islamic banking wings has been opened in Dhaka and Chittagong . The bank has entered into the internet world through its website www.standardbankbd.com and has also been operating automated trailer machine (ATM) and Point of sale (POS) services to meet the demand at the time.

ORGANIZATION COMPUTER RESOURCE:
Software resources: • MICROSOFT OFFICE 2007

• ASP.NET

• Oracle 09 Developer

• Oracle 10g

System Software’s:

• Windows XP

• Windows Server 2000

External Hardwires: • Personal computers • Document scanners • Printers • Networking cards • Currency counter • Coin counter

Attributes of server:

• ASP.NET

• Auto clear

• Batch

• SQL SERVER

• Cake PHP

• RMAN online backup system

• BO (Business Objective) Server

ORGANIZATION TRANSACTION PROCESSING SYSTEM

TPS OF SBL
A transaction processing system (TPS) is a type of information system. TPSs collect, store, modify and retrieve the transactions of an organization. A transaction is an event that generates or modifies data which is stored in an information system. Also transaction processing system or transaction processing monitor monitors the transaction programs which are special type of programs. The advantage of transaction processing program is that it manages data or information that must be left in a consistent state. The transaction processing system of STANDARD BANK LIMTED is working efficiently and effectively which offers the enterprise or management the means to process transactions rapidly to ensure the smooth flow of data and progression of process throughout the organization.

Payroll TPS
The payroll TPS of STANDARD BANK LIMTED is designed and created to gain and collect information and record of the employees and then calculate his or her annual earnings. It collect the information about the employees from the employee’s respective departments and from general ledger and send it to the payroll TPS from where it links that information with the previous record and then prepares a report which is then forwarded to the management. Management takes the notice the “LN” record of the employee’s efficiency to work and may declare extra bonus added or other form of incentives. This report is checked and approved by the branch manager after which check is issued to the employees. When that check is cashed, the record is updated in the general ledger as well as the master payroll (HUB).

Employees’ Record
All employees are supposed to login to the system of bank when they enter into the bank and logout on leaving, by tracing their thumb impressions on biometric device. This device is connected with the HUB which continuously makes record of employees hour spent in the bank. Moreover, the bank has their own setup which makes records of all the transactions made by an employee. Thus help management to monitor the working efficiencies and effectiveness of employees.

Customer Identification
STANDARD BANK LIMTED has their own information management software which is connected to Oracle 10 database. So if any new client wants to open an account the system will automatically send a request to the Oracle 10 G database to check and verify the customer ID number.

DATABASE MANAGEMENT SYSTEM
STANDARD BANK LIMTED uses Oracle Database 10g as their primary DBMS. Oracle Database 10g enables grid computing which is simply a pool of computers that provides needed resources for applications on an as-needed basis. It’s a Hybrid Object-Relational Database. Oracle Database 10g further reduces the time, cost, and complexity of database management through the introduction of self-managing features such as the Automated Database Diagnostic Monitor, Automated Shared Memory Tuning, Automated Storage Management, and Automated Disk Based Backup and Recovery. Below is some key feature of the DBMS:

Data Application Development Features:
Oracle 10g allows application development. Programmers can use SQL to create database applications. Moreover the DBMS also has a procedure language extension to SQL (PL/SQL). It also permits the use of object oriented programming and 3G programming languages (JAVA, C, C++ etc.).

Database Connection Features:
The database connection is responsible for supporting all communications between an application and the data it uses. Database users connect to the database by establishing a network connection using Oracle Net. Oracle’s Connection Manager reduces the number of Oracle Net client network connections to the database through the use of concentrators, which provide connection multiplexing to implement multiple connections over a single network connection.

[pic] Figure: Concentrators with Connection Managers for a large number of users.

Distrusted Database Features:
Data within an organization is often spread among multiple databases for reasons of both capabilities and organizational responsibility. Distributed queries can retrieve data from multiple databases. Distributed transactions can insert, update, or delete data on distributed databases. Background recovery processes can ensure database consistency in the event of system interruption during distributed transactions.

Data Warehousing and Business Intelligence:
Oracle 10g also has data warehousing feature. The DBMS has stored bitmap indexes to provide a fast way of selecting and retrieving certain types of data. Oracle also has optimized star query by introducing parallel bitmap star join, which uses bitmap indexes on the foreign keys to the dimension tables to speed star joins involving a large number of dimension tables. It has ANSI standard OLAP SQL analytic functions for windowing, statistics, CUBE and ROLLUP, and much more. Data mining applications are typically custom built using Oracle’s J Developer with DM4J.

Backup and Recovery:
Oracle 10g database’s integrated recovery platform is Recovery Manager (RMAN). Typical backups include complete database backups (the most common type), table space backups, data file backups, control file backups, and archived redo log backups. RMAN can perform incremental backups which back up only the blocks modified since the last backup of a data file, table space, or database; thus, they’re smaller and faster than complete backups. RMAN can also perform point-in-time recovery, which allows the recovery of data until just prior to an undesirable event (such as the mistaken dropping of a table).

Database Availability:
Oracle introduced partitioning as an option to provide a higher degree of manageability and availability, which can insure only legitimate users, can view specific data.

NETWORKING SYSTEM

[pic]

Figure: Overall Information flow of STANDARD BANK LTD.

CONCLUSION:
This is well established statement that practical situation always differ from Theoretical explanation. As a private bank SBL is trying to extend their service to the public. A very working environment is remaining in the SBL all Branches. The present customer dealing procedure is quite well at moment. The computerized transaction makes the system efficient and effective. They should also create and increase ATM booth, training to staff, give more attractive product etc. which may create a good result for their overall performance.