Олексій

Oleksii Shynkaruk
Warsaw, Poland · [open contact info](look above in the "contact info" section) · [open contact info](look above in the "contact info" section)
github.com/shynkaruk00-collab · public.tableau.com/app/profile/oleksii.shynkaruk

PROFILE
Detail-oriented and motivated student studying Quantitative Methods in Economics and Information
Systems at the Warsaw School of Economics (SGH), with a previous academic background in
Cybersecurity. Independently completed an end-to-end analytics project on a real-world dataset using
SQL, PostgreSQL, and Tableau. Interested in IT and business analytics and working with data. Skilled
in analytical thinking, structured problem-solving, and quantitative reasoning.

PROJECTS
Olist E-Commerce Marketplace Analysis — academic portfolio project
• Independently built an end-to-end analytics project on a Brazilian marketplace dataset: ≈ 99K
orders, 96K customers, 3K sellers, R$13.6M revenue.
• Loaded and cleaned raw data in PostgreSQL and built data models and analytical views with SQL
(CTEs, window functions, CASE logic).
• Designed separate order-level and item-level fact tables to prevent revenue duplication caused by
one-to-many relationships.
• Developed a composite priority score combining delivery risk, customer review scores, and revenue
to rank states, categories, and sellers.
• Found that ≈ 8% of orders are delivered late and that this segment shows noticeably lower customer
review scores; visualized the results in a Tableau Public dashboard.
Stack: PostgreSQL · SQL · Tableau Public · Git / GitHub

EDUCATION
Warsaw School of Economics (SGH) — Warsaw, Poland
Quantitative Methods in Economics and Information Systems
2025 — Present
Igor Sikorsky Kyiv Polytechnic Institute — Kyiv, Ukraine
Cybersecurity
2024 — 2025

TECHNICAL SKILLS
Microsoft Excel · Power BI · Tableau · SQL / PostgreSQL · Python (basic) · Data visualization ·
Working with structured data

CORE SKILLS
Analytical and critical thinking · Quantitative analysis · Statistical reasoning · Problem-solving ·
Research and information analysis · Attention to detail · Communication and teamwork · Time
management · Adaptability and fast learning

LANGUAGES
• Ukrainian — Native
• English — B2 (IELTS Academic, Overall Band Score 6.0)
• Polish — A2 / B1

CERTIFICATIONS
• IELTS Academic — Overall Band Score 6.0

ADDITIONAL INFORMATION
• Interested in IT analytics, business analytics, and data-related opportunities.
• Open to internships, intensive programs, and entry-level roles.
• Motivated to develop practical analytical and technical skills.