Services Our Services


Project Management

IT projects are always limited by three key factors: time, cost and quality. It is the art of project management to keep equilibrium among these three key components. Otherwise, the project either would not be implemented on time, or would exceed the budget, or would have inferior quality.
 
All IT projects pass key phases of their lifecycle. There are specific processes at each phase. Exmacon’s data warehouse project management methodology is based on IBM’s methodology with some adjustments developed in the course of the practical implementation of projects in large banks. Basic phases and elements of the methodology are presented below. 
 
We actively apply state-of-the-art project management methodologies, such as Agile and Waterfall, depending on the project phase. To manage IT projects, we use MS Project, Jira, Kanban, Continuous Integration software.
 

IT Architecture

Exmacon offers an independent expert appraisal of the efficiency of use of information technologies in financial organizations from the point of view of optimizing their key business processes. We help our clients develop a unified information systems development strategy to substantially reduce the cost of subsequent reengineering and integration of diverse applications. 
 
The flexible response of IT systems to business requirements makes it possible to create sustained competitive advantages for an organization on the market. Our experts will help optimize the cost of support and development of information systems and improve operational efficiency of the client’s IT function by optimizing software development and testing processes.
 
Exmacon’s IT consultancy services include:
  • IT Diagnostic Review
  • IT Strategy
  • IT Architecture
  • IT Development Management


IT Diagnostic Review

The IT diagnostic review includes comprehensive analysis of the IT infrastructure, the issue analysis and the recommendations on bringing IT infrastructure into conformity with business goals and objectives. 
 
The IT diagnostic review is a systemic process, which includes gathering and analyzing data on the current condition of IT systems of an organization:
  • Server equipment and workstations
  • System software
  • Corporate LAN structure
  • Security systems
  • Data transmission channels
  • et al.
 We apply the following methods during the audit of the IT infrastructure:
  • Taking inventory of IT infrastructure components
  • Distributing and processing questionnaires to employees
  • Analyzing software, files and system events of servers and workstations
As a result of the diagnostic review, we offer our clients an optimal IT architecture based upon their business goals, and available human and financial resources.

IT Strategy

The IT Strategy development includes preparation of an information technologies strategic development plan focused on attaining strategic business goals and objectives of the organization.
 
Exmacon develops an IT Strategy on the basis of the strategic development plan adopted by the organization. The goal of an IT Strategy Document has always been the attainment of a sustained competitive advantage on the market by using modern IT technologies, systems and resources.
 
The IT Strategy includes not only operating systems development and optimization plans, but also plans of development of state-of-the-art analysis and reporting systems. The reporting systems should permit solving the entire range of business analytics problems at all levels of organization management from the operating systems level to the level of management information systems.

IT Architecture

A properly designed and developed IT architecture has a number of features capable of delivering obvious business advantages:
  • Modular nature
  • Scalability
  • Flexibility
  • Resilience
  • Protection
  • Standardization
A properly designed IT architecture allows an organization to:
  • Ensure efficient operation of IT units
  • Reduce software development, implementation and support costs
  • Facilitate system management and integration tasks, which is especially important during mergers and acquisitions
  • Simplify the upgrades and replacement of information system elements
  • Reduce costs, labor input and time frames of the procurement of software and hardware components of an information system
According to Gartner’s analysts, the availability of a clearly defined architecture can provide the benefit of reducing unproductive expenses on IT by 25 to 30%.
Outsourcing

Exmacon offers outsourcing services of the development of applications using IBM, Microsoft and Oracle software. The outsourced application development includes the following services:
  • Application Architecture Development
  • Development of Terms of Reference and the Project Plan
  • Management of a Development Team
  • Application Development
  • Application Testing
  • Application Support.


Application Architecture Development

The application architecture development includes detailing requirements for an application, selecting technologies to be used, elaborating an application’s integration into the existing IT landscape of the organization, developing an application architecture document, and initial costing of the project.

Development of Terms of Reference and the Project Plan

This phase includes the preparation of detailed terms of reference for the development. The services include the solution detailing by a business analyst and a systemic architect, including detailed architectural diagrams and UserStory descriptions to underlie the development.
 
This stage also includes developing a project plan with the indication of developers’ roles (web-designer, front-end, back-end) needed to implement the project on time, and an accurate description of technologies to be used. 
 
The project is managed using MS Project or Atlassian Jira.

Management of a Development Team

Applications are developed using SCRUM methodology with the application of Continuous Integration tools (SVN, Bitbucket, Atlassian Jira, Bamboo, Crucible, Fisheye).

Application Development

Exmacon develops corporate web applications, multifunctional web sites, administration applications, integrates solutions based on SOA technologies, develops various monitoring applications, including real-time web monitors, and financial settlement applications.
 
