Владислав

SHYNKARUK VLADYSLAV
DATA ANALYST
PROFILE

Analytical professional with a Computer Science background and an Upper-Intermediate English level. My
expertise lies in SQL for querying data, Python for data manipulation (Pandas, NumPy), and BI tools like Power BI
for data visualisation and reports. I specialize in cleaning and transforming raw data, performing statistical
analysis, and building automated reports that empower business decisions. I am a highly motivated problem-
solver, thriving in teams that value precision and impact.

PROJECTS

ShopEase E-commerce Database
Database Design: Designed and implemented a normalized relational database (3NF) for an online retail
platform.
Business Logic: Developed PL/pgSQL triggers and stored functions to automate inventory updates upon
order creation and validate transaction integrity.
Constraints: Enforced data integrity rules using foreign keys, check constraints, and unique indexes to
prevent data anomalies.

Sales Performance Dashboard in Power BI
Data Modeling: designed a star schema data model and engineered complex DAX measures to calculate high-
level metrics like churn rate, customer lifetime value (LTV), and return on investment(ROI).
Visualization: Created an interactive report to track regional performance, utilizing dynamic filters and drill-
downs.
Key Insight: Identified a strategic opportunity in the Mexican market, which generates 27% of total profit with
only 12% of the customer base. Analysis revealed that Mexican customers have a 10% Churn Rate (vs. 46% in
Canada), resulting in significantly higher LTV.

TECHNICAL SKILLS

SQL (PostgreSQL, window functions, CTEs, query optimizations, indexes)
Excel (XLOOKUP, Pivot Tables, Power Query)
Power BI (ETL in Power Query, DAX, interactive dashboards)
Python (Pandas, Numpy, Matplotlib, Seaborn)

EDUCATION

National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”
Faculty of Applied Mathematics
Bachelor Degree in Software Engineering

CONTACT ME

Phone number: [відкрити контакти](див. вище в блоці «контактна інформація»)
Email: [відкрити контакти](див. вище в блоці «контактна інформація»)
Telegram: @Vlad888555
Location:Kyiv | Remote Only