Dataworhouse and analytical systems

The integrated database of multistructural bank (VICONT IBIS 1995-2009).

(This Complex uses Industrial RDBMS  firms SYBASE, or Microsoft SQL,

 The  working out  tools- Delphi)

The system provides  information lifting on regional (or the higher) level from all lowest levels of hierarchy, as well as all kinds of the reporting  formation for corresponding level and maintenance of reserve functions for subordinate divisions in hierarchy. The system carries out functions of support of decisions and provides  data  replication for out of balance  branches inclusive. System  provides  as well  the checking  functions  for  data   which  are going from the lowest levels :

The presence of balance on the rests and turns

The equality of turns behind the paid documents and under accounts

-Correctness of " the rests transfer ", that is check of consistency of the information. The system allows to receive both consolidated, and the analytical reporting on clients, settlement accounts, documents and operations which have been spent by bank as the legal body, and for any period of time.

Lifting of the information from CBS  is carried out by the special program.

Presence of own application server  allows to reduce to a minimum licences  quantity necessary for system work on client workplaces (3 CU (Concurrent user)) for Adaptive Server Enterprise 12.0 (12.5). (***)

Subsystem "the Tax declaration" VIONT   IBIS 1997-2009. Provides the full tax reporting for the legal entry/direction/branch, and also difference formation between  local financial and tax accounts. The VAT declaration  accounting  is provided as well. (Adaptive Server Enterprise v. 12.5)

The system is compatible to Subsystems "Anfisa" "IBIS" 1999-2009. And "Omega"IBIS 1997-2009 which are used at level of branches for calculation of declarations on Profits and the VAT.

Industrial storehouse of data and analytical systems, including  Data ETL procedures  and introduction. Projects implemented at the next  banks: Raiffaisen bank  AVAL,"ALPHA BANK"(Moscow),?(Istanbul).