• 151

    Projects submitted

  • 109

    Published projects

  • 47

    Comments left

  • 66

    Number of votes

  • 52

    days until voting ends

← Back to list

CubixBM: Import-Independent Budgeting for a Financial Group

  • Project manager on customer side

    Alexandra Makarova

    VTB Bank (PJSC)

    Head of Technology Development

  • Category

  • Nomination

  • Goals

    To ensure technological sovereignty and continuity of the budgeting process of an international financial group through a complete transition from a foreign platform to the import-independent CubixBM system.

    The project addresses three tasks:

    1. Replace a critical foreign system with an import-independent solution.

    2. Preserve and exceed the functionality of the previous platform: 1,500+ multidimensional cubes, 5,000+ calculation scenarios, 55 integration flows, consolidation of 50+ legal entities across 6 countries of international presence.

    3. Ensure budgeting continuity without interrupting business processes during migration.

    Expected result: a ready and stable system that fully replaces the legacy solution, with confirmed performance and a foundation for long-term development.

  • Timeline

    june, 2023 — march, 2026
  • Project completion year

    2026

  • Project scale

    100000 human-hours
  • Results

    The project was completed on time with budget savings of about 5%. 100% technological sovereignty in budgeting has been achieved — dependency on the external vendor has been fully eliminated.

    Key Measurable Results:

    • Data reconciliation efforts reduced by 30%

    • Budget approval speed accelerated by 30%

    • 50+ legal entities consolidated into a single system

    • 1,500+ multidimensional cubes and 5,000+ calculation scenarios operating in production

    • 55 integration flows providing real-time data exchange

    • Over 1,000 points of presence of the group worldwide received the implementation results

    The system fully replaces the legacy solution, data convergence with the previous platform is confirmed, and budgeting process continuity is ensured without stopping business processes. The solution is actively used in the Bank and can be applied by other large companies in import substitution projects or corporate planning system migrations.

  • Project uniqueness

    The world's first experience of migrating a budgeting system of this scale to a fully import-independent stack within an international financial group.

    Three key differentiators:

    1. Full core replacement, not just reports. The entire group planning and budget consolidation system was migrated, not just individual data marts. 50+ legal entities across 6 countries, 1,500+ cubes, 5,000+ scenarios.

    2. Deep product customization. The platform was tailored to unique banking algorithms: liquidity ratio calculation, transfer pricing, indirect cost allocation. The volume of customization exceeded 20% of standard functionality.

    3. Parallel migration without business disruption. An intermediate contour with data extraction from the old system to the new one ensured a seamless user transition and process continuity.

    The created solution can be successfully applied by other large companies in import substitution projects or corporate planning system migrations.

  • Software used

    Application Software:

    • CubixBM

    • PostgreSQL, Tarantool

    • Apache Kafka, Artemis MQ

    • Java, Python

    Infrastructure:

    • PostgreSQL

    • Open Source-based message queues

  • Solution from the Global CIO catalog

    The project does not use solutions from the Global CIO catalog

  • Project implementation complexity

    1. Tight deadlines and external constraints. The need to replace a critical system before the possible disconnection by the external vendor. Solution: priority funding, approved schedule, 100% import-independent stack.

    2. Scale and complexity of data. 1,500+ cubes, 55 integration flows, consolidation of 50+ legal entities in 6 countries, over a terabyte of data. Solution: a unified data model on PostgreSQL/Tarantool, automated data reconciliation.

    3. Unique banking algorithms. Calculation of liquidity ratios, transfer pricing, allocation of indirect costs. Solution: deep customization of the platform for 5,000+ formula scenarios, full data convergence with the previous system.

    4. User adoption and training. Transition of thousands of financial managers to the new system. Solution: training plan, instructions, webinars, on-duty rooms, a long stabilization phase.

    5. Managing 20+ teams and 7 contractors. Solution: a four-level planning system, synchronization via the roadmap, real-time transp

  • Description

    Amid shifting external conditions and the departure of foreign vendors, the international financial group faced the risk of losing a key business process — budget management. The system ran on the foreign Oracle Hyperion platform. Its loss would have meant the suspension of planning, control, and budget consolidation for a group with assets exceeding 30 trillion rubles, 53 thousand employees, and 50+ legal entities across 6 countries of international presence.

    Solution: the creation of the world's first fully import-independent budget management system of this scale based on the CubixBM platform. The platform is deeply customized for unique banking algorithms.

    Architecture and Scale:

    • 1,500+ multidimensional data cubes

    • 5,000+ plan-fact analysis and budget allocation scenarios

    • 55 real-time integration flows (Kafka, Artemis MQ)

    • Consolidation of 50+ legal entities of the group

    • Integration with 14 key source systems

    • Over 1 TB of processed data, considering all plan versions

    Key Functional Blocks:

    1. Formation of department budgets (Revenue and Expenditure Budget, Cash Flow Budget)

    2. Project activity and capital expenditure management

    3. Procurement planning

    4. Data consolidation for management reporting

    Project Management:

    • 20+ self-managed teams

    • 7 external contractors

    • 4 planning levels: roadmap → project plan → release plan (sprints) → task backlog

    • Planning horizon: over 3 months at all levels

    • Real-time transparency

    • Over 100,000 man-hours invested in the project

    User Training:

    • Over 500 man-hours of training for key users

    • Over 50,000 hours in total, considering all participants

    • On-duty rooms during the first business process run

  • Project geography

    Implementation:

    • Geographically distributed team of development, analytics, and implementation specialists

    Project results are used by:

    • All operational units of the group worldwide

    • 50+ subsidiaries and affiliated structures

    International presence of the group (countries with operating subsidiary banks and branches):

    CIS: Armenia, Belarus, Kazakhstan, Azerbaijan

    Asia: China, India

    Scale of coverage:

    • Over 1,000 points of presence worldwide experienced the implementation results

    • 4 countries with operating subsidiary banks

    • 2 countries with branches and representative offices

    • 6 countries of the group's international presence affected by the project

Comment

Only authorized users can comment.
We suggest you or register.

  • Customer

    VTB Bank (PJSC)

We use cookies for analytical purposes and to deliver you the best experience with our website. Continuing to the site, you agree to the Cookie Policy.