CUONE Data aggregation
CUONE is designed for storage, retrieval, and management of all financial and loan portfolio and performance data credit data for a credit union. CUMAN continuously uploads data from the credit union’s core system and loan systems including historical data going back 10 years. CUMAN One SourceTM eliminates the need for multiple data storage locations, files and spreadsheets. It also eliminates the hassle of multiple emails and spreadsheet versions. Most importantly all CUMAN users (including Management, Board Members and Examiners) have access to the same information that is continuously kept current.
DATA CENTRALIZATION -1
Where is my data? Is it current? Does everyone have in the CU, Board and NCUA Examiner have the same data
| Data/Information | Current Assumed State | Future State |
|---|---|---|
| Golden Source | General Ledger | Same |
| Investments/Bond Prices /Valuation | External Provider PDF Reports | Same |
| Loans – Individual Contract Level | General Ledger / Core System | GL mirrored in CUMAN |
| Deposits – Individual Contract Level | General Ledger / Core System | GL mirrored in CUMAN |
| Derivatives – Individual Contract Level | General Ledger / Other | GL mirrored in CUMAN |
| Other Balance Sheet Line Items | GL / MS Excel | GL mirrored in CUMAN |
| Budget Scenarios | MS Excel / External Provider PDF Reports | CUMAN |
| ALCO Minutes | MS Word | CUMAN |
| ALCO Data | Spreadsheet | CUMAN |
| CUMAN Package | MS Word / PDF | MS Word linked to CUMAN |
| CUMAN Policy Monitoring Report | MS Excel / MS Word / Other | CUMAN |
| Liquidity Coverage Ratios | MS Excel / Other | CUMAN |
DATA CENTRALIZATION -2
| Data/Information | Current State | Future State |
|---|---|---|
| Utilized Deposits | MS Excel / Other | CUMAN |
| Pledge Securities | MS Excel / Other | CUMAN |
| IRSA Shocks | MS Excel / Profit star | CUMAN Scenario Manager |
| EVE Shocks | MS Excel / Profit star | CUMAN Scenario Manager |
| Investment Total | MS Excel / Other | CUMAN |
| Capital Ratios | MS Excel / Other | CUMAN |
| Derivative Mark-to-market/reporting | MS Excel / Other | CUMAN |
| Yield Analysis | MS Excel / Other | CUMAN |
| Backtesting | MS Excel / Other | CUMAN |
| Goodwill Impairment | MS Excel / Other | CUMAN |
| Investment Reports | MS Excel/PDF/External Providers | CUMAN |
| Policy Exception Reporting | MS Excel/PDF/External Providers | CUMAN |
DATA CENTRALIZATION -3
| Data/Information | Current State | Future State |
|---|---|---|
| Investment Risk Monitoring Reports | MS Excel / PDF / External Providers | CUMAN |
| Capital Ratios | MS Excel / PDF / Business Analytics | CUMAN |
| Capital Projections | MS Excel | CUMAN Scenario Manager |
| Liquidity Reporting All fields | MS Excel | CUMAN Scenario Manager |
| Contingency Funding Plan | MS Excel / Word | CUMAN |
| Regulatory Stress Test | MS Excel / Word | CUMAN |
| Interest Rate Risk Reporting | MS E | CUMAN |
| Pricing Review All fields | Bank Coach | CUMAN Competitive Rates Monitor (GCRM) |
| ALCO Policy Review | MS Excel / Word | CUMAN |
| Board Reporting | MS Excel / Word | CUMAN |
| Competitor / Peer Analysis | Not currently used (S&P) | CUMAN – GPA Module |
| Investment Portfolio Risk Reports | External Providers | Can be integrated into CUMAN |
