ISTC

Discount Manager - VS2003/ASP.NET – Web application for managing adding, updating and reporting of about 35.000 student discounts for 150-200 users (60 forms – 6000 lines of code – 30 SQL tables – 30 views – 70 stored procedures).

DiscountDB – VS2003/ASP.NET - High performance Web application for searching student discounts (5 forms – 1000 lines of code. - 11 SQL tables – 20 stored procedures).

DiscountServer – VS2003/ASP.NET - High performance Web Services interface to the above mentioned DiscountDB (1000 lines of code).

Card Central DB - VS2003/ASP.NET - Windows application for uploading CSV files (1200 lines of code) plus a Web Service for managing and retrieving 6 million cardholder records (1900 lines of code – SQL Server back-end).

Contact Manager - VS2003/ASP.NET (Upgraded to VS2008) – Web applications that allowed members to update their contact information, key contact persons and roles. Included programmatic generation of PDF version of Member directory.

Office Manager – Web application for managing sales office locations (4 forms - 900 lines of code).

Office Server – Web service for retrieving sales office locations (240 lines of code).

Audit Comm – Web application allowing 3 internal auditors access to audit documents (document types: Word, Excel - 5 forms – 300 lines of code).

WYSETC Website – (20 forms – no code – complex include files).

Member Websites – CMS based website supporting several association websites (12 forms - 2600 lines of code – 5 SQL tables – 15 stored procedures).

Finance – Web applications for members to review their PDF invoices.

Quarterly Sales Reporting - VS2003/ASP.NET (upgraded to VS2008) - Web application for members to report their quarterly card sales (10 forms – 1300 lines of code – SQL back-end)

Newsletters VS2008/ASP.NET – Web applications for creating and publishing newsletters (10 forms – 5 User components - 1600 lines of code - SQL Server back-end).

Share Knowledge – Web applications sharing Best Practices, Marketing programs, Facts and Figures, Success stories - VS2003/ASP.NET (20 forms - 600 lines of code – SQL back-end).

Performance Assessment - VS2003/ASP.NET - Web Application allowing members to submit their sales and marketing activities and objectives - (17 forms – 3500 lines of code – SQL back-end). Includes MS Access with VBA front-end for reviewing and reporting.

Java based projects:

Ordering - Silverstream/java web application (80 pages - 300 lines of code and business logic - 100 lines of code on page logic - SQL Server 2000 back-end).

Discount Manager (initial version) - Silverstream/java web application and SQL Server 2000 back-end.

ISTCnet - Silverstream/java web application and SQL Server 2000 back-end.

Discount Manager (initial version) - MS Access/VBA.

CardMaster - MS Access/VBA.