AT&T and British Telecom:
Challenge:
International, federal and state regulatory
bodies requiring telecommunications carriers
to file forms or reports that provide revenue,
traffic and circuit information. In the past,
Concert parent companies (ATT & BT) have
submitted the required forms and reports to
these entities on behalf of concert. Beginning
JANUARY 2001, Concert was held responsible for
reporting regulatory information to the Federal
Communications Commission (FCC) and Public Utility
Commissions (PUCs) which are state regulatory
bodies. To ensure timely and accurate reporting,
an automated system was needed to ensure that
the Concert Financial Systems division can access
Concert financial information and generate reports.
Solution:
ProLink implemented a reporting solution that
consolidated data from revenue information sources
from the different organizations, the initial
requirement was to build a strategy and solution
for aligning this data onto a common platform
and report on the revenue for the company as
whole. The solution encompassed building an
implementing the Regulatory Finance Information
System (RFIS).
RFIS
was deployed on HP/9000 running HP-UX B.11.0
operating system with Oracle 8.1.6 Database
Server on the back-end. The data collection
and ETL Process is developed using Pro*C/C++.
The team built a web-based user interface to
facilitate the users to get the required reports
through their web browsers using the Oracle
Reports 6i tool.
Result:
ProLink’s solution provided BT Ignite
the ability to provide consistent and consolidated
reporting within the regulation timeframe given
by the FCC and PUC.
Back
to Success Stories Home
Return
to Top
|
