Client : Confidential
Industry : Pharmaceutical
Duration : 4 Months
Unifying resourcing data across organization with Data warehousing.
Business Case
As companies are adopting one organization one data approach. A global pharma giant was facing difficulties with resource planning-thanks to siloed data sets. They were looking for solutions to consolidate resourcing data so they could better plan their projects. They had a Planisware subscription for resource planning.
The client requested the following features:
- Consolidate data from various global offices
- Dashboards for resource forecasting
- Automate analytics
- One of the major challenges faced during the project was the consolidation of the data
- Secondly, they needed the data reporting in Planisware
- Automating reports
- We created a staging database which consolidate all the data into one platform and helped unified reporting
- As they were existing Planisware user we built a Planisware Data Grabber tool which could pull data from Planisware.
- As for automating reports, we built custom dashboards to show all data at an organizational level and help with forecasting
- complete removal of manual processing and consolidation of data
- The visibility of data at organizational level helped decision makers and project planners
- Substantial reduction in Full time equivalent
- To top it all, the entire thing is mobile friendly
Connect to know more
Contact Information
-
93 Shennecossett Rd, Suite # 104, Groton, CT 06340
-
+1(866) 968-9995
-
www.i2econsulting.com