We rely on the following programming languages, technologies and software frameworks: 
  • C# (.NET4.5)
  • Javascript (JQuery, ExtJs, Sencha)
  • HTML4, HTML5, CSS2, CSS3
  • PL/SQL, PL/pgSQL, T-SQL
  • ASP.NET MVC (Razor)
  • EntityFramework, ADO.NET, LINQ
  • WCF.NET
  • DesignPatterns .NET

Application Testing

When developing applications, we write auto-tests for each application functionality, and use Atlassian Bamboo to automate test runs and control development quality.

Application Support

Exmacon offers support to the software we developed, including:
  • Advice on the installation and the configuration of applications
  • Advice on functionality of applications
  • Detection and elimination of deficiencies via Exmacon’s support line
  • Provision of new versions and critical patches
Business Analysis

Exmacon offers a range of business analysis services for projects of the implementation of data warehouses, analytical applications, and reporting systems in banks. Our services in this field include:
  • Diagnostic review and analysis of user business requirements
  • Development of business requirements and reference tables, if they are not available
  • Development of technical specifications and data requirements
  • Logical mapping of data from sources to the data structure of the data warehouse or applications.


Diagnostic Review

Exmacon’s services in this field include: 
  • Analysis and systematization of calculation methodologies and models available in the bank
  • High-level data source analysis for the identification of key entities and objects
  • High-level analysis of existing reports, identification of the reporting structure, identification of duplicated elements
  • Analysis of key reference tables and systems of their support (reference tables of segments, products, units, sales channels, items of the balance sheet and profit and loss statement, etc.) 
  • Analysis of business requirements for the reporting and data storage system.
Exmacon’s clients will get the following deliverables as a result of the provision of consultancy services in this area:
  • A Diagnostic Review Report and recommendations on making good key methodology gaps
  • An Implementation Project Roadmap
  • A Preliminary Implementation Project Plan and Budget
  • A Project Presentation for the Management Board

Business Requirements

At this stage, Exmacon’s business analysts develop and co-ordinate business requirements for the reporting system with key project stakeholders and business clients. Business requirements that we develop and co-ordinate in a bank include the following sections:
  • General Description of Business Objectives and Project Scope
  • Requirements for a Data Warehouse
  • Requirements for Data Upload and Cleaning Tools
  • Requirements for Analytical Applications
  • Requirements for Technical Applications of the Data Warehouse
  • Requirements for the Reference Table Control System
  • Requirements for the Reporting System
  • Requirements for the Metadata Management System
  • Data Requirements
  • Key Reference Tables
  • Report Formats

Development of Technical Specifications and Data Mapping (Source to Target)

Based on diagnostic review results and after the analysis or development of business requirements, Exmacon’s business and data analysts start with the implementation phase covering:
  • Data analysis at source
  • Development of the comprehensive data storage logical model
  • Data mart logical model development
  • Logical mapping of data sources to the comprehensive data storage area, identification of data gaps
  • Development of solutions for the elimination of gaps in data for the warehouse
  • Development of specifications for the ETL team and technical data mapping
  • Development of specifications for the BI team.
The unique combination of business analysis and data warehouse modelling functions in the same Exmacon team members makes it possible to substantially speed up the process of the business analysis and the development of the detailed storage model and data marts of the warehouse, and make it less expensive at the same time.
DWH Modelling

Exmacon offers banks its banking data warehouse data model development and customization services based on IBM’s Banking DataWarehouse solution. Exmacon opted for this solution because our banking business consultants and practitioners are convinced that this solution is flexible and scalable to the extent making it possible for banks to develop and implement a banking data warehouse model within optimal time frames and budgets.
 
IBM BDW has a number of undeniable advantages: 
  • The IBM BDW model helps a bank to create a unified data storage, analysis and management system.
  • This is an off-the-shelf logical data model for the entire range of banking business containing over 80 per cent of all the typical data structures a bank needs for analysis and report development.
  • This model makes it possible to save on the implementation thanks to an off-the-shelf model of the comprehensive storage of data, and off-the-shelf data mart templates.
  • This solution minimizes risks due to the iterative approach toward building up a general corporate solution.
  • This system delivers productivity and scalability for meeting banks’ growing demand for the information about customers, deals, accounts, and sales outlets.
  • This solution supports coordinated access to the information about customers, contracts, accounts, and products for all business applications of a bank.
  • The model makes it possible to tackle infrastructure development and data storage issues in a situation of the growing information requirements within the framework of a single plan.
  • This model contributes to the standardization of data for a bank as a whole.
  • It offers competitive advantages to a bank due to the optimal data consolidation and rapid design of reports for the management of risks and finances.
