Home

Welcome to the ResourcePlanner wiki!

Introduction

The idea behind this project is to create a simple tool/report that allow managers to have a single view of the resource needs for upcoming or current ongoing projects and also have a view of those resources that are being released from various projects.

High Level Features

Requirements

Data requirements

Create a database in SQL Server that allows to persist resource data and generate reports. (Scripts to generate a basic database and table are committed to this project repo already. New scripts will be added as required)

High-Level Report Requirements as follows:

1. Resource requirements for upcoming projects - Count of resources required in next 3 months view
2. Count of resources that are coming out of Projects - (Resource ramp down or resources getting released)
3. Count of resources on bench

Front-end requirements

Create a GUI interface that allows user to manage resource data for projects. It will be a simple interface that allows the managers to allocate resources to various projects (current or future) / bench.

There will be a separate page that displays the report data fetched from SQL.