Мар'ян

SKIRKA MARYAN
Data Anal yst

CONTACTS SUMMARY
[open contact info](look above in the "contact info" section) Junior Data Analyst with strong analytical thinking and a passion for
data-driven decision-making. Experienced in SQL, Python, A/B testing,
[open contact info](look above in the "contact info" section)
and product metrics. Confident in working with l arge datasets, building
Linkedln dashboards, and delivering clear insights. Motivated to support teams
Telegram with accurate analysis and drive improvements.

Lviv, Ukraine

HARD SKILLS PROJECT EXPERIENCE
SQL
Ad Campaign Dashboard in Google Looker Studio
Tools : Google Looker Studio, SQL, PostgreSQL.
Python
As a Junior Data Analyst, I created an interactive dashboard in Google
A/B Tests
Looker Studio to analyze advertisingcampaign performance.
Product Metrics
I connected the report to a PostgreSQL database using a custom SQL
Google sheets
query to extract data on campaign names, dates, impressions, clicks, ad
spend, and revenue.
TOOLS I calculated key marketing metrics directly in Looker Studio, including
Google Analytics CPC, CPM, CTR, ROMI, and total Ad Spend.
DBeaver For visualization, I built:
1. A combo chart showing Ad Spend and ROMI by month,
Tableau
2. A line chart for tracking the number of active campaigns,
3.A heatmap table to compare campaign-level performance.
LANGUAGES To make the report dynamic, I added filters for campaign name and ad
English - Elementary date. This project helped me apply practical data analysis skills and build
Ukraine - Native clear, business-oriented dashboards.

WORK EXPERIENCE
EDUCATION
Puzata Hata
IT School “GoIT” Сook
Data Analysis March 2012 - June 2025
2025
Responsibilities
Ivan Franko National University of Lviv Cooking according to standards,
2007-2012 ensuring the necessary form of serving the meal,
Сomputer science design
maintaining cleanliness and tidiness at the workplace.
Achievement
Prevent risks,
Created something from scratch,
Helped others achieve their result - a colleague.