Risk & Revenue Management
Functional Goal
Analysis and Reporting System for the customer risk and profitability control and governance, depending on the custody type, the remaining life of the return and guarantees securing operations.
Technological Environment
- DBServer: OS/390 – DBMS DB2 MVS 6Design & Wireframing
- Application Server: 6 server in cluster HP-UX 11.0 – Web Logic 6.1 sp4
- Web Server: 6 server in cluster HP-UX 11.1 – IPlanet 4.1
- Application Server ReportWriter: 6 server Windows 2000
- Web Server ReportWriter: 6 server in cluster Windows 2000 – IIS 5.0
- Data Dictionary Server: HP-UX 11.1 – DBMS Oracle 8.1.7
Statistics
- more 'than 10,000 users entitled to use the D&I system
- 300 "dimensions", 168 of them with hierarchical domain
- 250 "measures"
- 15 time periods in line
- Approximately 23,000,000 records / month
- 9 Subject Areas (Reports, Customers, Trust, Guarantees, Customer Profitability Product, Portfolio, Central Risk, Country Risk, High Risks) divided into more than 500 tables
Project elapsed:
The first project has taken about 7 months, but since then it is evolving.