Pavlo Miroshnyk Email & Phone Number

Leuven, Flanders, Be

Leuven, Flanders, Be

Belgium

Kyiv City, Ukraine

1. As part of the second line of support, provided assistance to internal users in resolving complex issues related to reporting in the bank's main accounting system. Simple issues were handled by other staff members in the first line of support.Executed complex SQL queries in the ORACLE database to identify and rectify mistakes in data and procedures, thereby providing valuable assistance to users.2. Proficiently installed and executed updating scripts for the bank's main accounting system using tools such as Script Runner or SQL*Plus.3. Created detailed troubleshooting documentation to assist first-line support staff in resolving technical issues related to reporting processes.4. Provided support for the data processing management subsystem, which included a scheduler responsible for launching all automated tasks in the bank. These tasks encompassed a wide range of activities such as calculating interest, forming payments, reconciling funds, reparing data, and cleaning up space (over 400 different tasks in total).5. Actively participated in multiple projects focused on process automation.

Kyiv City, Ukraine

Automated manual accounting tasks for internal users within a large agricultural holding by utilizing MS Excel, Power Query, and SQL Server. Developed solutions to collect and integrate large volumes of data from diverse accounting systems. Created and analyzed reports by collecting data from various sources and performing data integration. Employed data combination techniques to generate comprehensive reports.

Kyiv City, Ukraine

Managed loan portfolios and facilitated the preparation of loan applications in collaboration with lending banks. Successfully processed substantial volumes of economic information from multiple accounting systems within a group of companies.

Kyiv City, Ukraine

Сontrolled all types of banking risks - сredit risk (IFRS-provision, PD, LGD, roll-rate, loan portfolio reports, other various limits), operational risk (various limits, reports), liquidity risk (GAP-analysis, liquidity limits, limits of interest rate risk). Сollaborated with external audit (Ernst&Young, PricewaterhouseCoopers). Working with accounting system ABS B2 (using Oracle) at the database level with the SQL

Kyiv City, Ukraine

Handled the reserving of legal entity portfolios and worked with information pertaining to groups of related borrowers. Generated various reports concerning the credit risk of legal entities, providing valuable insights and analysis.

Kyiv City, Ukraine

Organized and supported centralized reserve formation in the bank system (NSB0) as per Resolution No. 279/23, including forecasting, calculation, and back office order submission. Developed MS Access-based software for reserve calculation.Provided methodological support for the reservation system, improving accounting systems' efficiency for data management and reporting.Forecasted loan portfolio quality using PD, LGD, Roll-Rates, and Vintage Analysis.Prepared analytics on key credit risk indicators.Calculated reserves according to IFRS (PD, LGD, Roll-Rates).Generated credit portfolio reports for audits and compliance.Monitored concentration limits (borrower, industry, region) for risk control.

Kyiv City, Ukraine

During my time at the bank, I held different positions and performed various tasks in the field of banking. I started as a Cashier-Economist for 8 months and then worked as a Treasurer for 2 years. Eventually, I became the Head of the Risk Management Department at the main office.

Specialist (5 Years Of Study), Accounting And Auditing, Subspecialty Finance And Credit

Specialist (5 Years Of Study), Subspecialty Finance And Credit

Education record