Experience

Freedom Finance Europe Ltd

• Cyprus
• Financial Services
• 1 - 100 Employee

• Reconciliation officer

  • Sep 2022 - Present

  - reconciliation of securities at the end of the day with higher-level brokers - reconciliation of money flow - search for deviations and their causes - interaction with neighboring departments to eliminate discrepancies - automation of reconciliation reports - work with various databases and comparing data from different sourses - control over the reporting of counterparties - work with data base using SQL - creation reports using Power Query - daliy work with Excel,… Show more - reconciliation of securities at the end of the day with higher-level brokers - reconciliation of money flow - search for deviations and their causes - interaction with neighboring departments to eliminate discrepancies - automation of reconciliation reports - work with various databases and comparing data from different sourses - control over the reporting of counterparties - work with data base using SQL - creation reports using Power Query - daliy work with Excel, VBA, SQL, Power Query Show less - reconciliation of securities at the end of the day with higher-level brokers - reconciliation of money flow - search for deviations and their causes - interaction with neighboring departments to eliminate discrepancies - automation of reconciliation reports - work with various databases and comparing data from different sourses - control over the reporting of counterparties - work with data base using SQL - creation reports using Power Query - daliy work with Excel,… Show more - reconciliation of securities at the end of the day with higher-level brokers - reconciliation of money flow - search for deviations and their causes - interaction with neighboring departments to eliminate discrepancies - automation of reconciliation reports - work with various databases and comparing data from different sourses - control over the reporting of counterparties - work with data base using SQL - creation reports using Power Query - daliy work with Excel, VBA, SQL, Power Query Show less



Alfa-Bank

• Russian Federation
• Banking
• 700 & Above Employee

• Reporting Analyst

  • Jun 2022 - Aug 2022

• Data Analyst

  • Sep 2019 - Jun 2022

  * forecast and planning of banking products profitability * construction of models for calculating the profitability of banking products * plan/fact analysis * preparation regular reports and their automation * come up with new reports in Excel for managers * preparation of presentations for management in PowerPoint, using Think Cell * perform various ad-hoc tasks * work with different sourse of information and their compairing, find mistakes and correction * work… Show more * forecast and planning of banking products profitability * construction of models for calculating the profitability of banking products * plan/fact analysis * preparation regular reports and their automation * come up with new reports in Excel for managers * preparation of presentations for management in PowerPoint, using Think Cell * perform various ad-hoc tasks * work with different sourse of information and their compairing, find mistakes and correction * work with Oracle programm; * work with MSSQL, PLSQL Developer using database queries (join, subquery) * calculation of motivation/ KPI for bank employees * preparation data for calculating the number of employees model * have experience in creating dashboards in Power BI/Google Data Studio Now I use: Excel, Power Query, Power Point, Power BI, SQL, Confluence, Oracle, Think Cell, MS Outlook



Volkswagen Group Rus

• Motor Vehicle Manufacturing
• 300 - 400 Employee

• External Analyst

  • Sep 2018 - Sep 2019

  Held the position of an external analyst. Urban Science remained to be my official employer, but geographically I worked in the office of Volkswagen Group Rus. Main responsibilities: * checking the quarterly reports of the DC * identifying mistakes in the reports * business trip to the DC / conducting training / presentation * making adjustments to the report Held the position of an external analyst. Urban Science remained to be my official employer, but geographically I worked in the office of Volkswagen Group Rus. Main responsibilities: * checking the quarterly reports of the DC * identifying mistakes in the reports * business trip to the DC / conducting training / presentation * making adjustments to the report



Urban Science

• United States
• Automotive
• 500 - 600 Employee

• Business Intelligence Analyst

  • Sep 2017 - Sep 2019

  * Monthly gathering information of the dealer net`s financial statements: - new car department - used car department - parts & accessories - work shop and body & paint - admin & indirect costs * Checking received reports and identifying mistakes * Communication with dealers and adjusting all mistakes * Analysis of dealer net performance (month, quarter, year) - calculation KPI - identifying reasons for the growth and decline in profitability of the network -… Show more * Monthly gathering information of the dealer net`s financial statements: - new car department - used car department - parts & accessories - work shop and body & paint - admin & indirect costs * Checking received reports and identifying mistakes * Communication with dealers and adjusting all mistakes * Analysis of dealer net performance (month, quarter, year) - calculation KPI - identifying reasons for the growth and decline in profitability of the network - preparing the presentation for the car importer and explanation the current market situation * Preparing report for the car importer request * Consulting dealers regarding uploading reports into the system * Supporting system, updating relevant information in there * Creating new automatic reports and communication with IT department * Visiting dealer center to teach staff in filling and uploading reports and to demonstrate features of the system Show less * Monthly gathering information of the dealer net`s financial statements: - new car department - used car department - parts & accessories - work shop and body & paint - admin & indirect costs * Checking received reports and identifying mistakes * Communication with dealers and adjusting all mistakes * Analysis of dealer net performance (month, quarter, year) - calculation KPI - identifying reasons for the growth and decline in profitability of the network -… Show more * Monthly gathering information of the dealer net`s financial statements: - new car department - used car department - parts & accessories - work shop and body & paint - admin & indirect costs * Checking received reports and identifying mistakes * Communication with dealers and adjusting all mistakes * Analysis of dealer net performance (month, quarter, year) - calculation KPI - identifying reasons for the growth and decline in profitability of the network - preparing the presentation for the car importer and explanation the current market situation * Preparing report for the car importer request * Consulting dealers regarding uploading reports into the system * Supporting system, updating relevant information in there * Creating new automatic reports and communication with IT department * Visiting dealer center to teach staff in filling and uploading reports and to demonstrate features of the system Show less



Nord Auto Group

• Tver, Russia

• Financial Analyst

  • Jan 2016 - Sep 2017

  * Budgeting and forecasting (month, quarter, year) - communication with the head of departments - identifying the point of growth and cost cutting ways - creating budget * Providing plan/fact analysis and preparing presentations with period results for the top managers * Consolidation company group financial reports * Сontrol and analysis of receivables and payables * Preparing of payment registers * Monitoring and control of open work orders * Preparing reports… Show more * Budgeting and forecasting (month, quarter, year) - communication with the head of departments - identifying the point of growth and cost cutting ways - creating budget * Providing plan/fact analysis and preparing presentations with period results for the top managers * Consolidation company group financial reports * Сontrol and analysis of receivables and payables * Preparing of payment registers * Monitoring and control of open work orders * Preparing reports for banks * Сonducting an inventory in dealer centers Show less * Budgeting and forecasting (month, quarter, year) - communication with the head of departments - identifying the point of growth and cost cutting ways - creating budget * Providing plan/fact analysis and preparing presentations with period results for the top managers * Consolidation company group financial reports * Сontrol and analysis of receivables and payables * Preparing of payment registers * Monitoring and control of open work orders * Preparing reports… Show more * Budgeting and forecasting (month, quarter, year) - communication with the head of departments - identifying the point of growth and cost cutting ways - creating budget * Providing plan/fact analysis and preparing presentations with period results for the top managers * Consolidation company group financial reports * Сontrol and analysis of receivables and payables * Preparing of payment registers * Monitoring and control of open work orders * Preparing reports for banks * Сonducting an inventory in dealer centers Show less