Oleh

Oleh Pihnastyi
Senior Software Engineer
[відкрити контакти](див. вище в блоці «контактна інформація») 571093911
[відкрити контакти](див. вище в блоці «контактна інформація») Gdansk, Poland

Professional summary
Java Software Engineer
10+ years of experience in designing, developing, and optimising enterprise-grade software solutions;
•

5+ years of experience in cloud services (AWS), database migration, and building secure, high-performance
•

backend systems that meet complex technical and business requirements;
skilled in leading cross-functional teams (with 4+ years of leadership experience in team management),
•

mentoring, and Agile project delivery;
5+ years of experience in Machine Learning and Generative AI, including LLM integration, GenAI
•

application development, and data-driven decision-making;
adaptable, self-motivated, and consistently aligned with product vision and business goals.
•

Skills
Programming languages Backend & Frameworks Technologies
Java Core, Java 17+
• Spring Boot
• Docker, Kubernetes, Minikube
•

Python, R, TypeScript
• REST
• PyTorch
•

Microservices Maven, Gradle
Testing
• •

Git
JUnit, TestNG, Mockito Software Engineering Practices
•

Clean Code, Code Review Agile & Project Management
Leadership & Communication
•

Technical Mentoring SCRUM
Team Leadership
• •

•

Software Architecture Team Management
Customer Relations
• •

•

Design Patterns Resource Management
Teamwork
• •

•

Release Management
Effective Communication Amazon Web Services
•

•

Decision-Making
Compute: EC2, Lambda
•

Ownership
Gen AI & ML
•

Storage & Databases:
•

Self-Management
Large Language Models:
•

S3, DynamoDB, Redshift
•

•

Anthropic Claude 3.5, Amazon Messaging: SQS IDEs & Development Tools
Bedrock
•

DevOps & CI/CD: IntelliJ IDEA
RAG, Prompt Engineering
• •

•

CDK, CodePipeline, Brazil RGui, TexStudio
Machine Learning Models
•

•

Security:IAM, Secrets Manager
• DBeaver
•

Monitoring: CloudWatch
OS
•

SDK & Tooling: AWS SDK
Mac, Linux, Windows
•

Databases & Query Languages
•Oracle, PostgreSql, MySql,
MSSql, Hive
• SQL, PL/SQL

Professional Experience
Software Dev Engineer II, Amazon Development Center Poland 06/2021 – 07/2025
development and support of services AWS DMS Schema Conversion with Gen AI,
• Gdansk, Poland
Common Studio Framework (CSF), AWS DMS Schema Conversion, AWS Schema
Conversion Tool (SCT);
design and implementation AI-powered solutions for AWS DMS schema
•

transformation, leveraging Amazon Bedrock and Retrieval-Augmented Generation
(RAG) technique to handle schema elements that DMS does not automatically
convert by existing schema transformation rules. Utilizing LLM models for
optimization, performance enhancements, and code transformation to ensure
higher efficiency in database migrations;
design and development of solutions for loading, processing and handling
•

metadata for internal AWS DMS services to Common Studio Framework (CSF);
 design and development of solutions for loading, processing and handling
•

metadata for the migration from Apache Hadoop to Amazon EMR using Hive
metadata to create database objects in the target Amazon EMR Hive service;
design and implementation of solutions to automate, enhance and optimize
•

database migration with an emphasis on loading, processing and handling
metadata for relational OLTP and data warehouse databases, ensuring
compatibility with Amazon RDS, Amazon Aurora and Redshift;
ownership of a specialized module responsible for loading metadata in different
•

database dialects.
Technologies: Java, Spring Boot, Docker, Kubernetes, Python, PyTorch, LLM, ML,
SQL, TypeScript, JUnit, TestNg, Mockito, AWS (SDK, CodePipeline, IAM, Secrets
Manager, Lambda, SQS, S3, EC2, DynamoDB, Redshift, CDK, CloudWatch,
Brazil), Maven, Gradle, Git, Scrum (two-week sprints);
Team Lead, Software Engineer, DB Best Technologies 11/2019 – 06/2021
coordination the loading and processing data tasks with team members and other
• Kharkiv, Ukraine
teams;
providing recommendations for continuous improvement of the process loading
•

