– Data Warehouse Management;–Metric system management (efficiency coefficients of organizational performance)–Development of new metrics and editing of existing onesTechnology stack: PostgreSQL, Apache Airflow, Python, Jira, ConfluenceAchievements: I developed and proposed for implementation an automated quality control scheme for metric calculations based on mathematical statistics.

– Developing algorithms for extracting, transforming and loading data (ETL) between systems and databases of the bank using Informatica Powercenter software.

– Managing the Analytics Department. Analytics and research for the Bank's top management.– Developing, creating and supporting Data Warehouse.– Writing Python programs and SQL-queries.– Supporting of existing and developing new forms of reporting.– Creating ETL algorithms. Integration of various sources of information into the Data Warehouse: databases on different servers, files in the local network, materials received by mail, uploads from personal accounts on the Internet or from the Bank's internal systems (automation of uploads based mostly on Selenium and Pyautogui packages), etc.– Automation of business processes for ordinary bank employees, construction of updated reports in Excel and Power Bi.The main tools used: SSIS, SSMS, T-SQL, PL / SQL, Python (pandas, selenium, pyautogui), Excel (Power Pivot, Power Query), VBA.Achievements:-- Creating and developing of DWH.-- Establishing the system of personalized automated e-mail reports on daily basis.

‒ Managing the Statistics Department (2 people under supervision) ‒ Performing econometric studies with Big Data (mostly working with financial reports, logistic data and climate statistics) ‒ Developing scoring methods for selecting the most suitable candidate companies for state support ‒ Preparing analytical materials for the Head of the Department of Economy and senior management (vice premier Arkady Dvorkovich, Deputy Ministers of Agriculture Dmitry Uriev and Elena Gangalo). ‒ Collecting statistics from the regional offices of the Ministry ‒ Developing new reporting forms.‒ Financial modeling of agricultural enterprises (both crops and livestock producers). ‒ Writing analytical reports on candidates for state support. Achievements: ‒ Participated in preparation of The Agricultural Insurance Plan for 2018 (registered with the Ministry of Justice on November 3, 2017) ‒ Developed a scoring method for companies based on aggregating various financial ratios into a single Z-Score ‒ Developed a system that precisely links climate statistics to specific agricultural enterprises by obtaining their geographical coordinates and determining the nearest meteorological stations using geodesic formulas

‒ Conducting market research, analytical reports, calculations, preparing financial models ‒ Analyzing the activities of the Administration as the owner/developer of new airports, as well as the asset-holder of aerodrome property ‒ Searching for airports, promising in terms of potential investment and creating public-private partnership (PPP) projects. ‒ Studying Russian and international experience in the creation of PPP infrastructure projects, especially in aviation Achievements: ‒ Assessed the economic effects of various reorganization options for the Administration (conversion of the organizational form from Federal State Enterprise to JSC / Federal Treasury Enterprise / Federal State-Funded Institution, removal or connection of airports, changing airports rents level, etc.) ‒ Prepared the Strategy of Administration in accordance with the governmental decree №499 and secured its approval in the parent organization (Federal Air Transport Agency).

‒ Creating the full package of project documentation - including investment memorandum, presentation, business plan, activity progress chart, milestone schedule (the major project ‒ radiation decontamination of medical waste). ‒ Negotiating with technology providers, experts, partner organizations, and other companies of Rosatom ‒ Financial modeling, calculation of IRR, NPV, EV, etc. ‒ Conducting market research ‒ Writing technical specifications ‒ Searching for investment ideas across the following sectors: hazardous waste, sorting of waste, water treatment, alternative energy (biofuel, RDF fuel), non-destructive control (gamma-defectoscopes), inspection systems (introscopes, neutron analyzers). ‒ Presenting results to the top management Achievements: ‒ Found reliable business partners and led a project of opening a UIC representative office in Spain to provide goods and services of UIC in the LATAM region ‒ Prepared projects that successfully passed first stages of reviewal by the investment committee of Rosatom. ‒ Created and implemented English language training for co-workers using a novel method (Confirmed by a certificate).

‒ Preparing research on the Russian private equity market, M&A and target industries (retail sector, telecoms, food industry, life science, etc.); ‒ Preparing analytical reports and writing of speeches for NRG managing partner's presentations for big international Private Equity conferences (Superinvestor Conference, SuperReturn Emerging Markets, C5 CEE&CIS, etc.) ‒ Participating in Due Diligence and valuation; ‒ Preparing regular reports for limited partners (LPs) of private equity fund Volga River One ‒ Working with legal documents, translating from English to Russian and vice versa; ‒ Managing the company web site. Achievements: ‒ Proposed and introduced a new system of media monitoring ‒ Prepared and implemented the outline of a new company web site