Sign in

Test Cases Data

Hoffman Estates, IL
October 29, 2019

Contact this candidate


Niti Kumar



Above 9 years of experience in Software Testing, team management and client handling.

Experienced in Functionality Testing, Integration Testing, System Testing, GUI Testing, Regression Testing, Smoke Testing and Sanity Testing.

Strong background of developing and implementing QA processes using various methodologies.

Motivated Team Player with excellent communication skills.

Strong working knowledge of all phases of SDLC and Strong working experience of Software testing.

Experience in developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.

Experience in preparing Traceability metrics, Failure Analysis reports and coordination with client on it.

Experience in Test Case Design, Test Planning, Test Tool Usage, Test Case Execution, Defect Management and building Test Environment.

Extensive experience in status reporting to management, issue escalations.

Experience in developing SQL Queries to perform database testing.

Experience in preparing Traceability metrics, On-site and Off-shore Co-ordination, conducting weekly review meetings during Test Planning stage and daily status updates during Test Execution stage.

Actively participates on an agile (Scrum) development team working closely with developers, designers and other analysts to delivery product functionality in an iterative process.

Document the results of test cases and any defects encountered so they are easily understood, as well as provide complete information to replicate the issue.

Expertise in presenting and conducting UAT’s with Business team.

Hands on experience in doing RCA of defects.

Experience of handling Go/No Go meetings in the project.

Experienced in Managing the QA/test team and conducting status calls, Daily stand ups

Familiarity with Data Warehousing/Reporting, Business intelligence, and Quality management.

Experience in executing the automation scripts using Selenium -Web driver

Proven ability to work efficiently in both independent and team work environments.

Won Star Award at Cognizant.


Database : SQL Server 2000, SQL Server 2005, MS Access, Oracle, Mongo DB

Testing Tools: Quality Centre 10.0, QTP 9.0, Selenium and Load Runner.

Programming: C++, Java.

Defect Tracking : JIRA, Quality Centre, Bugzilla

Project Management : Kanbanery and JIRA Tool

QA/Testing : Black Box testing, System testing, Integration testing, Regression testing, End-to-end testing, UAT testing, Data validation and verification

CRM :, Siebel, MS Dynamics CRM 4.0


Office tools : MS Word, MS Excel, MS PowerPoint, MS Access

Scripting Languages : HTML, Java Script, VB Script

Application Tested : E-commerce, Website, Web based, BI, Web service


Company: Cognizant Technology Solution

Client: Sears Holding Corporation and Discover financial

Duration: July 2012 – October 2017

