Contact information

You can get this candidate's contact information from https://www.work.ua/resumes/10178436/

Work experience

Data engineer

from 01.2024 to now (2 years 9 months)
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

from 10.2022 to 03.2023 (6 months)
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

Education

Lviv Polytechnic National University

Master’s Degree in Information Systems and Technologies, Львів
Higher, from 2023 to 2024 (1 year)

Lviv Polytechnic National University

Bachelor’s Degree in Cyber Security, Львів
Higher, from 2018 to 2023 (5 years)

Additional education and certificates

Python

2020, 32 години
Certificate

Data Analytics Engineering Training, EPAM

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

Knowledge and skills

• 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

Language proficiencies

• Ukrainian — fluent
• English — average

Disability

3rd degree.
Цукровий діабет. Обмежень щодо роботи не маю.

Additional information

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.