, 246

TISS Company

Start May 2022
End Jan 2025
Customer: Company “TISS”
Project type: The website of the company
My position in project:
  • DBA
  • Web-programmer
  • Windows application developer
  • Data Analyst
  • Technical support engineer
Operation systems: Windows
Databases: MS SQL, PostgreSQL, ClickHouse
Languages: C#, SQL, HTML, JavaScript
Technologies: MS SQL Database (with replications), ASP.NET MVC, Razor, IIS, .NET CORE, WinForms, Git, AWS S3, SSRS

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

Continue Reading
, 63

Projects completed by me as part of the “Front Line” call center (Moscow)

Start Aug 2016
End Jul 2019

I worked as a programmer in a call center “Front Line” (Moscow, Zelenograd) from August 2016 to July 2019. There was a lot of work there, but several main directions can be distinguished.

  • Operational ongoing work, which consisted in the correction of existing telecommunications projects in accordance with the requirements of customers. The projects were ordinary sites written in HTML and Javascript on the browser side and PHP on the server side, a mySQL database. When creating a new project, usually an existing similar project was taken as a basis and modified in accordance with the terms of reference.
  • Ongoing work on creating reports for projects. Initially, all reports were written in PHP and there were several hundred of them. In the future, I was allowed to use Microsoft SSRS and I began to make new reports on my projects using this technology, in total I managed to write about 50 such reports, as well as train my colleagues to use SSRS.
  • Development of systems for integration with external projects. At the initial stage, there were few such integrations, I can only remember updating the DIT knowledge base, but later this segment has grown a lot. I have been implementing integrations with the following companies and organizations: “DPD”, “Nau taxi”, “Taxi commander”, “SPSR” (became part of DPD), “DIT”, etc.
  • With my arrival in the company, work was resumed on the creation of quality control systems for several projects that had not been possible to create until that moment. I managed to implement three such systems: for the DIT 7X7 project, the DIT EDC project and the project for servicing the chat on the Moscow State Pedagogical University website. These projects used one database, but on the client side, implementation technologies were very different: at the initial stage, I used plain HTML and Javascript for the control interface, in the next two projects I already worked with ExtJS. In addition, the projects were radically different in the algorithms for selecting calls and dialogues, as well as in the content of checklists for analyzing conversations, and the projects also had different reports that I did on SSRS.
  • When servicing the company’s projects, there was a lot of manual routine work, the management encouraged my project activities and therefore I constantly developed our internal production project. Within the framework of this project, I have implemented many tasks: managing the addresses of report recipients, a universal editor for regulatory background information, managing project interfaces, managing universal knowledge bases, etc.
    • , , 139

    The production planning of the company “Promopost”

    Start Jun 2011
    End Mar 2012
    Схема базы данных.
    Customer: Company “Promopost”, member of OTTO Group Russia
    Project type: Internal enterprise project for a Production Department
    My position in project:
  • The database architect
  • Developer
    • Operation systems: Windows, Linux
    Databases: mySQL, Oracle 11G
    Languages: C#, PHP, SQL
    Technologies: Silverlight, Oracle Apache Server
    IDEs: MS Visual Studio, mySQL Workbench
    Interface language: Russian

    Brief information about the project:

  • Support of calculations of loading for multiple assembly technologies
  • Planning within one month of loading assembly lines
  • Support for unlimited number of business units (firms)
  • Operational planning of lines loading for the days ahead
  • Storing relevant information about production processes in real-time
  • Import data from the CRM system of the company
  • Generation of reports in MS Reporting Services (SSRS)
    • Continue Reading