The logical data model is easily transformable into a physical warehouse database in any commercial DBMS.
Exmacon’s IT consultants offer their services of modelling the IBM BDW logical data model containing two key data storage and display areas:
  • A comprehensive data storage logical model (Atomic Model)
  • A warehouse data mart model (Dimensional Model)
In addition to modelling the warehouse data structure, we also offer: 
  • Mentoring and training of the implementation team in terms of IBM BDW modelling
  • Support to, and training of, solution owners after the completion of the implementation project.


System of Records (SOR) Detailed Data Storage Model

The System of Records (SOR) detailed data storage model makes it possible to:
  • Centralize and store information from various sources in detailed breakdowns in a regular form
  • Clearly define and save interdependencies between data model entities
  • Fill up key entities with clean, rationalized and easily accessible data
  • Structure and define data that needs history accumulation
  • Simplify extraction of the required data from an array of clearly structured data
  • Set up data areas, including detailed historical data required for BI systems and analytical applications
  • Limit direct access of analysis and business users to the minimum; the SOR area is not focused on tacking any functional analytical problems
The SOR logical model contains the following key entities:
  • Arrangement—information about a contract
  • Conditions—terms and conditions of a contract, a product, an account
  • Product—information about a product and its key features
  • Involved Party—process stakeholders (customers, counterparties)
  • Event—events related to the operation of a contract, an account, a customer, a sales outlet
  • Classification—the typology of key concepts, the interconnection between them, the parametrization of entities, classifiers and reference tables related to a contract, a product, a sales outlet, a customer, etc.
  • Location—the location of a sales outlet, a customer, a counterparty, a contractor.
IBM BDW’s conceptual comprehensive data storage model is based upon the Arrangement, which is linked to general ledger accounts and transactions via the Accounting Unit, a special entity making it possible to store information about balances and transactions using any accounting method (IFRS, NAS, GAAP), and to keep record of non-monetary accounting units (metals, vehicles, buildings, etc.).
 
An Arrangement is made between Involved Parties. E.g., a bank enters into contracts with customers, suppliers and contractors, and employees. An Arrangement has Conditions (rates, currencies, limits) and related Events (payments and payment schedules, events of default, etc.). An Arrangement is made in a specific Location (a unit with an address). In addition, a set of unified contracts with the same conditions and risk profiles is linked to a bank’s Product entity.
 
The Classification entity makes it possible to categorize all key entities of a warehouse on the basis of key reference tables used by a bank.

Warehouse Data Mart Model (Dimensional Model)

The warehouse data mart model (Dimensional Model) includes Dimensions, Profiles, and Data Marts, and makes it possible to:
  • Reduce time needed for the generation of reports by using re-prepared summary data tables and aggregated data based on SOR data
  • Rapidly organize collaboration among business users, business analysis and developers by having warehouse modelling specialists to thoroughly establish the business requirements
  • Establish business requirements in detail and optimize them to prepare summary tables and aggregates for building up reports
  • Understand and implement the data mart logic and rules in terms of summing up, aggregating and analyzing the data
  • Rapidly create data tables in the summary, aggregation and analysis area to detail, optimize, aggregate and update information
  • Expand the range of opportunities for the detailed data analysis in various business areas by turning from aggregate data to the most detailed (source) data in the warehouse
  • Relieve resources of a bank’s operating systems from inappropriate analytical functions.

Warehouse Data Model Implementation Team and Business Owners Mentoring

Exmacon’s business analysts and modelers provide implementation team mentoring and training services, and services of support to, and training of, business owners of the data warehouse model after the completion of the implementation project.
ETL Architecture

Exmacon offers a full range of data integration services on the basis of IBM InfoSphere Information Server, including the following software products: 
  • IBM DataStage
  • IBM QualityStage
  • IBM Metadata Workbench
  • IBM Business Glossary
  • IBM Fast Track.
Our services in the field of data integration include:
  • Diagnostic Review of ETL Architecture and Processes 
  • ETL Project Mentoring and Quality Assurance
  • Data Integration Architecture and Processes Development
  • Analysis of the Data Structure and Quality in Sources.


Diagnostic Review of ETL Architecture and Processes

Exmacon offers consultancy in the field of the diagnostics of the existing data integration architecture on the basis of IBM InfoSphere Information Server. As a result of the analysis, Exmacon’s specialists will formulate recommendations on the optimization of the existing solution. Key areas of diagnostics include:
  • Analysis and description of the existing architecture of the ETL solution
  • Identification of key issues of the existing ETL architecture
  • Development of recommendations on optimizing and increasing efficiency of the solution.

ETL Project Mentoring and Quality Assurance