and processing data;
training new team members on work processes and software;
•

collaborating with diverse teams across departments to incorporate innovative
•

architectures and load metadata modules into database migration tools;
ownership of a specialised module responsible preparation and processing of
•

statistical information about the metadata values for analysis of different database
dialects for database migrations between different database types more
predictable.
Software Engineer, DB Best Technologies 12/2015 – 11/2019
development of the algorithms for loading and processing metadata from various
• Kharkiv, Ukraine
sources;
solving customer problems related to the metadata loading and processing
•

module;
code review of the module for loading and processing data;
•

preliminary research, analysis and addition of new data sources to the application;
•

development strategy.
•

Technologies: Java Core, Java 8+, Spring Boot, Docker, SQL, PL/SQL, JUnit, Mockito,
Maven, Gradle, Git, S3, Redshift, Jira
Team Lead, PL/SQL developer, BearingPoint, Inc 11/2013 – 12/2015
developing stored procedures for generating cash flow reports;
• Kharkiv, Ukraine
development of stored procedures for generating reporting forms: journals,
•

balance sheet, profit and loss;
performing tasks for the development and implementation of the "Debtors and
•

Creditors" module at a manufacturing enterprise.
Technologies: PL/SQL, Jira

Education
PhD 2012 – 2015
National Technical University "Kharkiv Polytechnic Institute" Kharkiv, Ukraine
Faculty of Computer and Information Technologies, department of Distributed
Information Systems and Coud Technologies
Master of Engineering 1986 – 1993
Kharkiv Aviation Institute named N.E. Zhukovsky "KhAI" Kharkiv, Ukraine
Faculty of Rocket and Space Technology

Languages
English — Proficient Polish — Basic
Ukrainian — Native/Bilingual Russian — Native/Bilingual
Courses
Internship. Improve knowledge in the field of modern mathematical methods and 2016 – 2017
models: data mining and processing Kharkiv, Ukraine
V. N. Karazin Kharkiv National University

Certificates
AWS Certified Cloud Practitioner (CLF-C01) (A CLOUD GURU 03/2024)
Introduction to AWS Fargate (A CLOUD GURU 01/2024)
Introduction to Identity and Access Management (IAM) (A CLOUD GURU 01/2024)
Generative AI with Large Language Models (Generative AI with Large Language Models Amazon Web
Services (10/2023))
Algorithms, Part I Algorithms, Part I Princeton University (06/2020)

Machine Learning Publications
Neural network-based approach for predicting the flow material in transport 09/2024
systems
CEUR Workshop Proceedings, Volume 3790, 2024. ISSN 1613-0073, Pages 76-86. Proceedings
of the 12-th International Conference "Information Control Systems & Technologies"
Use of Neural Network-based Models to Predict the Severity of Bronchial Asthma 05/2024
in Children
CEUR Workshop Proceedings, Volume 3702, 2024. ISSN 1613-0073, Pages 329-339.
Proceedings of The Seventh International Workshop on Computer Modeling and Intelligent
Systems (CMIS-2024
Linear Regression Models for Bronchial Asthma Severity Prediction based on 09/2023
TSLP
CEUR Workshop Proceedings, Volume 3513, 2023. ISSN 1613-0073, Pages 276-290.
Improving the Prediction Quality for a Multi-Section Transport Conveyor Model 05/2022
Based on a Neural Network
CEUR Workshop Proceedings, Vol. 3132, P. 24 – 38, 8th International Scientific Conference
"Information Technology and Implementation"
Neural model of conveyor type transport system 05/2020
CEUR Workshop Proceedings, Volume 2608, 2020. ISSN 1613-0073, Pages 804-818
An Analytical Method for Generating a Data Set for a Neural Model of a Conveyor 04/2020
Line
IEEE 11th International Conference on Dependable Systems, Services and Technologies
(DESSERT)