Multi-Database Financial CRM
Designed and developed a secure enterprise CRM that consolidates customer, loan, credit, payment, and servicing information from SIMAH into a single platform. The solution integrates PostgreSQL, ClickHouse, and MySQL, provides role-based workspaces, supports collections task assignment, and enables authorized teams to access relevant customer and portfolio insights. Built with Next.js and Microsoft Entra ID authentication, with data validation and integrity controls applied across the platform.

Overview
A secure, internal CRM for a finance company that brings customer, loan, credit, payment and servicing information together in one place. Data that used to live in separate systems, including credit information from SIMAH (the Saudi Credit Bureau), is consolidated so authorized teams can see a customer and their portfolio from a single screen.
I designed and developed the platform: the integration across PostgreSQL, ClickHouse and MySQL, the role-based workspaces and the Next.js front end, secured with Microsoft Entra ID single sign-on.
The challenge
Customer, loan, credit and payment information lived in different databases, alongside credit data from SIMAH. Getting the full picture of one customer meant moving between systems, while access to sensitive financial data had to stay tightly controlled.
What I built
A Next.js and Tailwind CSS application that combines PostgreSQL, ClickHouse and MySQL into one consistent customer view, with ClickHouse powering the heavy analytical queries over loan and payment history. Role-based workspaces show each team only what it is authorized to see, Microsoft Entra ID handles sign-in so access follows the company's identity policies, and validation and integrity checks keep the consolidated data trustworthy.
Key features
- Single customer view across customer, loan, credit, payment and servicing data
- SIMAH credit information alongside internal records
- Role-based workspaces for each team
- Collections task assignment
- Customer and portfolio insights for authorized users
- Microsoft Entra ID single sign-on
- Data validation and integrity controls across the platform
Outcome
One secure workspace replaces lookups across several systems, with access governed by the company's own identity platform.