Exmacon’s IT consultants are prepared to support the development team by means of the transfer of expertise, mentoring and quality control of the implementation project using the IBM InfoSphere Information Server product range. 
 
The success of building a single corporate data integration system depends to a great extent on the efficient use of the potential of IBM InfoSphere Information Server and the correct design of data integration processes. Our specialists will help the development team design the ETL processes architecture, provide detailed recommendations on the implementation of ETL processes, explain various approaches toward designing processes and using IBM InfoSphere Information Server tools.
 
The comprehensive training, technical and methodological support will help the development team to build a single corporate data integration system on the basis of IBM’s DataStage, QualityStage, Metadata Workbench, Business Glossary, Fast Track solutions in a short time.
 
Exmacon’s services in this field include:
  • ETL Architecture design
  • Technical and methodological support to the development team
  • Implementation project quality control
  • Training the development team in IBM InfoSphere Information Server products
  • Training business owners and users of the data integration system.

Data Integration Architecture and Processes Development

Exmacon’s data integration system development services cover the entire service range from the development of the ETL architecture, the development of ETL processes of data transformation, consolidation, cleaning and upload to the management of metadata.
 
Exmacon will implement a data integration system on the basis of IBM InfoSphere Information Server from scratch within optimal time frames, and provide the post-project solution support. 
 
Exmacon’s services in the field of the data integration system development include:
  • Development of the general architecture of ETL processes (IBM Blueprint Director)
  • Metadata management (IBM IMAM & IBM Metadata Workbench)
  • Development of data download, transformation, consolidation and upload processes (IBM DataStage)
  • Development of data analysis, cleaning, standardization and matching processes (IBM QualityStage)
  • Implementation of a single corporate business glossary (IBM Business Glossary)
  • Automation of the distribution of reporting forms to users
  • Administration of the BI system.

Analysis of the Data Structure and Quality in Sources

Exmacon offers services of analysis of the data structure and quality in source systems, and in the field of the automation, standardization and cleaning in the course of their upload into the target system using IBM QualityStage.
Business Intelligence

Exmacon offers banks a range of consultancy services focused on developing and optimizing a management information system based on commercial BI solutions.
 
For the development of Management Information System (MIS), we suggest that our customers use IBM Cognos BI and IBM Cognos TM1 products. However, we often develop reports for our customers using the BI tools that can be properly integrated into the existing IT landscape (SAP Business Objects, QlikView, etc.), while dealing with the existing IT architecture, software and human resources.
 
We offer the following services in this area of IT consultancy: 
  • Diagnostic review and analysis of the existing bi architecture
  • Development of the BI system architecture, reports and metadata
  • BI system implementation project mentoring and quality control
  • Support to the BI system after the completion of the implementation project.


Diagnostic Review of the BI system

Exmacon’s specialists offer banks a range of consultancy services focused on analyzing the existing BI architecture and metadata model; they will help to optimize it and will give recommendations on enhancing system productivity and speed. Our recommendations based on the best international practices will allow banks to make use of the potential of the available BI system more efficiently. 
 
Our services in the field of BI systems diagnostic review and assessment include:
  • BI architecture analysis and assessment
  • BI system’s metadata model analysis and assessment
  • BI metadata and reporting model analysis and optimization.

BI System Development

Exmacon’s BI system development services include the entire range of services from the development of the BI architecture, metadata modelling, the development of standard and ad hoc BI reports, ad hoc queries for the multidimensional analysis, interactive information control panels for the management, the division of access to the information and system objects, the management of events, and the administration of the BI system. 
 
Exmacon will implement a BI system from scratch and support the developed solution professionally and within optimal time frames. 
 
Exmacon’s BI system development services include:
  • Development of the general architecture of BI processes
  • Metadata modelling (Framework Manager)
  • Development of pre-configured reports (Report Studio)
  • Development of information control panels (Dashboards in Report Studio)
  • Development of ad hoc reports (Query Studio & Analysis Studio)
  • Managing security and access at the level of users and data
  • Managing security and access at the level of reports
  • Managing events (Event Studio)
  • Automation of the distribution of reporting forms to users
  • Administration of the BI system

BI Project Mentoring

Exmacon’s technical consultants are prepared to support the development team by means of the transfer of expertise, mentoring and quality control of the implementation project. The success of building a single corporate reporting system depends to a great extent on the efficient use of the potential of the BI system and the correct design of metadata model. Our specialists will help the development team design the metadata model architecture, provide detailed recommendations on its implementation, and explain various approaches and BI tools.
 
The comprehensive training, technical and methodological support will help the development team to build a single banking information and analysis system within a short time frame.
 
Exmacon’s services in this field include:
  • Implementation project quality control
  • Technical and methodological support to the development team
  • Training of BI business owners and the bank’s development team
  • Training users in using IBM Cognos BI.

