Steering committee presentation

Plant Variety IP & Royalty
Licensing Management Platform

Systems audit findings and recommended PostgreSQL migration.

Prepared by Anthony Apollis, Business & Systems Analyst

1 · The problem

The current system can't keep up

Royalty rates and payment status live in disconnected Access tables and spreadsheets.
Reconciliation is manual, re-run every cycle, with no audit trail when discrepancies occur.
Single-file Access architecture blocks concurrent multi-user access.
Quarantine and pathology results are not consistently linked back to the blocks they govern.

2 · Our approach

A structured systems & business analysis

01 · Process mappingWalked the full IP lifecycle end to end, lane by lane.

02 · Systems auditAssessed Access against what the business actually needs.

03 · Requirements9 business requirements, prioritised and traced.

04 · Target designNormalised PostgreSQL schema, phased migration plan.

3 · What we found

8 subject areas, 10 tables, no enforced integrity

8

Subject areas mapped

9

Business requirements

0

Enforced FK constraints today

The data itself is well understood by the business — it's the system that can't enforce or scale the rules the business already follows.

4 · Recommendation

Migrate to PostgreSQL, phased by risk

Phase 1 — Licensing & royalty (highest business risk)
Phase 2 — Block, pathology & quarantine
Phase 3 — Nursery orders
Enforced referential integrity across every subject area from day one of each phase.

5 · Next steps

Sign-off requested

Approve the Business Requirements Document (BRD-PIM-001).
Confirm Phase 1 scope and target cutover date.
Assign a data owner per subject area for UAT.

Full documentation: case study · ERD · BRD · traceability matrix · process flow

Note

Synthetic portfolio artifact

This presentation, and every document it links to, uses a fictional organisation and fabricated data, built independently to demonstrate business and systems analysis deliverables. It does not represent or reproduce any real employer's or client's information.