Posts Tagged ‘Server’

Our company implemented Microsoft Project Server 2003 a few years ago and last year, upgraded to 2007.  The tool is well suited for managing projects, which is why the Project Client is the industry standard for PM’s.  The Project Server gives you a centralized view of all projects, essentially a Portfolio View.  It also gives you the ability to view most data through the Sharepoint interface without requiring the expensive client (for non-Project Managers).  In addition to these benefits, we targeted our biggest pain point, the problem of capacity management.   Assuming all your resources are in the system, the data for managing capacity already exists, there is just not a good way to manage from it.  To address this, we built some custom reports that pull data directly from the SQL Server database.  In these reports, we can view all tasks for a specific employee, overdue tasks, and a chart that displays the next six weeks of workload across all projects and resources.  To account for the non-project work that we were competing with, we created a maintenance and support project schedule to block time needed for these activities.  We also created an administration schedule to track folks that are out of the office for vacation and training.  Adding these schedules gave us the total picture of resource capacity.  The system works rather well.  The PM’s now meet weekly with all the Resource Managers weekly and we look at all resources over capacity and negotiate.  We also talk about overdue tasks and how to address them.  This method does require that all PM’s manage their plans daily to keep the data accurate, but the benefit to the organization has been tremendous.


Read Full Post »