Projects Listing
Article Series on Telecom Billing by Bradley Johnson
Year: 1998 - 2001
Sponsor Company: New Global Telecom
Technology: Oracle, PL/SQL, Oracle Forms and Reports, Developer 2000
SQL, SQL*Loader, SQL*Plus, K shell, FTP, Crystal Reports, SCO Unix, Solaris
Detail: Gathered requirements from key individuals in IT, operations,
accounting, sales and marketing. Designed rating engine, CDR loader, data model.
Oversaw various consultants work on performance tuning and coding portions ofthe GUI. Provided
UNIX administration and Oracle database administration.
Features of Version 1:
- Loaded call detail records from Harris and Ericsson switches in real time.
- Maintained all call records for use in determining statistics.
- Rated calls by incoming and/or outgoing truck groups.
- Call rounding - flexible call rounding (2 minutes to 1 second).
- Allowed time of day and day of week rating.
- Provided each customer and vendor with customized rates for each country, city or portion of a city.
- Maintained rates and costs so that gross margin could be calculated.
- Web reports for real time view of call volume, revenue and costs.
- User interface for maintaining prefix codes associated with a country, city and
region.
Features of Version 2:
- Improved user interface to allow quicker data entry.
- Improved speed of code.
- Added additional reports for watching gross margin and call statistics.
- Added gross margin drill down reports using Oracle Reports.
- Implemented a GUI and code to allow discounting based on call volume to a country or city.
Features of Version 3:
- Added additional user interfaces for simple and complex rate entry.
- Improved speed of rating engine.
- Started using partitioned tables.
- Improved ability to group common rates together.
- Added Underwater rate warning to GUI.
- Added integration to Oracle Financials.
Features of Version 4:
- Improved loader scripts.
- Again improved speed of rating engine.
- Implemented product groupings. Grouped nxx and npa codes together into
product groups.
- Added automated rate faxing.
- Automatically raises rates based on rising costs.
- Added support to maintain special rates for Managed Network Services Product.
- Utilized materialized views and instead of triggers.
Features of Version 5:
- Added ability to correlate calls going through multiple switches.
- Improved speed of rating engine by 150%.
- Improved ability to group common rates together.
- Further improved support for Managed Network Services product. Added special
tables to separate call detail records for Managed Network Services customers from
regular customer accounts.
Projects Listing