SUMMARY:

• Over 8.9 years of experience in Telecom domain and has ability to create solutions. Good Experience on OSS/BSS.
• Provided BI expertise, designed and developed data models by translating user requirements into data flows and data mapping.
• Understood ETL process and complex business rules that need to be implemented and planed the data transformation methodology.
• Highly experienced in Data analysis and profiling using Informatica Data profiling tool.
• Have work experience in Data Quality works and have worked in Teradata.
• Have good Knowledge in Mediation, Rating and Billing.
• Worked in COTS products like TBMS (Suntec) and got trained in Convergys. (Can work in any COTS product).
• Worked extensively on PL/SQL and UNIX.
• Customer handling experience at onsite (United states and NEPAL).
• Good working experience in Agile methodology.
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts. Worked closely with QA team to ensure quality and bug fixing.
• Extensive experience in functional testing, unit testing, integration testing, regression testing, GUI testing, back - end testing and browser compatibility testing.

TECHNICAL SKILLS:

• PL/SQL
• Eclipse
• CVS
• Oracle
• Putty
• Suntec - TBMS (COTS product)
• JAVA
• Quality Center
• Convergys - Infinys Billing system (COTS product)
• UNIX
• SQL Developer
• Mediation Zone (COTS product)
• Fiddler
• TOAD
• Rally
• Teradata
• Teradata studio
• Informatica Data quality 9.6.1, DVO

PROFESSIONAL EXPERIENCE:

Confidential, Mount laurel, NJ

Data quality Analyst

Responsibilities:

• Developing and testing SQL that provided status data on critical product line. Have knowledge on Teradata.
• Performing root cause analysis of data quality issues.
• Providing support for Merge and Transfer process across the billers (CSG to AMDOCS and vice versa).
• Worked with Informatica Data Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.6.1.
• Created transformations and mappings using IDQ to move data from multiple sources into targets.
• Created ETL transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the IDQ designer.
• Performed analysis, design, and programming of ETL processes.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.

Environment: UNIX and Windows.

Technology/Language: Teradata

Tools: SQL Developer, Putty, Teradata studio

Confidential, Denver, CO

Developer and Onsite Coordinator

Responsibilities:

• Gathering and analyzing mediation, rating requirements and customizing the same in Suntec TBMS-T billing system.
• Coordinating with offshore team.
• Fixing defects and providing support during QA phase.
• Providing L2 support for mediation processes.
• Providing support during production deployments and validating the release.
• Managing Change Requests from end to end
• Status reporting - daily, weekly and monthly basis to Senior Management.

Environment: UNIX and Windows.

Technology/Language: PL/SQL.

Tools: SQL Developer, Putty, Suntec TBMS-T billing system and Quality center.

Confidential

Developer

Responsibilities:

• Developing Automation scripts for loading rental and one time charges.
• Participating in business requirement discussions with Customer, Technical Architects, Business Architects and Application teams.
• Doing impact analysis and preparing design document for the requirements.
• Implementing various types of rating scenarios in TBMS as per customer requirements. It includes voice calls charging based on the packages, special number charging etc.
• Preparing unit test cases and providing support during QA phase.
• Creating adhoc reports requested by clients after bill runs.
• Developed tariff loader script which loads the rating configurations directly from excel sheet to TBMS.
• Having significant contribution in 10 membered team to achieve Best Delivery Team award from client.
• Worked on collections, Credit limits monitoring and bill snap modules.

Environment: UNIX and Windows.

Technology/Language: PL/SQL.

Tools: SQL Developer, Putty and Suntec TBMS-T billing system.

Confidential

Developer

Responsibilities:

• Attended 2 months training on Convergys product.
• Working in Telecom Practice team and participating in client demo on Suntec - TBMS system.
• Doing research in various billing products to know the feasibility.
• Analyzing new products by configuring and testing few scenarios.
• Presenting the results of the analysis to senior management.
• Developing of other house holding scripts.

Environment: UNIX, Windows

Technology/Language: PL/SQL.

Tools: SQL Developer, Putty, Suntec TBMS-T billing system, Convergys

Confidential

Developer and Onsite Coordinator.

Responsibilities:

• Mapping Customer requirements of mediation, rating, billing and partner settlement to the suntec TBMS system.
• Processing Mediation files for ASCII, Binary and Alcatel formats in TBMS. It includes voice, data, sms CDRs.
• Implementing voice calls charging based on the packages which includes special number, CUG, Friends & Family.
• KT sessions to team members on application functionality.
• Reviewing documents prepared by other teams in the engagement.
• Preparing System test cases and executing the same.
• Status reporting on weekly basis to Senior Management.
• Daily and weekly Status calls with the Customer.
• Working with customer at onsite (Nepal) during development and support phase.

Confidential

Developer

Responsibilities:

• Gathering requirements and preparing design documents.
• Working on provisioning and activation module.
• Developing Activation module in C++ and UI design (JSP).
• Interacting with the Customer for functionality clarifications, weekly calls and defect analysis
• Status reporting on weekly and monthly basis to Customer and Senior Management.