Oleksii

Oleksii Nebrat

14.05.2002
[відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)

https://github.com/SuchAStupidMe

https://leetcode.com/u/sasm-doppleganger/

Professional Summary
Data-focused professional with hands-on experience building AWS-based data warehouses and
automating ETL pipelines using Python, SQL, and Alteryx. Strong background in SQL optimization
and data modeling with enterprise experience at PwC.

Skills

• Data Engineering: Data Modeling, Indexing, Query Optimization, Data Orchestration,
Data Lake/Data Warehouse Understanding, Data Normalization, SCD
• ETL / Data Processing: Pentaho, Alteryx, pandas
• Databases: PostgreSQL, MySQL
• Programming & Automation: Python, VBA, Google Apps Script
• Cloud & Infrastructure: AWS (EC2, PostgreSQL deployment)
• Data Analysis & Visualization: Power BI (DAX), Tableau, Excel
• Process Automation: Data pipeline optimization, script migration, task automation
• Soft Skills: Problem-solving, analytical thinking, teamwork, attention to detail
• Version Control & DevOps: Git, GitHub, CI/CD basics

Work Experience

Junior Data Analyst
PwC Service Delivery Center |18.11.2024 – 8.11.2025

• Designed and optimized 15+ recurring workflows and automated data pipelines using
Alteryx and VBA, reducing manual processing time by 60%.
• Processed datasets of 500K+ rows and improved data validation accuracy by 25%,
increasing reliability across reporting workflows.
• Implemented structured data transformations and validation logic within automated
pipelines to ensure consistency across reporting datasets.
• Migrated Google Scripts to VBA and Excel Online, ensuring seamless transition and
improved functionality
Education

Bachelor’s Degree in Cybersecurity
National Aviation University | September 2019 – May 2023

Certifications & Courses

• Data Analyst Course – Udemy
• Data Engineering Course – Udemy
• Data Warehouse Course – Udemy

Projects
• End-to-End E-commerce Data Warehouse
Created end-to-end Data Warehouse for e-commerce site complete with PostgreSQL
server deployed in AWS, ETL-processes in Pentaho and full documentation/diagrams.
Designed star-schema models with fact and dimension tables and implemented
incremental loads. Performed data quality validation and optimized SQL queries for
analytical workloads. Managed code versions using Git and GitHub.
• HR Dashboard
Created an HR dashboard to analyze employee performance and attrition metrics. Data
was normalized, imported into MySQL, and then analyzed and visualized in Power BI,
providing actionable insights into HR trends.
• Laptop Prices Analysis Dashboard
Developed a Power BI dashboard to analyze laptop pricing trends based on
specifications. The dataset was normalized and imported into MySQL, allowing for
accurate and efficient analysis in Power BI.
• Solved 80+ data manipulation and SQL problems on LeetCode (focus on Pandas and
query optimization).

Additional Information

• Fluent in Ukrainian
• Proficient in English