My projects

Alex Terletskiy

List and brief description of my projects

ERP system IsPro

10/2023 - 09/2025

Functionality expansion and bug fixes

Tools: Ms VisualStudio (C++, C#), WebAPI

RDBMS: MS SQL, Oracle

Crew member certificate

2023

Entering data for the production of a certificate.

Tools: C#, DevExpress, MS SQL, WCF

Technical Vision System
(as part of Track&Trace)

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 can be applied automatically by a special printer or by a manual applicator, which is filled with stickers with the code and other product information.
The code from the box is read either by a camera or a handheld scanner 1D(bar+)/2D(QR+) and transferred to the database. Thus, the database accumulates information that allows you to aggregate goods into a container.
Similarly, the level of nesting can be increased: small box to big box, big box to pallet, pallet to truck/rail container.

As a result, by reading the code from a container document (e.g., a waybill), it is possible to obtain all the information about the contents of the 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

Unique code identification systems

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.

Example
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

Website

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

Printing documents on a plastic card

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

Information systems with distributed databases

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

The increase in available DB space

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

Medical card wounded

07/2015 more ...

Teken data from email and put in DB

Tools: C#, XML, MS SQL

Taken biometric data

Reception photo, fingers print and signature

Devices:
Fingerprint scaner Sonda LS2FP;
Camera Canon EOS 1100D;
Wacom STU-520A.

Tools: C#, Canon SDK, Sonda SDK.

Online Business Card

05/2014 cheese.kiev.ua

Development of a small website

Tools: Apache HTTP Server, PHP, MySQL

Graphic Personalization document based on plastic cards

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

Devices: Datacard DCL65

Expert opinion

2011

Software for creation Expert Opinion of research forgery documents, banknotes, and other

Subsystem of automated data exchange

2011 - for a system of issuance of a certificate state employee

Transferring files via FTP. Queuing for transmission. Multithreaded processing queue

Automatic data backup

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

System receiving payments from the public

2008-2010

Design, development and implementation of hardware and software e Pay-desk