WORK EXPERIENCE:

 
System 4 Administrator Application

Languages:

Microsoft Visual Basic 5.0, Wise Installation System 6.0, ActiveX Controls

Operating System:

Windows 95/NT

Computer System:

IBM PC Compatible

See Also: Screen Shots
CRC Card Sample
Sample UML Diagrams
Sample Code

 

Purpose and Notes:

 

Took over development of System 4 Administrator Application for GTE Enterprise Solutions. The product was initially an account manager tool for Multiple Listing Service (MLS) Board staff members for the System 4 MLS database system provided by GTE. I Worked in concert with an Oracle Developer to implement major new features including System Message Broadcasting, MLS Listing Transfers and Personal Database Update Restrictions. Also redesigned and improved existing Subscriber Manager feature.

 

  • Development proceeded by modeling classes using CRC Cards and UML diagrams with Rational Rose and Visio. Produced technical class model documentation exported to HTML format for use by legacy maintenance teams.
  • Developed a number of custom ActiveX Controls which were used throughout the application to increase code re-usability. Integrated a third-party multiple-selection tree view control into the application for use in the Listing Transfer feature.
  • Redesigned and improved the existing Subscriber Manager feature. Made improvements to the existing database layer and improved the user interface for creating and editing user accounts. Heavily optimized the queries for locating accounts using different search criteria.
  • Developed new System Messaging feature. This new feature required the application framework to change from one main window to a Tabbed main window. Subsequent new features were each placed on a new tab on the main window.
  • System Messaging Feature allowed the user to view all the broadcast messages currently in the system and add new, edit or copy existing messages and delete messages. Developed a pair of ActiveX controls to implement a drop down calendar and time control for later re-use in new features.
  • Developed an ActiveX control to implement a pair of listboxes with the ability to transfer items between each listbox. This was used in the data lookup dialogs. These dialogs would allow the user to search the database quickly for a message recipient by name, MLS ID, office or company.
  • Developed new Listing Transfer feature. Developed an abstract Tree View class for displaying Company, Office, Agent and MLS Listing information hierarchically from the database. The class isolated the application code from the actual tree view control used. This was necessary as the original tree view control evaluated was discovered not to have enough functionality for the application. Thus the 3rd party ActiveX control for the tree view was changed half way through feature development with no adverse effects on the application code.
  • The listing transfer feature was quite complex and involved several modes of operation where the tree control had to respond differently in each mode. Users could drag and drop listings between two hierarchical MLS listing displays.
  • Developed new Personal Database Restrictions feature. This was a simple feature to display and edit a set of parameters controlling the Personal Database Update.
  • Optimizations and effective use of caching improved application performance by 60% in many cases.
  • Developed SQL scripts and stored procedure API to generate appropriate test data for Listing Transfer feature. This enabled creation of test data on any client database for quick verification of program operation. This also removed the need to impact the database migration team to create test data manually, thus removing a bottleneck in the Development/QA process.
  • Developed unit test plans for QA to confirm operation of new features. Application user interface was so well done, members of QA were convinced it was developed in C++ and not Visual Basic.
  • Improved the setup program and responsible for creating and assembling application builds for release to specific client sites.
  • Completed major milestones and project deadlines on or ahead of schedule.

 

This was a project developed in 1998-1999 for GTE Enterprise Solutions

HOME | RÉSUMÉ | WORK EXPERIENCE | PORTFOLIO | DOCUMENTATION & WRITING | TOOLS OF THE TRADE | CONTACT ME | SITE MAP