Projects

Match every procurement-card charge to a purchase order, then settle it into Fusion

A rebuild of an Oracle procurement-card reconciliation application as a modern web app. It takes a monthly card statement, matches each charge to the purchase order behind it, lets cardholders clear anything the system could not match on its own, and then stages a single AP invoice and the supporting journal entries for Oracle Fusion. A manager sees every cardholder on a statement; a cardholder sees only their own charges. The auto-match engine follows the same priority rules as the original Oracle package — an exact purchase-order hit first, then a supplier-and-amount match, then a best-effort guess it will refuse to make when it is not sure.

Next.js · TypeScript · Prisma · Neon Postgres · Vercel

See who is billable, who is on the bench, and where every project stands

A capacity-planning and project-health application for a consulting practice. It brings resource allocation, timesheet actuals, project financials, and utilization reporting into one place, and layers a live Jira feed on top for project-health dashboards. What each person sees is driven by their role — a standard consultant sees only their own workspace, while practice leads and project managers get the analytics and administration screens.

Oracle APEX · PL/SQL · Oracle Autonomous Database · Chart.js · Jira REST

Turn a requirements document into JIRA-ready use cases and test cases

An AI-assisted delivery accelerator for Oracle Fusion teams. Upload a client's requirements document and Relay extracts each numbered requirement, matches it to the closest reusable use case with a confidence score, then maps accepted use cases to test cases — every link traceable back to the original requirement. When the mapping looks right, it exports the whole set as a JIRA All-In-One CSV, ready to import as stories, tests, and steps. Matches come from a shared bank of Oracle use and test cases built from real delivery work, and you can draft new cases with AI when nothing fits.

Next.js · TypeScript · Prisma · Neon Postgres · Gemini embeddings

Ad-hoc SQL on Oracle Fusion, with an AI that writes the query

A web tool that runs ad-hoc SQL against Oracle Fusion through BI Publisher. Type SQL directly, or ask in plain English and an AI assistant generates the query, runs it, and feeds any Oracle error back to itself to self-correct. Includes a browsable catalog of Fusion tables, email-verified access, and per-user query history.

React · Vercel · BI Publisher SOAP · multi-provider AI

Give an AI agent safe, direct access to Oracle Fusion reporting

An MCP (Model Context Protocol) server that exposes Oracle Fusion BI Publisher operations — run reports and data models, and deploy new ones — as tools an AI agent can call. It talks to Fusion's BI Publisher SOAP service directly, with usage metering and clear error handling. Clone the repo and point your own agent at your own Fusion instance.

Python · Model Context Protocol · BI Publisher SOAP

Pick a film the whole household will actually enjoy

A movie-night recommender for families. Everyone rates films and sets their genre and actor preferences; pick who is watching and it recommends titles the group will enjoy, filtered by the youngest viewer's rating. Movie data comes from OMDB and TMDB.

React · FastAPI · Postgres · Vercel