Projects

Posts Tagged ‘SQL’

“Octopus” – WEB Store Engine (WSE)

1999-2000 (10 months), customer: “Sumix Corporation”, full-time, Developer & Project manager, 4 developers
result: several WEB stores were implemented
OS: Linux; languages: TCL, HTML, SQL; tools: AOL server

WSE consists of flexible set of parameterized TCL scripts, Shopping cart (PERL) and Admin part for building Oracle based WEB Store with credit card payment.
My part was writing TCL scripts for DB data representing in HTML and Admin part for the store controlling and DB filling.

@ Software, WEB/Network , ,

DBMS “Sklad” (“Warehouse”)

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.

@ Software, DBMS/ERP ,

DBMS “Romashka”

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.

@ Software, DBMS/ERP ,

DBMS “CDPlant”

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.

@ Software, DBMS/ERP ,

Team Events Schedule System Printing Support

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.

@ Software, DBMS/ERP ,