FINA Overview

1. INTRODUCTION

In response to the need for better bank supervision systems a state-of-the-art information management system was developed for Bank Supervision Authorities called FINA. FINA is the system to collect data from banks, store them in the data base and generate different reports using very flexible report designer tools.

The advances of the FINA are:

  • FINA is fully customizable and localizable system at user level; it is independent of any legal, regulatory, or accounting framework. Changes in input/output forms does not require additional programming and can be implemented into system very quickly with any staff who knows spreadsheet functions.
  • FINA is platform independent and works on Windows, Linux, AIX and Solaris.
  • FINA is database independent. It supports 4 main data base systems -MSSQL, Oracle, DB2 (earlier version) andMySQL.
  • FINA is 3 tire java application and this makes it scalable and extendable.
  • System has very low software/hardware requirements. It works on any Computer (IBM or MAC compatible) higher than Pentium 2/200MH, on any OS supporting Java Virtual Machine (Windows, UNIX, etc.) and on any IP based network.
  • FINA is open source under the GNU/GPL license. All components used in the system are free and does not require license fees.
  • Main outputs from FINA system are : UBPR (Uniform Bank Performance report), CAEL/CAMEL, Early Warning Systems, Trends/Time Series.
  • FINA is implemented and tested in 4 Central / National banks in the countries of Georgia, Kyrgyzstan, Tajikistan and Azerbaijan. Currently being implemented in San Marino.

2. MAIN CONCEPTS

Main idea of the FINA project is to build customizable system. Functionality of all central banks and supervisory agencies are very similar: data collection from banks, checking, storing to data base and then designing/generating of different reports.

Returns submitted by banks (call reports, supervisory forms, statistical data, etc.) being changed time by time based on changes/additions in regulations or new business requirements. Therefore we decided to built the system which should be flexible and easy changeable. This was achieved by the concept of the Meta Data Tree. Any table can be described as hierarchical data structure called Meta Data Tree.

Output reports also could be changed very often. To capture those changes into the system FINA has Report Designer. It is very flexible and easy to use tool. Meta Data Tree and Report designer makes FINA easy changeable and customizable system.

FinA can be translated into any language. To configure FinA for another language user has to complete the following three procedures: a) Create locale. B) Create/Translate message bundle and c) Translate Menu/Meta Data Tree.

The User Manager organizes the roles and users with access rights. Each user can have original permissions or can be member of the group (role) and inherit all predefind permissions. User management can be organized based on physical units and/or on logical groups.

3. SYSTEM ARCHITECTURE

Three Tire Architecture

FINA is 3 tire java application:

  • Client Side – Java Application and/or Web Interface
  • Server Side – Jboss (or Oracle App. Server, Bear WebLogic, etc)
  • Data base – My SQL, MS SQL, ORACLE, DB2

Security

The default implementation of the JBoss security framework is based on the JAAS API. The JAAS 1.0 API consists of a set of Java packages designed for user authentication and authorization. It implements a Java version of the standard Pluggable Authentication Module (PAM) framework and compatibly extends the Java 2 Platform’s access control architecture to support user-based authorization. JAAS authentication is performed in a pluggable fashion. This permits Java applications to remain independent from underlying authentication technologies. More details about JAAS API you can find

FINA Hardware Requirements

APPLICATION & DATABASE SERVER(s)

This is an estimated minimum required for the application server’s files and database containing one year worth of data typical for a small size banking system. In such environment FinA Database Server and Application Server can be installed on same machine. The amount of RAM and CPU speed to adequately run the FinA database is highly dependent on the amount of data being processed and should be estimated during the capacity planning phase. See minimum and recommended specifications below:

Requirement

Minimum

Recommended

CPU

AMD/Celeron/Intel 1.0 MGH +

Two 4-Core Intel® Xeon®

RAM

8 GB

32 GB

HDD

200 GB HDD

500 GB RAID 10 with 5(+) x 15 rpm or SSD HDDs

NIC

1 Mbps+

1 Gbps

Monitor/Screen

1024x768 +

1280 x1024 +


For minimum and recommended configurations see also useful links below:
  1. Microsoft® SQL Server (MS SQL Server):http://www.microsoft.com/sql/default.mspx
  2. Oracle® Database (Oracle):http://www.oracle.com/database/index.html
  3. MySQL:http://www.mysql.com
