Scientific Data Management System

We care

A global pharmaceutical company aimed at digitizing the outputs of its laboratory scientific measurements. Prior to the project, the measurements were recorded on paper and disparate instrument-specific systems, which brought human error, inefficiency and increased consumption of resources. The challenge of the large digitalization project was to implement a common solution used in laboratory sites around the world, get local teams engaged in the change process and coordinate with other digitalization projects that run at the same time.

We act

Our expert had a double-role as IT project lead and Scrum Master. As the IT project lead, we planned the IT resources and required budget, managed the project stakeholders including internal IT teams, business and external IT vendors. As part of the Scrum Master role, we ensured the development team has the best conditions to work in Agile methodology and enabled project members to work better together.

We deliver

The project achieved the digitization of scientific laboratory work in 6 sites across 3 countries in Europe. The project is ongoing, and additional 14 sites are planned to be digitized until 2027.

Dashboard Analytics and Reporting Tool

We care

The sustainability and quality department of a global pharmaceutical company sought to improve its analytics and reporting capabilities by creating visual and easily understandable reports in Qlik. To achieve this, it was necessary to onboard interested stakeholders, ensure the data transfer between different databases and develop tailored visual reports.

We act

As IT project leader, we were responsible for budgeting, creation of project plan and reporting. We also took care of the coordination between different stakeholders in the project - including internal database team, external developers and the internal clients for whom the dashboards are being developed.

We deliver

The project is ongoing and so far 8 dashboards have been created and are in use by internal clients. Examples of reports created include security audits, environmental safety and learning.

Global Value Chain Reporting Solution

We care

A pharmaceutical company sought to improve enterprise steering and the decision making process by achieving greater transparency on margins per product and enable controllers to leverage trade margin data as a key operating principle to drive profitable growth. The challenge of the project was to establish a solution that automates data collection from different ERP systems, and value chain generation and validation.

We act

Our expert served as IT Project Leader during the feasibility study and subsequent solution implementation project. We were responsible for project preparation & project planning, as well as budget management and steers of external suppliers & IT departments working for the project. We supported the Product Owner in scope management and acted as first escalation instance on IT related topics. We worked in closely and ensured alignment with purchasing, IT boards, and other projects / initiatives.

We deliver

The company now has in place an on-premise SAP plug-in solution that allows data extraction from viarious SAP systems, and detailed calculation of global product cost along the global production and supply chain with millions of data points.

eQA Management Suite – Automated system management processes in ServiceNow

We care​

​At a customer in a regulated industry, system management for electronic Quality Assurance systems is handled in disparate, manual processes and systems​

• Checks of executed mandatory user trainings and access authorization, e.g. by line managers, are not integrated​

• Master data management (request, approval and fulfilment) in electronic QA systems is cumbersome and error-prone, and bears documentation risks​

We act​

• Design and implement an integrated web-based workflow tool facilitating management of all relevant operational activities for multiple eQA systems​

• ServiceNow for ticket generation and information exchange​​

We deliver​

• Create an accessible single point for end users to raise requests for multiple systems and follow their ​implementation

• Streamline process for compliance checks and approvals, and IT service delivery with fewer errors​

• Leverage existing workflow tools available at the customer leading to cost savings​