Worked as a Test Engineer at Sears’s ecommerce QA Engineering Team (Sears Holdings Corporation is the 5th largest internet retailer in the world (year: 2014) source:

Project name: Online testing

Worked on WCS migration project to migrate the SHC ecommerce websites (,,,, from the IBM WCS to monolithic platform to SOA based platforms.

Member Dashboard (Complete redesign of Order center/Order details/Manage my account page)

Holiday Messaging

Layaway, Enhanced delivery system

SCIM code changes

Troop ID integration

Fulfillment by Palooza

AMEX Car linking, HSBC card termination

Kmart home delivery

Ratings and review

Self –service cancellation

Email redesign, Payment redesign, Personal Info Management, Message center

Member messaging and Personalization

Job Responsibilities:

Interacted with Users, Business Analysts, gathered business and technical requirements, reviewed business requirements, technical requirements and specifications.

Performed extensive back end Database testing using complex SQL queries.

Wrote complex SQL Joins, Unions and Nested Queries on various data tables for Data validation.

Created test data for validating scenarios based on functional requirements specifications.

Created Test scripts and UAT test cases and coordinated with the UAT Team and Project manager and performed User Acceptance Testing with the Users.

Conducted integration testing, identified application errors, resolved issues through bridge calls.

Worked closely with cross-functional teams including users, development, marketing, validation, and technical writing.

Responsible for creating and maintaining Requirement Traceability Matrix (RTM) and traced the requirements to the corresponding test cases.

Daily Status meeting with Development and Management teams to discuss bugs and other issues.

Worked in waterfall, Agile-Scrum methodologies. Passion for continuous improvement of QE effectiveness and efficiency through metrics & causal analysis.

Isolate, replicate, reports defects, verified defect fixes, and strive to reduce defects.

Coordinated testing efforts with the offshore teams.

Involvement with different development teams browse, profile, and checkout. Used site Analytic tools Omniture to track various events on SHC sites like user hitting a category, subcategory, product page, user logging in, user making checkout etc.

Has been playing a pivotal role in Black Friday/Holiday readiness test support for past 2 years.

Worked on WCS migration project to migrate the SHC ecommerce websites (,,,, from the IBM WCS to monolithic platform to SOA based platforms.

Leading profile automation.

Monitor all business and functional requirements for all tests and documents all test cases and assist to resolve all issues

Administer and maintain all profile automation scripts and review all product changes and coordinate with developers to provide efficient feedback and partner with manual test team to implement at manual test cases

Monitor all automation processes and prepare status reports for all progress.

Record test results and report and verify software bug fixes to accept automation criteria.

Tools and Technologies: Ipconfig, UNIX, JIRA, DB visualizer, Rest client, Kanbanery, Firebug, Mongo DB, Microsoft SQL Server, JAVA, Eclipse, Soap UI

Company Name: Sunsoft Services

Client Name: DELL

Duration: Dec 2011 - July 2012

Job Responsibilities:

Lead a project testing team of 6 for a successful implementation of their legacy system replacement.

Produced and managed QA deliverables through formal Project Plans. Presented Project Plans to the project team for review and approval.

Testing of different workflows in salesforce

Authored test plans, create high level test cases and performed risk based analysis to identify high priority test areas. Utilized technical design, business requirements and data specifications to assist with these activities

Reviewed the detailed test cases and approved them to be put into Quality Center.

Managed the Traceability between requirements and test cases.

Involved in cross browser testing, using Netscape Navigator and Internet Explorer.

Created SQL scripts to test the database migrations, data storage and retrieval on a DB2 database.

Experience reading the Source to target mapping documents in created highly complex SQL queries for validating of data migrations.

Participating in regular project status meetings to deliver periodic updates on testing related activities.

Generated Test Metrics using quality center reports and graphs

Conducted test plan and test case review meetings with the team.

Tools and Technologies: HP QC, Sales force, MS Dynamics, Oracle, MS Access, MS Excel, Java, QTP

Company Name: Agilent technologies, India

Duration: July 2007 – March 2009

Quality Analyst

Job Responsibilities:

Prepared Test Plans, Test Procedures and Test Cases for Manual Testing.

Executed tests and participated actively in system test cycles.

Tracked and logged defects in Quality Center and coordinated meetings with developers and business analysts to prioritize the bugs.

Conducted User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.

needs and formulate solutions to meet those needs.

Develop MS SQL based solutions for data analysis and reporting.

Took the responsibility of identifying new process, finding out gaps in existing process, arranging training modules for new process development and implementation.

Company Name: Astadia, India

Duration: March 2007 –June 2007

CRM Quality Analyst

Job Responsibilities:

Attended the regular client call and discuss the weekly status with the client.

Sent the Status Report (Daily Weekly etc.) to the Client.

Modify existing database as user needs and technological capabilities change

Data Migration with/to SFDC from different sources such as Oracle Siebel, Sugar CRM, Pivotal CRM, MS CRM, etc. to without losing the relation between the different data.

Conducted weekly QA status meeting for the projects to discuss defects, issues and timelines.

Write and execute manual, functional test cases during multiple phases of SDLC.

Documented QA processes for all the projects under QA department

Developed Test Plan, Test Cases and Test Scripts for testing the applications.

Company: Centurion bank, India

Duration: Jan 2005 – Feb 2007

Database/Quality Analyst

Job Responsibilities:

Created MIS reports, Internal Customization and scheduling Bank Operational reports on Intranet using HTML Report Studio to help management to make informed decision.

Extract, Transform and Load the data using ETL Studio. Designed operational and MIS Reports using Oracle and made that available to user on web using Web Report Studio. Designed and Developed scripts on UNIX using Oracle (SQL) For MIS.

Designed Test cases from Requirements, Functional Specifications and Design Documents

Responsible for analyzing database related applications and software


MBA in Information technology & Marketing, Amity Business School.

B.E COM from GGSIPU. New Delhi

Contact this candidate