Pavlo

Pavlo Kotenko
Junior Data Analyst|SQL|Python|Excel/Google Sheets|Power BI|Data Analytics
[відкрити контакти](див. вище в блоці «контактна інформація») | TG: @PavelKotenko | [відкрити контакти](див. вище в блоці «контактна інформація») | LinkedIn | github | Kyiv, Ukraine

Summary
Junior Data Analyst transitioning from a 13+ year career in game development and QA
engineering. Hands-on experience with SQL, Excel/Google Sheets and Python/Pandas and
Power BI, including data cleaning, validation, aggregation, exploratory analysis and business
metric calculation. Built analytical projects using relational customer and subscription data,
writing SQL queries with JOINs, CTEs, CASE statements and aggregations, and creating
reports and dashboards in Google Sheets. Strong background in investigating complex product
issues, identifying anomalies, validating data and performing root-cause analysis.

Skills

SQL:
● SELECT, WHERE, ORDER BY
● JOIN, LEFT JOIN
● UNION ALL
● GROUP BY, HAVING
● Aggregate functions: COUNT, SUM, AVG, MIN, MAX
● CASE statements
● CTEs
● Multi-table analysis
● Data validation
● Customer and subscription analytics
Excel/Google Sheets:
● Pivot Tables
● QUERY
● XLOOKUP
● ARRAYFORMULA
● COUNTIF/COUNTIFS
● SUMIF/SUMIFS
● AVERAGEIF
● Data cleaning and validation
● Business metrics
● Dashboards and charts
Power BI:
● Power Query
● Data cleaning and transformation
● Data modeling
● Relationships between tables
● DAX measures and calculated columns
● KPI calculations
● Interactive dashboards
● Data visualization

Statistics & Analytics:
● Descriptive statistics
● Mean, median and percentiles
● Variance and standard deviation
● Statistical significance fundamentals
● Hypothesis testing fundamentals
● p-value and significance level (α)
● A/B testing fundamentals
● Retention analysis

Data Quality:
● Duplicate detection
● Missing-value analysis
● Format consistency checks
● Outlier investigation
● Data validation
● Root-cause analysis
Tools:
● Git/GitHub
● Jira
● Confluence
● Google Cloud
● TeamCity
● Basic JavaScript
● Basic C#
● Basic MongoDB
● SQLite
● Power BI
● DBeaver

Data Analytics Projects
Starlink Customer & Subscription Analytics

SQL | Google Sheets | Python | Power BI

● Worked with relational customer and subscription datasets.
● Combined data from multiple tables using JOIN and LEFT JOIN.
● Used GROUP BY, HAVING and aggregate functions to calculate business metrics.
● Used CTEs to structure multi-step analytical queries.
● Applied CASE statements for customer and data classification.
● Performed data-quality and validation checks.
● Analyzed customers by country, subscription plan and usage.
● Calculated revenue and other business metrics.
● Built reports, Pivot Tables and dashboards in Google Sheets.
● Translated business questions into SQL queries and analytical reports(Python, Excel)
● Transformed and prepared data using Power Query.
● Built a relational data model and defined relationships between tables.
● Created DAX measures for business metrics and KPI analysis.

● Built an interactive Power BI dashboard to visualize customer, subscription and revenue
metrics.

Transferable Analytical Experience

● Strong analytical and problem-solving background developed through 13+ years in QA.
● Extensive experience investigating large amounts of product information.
● Identifying patterns, anomalies and inconsistencies.
● Root-cause analysis.
● Data validation and quality control.
● Translating requirements into structured questions and test scenarios.
● Working with cross-functional teams in a production environment.
● Deep domain knowledge of game development and mobile/web products

Professional Experience
Senior QA Engineer | Plarium, Ukraine | June 2012 – March 2026
● Owned testing for crafting game genre project: designed comprehensive test strategies,
identified 100+ critical bugs through functional and UI/UX verification, and collaborated
with design and development teams resulting in 300,000+ active users across 7
countries
● Led QA efforts on solitaire game with 2+ million users across iOS and Android platforms,
executing regression and performance testing for 40-person development team
● Managed support project lifecycle: validated 50 new level releases weekly, coordinated
with development to prevent regressions, and maintained test coverage across content
pipeline, while serving as delivery manager to ensure on-time, quality releases
● Analyzed and resolved user-reported production issues through systematic investigation
and reproduction, prioritizing business-critical bugs affecting paying customers and
collaborating with engineering leadership on fixes
● Improved analytics accuracy by validating dev-to-dev event data pipeline, ensuring
metrics delivered correctly to business and data analysis teams for decision-making
● Maintained comprehensive test documentation including test cases, checklists, and bug
reports in Jira and Confluence for 7–65 member teams; configured testing environments
with backend server setup, frontend builds, and TeamCity verification
● Tracked and analyzed 4,000+ bugs using Jira to identify patterns, prioritize fixes, and
drive quality improvements across releases

Education
The Volodymyr Dahl East Ukrainian National University | Bachelor's Degree in Computer
Systems in Management and Training | 2006–2011

Certificates
● Google AI Fundamentals, 2026
● SQL for Data Science, 2026
● Python for Data Science, AI & Development, 2026

Pet projects
● sql-practice-starlink
● starlink-python-analytics

● starlink-google-sheets-analytics
Languages
English — Advanced • Ukrainian — Native • Russian — Native