1998-1999, customer: “Lucky Trade”, outsourcing, 1 developer
result: realized but not used
OS/Hardware: Windows 98; languages: VB 6.0, VBA, SQL; tools: Visual Basic, MS Access DB format, MS Office 97
Simple “CDPlant” based multi-user database for goods registration, goods movement and using tracking, planning and creating orders to manufacturers of goods based on current and minimal amount in the store.
1998, customer: private firm, outsourcing, 1 developer
result: realized but not used
OS/Hardware: Windows 9x; languages: VB 5.0, VBA, SQL; tools: Visual Basic, MS Access DB format, MS Office 97
“CDPlant” based DBMS for goods tracking.
1996-1998 (2 years), customer: “Mashel” & “Bolidisk” (1&2nd Compact Disk Manufacturing Plants in Ukraine), full-time, 1 – both developer and systems administrator
result: implemented and used starting 1 year of development
OS/Hardware: Windows 9x; languages: VB 3.0-5.0, VBA, SQL; tools: Visual Basic, MS Access DB format, MS Office
Multiuser System monitors CD manufacturing orders fulfillment. 12 possible parts of manufacturing process execution, in/out of stock. Second implemented version was able to calculate timing of orders at the moment of ordering. Different reports preparing using MS Word templates with special tags. Finally source code was 50 000 lines of VB. “Orders” DB table had 160 fields. Custom part of process interface customization was possible (manager, reception, designers, manufacturing, printing, packing, stocking, etc.) with different rights of access. DB had user friendly backup/restore procedures.
Custom record locking mechanism was made. Parametrized search, administrator controlled configurable tables.
1995-1996, customer: “Techsell”, Sweden, outsourcing, 2 developer
result: several versions were released
OS/Hardware: Windows 3.11/95; languages: VB 3.0, SQL
It was my first project which used Visual Basic and SQL.
Aim of our project was to make parameterized selections from ready team scheduler DB and to print results in different formats.