IT projects are always limited by three key factors: time, cost and quality. It is the art of project management to keep equilibrium among these three key components. Otherwise, the project either would not be implemented on time, or would exceed the budget, or would have inferior quality.
 
All IT projects pass key phases of their lifecycle. There are specific processes at each phase. Exmacon’s data warehouse project management methodology is based on IBM’s methodology with some adjustments developed in the course of the practical implementation of projects in large banks. Basic phases and elements of the methodology are presented below. 
 
We actively apply state-of-the-art project management methodologies, such as Agile and Waterfall, depending on the project phase. To manage IT projects, we use MS Project, Jira, Kanban, Continuous Integration software.
 

Exmacon offers an independent expert appraisal of the efficiency of use of information technologies in financial organizations from the point of view of optimizing their key business processes. We help our clients develop a unified information systems development strategy to substantially reduce the cost of subsequent reengineering and integration of diverse applications. 
 
The flexible response of IT systems to business requirements makes it possible to create sustained competitive advantages for an organization on the market. Our experts will help optimize the cost of support and development of information systems and improve operational efficiency of the client’s IT function by optimizing software development and testing processes.
 
Exmacon’s IT consultancy services include:
  • IT Diagnostic Review
  • IT Strategy
  • IT Architecture
  • IT Development Management


IT Diagnostic Review

The IT diagnostic review includes comprehensive analysis of the IT infrastructure, the issue analysis and the recommendations on bringing IT infrastructure into conformity with business goals and objectives. 
 
The IT diagnostic review is a systemic process, which includes gathering and analyzing data on the current condition of IT systems of an organization:
  • Server equipment and workstations
  • System software
  • Corporate LAN structure
  • Security systems
  • Data transmission channels
  • et al.
 We apply the following methods during the audit of the IT infrastructure:
  • Taking inventory of IT infrastructure components
  • Distributing and processing questionnaires to employees
  • Analyzing software, files and system events of servers and workstations
As a result of the diagnostic review, we offer our clients an optimal IT architecture based upon their business goals, and available human and financial resources.

IT Strategy

The IT Strategy development includes preparation of an information technologies strategic development plan focused on attaining strategic business goals and objectives of the organization.
 
Exmacon develops an IT Strategy on the basis of the strategic development plan adopted by the organization. The goal of an IT Strategy Document has always been the attainment of a sustained competitive advantage on the market by using modern IT technologies, systems and resources.
 
The IT Strategy includes not only operating systems development and optimization plans, but also plans of development of state-of-the-art analysis and reporting systems. The reporting systems should permit solving the entire range of business analytics problems at all levels of organization management from the operating systems level to the level of management information systems.

IT Architecture

A properly designed and developed IT architecture has a number of features capable of delivering obvious business advantages:
  • Modular nature
  • Scalability
  • Flexibility
  • Resilience
  • Protection
  • Standardization
A properly designed IT architecture allows an organization to:
  • Ensure efficient operation of IT units
  • Reduce software development, implementation and support costs
  • Facilitate system management and integration tasks, which is especially important during mergers and acquisitions
  • Simplify the upgrades and replacement of information system elements
  • Reduce costs, labor input and time frames of the procurement of software and hardware components of an information system
According to Gartner’s analysts, the availability of a clearly defined architecture can provide the benefit of reducing unproductive expenses on IT by 25 to 30%.

Exmacon offers outsourcing services of the development of applications using IBM, Microsoft and Oracle software. The outsourced application development includes the following services:
  • Application Architecture Development
  • Development of Terms of Reference and the Project Plan
  • Management of a Development Team
  • Application Development
  • Application Testing
  • Application Support.


Application Architecture Development

The application architecture development includes detailing requirements for an application, selecting technologies to be used, elaborating an application’s integration into the existing IT landscape of the organization, developing an application architecture document, and initial costing of the project.

Development of Terms of Reference and the Project Plan

This phase includes the preparation of detailed terms of reference for the development. The services include the solution detailing by a business analyst and a systemic architect, including detailed architectural diagrams and UserStory descriptions to underlie the development.
 
This stage also includes developing a project plan with the indication of developers’ roles (web-designer, front-end, back-end) needed to implement the project on time, and an accurate description of technologies to be used. 
 
The project is managed using MS Project or Atlassian Jira.

Management of a Development Team

Applications are developed using SCRUM methodology with the application of Continuous Integration tools (SVN, Bitbucket, Atlassian Jira, Bamboo, Crucible, Fisheye).

Application Development

Exmacon develops corporate web applications, multifunctional web sites, administration applications, integrates solutions based on SOA technologies, develops various monitoring applications, including real-time web monitors, and financial settlement applications.
 
