My functions as CIB financial analyst: Assisted in deal execution, Built financial models (DCF), Prepared presentations and reports for the Investment Committee, Optimization of working processes.
Calculation of drivers, optimization of senior employees number.
In the position of analyst, I have experienced a deep dive into the sunflower oil production, having business trips to the factories, meeting with the processes, and optimizing them. Optimization of reporting, Introduction of SQL database and moving processes there, Optimization and simplification of the processes using R and SQL, Optimization of the number of employees and drawing up control standards, Ad-hoc.
Conducting audit activities: Examination of financial statements open-sourced or given by an audited entity using Excel, Compilation of an auditor’s report using MS Word.
Working in SQL: conducting data research, uploading data according to conditions, and creating tables, Improvement of actual tools: upgrading SQL scripts and adding products to "Calculator," which is used to calculate deposits and define their conditions, Creation of financial models: calculating financial indicators and assessing the impact with and without the new deal (e.g. ‘Размещай-ка’). The deal was successful, Routine processes automation (e.g., I created a supportive table that defines how relevant interest is, etc.).