 VERTIKOTE
CORP. LIMITED
April 2007 to Present
Title:
Microsoft Access Programmer.
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 Programming. 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 issues.
- Created an Error handling module that records error details to a log file.
- 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.
- Eliminated all 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 BackEnd database. Created a Startup
Form that controls the BackEnd Relinking.
- Identified the sources of performance issues.
|