Nitin Kumar
Mobile: +1-678-***-****
Email: acucfr@r.postjobfree.com / acucfr@r.postjobfree.com
12+ years of Experience in Software Development and QA
Professional Summary :
Overall 12+ years of Industry experience in Telecom and Functional Testing.
Full Project Life Cycle, Planning/ Scheduling/ Tracking, Issue Resolution, Resource Allocation, QA Support, On-shore and offshore Team Management, and Documentation.
Working as Group LEAD, BID (business intelligence data warehouse) module.
5+ years of hand on experience in Amdocs Billing system and almost 7+ years of experience in Amdocs Billing system integration with BIDW systems.
Prepare estimates, scheduling, defining the metrics, tracking progress, perform metrics measurement, status reporting, report metrics data and benchmarking SLA to PMO
Product modeling expertise for Voice and Data Products for Wireline and Wireless services
Communicate with team and frame business and technical requirements in accord with SLA
TECHNICAL SKILLS
Operating System : UNIX, LINUX (Red Hat 7.2 & Mandrake), DOS, Windows 9x/2000
Languages : C, C++, VB 6.0, HTML, VB Script, Shall Script
Packages : MS-Office,
RDBMS : ORACLE 8.0 (PL/SQL), SQL Server 7.0
Familiar with : Networking, Software Engg.Artificial Intelligence, MIS, SAD, OS, Agile
Testing Tools : Test Director 7.x/8.0, Quality Center, Win Runner 8.0, Quick Test Professional 8.0,
BIDW Toold : Informatica Power Center 7.1, Teradata, Vertica, Toad, Sql Assistance, Business Objects, Micro Strategy
ACADAMICS
2000-2003 Master of Computer applications
Rajeev Gandhi Technical University, Bhopal, India
1997-2000 Bachelor of Commerce
Rani Durgawati University, Jabalpur– India
ACHIEVEMENTS
Letter of Recognition for exceptional efforts and quality of work in Amdocs.
Special bonus in recognition of excellent performance during testing of a version in Amdocs.
PERSONAL PARTICULARS
Date of Birth : 22.09.1976
Passport No : F9665328
PROFESSIONAL EXPERIENCE
10/2013 -PRESENT AMDOCS INC. ALPHARETTA, GA 30009
Client: AT&T
DWH/BI Test Team Lead/Testing Group Lead
Domain: Telecommunication (Data Warehouse)
Tools/Plateform: HP-UX, SQL, TOAD, Vertica, SQL assistance, Teradata, Informatica, Rally, Mercury Quality Center
ECDW IS AN ENTERPRISE CORPORATE DATA WAREHOUSE IMPLEMENTATION FOR AT&T WHEREIN THE ETL ARE RUN AND VALIDATED ON THE TEST ENVIRONMENTS BEFORE THE PRODUCTION IMPLEMENTATION OF THE VARIOUS WORK EFFORTS. THE PROJECT DEMANDS SKILLED AS WELL AS CAPABLE RESOURCES IN TERMS OF TECHNOLOGY AND EXPERIENCE.
AS A DWH/BI TEST TEAM LEAD/TESTING GROUP LEAD FOR SYSTEM TEST TEAM OF THE APPLICATION (WITH A TEAM SIZE OF 10) I AM RESPONSIBLE FOR THE FOLLOWING:
Analyzing Business and development requirements and finally gathering test requirements.
Reviewing and providing signoff to the design\development documents.
Review of Test Design activities performed by the testers.
Provide the estimation for the testing activities based on the requirement analysis
Monitoring and reporting the daily progress of the testing activities during the execution timelines.
Preparation of Defect Log and reporting.
Reviewing, approving and signoff the testing summary towards the end of the project testing cycle.
Providing signoff for the QC Certification for the production deployment of the code.
Conditioned the Test Accounts for QC testing on assigned Workflows.
Monitoring the Detected, classified and reported bugs by the testers through Defect Tracking System
Liaison with the testing group and the developers to determine nature of fault, fault resolution, etc.
Building up a very strong customer support and communication structure
Contribution to Lessons learned best practices.
Bringing innovative and automation ideas to the table to reduce the testing efforts and time.
04/2012 -09/2013 Amdocs Inc. Alpharetta, GA 30009
As a Sr. IT Systems Analyst, I was responsible for the following:
Business Analysis and Data Modeling of Reference and Application data to migrate Customer and Usage data from Amdocs Billing system to BIDW system.
Co-ordinate w offshore dev and test teams, update on client expectations and deadlines.
Discuss Resource and Time management decisions daily and status reports to client
Product Modeling, define Line items and service attributes, map according to network architecture, create BRD, FSD and PRD
Create source to target system field mapping specifications and gather business rules for data validation, filtering and inconsistencies. Create UML diagrams to depict the flow.
Creating Support Documentation and presentations to reverse shadow knowledge and functionality for forth coming releases and discuss with Development team to confirm the correct process for every release. A detailed and approved roadmap was created after these discussions for the troubleshooting tasks and workarounds for each release
08/2011 - 03/2012 Amdocs Inc. Alpharetta, GA 30009
Client: AT&T
Testing Group Lead
Domain: Telecommunication (Business Object and Micro strategy)
Tools/ Plate-form: SQL, TOAD, Vertica, SQL assistance, Teradata, Business Object, Micro Strategy, Mercury Quality Center
Business Objects and Micro strategy are business intelligence tools implemented for AT&T, which allows business users to view, sort and analyze the business intelligence data. BO and Micro strategy integrates with eCDW (enterprise corporate data warehouse) and other Amdocs proprietary applications to provide the business intelligence data for business users.
As a for System test Team of the application (with a team size of 8) I was responsible for the following.
Analyzing Business and development requirements and finally gathering test requirements.
Reviewing and providing signoff to the design\development documents.
Review of Test Design activities performed by the testers.
Monitoring and reporting the daily progress of the testing activities during the execution timelines.
Preparation of Defect Log and reporting.
Reviewing, approving and signoff the testing summary towards the end of the project testing cycle.
Providing signoff for the QC Certification for the production deployment of the code.
Conditioned the Test Accounts for QC testing on assigned Workflows.
Monitoring the Detected, classified and reported bugs by the testers through Defect Tracking System
Liaison with the testing group and the developers to determine nature of fault, fault resolution, etc.
Building up a very strong customer support and communication structure
Contribution to Lessons learned best practices.
Bringing innovative and automation ideas to the table to reduce the testing efforts and time.
10/2009 - 08/2011 Amdocs DVCI, Pune, India
Client: AT&T
Senior Testing Engineer
Domain: Telecommunication (Data Warehouse)
Tools/ Plate-form: SQL, TOAD, SQL assistance, Unix, Mainframes, Teradata, Mercury Quality Center
EDW is an enterprise data warehouse implementation for AT&T wherein the ETL are run and validated on the test environments before the production implementation of the various work efforts. The project demands skilled as well as capable resources in terms of technology and experience.
Initially as team member from 10/2009 to 03/2010 and then as a Testing Group Lead starting 04/2010 (Team size of 10), I was responsible for following:
Analyzing Business and development requirements and finally gathering test requirements.
Reviewing and providing signoff to the design\development documents.
Provide the estimation for the testing activities based on the requirement analysis
Review of Test Design activities performed by the testers.
Monitoring and reporting the daily progress of the testing activities during the execution timelines.
Preparation of Defect Log and reporting.
Reviewing, approving and signoff the testing summary towards the end of the project testing cycle.
Providing signoff for the QC Certification for the production deployment of the code.
Conditioned the Test Accounts for QC testing on assigned Workflows.
Monitoring the Detected, classified and reported bugs by the testers through Defect Tracking System
Liaison with the testing group and the developers to determine nature of fault, fault resolution, etc.
Building up a very strong customer support and communication structure
Contribution to Lessons learned best practices.
Bringing innovative and automation ideas to the table to reduce the testing efforts and time.
Managed full transition activity from Infosys and built a team to support EDW activities.
07/2008 – 09/2009 Amdocs DVCI, Pune, India
Client: Cingular, AT&T
Senior Testing Engineer
Domain: Telecommunication (Ensemble Billing system)
Tools/ Plate-form: SQL, TOAD, Telegence (CSM, MAF-MPS, BILLING, AR, NM, WLNP etc.) Mercury Quality Center
Ensemble Billing System (known as TELEGENCE and Enabler) are Amdocs proprietary tool implemented in Cingular AT&T. I have worked on most of its modules ie. CSM (customer service management), NM (Number Management), AR (Account Receivable), MAF (Message acquisition and formatting), MPS (Message processing system) and Billing module.
Senior Testing Engineer
I was responsible for following:
Own and manage all the testing environments for system testing.
Manage the J-tracker (trouble ticket system)
Allocate the J-tracker tickets to the team members
Responsible for Environment setup, and troubleshooting the environment related issues.
Responsible for changing reference data as per testers need.
Responsible for implementation and maintenance of testing tools and various scripts used for the testing purpose.
Ongoing support to testing team during execution.
Tuxedo maintenance for testing team.
POC MAFMPS module.
Trouble shooting billing related issues and data setup.
First POC for any testing issues faced by testers on all the Telegence modules.
Test Planning and Estimations.
Execution of test cases and Identifying/reporting the defects in Quality Centre.
04/2007 – 07/2008 Maxelor Technologies Pvt. Ltd. Pune, India
Client: Cingular, AT&T
Domain: Telecommunication (Ensemble Billing system)
Role : Senior Testing Engineer
Tools/ Plate-form: SQL, TOAD, Telegence (CSM, MAF-MPS, BILLING, AR, NM, WLNP etc.) Mercury Quality Center
Ensemble Billing System (known as TELEGENCE and Enabler) are Amdocs proprietary tool implemented in Cingular AT&T. I have worked on most of its modules ie. CSM (customer service management), NM (Number Management),AR (Account Receivable), MAF (Message acquisition and formatting), MPS (Message processing system) and Billing module.
Responsible for following:
Own and manage all the testing environments for system testing.
Manage the J-tracker (trouble ticket system)
Allocate the J-tracker tickets to the team members
Responsible for Environment setup, and trouble shooting the environment related issues.
Responsible for changing reference data as per testers need.
Responsible for implementation and maintenance of testing tools and various scripts used for the testing purpose.
Ongoing support to testing team during execution.
Tuxedo maintenance for testing team.
POC MAFMPS module.
Trouble shooting billing related issues and data setup.
First POC for any testing issues faced by testers on all the Telegence modules.
Test Planning and Estimations.
Execution of test cases and Identifying/reporting the defects in Quality Centre.
04/2006 - 04/2007 Sapient, Gurgaon, India
Client: Sprint/Nextel, USA
QA Tester
Domain: Telecommunication (Ensemble Billing system)
Tools: SQL, TOAD, Telegence (CSM, MAF-MPS, BILLING, AR, NM, WLNP etc.) Mercury Quality Center
Nextel announced merger in December, 2005 and they merged their customer database. Nextel was using ensemble billing application, developed and supported by Amdocs and sprint was maintaining convergis billing application, after the merger they decided to go with ensemble billing application and both the customer database were merged to ensemble billing application and we at sapient supported the biggest telecom merger ever had by that time in telecom industry in terms of testing activities.
Associate QA Product L2
As testing team member I was responsible for following:
Analysis of the Impact Assessment (IA’s) documents.
Estimation of Test cases for various engagements.
Designing and executing the HLS (business scenarios test cases) and LLS (test steps test data).
Test management using Quality Center 9.0 and Change Synergy. Worked on Requirements Settings - for the requirement uploading in QC, Test Plan – for the uploading of the designed test cases, Test Lab – for the mapping of Requirement Settings and Test Plan and Defects tab – for bug reporting and tracking. Going forward we would be using change synergy defect management tool.
Responsible for work allocation, issue tracking, managing team activities, reporting to manager.
Responsible for Daily status report, EOD status call and defect triaging with US counterpart.
02/2005 - 03/2006 Sapient, Gurgaon, India
Client: Nextel, USA
Domain: Telecommunication (Ensemble Billing system, online store)
Tools: SQL, TOAD, Telegence (CSM, MAF-MPS, BILLING, AR, NM, WLNP etc.) Mercury Quality Center
Nextel Communications, a FORTUNE 200 company based in Reston, Va., was a leading provider of fully integrated wireless communications services and has built the largest guaranteed all-digital wireless network in the country covering thousands of communities across the United States.
We at sapient was responsible to provide the testing support for the applications implemented in Nextel for various business functions (ie Ensemble Billing system, Online store etc).
Associate QA Product L2
As a testing team member I was responsible for following:
Analysis of the Project Requirement Document (PRD).
Estimation of Test cases for various engagements.
Designing and executing the HLS (business scenarios test cases) and LLS (test steps test data) and Black Box testing for the Maintenance Releases (MR), Change Request (CR), Emergency Change Requests (ECR) and Promo Releases (PR).
Test management using Test Director. Worked on Requirements Settings - for the requirement uploading in test director, Test Plan – for the uploading of the designed test cases, Test Lab – for the mapping of Requirement Settings and Test Plan and Defects tab – for bug reporting and tracking.
Setup and maintain client specific tools like Enterprise Management Tool (eMT) – used for the content creation for the website, Aisle Setup Tool (AST) - for the creation / modification of aisles that would be used on the different environments during the different rounds of the testing.
06/16/2004 – 02/02/2005 HCL Technologies, Noida, India
Client: Mercury Interactive, USA
Domain : Testing
Tools: SQL, VB Scripting, Test Director, Quick Test Professional 8.0 and Ticket management system.
The project involves providing technical support for web based Testing Management tool, Test Director, and Test Automation tool Quick test professional. Test Director manages all phases of testing, i.e. specifying Testing Requirements, Planning tests and executing tests and tracking Defects. And QTP provides powerful automation capabilities using user friendly interface and VB Script. The project deals in providing robust and foolproof solutions to customers’ problems within a stipulated time. It includes developing codes (VB Scripting) for the customers for their customized requirements.
As a Member Technical support engineer, I was responsible for following:
Responsible for active time bound technical assistance and support for the Testing Tools i.e. Test Director and Quick Test Professional.
Review the work request and provide the solution to the users ie. Test Director Admin etc.
Responsible to help the customer with tool customization request using VB script.
10/10/2003 – 06/15/2004 HCL Technologies, Noida, India
Helix producer is an encoder which runs behind the real media player and provides on line encoding features. We were required to test the functionality of the producer for the windows, Linux platform and Symbian environment.
As a Testing team member I was responsible for following:
Responsible for analyzing the project requirement document.
Responsible for writing the test cases.
Responsible for Test case execution
Logging the defects using Bug Zilla and communication with development team.
Responsible to manage the inventory (Symbion phone devices, various audio/video devices and corresponding device drivers)
03/2003 - 09/2003 HCL Technologies, Noida, India
Strategic IT Enterprise Management Dashboard
This project describes the methodologies; metrics, processes and systems used to monitor and manage the business performance of an it enterprise. This provides the graphical charts, meters to provide a clear view to the management for analysis. Creation of charts and meters is done through third party active-x components like chart director and circle gauge
6 Month industrial training at HCL Tech Noida
As a team member I was involved in requirement specification, database conversion, coding and testing of SIEM dashboard. First we developed the system using VB and SQL Server and then for the distributed environment upgraded the entire software using ASP and SQL Server.