We rely on the following programming languages, technologies and software frameworks: 
  • C# (.NET4.5)
  • Javascript (JQuery, ExtJs, Sencha)
  • HTML4, HTML5, CSS2, CSS3
  • PL/SQL, PL/pgSQL, T-SQL
  • ASP.NET MVC (Razor)
  • EntityFramework, ADO.NET, LINQ
  • WCF.NET
  • DesignPatterns .NET

Application Testing

When developing applications, we write auto-tests for each application functionality, and use Atlassian Bamboo to automate test runs and control development quality.

Application Support

Exmacon offers support to the software we developed, including:
  • Advice on the installation and the configuration of applications
  • Advice on functionality of applications
  • Detection and elimination of deficiencies via Exmacon’s support line
  • Provision of new versions and critical patches

Exmacon offers a range of business analysis services for projects of the implementation of data warehouses, analytical applications, and reporting systems in banks. Our services in this field include:
  • Diagnostic review and analysis of user business requirements
  • Development of business requirements and reference tables, if they are not available
  • Development of technical specifications and data requirements
  • Logical mapping of data from sources to the data structure of the data warehouse or applications.


Diagnostic Review

Exmacon’s services in this field include: 
  • Analysis and systematization of calculation methodologies and models available in the bank
  • High-level data source analysis for the identification of key entities and objects
  • High-level analysis of existing reports, identification of the reporting structure, identification of duplicated elements
  • Analysis of key reference tables and systems of their support (reference tables of segments, products, units, sales channels, items of the balance sheet and profit and loss statement, etc.) 
  • Analysis of business requirements for the reporting and data storage system.
Exmacon’s clients will get the following deliverables as a result of the provision of consultancy services in this area:
  • A Diagnostic Review Report and recommendations on making good key methodology gaps
  • An Implementation Project Roadmap
  • A Preliminary Implementation Project Plan and Budget
  • A Project Presentation for the Management Board

Business Requirements

At this stage, Exmacon’s business analysts develop and co-ordinate business requirements for the reporting system with key project stakeholders and business clients. Business requirements that we develop and co-ordinate in a bank include the following sections:
  • General Description of Business Objectives and Project Scope
  • Requirements for a Data Warehouse
  • Requirements for Data Upload and Cleaning Tools
  • Requirements for Analytical Applications
  • Requirements for Technical Applications of the Data Warehouse
  • Requirements for the Reference Table Control System
  • Requirements for the Reporting System
  • Requirements for the Metadata Management System
  • Data Requirements
  • Key Reference Tables
  • Report Formats

Development of Technical Specifications and Data Mapping (Source to Target)

Based on diagnostic review results and after the analysis or development of business requirements, Exmacon’s business and data analysts start with the implementation phase covering:
  • Data analysis at source
  • Development of the comprehensive data storage logical model
  • Data mart logical model development
  • Logical mapping of data sources to the comprehensive data storage area, identification of data gaps
  • Development of solutions for the elimination of gaps in data for the warehouse
  • Development of specifications for the ETL team and technical data mapping
  • Development of specifications for the BI team.
The unique combination of business analysis and data warehouse modelling functions in the same Exmacon team members makes it possible to substantially speed up the process of the business analysis and the development of the detailed storage model and data marts of the warehouse, and make it less expensive at the same time.

Exmacon offers banks its banking data warehouse data model development and customization services based on IBM’s Banking DataWarehouse solution. Exmacon opted for this solution because our banking business consultants and practitioners are convinced that this solution is flexible and scalable to the extent making it possible for banks to develop and implement a banking data warehouse model within optimal time frames and budgets.
 
IBM BDW has a number of undeniable advantages: 
  • The IBM BDW model helps a bank to create a unified data storage, analysis and management system.
  • This is an off-the-shelf logical data model for the entire range of banking business containing over 80 per cent of all the typical data structures a bank needs for analysis and report development.
  • This model makes it possible to save on the implementation thanks to an off-the-shelf model of the comprehensive storage of data, and off-the-shelf data mart templates.
  • This solution minimizes risks due to the iterative approach toward building up a general corporate solution.
  • This system delivers productivity and scalability for meeting banks’ growing demand for the information about customers, deals, accounts, and sales outlets.
  • This solution supports coordinated access to the information about customers, contracts, accounts, and products for all business applications of a bank.
  • The model makes it possible to tackle infrastructure development and data storage issues in a situation of the growing information requirements within the framework of a single plan.
  • This model contributes to the standardization of data for a bank as a whole.
  • It offers competitive advantages to a bank due to the optimal data consolidation and rapid design of reports for the management of risks and finances.
