First Citizens Bank · Enterprise Cards · Sep 2025 – Oct 2026
PRA Mart (Payment & Risk Analytics)
- ~117,000 clients
- ~300 attributes traced
- 2 banks → 1 mart
After the merger, Silicon Valley Bank and First Citizens data sat on separate platforms. SVB already had a mart for portfolio monitoring; First Citizens didn't. Its business owners ran long, complex queries through layers no one could trace to get delinquencies, charge-offs, card counts, deposits, loans and financials.
From untraceable queries to one trusted mart
Select a step to see my role
Step 1 of 5 · My role
Business owners pieced together portfolio data from long queries over layers whose sources no one could trace.
Impact for the bank
- First Citizens now has the portfolio-monitoring mart SVB already had, and both banks' data sits in one place covering ~117,000 First Citizens small business clients.
- Long, untraceable queries replaced by governed views where every one of ~300 attributes traces to its source.
- Risk teams monitor delinquency and charge-offs from one view, and spend trends help marketing target card offers.
- Delivered in ~10 months, followed by 1 month of hypercare.
Read the full details
- Traced the lineage of ~300 attributes the business relied on, back to their true sources.
- Rebuilt the business logic on the bank's new unified data source.
- Designed normalized views at company, customer, company-branch and company-associate level, then rolled them up into aggregated company card metrics (delinquency, charge-offs, open card counts, spend trends) and client financials (loans, deposits, EBITDA, net profit, current ratio).
- Ran a gap analysis against SVB's existing PRA Mart so both banks' data could be consolidated in one place.
