Learning and Training Learning


Strategy and IT Architecture

During this two-day training course, the participants will familiarize themselves with the structure of management reporting (Management Information System (MIS)), understand the importance of the development of a bank’s business architecture, and realize its influence on IT architecture and reporting. 
 
Training participants will be issued a package of executive management reports, and provided with information about approaches toward the formulation of MIS business requirements and the organization of a MIS project or unit in a bank.


Module 1: 1 day

MIS architecture and components

MIS architecture and key modules in banks
  • Data warehouse
  • Reporting system for the BI (Business Intelligence) management
  • Data warehouse control system
  • Financial applications: Transfer-pricing module, Balance Sheet and P&L, Calculation of Provisions and Capital Allocation, Budgeting and Budget Control
  • Technical applications: managing the data warehouse load, managing reference tables, samples and events
MIS structure and hierarchy: reports for the management board, reports for the mid management
  • Commercial reports of business units, CRM and marketing
    • Sales
    • Income and commissions
    • Balanced indicators of business segments
    • Balanced network indicators
    • Customer loyalty and outflow analysis
    • Cross sales analysis
    • Advertising campaign analysis
  • Financial reporting (IFRS and national accounting standards)
    • Balance sheet
    • Profit and loss account
    • Cash flow statement
    • Equity statement
    • Notes to statements
  • Profitability management reporting (target vs actual):
    • Branch profitability
    • Sales channel profitability
    • Business segment profitability
    • Product profitability
  • Risk management reporting
    • Credit risk reporting
    • Market risk management reporting and ALCO reports
    • Operational risk reporting


Module 2: 1 day

MIS implementation project

Preparing for an implementation project
  • Setting up an MIS unit
  • Developing project budget
  • Requirements for the implementation team and selection of team members
  • Developing a high-level work plan
  • Job descriptions and policies
Implementation project
  • Macro Design Phase
    • Business analysis of user requirements
    • Data source analysis
    • Macro design of the logical model of the warehouse and data marts
    • Evaluation of data gaps in sources and objects of the data warehouse model
    • Adjustment of the logical data warehouse model and data mart macro design
    • ETL macro design
    • Application architecture macro design
    • BI reports macro design
    • Developing a detailed development plan
  • Micro Design Phase
    • Developing detailed business requirements for ETL & PL/SQL development teams
    • Micro design of the logical data mart warehouse model
    • Source data mapping to entities of the data warehouse model
    • ETL micro design
    • Applications micro design
    • BI reports micro design
    • Adjustment of a detailed development plan
  • Development Phase
    • Development of the physical model of a warehouse
    • Developing Level 1 ETL procedures for data warehouse loading
    • Developing Level 2 ETL procedures for data marts loading
    • Developing storable application procedures
    • Developing reports in BI
  • Testing Phase
    • Testing data upload to the warehouse
    • Testing data marts
    • Testing calculation applications
    • Testing reports
  • Commissioning Phase. User Training and Support
Assessment of the project implementation quality
  • Assessment of the project management quality
  • Assessment of the general architecture of the solution and applications
  • Assessment of the logical model of the data warehouse and data marts
  • Assessment of the architecture and the quality of ETL procedures
  • Assessment of the architecture and the quality of BI reports

During this two-day training course, the participants will familiarize themselves with the structure of management reporting (Management Information System (MIS)), understand the importance of the development of a bank’s business architecture, and realize its influence on IT architecture and reporting. 
 
Training participants will be issued a package of executive management reports, and provided with information about approaches toward the formulation of MIS business requirements and the organization of a MIS project or unit in a bank.


Module 1: 1 day

MIS architecture and components

MIS architecture and key modules in banks
  • Data warehouse
  • Reporting system for the BI (Business Intelligence) management
  • Data warehouse control system
  • Financial applications: Transfer-pricing module, Balance Sheet and P&L, Calculation of Provisions and Capital Allocation, Budgeting and Budget Control
  • Technical applications: managing the data warehouse load, managing reference tables, samples and events
MIS structure and hierarchy: reports for the management board, reports for the mid management
  • Commercial reports of business units, CRM and marketing
    • Sales
    • Income and commissions
    • Balanced indicators of business segments
    • Balanced network indicators
    • Customer loyalty and outflow analysis
    • Cross sales analysis
    • Advertising campaign analysis
  • Financial reporting (IFRS and national accounting standards)
    • Balance sheet
    • Profit and loss account
    • Cash flow statement
    • Equity statement
    • Notes to statements
  • Profitability management reporting (target vs actual):
    • Branch profitability
    • Sales channel profitability
    • Business segment profitability
    • Product profitability
  • Risk management reporting
    • Credit risk reporting
    • Market risk management reporting and ALCO reports
    • Operational risk reporting


Module 2: 1 day

MIS implementation project

Preparing for an implementation project
  • Setting up an MIS unit
  • Developing project budget
  • Requirements for the implementation team and selection of team members
  • Developing a high-level work plan
  • Job descriptions and policies
Implementation project
  • Macro Design Phase
    • Business analysis of user requirements
    • Data source analysis
    • Macro design of the logical model of the warehouse and data marts
    • Evaluation of data gaps in sources and objects of the data warehouse model
    • Adjustment of the logical data warehouse model and data mart macro design
    • ETL macro design
    • Application architecture macro design
    • BI reports macro design
    • Developing a detailed development plan
  • Micro Design Phase
    • Developing detailed business requirements for ETL & PL/SQL development teams
    • Micro design of the logical data mart warehouse model
    • Source data mapping to entities of the data warehouse model
    • ETL micro design
    • Applications micro design
    • BI reports micro design
    • Adjustment of a detailed development plan
  • Development Phase
    • Development of the physical model of a warehouse
    • Developing Level 1 ETL procedures for data warehouse loading
    • Developing Level 2 ETL procedures for data marts loading
    • Developing storable application procedures
    • Developing reports in BI
  • Testing Phase
    • Testing data upload to the warehouse
    • Testing data marts
    • Testing calculation applications
    • Testing reports
  • Commissioning Phase. User Training and Support
Assessment of the project implementation quality
  • Assessment of the project management quality
  • Assessment of the general architecture of the solution and applications
  • Assessment of the logical model of the data warehouse and data marts
  • Assessment of the architecture and the quality of ETL procedures
  • Assessment of the architecture and the quality of BI reports


This course is designed for finance directors, chief accountants, managers, economists, specialists from financial analysis, planning and audit, management reporting and accounting, network performance analysis