Welcome to web Pages of Vicky Shiv

Resume Experience Projects Courses Thesis Download
Web Distributed OO C++ VC++ Java Others Projects

Web Based Projects

Online Shopping web for Sobeys Inc.

Place: Sobeys Inc.
Platforms used: Oracle,Sybase, ASP, JavaScript’s, ADO, RDO and VB Scripts.
This application is implemented as a three tier web based client server architecture. This is a web based application for ordering stuff from Sobeys. It is on www.sobeys.ca under the Catering Service.

Online Shopping web for Eastern Sing Print

To check out sample screens click here.
Place: Sobeys Inc.
Platforms used: Oracle,Sybase, ASP, JavaScript’s, ADO, RDO and VB Scripts.

This application is implemented as a three tier web based client server architecture. This is a web based application for ordering stuff from Eastern Sign Print. There are two web sites designed for on line shopping at ESP, one for Sobeys Customers and  another for ESP administration. The searchable catalog of ESP is on the Web, which is divided into various departments and categories within the departments. You can place your order online and even check the status of you order later on. The status of the order is maintained with respect to the purchase order as well at the individual item in the purchase order. Administrator can update the status of the order so that the customer can check and view the latest status of its order.

The search and catalog screens helps in finding the items and put it into the shopping cart. The accounting module is also implemented, which helps customers and the company to print invoices and bills.This helps to articulate the purchase orders and invoicing printing from the web.The administrator can add, modify delete items from the catalog and change the status of the items online. The other key feature of the web site administration is quantity in order (total quantity in all purchase orders per item). This helps in managing the inventory.

Achievements: This process saves the cost of fax, phone, printing the catalog and helps in maintaining the inventory efficiently.

Employee Self-service

Place: Sobeys Inc.
Platforms used: BAPI, SAP, C++, Java (Access builder), Sybase, ASP, Java Script, VB Scripts, ASP and Visual Basic(COM).
To check out sample screens click here.

Designed and developed three-tier client server application. The application is used for corporate management of human resources to collaborate between several offices through the web.

Designed Human Resources Modules and Human Resources Web site. This includes inter platform development which includes C++/Java/Visual Basic programs (Inter Platform Developments in SAP) for calling BAPIs/RFC in SAP and ASP/Sybase for the web site. Since the BAPIs (OOP) is a new technology in SAP an extensive research was conducted. I was involved in designing the application and Extracting HR data from SAP into Sybase that is required to support the Employee Self-service Web Site. This is basically Employee data, any dependants, employee absence/attendance data, lookup tables to validate data entry, Warehouse Scheduling, Time Management as well as benefit and pension data. Once the data is ported to Sybase, Employee Self-service Web takes over for the updates and sending back these updates to SAP. BAPI interfaces will be used as much as possible to make updating SAP with changes. RFC calls are used to provide non-updateable data like lookup tables. Visual Basic will be used for testing concepts, but is then converted to C++ and Java. There was a large amount of R&D in this project.

Achievements: The Original cost of the SAP Employee Self service is a few millions dollars which is being saved by this Application.

Log Viewer Application

Place: Sobeys Inc.
Platforms used: C, Unix, Sybase, ASP, Java Scripts, VB Scripts and RI
 
This application is a Three-Tier Client server web application used to views logs files on the Intranet.
The Application is divided in few different modules.
1.All the raw log files from the SAP, Windows NT,Windows 95/98, Sybase, Oracle and Unix platforms are ported to Window NT Server.
2.These files are then gathered by Retail Interchange and are fed into a C Program on the Unix Machine.
3.The C program depending on the type of the Log files creates a bunch of text files to the bulk copy into Sybase.
4.Unix scripts have a semaphore (Task Controls) implemented so that out going text file should not be overwritten or corrupted.
5 The Bulk copy copies files into the database (Sybase/Oracle)
6 The ASP/ADO web pages are created to view and administrator the Log Files Modules.
7 The Cron process in Unix are used in scheduling the backing up the Log files on the Unix Platforms for 30 days.
 
Achievements: The whole project helps in administrating the vast varieties of platform dependent log files from the web in a centralized system.

Few other web application

Place: Sobeys Inc.
Platform used: Visual Basic(COM), VB script, JavaScript, ASP,ADO,Oracle, Sybase
To check out sample screens click here.
 
All these applications are four tiers Architecture. The first tier is the browser the second tier is the web server which is talking to the visual Basic COM object(DLL) through the MTS on NT Server which talks to the four tier database.This new technology using Visual Basic helps in reducing the response time significantly. Once the DLL is loaded in the user memory the execution times drops by 40% with respect to the convention 3 tier applications of ASP
Intranet Human Resources web sites
  • Staff Opportunity
  • Intranet security Modules

Gift Certificate/ Ticket web based application

Place: Sobeys Inc.
Platform used: C,UNIX script, RI, VB script, JavaScript, ASP,ADO,Oracle, Sybase
To check out sample screens click here.

This application is used to send the gift certificate and ticket information to the various stores of Sobeys. It contains different modules such as the web modules, process module and communication module. Gift certificate information is entered from the web and later this information is pulled out from the web into the flat file. These flat files are again reformatted and sliced according to the store standard format file. After that it is grabbed by the Retail interchange and send to all different stores across Canada. In the other way around files from the stores are pulled out and formatted to be fed back to the database and SAP for update and accounting.

Sybase to Oracle Conversion

Place: Sobeys Inc.

Due to the outstanding Issues for the Sybase , MDAC web group convert there intranet and internet back end to the Oracle.Converting the back end database of all the intranet web sites from Sybase to Oracle includes Active server pages, Unix scripts, database and VB com objects. This project was designed into 3 different phases which includes database conversion , source code conversion and IIS server management. I was mainly involved in handling the first two phases.
 
1