We provide IT Staff Augmentation Services!

Database Developer Manager Resume Profile

5.00/5 (Submit Your Rating)

NY

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.

Employment History

Confidential

Position: IT Billing Specialist / PL/SQL Developer

  • 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.
  • Position: IT Billing Analyst
  • 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

Position: Interconnection Assistant Manager

  • 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

Position: Database Developer Manager

  • Worked in different positions such as Billing Engineer, Senior Billing Engineer MIS, and Database Developer Manager in MOCIT and Afghan Telecom Kabul Afghanistan
  • 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

Skills

  • 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.

We'd love your feedback!