work
DevOps Team Lead @ StarHub
Oct 2017 – May 2019
SingaporeETLIBM CognosSQL ServerData WarehouseVaricent
Enterprise Data Operations in Singapore
StarHub is a Tier-1 telecommunications provider in Singapore, offering mobile, broadband, and enterprise solutions to millions of subscribers. Led the team managing the VARICENT financial management system (built on IBM Cognos BI) for calculating and disbursing sales commissions across StarHub's entire dealer and agent network.
Key Achievements
- ▹Engineered complex ETL pipelines for telecom commission calculations — millions of records monthly with strict 4-hour batch SLA
- ▹Partnered with IBM Canada to migrate Cognos 8 → Cognos 10 (major version with breaking changes)
- ▹Migrated Varicent application from on-premise to Varicent Cloud
- ▹Coordinated UAT with 50+ stakeholders from finance and operations
- ▹Zero data loss during migration — maintained commission accuracy to the cent
- ▹Led squad of 5 engineers: daily standups, sprint planning, code reviews
- ▹Introduced automated regression testing — reduced manual QA by 60%
- ▹Created comprehensive runbooks and disaster recovery procedures
bash
$ cat /starhub/stack.conf
language: C#
database: SQL Server
etl: SSIS (SQL Server Integration Services)
bi_platform: IBM Cognos BI
application: Varicent (Commission Management)
data_warehouse: Custom DW schema
team_size: 5 engineers
location: Singapore
batch_sla: 4 hours
records: millions/month