Олег

OLEH RIPAK
DATA ANALYST

SUMMARY
A responsible data analyst with strong attention to detail and a genuine passion for analytics — not
just as a job but as a way of thinking and living. I view working with data as a meaningful process
that combines logic, curiosity, and real business impact. My goal is not only to complete tasks but to
deeply understand the processes behind them and support better decision-making through high-
CONTACTS quality analytics. I constantly improve my technical skills and analytical thinking as I grow in the
industry.

Kyiv PROJECT EXPERIENCE
[відкрити контакти](див. вище в блоці «контактна інформація») Marketing Dashboard for Campaign Analysis

[відкрити контакти](див. вище в блоці «контактна інформація») Tools: Looker Studio, Google Sheets, SQL
Built an interactive dashboard in Looker Studio to analyze campaign performance over time.
Telegram: @HEILGAROV Tracked ROMI, Ad Spend, CPC, CPM, CTR. Prepared and cleaned data in Google Sheets, used SQL
for aggregation. Added filters for dynamic exploration and highlighted low-performing campaigns.
Linkedin:

User Cohort Analysis for Retention Insights
Tools: Google Sheets, Excel (Pivot Tables, Formulas), Conditional Formatting
HARD SKILLS Developed interactive analytical tables for in-depth cohort analysis with dynamic retention rate
calculations. Utilized pivot tables and advanced formulas for automatic data scaling and trend
visualization using conditional formatting. Implemented slicers for multi-dimensional filtering by
SQL activity type, language, and game. Optimized analytics for quick identification of retention patterns
and user engagement effectiveness.
Python
A/B Tests WORK EXPERIENCE
Web Analytics
Data Analysis GIS-Point Hmara
GIS Specialist & Controller Geodata Engineer
July 2024 - Present July 2023 - July 2024
TOOLS
Responsibilities: Responsibilities:
Processed geospatial data both manually and Checked geospatial data quality,
Google Shets, Excel automatically, ensuring accuracy and on-time identified and corrected errors within
project delivery. control deadlines.
DBeaver, BigQuery Coordinated team activities, monitored task Supervised task execution by team
Tableau, Looker Studio quality, and implemented timely corrections. members and provided feedback for
Worked in various software environments to improvement.
provide flexible and precise data processing. Used GIS tools for mapping analysis and
Optimized workflows by selecting the most creating visualizations.
SOFT SKILLS efficient software solutions for specific tasks. Prepared technical documentation for
Performed result verification and compiled internal use and external audits.
reports for clients. Achievements:
Attention to detail Achievements: Introduced a quality-check template that
Reduced data processing time by was adopted as a project standard.
Self-learning ability streamlining key stages through automation. Implemented improved quality control
Improved data accuracy, leading to a standards, which helped reduce the
Efficiency-driven mindset significant decrease in client revisions. number of required revisions.
Team player with strong
communication skills

LANGUAGES EDUCATION
IT School “GoIT” Kyiv National University of Construction and Architecture
English - Pre-Intermediate
March 2025 - Present September 2020 - June 2024
Ukrainian - Native
Data Analysis Bachelor of Geoinformational systems and technologies