Олексій

Oleksii Irnazarov
Data Science & Analytics
Kyiv, Ukraine • (437)-383-9178 •
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація») • github.com/zizy2003 •
zizy2003.github.io

Data Science & Analytics professional based in Kyiv with hands-on experience delivering end-to-end analytics solutions - from
raw data preprocessing to SQL analysis and Power BI dashboards. Built production-grade PostgreSQL infrastructure for a 267-
registration hackathon platform, including a full staging-to-production migration with zero data loss. Seeking a Junior Data
Analyst role to apply RFM segmentation, cohort analysis, and BI development skills.
SKILLS
Programming: Python (Pandas, NumPy, Matplotlib, Plotly, Seaborn, SciPy), R, SQL
Databases: PostgreSQL, MySQL, NoSQL (MongoDB, DynamoDB), Supabase
Visualization: Power BI (DAX, data gateways), Tableau, MS Excel (Pivot Tables, VLOOKUP, charts)
Cloud & Tools: AWS (S3, DynamoDB), Databricks, Apache Spark, Git, Scrum
Other: ETL, A/B Testing, Statistical Analysis, Data Modeling, KPI Reporting, Root Cause Analysis
EDUCATION
Software Engineering / Databases (F3, correspondence) - KNUTD 09/2026 - Present
Kyiv National University of Technologies and Design
Data Science and Analytics - Seneca Polytechnic College, Canada 01/2025 - 09/2026
Full Academic Scholarship - 4 consecutive semesters
EXPERIENCE
Database Specialist & BI Developer - Contractor - Seneca Hackathon 02/2026 - 06/2026
• Designed and deployed a 20+ table PostgreSQL schema in Supabase serving 267 registrations - covering group
management, challenge selection, submissions, and judging workflows
• Executed full staging to production schema migration covering sequences, constraints, indexes, RLS structure, and
custom PL/pgSQL functions - zero data loss
• Built live Power BI dashboard connected to PostgreSQL tracking 6+ KPIs in real time - published to Power BI Service for
program directors and student success officers
• Diagnosed and resolved a production data gateway failure under time pressure, restoring reliable reporting within the
hour
Vice-President - Board - AI Seneca Club - Seneca Student Federation 01/2026 - Present
• Organized 5+ events with 50+ attendees for a 200+ member club - facilitated AI/data workshops and connected students
with industry professionals
• Guided 200+ students through Riipen Labs platform for industry project matching and real-world experience
Data Contributor - Freelancer - TransPerfect 01/2026 - 03/2026
• Built Python pipelines to clean, classify, and tag large-scale datasets for AI/ML training - maintained 100% data integrity
compliance
Branding Assistant - Ukrainian Branding Agency 04/2024 - 08/2024
• Maintained and analyzed inventory database for 100+ items in Excel, ensuring data accuracy and operational reporting
PROJECTS
E-Commerce Sales Analysis | Python • PostgreSQL • Power BI • Pandas
• Preprocessed 540K+ transaction records - resolved encoding, removed 5,268 duplicates, engineered 8 datetime features
reducing data noise by ~12%
• Built PostgreSQL schema with 8 analytical views (RFM, ABC, cohort, retention) - identified At Risk segment (1,422
customers) generating £6.1M and 19% of SKUs driving 80% of revenue
• Published 2 Power BI dashboards to Power BI Service with cohort matrix, retention trends and RFM breakdown across
4,338 customers
A/B Testing Conversion Analysis | Python • SQL • Power BI
• Engineered ETL pipeline processing 290,584-user dataset - applied Z-tests across 3 markets (USA, UK, Canada)
• Concluded new page design showed no meaningful improvement (0.15pp difference) - delivered structured business
recommendation based on statistical significance testing