Established in 2001, Ufone is a mobile telecommunications service provider with 22 million subscribers across Pakistan. The company operates 10,000 cell sites, 400 network franchises (including 30 company-owned customer service centers), and 150,000 distribution outlets. It also offers international, cell-phone roaming services through 300 operators in 160 countries. Ufone is the trade name for Pakistan Telecommunication Mobile Limited (PTML), which was privatized and became part of the Emirates Telecommunication Corporation Group (Etisalat) in 2006.
Ufone needed to provide its business managers with faster access to the most current customer and sales data to help make better business decisions and protect revenue. The organization deployed Oracle GoldenGate to replicate data from an in-house customer relationship management (CRM) system to its data warehouse, providing business managers with access to data that is updated every hour, rather than once a day.
It also rolled out Oracle Data Integrator to eliminate the need to use many applications to extract, transform, and load data into its data warehouse.
Ufone felt Oracle GoldenGate and Oracle Data Integrator were the most comprehensive and simplest tools to help the organization achieve its goals.
“Oracle GoldenGate’s real-time data replication ensures data in business intelligence reports is up to date, helping business users make informed decisions,” said Atif Aslam, head of management information systems, Ufone. “Oracle Data Integrator makes data integration simpler, as our operations team only needs one interface to access data from a variety of operational platforms, rather than using multiple, complex technologies. It has definitely removed a lot of complexity from our data warehouse-related operations, making life easier.”
Initially, Ufone’s IT team completed a proof-of-concept to ensure Oracle GoldenGate and Oracle Data Integrator would meet Ufone’s requirements. The IT team then configured and deployed the solutions across the organization.
Oracle Data Integrator went live in May 2010 and Oracle GoldenGate in August 2011.