DCS | Data Collection Server(s)

Requirement

Minimum

Recommended

CPU

AMD/Celeron/Intel 1.0 MGH +

Two 4-Core Intel® Xeon®

RAM

6 GB

16 GB

HDD

100 GB HDD

500 GB +

NIC

1 Mbps+ (DMZ)

100 + Mbps (DMZ)

Monitor/Screen

1024x768 +

1280 x1024 +


DCS server has to be installed in DMZ

CLIENT WORKSTATION

Requirement

Minimum

Recommended

CPU

1 GHZ

2 + GHZ

RAM

2 GB

4 + GB

HDD Free Space

1 GB

10 GB

NIC

1 Mbps

1 + Gbps

Monitor/Screen

SVGA 1024x768

1280 x1024 +

FinA Administrator skills Requirements
  1. System Administrator [sadmin] - In order to install, configure, and maintain FinA, the designated FinA Systems Administrator should have qualifications and experience in the following areas:

    • OS: MS Windows | Linux | Solaris | AIX based on policy ;
    • Database server: Oracle | MS SQL Server | MySQL based on policy.
    • LAN administration and Security Management: Firewalls, Switches, etc.
    • Java : Preferable, but not obligatory;
    • Language skills: English Intermediate or higher;

    Functional Administrator [fadmin]: Supervisor with advantage skills of Spreadsheet, Concept of the Relational database and basics of OS management. Fadmin should have qualifications and experience in the following areas:

    • Good knowledge of the financial reporting forms;
    • Good knowledge of output reports: UBPR, Early Warning systems, Stress Test Models and other reports used in Central Bank;
    • Spread Sheet: Advanced knowledge of Excel | OpenOffice.org calc;
    • Language skills: English Intermediate or higher;

    ProjectCoordinator: Is all hands specialist who has to coordinate and manage all tasks. In some organizations PC is from IT department with some experience in supervision, in others - it is supervisor with advantage knowledge of IT. Good knowledge of English is required.

    ProjectManager [PM]:Decision Maker from top or middle level management who is supervising the project.

  • FinA Software Requirements
    1. Operating System (OS) - MS Windows NT/2000/2003/XP/Vista/7, Linux, AIX and Solaris
    2. Database Engine – Oracle 10g/11g, MS SQL Server 2005/2008, and MySQL 5.1. Later versions of these database engines as well as other database engines such as IBM DB2, PostgreSQL are being continuously evaluated for use with FinA.
    3. FinA Client and FinA Server – The installation packages also include the OpenOffice.org, Java, and JBOSS, which are required to be installed in order to run FinA.

  • FINA Software Requirements

    1. Operating System (OS) - MS Windows NT/2000/2003/XP/Vista/7, Linux, AIX and Solaris
    2. Database Engine – Oracle 10g/11g, MS SQL Server 2005/2008, and MySQL 5.1. Later versions of these database engines as well as other database engines such as IBM DB2, PostgreSQL are being continuously evaluated for use with FinA.
    3. FinA Client and FinA Server – The installation packages also include the OpenOffice.org, Java, and JBOSS, which are required to be installed in order to run FinA.

      Related items

      • FinA Administrator skills Requirements
        1. System Administrator [sadmin] - In order to install, configure, and maintain FinA, the designated FinA Systems Administrator should have qualifications and experience in the following areas:

          • OS: MS Windows | Linux | Solaris | AIX based on policy ;
          • Database server: Oracle | MS SQL Server | MySQL based on policy.
          • LAN administration and Security Management: Firewalls, Switches, etc.
          • Java : Preferable, but not obligatory;
          • Language skills: English Intermediate or higher;

          Functional Administrator [fadmin]: Supervisor with advantage skills of Spreadsheet, Concept of the Relational database and basics of OS management. Fadmin should have qualifications and experience in the following areas:

          • Good knowledge of the financial reporting forms;
          • Good knowledge of output reports: UBPR, Early Warning systems, Stress Test Models and other reports used in Central Bank;
          • Spread Sheet: Advanced knowledge of Excel | OpenOffice.org calc;
          • Language skills: English Intermediate or higher;

          ProjectCoordinator: Is all hands specialist who has to coordinate and manage all tasks. In some organizations PC is from IT department with some experience in supervision, in others - it is supervisor with advantage knowledge of IT. Good knowledge of English is required.

          ProjectManager [PM]:Decision Maker from top or middle level management who is supervising the project.

      • FinA Hardware Requirements

        APPLICATION & DATABASE SERVER(s)

        This is an estimated minimum required for the application server’s files and database containing one year worth of data typical for a small size banking system. In such environment FinA Database Server and Application Server can be installed on same machine. The amount of RAM and CPU speed to adequately run the FinA database is highly dependent on the amount of data being processed and should be estimated during the capacity planning phase. See minimum and recommended specifications below:

        Requirement

        Minimum

        Recommended

        CPU

        AMD/Celeron/Intel 1.0 MGH +

        Two 4-Core Intel® Xeon®

        RAM

        8 GB

        32 GB

        HDD

        200 GB HDD

        500 GB RAID 10 with 5(+) x 15 rpm or SSD HDDs

        NIC

        1 Mbps+

        1 Gbps

        Monitor/Screen

        1024x768 +

        1280 x1024 +


        For minimum and recommended configurations see also useful links below:
        1. Microsoft® SQL Server (MS SQL Server):http://www.microsoft.com/sql/default.mspx
        2. Oracle® Database (Oracle):http://www.oracle.com/database/index.html
        3. MySQL:http://www.mysql.com
        .DCS | Data Collection Server(s)

        Requirement

        Minimum

        Recommended

        CPU

        AMD/Celeron/Intel 1.0 MGH +

        Two 4-Core Intel® Xeon®

        RAM

        6 GB

        16 GB

        HDD

        100 GB HDD

        500 GB +

        NIC

        1 Mbps+ (DMZ)

        100 + Mbps (DMZ)

        Monitor/Screen

        1024x768 +

        1280 x1024 +


        DCS server has to be installed in DMZ

        CLIENT WORKSTATION

        Requirement

        Minimum

        Recommended

        CPU

        1 GHZ

        2 + GHZ

        RAM

        2 GB

        4 + GB

        HDD Free Space

        1 GB

        10 GB

        NIC

        1 Mbps

        1 + Gbps

        Monitor/Screen

        SVGA 1024x768

        1280 x1024 +

      • Document Management System

        Document Management

        Ensure complete, secure control of the document lifecycle, with straightforward search, storage, indexing, and version management. Application examples include Enterprise Document Management, Enterprise Content Management (ECM), Web Content Management (WCM), Content Management Interoperability Services (CMIS), and Collaboration.

        Benefits:Streamlined, automated lifecycle management; Fast, easy access to searchable content; Mitigated risk thorough audit trails and use histories

        Key Features:

        • Document Management
        • Web Content Management
        • Collaboration
        • Content Platform and Repository
        • Content Management Interoperability Services (CMIS)
        • Records Management
        • Image Management

        Our Document Management solutions provide organizations with all the services necessary for creating, converting, managing, and sharing electronic documents. Built on industry-standard open source platforms, our solutions ensure completeness, validity, traceability, and inalterability of important documents ranging from employment and maintenance contracts to purchase agreements and collaboration agreements with a business partners. Additional features include version management, search capabilities, and visual representation of relationships and dependencies.

        An intuitive interface allows administrators to import and export workspaces and documents, and manage users and security based on Users, Groups, and Roles. Presentation templates and dashboard views provide personalized and real-time reporting of selected content. The preview feature shows content in combination with other elements, and the composite document feature helps to logically group documents and digital assets for specific marketing projects. Comprehensive search capabilities support indexing, metadata, and multi-category searches.

        Comprehensive Integration and Formatting Options

        Our Document Management solutions are interoperable with any database (Oracle, MySQL, etc.), any membership system (RDBMS, LDAP, Windows Directory Services, etc.), any operating system (Windows, Linux, Solaris, etc.), and any external system (.NET, J2EE, Python, PHP, etc.).A built-in data management and transformation engine enables organizations to transform data into required formats based on business rules. And an integrated workflow tool gives users complete control over document lifecycle management and process flow.

      FINA Network Requirements

      All data processing and analysis takes place on the FinA application server. Therefore, FinA does not require a high-speed network connection. The recommended local area network (LAN) speed is 100 + Mbps from the FinA client machine to the FinA application server machine. If the FinA application server and FinA database server are installed on different machines, the recommended LAN speed is 100 Mbps from the application server machine to the database server machine.