National Gallery of Art
Migration from Oracle EBS to Oracle Fusion Cloud Financials, the first federal adoption of Oracle Cloud Federal Financials, supporting both federal budgetary accounting and the museum’s private, not-for-profit reporting. Designed Oracle Integration Cloud (Gen3) interfaces with payroll (NFC), procurement (CWS), travel (GO.gov), SAM.gov, and PCard (Citi) systems; built the NFC payroll accounting flow through Autonomous Data Warehouse and Fusion Accounting Hub to the general ledger, with SF-52 coding validation and encrypted employee data; built GL, supplier, customer, and purchase order conversions with record-level reconciliation; delivered BI Publisher, OTBI, and Oracle APEX reporting for procure-to-pay and finance; and supports quarterly Oracle update testing and year-end close.
District of Columbia: District Integrated Financial System (DIFS)
Replacement of the legacy SOAR financial system with Oracle Fusion Cloud Financials. Built inbound and outbound OIC integrations, including high-volume EPM data flows; ran data conversions with a reconciliation strategy; set the instance, refresh, cloning, and patching strategy from CRP through go-live.
Marine Corps Community Services (MCCS), Quantico
Replacement of an outdated, unsupported ERP with Oracle Cloud ERP (Financials, Purchasing, Project Costing, Inventory, Order Management, and Planning & Budgeting), standardizing processes and data across Marine Corps installations and business units. On a program of 17 data conversions and 60+ integrations, built a reusable FBDI and SOAP web-service framework for third-party data, a line-of-accounting translator for the legacy chart of accounts, and an APEX application to monitor and manage interfaces; delivered OTBI and BI Publisher reporting and custom payment formats.
Department of Health and Human Services
with Deloitte Consulting
Upgrade of Oracle Federal Financials from 11.5.10 to R12.2.3. Implemented CARS and DATA Act reporting, Treasury PAM payment formats, TAS derivation for GTAS, the daily SAM vendor interface, IPAC and IAA processing, and the Concur travel interface.
U.S. Department of Energy (DOE) National Nuclear Security Administration (NNSA)
Migration from Oracle EBS to Oracle Fusion Cloud Financials. Designed Oracle Integration Cloud interfaces with procurement, travel, SAM.gov, and payroll systems; built GL, supplier, customer, and purchase order conversions with record-level reconciliation; delivered BI Publisher and OTBI reporting for procure-to-pay and finance.