Customer Service
Resume:
Priyanka Rajendra Suryawanshi
Contact: +1-734-***-**** Email: *********@*****.***
* ***** ** ********** ** ATOS INDIA IN TELECOM DOMAIN
AS SYSTEM ANLAYST AND ASSOCIATE EXECUTIVE
~ Looking for Technical/development analyst/entry level positions to learn new technologies ~
Profile Overview
]3 Years of IT experience as System Analyst and Associate Executive in Telecom Domain. Telecom Operators operations and networks enabling the delivery and support of next generation services to their customers.
]Worked on different IT projects helped gain experience in end to end life-cycle of projects starting from requirements, design, and development and production implementation to user training.
]Experience in SQL query for data analysis and reporting.
]Experience in Citrix
] Experience in UNIX, HPUX, PUTTY query for data analysis and reporting.
]Experience in using defect tracking tools like DDTS, ClearDDTS.
]Experience in KMOrg tool, AM2 tool.
]Experience in analyzing test results and submitting the bugs using
] Ability to work under pressure and meet deadlines.
]Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies.
]Has ability to deal with people with conflicting needs.
Technical Skills
]Languages: - SQL,UNIX
]Database: - Oracle
]Tools: - TOAD, DDTS (Distributed Defect Tracking System – DDTS works same as tool Jira where Jira is a proprietary issue tracking product ), KMOrg
Trainings Undergone
]Web Component development using Java Technologies (Completed Java Certification from NIIT institute PUNE)
]Participated in SEED IT idol Competition ( Competition was held in Kolhapur, India)
Company: Atos India Pvt ltd
Title: Associate Executive November 2012 to November 2014
Client: Eplus
Location: Germany
E-Plus is a 3rd largest telecom Network service provider in “Germany”. We are getting the Additional service Requests (ASR’s) E-Plus. Application having different modules NORMAN, KUBIS, BSCS, CASS-NO, DCS each module having their own functionalities NORMAN is used for Order creation and customer activation. KUBIS is used for CRM customer care application BSCS is used for Retail billing, Alcatel-Lucent-IN, CASSNo is used for wholesale billing, DCS for dealer commission system. As well defect tracking (DDTS) that keeps track of reported software bugs in software development projects in various systems that are raised by customer in various system like NORMAN, SK, BSCS, ELAB etc. and applications handles many business processes like activation of prepaid and postpaid subscribers / SIM change / Contract renewal for postpaid customers / Mobile Number Portability, etc
Key Deliverables
] Worked on defect tracking tool as an admin on DDTS, ClearDDTS tool.
] Worked on defects. Defects are organized into classes and projects and stored in UNIX server. Every project is identified by unique name and associated with particular class as well naming convention of defect is 5 characters uniquely identify in ClearDDTS.
]Projects are created on UNIX server this projects are created with special class, client name, project created for reason, such information contains in projects as well project created for specific defect once the defect is solved the project gets closed.
]Performed testing like checking defect or bug size, reason of defect also checking details of defect in flat file and comparing the flat files in UNIX environment as well also need to check in Sql server details of defect.
] Worked on all defects tracked which stored in ClearDDTS, the defects are stored in particular project, particular class.
]Involved in interacting with the client for gathering and understanding requirements
] Check for monitoring messages, alerts and act to resolve it also check in the database in Sql server about the alert detail by running Sql query.
] Analyze the problems or bug in the UNIX system and raise defects to supplier for fixing in DDTS tool if the problem is was supplier end.
]Had direct interaction with the client and participated in Hand-off activities.
]Provided Training to New Joiners.
] Worked in ClearDDTS where ClearDDTS tracks and manages the defects and enhancement requests throughout the project lifecycle. In ClearDDTS defects are stored in flat files and flat files are stored in particular directory in UNIX server.
]If any of the flat files gets deleted by any user or if it is bymistakly deleted from UNIX server then the defect also gets deleted or the information regarding the defects will not display clearly and will create problem to track the defect.
] Maintains flat files as flat files represent the real data and are used to post copies of data to SQL database and flat files are stored in UNIX server, flat files contains the details of PR (Problem Report) like what is the problem, when did it occur, from whom did it occur, size, time etc.
] Worked on defects that raised by customers on UNIX server, defects/bugs may be anything like customer has problem in logging in any server, customer needs credentials for any server, need any specific report of defects (Report with details like defect number, defect reason, who raised defect, what is the reason for raising the defect, time, date etc and reports are prepared in UNIX server) changes in any shell scripts, etc.
]Worked on different applications like NORMAN, ELAB, and EPLUS etc where NORMAN, ELAB etc are small applications as well name represents clients.
] Created reports on defects in HPUX and UNIX for client presentation as well as also prepared if it is requested by client.
]Accepting the delivery as provided by client and the delivery was accepted in KMOrg which is UNIX based environment who includes XML delivery notes (XML delivery acceptance in short) by KMOrg tool as well installing the installation inputs based on delivery accepted.
] Synchronization the delivery details for the MOU report (MOU report contains the information like name of delivery, delivery requested by, accepted by, time, date etc report needs to update in AM2 tool.
]Updating of projects and PRs from DDTS as well also checking the details of projects and PRS in UNIX server weather it is correctly synchronized and the delivery accepted by KMOrg tool.
] If supplier feels any problem in delivery xml note then supplier raise the PR (bug) in DDTS and sends again the delivery by then again we accept the delivery by rejecting previous one and pass it to supplier if supplier is satisfy with the delivery he resolves the PR by changing the state of PR to resolve state and in such way the DDTS and KMOrg tool are synchronized.
] Generating xml schema files for supplier which is sent to supplier in case of changes, they help supplier to validate xml delivery note.
]KMOrg is embedded in the environment at test services which help to be position to effectively execute the testing with respect to implementation phase of project.
Company: Atos India Pvt ltd
Title: System Analyst December 2011 to November 2012
Client: KPN
Location: Belgium
Goal of the project was to carry out rating and billing of customers the services used by them. The roles involve requirement analysis, technical evaluation of billing solution, System integration and deployment of telecom billing systems.
Key Deliverables
]Experienced in rating and billing process in BSCS covering all business domain entities of BSCS, CMS development, business configuration (rate plans, system scenarios, rating packages, free units, promotions and customer’s data migration).
] Worked in Modules System Admin, CRM, Order Management, Product, Project Management, Billing, Voice Billing, Provisioning.
]Used Toad and Sql for Database verifications.
]Involved in interacting with the client for gathering and understanding requirements.
] Worked on BSCS systems in terms of database tables design and column mapping by running Sql queries.
] Coordinating with CRM, billing, migration and interfaces teams to be synchronized with the data mapping between the two systems.
]Worked closely with the CRM team in order to agree on the data mapping, e.g. how are the markets, rate plans, services, parameters … etc are mapped between the two systems? Each system has its own database structure and constraints and all these information we need to check in TOAD in database by running sql queries.
]Worked on rating engine, the events received in rating engine in the form of CDRs (Call Detail Records) or UDRs (Usage Detail Records), which explains the use of services. CDR is the collection of data which contains call information such as call date, call time, call length, calling party, called party etc and CDRs. Which are use to rate events, there is also a different table for rate plans.
]There are basic steps which we use to carry out for rating the events.
]Accepting CDRs from mediator in the UNIX server also need to check the CDRs naming convention which includes the call info (call info which contains call time, date, length etc) in UNIX server.
] Validating the CDRs and eliminating any duplicate records and the duplicate records are checked by running Sql query also checked in UNIX server and after checking all the info records are stored in Oracle database tool i.e. in TOAD for later verification.
]Determining customer account that has to charge the service/event and the customer details are checked in Oracle database tool i.e. in TOAD. Rate process pickup source (Mobile number or IP address – we can get mobile no details from TOAD i.e. from database as well also from UNIX system as under UNIX server also the details of customers are stored.) and then we need to check in TOAD in database if service associated with any account and if service is not present then that event/service is rejected and stored in TOAD for later verification.
]Worked on costing to service and service is charged according to traffic plan, there is a separate table in TOAD in database for traffic plans which stores various traffic plans and its details. The rated services are stored in TOAD for billing purpose or sent to external system for billing.
]Understanding different rate plans and their billing impacts.
]Performing bill preparation activities for bill run.
] Worked on billing process, billing process is aggregation of all chargeable, non-recurring services on an account by account basis. Involved in running billing Processes like End of Day, End of month, End of cycle, and Bill preparation, Bill confirmation and Accounts receivable and general ledger and collection processes as well need to check data of customer in UNIX server as well also in TOAD i.e. in database for confirming data.
] Billing engine pickup an account to generate a bill and we carry out following steps to generate invoice where billing process runs on the UNIX server.
]1. Firstly we need to rate CDRs of customers within 1 month of invoice, there are 4 billing cycles and we need to check first from TOAD whether which month billing we need to carry out by running the Sql query in TOAD for selecting billing cycle and there separate table for billing cycle in TOAD..
]2. If there is any refund or other charges are applicable, need to check in TOAD by selecting the records from Charges table by Sql Query.
]3. Adjustment passed in favor of customer or against customer, or discount given to customer or any taxes applicable on customer’s usage and rental charges are updated in TOAD to respective customers account.
]4. The billing system then guides the billing records to correct account and we rates the call using the arte tables in TOAD. Then we update the billing records in billing pool and the updation is done automatic we can check in TOAD in database by running the Sql query.
]5. Then from backend of billing system we combines records from pool to create a single invoice that is sent to customer.
]6. The customer then sends to telecom service provider then payment are posted or recorded in billing system. Then we update the files of customer service representatives
Credentials
2009-2011 Bachelors in Computer Science from University of Kolhapur, India
Personal Details
Date of Birth: 18th December 1989 Linguistic Abilities: English, Hindi and Marathi Address: 37705 dale dr, apt 201, Westland, MI -48185
Contact this candidate