Visual Basic Programmer

Visual Basic Client Projects

Vertikote Corp. Pty Ltd

April 2007 to December 2009

Job Description:

Microsoft Access Programmer.

Company Profile:

Vertikote Corp. Ltd. is one of the largest industrial paint and powder coating operators in Australia. They offer a complete range of coatings and textures for commercial and domestic applications.

Duties:

Microsoft Access Database and Visual Basic Programmer. Maintaining the PCS Administration database, consisting of over 45,000 lines of code.

Achievements:

• Created a test environment to emulate the Vertikote PCS system.
• Using Terminal Services, created a test environment on the Vertikote Server.
• Installed the PCS system using Access 97, and then converted the databases to Access 2003.
• Upgraded the linkage of the Sybiz (FoxPro database) from ISAM to ODBC.
• Analysis of the Access database identified over 30,000 issues. Resolved all major problems.
• Created an Error handling module, recording error details to a log file and database.
• Added error handling to each procedure in all Forms and Reports. All "Resume Next" statements replaced with error handling. Ensured that all Variables are typecast. Eliminated Variant variables.
• Created an ADO module, to handle Database access.
• Upgraded Access 2 and VB5 functions to VB6. Removed all Access 95 constructs and macros.
• Created a data driven Menu system.
• Added Microsoft Access and User security to the Access database.
• Decompiled the PCS database, reducing the size by 60%.
• Added a procedure to calculate the number of workdays in a period, taking into account weekends and holidays.
• Created a Form and the logic to Relink to any Back-End database. Created a Startup Form that controls the Back-End Relinking.
• Identified the sources of performance issues.
• Added a procedure for the automation of Faxes to clients.