Sergei Goriashin Email & Phone Number

Tbilisi, Georgia

The CRM product “Business Process Management Platform” is designed for customisation, automation of client calls and synchronisation with external systems.- Developed over 20 new RESTful API functions including controllers, views, services, repositories and table models using Spring MVC, Lombok, Spring Framework and JPA/Hibernate.- Expanded product functionality by refining over 50 existing API functions.- Migrated the product from Oracle to PostgreSQL by implementing a new connection, unifying SQL queries using MyBatis and rewriting functions and procedures. This reduced the cost of the product for the client and reduced Oracle license costs. - Performed over 15 database schema change tasks using Liquibase. These tasks included creating tables, adding columns, descriptions, creating indexes, sequences, and adding constraints. All operations were performed to support both Oracle and PostgreSQL simultaneously.- Repeatedly performed technical analysis to determine the feasibility of implementing the requirements.- Conducted code refactoring to improve code readability and to unify and make implementations more flexible.- Increased unit test coverage of the application by 14% using JUnit.- Increased the security and interoperability of the product with other systems by analysing vulnerabilities with JFrog Xray and updating dependencies in Maven/Gradle.

Tbilisi, Georgia

The "Payment Acceptance" product is designed to integrate with external payment systems, manage payments, accept payments via web-cash offices and process bank statements. - 100% covered new functionality and bugs with the help of TestNG. - Successfully migrated the product from TestRail to Allure. - Ensured 100% shipment of the product, including defending the project to the client and conducting QG, contributing to a successful release and customer satisfaction. - Corrected all “historically red” tests for stable CI/CD performance. - Conducted manual testing of the PAYS web interface using DevTools, Postman and JMeter. - Conducted comprehensive product testing with related product teams for comprehensive analysis and defect identification.- Implemented integration tests on Robot Framework.

Moscow, Russia

The Customer Service Management product implements server-side program logic for working with product offerings, products, services and resources provided by a telecom operator to its subscribers. - Minimised system problems by preventing them from occurring through automated OSA-based scripts (ETL). Scripts included handling multiple databases, python scripts, handling RabbitMQ messages and api requests. - Expanded product monitoring with Grafana, providing more comprehensive coverage. - Reduced Time To Market by creating temporary solutions using ETL. - Ensured high service levels by resolving incidents within SLAs. - Minimised and remediated incidents through mass operations in Oracle SQL. - Ensured continuous customer service through participation in scheduled product updates. - Facilitated the adaptation of new employees to the product through the creation and development of a knowledge base for the ETL solution.

Yekaterinburg, Russia

The "Customer Service Management" product implements server-side software logic for handling product offerings, products, services, and resources provided by the telecommunications operator to its subscribers. - Reduced customer inquiries through prompt analysis of issues for commonality and swift response. - Decreased incident resolution time by developing templates for their resolution in Oracle SQL. - Performed as a team leader, providing effective team management, mentorship, and colleague training. - Enhanced customer satisfaction by maintaining high SLA performance levels.