About Exmacon Beratung

  • IT Consultant, Exmacon Beratung
  • Chief modeller of the IBM BDW data warehouse with three-year hands-on experience at the banking data warehouse implementation project in Oschadbank, the largest retail bank in Ukraine
  • Design and development of the conceptual and logical models of the data warehouse: System of Records (SOR) IBM BDW and Dimensional Model IBM (Summary, Analysis Area, Reporting Area: Profiles, Summary tables, Snapshots, Aggregates), design of Data Marts, development of reference files and business rules of the warehouse for making calculations and building reports
  • Managing a group of business analysts at the data warehouse implementation project
  • Certificate IBM Banking Data Warehouse (ECM-00981/12)
  • More than 14 years of work experience in the largest financial institutions of Ukraine as a business analyst
  • Vast experience in financial analysis, identification of business owners, ascertainment of their requirements, detailed analysis, processing and optimisation of business requirements, use of advantages of modern business analysis technologies and tools, fluency in international best practices of analysis and modelling
  • Task setting for programmers for the development of analytical applications for transfer pricing, cost accounting and allocation, financial modelling and budgeting
  • Practical experience in building financial and management reporting systems in various fields of banking, such as loans and deposits, capital market, credit, market and operational risk analysis, liquidity risk management, currency position management, bank assets and liabilities management
  • Data warehouse model development tools: IBM IDA, M1. Knowledge of relational databases. Experience in working with an Oracle (TOAD) database, fluency in SQL