Вікторія

Viktoriia Chaika
Junior Data Analyst
Lviv, Ukraine | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація») | Telegram: @viktoriiachaika97 |
LinkedIn: [відкрити контакти](див. вище в блоці «контактна інформація»)

SUMMARY
Aspiring Data Analyst with a background in management, sales, marketing and customer service. Currently developing practical
skills in SQL, PostgreSQL, Google Sheets, Excel, BigQuery and data visualization through hands-on projects. Experienced in
working with large amounts of information, solving problems, communicating with different stakeholders and making decisions
in a fast-paced environment. Looking for a Junior Data Analyst opportunity to apply analytical skills to real business problems
and continue growing in data analytics.

HARD SKILLS
SQL • Data Analysis • Data Cleaning • Data Transformation • Data Validation • Cohort Analysis • Retention Analysis • Data
Visualization • Business Metrics • Product Analysis • Data Storytelling • A/B Testing • Statistics • Python • Conversion Rate •
ARPU • LTV • Churn Rate

TOOLS
PostgreSQL • Google Sheets • Microsoft Excel • BigQuery • Tableau • Power BI • Looker Studio • Pandas • NumPy • Matplotlib
• Seaborn • Jupyter Notebook

SOFT SKILLS
Analytical Thinking • Information Research & Interpretation • Attention to Detail • Critical Thinking • Structured Thinking •
Data-Driven Problem Solving • Communication • Time Management • Teamwork • Adaptability

PROJECT EXPERIENCE
Cohort Analysis: User Retention & Promo Performance
Technologies: PostgreSQL, SQL, Google Sheets
Project link: https://docs.google.com/spreadsheets/d/1yfGf4Pe3Y72m8UOTHR6lu9P6Kidq2vJLya-b7se3Fu0/edit ●
Conducted cohort analysis to evaluate user retention over time and compare cohorts based on promotional sign-up status. ●
Cleaned and standardized raw user and event data.
● Joined user and event datasets and excluded test events and invalid records.
● Created monthly cohorts, calculated month offsets and retention rates, and built cohort tables. ●
Compared retention dynamics across promotional and non-promotional user groups.
● Result: identified a gradual decrease in retention over time and differences between user groups.

Digital Advertising Performance Dashboard
Technologies: Tableau
Project link:
https://public.tableau.com/views/Facebook_Google_ads_analysis/DigitalAdvertisingPerfomanceDashboard?:language=
en-US&publish=yes&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
● Analyzed Facebook and Google advertising campaign data to evaluate performance and efficiency. ●
Built an interactive Tableau dashboard with KPI overview and campaign analysis.
● Analyzed Spend, Impressions, Clicks, Leads, CTR, CPC, CPL, CPM and ROMI.
● Compared campaign performance, identified trends and analyzed the relationship between spend and leads. ●

Created campaign rankings, efficiency analysis and interactive filters.
● Result: created a dashboard for evaluating digital advertising performance and identifying campaign efficiency trends.
WORK EXPERIENCE
Manager — InshiApartments | March 2025 – Present | Lviv, Ukraine
Manage guest bookings and customer communication across 44 apartments, handling up to 30 bookings per shift. Work with
CRM for reservations and daily operations. Respond within 5 minutes, resolve complex situations, train new managers, and
coordinate with internal teams.
Achievement: Maintained 90%+ service performance.

Marketing & Communications Manager — Prouvé Ukraine | June 2020 – September 2022
Managed website updates, products, promotions and marketing materials; managed social media and created content; prepared
presentations and webinar materials; organized and hosted webinars and seminars.

Sales Manager — Family Gold Masters | October 2019 – June 2020
Consulted customers, managed the full sales process, built customer relationships, handled objections and individual
requests, and worked toward sales targets.

Administrator — Beauty Salon | September 2018 – August 2019
Managed daily administrative operations, appointments, payments and customer communication; coordinated client requests
and staff schedules; resolved customer issues.

LANGUAGES
English — Pre-Intermediate | Ukrainian — Native

EDUCATION
● IT School GoIT — Data Analysis | Apr 2026 – Oct 2026
● Ivan Franko National University of Lviv — Master’s Degree in Journalism | Sep 2018 – Dec 2019 ● Ivan
Franko National University of Lviv — Bachelor’s Degree in Acting — Actress of Dramatic Theatre and Cinema
| Oct 2014 – Jun 2018