Created bill tracking tool for client incorporating MS Access, SQL Server and Visual Studio – SQL scripting, VB.Net
Customer had a ms access tool for tracking bills that was being used by 25 different employees. Complaint was that the tool would often freeze when one or more individuals was using it or when processing the data. After reviewing the customer’s system it was determined that there were several component contributing to the issues. The MS Access tool was saved to a network drive however the original developer didn’t split the database. Each users machine was processing the data with its individual ram which on several machines was very limited to non-existent. In addition there was several networking issues that needed to be solved.
Recreated the tracking system as a Front End VB.Net data entry web form with sql server maintaining the data.
The new application improved the customer’s day-to-day processes. Solving the processing power issue, increasing system response time and performance.