REQUIREMENTS TRACEABILITY MATRIX (RTM)
Project: FinTech Fraud Detection & Risk Analytics
|
Version |
Author |
Date |
Status |
|
1.0 |
Priyanka Chaudhari |
2024-Q1 |
Approved |
The RTM maps each Business Objective from the BRD to its Functional Requirements, corresponding SQL/Excel/Dashboard deliverables, test cases, and completion status. This ensures 100% requirement coverage and provides full audit traceability.
TRACEABILITY MATRIX
|
BRD Ref |
Business Objective |
FRD Ref |
Functional Requirement |
Deliverable |
Test Case |
Status |
|
BO-01 |
Identify fraud exposure by merchant, category, geography, time |
FR-SQL-02 FR-SQL-03 FR-SQL-04 |
Category analysis query Time-of-day query State risk ranking |
fraud_analysis.sql (Queries 2,3,4) |
TC-01: Verify category fraud rates sum to total |
Complete |
|
BO-01 |
Identify fraud exposure by merchant, category, geography, time |
FR-XL-02 |
Excel: Fraud by Category tab with bar chart |
Fraud_Risk_Analytics.xlsx Tab: Fraud by Category |
TC-02: Chart renders with correct category labels |
Complete |
|
BO-02 |
Produce merchant risk scorecard |
FR-SQL-09 |
CREATE VIEW v_merchant_risk_scorecard HIGH/MEDIUM/LOW classification |
fraud_analysis.sql (View definition) |
TC-03: All merchants classified; no NULL risk tiers |
Complete |
|
BO-03 |
Deliver monthly trend visibility |
FR-SQL-07 FR-XL-04 |
Monthly trend query Excel: Monthly Trend tab with chart |
fraud_analysis.sql (Q7) Fraud_Risk_Analytics.xlsx Tab: Monthly Trend |
TC-04: 12 months returned; no missing months |
Complete |
|
BO-04 |
Profile high-risk customers for CDD |
FR-SQL-06 |
Top 10 customers by fraud exposure query |
fraud_analysis.sql (Query 6) |
TC-05: Top 10 by exposure; verify amounts match is_fraud=1 filter |
Complete |
|
BO-05 |
Provide rule recommendations |
FR-PBI-01 FR-PBI-02 FR-PBI-03 |
3-page Power BI dashboard Rule recommendations in README |
Power BI .pbix file Project README.md |
TC-06: Dashboard slicers cross-filter all visuals correctly |
Complete |
|
BO-05 |
Provide rule recommendations |
NFR-05 NFR-06 |
Full BA documentation suite |
BRD, FRD, RTM, User Stories .docx files |
TC-07: All docs present in /docs folder; no broken references |
Complete |
TEST CASES SUMMARY
|
Test ID |
Test Description |
Expected Result |
Actual Result |
Pass/Fail |
|
TC-01 |
Category fraud rates aggregate correctly |
Sum of category fraud txns = total fraud count |
Verified via SQL SUM |
Pass |
|
TC-02 |
Excel category chart renders |
Bar chart shows all 7 categories with correct rates |
Chart renders correctly |
Pass |
|
TC-03 |
Merchant scorecard has no NULL risk tiers |
All merchants classified HIGH/MEDIUM/LOW |
No NULLs found |
Pass |
|
TC-04 |
Monthly trend covers full 12 months |
12 distinct months in output |
12 months confirmed |
Pass |
|
TC-05 |
Customer profiling filters to fraud only |
Only is_fraud=1 records in top-10 output |
Filter verified |
Pass |
|
TC-06 |
Dashboard slicers cross-filter |
Selecting a category filters all 3 pages |
Cross-filter confirmed |
Pass |
|
TC-07 |
All BA docs present in /docs |
BRD, FRD, RTM, User Stories all present |
All 4 docs present |
Pass |