A leading mobile operator in Thailand
Millions of call records a day, collected, validated and reported unattended.
Daily reporting runs unattended, and new data formats go live without code changes or downtime.
Context
A leading mobile operator in Thailand generates call-detail and billing files on dozens of servers nationwide and must deliver reconciled reports to downstream units daily.
Challenge
Formats change often; staff were pulling files by hand; any gap meant a missed report.
What we built
- A four-stage pipeline. Collect: files pulled over SFTP per region and site, with duplicate and partial-transfer detection
- Transform: column validation with error rows quarantined rather than dropped
- Execute: configurable stored-procedure chains run on the GaussDB warehouse
- Generate: report files produced from user-defined templates
- File layouts, procedure chains, templates, alarm rules and site topology configured from the web UI or imported from Excel
- Alarms by type, severity, expected arrival and SLA
- Priority-based Active/Standby/DR failover with heartbeat election, report replication and catch-up jobs
Outcome
Daily reporting runs unattended; new data formats go live without code or downtime; full audit and role-based access.
Architecture
Tell us what your business needs.
Speak directly with our solution architects and get a practical architecture, estimate and delivery plan.