Background Unaitas Sacco is one of the leading deposit-taking ...

siberiaskeinΔιαχείριση Δεδομένων

20 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

415 εμφανίσεις

Background

Unaitas Sacco

is one of the leading
deposit
-
taking
Sacco

in Kenya

licensed by SASRA to
operate front office services
. It

has steadily continued to grow
in terms of

membership,
asset base

and operational functions.

Being a financial institution it main functions include
Lending, Deposit taking and Insurance agency.

Currently Unaitas has three main divisions: Business Development
,
Business Support and
Bus
iness Operations and
a network of
fi
fteen branches spread across Nairobi, central and
Rift valley provinces. All branches and functions are interlinked with a
central database
located at

i
ts head office in Murang’a town.

The Sacco uses Bankers R
ealm
®

from craft
silicon as its
main

banking application

and also interlinked with ATMs and Mobile banking

applications.
The Sacco also has HRMIS application
-
DUX ®

from Spasys Ltd and this is
interlinked with

the
Bankers Realm

as well.

The growth of Unaitas has made it operations to be more

and more complex and
necessitated adoption of strategies to ensure efficiency and effectiveness. The Sacco has
also established an audit department whose work includes; determining whether financial
and operating information is accurate and reliable, asse
ss the
effectiveness of
organizations
risk management framework,

Ascertaining compliance with external regulations and
acceptable internal policies and procedures, determining whether the resources are used
efficiently and economically, ensuring that the o
rganizations objectives are effectively
achieved and ensuring effective discharge
of governance responsibilities.

Currently the audit department has been auditing through and around computers most of
the data analyses work being done manually.

The volume a
nd complexity of work has
necessitated a need of Computer Aided Audit Tool (CAAT)) to enhance efficiency and
effectiveness of the audit function.

Objectives of the
CAATs

Unaitas want adopt an
interactive data mining and analyses audit software

that meets the
requirements of risk based auditing standards.


Specifications

The software must comply with the following specifications;

Technical requirements;



Able to support window based platforms,



Allow importation of external document in various for
mats into audit file



Prevent simultaneous updating of audit file



Compatibility
to wide varieties

of
relational databa
ses and data file fo
rmats
.
Compatible with Bankers Realm® and Dux®



Encryption of data files stored in the system to prevent view
ing and edi
ting outside
system



Ability to filter data, integrated report generation capabilities in different file formats
and edit

exception reports generated according to user rights
,



Support access of multiple windows with tree controls to represent hierarchical
data.



Support review of audit files
e.g. keep track of review comments

Usability
Requirements

Ease of use, simple intuitive user forms and c
omprehensive Logging features
.

Provide intensive training and support.

Functional Requirements



Capabilities to
define criteria for data extraction and support extraction of large
volume of data from disparate systems and file formats, select samples,

cross match
data and perform
advanced statistical

data analyses
like Horizontal and Vertical
analyses, trend, variance, Stratifications, Aging, Benford’s Law
as well as data
validation.



Support of advanced searches and filtering capabilities



Facilitate direct access and querying of transaction from various sources



Su
pport data management techniques like;

Append/merge,

calculate fields,

cross
tabulate,

duplicates
,

gaps,

sort

/index,

relate,

create

customized reports and
graphics a well as
process tracking.



Support chart options like; Titles,

3D effects, legends, colour
, patterns and grid
styles.



Ability to Compare and integrate data from disparate systems

Fraud Detection and prevention



Facilitate comparison of data and transaction from separate functional systems.



Calculation of statistical parameters like averages,
standard deviations, highest and
lowest values
,



Stratification of numeric values to identify unusual and outlying values,



Joining and matching of data fields between disparate systems to look for expected
matches or differences in existing data.



“Sound li
ke” functions that identify fraudulent variations of valid data,



Duplicate testing that identify simple or complex combination of duplication



Gap testing that identify missing sequential files.

Other requirement

1.

Provide the clientele base who have been sup
plied with the same software

2.

The owner of the CAAT

and if the owner is not the supplier, the kind of relationship
with the owner and the rights given to supplier.

3.

CAAT hardware requirement