ESSENTIAL
SOFTWARE
December 2000 to March 2001
Title:
Microsoft Visual Basic Programmer
Profile:
Essential Software is a computer software company with a staff of 12. It provides
computer system consultancy and software. The company's expertise lies in writing
systems using Microsoft Visual Basic to access Oracle and SQL Server databases.
Duties:
- Support of the "BackOffice" for a large, 3 Tier, Travel Agency Client/Server system.
This involved mainly the creation of a sub-system dealing with Transfers from Hotels,
Airports and Wharves. The Transfer routine was written in Microsoft Visual Basic
6 using ADO to access Microsoft SQL Server Databases. It comprised incomplete and
un-debugged programs with little or no documentation.
- Provide technical Windows NT and Component Object Module (COM) support to the staff
in dealing with multiple versions of DLLs and ActiveX controls.
Achievements:
- Enhanced the Security DLL to allow User control at Form level. Set up maintenance
routines to maintain the Security system and the additional Microsoft SQL Server
Database Tables.
- Created a Message Queuing system that allowed triggered events to be forwarded to
selected users.
- Analysed and redesigned the Microsoft SQL Server Database for the Hotel Transfers.
Set up test data in the database.
- Rewrote a DLL that handled the various aspects of the Hotel Transfer system. The
DLL comprised of:-
- Numerous Forms with Tabs
- Many UserControls
- Various DLLs handling ADO, Buttons, etc
- Sheridan Grids and Combo Dropdowns
- Created a DropDown ActiveX control that allowed multiple item selection.
|