Олег

OLEH JUNIOR DATA ANALYST
Junior Data Analyst with practical experience gained through personal and educational

MAKHNO
projects. Skilled in SQL, Excel, Power BI, and basic Python (pandas, numpy). Analyzed
data in self-directed projects on salary trends and advertising campaign performance,
where I created dashboards, wrote analytical queries, and prepared reports. One of the
outcomes was identifying the most effective advertising channels and optimizing the
marketing budget. I am eager to apply my data skills to solve real business problems
CONTACTS and grow in the analytics field.

[открыть контакты](см. выше в блоке «контактная информация») PROJECT EXPERIENCE
[открыть контакты](см. выше в блоке «контактная информация») Data Science Salaries Analysis
Telegram Tools: SQL, Tableau Public
LinkedIn Description: Conducted an analysis of salary trends in the Data Science field using
Lviv, Ukraine open datasets. Explored various aspects such as salary distribution by role, seniority,
location, and work setup (remote vs on-site) to uncover industry patterns.
HARD SKILLS My tasks: Data cleaning and transformation using SQL. Salary segmentation by role and
SQL experience level. Analysis of salary trends over time. Visualization of key findings in
Python Tableau Public
Advertising Campaign Analysis Result: Average salary grows over the years. The largest growth was in the period from
Visualization and creation of 2021 to 2022. The highest salary is in the USA and Venezuela. Executive-level salary is
dashboards 2 times higher than Entry-level.
A/B Testing Facebook & Google Ads Performance Analysis
Product Analysis Tools: SQL, Tableau, Google Sheets
Description: Conducted an in-depth analysis of advertising campaigns on Facebook and
TOOLS Google, leveraging key performance metrics such as ROMI, CPL, CTR, and CPM.
Google Sheets My tasks: Data preparation using SQL. Calculation of performance KPIs (ROMI, CPL,
DBeaver CTR, CPM). Comparative analysis of Facebook vs Google campaign efficiency.
Tableau Identification of patterns.
Looker Studio Result: Facebook Ads to outperform Google Ads across most metrics. Recommended
discontinuing low-performing campaigns. Identified top-performing campaigns:
SOFT SKILLS Lookalike, Wholesale, Discounts

Team player WORK EXPERIENCE
Company name and position not disclosed due NDA
Time management
February 2025 – May 2025
Multitasking
Participated in a confidential project under a non-disclosure
Adaptability
agreement.Responsibilities, tools, and project scope cannot be disclosed due to
Analysis and decision making
confidentiality terms
Honesty
Note: Engagement ended early due to a temporary health-related leave from
LANGUAGES professional activities
Vuyko Sam Distillery
English - elementary
Senior Shift Worker
Ukrainian - native
November 2023 – February 2025.

EDUCATION Main responsibilities:
Planned and organized production processes, distributing tasks among team members.
IT School GoIT Monitored compliance with production standards and quality control in all stages of
2025; Data Analysis product manufacturing. Developed training programs and instructional materials.
Trained, supported, and integrated new staff into the team. Executed special
Lviv Polytechnic National University assignments from senior managemen.
2020-2024; Bachelor's degree, Achievements: Career growth from line worker to senior shift worker. Reduced and
Food technology improved the adaptation period for new employees by developing written and video
instructions