Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Taras Utkin

Taras Utkin

Data Analyst | Financial Analyst | Reporting & Forecasting Expert
Batumi

Summary

Data-driven and results-oriented Data Analyst with extensive experience in financial reporting, forecasting, and data visualization. Skilled in optimizing financial processes, automating reporting systems, and deriving actionable insights from data. Proven ability to collaborate with cross-functional teams and deliver reports that support executive decision-making. Adept at working with tools like SQL, Power BI, Python (Pandas), and UiPath RPA to streamline processes and drive business value.

Overview

7
7
years of professional experience
3
3
Certifications
2
2
Languages

Work History

Data Analyst in Revenue Forecasting

EPAM Systems
08.2023 - Current
  • Aggregate and clean data from multiple sources, including CRM systems, SQL Server, and SAP.
  • Develop daily reports for top management, utilizing Power BI for visualizations and ensuring data accuracy.
  • Write optimized SQL queries and implement DAX for custom financial calculations.
  • Collaborate with cross-functional teams to ensure reporting aligns with business needs.

Key Achievements:

  • Reduced report refresh time by 30% by optimizing Power BI calculations.
  • Automated data extraction processes, reducing manual work by 40%.
  • Increased forecasting accuracy by 15% through new methodologies.

Control & Reporting Analyst

PepsiCo
09.2020 - 08.2023
  • Managed monthly and quarterly reporting in compliance with corporate standards.
  • Led financial KPI analysis and preparation of Quarter BSR.
  • Coordinated with internal and external auditors to ensure compliance.
  • Automated financial reporting using Python (Pandas) and Power BI.

Key Achievements:

  • Reduced X-charge reconciliation discrepancies by 60% in one year.
  • Improved external audit accuracy by automating data collection processes.
  • Built and deployed a Power BI dashboard for asset management, improving reporting efficiency by 50%.

Accounting Supervisor

Marriott International
10.2017 - 09.2020
  • Managed financial reporting, including analysis of cash flow and monthly closing procedures.
  • Ensured accuracy and compliance of financial records in SUN System.
  • Collaborated with departments and mentored staff to meet reporting deadlines.
  • Led the implementation of new ERP systems (including Material Control by Oracle and Opera Hospitality).

Key Achievements:

  • Reduced reporting time by 20% through automation of recipe write-offs in Material Control by Oracle.
  • Enhanced financial reporting accuracy and transparency.
  • Successfully transitioned to a new ERP system and provided team training.

Education

Bachelor of Science - Economics And Management

Voronezh Economic And Law Institute
Voronezh, Russia
04.2001 -

Skills

  • Data Analysis & Reporting: SQL, Power BI, Python (Pandas), Excel
  • Forecasting & Financial Modeling: Revenue Forecasting, Financial Reporting
  • Automation & Process Optimization: UiPath RPA, Data Cleaning & Aggregation
  • Tools & Systems: SAP, CRM, Oracle, SUN System, Opera Hospitality
  • Soft Skills: Cross-functional Collaboration, Project Management, Mentorship

Certification

Microsoft Certified: Power BI Data Analyst

Timeline

SQL for Data Analysis

08-2024

Power BI Quick Tips

08-2024

Data Analyst in Revenue Forecasting

EPAM Systems
08.2023 - Current

Microsoft Certified: Power BI Data Analyst

02-2023

Control & Reporting Analyst

PepsiCo
09.2020 - 08.2023

Accounting Supervisor

Marriott International
10.2017 - 09.2020

Bachelor of Science - Economics And Management

Voronezh Economic And Law Institute
04.2001 -
Taras UtkinData Analyst | Financial Analyst | Reporting & Forecasting Expert