Case study 01 · Telecom · Payments & identity
Payment gateways & KYC at Jawwal
Bills, top-ups and government identity checks for 150,000+ subscribers.
The problem
Subscribers needed to pay bills and top up through local payment gateways, and new subscribers had to be verified in real time against Ministry of Interior records (KYC) during onboarding.
My role
I integrated the eSadad and Reflect payment gateways and Ministry of Interior identity verification into .NET Core services on Oracle, and kept the surrounding services healthy in production.
Architecture
My scopeDecisions, explained belowKey decisions
Never fail a payment blindly. On a gateway timeout the transaction stays pending in Oracle until a status check or the gateway's callback confirms the final result — then reconciliation closes the loop.
Tune from the execution plan. Stored procedures and views on the hot paths were optimised from their execution plans, not by guesswork.
One reference per payment. Every payment carries a unique transaction reference, so a retry or a duplicate callback can never charge a subscriber twice.
Verify identity in real time. The Ministry of Interior KYC check is called live during subscriber onboarding and activation, not in a later batch.
See problems before subscribers do. Production monitored with Prometheus and Grafana dashboards across services and databases.
Result
- subscribers served
- 150,000+
- responses on tuned SQL paths
- ~10% faster
- of payment transactions handled every day
- Thousands