All work
2023
Oracle Royalty Management Tool (ORMT)
Replaced macro-Excel and email templates with a self-service tool that auto-calculates royalties and submits straight to AR.
75%
reduction in manual processing time
4d → 1d
per royalty cycle
18K+
submissions to date (~20/day)
- Role
- Program Manager, Requirements & Change Management
- Timeline
- Rollout across partners and internal teams
- Stakeholders
- Royalty ops, Legal, Finance, AR, Partner Support
- Tools
- Oracle ApexOracle R12VisioSharePoint
01Context
Partner royalty submissions ran on a manual macro-Excel process: partners emailed templates, support pulled agreements, cross-validated line by line, and routed to AR. Slow, error-prone, and a compliance risk.
02Problem
Each submission took days of manual validation, and inconsistent handling made compliance hard to guarantee at scale.
03Approach
- 01Program-managed requirements, rollout, and change management end to end.
- 02Translated the operational pain points into defined requirements for automated validation against pre-loaded partner terms.
- 03Managed rollout to partners and internal teams, running change management so the tool was adopted rather than worked around.
- 04In parallel, drove the digitization of the Partner Store's Non-Standard Request Form.
04Build
- Self-service submission that auto-calculates royalties from partner-entered sales against pre-loaded terms and submits straight to AR.
- Automated validation requirements translated from real operational pain points.
- Digitized Non-Standard Request Form for the Partner Store.
05Impact
4d → 1d
cycle time (75% reduction)
18K+
submissions processed to date
Champion
multiple Quarterly Champion wins