Oleksii

Oleksii Nebrat
[open contact info](look above in the "contact info" section) | [open contact info](look above in the "contact info" section)

Professional Summary
Junior Data Engineer with experience designing and automating data pipelines using Python,
PostgreSQL, Pentaho, and Alteryx. Hands-on experience building end-to-end data warehouses
on AWS, performing ETL/ELT processes, and optimizing data workflows in enterprise
environments (PwC). Strong SQL background and focus on scalable, reliable data systems.

Skills

• Programming & Automation: Python, VBA, Google Scripts
• Databases: PostgreSQL, MySQL
• ETL / Data Processing: Pentaho, Alteryx
• Cloud & Infrastructure: AWS (EC2, PostgreSQL deployment)
• Data Analysis & Visualization: Power BI, Tableau, Excel (Pivot Tables, Lookups, Macros)
• Process Automation: Data pipeline optimization, script migration, task automation
• Soft Skills: Problem-solving, analytical thinking, teamwork, attention to detail

Work Experience

Junior Data Analyst
PwC Service Delivery Center |18.11.2024 – 8.11.2025

• Designed and optimized automated data pipelines using Alteryx and VBA, reducing
manual processing and improving data accuracy and 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
• Collaborated with teams to automate repetitive processes, saving significant time and
resources.

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.
• 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.

Additional Information

• Fluent in Ukrainian
• Proficient in English

Soft Skills

• Problem-solving
• Analytical thinking
• Teamwork
• Attention to detail
• Adaptability
• Effective communication