Technical Projects

Largest APEX application in portfolio. Clinical research lifecycle management with role-based access control, patient cohort management, and study tracking.

100+ volunteer coordination with DocuSeal digital signatures, NextCloud file provisioning, and OKE deployment with DBMS_SCHEDULER automation.

Youth program management with participant tracking, attendance monitoring, and automated reporting for program outcomes.

Multi-clinic performance benchmarking with KPI dashboards for board reporting, outcome tracking, and trend analysis.

Automated invoice extraction processing 135+ PDFs via n8n + Google Drive. Plaid API for bank sync with Canadian GST/HST/PST tax calculations.

Multi-tenancy cost visibility with real-time OCI Usage API integration, data verification framework, and monthly billing reconciliation.

Barcode generation and scanning with email templating engine and real-time Banner ERP integration.

Automated invoice generation from Zoho timesheets with client-specific rate card management and payment status tracking.

Per-domain delivery rate tracking with bounce/complaint monitoring and suppression list management via OCI Email Delivery APIs.

330+ automated security checks with a Flet cross-platform GUI. Generates HTML reports with remediation guidance. Compatible with Oracle 11g through 23ai.

A 7-page APEX application that proactively monitors TLS certificate expiration across hundreds of endpoints. Scans configured endpoints, tracks certificate chains, expiration dates, and issuer details with automated alerts before certificates expire.

Cross-platform monitoring tool generating styled HTML email reports. Covers performance metrics, tablespace usage, and session activity — no agent required.

Production-grade integration modules for SAP Concur (OAuth2), UKG (SFTP + REST), with retry logic and error handling.

AI-assisted PDF data extraction monitoring Google Drive folders. Processed 135+ invoices through Oracle staging tables with bind variables.

Led the migration of a legacy Drupal platform to modernized infrastructure on Oracle Cloud Infrastructure (OCI), leveraging Terraform for infrastructure-as-code provisioning and implementing a comprehensive disaster recovery strategy using OCI Full Stack DR.

Automated Let's Encrypt renewal with DNS-01 challenge via Route53, OCI Load Balancer auto-deployment, and zero-downtime certificate rotation.

10+ Claude Code skills for infrastructure visibility: Compute, VCN, DRG topology, storage, ADB, and OKE reports for on-demand inventory.

10-year engagement managing Oracle RAC + Data Guard HA for Banner ERP. Upgraded Banner 8 to 9 across all modules. Supported 20+ integrated systems.

IBM Maximo to Oracle Primavera P6 bi-directional integration with 26+ system integration points. Remediated 100,000+ malformed BLOB records at Canada's largest nuclear facility.