Контактна інформація

Отримати контакти цього кандидата можна на сторінці https://www.work.ua/resumes/10178436/

Досвід роботи

Data engineer

з 01.2024 по нині (2 роки 9 місяців)
DataMola LLC, Львів (IT)

Worked primarily with IBM DB2 and Oracle, using SQL, Python, JavaScript and Microsoft SQL Server.

• Designed and supported ETL/ELT pipelines for 40+ external data sources, including APIs, SharePoint and file-based sources.
• Built end-to-end integrations for new sources: source/API analysis, Python extraction flows, validation, transformation, loading, scheduling, testing and production deployment.
• Developed configuration-driven ETL pipelines and worked with raw/landing, historical and current-data DWH layers.
• Developed and maintained stored procedures, views and complex SQL queries for data processing, reporting and application logic.
• Implemented new application features from the database/backend side by designing stored procedures for data retrieval, saving and updating data, calculations, mappings, filtering, sorting and business rules.
• Built supporting JavaScript APIs to expose this functionality to custom frontend dashboards and admin panels.
• Monitored production ETL processes, performed root cause analysis and fixed failed loads, invalid data, duplicates, API changes and source-system issues.
• Implemented data validation and data-quality rules and investigated data anomalies by comparing current and historical datasets.
• Optimized high-volume loads using batch/incremental processing and improved slow SQL procedures.
• Created and maintained SQL Server Agent jobs for ETL scheduling, automated reports and email notifications.
• Maintained PDM models in SAP PowerDesigner and performed schema-level migration of 10+ DWH/application schemas to a new server.
• Used Flyway, Git-based workflows, pull requests, DEV/PROD releases and production hotfixes.
• Participated in Oracle-based legacy system modernization and implemented database-level access control and data isolation.

Technologies: IBM DB2, Oracle, MS SQL Server, SQL, Python, JavaScript, SQL Server Agent, PowerDesigner 16, Flyway, Git, GitHub, Postman, Bruno, Docker, WinSCP.

Trainee/Junior Data Analyst

з 10.2022 по 03.2023 (6 місяців)
EPAM, Львів (IT)

Python Programming
• Data types, functions, decorators
• File handling (read/write operations)
• Working with databases (SQL integration)
• Object-Oriented Programming (OOP)
Data Analytics & Visualization
• Data analysis fundamentals
• Tableau: data exploration and visualization
• Power BI: data modeling and dashboards
• Practical workshops with Power BI

Освіта

Lviv Polytechnic National University

Master’s Degree in Information Systems and Technologies, Львів
Вища, з 2023 по 2024 (1 рік)

Lviv Polytechnic National University

Bachelor’s Degree in Cyber Security, Львів
Вища, з 2018 по 2023 (5 років)

Додаткова освіта та сертифікати

Python

2020, 32 години
Сертифікат

Data Analytics Engineering Training, EPAM

Липень 2022 - Вересень 2022, 3 місяці, 101 година
Сертифікат

Знання і навички

• SQL
• IBM DB2
• Oracle Database
• ETL
• ELT
• Database Management Systems (DBMS)
• Data analysis
• Python
• JavaScript
• Git
• GitHub
• Bitbucket
• MS Office
• MS Excel
• HTML
• Communication
• Creativity
• Problem solving
• Ability to quickly learn new information
• Self-motivation
• Teamwork
• Analytical thinking
• Time management
• Conflict resolution
• Detail-oriented
• MS SQL Server
• SQL Server Agent
• PowerDesigner
• Flyway
• Postman
• Bruno
• Docker
• WinSCP

Знання мов

• Українська — вільно
• Англійська — середній

Інвалідність

Третя група.
Цукровий діабет. Обмежень щодо роботи не маю.

Додаткова інформація

I am a DWH / Data Engineer with 3 years of commercial experience working primarily with IBM DB2 and Oracle databases.

My experience includes designing, developing, and supporting ETL/ELT pipelines for 40+ external data sources, including APIs, SharePoint, and file-based systems. I have built new data integrations end-to-end, covering data extraction with Python, validation, transformation, loading, scheduling, testing, and production deployment.

I have strong experience in SQL and database development, including stored procedures, views, complex queries, data transformations, and performance optimization. I also implemented new application functionality on the database/backend side, including calculations, mappings, filtering, sorting, business rules, and data modification workflows, with JavaScript APIs used by custom frontend dashboards and admin panels.

I regularly worked with production data pipelines, investigated failed loads and data anomalies, performed root cause analysis, and resolved issues related to invalid data, duplicates, API changes, missing loads, and outdated business logic.

I also maintained PDM models in SAP PowerDesigner, worked with Flyway and SQL Server Agent, and performed a schema-level migration of 10+ DWH/application schemas to a new database server.

I focus on building reliable data pipelines, maintaining data quality, improving performance, and solving complex data and database-related problems.