⬡
NAIROBI FUND RISK SYSTEMS Secure Analyst Access Portal · v4.2.1
nfrs-init.sh — analyst@workstation-04
Analyst Briefing — Confidential
You are a Junior Credit Risk Analyst
at Nairobi Fund.
Nairobi Fund is a mid-tier microfinance institution operating across 10 branches in Kenya. Your team uses SQL daily to monitor loan performance, flag delinquency risks, and generate management reports. You have been granted read access to both the operational database (OLTP) and the analytics warehouse (DW). Your manager has queued a series of tasks requiring data investigation. Work through them systematically.
🏦
Your Environment
Two connected databases — live transactional records (OLTP) and aggregated analytics tables (DW). Both are preloaded with branch, customer, loan, and repayment data.
🔎
Your Tools
A SQL editor with live query execution, instant results, schema reference, and a progress tracker. Each task comes with a validation check — output must match expected results.
📋
What Analysts Do Here
Filter and aggregate loan portfolios, compute repayment rates, identify high-risk customer segments, and trace branch-level performance over time.
📈
Why This Matters
Credit risk decisions move money. Every query you write informs whether a branch gets flagged for review, whether a customer is escalated, or whether a product is restructured.
Mission Objectives
01 Analyze branch lending performance across regions OLTP + DW
02 Investigate overdue and partial repayments OLTP
03 Identify high-risk customer segments by product and geography OLTP
04 Produce aggregate loan volume and approval-rate insights DW
05 Compile findings as data management will review your work REPORT
SYS.AUTH · CLEARANCE GRANTED · SESSION ACTIVE