Telecom Thailand
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

Source servers dozens · nationwide SFTP Collect per region · per site duplicates · partials Transform column validation quarantined rows GaussDB data warehouse Execute stored-procedure chains, configurable Generate report files from user templates Downstream report consumers daily Alarms & SLA by type · severity · expected arrival · SLA Active / Standby / DR priority failover · heartbeat election report replication · catch-up jobs Layouts, procedure chains, templates, alarm rules and site topology configured in the web UI or imported from Excel

Tell us what your business needs.

Speak directly with our solution architects and get a practical architecture, estimate and delivery plan.

Talk to an architect