Resource Planning Solution (RAIVS)

Requirement

A resource management tool was required to identify resource shortages to allow the company to identify where investment into additional resources was required.  

In addition the resource management tool was required to identify resource shortages to allow the company to identify where investment into additional resources was required. 

Solution

Project  designed and developed a solution (RAIVS) that gave Network Rail a breakdown of possessions, timings, and track outages; as well as assigning people and equipment to avoid clashes and conflicts.  Thus ensuring resource usage is maximised.

RAIVS used Oracle data access components for Windows to integrate with Microsoft Power BI for the dashboard and visualisations.  The solution also used Oracle Apex to capture and manage data through forms which were output into a data warehouse scheme.

 An agile approach of six sprints was adopted, and these included interactive workshops with up to 12 planners participating at any one session so that development was quick, targeted and effective.  The team also developed an interactive user guide for end user assistance to help ensure adoption and up-take, supplemented with training sessions for key users and Train the Trainers workshops.