Project Description
To protect illegal VoIP call, Bangladesh Govt. decided to carry international telephone calls using legal channel. Based on this decision, BTRC(Bangladesh Telecommunication Regulatory Commission) – A Bangladesh Govt’s authorized Telecom Regulatory Board issued IGW (International Gateway), ICX (Interconnection Exchange) license to Bangladeshi companies. UIL is such an IGW company that carries VoIP call.
iBILL Solution is an integrated Customer Care and Billing solution that supports billing for multiple services necessary in today’s convergent telecommunications, IP voice telephony and Internet service provider environments. The product’s powerful rating and billing functionality, coupled with a range of modules that address the areas of Customer Care, Accounting, Agent/Distributor Management, Reporting and Web interface for access over the Internet, makes it a complete back-office system for a service provider.
Features:
- An end-to-end, fully integrated interconnect billing solution – from switch to bill
- Rates and bills all products incl. Voice, SMS, MMS, and content with ease.
- Multiple rating of the same CDR for Revenue Share and regulatory purposes
- Rating flexibility that can be based on duration, event and data usage scenarios
- Flexible set up that can be based on Trunk range identification
- Highly-intuitive, powerful, real-time reporting tools – fully integrated
- Full Invoice production functionality
- CDR Mediation, Rating Engine Development, CDR auto FTP to IOF server for billing reconciliation
- Fully web-based via an easy to use GUI
- Rapid rating and re-rating performance
- Unique autoloader for easy management of Carrier rates and codes
- Real-time credit management tools – fully integrated
- Flexible interfacing abilities
Project Information
Designation & Role: Project Manager/Business Analyst/Developer
Client / Industry: Unique Infoway Limited (UIL), Dhaka, Bangladesh – An IGW Company
Duration: July 2012 – June 2014
Budget: USD 1.5M | Team Members: 7 (Software Engineers)| Method: Agile/Scrum
Tools Used: Primavera P6 (Project Management), JIRA (Task Management), PHP, HTML, CSS, MySQL, Linux Server, Perl Scripting for CDR Mediation/FTP Automation
Contributions/Challenges/Impact
Contributions
- Managed the project from scratch to finish
- Developed script for CDR Mediation, FTP Automation for CDR collection, Rating engine
- Led Frontend developer to integrate backend service
- Coordination with IOF body (IGW Operators Forum) to reconcile the CDR disputes
- Stakeholder Management
Challenges
- Handling massive CDR (Call Detail Record) volumes with near-real-time processing while ensuring accuracy for billing
- Reconciling CDR disputes among multiple IGW operators due to mismatched call records
- Ensuring system uptime and reliability to meet strict SLAs (99.999% availability)
- Managing dynamic rate changes from international carriers, leading to billing inaccuracies
Actions
- Developed optimized Perl scripts for CDR mediation and FTP automation, reducing processing time by 70%. Implemented parallel processing and database indexing to enhance performance
- Worked closely with the IGW Operators Forum (IOF) to standardize CDR formats and introduced a reconciliation module that reduced billing disputes by 90%
- Implemented redundant Linux servers, automated failover mechanisms, and 24/7 monitoring, achieving carrier-grade reliability
- Built an auto- loader feature for real-time rate updates, eliminating manual errors and ensuring accurate billing
Results
- Successful Deployment: Delivered the end-to-end billing solution on schedule, enabling UIL to process over 50 million call records monthly with 99.999% uptime post-go-live
- Operational Efficiency: Automated CDR processing and reconciliation reduced manual effort by 80%, improving billing accuracy and dispute resolution
- Regulatory Compliance: Ensured full adherence to BTRC regulations, securing UIL’s position as a compliant and competitive IGW operator in Bangladesh
