Foreword |
|
v | |
About the Author |
|
vii | |
|
|
1 | (6) |
|
Chapter 2 Risk Typology and Data Implications |
|
|
7 | (8) |
|
|
10 | (2) |
|
|
12 | (1) |
|
|
13 | (2) |
|
Chapter 3 Risk Analytics Landscape |
|
|
15 | (32) |
|
3.1 Software and Solutions |
|
|
15 | (6) |
|
3.1.1 Request for Proposal (RFP) |
|
|
17 | (1) |
|
3.1.2 Terms of Reference (TOR) |
|
|
17 | (2) |
|
3.1.3 Proof of Concept (POC) |
|
|
19 | (1) |
|
3.1.4 System Integration Test (SIT) |
|
|
20 | (1) |
|
3.1.5 User Acceptance Test (UAT) |
|
|
21 | (1) |
|
3.2 Data Table and Data Type |
|
|
21 | (3) |
|
|
24 | (13) |
|
3.3.1 Business understanding |
|
|
26 | (2) |
|
|
28 | (2) |
|
|
30 | (1) |
|
|
31 | (2) |
|
|
33 | (4) |
|
|
37 | (1) |
|
|
37 | (4) |
|
3.4.1 Data quality and quantity |
|
|
37 | (1) |
|
3.4.2 External and internal data integration |
|
|
38 | (1) |
|
3.4.3 Security and access |
|
|
39 | (1) |
|
3.4.4 Analysis and decision-making |
|
|
40 | (1) |
|
|
41 | (3) |
|
|
44 | (1) |
|
|
45 | (2) |
|
|
47 | (10) |
|
4.1 ORACLEHOME and R_HOME |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
49 | (2) |
|
4.4 R Packages and RStudio |
|
|
51 | (2) |
|
4.5 Oracle R Enterprise (ORE) |
|
|
53 | (4) |
|
|
57 | (12) |
|
|
57 | (2) |
|
|
59 | (2) |
|
|
61 | (2) |
|
|
63 | (1) |
|
|
64 | (1) |
|
|
65 | (1) |
|
5.7 Treatments for Problematic Data Values |
|
|
66 | (3) |
|
Chapter 6 Data Warehousing |
|
|
69 | (10) |
|
|
69 | (3) |
|
|
70 | (1) |
|
|
70 | (1) |
|
|
71 | (1) |
|
|
71 | (1) |
|
6.2 Enterprise Data Warehouse vs Specialized Data Mart |
|
|
72 | (2) |
|
|
72 | (1) |
|
6.2.2 Access and security |
|
|
73 | (1) |
|
|
73 | (1) |
|
|
73 | (1) |
|
6.3 Extraction, Transfer, Load (ETL) |
|
|
74 | (5) |
|
|
74 | (2) |
|
|
76 | (1) |
|
|
77 | (1) |
|
|
78 | (1) |
|
Chapter 7 Analytical Data Sphere |
|
|
79 | (12) |
|
7.1 Archive, Not Overwrite |
|
|
81 | (1) |
|
7.2 Dropdown List, Not Free Text |
|
|
82 | (1) |
|
7.3 Meaningful Categories |
|
|
83 | (1) |
|
7.4 Optimal Number of Categories |
|
|
84 | (1) |
|
7.5 Expandable Data Tables |
|
|
85 | (1) |
|
|
86 | (1) |
|
7.7 Useful and New Primary Keys |
|
|
86 | (1) |
|
|
87 | (2) |
|
|
89 | (2) |
|
Chapter 8 Risks in Financial Institutions |
|
|
91 | (8) |
|
8.1 Profiling What Is Ahead |
|
|
92 | (3) |
|
8.2 External Warning Indicators |
|
|
95 | (1) |
|
|
96 | (1) |
|
8.4 Portfolio Composition |
|
|
97 | (2) |
|
Chapter 9 Common Risk Models and Analytics |
|
|
99 | (20) |
|
9.1 Expected and Unexpected Losses |
|
|
99 | (2) |
|
|
101 | (7) |
|
9.3 Securities Portfolio Optimization |
|
|
108 | (1) |
|
|
108 | (3) |
|
|
111 | (1) |
|
9.6 Operational Loss Distribution |
|
|
112 | (1) |
|
|
113 | (1) |
|
|
114 | (5) |
|
Chapter 10 Internal Rating System |
|
|
119 | (32) |
|
|
121 | (1) |
|
|
122 | (5) |
|
10.3 Predictors and Target |
|
|
127 | (2) |
|
10.4 Weight of Evidence (WoE) |
|
|
129 | (3) |
|
|
132 | (3) |
|
|
135 | (7) |
|
|
142 | (9) |
|
|
151 | (10) |
|
11.1 Default and Reageing |
|
|
157 | (2) |
|
11.2 Enterprise Data Warehouse or Data Mart |
|
|
159 | (2) |
|
Chapter 12 Through The Cycle (TTC) Updating |
|
|
161 | (8) |
|
Chapter 13 Desktop Analytics |
|
|
169 | (30) |
|
13.1 Basic Excel R Toolkit (BERT) |
|
|
169 | (1) |
|
13.2 Probabilities and PD |
|
|
170 | (5) |
|
13.2.1 Cumulative and marginal probabilities |
|
|
171 | (1) |
|
13.2.2 Joint, conditional and unconditional probabilities |
|
|
172 | (1) |
|
|
173 | (2) |
|
13.3 Loss Given Default (LGD) |
|
|
175 | (2) |
|
13.4 Credit Valuation Adjustment (CVA), Debit Valuation Adjustment (DVA) and xVA |
|
|
177 | (8) |
|
13.4.1 Spot, forward and par rates |
|
|
180 | (1) |
|
13.4.2 Interest rate binomial lattice |
|
|
181 | (2) |
|
13.4.3 Counterparty default |
|
|
183 | (2) |
|
|
185 | (14) |
|
|
199 | (4) |
|
|
199 | (1) |
|
|
200 | (1) |
|
|
201 | (2) |
Annex A Meeting of Minds Questionnaire |
|
203 | (8) |
Annex B |
|
211 | (12) |
Index |
|
223 | |