Property Tax Database Port for TCSL Project undertaken in November 1999. John Gibson upgraded the Property Tax database from SQL Server 6.5 to SQL Server 7 and the Property Tax database maintenance program from Visual Basic 5 to Visual Basic 6. Visual Basic 6 was used from within Microsoft Visual Studio 6. Enhanced Client Databases for Aspen Field Marketing Project undertaken between September 1999 and December 1999 Aspen Field Marketing uses a field representative force of about 200 persons to gather marketing data from small and medium sized retailers on behalf of household name clients. John Gibson enhanced and performance tuned the databases, the database maintenance programs and the reporting systems for two large Aspen clients.
Aspen databases tend to be very large.
One of the databases worked on had a table with 35 million rows. Aspen Field Marketing databases ran on SQL Server 6.5. The database maintenance programs were written in Visual Basic 5. All reports are written in Crystal Reports 6. Lloyds TSB is one of the largest UK retail banks.