Implement TABS7 billing reporting portal for Airtel Nigeria which extract data from production system and refresh the reporting system through overnight ETL process, which support all kinds of postpaid revenue tracker, daily & monthly billing KPI, collection KPI, gross adds KPI, inventory KPI, adhoc reporting.
This product developed based on below tools
- Oracle Database 11.2
- Oracle Warehouse Builder 11.2 including repository.
- Fast Clone (informatica product to extract & load data)
- Oracle Discoverer administrator & Desktop
# Process CDR more than 22 million subscriber in data warehouse to ensure the NRT(Near Real Time) data available to business for analysis.
# Manage database which is more than 20TB.
# Ensure the backup of all processed CDR(s) in data warehouse.
# Ensure the data quality in each stage of the integration.
# Analysis & requirement gathering to fit the current, prioritized goals of the organization.
# Extracted data from Oracle database and flat files, perform mappings and load it into target Oracle tables by SQL Loader & external table.
# Design Logical and Physical modeling of database.
# Design and develop data validation, load processes (ETL) using Oracle Data Warehouse Builder.
# Developed procedures, functions and database triggers using PL/SQL.
# Involved in unit testing, integration testing and system Testing.
# Set up dimensions, measures and hierarchies for providing drill down facilities for reporting environment.
# Designing, integrating, review and optimization of reporting framework (OBIEE Admin, Answer, Dashboard) and data modeling.
# Management of all front end business Intelligence and reporting applications
# Provide analytical management reports on emerging issues and any other relevant areas to facilitate business management and decision making.
# Analyzing Key Performance indices of the network with set target of Subscriber base, Revenue and identification of gaps to help in meeting the Company’s objectives.
# Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using Oracle BI.
BSS Reporting - Billing System
# Ensure the successfully completion of ETL(CRM,ARM,MEDIATION,BILLING,INVENTORY etc.) process within KPI
# Develop & maintain the new process flow and mapping in ETL process using OWB to integrate with production system.
# Configure Fast Reader tools to Extract data from the production database.
# Develop script to spool data into *.csv and send via mail automatically and FTP to different server.
# Analysis business process and prepare new report and deploy into Discoverer reporting portal for business users.
# Generate ad-hoc reports using Oracle Discoverer 10g (Admin & Desktop).
# Perform various type of data migration from different system to production system.
# Daily & Monthly analysis on revenue, customer segmentation, recharge trend with RA(Revenue Assurance), Credit Control, Roaming, Finance, Sales & Marketing group.
# Maintain all type of change trail in production system.