Project System

MADHAVI N

Mobile : +91-949******* E Mail: ********@*****.***

Professional Summary

Have around 3+ years of work experience in Telecom domain in IT industry with wide exposure to various phases of

software development life cycle, customer support and maintenance. It includes extensive experience in telecom billing

systems like Xalted’s Modula. Has an extensive Experience in Telecom Interconnect Billing System deployed for India’s

largest Telco service provider. Hands on experience in Mediation, Rating, ISDN Connectivity, Roaming Scenario, IN

Services, Hubbing traffic, POI and other reference data Configuration, Reconciliation, Processing, Invoicing, Various

ILDO Reports, Router Configuration and Tuxedo. On the other hand, has a good interpersonal skill set with UNIX,

Oracle 9i (SQL) extensively for accomplishing the tasks with the quality norms and procedures of the industry.

Highly successful in business process for improvement of successful automates solutions and working towards

developing skills in the latest emerging technologies and exploring opportunities that suit best for the individual’s

strengths and the Enterprise.

As a motivated achiever have strong interpersonal and communication skills both written and verbal

Academic Qualification

• Passed out BSC(Computer Science) from Andhra University (Andhra Pradesh) in 2008 with First Class

• Passed out Higher Secondary from Sri Chaitanya College (Visakhapatnam) in 2005 with First Class

• Passed out Matriculation from Bhashyam Public School (Visakhapatnam) in 2003 with First Class

Skill Set

• Telecom Tools : MODULA Suite (Mediation, Reconciliation, Rating, Billing),Intec

Singl.eview Convergent Billing System

• Middleware : TUXEDO, Web Services (SOAP, WSDL)

• Languages : SQL, UNIX, C

• Front Ends : Visual Basic 6.0,

• Back Ends : Oracle.

• Operating Systems : SUN Solaris, Windows XP, Vista and UNIX

Areas of Expertise

• Process prolific experience in the interconnect Billing (Rating of Call Detail Records, Reconciliation,

Revenue Assurance & Fraud Management, Discard analysis, Discrepancies handling, Business Configuration

(Rating, TGP, MSC, IN Services, Roaming, Hubbing, ILDO, Call Scenarios Treatment etc.,)

• Process experience in UNIX, VBA and SQL and C.

• Sturdy management skills, demonstrated proficiency in leading the team for forming consistent

environments with in the team.

Total Experience

Worked in MAHINDRA SATTYAM SRVICES LIMITED (India) from June 2008 to July 2011 as Software

Engineer –Telecom Billing, Reconciliation, and Business Configuration with Mediation modules in

Interconnect Billing Telecom under BSS Operations for BSNL and develop and implement Convergent Billing

System for MTNL Customer Care & Billing System(CCBS)

Project Profile 1:

Project Name : BSNL IOBAS(Inter Operator Billing and Accounting System)

Duration : Aug 2008 Aug 2010

Client : Bharat Sanchar Nigam Ltd.

Organization : Satyam Computer Services Ltd.

Project Domain : Telecom

Team Size : 30

Environment : Programming Languages: UNIX Shell Script

Database : Oracle 8i

O/S : Sun Solaris

Middleware : Tuxedo

Tools : Toad, Winscp, Editplus

Project Description:

Inter Operator billing and Accounting System (IOBAS) is used to generate Invoices for different OLO’s (Other

Licensed Operators) across 16 circles in India. Across these 16 circles, we have many OLO’s like Bharti, Reliance, and

Tata etc. There are generally 4 operator types (services) in this system they are BSO, CMSP, NLDO, and ILDO. The

information for the system is supplied through CDR’s (Call Data Record) which consists of both Interconnect (Calls

Originated from OLO to BSNL [or] BSNL to OLO) and Non Interconnect calls (Calls Originated from BSNL to BSNL).

Totally there are 5 switches that generate CDR’s they are CDOT, AXE, 5ESS, EWSD, OCB. Each CDR consists of

Calling number, Called number, Trunk group, duration etc.

The CDR’s are first present in the raw state in Telephone Exchange switches. These CDR’s are placed in the

POI (Point of Interconnect) PC by the POI PC incharge at particular telephone exchange in binary format and then

renames by using renaming utility software. These renamed files are collected to respective FTP Servers (Across 16

Circles) and then to Data Center (DC) for mediation process. The mediation is done by using appropriate switch wise

converters where the collected raw file is changed from binary format to ASCII file format. Before rating of these CDRs,

we separate both Interconnect and Non Interconnect CDRs (calls) through filtration mechanism since the billing is done

only for Interconnect calls. After filtration, we rate those Interconnect CDR’s for generation of Invoices for different

operators and operator types (services).Apart from these, we also perform Time Gap Analysis reports, Record

continuity checks to identify the missing CDR as soon as we receive the CDR file to Data Center.

Contribution

**As a part of the team, was responsible for day to day operations of IOBAS which mainly include:

• Data Collection

Acquired good knowledge on problems encountered on different kinds of network connectivity’s (ISDN, PSTN, LAN,

WAN), ensuring data integrity while collection of data across the network and automation of the collection process

using UNIX shell scripts and ftp protocol. Have good knowledge on CISCO routers while configuring various dialers

on ISDN connectivity and solving various ISDN related problems.

• Mediation

Worked on various conversion routines for various telecom switches (Alcatel OCB, Siemens EWSD, Ericsson AXE,

Lucent’s 5ESS, ITI’s CDOT) and handled many conversion related problems while testing and was also successful

in tightly coupling the various activities involved in mediation by automating conversion of CDRs, filtering of CDRs

with respect to trunk groups and removal of duplicate CDRs.

• Business Configuration

Possess fine knowledge of various reference data configuration and responsible for the implementation of various

call scenario in billing system

• Processing

In this module we are rating the calls as per IUC by using TUXEDO and pumping the CDRs to traffic table in a

normalized form. Since we are processing huge volume of data hence we required to manage space availability for

the rated CDRs at day wise & index partitions. Need to monitor various tuxedo error, compilation error, oracle error,

processing speed performance and server hard ware error if any.

• Invoicing

Possess fine knowledge on various rounding off issues and aggregating the calls which are rated, according to

required format by creating various procedures in oracle.

• Reports

Possess fine knowledge on various reports such as: ILDO TRAI, ADC TRAI, Country wise report etc.

Responsibilities

Data collection activities and solving various connectivity issues (ISDN, LAN, WAN).

Changes in the current system configuration as per the new Business requirement.

Reconciliation of the complete data to avoid any discrepancy in current billing system.

Discards analysis for entire bill cycle.

Accomplish the day to day operations of the project.

As a Module Team Member Expertise for

Data Collection

Mediation

Reconciliation

OLO Reconciliation

CDR Extractions

Clearing Discards

ILDO, Sample Discard and Country wise Reports

Project Profile 2:

Project Name : MTNL Customer Care & Billing System(CCBS)

Duration : Aug 2010 to july 2011

Client : MTNL (Mahanagar Telecom Nigam Ltd.)

Organization : Satyam Computer Services Ltd.

Project Domain : Telecom

Role : Oracle Database Administrator

Environment : Windows NT,Oracle 9i/10g and UNIX AIX 5.

Tools/Utilities used : Intec Singl.eview Convergent Billing System v6.0,

TOAD,RelGen

Languages : SQL,UNIX Shell Scripting,C

Project Description:

The overall scope of the project is to capture the client’s requirements, develop and implement Convergent Billing

System. The solution provides one platform to implement varied services offered by MTNL – GSM, Wire line, CDMA,

Leased Line, Internet, Broadband, ISDN, IN, INet. The Billing Module’s scope is to analyze the billing requirements

considering all the Lines of Businesses, configure these requirements in the Intec Singl.eView Billing System and

develop integration with all other systems such as PeopleSoft CRM, Sys Team Mediation, Sys Team Provisioning,

MTNL Financial Management System, Kodak Printing System, etc. The Singl.eView Convergent Billing system will be

centralized single platform for all business of MTNL enabling MTNL the flexibility of managing the Customer, Products,

and Discounts effectively and efficiently.

Contribution

Actively participated in various activities like Single view Administration, Solved connectivity issues related to

production and development .Code release into production Environment using RELGEN,Creation of users in different

levels,for maintaining security and trouble shooting of different issues in production and also in development in MTNL

project

**As Singl.eView Admin which mainly include:

Deploying Billing Singl.eView Application.

Administering Singl.eView on Production (RAC environment), UAT And dev.

Trouble shooting Singl.eView related Issues.

Tuxedo Installation.

Tuxedo Configuration and Administration

Singl.eView Release Management.

• Dev/UAT/Production support in Release Installat

As a DBA, is responsible for

Oracle software Installation.

Oracle database Instance creation according to the customer requirements.

Implemented and configured RMAN on Production environment.

Creating the required table spaces, users, and roles for the application.

Estimating the space requirements for various data structures used in the Application.

Database Design and creation of schema as per design.

Scheduled Backup of database (full backup and logical backup).

Using imp and exp utility to move the data from one instance to another.

Monitoring OS CPU utilization and killing unwanted user process.

Database and application security.

Monitoring and Troubleshooting Database errors.

Monitoring and improving performance of the database (SQL tuning and database level tuning).

Release manager for the CR’s sent by the business and development team.

Certifications Accomplished

**Certified in QMS (Quality Management System) of Satyam own I Strive Methodology.

**Certified in the following areas in Satyam School of Leadership

• Effective Communication

**Telecom Domain certified in Satyam.

Personal Details

Name : Madhavi N

Date of Birth : 13 AUG 1988

Marital Status : Married

Permanent Address : Door No: 16 94, Prahalladhapuram,

Simhachalam, Visakhapatnam - 530017

Languages known : English, Hindi, Telugu

Contact this candidate