Skip to content
Private / internalAmlak International Finance Company

Automated Credit Risk Analytics & Reporting

Engineered a full-stack financial risk analytics platform that processes loan portfolio data, supports configurable NPL and DPD analysis rules, and generates standardized quarterly risk reports. The application combines Next.js and Tailwind CSS for the user experience, ClickHouse for high-performance analytical queries, React Charts for data visualization, and Microsoft Entra ID for secure access. It replaces repetitive manual reporting workflows with an interactive, configurable, and automated reporting process.

internal · private network
Automated Credit Risk Analytics & Reporting screenshot
01

Overview

A full-stack credit-risk analytics platform that processes loan portfolio data and produces standardized quarterly risk reports. Analysts configure the rules for non-performing loan (NPL) and days-past-due (DPD) analysis themselves, and the application turns portfolio data into interactive charts and report-ready output.

It replaces a repetitive, manual reporting routine with a configurable, automated workflow.

02

The challenge

Quarterly risk reporting meant repeating the same manual steps every quarter: pulling portfolio data, applying NPL and DPD classifications and rebuilding the report. That made it slow to produce and hard to keep consistent.

03

What I built

ClickHouse runs the heavy analytical queries over the loan portfolio so large datasets can be sliced quickly. The Next.js and Tailwind CSS front end lets users adjust the NPL and DPD rules, explore the results through React chart visualizations and generate the standardized quarterly report. Microsoft Entra ID secures access.

04

Key features

  • Configurable NPL and DPD analysis rules
  • Standardized quarterly risk reports
  • Interactive charts of portfolio and delinquency trends
  • Fast analytical queries on ClickHouse
  • Secure sign-in with Microsoft Entra ID
05

Outcome

Quarterly risk reporting became an interactive, repeatable process instead of a manual one, with the same rules applied every time.