Oleksii L. Email & Phone Number

Amsterdam, North Holland, Netherlands

Gdańsk, Pomorskie, Poland

Project: Multiple internal projectsKey Responsibilities:• Developing an ANTLR Java source code parser to extract valuable information on API controllers and methods.• Upgrading C# functional tests to .NET to enable cross-platform compatibility.• Building a CICD pipeline for a .NET application using AWS CodePipeline and AWS CloudFormation for infrastructure configuration.• Creating a Test Strategy document outlining essential resources, workflows, acceptance criteria, testing approaches, automation processes, and more.• Designing and implementing an API test framework using Java, Lombok, RestAssured and Gradle, leveraging POJO models, custom AssertJ assertions and annotations for efficient response parsing, validation, and reporting.• Developing the core architecture of a UI test framework using Java, Lombok and Selenium, following the PageObject and PageElements patterns.Key Achievements:• Demonstrated strong knowledge in the Spring Boot and microservice architecture, successfully migrated multiple Java modules to the Spring Boot.• Orchestrated a highly efficient CICD pipeline for the .NET application, providing real-time notifications in Slack for multiple operating systems, resulting in faster issue resolution.• The Test Strategy document played a vital role in early identification of critical points, ensuring clear responsibilities, required tools, and necessary environments.• The implementation of POJO models in the API test framework facilitated rapid adaptation to ongoing development changes, eliminating the need for separate tests for JSON schema validation.• Created over 2000 API functional tests with test result reporting in less than 5 minutes, enabling quick identification of new issues.• Developed a UI test framework that streamlined testing processes, utilizing industry best practices such as PageObject and PageElements patterns for improved maintainability and scalability.

Gdańsk, Pomorskie, Poland

Project: Collect performance statistic for serverless frameworkKey Responsibilities:• Updating existing test framework to add marks for metrics collection.• Creating Shell scripts for collecting and analyzing the performance metrics, e.g. CPU, RAM, disk space and network bandwidth utilization.• Creating scripts for generation of performance tests (JSON) with rich parametrization of migration input parameters, e.g. rows count, tables count, column count and data type.• Utilizing AWS CLI create skeletons for metrics requests to AWS CloudWatch.• Create summary report of performance analysis.Key Achievements:• Tests generation script resulted in appr. 3 000 performance test cases.• With performance statistics were calculated trendline formulas of resources utilization on different load.• Improved recommendations of instances for specific load.• Performance statistics showed key bottlenecks.

Gdańsk, Pomorskie, Poland

Project: Application migration from Oracle to PostgreSQLKey Responsibilities:• Performing smoke testing of data after migration• Running customer’s Postman tests to validate APIKey Achievements:• Created Shell script as initial point of access to both database from CLI with options menu for user input. Script establishes connections with SQL Plus and Psql to run user SQL scripts.• Created SQL scripts for collecting database statistics and running smoke test to find a difference on missing tables or records count in them.• Reviewed and extended all provided API tests with JSON Schema validation and additional logic.

Kharkiv, Ukraine

Project: Migration client applications from Oracle to PostgreSQLKey Responsibilities:• Collaborating with a group of 2 automation and 1 manual QA engineers as part of a large project involving approximately 50 team members.• Conducting both manual and automated testing of PRO*C batches during the migration process.• Verifying the integrity of the PostgreSQL database structure and data after the migration.• Developing a Java-based test runner using TestNG to execute customer's Groovy tests through an SSH tunnel on remote AWS EC2 instances, enabling centralized test result collection.• Configuring and implementing code coverage collection for PRO*C and Java batches, providing detailed reports for analysis.• Configuring the testing stage of the CICD pipeline on the Jenkins server.• Maintaining the test environment.Key Achievements:• The implemented testing stage in the CICD pipeline enabled the early identification and timely resolution of new issues.• Created more than 10 Jenkins sub-projects with advanced parametrization to execute test plans and specific tests.• The developed test runner significantly improved the organization of test results, facilitating quick analysis and monitoring.• Code coverage reports highlighted areas with insufficient coverage, guiding the team in the development of new tests.

Kharkiv, Ukraine

