Project Tracking System

We developed a comprehensive project tracking system for tracking project schedule and status, time and expenses to ensure quick and easy turnaround ensuring maximum profitability. It is used by different industries like IT Services, Healthcare, architect designs, automotive etc. This system is perfect for professionals, workgroups and enterprises who want to track time, project expenses and knowledge.

The primary intent was to migrate the system from VB6 to VB.Net and the Access database to SQL Server 2005. But prior to migration we were involved in increasing the efficiency of the existing software application as it was slow on performance in data formatting and display.

For improving the efficiency of this project we have done some changes which are as follows.

1. We have written stored procedures for this project.

2. We have done some major changes to improve existing code performance.

3. We have written triggers for this project. For example before the changes, the data populated in Flexgrid took 81 seconds and after the changes it took just 18 seconds. We also worked on writing Macros for this system to generate correct/formatted Pivot Tables out of single Excel Sheet.