Aleksandr Popov Email and Phone Number

Key achievements:• Automated the bank's liquidity reporting process, reducing generation time significantly and enhancing operational efficiency.• Designed and developed data marts for various banking products.• Implemented integrations between data storage systems, software, and multiple banking source systems.Main responsibilities: • Collaborated with internal stakeholders, users, and cross-functional teams to gather and analyze requirements, define user stories, and establish acceptance criteria for product features and enhancements.• Worked closely with development and analyst teams during sprint planning and execution, ensuring that user stories were clearly understood, accurately estimated, and delivered on time in alignment with sprint goals.• Led the analysis, design, and development of data storefronts within a data warehouse, while automating existing processes for the Treasury Department using Python and PL/SQL to improve operational efficiency.• Designed, developed, and implemented unified data marts for the Treasury Department.

Key achievements:• Designed and developed algorithms and interfaces for generating Dynamic Balance, enabling daily calculation and prediction of the Bank’s profit and loss (P&L), significantly improving financial forecasting accuracy.• Automated data retrieval processes by introducing Python to load indicators, trading results, auction data, and other key information from web pages, streamlining workflows and reducing manual effort.• Implemented an operational system for calculating the Net Stable Funding Ratio (NSFR), ensuring compliance with regulatory requirements and improving the Bank’s liquidity management.Main responsibilities: • Oversaw MS SQL Server processes, including ETL operations, data quality checks, and data enrichment tasks to ensure smooth and efficient data management workflows.• Produced detailed analytical reports for the Treasury Department, covering critical areas such as accounting, liquidity management, regulatory compliance, funding, and pricing.• Developed and maintained an ALM (Assets and Liability Management) system with a user-friendly interface, enabling employees to easily access and visualize data related to clients, deals, and accounts through tables, pivot grids, and reporting functionalities.• Prepared data and designed algorithms for the calculation of Profit and Loss (P&L) reports, while also forecasting the assets and liabilities portfolio to support financial decision-making.

Key achievements:• Developed and implemented an operational forecasting system for liquidity regulations, enabling precise predictions and preventing regulatory violations. This solution significantly improved the Bank's ability to monitor and maintain compliance with liquidity standards.• Led the accurate migration and seamless integration of data during a major bank merger, a project recognized as the “Project of the Year 2015” for its success in ensuring uninterrupted reporting operations.• Overhauled the Treasury reporting system by enhancing data management capabilities and establishing robust data quality control processes. This initiative greatly improved the granularity and accuracy of reports, leading to more reliable financial insights.

Key achievements:• Led the migration of the department's reporting system from MS Access to MS SQL Server, enhancing data processing capabilities and improving overall system reliability.• Contributed to the development and implementation of an ALM system, successfully migrating existing reports to the new platform. This initiative significantly accelerated decision-making for managing the bank's liquidity and strengthened operational control.• Integrated SSIS (SQL Server Integration Services) into the ETL process on MS SQL Server, optimizing data extraction, transformation, and loading workflows, resulting in more efficient and automated data management.