Database and Macroeconomics Analyst/Deputy Head of the Treasury

Responsibilities:

Databases:

• Creating forms and maintaining databases in Excel
• Work with structured data using the following programs:
• Excel (VBA): complex graphs, macros, functions, formulas all functionality
• BI: creating individual queries and procedures
• PL / SQL: work with large amounts of data, Oracle programming
• Interaction of databases on different platforms

Management reporting:

• Creating periodic reports of the Treasury (liquidity, normatives, profitability, KPI, currency position, etc.) and presenting them to management and users in the form of presentations, tables, comparisons.
• Analysis of indicators and their dynamics.

Analysis of counterparty banks, sovereigns and NBFIs:

• Analysis of counterparty performance indicators based on reporting according to IFRS and IFRS (annual / quarterly / monthly): Cost-to-income, ROA, ROE, CAR, NPL ..
• Writing analytical queries to set limits for transactions in financial markets. Monitoring of counterparty banks, credit risk assessment.
• Preparation of presentations for submission of requests to credit committees
• Monthly monitoring of financial condition and dynamics of counterparties, determination of classes for reserves according to P.351

Risk Management:

• - Calculation, modeling and supervision of statutory standards:

NBU: Liquidity ratios H2-H12, currency position L-13, and reserve ratios

Group risks: liquidity gaps in the trading book, use of trading book limits, transfer pricing, etc

Macroeconomics Analysis:

• Writing daily macroeconomic reports / paragraphs and weekly reviews of major changes in the global economic space.

Senior manager. Banking Supervision Department, Foreign Banking Supervision Department.

- Supervision of banks by foreign banking groups (diverse in-depth knowledge of the bank's activities as an organization).

Senior manager. Banking Supervision Department, Foreign Banking Supervision Department.

• Supervision of banks by foreign banking groups (diverse in-depth knowledge of the bank's activities as an organization).

1. Center Group (Karavan Group) (one of the largest national holdings, assets under control over $ 250+ million.)

Treasurer of the management company (part of the financial department).

• Runing the nostro position of the management company.
• Payment calendar of settlements (calendar of investments, expenses, credit payments, dividends, etc.)
• Management reporting, accounting of shareholders' investments/withdrawals.
• Interaction with banks (residents and non-residents): obtaining loans, servicing and optimizing the existing loan portfolio, currency exchange operations.
• Initiation/withdrawal of investments from abroad, registration of investments in the NBU.

Main responsibilities:

• responsible for key customers' projects: МТС, Nokia Siemens Networks Ukraine, NEC "Ukrenergo", JSC "Kyivstar", JSC "Ukrtelecom", Dalekovod, Powerstorm Inc.;
• project management (project documentation; coordination of interactions between divisions: designers, assemblers, logistics, service department; planning and executing);
• preparation and participation in tenders.

Key achievement: implementation of the projects in strict accordance with terms, project documentations and customers' budgets. Executive manager of project for «МТС» 122 Base stations of connection in the Donetsk region, term of project 6 months. Won the tender of Huawei (installation and commissioning), Nokia Siemens Network (installation of basic station LTE in Kazakhstan) and Urkenergo (equipment).

Analysis of credit applications, definition of solvency, the definition class of client, financial analysis of small and medium businesses, work with databases, issue of loans, administration of issuance of credits; keeping a register of applications and their status, writing daily and monthly management reports.