Андрій

6/17/26, 9:46 PM Andrii Chaplynskyi — Data Analyst CV

Andrii Chaplynskyi Hong Kong S.A.R., China
[open contact info](look above in the "contact info" section)
DATA ANALYST · SQL · PYTHON · TABLEAU · BIGQUERY [open contact info](look above in the "contact info" section)
Detail-oriented Data Analyst with 2+ years of hands-on experience in data github.com/andrii-chaplynskyi
collection, analysis, and reporting in a large government organisation, [open contact info](look above in the "contact info" section)
supported by 15+ years of statistical and investigative analysis in law
enforcement. Proficient in SQL (BigQuery, MySQL), Python (pandas,
matplotlib, scipy), and business intelligence tools. Combines proven
analytical experience with a technical programming background. Portfolio
includes hands-on projects in A/B testing, cohort analysis, and interactive
dashboards. Seeking a Data Analyst role to translate complex data into clear,
actionable business decisions.

WORK EXPERIENCE TECHNICAL SKILLS

Data & Statistical Analyst / IT Specialist Jan 2022 – May 2024 Query & Databases
Dept. of Information and Analytical Support — Ukraine (Government, 500+ staff) SQL BigQuery MySQL
– Collected, cleaned, and analysed operational data using SQL and Excel to MongoDB
support monthly and quarterly reporting and data-driven decision-making for
Python
senior management.
– Built and maintained recurring analytical dashboards and structured reports, pandas numpy matplotlib
reducing manual reporting effort by approximately 30%. seaborn scipy
– Conducted trend and anomaly analysis on incidents and operational metrics, Visualisation
identifying data inconsistencies and potential risks.
Tableau Google Sheets
– Maintained internal databases and ensured data integrity across multiple
operational information systems. Excel
– Collaborated with developers to improve data pipelines and automate routine Statistics
extraction and transformation tasks.
A/B Testing
– Worked with sensitive law enforcement data, ensuring confidentiality and
Hypothesis Testing
accuracy in all reporting.
Cohort Analysis z-tests
Trainee Front-End Developer Jan 2025 – Oct 2025 Confidence Intervals
FoxmindEd Bootcamp — Remote
Tools
– Built data-driven UI components and simple dashboards using React and
Git/GitHub Jira
TypeScript, strengthening understanding of how analytics is consumed in
front-end and BI interfaces.
– Practised version control with Git and task tracking in Jira in a mentorship- EDUCATION

based bootcamp environment.
Master's Degree — Law
– Completed structured assignments with regular mentor feedback, then Enforcement
transitioned focus from web development to Data Analytics with SQL, Dnipropetrovsk State
Python, and Tableau. University of Internal Affairs
Sept 2010 – Aug 2011
DATA ANALY TICS PROJECTS
Full-Stack Web
Development
A/B Test Analysis — E-commerce Conversion Rate IT Academy Step
Python pandas scipy matplotlib 2024 – 2025
Built a full A/B test analysis pipeline including data cleaning, exploratory data Front-End Development
analysis, and a two-proportion z-test. Measured p-value and confidence Bootcamp
intervals; identified a statistically significant 12% uplift in conversion for the test FoxmindEd

file:///Users/andriichaplynskyi/Documents/privat/Andrii/cv/Andrii-Chaplynskyi-Data-Analyst-CV.html 1/2
6/17/26, 9:46 PM Andrii Chaplynskyi — Data Analyst CV
variant at 95% confidence, and provided a business recommendation on Jan 2025 – Oct 2025
rollout.
CERTIFICATIONS
Customer Segmentation — SQL Analysis (BigQuery)
SQL BigQuery CTEs Window Functions SQL for Data Analytics — Mate
Academy
Built a multi-step SQL pipeline using CTEs and window functions
(ROW_NUMBER, RANK, LAG). Segmented customers by recency, frequency, Python for Data Analytics —
Mate Academy
and email engagement to support cohort-level insights and retention campaign
Statistics & A/B Testing —
planning.
Mate Academy
Tableau — Mate Academy
E-commerce Sales Dashboard — Tableau + Python
Tableau Python pandas Excel
LANGUAGES
Cleaned raw transaction data with pandas and built an interactive Tableau
dashboard with KPIs for revenue trends, category breakdowns, and geographic Ukrainian Native
performance. Identified top-performing regions and seasonal demand patterns
through visual analysis. Russian Native

English B1+

QQEnglish course + speaking
level test completed

STRENGTHS

Analytical thinking
Attention to detail

Cross-team communication
Self-directed learning

Structured problem-solving

file:///Users/andriichaplynskyi/Documents/privat/Andrii/cv/Andrii-Chaplynskyi-Data-Analyst-CV.html 2/2