Sergei Girba

I am involved in the development of a new digital insurance platform in a cross-functional product team. I work in an Agile environment, microservice architecture and a full CI/CD cycle.

I transfer the knowledge accumulated over 9 years into media format.

Partnerships with crypto exchanges and crypto projects. I provide personal advice in the field of investing in cryptocurrencies.

Development and management of new IT systems from scratch (ERP, CRM, ETL, MVP, API) for business automation and refinement of existing customer systems.

Free communication with business, collection and analysis of requirements and setting of tasks for technical leaders and developers. Writing technical documentation. Building UML diagrams. Database design (relational and non-relational). Communication with related teams. Risk analysis.

I use an approach in analysis and development that reduces costs and brings profit to the business by automating processes.

A decent background as a lead developer and excellent communication skills allow me to easily translate business requirements into an IT product.

Collection and analysis of business requirements, interaction with the business customer (communication in the same language with developers and business). Organization/management of Scrum/Kanban work. Setting and decomposing tasks together with the team, writing the necessary specifications. Assessment of labor costs and control of task performance. Participation in the construction of architecture and interaction schemes. Ensuring the integration interaction of systems. Creation of data structures, description of data processing algorithms. Development of the system analytics direction.

All cycles of development of a new service. Created MVP. PHP 7.4, Nginx, MySQL, Memcached, Ubuntu 20.04, GitLab CI/CD.

Creating new ETL system with DWH (PHP 7.4, RabbitMQ 3.8+, ClickHouse 20+, MySQL 8, PostgreSQL 12+, Laravel/Lumen 8+, VueJS 2.5+, PHPUnit 9+, Allure, Redis, KeyDB). Optimization and improvement of the analytical system. Optimization of database queries. Support and improvement of the API.

Development of a panel for system administrators to automate work with IPs and domains (API integration - Cloudflare, OVH, GitLab, Ansible).

Development of an Internet project from scratch. PHP 7.2, MariaDB 10.4, Nginx, Memcache, Ubuntu 18.04, GitLab CI/CD, jQuery, Ajax.

Engineering, design, programming, testing, PR, contacts with potential clients (photographers, models, designers, etc.). Bots for searching experts were created in Telegram and VK.

Developed new company websites. PHP 7, Zend Framework 2, Twig, MotoCMS, MariaDB, Redmine.

Development of an ERP system for pre-post preparation (Russian Post) from scratch. Some features:

• Loading of mailing lists and data standardization
• Packman app
• Automatic tariffing according to Russian Post tariffs (standalone calculator with daily loading of new data and detailed tariff breakdown)
• Automatic selection of the most beneficial tariff
• Label printing
• Generating form 103 with a single click
• Generating financial reports
• Working with returns

Designing and development of Web apps and services. Automation of business processes. Designing and development of a custom basic MVC framework for application deployment and interaction with the main company system. Designing and development of user interfaces and views. Deployment and operation of a MongoDB-based infrastructure.

Integration and support of various API code in apps. Some of them: Mandrill, Mailgun, Smspilot, DaData, Yandex.Maps, Yandex.Geocoder, OpenStreetMap, Google. Integration of API code services for partner companies, such as DPD, BoxBerry, Strizh, Russian Post, TopDelivery. Asynchronous app development for data processing. API designing and development for high-load apps. Development of redundant, fault-tolerant web apps. Development of services for internal workflow.

From all the completed projects, the following can be highlighted:

• Fault-tolerant system for weighing orders for warehouse facility. The system consists of several services and apps, which capture the weight from the order using a custom app developed based on Google Chrome App and Shtrikh-M Slim scales. The system implements guaranteed data transmission to the main company system.
• Automatic address geocoding and distance estimation system from MRR/RR for new company orders (OSRM + Yandex).
• Google Chrome app for working with Shtrikh-M FR cash register through the browser (main trade functions are implemented, exchange between devices is done via POS protocol).
• Parcel status monitoring system from multiple operators (Axiomus, BoxBerry, DPD, TopDelivery, Russian Post), unified into a single format. Widget for online stores with flexible configuration options.
• Development of a C# app for automatic interaction with online cash registers.

Setting up interaction between dispatchers and taxi drivers from scratch in a new taxi park. Creating a new website. Monitoring taxi drivers using specialized software.

Database design (the topic was refresher courses for educational institutions) and creation of a management system.

Further development of a CRM system according to clients' needs. Creation of new plugins and report generators. B2B sector.