Financial system, which is tightly integrated with the Warehouse Management System, developed and deployed earlier in this company. This system has been designed in the client-server architecture.

In the framework of this project, I took part in requirements analysis, software system architecture design, designed database schema with the help of ERWin CASE tool for MS SQL Server, and developed applications on Sybase PowerBuilder, developed reports on Seagate Crystal Reports.

The following applications have been designed and developed:

1. Reference management utilities, which are used for setting up the system
2. Reports on documents and operations, balance report
3. Day opening/closing procedure
4. Data replication/transport utility between company branches
5. Payment indicator
6. Document processor

Facts

Internet shop (accessible via HTTP on VESCO WWW site www.vesco.ru/ishop), which allows our customers make their orders and view the descriptions of the positions on sale in the Internet. This Internet shop does not require such heavyweight technologies like ASP, EJB, Cold Fusion, etc. It it completely based on client-side lightweight JavaScript programs and cookies. At the same time a special integration part was developed. It resides on the company side, and communicates with the corporate database. It automatically generates new site content, and collects and processes email orders from our customers.

The Internet shop software components structure is described in the following list:

1. VESCO's side:  Corporate database, Goods description utility, HTML templates, Import utility, Export utility, Order processing utility.
2. ISP's side: HTML pages/JavaScript, E-mail processing CGI script
3. Client's side: Internet browser

In the framework of this project, I designed both Internet-shop and integration/generation programs.

Facts

The warehouse management system was designed and developed for VESCO Company (Moscow, Russia).

VESCO is a hole-sale trading company. The company sales spirits and wines for Moscow region and other regions of Russia. It has six branches in Moscow, each with its storage places and points of sale. All branches are bound to the central office (every day they send and get information to (from) the central office).

The Warehouse management system is an information system that automates and helps to control all kinds of warehouse operations: buying and delivering products from suppliers, managing prices, sell products to retailers, wholesalers, and consignees, it provides various set of reports and official documentation.

The system was developed on Centura Team Developer (Centura, formerly Gupta) platform as a front-end of client-server architecture and on SQLBase (Centura) SQL-DBMS as a back-end. DBMS servers are installed on separate servers in the branches. Reports were developed in Seagate Software Crystal Reports 6.0.

I have been working on this project since the forth quarter of 1995. The system was released and then installed in January 1998. Since 1998 it has been redesigned (some parts of it were added or changed) several times due to permanently changing law in Russia.

Description

WWW site for VESCO company (address in the Internet - www.vesco.ru)

Participation

In the framework of this project I designed and developed the site.

For development of this site, WEB-design tool Microsoft FrontPage`98 was used. Pictures were scanned and processed in Adobe PhotoShop v.4.0 graphic editor. Animation parts were made in WWW GIF Animator.

In the framework of this project the warehouse management system, which is being used in VESCO Company, was researched. The purposes of this research were the following: to obtain functional dependencies between parameters (number of clients, hardware characteristics, etc.) and response time, determine maximum number of clients, determine any potential bottlenecks, and find ways of system optimization.

Participation

A software utility that helps to fill in TPC-C test results was also developed. The TPC-C test results (Transaction Processing Council test "C" for OLTP systems) are used in "Decision support system (DSS) on distributed systems design and development" which was developed by professor, Dr. Ury Grigoriev at Moscow State Technical University named after Bauman. Application was developed on Centura Team Developer as front-end part in client-server architecture. Back-end part is DBMS Personal ORACLE 7.1 for Windows 9x.

This software system was developed for one of Moscow's pension funds. The system is used for clients accounting and for payments distribution among them. It was developed on 4GL SQLWindows (Centura, former GUPTA) for SQLBase DBMS.

Description

The advertising utility was written for MSTU named after Bauman to perform software product advertisement. This utility can be used with all software products for MS DOS. It memorizes pressed keys sequence in special file and then, in demonstration (advertisement) mode, plays this sequence.

Application was written using Borland C 1.0 language.

Utility has two parts:

1. Scenarios writer: Terminate and Stay Resident (TSR) part that intercepts INT 9 (keyboard interrupt) and memorizes key-codes (codes of keys pressed for navigating in demonstrated program's menu) and time intervals into a memory buffer. After the end of a scenario, the buffer is flushed into a file on a disk.
2. Scenarios player: Also has TSR part that intercepts INT 8 (timer interrupt) and according to a written scenario puts previously recorded key codes into application's input buffer.

Description

This system was developed for fish-growing production to help an operator to monitor several parameters (temperature, oxygen and nitrogen concentration in the water, etc.).

Participation

In the framework of this project, I developed software part of the monitoring system. Software component was divided into two parts:

1. Resident driver: this part was written for MS DOS operation system (OS) in Intel x86 Assembler. This driver intercepts INT 8 interrupt (timer interrupt) and reads special hardware ISA card (analog-digital converter) inserted into computer expansion slot. Data read from this card is written into a special shared data file on a disk.
2. Interactive part: this part was written in Borland C v.1.0 for MS DOS OS. It shows results (from the data file on a disk) on a computer display in graphical format. Measurement results can be shown according to a selected period or a set of parameters. Measurement results can be displayed either in on-line mode or in off-line mode.