The logical data model is easily transformable into a physical warehouse database in any commercial DBMS.
Exmacon’s IT consultants offer their services of modelling the IBM BDW logical data model containing two key data storage and display areas:
  • A comprehensive data storage logical model (Atomic Model)
  • A warehouse data mart model (Dimensional Model)
In addition to modelling the warehouse data structure, we also offer: 
  • Mentoring and training of the implementation team in terms of IBM BDW modelling
  • Support to, and training of, solution owners after the completion of the implementation project.


System of Records (SOR) Detailed Data Storage Model

The System of Records (SOR) detailed data storage model makes it possible to:
  • Centralize and store information from various sources in detailed breakdowns in a regular form
  • Clearly define and save interdependencies between data model entities
  • Fill up key entities with clean, rationalized and easily accessible data
  • Structure and define data that needs history accumulation
  • Simplify extraction of the required data from an array of clearly structured data
  • Set up data areas, including detailed historical data required for BI systems and analytical applications
  • Limit direct access of analysis and business users to the minimum; the SOR area is not focused on tacking any functional analytical problems
The SOR logical model contains the following key entities:
  • Arrangement—information about a contract
  • Conditions—terms and conditions of a contract, a product, an account
  • Product—information about a product and its key features
  • Involved Party—process stakeholders (customers, counterparties)
  • Event—events related to the operation of a contract, an account, a customer, a sales outlet
  • Classification—the typology of key concepts, the interconnection between them, the parametrization of entities, classifiers and reference tables related to a contract, a product, a sales outlet, a customer, etc.
  • Location—the location of a sales outlet, a customer, a counterparty, a contractor.
IBM BDW’s conceptual comprehensive data storage model is based upon the Arrangement, which is linked to general ledger accounts and transactions via the Accounting Unit, a special entity making it possible to store information about balances and transactions using any accounting method (IFRS, NAS, GAAP), and to keep record of non-monetary accounting units (metals, vehicles, buildings, etc.).
 
An Arrangement is made between Involved Parties. E.g., a bank enters into contracts with customers, suppliers and contractors, and employees. An Arrangement has Conditions (rates, currencies, limits) and related Events (payments and payment schedules, events of default, etc.). An Arrangement is made in a specific Location (a unit with an address). In addition, a set of unified contracts with the same conditions and risk profiles is linked to a bank’s Product entity.
 
The Classification entity makes it possible to categorize all key entities of a warehouse on the basis of key reference tables used by a bank.

Warehouse Data Mart Model (Dimensional Model)

The warehouse data mart model (Dimensional Model) includes Dimensions, Profiles, and Data Marts, and makes it possible to:
  • Reduce time needed for the generation of reports by using re-prepared summary data tables and aggregated data based on SOR data
  • Rapidly organize collaboration among business users, business analysis and developers by having warehouse modelling specialists to thoroughly establish the business requirements
  • Establish business requirements in detail and optimize them to prepare summary tables and aggregates for building up reports
  • Understand and implement the data mart logic and rules in terms of summing up, aggregating and analyzing the data
  • Rapidly create data tables in the summary, aggregation and analysis area to detail, optimize, aggregate and update information
  • Expand the range of opportunities for the detailed data analysis in various business areas by turning from aggregate data to the most detailed (source) data in the warehouse
  • Relieve resources of a bank’s operating systems from inappropriate analytical functions.

Warehouse Data Model Implementation Team and Business Owners Mentoring

Exmacon’s business analysts and modelers provide implementation team mentoring and training services, and services of support to, and training of, business owners of the data warehouse model after the completion of the implementation project.

Exmacon offers a full range of data integration services on the basis of IBM InfoSphere Information Server, including the following software products: 
  • IBM DataStage
  • IBM QualityStage
  • IBM Metadata Workbench
  • IBM Business Glossary
  • IBM Fast Track.
Our services in the field of data integration include:
  • Diagnostic Review of ETL Architecture and Processes 
  • ETL Project Mentoring and Quality Assurance
  • Data Integration Architecture and Processes Development
  • Analysis of the Data Structure and Quality in Sources.


Diagnostic Review of ETL Architecture and Processes

Exmacon offers consultancy in the field of the diagnostics of the existing data integration architecture on the basis of IBM InfoSphere Information Server. As a result of the analysis, Exmacon’s specialists will formulate recommendations on the optimization of the existing solution. Key areas of diagnostics include:
  • Analysis and description of the existing architecture of the ETL solution
  • Identification of key issues of the existing ETL architecture
  • Development of recommendations on optimizing and increasing efficiency of the solution.

ETL Project Mentoring and Quality Assurance

Exmacon’s IT consultants are prepared to support the development team by means of the transfer of expertise, mentoring and quality control of the implementation project using the IBM InfoSphere Information Server product range. 
 
