Oracle APEX Process Automation App

I need an Oracle APEX database application that automates the way we track and manage how employees roll out key business strategies. The focus is on two streams—customer- and supplier-facing initiatives, plus internal operations-improvement programs—and I want a single, easy-to-use workspace where team members can identify opportunities, monitor, and report on progress.

Core scope
• Design a clean data model in Oracle Database to store strategies, milestones, action items, ownership, and timeline data.
• Build the APEX UI: tabbed pages or cards where users can create a strategy, break it into tasks, assign owners, update status, and upload supporting documents.
• Set up role-based access so executives, managers, and employees each see the right level of detail.
• Add real-time dashboards in APEX with interactive charts and KPIs showing completion rates, on-time delivery, and impact metrics.
• Include email or in-app notifications when deadlines slip or tasks are reassigned.

Acceptance criteria
• Fully functional prototype running in my existing Oracle Cloud (or on-prem) APEX workspace.
• PL/SQL packages, triggers, and validations are commented and follow best practices.
• A short hand-off guide explaining schema objects, page numbers, and how to extend the app.

This is a medium-sized engagement: I expect an iterative approach—first a clickable prototype, then refinements based on feedback. I am a perfectionist, and I expect you to work quickly, efficiently, and collaboratively with me at a very high standard. Superior fluency in English is a must. Ideally someone in Vancouver, Canada, or very close to the PT timezone is preferred. If you have Oracle APEX expertise and can translate business rules into a crisp, maintainable application, let’s get started.