WORK
EXPERIENCE: |
|
 |
System 4 Administrator Application |
|
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
|