524

Telegram chat bot

Start Jan 2025
End Feb 2025


The goal of the project: to study the basic capabilities of Telegram chatbots. Implemented functions:

  • Creating a command menu
  • Creating an inline keyboard
  • Sending messages to the bot
  • Receiving messages, commands and callbacks
  • Creating questionnaires and receiving graphical results
  • Recording all activity in the database
  • Deleting messages from the bot
  • Launching the telegram web application
  • Communicating with the web application

The bot is available at link
Libraries used: irazasyed (basic for working with telegram), jpgraph (for creating a graph), the web application is made in the form of a regular HTML page, JQuery and JQuery UI libraries are added to it.
The bot is serviced by a PHP program that runs on my hosting in a window (screen) of the operating system. The server requests messages every 5 seconds. I decided to make only this one option for now, so as not to lose messages in case of program or connection failures. The following general scheme works:

Continue Reading
, , 289

Project MUSICALION (Germany)

Start Jul 2019
End Jun 2021

The project is a commercial music service, whose members can publish their works, as well as works of other authors in their own performance and / or arrangement. I worked on the project from July 2019 to June 2021 as a programmer. To my great regret, during this time, I completed all the tasks assigned to me and there was nothing to work with, the covid epidemic also added negativity to this business, which led to its strong reduction and the cancellation of the well-known music competitions for which the project was the organizer.
Due to the fact that I am associated with my former employers by the NDA (Confidentiality Agreement) agreement, I cannot elaborate on the tasks that I performed within the framework of this project and the technologies on which this was performed. You can look at the part of the project site that is in open access, this is a rather large piece of it, by the nature of my activity, I took part in the modification of almost all pages in one way or another, and I created some of the modules and functions from scratch, they were not in the project.
Briefly, I can list the following areas of my activity:

Continue Reading
, 250

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.
    • , , 336

    Project OMS.

    Start May 2013
    End May 2014
    oms-11
    Customer: Company “NADOM”, member of OTTO Group Russia
    Project type: The internal enterprise project for marketing Department
    My position in project:
  • The database architect
  • Head of development
  • The architect of software solutions
    • Operation systems: Windows, Mac OS
    Databases: mySQL, Oracle
    Languages: C#, PHP, SQL, Adobe JavaScript, XML
    Technologies: Silverlight, Adobe InDesign (client, server), SOAP, PHP image libraries, Microsoft Reporting Services
    Interface language: English


    OMS (Offer Management System) is a system for creating catalogs of products in a format for print (Adobe InDesign).

    Includes:

  • A graphical editor allowing you to create presentations consisting of images, text blocks, internal variables and other presentations.
  • Database (mySQL) for storage of proposals (offers) and the goods within them, which is updated from the database of a CRM system (Oracle). Also the database stores information about the catalogs and presentations.
  • The system for building of catalogue templates and the catalogues that can be replicated to the Adobe InDesign server using SOAP (PHP, Adobe JavaScript).
  • The set of scripts for client programs Adobe InDesign (Adobe JavaScript) that allow you to connect to a database of products and update prices and descriptions using internal variables.
    • Continue Reading
    , , 354

    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
    , 269

    System process control for laboratory “EuroTest” (russian)

    Start May 2016
    End May 2016
    Interface for working with research results / Интерфейс для работы с результатами исследования
    Customer: Company “Euro Test”
    Project type: Inner enterprise project
    My position in project:
  • System analyst
  • Programmer
    • Databases: mySQL
    Languages: PHP, HTML, JavaScript
    Tecnologies: jQuery, PHPExcel library
    IDEs: Netbeans 8, mySQL Workbench

    Project purpose: provide laboratory analysis of biophysical material.

    Laboratory “Euro Test” performs biophysical research of materials for several large healthcare companies. The project provides registration of samples, preparation of research plan, task assignment for research, storing results and sending them to customers. Sending results via email (MS Excel format) and web services (XML format). The project site is closed, but customers have access to their results of research via the Internet.

    Continue Reading