Vladyslav

SHYNKARUK
CONTACT ME
VLADYSLAV
[відкрити контакти](див. вище в блоці «контактна інформація») DATA ANALYST
@Vlad8885555
PROFILE
[відкрити контакти](див. вище в блоці «контактна інформація»)
Kyiv | Remote Only Data Analyst with a background in Software Engineering.
Proficient in SQL (BigQuery) and Power BI for building automated
SKILLS reporting solutions. My experience includes migrating Excel
workflows to interactive dashboards, conducting product analysis
Advanced SQL (funnels, cohorts), and implementing data quality monitoring.

Dialects: PostgreSQL, BigQuery Skilled in translating complex datasets into clear, actionable
business insights.
Key concepts: Window functions,
Aggregations, CTEs, Joins
Working with nested
data(UNNEST, ARRAY, STRUCT)
EXPERIENCE
Excel MyProx
XLOOKUP/VLOOKUP, INDEX, (E-commerce)
Data Analyst
MATCH functions
October 2024 - December 2025
Pivot Tables
Reporting & Visualization: Migrated core operational reports from
Power BI
Excel to Power BI. Created and maintained interactive dashboards for
DAX(Time Intelligence, Calculate)
Sales and Marketing teams, ensuring data freshness and accuracy.
Data modelling(Star Schema)
Ad-hoc Requests: Handled requests from category managers using
Interactive dashboards, reports
SQL to extract specific data (e.g., lists of churned users, low-margin
Power Query for ETL
products).
Python
Funnel Analysis: Regularly analyzed the checkout funnel and user
Data manipulation: Pandas, paths to identify conversion drop-offs, bottlenecks, and potential
NumPy technical anomalies on the website.
Data visualization: Seaborn, Cohort Analysis: Conducted cohort analysis (LTV, Retention Rate) to
Matplotlib evaluate the effectiveness of marketing campaigns and user
Product Analytics: engagement over time.
Conversion funnel Analysis Implemented SQL-based data quality checks using BigQuery
Cohort Analysis: Retention Rate, Scheduled Queries. Setup logic to trigger email notifications in case of
Churn Rate, LTV data anomalies (e.g., duplicates, missing values) prior to report
Marketing Analytics updates.

Marketing Performance Metrics
(ROAS, CAC, CPC, CPM, CPI)
A/B testing fundamentals
Version Control System(Git)

LANGUAGES
EDUCATION

Ukrainian - Native National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”
English - Upper-Intermediate Faculty of Applied Mathematics
Bachelor Degree in Software Engineering