Альона

YEFIMENKO
ALENA ROFESSIONAL SUMMARY

Junior Data Analyst with hands-on experience working with large-scale financial
datasets in Excel. Strong background in process automation, financial modeling, and
data validation within Big 4 and treasury environment. Skilled in SQL and advanced
Excel for data transformation, reconciliation, and performance optimization. Focused
on turning raw data into structured insights and improving business efficiency.

Contact EDUCATION
National University of Kyiv-Mohyla Academy
[open contact info](look above in the "contact info" section)
Bachelor of Business Administration - Total GPA 96,34
[open contact info](look above in the "contact info" section) 2021 - 2025
Kyiv, Ukraine

PROFESSIONAL EXPERIENCE

Hard Skills Ernst & Young | Big 4 July 2025 - currently
Tax Audit
SQL: SELECT, WHERE, JOIN
(INNER/LEFT), GROUP BY, HAVING, Processed and validated large financial datasets (50k–500k rows) in
Excel for tax reporting and compliance.
subqueries (currently expanding to
Automated reconciliation workflows using advanced formulas
advanced queries and window functions)
reducing manual processing time by 50–75%.
Excel (Advanced): Pivot Tables, Built structured analytical files to improve data transparency and
XLOOKUP, INDEX & MATCH, reduce risk of calculation errors.
SUMPRODUCT, CONCAT, SEARCH, Performed financial data cross-checking and multi-source
nested IFs etc reconciliation.
Data Validation, financial modeling Conducted regulatory and tax research, transforming complex
information into structured summaries for decision-making.
Optimized spreadsheet architecture for improved scalability and
Data Work usability across teams.

Data Cleaning & Validation
“Nibulon” JV LLC February -July 2025
Large Dataset Processing (50k–500k) rows)
Treasury Specialist
Financial Data Analysis
Process Automation Analyzed cash flow data and monitored loan covenant compliance.
Built automated Excel models for interest and amortization
Reconciliation & Structured Data Analysis
calculations.
Developed structured financial tracking tools for deposits, maturities,
Soft Skills and interest rate analysis.
Analytical Thinking Improved internal calculation processes, reducing routine manual
work by ~50%.
Fast Learner
Supported dispute calculations with banks through structured
Discipline
financial modeling.
Time Management Worked with high-volume financial data ensuring accuracy and
Critical Thinking consistency.
Communication Skills
Problem Solving
Additional Education
Attention to Detail
Nibulon Ltd.| Microsoft Excel Pro
Languages W3Schools | SQL Education
English - Upper Intermediate Coursera | Databases and SQL for Data Science with Python (63% completed)