Business Problem
France Citevision's business plan called for significant growth in subscriber numbers. This could only be achieved through geographic expansion away from its core network in Amiens, France. It had to offer its' services over networks in other cities where the networks were owned and operated by different companies . This required :
- Creation and management of new products localised for these different geographic areas
- Automatic creation of a Service Provisioning Request immediately after creation of the customer order in SmartPack
- Automatic creation of a Provisioning Request File using different formats for each remote network operator
- Updating the remote network operator's systems with Provisioning Requests
- Accepting and managing automated feedback and Provisioning Status updates
- Creation of a tracking and management system to support follow-up processes and procedures
Limited budgets and short timescales ruled out migration and implementation of new CRM, Billing and OSS systems.
Solution
The solution that was developed had to employ inexpensive, readily available tools and make use of the existing systems and to accomplish the necessary tasks, albeit that these systems had not been developed with this kind of integration in mind.
A fully automated solution was created using the innate capabilities of Amdocs' SmartPack and the underlying Oracle database for the Customer and product management. The process management and automation layer was implemented using an open source ETL tool (Pentaho Data Integration or PDI) which captured changes of state, took appropriate actions and managed automation, reporting and integration with external systems.
PDI was chosen for its ease of implementation, its flexibility and its diverse capabilities which ensured that a single core could be developed that would interface to a wide variety of third-party systems whether file-based or using WebService interactions.
Results
The solution was developed in a Windows-based test environment and, following debugging and refinement of processes, it was migrated to a dedicated linux server where the various processes ran continuously to completely automate the new inter-operator interactions. The new tables created as part of the project became the basis for management reporting for follow-up and operational troubleshooting.