Data Test

Rajesh Chilkamari

732-***-**** ******@*********.***

Professional Summary

Over 11 years of diversified Software Quality Assurance Experience in the areas of Web based, Client - Server and standalone applications using Automation and Manual testing in both Waterfall, Agile methodologies

Well versed in creating and maintain automation scripts with Handling, Selenium WebDriver methods, Java Page Object model with TestNG Annotations in Selenium WebDriver for Functional and Regression Testing.

Good Experience on Object Oriented Programming

Expertise to work with Development teams on Agile-BDD approach to develop web UI testing using Cucumber, Gherkin and Selenium WebDriver.

Experience in Design and implement different automation frameworks like for various projects with log4j and Extent Reports

Expertise in creating new Automation frameworks from scratch

Worked on Continuous integration and Continuous Deployment (CI/CD) with Jenkins and Maven as Build tool also GIT for version control.

Well versed on Web Services /API testing using Soap UI,Rest Assured and Post man.

Good knowledge on Mobile testing tool like Appium.

Knowledge in Protractor Automation testing for both Angular and Non-Angular pages

Well acquainted with all SDLC and STLC phases and Testing Methodologies like Agile (Scrum and Kanban), Waterfall

Extensively used SQL and PL/SQL to retrieve the data from databases to perform data validations and comparisons for regression testing.

Worked extensively on Data Warehouse (ETL) testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.

Extensive Experience in Business Requirement Analysis, Test Strategizing, Test Traceability and Test Planning

Good at Mentoring team members in various technical and process related issues and activity prioritization, effort & cost estimation, productivity, time & resource management

Experience in using JIRA, HPALM and Clear quest as bug tracking as well as Test management tool

Always Focused on customer satisfaction, process compliance, comprehensive business knowledge and user needs, proactive providing technical and test design solution; able to gain excellent credibility and relationship with clients.

Worked during various phases of testing life cycle that include Efforts & Resource estimation, Resource allocation within the team, Defect Triage, preparing Release end Test Reports, Test Metrics, Defect Tracking, Test Report generation, Production defect verification

Ability to work on multiple software systems, ability to quickly learn new technologies, adapt to new environments, self-motivated, team player

Technical Skills:

Testing Tools : Selenium Web driver, QTP/UFT, SOAP UI, Appium, Rest-Assured, Post man

Test Management Tools : HP ALM/QC, Rational Clear Quest,

Web Services : SOA, REST, SOAP UI

Programming Languages : Java, Java Script, VB script, C#, UNIX Basics.

RDBMS : SQL-Server 2000/2008, DB2, Oracle

Methodologies : Agile Scrum, Kanban, Waterfall

Build Tools : Maven and Ant

CI/CD and VCS Tools : Jenkins, Bamboo, GIT, TFS

Automation Frameworks: : BDD/ATDD (Cucumber), TDD, Data Driven, Keyword, Hybrid driven

IDE : Visual Studios, Eclipse

Unit Test Frameworks : Junit, TestNG

Domain Knowledge : Banking (Lending &Finance), Health Care, Insurance

Project Details:

Location – Minneapolis, Mn/ West Desmoines, IA. USA

Project Title : Provenir-Front end Credit Cards.

Client : Wells Fargo

Duration : Dec’2014 -Till Date

Environment : Java, Oracle, Eclipse Selenium Web Driver with TestNG/Junit framework, HP ALM, Maven, Jenkins, IT

Role : System QA Analyst-Automation, Test Lead, Test Co-Ordinator

Responsibilities

Business Requirement Analysis, Test Strategizing and Test Planning

Preparation of High-level scenarios and Test Case /Test Data Preparation based on requirements

Managed a team of 18 people in different geographical locations

Conducted GUI testing, user acceptance testing, integration testing and regression testing using web and client-server applications.

Practicing full facing AGILE methodology with SCRUM Meeting, Sprint Planning Meeting, and Sprint Review Meeting etc.

Involved in Automation Infrastructure Development using Selenium.

Identify and Design Automation cases using Selenium Web driver with Java and TestNG/Junit

Working on converting existing framework to Data Driven Framework with Page Object model (POM) with TestNG and MAVEN

Worked on different kind of Web Element locators like ID, Name, CSS Selector, Xpath for identifying the fields.

Execute the Test Scripts using Jenkins and maintain in GIT

Identify and Implementing BDD-Cucumber framework for Agile scenarios

Validated webservices/APIs using SOAP UI and Selenium Rest Assured.

Implemented Test Case Execution, Results analyzing, Defect reporting/Defect Analysis and Requirement Traceability matrix (RTM) preparation in HPALM/QC

Produced ALM and Excel metrics/reports from scheduled execution test runs.

Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology.

Staffing, Task allocation, Status reporting Managing/monitoring the QA a team, including monthly reviews and progression plans

Generating the detailed reports of the Bugs, Test Execution summary reports.

Work with Business and cross project teams in determining testing solution and validating requirements

Prepare estimations, release plan for future releases.

Preparing weekly and monthly status reports.

Mentoring team members in various technical and process related issues

Location – Hyderabad, India.

Employer : Infosys Ltd

Project Title : Asset Movement – Attach Paperwork

Client : Well Fargo

Duration : Sept 2013 to Nov,2014

