How Medicines Patent Pool Digitised Manual Processes into a Centralised Data Portal

Ajackus replaced MPP’s fragmented offline workflows—manual data entry, offline meeting records, and disconnected document storage—with a centralised data portal featuring reporting dashboards, compliance tools, and an interactive global map.

Services

Web Development

Data Analytics

Technologies

Airtable | Ajackus.com
technologies django-logo
case-studies postgresql-image | Ajackus.com
MPP | Ajackus.com
website

3

Reporting Dashboards

Centralised

Meeting Minutes & Documents

Interactive

Global Coverage Map

Overview

Executive Summary
Client Overview
The Challenge
Project Goals
Our Approach
Results and Impact
Frequently Asked Questions

Executive Summary

The Problem

Medicines Patent Pool (MPP), a UN-supported public health organisation, relied on manual data entry for partner information, maintained meeting minutes offline, and stored partner invoices and tax documents in disconnected systems—making it difficult to track records, retrieve documents, or maintain compliance at scale.

The Solution

Ajackus built a centralised data portal with three reporting dashboards (PDT, filing, sales), a minutes-of-meeting system, a partner document management portal with admin access, compliance template tools, partner and product list management, and an interactive map integrated into MPP’s public website.

The Result

MPP transformed fragmented, offline manual processes into a single digital platform. Partner data, meeting records, invoices, and compliance documents are now centralised and searchable, and the interactive map provides public visibility into MPP’s global product coverage.

Client Overview

Medicines Patent Pool is a United Nations-supported public health organisation that collaborates with governments, pharmaceutical companies, and patient groups to license essential medicines and promote affordable generic production in low and middle-income countries.

Industry Healthcare / Public Health
Organisation Type UN-supported
Mission Accessible medicines for low/middle-income countries
Key Deliverable Centralised data portal with reporting and document management
Website medicinespatentpool.org

The Challenge

THE BOTTOM LINE

MPP needed to replace offline, manual processes for partner data, meeting records, and document management with a centralised digital portal—enabling efficient tracking, retrieval, and compliance at organisational scale.

MPP’s operations relied on a patchwork of manual data entry, offline document storage, and fragmented communication—creating inefficiencies that were increasingly untenable as the organisation scaled its global medicine access programmes.

Core Pain Points

  • Manual data entry: Key details about partners and active products were captured manually, creating inefficiencies and potential errors across the organisation.
  • Offline meeting records: Minutes of meetings were maintained offline, making it difficult to track and access past records—especially when team members needed to locate specific documents.
  • Disconnected document management: Partner invoices and tax documents were stored offline, complicating retrieval and creating compliance risks.
  • No centralised system: Without a unified platform, team members navigated multiple offline sources to find information, slowing operations and decision-making.

Project Goals

The project aimed to replace MPP’s entire offline workflow with a centralised digital portal that could manage partner data, meeting records, documents, compliance, and public-facing reporting in one platform.

Goal Success Criteria
Digitise manual data entry Centralised partner and product information management
Centralise meeting records Quarterly MOM uploads in a single, searchable portal
Streamline document management Partner portal for invoices and tax docs with admin access
Enable compliance templates Users can create and manage templates as needed
Build reporting dashboards PDT, filing, and sales reports accessible from the portal
Public-facing interactive map Product coverage map integrated into MPP’s main website

Our Approach

Ajackus built a comprehensive data portal that replaced MPP’s entire offline workflow—not just individual spreadsheets—with an integrated digital platform.

Dashboard and Reporting

The team built three specific report sections within the portal: PDT report, filing report, and sales report. Each provides detailed information about partners and products, including product details, country, quarter, medicine sales, and purchaser data.

Minutes of Meeting Integration

A centralised system was built for capturing all meeting minutes in one portal. MPP can now upload quarterly MOMs and maintain them in a single, searchable location—eliminating the need to sift through multiple offline records.

Partner Portal for Document Management

The team developed a secure partner portal where MPP can upload and manage partner invoices and tax documents, with admin access controls for secure and efficient document retrieval.

Compliance and List Management

Compliance template creation was built in, allowing users to add new templates as needed for organisational consistency. Partner and product list sections provide comprehensive details including names, categories, and product classifications.

Interactive Global Map

An interactive map was integrated into MPP’s main public website, allowing visitors to view product details including the countries where MPP’s licensed medicines are available—providing public transparency into the organisation’s global impact.

Results and Impact

MPP transformed its entire offline workflow into a single digital platform, centralising data management, reporting, compliance, and public transparency.

3

Integrated Reporting Dashboards

Centralised

Meeting Minutes & Documents

Interactive

Public Global Coverage Map

What Was Delivered

  • All manual data entry processes digitised into a centralised, searchable portal.
  • Three reporting dashboards (PDT, filing, sales) providing on-demand insights into partner and product data.
  • Meeting minutes centralised with quarterly upload and search capabilities.
  • Partner document management portal with secure admin access replacing fragmented offline storage.
  • Compliance template system ensuring organisational consistency across all processes.
  • Interactive map on MPP’s public website providing global transparency into licensed medicine coverage.

Why It Worked

Portal Replaces Process

Building a unified portal that replaced the entire offline workflow—not just individual spreadsheets—eliminated fragmentation at the root.

Public Transparency Built In

The interactive map was designed for MPP’s public website, giving the world direct visibility into the organisation’s global impact.

Compliance by Design

Template creation and admin-controlled document access ensured compliance was a core feature, not an afterthought.

Frequently Asked Questions

What is the MPP Data Portal?

It’s a centralised digital platform built by Ajackus that replaces MPP’s offline manual processes. It includes partner and product management, meeting minutes tracking, invoice and tax document storage, compliance templates, three reporting dashboards, and an interactive global product map.

How does the interactive map on MPP’s website work?

The map is integrated directly into MPP’s main public website, allowing visitors to view an interactive display of product details including the countries where MPP’s licensed medicines are available—providing public transparency into the organisation’s global reach.

We're Ajackus
We combine design, engineering, and speed to deliver beautifully crafted, scalable products.