Context
A bank needed Oracle Financial Services Analytical Applications (OFSAA) deployed for two regulatory workloads: Asset & Liability Management and Basel III Capital Adequacy Ratio reporting. These are the numbers a regulator reads, which means "roughly right" is not a category that exists. I ran the roughly $100K implementation end-to-end as the primary client liaison.
The problem
Two problems, really. The first was the deployment itself: OFSAA modules only produce correct regulatory output if the data feeding them is complete, reconciled, and on time. The second was inherited: the bank's existing Loans and Lines pipeline took 24 hours to run. When your inputs take a full day to land, every downstream regulatory calculation starts life a day late.
What I built
- Deployed and configured the OFSAA ALM and Basel III CAR modules, with custom reporting tailored to how the bank's risk team actually consumed the outputs.
- Designed and automated the ETL workflows feeding them — extracting from Oracle 11g, Oracle 12c, and flat files into staging, replacing manual processing.
- Wrote custom SQL and PL/SQL functions for requirements the packaged product didn't cover, keeping the data handling precise instead of approximated.
- Redesigned the Loans and Lines pipeline and tuned the high-volume SQL underneath it, taking execution time from 24 hours to 10 minutes.
What made it hard
Regulatory data work punishes optimism. Every shortcut in an ETL job eventually surfaces as a number a risk officer can't explain. The 24-hour pipeline wasn't slow because of one bad query — it was slow because of years of accumulated assumptions, so the fix meant re-deriving what the pipeline was actually supposed to compute and rebuilding from that, not patching the symptoms. This project is also where I learned to treat the business question — what is this number for, who acts on it — as the first engineering requirement, a habit that has outlasted every tool in my stack.
Outcome
Both modules live in production, custom reporting in the hands of the risk team, and a core pipeline running 144x faster. The engagement also generated roughly 10% additional revenue within three months through follow-on consulting — the quiet metric that says the client trusted the work.