Project: Development of the E2E credit scoring solutionKey Responsibilities:• Collaborating within a team of 5 QA engineers as part of a 20-member project, utilizing Scrum methodology for effective project management.• Conducting manual testing of a C# application for building credit score solutions from scratch.• Verifying data validity and optimizing SQL queries performance on Microsoft SQL Server database.• Performing testing of the project website using Python and Selenium WebDriver.• Conducting API testing of the product using tools like Postman and cURL.• Maintaining and troubleshooting the test infrastructure based on Microsoft IIS, ensuring seamless functionality and analyzing logs.• Verifying and providing sign-off for deployments on customer servers.Key Achievements:• Collaborated with a team of 2 engineers to develop a robust UI testing framework using Python and Selenium.• Demonstrated proficiency in manual, exploratory, functional, regression, installation and UAT testing.• Identified and resolved the root cause of poor SQL performance in multiple stored procedures, analyzing execution plans and providing assistance in fixing them.• Mentored new employees and actively shared knowledge across the team, fostering continuous learning and growth.

Kharkiv, Ukraine

Project: HealthCare data analysis projectKey Responsibilities:• Collaborating in a team of 4 QA engineers within a 10-member project.• Performing initial data import into Informix databases and developing procedures for calculations and exporting results for testing.• Writing and refactoring Shell scripts for data import/export to the database.• Testing PDF reports using a Python-based test framework, validating calculated data and verifying the accuracy of points on visual graphs.• Conducting post-deployment testing of reports on customer web-sites using Python and Robot Framework.• Management and maintenance of the test framework for both database and UI testing.• Providing solutions for optimizing the existing framework.• Providing sign off for release.Key Achievements:• Strong experience in Kanban and Waterfall methodologies.• Optimized the execution time of SQL Shell scripts from 6-8 hours to 2-3 hours.• Resolved multiple flaky issues in UI automation, resulting in reduced test failures.• Refactored core modules of the test framework to adhere to Clean Code principles, improving readability and reducing the codebase.

Kharkiv, Ukraine

Project: Development of the open-source Chrome-based web-browserKey Responsibilities:• Collaborating with a team of approximately 50 quality assurance engineers in a large-scale project.• Working as part of a sub-team of 4 QA engineers responsible for testing network-related features.• Acquire proficiency in Agile methodology and the system development lifecycle (SDLC).• Conducting manual, exploratory, functional, regression, installation and localization testing.• Performing API testing using tools such as Wireshark, Fiddler, Charlies and JMeter.• Testing the application on various operating systems, including MacOS, Windows, Ubuntu, etc.• Writing scripts in Python and PowerShell to set up test data.• Developing XML-based API tests, focusing on data input and familiarizing with JSON/XML structure and schema validation.• Utilize browser console and internal pages for debugging purposes.• Creating manual tests for new product features.Key Achievements:• Discovered a critical issue with an outdated application version on one of the 7 servers under the load balancer, ensuring its timely resolution.• Successfully addressed multiple critical issues related to the caching mechanism, improving the application's performance.• Recognized with the internal achievement "Crash Tester" for identifying 10 high-severity bugs that caused application crashes.• Created more than 15 test plans and manual test cases for testing new network features.• Developed proficiency in *nix-like operating systems.• Implemented a CRUD module in Python to facilitate file management on an FTP server.

Kharkiv, Ukraine

Key Responsibilities:• Ensuring uniformity of measurements in Ukraine for the range from 1 mm to 1000 m.• Verifying and calibration various length and optical measurement equipment.• Developing calibration methods to enhance measurement accuracy and traceability.• Researching modernization strategies for existing measurement standards.Key Achievements:• Scientist-keeper of the "Secondary standard of length unit in the range of 24-1000 m",contributing to maintaining accurate measurements in Ukraine.• Served as the Executive Secretary of the COOMET Technical Committee 1.5 "Length and Angle", facilitating international cooperation in metrology.• Represented Ukraine in the international comparison of stabilized He-Ne/I2 lasers (COOMET.L-S9, 2011), contributing to global measurement standardization efforts.• Recognized as a participant in the competition "The Best Young Metrologist of COOMET-2013" at PTB, Germany, showcasing expertise and dedication to the field.Tools & Technologies:• Proficient in operating surveying equipment, including tachymeters, GPS receivers, theodolites, and more, for precise measurements of large-scale distances and dimensions.• Skilled in operating laser interferometers, coordinate measuring machines (CMMs) and optical microscopes.• Basic knowledge in operation of atomic force microscopy (AFM) for precise measurements of nanoscale particles.

Kharkiv, Ukraine

Key Responsibilities:- Dived deep into verification and standardisation area.- Became familiar with various measurement techniques and standards.- Performed verifications of different length and optical measurement equipment.

Master'S Degree, Applied Economics

Thesis: "Economic-mathematical methods in project management of metrological expertise"

Education record

Internship at working group 5.42 "Multiwavelength Interferometry for Geodetic Lengths"

Master'S Degree, Radiophysicist

Thesis "Research on the possibility of controlling the energy parameters of slots in a waveguide using dielectric inserts"