IT Billing Specialist / PL/SQL Developer Resume

SUMMARY:

Ten years of experience in telecommunication (Billing System, Interconnect Settlement reports, Revenue Assurance System, and Data - warehouse) and Strong Oracle PL/SQL programming. basic shell scripting, reporting specialist, Basics of Oracle Database Administration. Motivated self-starter with excellent problem solving skills.

SKILL:

Strong Oracle PL/SQL(UTL SMTP, UTL File, Procedures, Packages, Functions, Indexes, Tables, etc).

Basics Shell Scripting, HTML, Basics Java Programming, SQL Loader

Basics Oracle Database Administrations ( Installations, User Management, Tablespace Monitoring, Adding Data files, Import & Export of Tables & Data)

Telecom ZTE Billing System ( Mediation, Interconnect and Roaming Settlement, Rating & Charging).

Wedo Technologies Telecom RAID Revenue Assurance Integrity Driller .

Oracle Database (9i, 10G, 11G), TOAD, SQL Developer, Putty, WINSCP, FTP, SFTP, ETL using scripting.

EMPLOYMENT HISTORY:

Confidential

IT Billing Specialist / PL/SQL Developer

Responsibilities:

Lead the team and handled the overall Roaming, Interconnect Settlement, Mediation, and RAID Revenue Assurance Integrity Driller System.
Using Oracle PL/SQL & Teradata SQLA Developed Reports (Roaming, Interconnection settlement,Reconciliations, Complete Monitoring of the system process) sending reports automatically through email using PL/SQL UTL SMTP.
Developed and Administered CDR Pool Server (Oracle Database 11G, Linux OS,): Using FTP for File collection, Using PL/SQL UTL FILE for Reading directory, files and uploading files content into Oracle Database, calling the Oracle procedures in crontab of Linux scheduler .
Developed Oracle Schema for Telecom BSC Statistics Report and Reading the BSC Statistics files and uploading them into Oracle Database using PL/SQL UTL FILE.
Exporting data from Oracle Database using Shell scripting, and importing using SQL Loader.
Shell Scripting Calling the PL/SQL Procedures, Extracting the data from Oracle Database, Using SQL Loader, File System Monitoring, Using Crontab scheduler
Coordinating with external auditors for the audit of the Billing System.
Using IT Support portal for assigning TT’s for the team, Using RAID support portal.
Solving the alarms and cases of the RAID system.
Implementing NRTRDE Near Real Time Roaming Data Exchange
Using Shell Scripting & FTP for Roaming TAP File & NRTRDE files automation transfer and collecting.
Coordinating with the Wedo Technologies with Providing data for the RAID Project.
Loading the data into Oracle data base using SQL Loader

IT Billing Analyst

Confidential

Responsibilities:

Developed Roaming and Interconnect Settlement Reports taking in consideration all traffic routes: Domestic, International & Transit using Oracle PL/SQL.
Complete Postpaid & Prepaid Revenue Report Using Oracle PL/SQL
Handle over all mediation, Roaming and Interconnect Settlement configurations using ZTE CVBS, and developed scripts in Oracle PL/SQL to monitored the system process.
Developed PL/SQL Coding to upload the interconnect settlement international outgoing traffic rates to Oracle database and changing its formats from one row to multiple rows as the multiple dialing codes was in one cell and it had to be unique dialing code in one cell/row, and updating the expiry date as of new rates effective date.
Developing the reports in Crystal Report.
Using PL/SQL to catch the SIM BOX numbers.

Confidential

Interconnection Assistant Manager

Responsibilities:

Connected Wasel with all other operators in Afghanistan (Writing proposal, processing agreement, physical link activation, testing voice and SMS, and CDRs reconciliation).
Developed all interconnect reports using Oracle PL/SQL.
Managed all interconnection settlement with other operators ( IT, Commercial and Financial part)
Worked in CVBS and Coordinate with CVBS and VAS vendor CBOSS

Confidential

Database Developer Manager

Responsibilities:

Designed and developed interim billing system to generate postpaid telephone bills using MS Access database and Visual Basics
Generate the Interconnect Settlement Reports for national and international operators using PL/SQL.
Coordinate with TECON Billing System vendor for installing and operating the new billing system
Network based application for prepaid system (Using MS Access)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship