A global pharma giant was struggling with manual resource planning. The use of spreadsheets and manual report generation were cornerstones of their daily operations and integral to resource management. They were invested in three different Human Resource Management Systems for timesheet, project resourcing, and general HR information. In addition, the company used PPM system Planisware and Data Analytics system Spotfire in limited capacity for resource forecasting and analytics respectively.
Our customer approached i2e Consulting for a solution, which would enable them to use their resourcing data (across all their offices globally) for Resource Forecasting and cost estimation. In addition, they wanted modern dashboards and reports for better insights.
We ran an assessment survey of the company, its process, existing subscriptions and suggested our recommendations. The customer decided to go ahead with an Oracle RDS approach.
The project was broken down into: Resource Forecasting and Resource Analytics with the below end goals: