About Leading Science Organization
The organization helps customers accelerate life sciences research, solve complex analytical challenges, improve patient diagnostics, deliver medicines to market, and increase laboratory productivity.
Market research led to Micro Focus Project and Portfolio Management (PPM). PPM provides real-time visibility into financial performance, from cost forecasts to the capture of actual costs as work is performed. The Senior IT Project Manager comments: “Although PPM has many more capabilities, financial reporting and tracking was our most pressing requirement, and PPM worked very well for this. Soon, we had 2,500 PPM users, managing around 900 IT projects through the solution.”
To support the need for clearer reporting and improved consolidated visibility, the organization introduced integration between PPM and Microsoft PowerBI, to display PPM data by pulling data via secure VPN and stage it locally. Amazon Web Services (AWS) was leveraged for database hosting, to guarantee maximum performance and alerts. An incremental database refresh design proves much more effective than the traditional ‘truncate-reload’ method previously deployed. The data is available 24/7, instead of having to manage a daily 6-hour downtime.
Providing visibility into meaningful data has resulted in dynamic reports with real-time status on Project and Portfolio Management, resource management, and financial management. The Senior IT Project Manager explains: “We created custom reports with project health indicators, such as red, yellow, and green, based on project execution status. This is really helpful for our management reports, especially on our large, strategic projects which represent a high investment for the company. Our reports form the basis of our project status discussions with management.”
PPM also tracks project milestones, supports resource capacity forecasting, and provides full project financials. Many of the PMO teams are geographically distributed, and this solution supports team collaboration with consolidated project visibility. Different teams can filter and drill down into specific project sections.
The comprehensive PPM reporting has caught the attention of other PMOs, according to the Senior IT Project Manager: