TISS is one of the leading distributors of auto parts in Russia. Official representative of the international trade and purchasing group Nexus.

  • On the market for over 27 years
  • More than 200 brands in the portfolio
  • About 10,000 wholesale customers
  • More than 1,000 employees
  • Branches in 25 cities of Russia
  • The company’s assortment includes about a million products


Ladies and gentlemen, all the schemas displayed on this page show distorted information and do not provide accurate details about the actual architecture of the project.

About my projects in the company

DBA MS SQL
As part of this project, I converted snapshot replications to transactional ones. Starting in 2022, the load on databases increased significantly, and snapshot replications became a source of problems and failures when updating them. I converted several dozen publications and subscriptions to transactional ones. This process took place with a constantly loaded database and took about two months. Several dozen stored procedures were rewritten, queries were optimized, additional indexes were built.

For projects in Kazakhstan, I have carried out a complete restructuring of the database configuration, all databases were collected into one instance, the connections between them were rebuilt and the replication system was built anew. Reference books of normative and reference information (assortment, tables of analog connections, etc.) were transferred.

Performed setup and maintenance of SSRS (Microsoft Reporting System, included in the MS SQL delivery).
Web developer
As part of servicing the company’s websites, I completed the revision of web pages and created new ones.
For websites in Kazakhstan:

  • Developed a system for asynchronous polling of external suppliers’ APIs. On the backend side, parallel requests were initiated to the suppliers’ APIs, which transferred data in parts to the browser; on the browser side, this data was also collected in parallel mode and dynamically displayed on the page
  • For external suppliers’ APIs, developed a custom parser for data transmitted in XML format.

Desktop application developer
Developed an application that filled catalogs of images of parts and diagrams on Yandex Disk, processed these images, put a watermark on them and uploaded them to Yandex Cloud. The application allowed for setting up watermarks for various storages in Yandex Cloud, which allowed using a library of sample images for different sites and companies with different watermarks. Batch processing of about a million images for the company’s sites was performed and they were transferred to Yandex Disk and Yandex Cloud.
Data analyst
Development and maintenance of SSRS reports for the assortment and marketing departments.
Preparing documentation for the product analog selection system for the old website.
Unfortunately, this system was not documented and the business did not have a full understanding of how the product issuance on the website worked. The database block for such selection contained about 20 tables and was serviced by several stored procedures and functions with a total of about 10,000 rows and 7 nesting levels, which mostly consisted of complex SQL queries. I built a process flow chart that allowed me to identify bottlenecks in the algorithm and even errors. I used the drawio editor to create the chart.
Upon completion of the analysis, I made changes to the replication system to avoid cross-server requests to databases on other machines, and built additional indexes on the tables to speed up the execution of SQL queries.
Transfer of data (normative and reference information) from the old project database to the new one, PostgeSQL DB.
The database structures were radically different. To carry out the transfer, a copy of the tables of the new database was created in MS SQL, procedures for filling them were written.
Initially, the contractor put forward a requirement to transfer data by means of loading on the new site through files in Excel format, in connection with this, unloading from MS SQL into files was carried out with division of large tables into parts. After abandoning this loading method due to its low performance, I transferred the data using database tools.
Development and maintenance of a database (ClickHouse) for a reporting system and dashboards. Working with Yandex DataLens. My responsibilities included planning and maintaining a database for an analytical system, data was transferred to it from 1C.

Add Comment