• Preparation of charts regarding bonds’ yield to maturity with annually compounded interest
• Control of loading quotes and rates of securities into the system
• Calculation of fair value of interest SWAPs
• Calculation of banks’ credit ratings
• Calculation of fair value of government bonds
• Calculation of yield to maturity curves

• Acquaintance with the activities and functional responsibilities of the colleagues of the Financial Department and the department of financial controlling
• Acquaintance with the direct functional responsibilities of the position held
• Acquaintance with the technical architecture and complex of systems and programs

• Group financial reporting to parent company
• Participation in preparation of Business Plan (BMA or SREP) to NBU
• Participation in filling of Financial Statements in XBRL-format (Taxonomy) to NBU (2020, 2021 years)
• Participation in preparation of Stand-Alone FS for 2021 year to NBU (BS, P&L, Equity, other Notes) and interaction with external auditors
• Reconciliation of BS and P&L XBRL-format (Taxonomy) vs Annual Report
• Interaction with developers of system InfoWare, DealWare, Scrooge-Analytics

Key achievements:

• Automation with Excel formulas of working files for group financial reporting to parent company
• Revision of clients’ data base in CW.Net to increase quality of data in BRP (Bundesbank Reporting Package) report, reduce the number of manual adjustments
• Organization and participation in automation of download of types of economic activities from CW.Net to IW

• Filling of P&L, Cash-Flow, BS for Group company from Account Card, Turnover-Balance Sheet reports from Program 1S
• Filling of plan data on General & Administrative expense in P&L for international financial company
• Development of template and its filling with data upon consolidated liabilities and daily consolidated liquidity
• Filling of actual data into block Operation, P&L, Cash-Flow
• Development and maintaining a register of intragroup loan agreements
• Processing data on services from suppliers to fill in Operational expenses
• Development and preparation of daily CRM-Bank Statements reconciliation
• Accounting, calculation and accrual of interest upon intragroup loans in QuickBooks Online Plus
• Design and filling of a register of agreements with suppliers
• Control of calculation of costs for services received from vendors

• Group financial reporting to parent bank
• Management reporting (Financial and Risk Management Review to bank Board and to Supervisory Board)
• Function of financial control (daily sanity checks, investigations and corrections under preparation of group financial reporting to parent company, payment invoices control)
• Financial reporting to NBU (quarterly interim financial statements and annual report of the bank to NBU audited by external auditors, partial preparation of business plan for 3 years to NBU)

Key achievements:

• Automation with Excel formulas of working files which are used as data basis for group financial reporting to parent company
• Preparation of quarterly interim financial reporting to NBU
• Preparation of annual report of the bank to NBU
• Implementation of full financial control function in Credit Europe Bank Ukraine

• Prepared group financial reporting to parent bank
• Executed Intercompany Reconciliation
• Performed Finance to Risk Reconciliation
• Processed LLP (Loan Loss Provisions)
• Consulted, participated in correspondence with contact persons from GBS Support Team (Head Office)
• Consulted local MRM (Market Risk Management), CRM (Credit Risk Management), FM (Financial Markets) and other back offices on respective questions
• Verified relevant manual entries in GBS (general ledger, data basis for GFRS – Global Financial Reporting System)
• Executed B2 (local general ledger, data base for the NBU’s reporting) - GBS - GFRS BS (Balance Sheet) and P&L monthly reconciliation
• Performed duties of secretary of LPC (Local Parameters Committee)
• Assisted and interacted with local rating agency “Credit-Rating”
• Assisted and interacted with external audit company “Ernst & Young”, “KPMG”
• Performed analysis of major competitors (market position analysis)
• Prepared MASS (management reporting) data for ING Lease Ukraine

Key achievements:

• Active and successful participation in the projects on the opening and closure of ING Bank Retail
• Active and successful participation in implementation of IFRS 9
• Participation in organization and transfer of group financial reporting to HUB (Manila) according to Head Office’s project of centralization

Internship:

• Monitored, controlled and checked group financial reporting of respective ING branches
• Consulted and supported contact persons in appropriate ING branches
• Assisted and interacted with GFRS Support and GFRA Support (HO)
• Assisted, supported and interacted with other HO contacts from Financial Consolidation Services Division

• Executed accounting of intra company transactions and administrative costs
• Controlled budget utilization with respect to administrative costs
• Calculated limits / thresholds of administrative costs
• Prepared internal use reporting

• Monitored budget utilization
• Prepared BS and P&L reports
• Controlled administrative costs
• Monitored balances on current accounts of legal entities
• Calculated liquidity gap
• Forecasted corporate customers’ balances on current accounts
• Calculated and supported reserve on correspondent account in the NBU
• Executed an interbranch lending, accounting