Enterprise Resource Management Tool
A custom tool was developed to track and assign resources to various projects.
The Enterprise Resource Management Tool streamlined the request for resources and handled subsequent allocation to various projects.
Features:
- Data store for active projects and available resources that could be allocated to the projects
- User interface for requesting resources
- Workflow for routing resource requests and providing approvals
- Role based security
- Reports for resource availability and project staffing
Benefits:
Optimize resource allocation
Solution:
Dashboard that collects data from various sources and consolidates into a central location.
The components of Resource Management Tool:
- Two data sources to load initial data and subsequent maintenance
- Resource Pool
- Project Portfolio
- Resource Allocation Work Flow
- Request Initiation
- Initiate requests for resources for specific projects
- Resource request notification sent to Strategic Resource Manager (SRM)
- Resource Allocation
- Assign resources to specific projects against resource requests
- Resource Allocation notification sent to manager and requester once assigned
- Manager Approval
- Manager Approval notification for Resources assigned sent to requester, SRM, manager and resource once approved
- Reports
- Resource availability by time (Gantt chart view)
- Resource allocation versus resource request by project (project staffing)
Technologies:
Microsoft SQL Server ,SharePoint, .NET