We work on projects for our clients ranging from less than ten hours per month to over 150 hours.

Portal Development

Part of a team that created an extranet portal to handle the contract creation, student details such as attendance and personal information, and invoicing. The portal was written in VB.Net 2005 (ASP.Net 2.0) using DotNetNuke 4.3.X .

SQL Server Data Warehouse programmer

Created SQL Server Integration Services (SSIS) scripts and stored procedures to take data from an external source and transform it to go into the data warehouse. Also created some helper applications for this process.

Forensic Computing

Since 2005, we have been working with a company on insurance fraud cases. Data was seized and various methods were used to extract the necessary data for analysts to review and categorize the data. We worked as part of the team by creating Microsoft Access databases to manage the hundreds of thousands of files involved. Microsoft Excel was also used for some tasks. Word automation was put in the forensic application to get the information that showed fraud was being committed. Other utilities were created and third-party utilities were used to extract data from Microsoft Word documents allowing analysts to use an aggregating process to deal with documents rather than working with the documents as a single file or small group.

Visual Basic Rework

A temporary agency had a program that was created twenty years ago. They asked the original Dbase programmer to create the next version. The developer decided to rewrite it using VB, however it was written in a Dbase style. This design mistake led to code that had bugs that were difficult to eradicate. The program was re-engineered to work in a modular fashion using Classes and Modules to encapsulate code where appropriate. Before the client said that if one bug was fixed, three new problems would surface. Now when a bug is fixed or a feature is added it does not create a dependency spider web.

Custom Microsoft Access Reports

Helped a law firm with Access Reports to get data they need from a program called ProLaw (a legal application by Thomson Elite; a.k.a. ProLaw Enterprise). The application did not provide reporting that covered all of the requirements for the law firm. We analyzed the database structure and created an easy to use Access database to run weekly critical reports for the company.