Gazprom Dobycha Nadym LLCGas & OilSince August 2024 - PresentTelegram bot for employee safety knowledge testing:- Developed a test generation system using aiogram-dialog- Wrote SQL query scripts for SQLite database- Created an authorization system in the botThe bot was developed for convenient and quick access to theoretical safety materials. The bot includes user information collection and an assessment system for test answers.Web application for database administration:- Developed user authentication system- Developed CRUD system- Tested main application functions using JUnit 5- Created web interface using Spring Web- Developed a web application on Spring Boot, including RESTful API implementation and integration with databases using Spring Data JPA- Configured Spring Boot autoconfiguration for different environments (development, testing, production) and managed dependencies with Maven- Implemented a multi-layer security system with authentication and authorization using Spring Security- Applied UX knowledge to create a user-friendly, intuitive interface- Developed an XML file parsing script for automatic database entryThis web application allowed for quick information entry and updates, instantly reflected in the Telegram bot.The entire project aimed to raise employee awareness of safety rules on-site and safe operation of gas extraction tools. The rate of successfully passed exams increased by 12% after the project's launch.Etagi - real estate agencySince June 2023 to May 2024Java Developer- Development of SQL scripts for adding/modifying tables;- Code coverage with Unit and Integration tests (JUnit 5, HSQLDB);- Development and support of Java applications using Spring and Spring Boot technologies;- Participation in making architectural and technical decisions;- Updating application components using updated technologies (Spring Web, Spring MVC);- Setting up Hibernate Cache;- Code review;- Develop overall microservices architecture;- Develop workflow of media services and web-search services;- Integrate Websockets functionality;