Ігор

Igor Yankovskyy [open contact info](look above in the "contact info" section)
QA Engineer / Test Analyst (Data, API) [open contact info](look above in the "contact info" section)

Summary
QA Engineer / Test Analyst for data-intensive applications: functional, integration, regression,
and API testing (CI (Jenkins), Swagger, Postman) on an e-commerce platform built on SAP
Commerce (Hybris) integrated with PeopleVox, and on game applications. Specialised in
validating data correctness end-to-end: reconciling front end, API, and logs to the root cause;
SQL (HackerRank Advanced); verifying business rules and calculations. Last two years in data
quality engineering (Python, ClickHouse, 100+ tables). ISTQB Advanced Test Analyst; QA Lead
and Scrum Master background.
Work experience
2024 – 2026, Data QA Engineer, Rozetka, Hybrid, Kyiv, Ukraine
● Write SQL to validate data consistency and integrity across 100+ ClickHouse tables:
reconciliation, duplicates, gaps, business-rule checks; layered checks skip later validation
after an early failure. Report issues to developers with reproduction details and follow them
through to resolution.
● Built Python pipelines (Pandas/Polars, Docker, GCP Vertex AI) running automated validation
rules and statistical checks every 15 minutes across 40+ ML pipelines, with Google
Chat/Telegram alerts on failures.
● Documented every table and column in a data catalog with a lineage map, used daily by up to
10 ML engineers and 1–2 ETL engineers.
● Defined requirements and validated the data sources behind a Redash dashboard (status, key
metrics, change history for 100+ tables); an analyst built the dashboard itself.
2023 – 2024, QA Engineer, 2K Group, Remote, Kyiv, Ukraine
● Designed and maintained 800+ Zephyr test cases and suites for 6 applications, covering key
game flows on desktop and mobile.
● Identified and reported ~20 issues per week in Jira through structured functional/UI/API
testing, reducing defects escaping to players; worked in 2–3-week cycles with testers rotating
between games.
● Created and updated project documentation (guides, flow schemes) and reviewed
requirements to keep test coverage aligned with changing features.
● Built an independent verification model in Excel for win-probability calculations for a
lottery-style game mechanic (5-of-36 letter draw): structured a multi-sheet workbook with
cross-sheet lookups (XLOOKUP, INDEX, MATCH) and combinatorial formulas to validate
win-probability calculations before release.
2018 – 2023, QA Engineer, Fiver London Ltd., Remote, Kyiv, Ukraine
● Ran cross-browser and cross-platform functional, integration, exploratory, regression, and
smoke testing within Scrum sprints on an e-commerce platform (OSC-SAP Commerce
(Hybris)-PeopleVox), covering front-end and API layers; maintained 400+ TestRail test cases.
● Built and deployed test environments of the platform via Jenkins as the deployment flow
evolved over 5 years

● Kept production stable for 5 years: zero critical production issues, weekly defect count under 5
(e.g., UI artifacts), each reported and queued for the next sprint
● Investigated individual failed transactions, reconciling order data across front-end, back-end
(Postman, Swagger UI, API), and Kibana logs to trace discrepancies and isolate root causes
through the full order-to-fulfillment cycle
● Authored process documentation (guides, schemes) to standardize transaction
troubleshooting and order-flow analysis across the team, using Jira/Confluence to track
coverage.
2009 – 2018, Test Engineer > QA Team Lead, 2K Group, Office, Kyiv, Ukraine
● Grew from Test Engineer to QA Team Lead over 9 years, contributing to 20+ game launches
● Led QA processes using Agile/Scrum methodology, acting as Scrum Master and conducting
weekly negotiations with product owners in English; administered Jira.
● Introduced early test automation using AutoHotkey
Education
● Honoured Diploma in System Engineering, Master of Science
Computer Engineering and Information Science, Kyiv Polytechnic Institute
Certifications
● 2026 – HackerRank. SQL (Basic), SQL (Intermediate), SQL (Advanced)
● 2024 – ISTQB® Certified Tester - Advanced Level - Test Analyst
● 2024 – ISTQB® Certified Tester - Foundation Level
Languages
● English – B2 ● Ukrainian – native
Skills
● Testing: manual functional, regression, smoke, UI and API testing (Postman); test design, test
plans, defect reporting, test planning & strategy
● Test management & tools: TestRail, Zephyr, Jira, Confluence, Jenkins, Kibana, Postman,
Swagger
● Methodologies: Scrum/Agile, SDLC/STLC, ISTQB Advanced Test Analyst
● Data validation & reconciliation: Git/GitLab, SQL (ClickHouse, HackerRank), Python
(Pandas, Polars), Google Sheets, Redash, Tableau Public (pet project)
● Domain background: SAP Commerce (Hybris): order flow, integrations with WMS/fulfilment,
game applications (desktop, mobile)
● Soft Skills: Problem-solving, cross-team collaboration, structured documentation
Courses
● 2026 – DataCamp. PostgreSQL Summary Stats and Window Functions
● 2024 – DataCamp. Python courses
● 2022 – “Foxminded” IT School. Automation QA (Java)
● 2018 – “Infopulse” Univer. Automated Software Testing (Python)