Жанна

Zhanna OLEKSICH
DATA ANALYST
About me
Data Analyst with a strong background in economics, accounting, and ESG analytics.
Transitioning into data analytics with hands-on experience in SQL, Python, Tableau,
and statistical analysis. 12+ years of experience in analytical research, data
interpretation, and project management in academia. Skilled in transforming complex
data into actionable insights, building dashboards, and applying data-driven
approaches to solving business problems.

Experience
Data Analyst 2025
Self-employed 2025 - 2026
Built analytical datasets using SQL (BigQuery), including CTEs, window functions, joins,
and aggregations
Performed data cleaning and transformation using Python (Pandas, NumPy)
Conducted exploratory data analysis (EDA) and identified key patterns and trends
Contact Developed interactive dashboards in Tableau and Looker Studio
[відкрити контакти](див. вище в блоці «контактна інформація») Worked with datasets related to sales, marketing, and user behavior
Applied statistical methods including hypothesis testing and A/B testing
[відкрити контакти](див. вище в блоці «контактна інформація»)
Associate Professor, Department of Accounting and Taxation
Telegram
Sumy State University 2012 – Present
LinkedIn Responsibilities:
Kyiv, Ukraine, remote Conducted analytical research and worked with large datasets in accounting and ESG
domains
Skills Developed and delivered courses
Spreadsheets: Pivot Tables, Data Supervised student research projects involving data analysis
Coordinated international academic projects and collaborations
Cleaning, Visualization Accomplishments:
SQL: Advanced Queries, Window Head of the Department (2022–2025)
Led department to top-10 ranking (9th out of 68)
Functions, Query Optimization, Project leader of Jean Monnet Module (Erasmus+)
Common Table Expressions (CTE) Participant in international academic mobility programs (Hungary, UK, Slovakia)

Python: Pandas, NumPy, Matplotlib,
Portfolio
Seaborn, Exploratory Data Analysis
Project 1 (SQL Projects) – SQL Analytics Project (BigQuery, Looker Studio)
(EDA) Built a consolidated analytical dataset using complex SQL (CTE, window functions,
Tableau: Interactive Dashboards, UNION); calculated key business metrics: user growth, email engagement, country
performance; designed dashboards in Looker Studio for trend analysis and
Data Storytelling, Publishing segmentation
Statistics: Sampling, Hypothesis Project 2 (Tableau Projects) – Tableau Sales Analytics Project (SQL, Python, Tableau)
Developed an end-to-end analytics solution combining SQL, Python, and Tableau; built
Testing, Correlation, Statistical interactive dashboards to analyze sales, customer behavior, and traffic channels;
Significance applied statistical analysis to support data-driven decision making
Project 3 (Python Projects) – Python Data Analysis Project (Pandas, Matplotlib,
A/B Testing: Planning, Analysis, Seaborn)
Reporting Conducted full-cycle data analysis: cleaning, merging, and transformation; built key
Reference business metrics (revenue, profit, delivery performance); identified trends, seasonality,
Other Tools: Jupyter Notebooks, and factors affecting profitability
Google Analytics, Excel
Education
Languages Data Analyst Program
Mate Academy 2025 - 2026
English (Intermediate)
Master’s Degree in Accounting and Auditing
Ukraine (Fluent) Ukrainian Academy of Banking of the National Bank of Ukraine 2002 - 2007