Особисті дані приховані Ветеран

VADYM KAPILEVYCH
Junior Data Analyst
Kyiv, Ukraine | [відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)

Junior Data Analyst with 4+ years of research experience in the
MilTech domain, skilled in SQL, Python (Pandas, NumPy,
Matplotlib, Seaborn), Tableau, Power BI. Completed analysis within
10+ scientific publications in the field of data-centric IT solutions,
provided valued outcomes with the implications for improving data-
driven decision-making. Leverage my analytical and technical skills
to solve the issues challenging the product development.

HARD SKILLS: RDBMS, SQL, python, DAX, EDA, A/B testing, product analysis (ARPU, LTV,
CAC, Retention, Churn, Conversion, DAU/WAU/MAU), mathematical statistics, advanced
analytics, data cleaning, data visualization.
TOOLS: Tableau, Google Data Studio, Google Sheets, Google Colab, Jupyter Notebook,
BigQuery, Microsoft Excel, PowerBI, Power Query, Google Analytics, Amplitude, DBeaver,
PostgreSQL, MySQL, SQLite, Pandas, Numpy, Seaborn, Matplotlib.
SOFT SKILLS: Disciplined, focused, accurate, eager to learn.

PROJECT EXPERIENCE
Revenue Metrics Dashboard
https://public.tableau.com/app/profile/vadym.kapilevych/viz/Dashboard_Revenue_Metrics/RevenueMetrics
Tools: SQL (PostgreSQL), Tableau, Data Visualization.
Description: Developed an interactive dashboard for analyzing recurring revenue dynamics and
customer payment behavior. It enabled Product Managers to monitor monthly revenue trends and
identify key factors driving changes in MRR and the paid customer base.
My Tasks:
● calculated key SaaS revenue metrics (MRR, Paid Users, ARPPU, Churn Rate, and LTV);
● prepared and transformed data using SQL for further visualization and analysis;
● built monthly revenue and paid-user dynamics to identify changes in customer behavior;
● designed an interactive dashboard with visualizations, added filters by date, language, age;
Result:
● created an interactive revenue analytics dashboard that provides a high-level overview of
MRR and paid-user dynamics;
● helped identify the main drivers of month-over-month changes;
● delivered insights to support Product Managers in monitoring customer behavior.

Marketing Campaign Analysis
https://public.tableau.com/app/profile/vadym.kapilevych/viz/Vadym_2_project/MarketingPerformanceDashboard
Tools: PostgreSQL, DBeaver, Tableau, Data Visualization.
Description: Introduced an interactive dashboard for marketing campaign performance analysis,
featuring dynamic KPI selection (CTR, CPC, CPL, ROMI, Conversion Rate), campaign ranking,
spend vs. leads analysis, correlation analysis, and cross-filtering between visualizations.
My Tasks:
● prepared marketing campaign data using SQL, calculated key marketing metrics;
● engineered campaign rankings to compare them across selected KPIs;
● performed correlation analysis to identify spend-to-outcome relationships across campaigns;
● configured interactive visualizations with cross-filtering to enable campaign-level analysis;
● structured the dashboard to support comparison of campaigns, identification of performance
differences, and exploration of key marketing drivers.
Result:
● created an interactive marketing analytics dashboard enabling users to evaluate and compare
campaign performance across multiple KPIs, while exploring spend-to-leads relationships;
● helped to identify key patterns for data-driven marketing decisions.

Analytics and Time Intelligence in Academic Performance Overview
https://drive.google.com/drive/folders/1h9w8yruXCO1GCjJaFizPjYFZu00Mcrh1?usp=sharing
Tools: PowerBI, SQL, Google Sheets, A/B testing, Cohort Analysis.
Description: Reviewed the academic progress among the students, carried out the analysis of
attendance and their progress. Delivered a dashboard with ad-hoc metrics, KPIs and graphs that
displayed the analysis results in realm of time, categories and acceptable limits.
My tasks:
● designed data model and relationships between educational datasets, collected and
transformed educational data;
● implemented DAX measures and defined KPIs for academic overview;
● completed exploratory data analysis to identify patterns and anomalies;
● implemented interactive visualizations and optimized dashboard usability by drill-down and
filtering capabilities;
● explored relationships between attendance, engagement, and academic outcomes.
Result:
● improved visibility into student achievement data, enabled clear understanding of abnormal
values in academic performance;
● empowered leadership with data-driven insights to optimize strategies for upcoming
academic year.
WORK EXPERIENCE
Center for Military and Strategic Studies
Leading Researcher
Nov 2021 - Jun 2026
● performed comprehensive data analysis and comparative assessments of international data
management standards;
● investigated data marking in the cloud-based environment to improve data management.
Revised the data-related issues of IT military projects to facilitate their implementation;
● refined the role of active metadata in data management, enhancing interoperability and
decision-support capabilities through targeted research reports, analytical papers, and
recommendations for leadership.
Achievements:
● analyzed 51 standards (4172 pages), identified 2 key areas for strategic improvement,
initiated specific part of a taxonomy-like descriptive catalog of technical services;
● collaborated 3 researches, 2 scientific tasks and produced 10+ articles, thesis and reports in
the areas of metadata management, data-centric security, data integration in cloud-based
environment, usage of active metadata, metadata label services, generated 5+ detailed
reports impacting decision-making processes, defined data requirements for 2 projects.
Armed Forces of Ukraine
Military positions, mostly by technical specialty
Jul 2004 - Nov 2021
● managed multidisciplinary teams, oversaw organizational planning, coordinated and
streamlined consulting processes for IT initiatives, supporting project implementation;
● collaborated with contractors and international partners to facilitate knowledge sharing.
Achievements:
● coordinated 1st and 2nd Ukrainian Defense Hackathons focused on solving IT challenges.
EDUCATION
GoIT – Data Analyst (2026); Kaggle – Python (2026); DataCamp – Intermediate Python (2026);
The U.S. Army War College – “From Data to Better Decisions” (2021);
ITEA – Agile PM Course (2019); ITEA – PM course (2018);
National Technical University of Ukraine ‘Kyiv Polytechnic Institute’: Bachelor’s degree, Computer
Science (1999-2003), Specialist’s degree, Computer Science (2003-2004).
LANGUAGES
English – Upper-Intermediate; Ukrainian – Native