Voronkov Nikolay, my portfolio.

Hello everyone!

I bring to your attention my portfolio: a brief overview of the projects that I have done in the last few years. Some projects are open, to them I give the links, some are the corporate developments and for them the only available description.

My main skills:

  • Databases: Oracle, mySQL, MS SQL
  • programming Languages: PHP, C#, Visual Basic, HTML, JavaScript
  • CMS: WordPress
  • Technologies: ASP.NET, Silverlight, WPF, Delphi, Microsoft Reporting Services, Microsoft Analysis Services (MDX language)

Speaking about the priority directions for me, it is:

  1. Oracle: database development, work with Oracle SQL, Oracle PL/SQL
  2. ASP.NET (C#)
  3. PHP: programming for the WEB

My last projects:

TISS Company

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


Read more …

Project MUSICALION (Germany)

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:

Read more …

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

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.

    • Add Comment