The success of building a single corporate data integration system depends to a great extent on the efficient use of the potential of IBM InfoSphere Information Server and the correct design of data integration processes. Our specialists will help the development team design the ETL processes architecture, provide detailed recommendations on the implementation of ETL processes, explain various approaches toward designing processes and using IBM InfoSphere Information Server tools.
 
The comprehensive training, technical and methodological support will help the development team to build a single corporate data integration system on the basis of IBM’s DataStage, QualityStage, Metadata Workbench, Business Glossary, Fast Track solutions in a short time.
 
Exmacon’s services in this field include:
  • ETL Architecture design
  • Technical and methodological support to the development team
  • Implementation project quality control
  • Training the development team in IBM InfoSphere Information Server products
  • Training business owners and users of the data integration system.

Data Integration Architecture and Processes Development

Exmacon’s data integration system development services cover the entire service range from the development of the ETL architecture, the development of ETL processes of data transformation, consolidation, cleaning and upload to the management of metadata.
 
Exmacon will implement a data integration system on the basis of IBM InfoSphere Information Server from scratch within optimal time frames, and provide the post-project solution support. 
 
Exmacon’s services in the field of the data integration system development include:
  • Development of the general architecture of ETL processes (IBM Blueprint Director)
  • Metadata management (IBM IMAM & IBM Metadata Workbench)
  • Development of data download, transformation, consolidation and upload processes (IBM DataStage)
  • Development of data analysis, cleaning, standardization and matching processes (IBM QualityStage)
  • Implementation of a single corporate business glossary (IBM Business Glossary)
  • Automation of the distribution of reporting forms to users
  • Administration of the BI system.

Analysis of the Data Structure and Quality in Sources

Exmacon offers services of analysis of the data structure and quality in source systems, and in the field of the automation, standardization and cleaning in the course of their upload into the target system using IBM QualityStage.

Exmacon offers banks a range of consultancy services focused on developing and optimizing a management information system based on commercial BI solutions.
 
For the development of Management Information System (MIS), we suggest that our customers use IBM Cognos BI and IBM Cognos TM1 products. However, we often develop reports for our customers using the BI tools that can be properly integrated into the existing IT landscape (SAP Business Objects, QlikView, etc.), while dealing with the existing IT architecture, software and human resources.
 
We offer the following services in this area of IT consultancy: 
  • Diagnostic review and analysis of the existing bi architecture
  • Development of the BI system architecture, reports and metadata
  • BI system implementation project mentoring and quality control
  • Support to the BI system after the completion of the implementation project.


Diagnostic Review of the BI system

Exmacon’s specialists offer banks a range of consultancy services focused on analyzing the existing BI architecture and metadata model; they will help to optimize it and will give recommendations on enhancing system productivity and speed. Our recommendations based on the best international practices will allow banks to make use of the potential of the available BI system more efficiently. 
 
Our services in the field of BI systems diagnostic review and assessment include:
  • BI architecture analysis and assessment
  • BI system’s metadata model analysis and assessment
  • BI metadata and reporting model analysis and optimization.

BI System Development

Exmacon’s BI system development services include the entire range of services from the development of the BI architecture, metadata modelling, the development of standard and ad hoc BI reports, ad hoc queries for the multidimensional analysis, interactive information control panels for the management, the division of access to the information and system objects, the management of events, and the administration of the BI system. 
 
Exmacon will implement a BI system from scratch and support the developed solution professionally and within optimal time frames. 
 
Exmacon’s BI system development services include:
  • Development of the general architecture of BI processes
  • Metadata modelling (Framework Manager)
  • Development of pre-configured reports (Report Studio)
  • Development of information control panels (Dashboards in Report Studio)
  • Development of ad hoc reports (Query Studio & Analysis Studio)
  • Managing security and access at the level of users and data
  • Managing security and access at the level of reports
  • Managing events (Event Studio)
  • Automation of the distribution of reporting forms to users
  • Administration of the BI system

BI Project Mentoring

Exmacon’s technical consultants are prepared to support the development team by means of the transfer of expertise, mentoring and quality control of the implementation project. The success of building a single corporate reporting system depends to a great extent on the efficient use of the potential of the BI system and the correct design of metadata model. Our specialists will help the development team design the metadata model architecture, provide detailed recommendations on its implementation, and explain various approaches and BI tools.
 
The comprehensive training, technical and methodological support will help the development team to build a single banking information and analysis system within a short time frame.
 
Exmacon’s services in this field include:
  • Implementation project quality control
  • Technical and methodological support to the development team
  • Training of BI business owners and the bank’s development team
  • Training users in using IBM Cognos BI.