ERP system IsPro
10/2023 - 09/2025
Functionality expansion and bug fixes
Tools: Ms VisualStudio (C++, C#), WebAPI
RDBMS: MS SQL, Oracle
List and brief description of my projects
10/2023 - 09/2025
Functionality expansion and bug fixes
Tools: Ms VisualStudio (C++, C#), WebAPI
RDBMS: MS SQL, Oracle
2023
Entering data for the production of a certificate.
Tools: C#, DevExpress, MS SQL, WCF
2019-2022
The product with a unique code (QR, DataMatrix ...) moves along the conveyor, where a high-speed camera is installed.
The camera reads and transmits the code and time (local time, accurate to the millisecond) to the database. The fact of assigning a code for the product is recorded, and the product is sent for packaging.
The product are packed in a container (usually a cardboard box), and a unique code is applied to the box.
The code from the box is read either by a camera or a handheld scanner 1D(bar+)/2D(QR+) and transferred to the database.
Similarly, the level of nesting can be increased: small box to big box, big box to pallet, pallet to truck/rail container.
Tools: C#, MS SQL
Applied to: The system was launched to
- control the production of tobacco products. With QR on the excise stamp
- logistics of vegetable oil sales. With QR on the bottle label
2019-2021
The number of objects is almost unlimited.
A trillion objects can have a unique 8-character string code that includes numbers and uppercase Latin letters.
Unique object number | Code |
---|---|
100 000 000 000 | 11UE85X3 |
1 000 000 000 000 | 115BBB4X |
1 099 000 000 001 | 2HC3SHZZ |
Numeric 100 000 000 000=11UE85X3, can be represented as an image :
Code image | Type | Value |
---|---|---|
![]() |
QR | 100 000 000 000 = 11UE85X3 |
![]() |
Data Matrix | 100 000 000 000 = 11UE85X3 |
![]() |
Code-128 | 100 000 000 000 = 11UE85X3 |
![]() |
QR , url | https://site.com?i=11UE85X3 |
Usually, the generated codes are stored in the database, therefore, a CLR procedure was created, to increase the generation speed.
In this project has created an application for Andriod smartphone that reads QR, sends the read code to the webservice and displays information about the object, by code.
The mobile application was created using Android Studio in Java.
Webservice - SOAP (.asmx) in C #, under IIS.
Tools: C#, CLR , MS SQL
2020
Enter and display text data and images. The data is stored in the MS SQL database. Also, data is exchanged with database (Oracle in DMZ), via WCF web service.
Tools: .NET Core Reazor, C#, MS SQL, DevExpress/DevExtreme, Oracle
2018-2019
The way of life of the document according to the rules of document circulation, with different states from data entry to printing and issuance of the document
Tools: C#, MS SQL, DevExpress, InnoSetup
Devices: DataCard CD800
2016-2018
Data entry, data exchange between central and regional databases, search by various parameters, reports.
Data exchange via SOAP (.asmx), WCF web services
Tools: C# , DevExpress, InnoSetup
RDBMS: MS SQL, Oracle
11/2015-01/2016
Enter any personal data, photo, fingerprint, signature image.
Tools: C#, DevExpress, GreenBit SDK
Devices: WebCam, Scaner A4, DactyScan 84n
12/2015
MSSQL 2008 Express DB has a limit 4Gb. In this project, virtually, the available space is increased.
Tools: C#, MS SQL .NET SDK, MS SQL
07/2015 more ...
Teken data from email and put in DB
Tools: C#, XML, MS SQL
Reception photo, fingers print and signature
Devices:
Fingerprint scaner Sonda LS2FP;
Camera Canon EOS 1100D;
Wacom STU-520A.
Tools: C#, Canon SDK, Sonda SDK.
05/2014 cheese.kiev.ua
Development of a small website
Tools: Apache HTTP Server, PHP, MySQL
2013 as part of Ukrainian National Automated Information System of trafic police
My role:
The idea; Planning; Set task for software developers team; Control of execution; Introduction.
2012
as a module for systems to give certificate of registration the vehicle
and certificates for the driving licence
Picture and text data plotted on a plastic card by laser engraving
2011
Software for creation Expert Opinion of research forgery documents, banknotes, and other
2011 - for a system of issuance of a certificate state employee
Transferring files via FTP. Queuing for transmission. Multithreaded processing queue
2010 - for a system for forming an expert opinion of the vehicle inspection
Here is just a make schema dump the database Oracle XE 10, at system startup
Also in this project - installation of central database server Oracle 11 пoд OS Oracle Enterprise Linux
2008-2010
Design, development and implementation of hardware and software e Pay-desk