Project for automation of foreign branches of the company "Kvazar-Micro"
At the start of the project, the corporation had the following situation. An ERP system based on Oracle Applications had been implemented in the head office in Kyiv. A large expansion into the Russian and CIS markets was planned, with the opening of many branches. The task was to automate these foreign branches and integrate their accounting systems into a unified information space with the head office. At that time, internet channels were extremely expensive, and branches were planned from the Baltic states to Vladivostok, so it was necessary to find a solution with offline data exchange with the central office. Moreover, the exchange had to be bidirectional — both from branches to the center and from the center to branches.
Shortly before the project started, a new version of 1C 7.7 was released, and considering its low cost and the presence of a reliable distributed database system, it was decided to automate the branches based on it. Since the task involved exchanging the full document flow, it was important that the accounting models in the central Oracle Application database and in the branch 1C systems matched. For this purpose, a special 1C configuration was developed that replicated the financial accounting of the head office.
At the same time, functionality for integrating 1C with Oracle Application was developed. The integration system consisted of several dozen tables in a special Oracle interface schema, several thousand lines of PL/SQL code, and thousands of lines of 1C code.
After several years of persistent work, the system became operational and was deployed in dozens of branches across Russia.
The project team consisted of two people — myself as a technical specialist, and a financial manager, an excellent expert in their field, who was responsible for accounting models and implementation. Of course, the project would not have been possible without the full support of the corporation's management.
Ultimately, the system operated for more than 15 years, until the business in Russia was discontinued by the company's management.
Data hub of the credit risk department of the London bank Barclays
Due to the adoption of new legislation in the regulation of banking activities in the United Kingdom, there arose a need to consolidate data flows from several credit risk accounting systems into a single database.
This project was notable for me because of the geographical distribution of participants. I was a member of a team working in Kyiv. The business analyst, part of the project management, and some technical specialists were in London, others were located in New York. The testing team was in Singapore.
The technology stack used in the project included MSSQL, SSIS, and Autosys. I performed the role of a database developer. The team in Kyiv consisted of four technical specialists and one project manager.
Overall, it was a very interesting and intensive experience of international collaboration in the field of IT support for investment banking.
Electronic price list system for clients of KM-Disti
For a long time, clients of KM-Disti used an e-business system that allowed them to view a personalized price list in a web browser, create orders, and so on. However, a limitation of this system was that it required interactive manual work in a web browser. Sales managers of KM-Disti approached me with a request to develop an API that would allow clients' automated systems to obtain price lists without manual intervention.
As a result of the project, such an API was developed. Now clients can receive product information in JSON/XML format.
The technology stack used in the project included Perl, Dancer, and ORACLE.
I must admit — I am a fan of the Perl language. There is a certain poetry in scripts written in it. I am glad that my good old tool proved useful in this project.
Integration of 1C and a billing system based on Terrasoft Creatio at De Novo
At De Novo, a service billing system based on the Terrasoft Creatio product was implemented. The problem arose of integrating the billing system with the corporate accounting system based on 1C.
As a result of the project, such integration was developed. To solve this task, I had to dive into programming in Terrasoft Creatio. I developed: a Terrasoft Creatio web service in C#; a COM component used by 1C to interact with Terrasoft Creatio; and a fairly large 1C processing module used by an operator to generate documents.
The project involved the following technology stack — C#, Terrasoft Creatio, 1C.
This was a project involving multiple systems and quite interesting technological solutions.
Use of artificial intelligence (AI) to automate payment request entry at KM-Disti
At KM-Disti, managers manually created payment requests in Oracle Applications based on supplier invoices.
Supplier invoices were files in various formats, and their manual processing was a labor-intensive and exhausting process.
To simplify this task, a system using artificial intelligence from OpenAI was created. Now managers copy the invoice file into a special folder on the server, the AI analyzes the file and automatically creates a payment request in Oracle Applications.
The project involved the following technology stack — Perl, Dancer, ORACLE, OpenAI.