Learn Data Skills
Beta
Vitalii Lahodiuk

Vitalii Lahodiuk

Certified

Data Analyst

TIP Trailer Group | Poland Warszaw

Technologies

My Portfolio Highlights

My New Course

Introduction to Data Visualization with Seaborn

My New Course

Data Manipulation with pandas

My New Course

Joining Data with pandas

My New Course

Introduction to Data Visualization with Seaborn

Champion of data integrity, ensuring accuracy in the age of information overload.

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Data Engineer Associate

Data Engineer Associate

Data Analyst Associate

Data Analyst Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Understanding Artificial Intelligence
Introduction to Power BI

My Work Experience

Where I've interned and worked during my career.

TIP Group | Mar 2024 - Present

Senior - FP&A Data Analyst

• Enhancing SAC and PowerBI for ongoing improvements in budgeting, forecasting, and reporting. • Supporting data gathering and analysis for reports to functional owners such as Commercial, Pricing, and Asset Management. • Developing and delivering monthly performance reports, including P&L, Cash Flow, and Balance Sheets, along with related commentary for senior leadership. • Standardizing and developing new monthly reporting processes, identifying opportunities to streamline existing processes, and eliminating inefficiencies. • Assisting in planning cycles, developing financial models, and preparing strategic scenario analysis on key business drivers. • Driving improvements in analytical reporting and performing ad-hoc assignments/projects as needed to support FP&A initiatives. • Managing monthly reporting to shareholder and supporting short-term forecasting in partnership with regional commercial and finance teams.
Show More

TIP Group | Feb 2022 - Mar 2024

ABS/Investor Relations Analyst

• Assisted in funders and banks presentations and reporting, including the annual report. Conducted forecasting scenarios and modeled ABS refinancing to ensure accurate financial projections. • Cultivated and strengthened relationships with funders, banks, and shareholders on a day-to-day basis. Leveraged banking capabilities to facilitate the company growth. • Ensured strict compliance with covenants and terms & conditions outlined in the ABS agreements. • Supported the Treasury and Investor Relations Director in delivering high- quality presentations and reports to both internal and external stakeholders, while efficiently handling ad hoc requests. • Provided financial support to other functional areas in alignment with the business strategy and targets. Collaborated with the controllership, tax, and treasury teams to ensure the implementation of robust internal controls. • Utilized recurring and ad-hoc analytics to support the SLT in effectively managing the ABS structure. • Ensured strict compliance with local regulations and internal TIP policies and procedures. • Assisted the Treasury and Investor Relations Director in providing analytics that supported the SLT in driving strategic, sustainable, and profitable growth.

TIP Group | Aug 2022 - Jan 2023

Finance Projects Coordinator

• Provide comprehensive support to the controllership department by assisting with daily and ad hoc tasks. • Conduct monthly reviews and analysis of all balance sheet accounts, devising and implementing action plans to clear aged items and ensure accurate reporting. • Take responsibility for the maintenance and clearing of post-merger items, ensuring seamless integration and streamlined financial processes. • Collaborate with the outsourced team to enhance the quality of Blackline reconciliation, optimizing accuracy and efficiency.

TIP Group | Jun 2020 - Jul 2022

Finance Operations Accounting Coordinator

• Supporting operational activities of AP/AR specialists responsible for preparing and reconciliation of Cash accounts (Bank Recs). • Being a backup for the manager in terms of team management and work organisation. • Identifying opportunities for process re-engineering/improvement and driving changes together with other team members. • Supporting operational activities person responsible for reconciliation of all T&L accounts. • Leading of Deferred Revenue booking process • Month-end, Quarter-end, and Year-end closing • Preparing evidence and support during financial audits • Providing accrual information to the local finance • Maintenance of AP/AR/Bank payments/GL system Interfaces

TIP Group | Jul 2019 - May 2020

Finance Operations CoE Coordinator

• Cooperation of the teamwork, ensuring efficiency of performed activities and providing necessary support to team member in terms of process knowledge and system specification. • Responsibility for UK (Great Britain, Ireland)/Central (Poland, Czech Republic, Romania, Germany, Austria)/Headquarter • Being a backup for the manager in terms of team management and work organisation. • Analysing problematic/ineffective areas and suggesting ideas to change and improve processes managing related projects. • Managing preparation and maintenance of process documentation, ensuring that procedural changes/new initiatives are reviewed and fully communicated. • Supporting operational activities of the team: invoice processing, vendor payments, account payable and receivables transactions reconciliation.

TIP Group | Dec 2018 - Jun 2019

Finance Specialist for AP & AR

• Responsibility for AP/AR of UK and Nordics regions • Develop AP Super user skills with the aim of becoming the “go to person” on AP system issues • Understand and control on a real time basis the inflows and outflows of the AP accounts • Process invoices using OCR technology • Process payments and vendor master data change requests • Clear remaining bank items • Follow up on reconciliation open items • Manage AP Sub Ledger/GL Interface Controls • Leading monthly reconciliations. Perform reconciliation cycle within 5 days pushing further automation of the reconciliations and reduce open items to minimum with support from the regions • Leading monthly and quarterly financial close • Assist production of AP BOC Report; plus have an ability to present such reports in Team meetings • Update policies & procedures • Provide training on a European level on TIP’s AP Processes • Refund Processing/Payments • Post VAT Refund on Write-Offs • Post Bank Journals not allocated by Cash Allocators

TIP Group | Mar 2018 - Nov 2018

Junior Finance Specialist for AP & AR

• Responsibility for AP/AR of UK and Nordics regions • Communication between regional AP super users and outsourcing organisation of invoice processing • Clear remaining bank items • Follow up on reconciliation open items • Manage AP Sub Ledger/GL Interface Controls • Supporting monthly reconciliations. Perform reconciliation cycle within 5 days pushing further automation of the reconciliations and reduce open items to minimum with support from the regions • Supporting monthly and quarterly financial close • Refund Processing/Payments • Post VAT Refund on Write-Offs • Post Bank Journals not allocated by Cash Allocators

TIP Group | Oct 2017 - Feb 2018

FINOPS Intern

• Supporting of senior person on the Benelux and Med Regions, both AP and AR • Support on overall Finance Operations processes • Prepare daily balance sheet reconciliation & month – end close consolidation and regularly follow up on open items • Manage payment cycles in cooperation with Treasury department • Improve analysis of Key Performance Indicators (KPI) and reporting to optimise existing processes and eliminate inefficiency according to business requirement • Provide finance operation support (training, best practice sharing, operational excellence & guidance) to the regions and the regional super users • Support the Tax & Controllership departments ensuring appropriate FinOps back up and documentation in place during audit • Support monthly FinOps department meetings • Ad-hoc requests from senior management

My Education

Take a look at my formal education

Master's degree, Accounting and FinanceAkademia Leona Koźmińskiego | 2017
Bachelor's degree, Finance, GeneralTernopil Academy of National Economy | 2015

About Me

Vitalii Lahodiuk

Result oriented in work, possessing strongly developed analytical skills. Passionate about new knowledge and new technologies. I believe that IT and economical knowledge should complement each other. The future is already here and such things as Big

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free