Environment : Selenium, HP ALM and Clear quest, Unit, Java, Oracle

Role and Responsibilities

Business Requirement Analysis, Test Strategizing and Planning

Mentoring team members in various technical and process related issues

Worked as a QA Lead for a Team of 8 in a SCRUM/AGILE project

Developed tests using Cucumber by writing and Developed required Selenium support code in JAVA

Performed Cross Browser Automation using Selenium GRID with Sauce Labs Cloud Integration

Creating the Automation scripts based on the TFS User stories to ALM

Determine the scope of the overall QA team based on all the business demand, run the business maintenance work

Implemented Continuous Integration using Jenkins and GIT

Hands on testing various business rules User/Customer functionalities, and Change Processes

Configured ANT, Maven, Eclipse, Cucumber CI/CD configuration files

Performed functional test automation and execution using data driven framework with Page Object Model in Selenium Web Driver and used Apache POI for the implementation

Coordinated with developers and record defects in JIRA to track until they are resolved

Extensively used SQL queries to check storage and accuracy of data in database table

Developing advanced SQL queries to extract, manipulate, and calculate information to fulfill data that includes identifying the tables and columns from which data is extracted

Contributed in Hadoop pilot Project for Data Loading

Prepared user documentation with screenshots for UAT

Automated all the API test cases by using SOAPUI tool

Involved in extensive DATA validation using SQL queries and back-end testing

Employer : Infosys Ltd

Project Title : Claims Migration

Client : Blue Cross Blue Shield of Minnesota (USA)

Platform/Tools : WEB, ORACLE9i, QTP, ClearQuest, Quality Center

Duration : Nov 2011 to Aug 2013

Role and Responsibilities:

Business Requirement Analysis, Test Strategizing and Planning.

Task allocation, Status reporting and Project Billing

Effort estimation preparation for Automation and manual testing

Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica

Utilized HP ALM to track, report, and manage defect throughout the test cycle and attended Defect Status Meeting on daily basis during testing cycle

Configured and connected ALM with QTP and stored all the automated test scripts into ALM

Attended daily standup meeting as part of SCRUM activities

Developed scripts using Descriptive Programming to enhance optimum coding standard

Preparation of Test plan, Test conditions and Test Scenarios

Created the Backend testing and Validated the data in the database by running SQL queries

Tracking offshore the testing activities and sending weekly status report to the client

Preparation & Execution of test cases End to End and Regression testing for the Sales Force App

Documented and Executed test scripts and recording defects in ALM

Worked closely to the web performance testing team to assess the load testing using LoadRunner

Employer :Infosys Ltd

Project Title : NASCO

Client : Horizon Blue Cross Blue Shield – NJ (USA)

Duration : July, 2010 to Oct 2011

Role and Responsibilities:

Involves with Various Component leaders for bug fixing and status of bugs

Extracted data from various sources like Oracle and flat files

Created different BPT components for the wealth management system for the web sphere suite functionality

Used to analyze User stories to understand the system and Objectives of Agile Testing

Tested the data loaded into the Data Mart from the Data Source

Verifying verification points in data driven scenarios for BCBS healthcare

Performed Data Validation –using SQL (Toad)

Created scripts to load the more volumes of data into databases

Performed API testing (SOAP Web Services) using SOAP UI

Developed general and application specific functional libraries

Enhancing the Test Scripts for Global Execution through QC/ALM

Inter coordination between Implementation, BA teams and Client

Involved in Analyzing the Test Error Logs to find the root cause for the test failures

Employer :Patni Computers( Capgemini)

Project Title : IFSS – Renters Rate Quote

Client : GE-Fleet Services, Mn

Duration : July 2009 to June 2010

Role and Responsibilities:

Understanding test requirements and analyze them.

Creating Test Strategy, Test Plan, Status reports, Traceability matrix and Dash board.

Task allocation, Status reporting and Project Billing

Preparing and reviewing manual test cases from Offshore in QC.

Identify the test cases for automation.

Employer :Patni Computers( Capgemini)

Project : Delivery Assurance

Client : State Farm Insurance -IL

Duration : November 2007 to June 2009

Role and Responsibilities:

Creating Test Strategy, Test Plan, Status reports, Traceability matrix and Dash board

Understanding test requirements and analyze them

Worked at client place as Onsite -coordinator

Preparing and reviewing manual test cases from Offshore in QC

Identify the test cases for automation

Preparing automation test cases using QTP 9

Execution and bug reporting using Quality center

Preparing testing weekly status reports to Onsite

Ensure resolutions for day by day issues at offshore

Conducting ETL testing and data base verification manually as well as using automation tools

Employer :Patni Computers( Capgemini)

Project : SAP Regression Testing

Client : Rohm and Haas, PA

Duration : Aug’2005- May’2007

Role and Responsibilities:

To understand the SAP Functional transactions in various modules based on the Business flows of the client requirement.

To build the QTP scripts, enhance it, Parameterize the data and make the script Data-Driven

To use the Reusable Actions, Scripts, Functions to achieve the targets in the limited time

To prepare the various project delivery artifacts like Test Script Checklists, Comments in the Scripts for future understanding, Test Script documentation

To Execute of Test scripts for Regression testing monthly build/Support Pack/EHLS

Contact this candidate