Ostap

OSTAP KUSHNIR
Data Analyst
[відкрити контакти](див. вище в блоці «контактна інформація»)
github.com/lapush0k
[відкрити контакти](див. вище в блоці «контактна інформація»)

SUMMARY

Self-taught. I write SQL (JOIN, CTE, window functions) and work with pandas and matplotlib in
Python. I’ve created a project on GitHub: an analysis of e-commerce sales using 9 data tables. Iʼm
looking for my first role as an SQL/data analyst.

EXPERIENCE
Personal Project: E-commerce Sales Analysis (Olist) SQL (SQLite), Python
(pandas, matplotlib)
Loaded 9 tables from the Olist dataset (Brazilian e-commerce, Kaggle) into SQLite and linked
them using JOINs
Calculated monthly revenue and the top 10 categories by revenue, and reconciled the totals by
category with the grand total
Analyzed delivery: average time of 12.6 days, percentage of late orders 6.8%
I Calculated repeat customer rate by customer_unique_id: 3.0% (2,801 of 93,358 customers).
Wrote queries using window functions: month-over-month revenue change (LAG), top 3
categories by state (ROW_NUMBER + PARTITION BY in a CTE)
Created graphs using pandas and matplotlib, and described the findings in the README
Incom Polska Sp. z o.o.

Checked many tables and reports for duplicates, missing values and errors; found and corrected
>500 issues, which kept the data accurate for manager
Compared data across periods and filled in Excel reports monthly, flagging discrepancies in
material dimensions to quality departament

SKILLS
SQL: SELECT, JOIN, GROUP BY, HAVING, subqueries, EXISTS, CTE,
window functions (LAG, ROW_NUMBER, PARTITION BY)
Python: conditionals, loops, lists, dictionaries, functions, file handling,
error handling, classes
pandas / matplotlib: Series, DataFrame, filtering, aggregations, missing
values (NaN), reading and writing CSV files, plotting
Git / GitHub: version control for own projects
Languages: Ukrainian, English (B2)
Power BI

EDUCATION
University of Szczecin “Accountant” 2023-2026

followed by self-study, I mostly learned from the stratascratch website