Data Selenium

Pradeep Kumar Allie

Current Location: Phoenix, AZ

Phone: 409-***-****

Email: ***********@*****.***

Submission Summary

A professional Quality Assurance Analyst with over Eleven (11+) years of experience specializing in Quality Assurance Methodologies. Background includes:

Extensive experience in manual testing and automated testing of client server and web applications.

4 years of experience as a QA in Salesforce.com CRM application, mainly with Leads, Contacts, Accounts, Cases, Campaigns, Opportunities, Orders and Services entities

Experience working in an Agile/Scrum development framework.

Experience using SQL create data set and in Database Application Testing (SQL and PL/SQL). Experienced in Database Application Testing (SQL and PL/SQL).

Test cases execution using ALM/Quality Center/TFS/JIRA

Strong testing skills in Salesforce standard object, custom objects, custom fields, page layouts, custom Tabs, Reports and various other components as per application requirements.

Strong knowledge in Service testing

Interacted with other members of the team in delivery the project as per the schedule and budget.

Good knowledge in Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.

Have knowledge in implementing various advanced fields like Pick lists, Custom Formula Fields, Many to Many Relationships, Lookups, Master-Details, Field Dependencies, and Approval Processes for automated alerts, field updates & Email generation per application requirements.

Experience in building reports and dashboards, customizing them as per user requirements.

Have knowledge in implementing various advanced fields like Pick lists, Custom Formula Fields, Many to Many Relationships, Lookups, Master-Details, Field Dependencies, and Approval Processes for automated alerts, field updates & Email generation per application requirements.

Tested lookup and master- detail relationships on the objects and created junction objects to establish connectivity among objects.

Provide mentoring and guidance for an Agile approach to application development.

Performed data validation and mainframe testing in interactive mainframe environment.

Experience in creating Test Plans, Test Scripts, Test Logs, and Test Reports; extensively used SELENIUM.

Expertise in performing different kinds of testing like Smoke, Black Box, GUI, Functionality, Unit, Integration, Regression, Compatibility, System, Performance, Stress and User Acceptance (UAT) of web and client/server applications.

Experience using Selenium, SOAPUI in real time and unattended testing environments across multiple operating systems and technologies

Experience in testing web based and Windows Mobile applications.

Involved in web service testing API (SOAPUI & Postman) in a Selenium framework.

Responsible for testing API services using the Rest Assured Framework, Postman, and Soap UI, Ready API,Postman

Experience Testing Ecommerce Websites

Background using Test Director/ Quality Center, Mercury Suite Tools, Win Runner, Load Runner, and QA Load.

ITIL Change Management administration using TFS / Mercury Quality Center.

Experience with QA Methodology and QA Validations to ensure Quality Assurance Control.

Expertise in using the Quality Center, Team Foundation Server (TFS) for Defect Tracking, Organizing, Managing, Planning and executing the tests.

Recording test, debugging test, editing test-using VB Script, running and analyzing results.

Good knowledge of SDLC and Software Testing Life cycle.

Expertise in SQL Server database query language (TSQL)

Writing complex SQL queries and PL/SQL procedures to extract data from various source tables to perform database testing.

Core Qualifications

OP Systems: Windows NT/98/2000/XP/VISTA, Linux, and UNIX

Programming Languages: C, Java, VB, .Net, HTML, XML and SQL/TSQL

Databases: Oracle 7.X, 8i, 9i, DB2, Sybase & SQL Server 2000, SSIS

Automation Tools: SOAPUI, Selenium

Test Management Tool: Mercury Quality Center/Test Director, RALLY, TFS

Scripting Languages: JavaScript, VBScript, UNIX Shell and Perl, COBOL

Testing Methods: Unit, Integration, System, Smoke, Regression and UAT

Professional Experience

SR.QA Analyst/ Salesforce Tester/QA Lead

BANK OF THE WEST

Feb 2019 – Till date

Prepared traceability matrix for the requirements.

Ensured traceability between requirements and test cases for complete test coverage, defect management using Quality Center.

Test case execution using Jira/ALM.

Validated Data security and Sharing rules in Salesforce.

Tested Users, Profiles, Role hierarches and Permission sets as per user profile and Public group

Validated hundreds of reports and tested dashboard bases on roles and role hierarchies

Tested lookup and master- detail relationships on the objects and created junction objects to establish connectivity among objects.

Used Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.

Tested salesforce standard objects (Campaign, Accounts, Contacts, Opportunity) and custom objects, page layouts, fields validations and its access to the user based on defined profile.

Experience using SQL create data set in Database Application Testing (SQL and PL/SQL). Experienced in Database Application Testing (SQL and PL/SQL).

Performed Back end testing using SQL queries to access the main database

Involved in testing web services and XML with SOAPUI.

Performing the functional testing of individual API services

Edited, recorded scripts using Selenium.

Participated in Defect Review and status meetings.

Coordinating with Business Analysts, Project Managers, Infrastructure Team and Development Team in resolving various issues.

Worked on data driven and keyword frame works.

Coordinated patch releases/defects/fixes with the development teams.

Coordinated with other testing teams for Integration Testing.

Coordinated with BSA, Development, and Environment Management and Test Data Management teams.

Executed and documented various manual test results from regressive testing of each release.

Created data-driven tests to check application performance with different sets of data.

Used Mercury ALM to maintain test cases and execute test scenarios and log defects.

Execute the end-to-end testing to test the business flow from Mobile application to report generation.

Environment: JIRA, SQL, ALM, SOAPUI, UNIX, Eclipse, Jenkins, API Testing, Salesforce.com Platform, Apex, Apex Data Loader

SR QA Analyst/Salesforce QA/Automation QA

International Cruise & Excursions, Inc. (ICE)

MARCH 2018 – Jan 2019

ICE is Leading Provider of travel based Loyalty, rewards and incentive Programs and Provide access to broad set of leisure travel (cruise, resorts, air, car,hotels and tour) and leisure lifestyle activities (shopping,wine,dinning,golf,spa) coupled with an unparalled value proposition of both its partners and consumers. Though these travel and lifestyle Offerings, ICE dramatically enhances consumer engagements and the overall appeal of its partner brands

Understand functional and business requirements

Strong Experience in Java Programming, Selenium WebDriver and TestNG.

Writing Test cases using Element locators, WebDriver methods and Java programming features.

Experience working on Page Object Model with Page Factory in Selenium.

Strong testing skills in Salesforce standard object, custom objects, custom fields,

Thoroughly implemented the review process for the entire test planning deliverables (Test scenarios, Test Scripts and queries) by means of check lists, peer reviews and group reviews.

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security

Test effort estimation, test data creation, detailed Test Plans, Test traceability approach, defect management & configuration management approaches, Business sign off.

Test case preparation and execution

Test data setup using mainframes application

Review of all deliverables before sending for Onshore review

Ability to trace and classify issues and timely resolution of the same

Interact with client to clarify issues

Onsite / Offshore Co - Ordination activities

Prepared traceability matrix for the requirements.

Ensured traceability between requirements and test cases for complete test coverage, defect management using Quality Center.

Test case execution using TFS/Quality Center.

Experience using SQL create data set in Database Application Testing (SQL and PL/SQL). Experienced in Database Application Testing (SQL and PL/SQL).

Coordinated all the database changes to the development and test databases.

Developing automated testing systems using commercial tools (Selenium, scripts and data set.

Involved in testing web services and XML with SOAPUI.

Validating the functionality and performance of APIs under the load.

Participated in Defect Review and status meetings.

Coordinating with Business Analysts, Project Managers, Infrastructure Team and Development Team in resolving various issues.

Worked on data driven and keyword frame works.

Environment: Selenium, AWS, SQL, ALM, SOAPUI, API Testing, UNIX, SQL, MTM, Eclipse, Jenkins

SR. QA Analyst

Choice Hotels International

MARCH 2015 – FEB 2018

Involved with the Business and Development team to understand the requirements

Analyzed the existing business scenario and business rules.

Designed Test Documents, including Test Plan, Test Requirements, Test Cases and Test Procedures for functional and GUI testing.

Involved in the conversion of Manual regression test cases to Automation Test Cases.

Involved in Regression testing on each build during various phases of application.

Defect reporting and review of the defects with development team.

Identified key performance bottlenecks in the application and also performed end-to-end root cause analysis on these bottlenecks to pin point the reasons. Also presented my analysis in the reports to the client which was helpful in improving performance.

Set test strategy and work closely with team members to execute the plan.

Consulted with developers and clients about software system design and requirements.

Responsible for testing API services using the Rest Assured Framework

Provide mentoring and guidance for an agile approach to application development.

Performed Manual, GUI, Functional, Regression, and Smoke on Mobile device and Role based testing for SharePoint application.

Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports.

Strong Experience in Java Programming, Selenium WebDriver and TestNG

Environment: Rally, AWS,Java, Selenium, READY API, UNIX, SQL

SR.QA Analyst

Blue Cross Blue Shield of Arizona (BCBS)

April 2013 – December 2014

Understand functional and business requirements

Lead the offshore team and took the bottom-line responsibility of the project.

Checking the premium calculation using Excel Macros.

Test case preparation and execution

Ability to Identify defects and tracking till closure.

Test effort estimation, test data creation, detailed Test Plans, Test traceability approach, defect management & configuration management approaches, Business sign off.

Interact with client to clarify issues.

Onsite / Offshore Co - Ordination activities.

Prepared traceability matrix for the requirements.

Ensured traceability between requirements and test cases for complete test coverage, defect management using Quality Center.

Edited, recorded scripts using Selenium.

Participated in Defect Review and status meetings.

Coordinating with Business Analysts, Project Managers, Infrastructure Team and Development Team in resolving various issues.

Worked on data driven and keyword frame works.

Coordinated patch releases/defects/fixes with the development teams.

Coordinated with other testing teams for Integration Testing.

Coordinated with BSA, Development, and Environment Management and Test Data Management teams.

Executed and documented various manual test results from regressive testing of each release.

Created data-driven tests to check application performance with different sets of data.

Worked on Multiple SQL Concepts to extract the data Between Tables

Used Mercury ALM to maintain test cases and execute test scenarios and log defects.

Execute the end-to-end testing to test the business flow from Mobile application to report generation.

Environment: Selenium, SQL, Quality Center,Java, SOAPUI, TFS, UNIX, Load Runner, SSIS

QA LEAD/Sales Force QA

CalPERS, State of California –Sacramento, CA

January 2012 – April 2013

Ensured traceability between requirements and test cases for complete test coverage, defect management using Quality Center.

Test case execution using Jira/ALM.

Worked on Various Joins for data Extraction in SQL

Involved in testing web services and XML with SOAPUI.

Edited, recorded scripts using Selenium.

Perform Manual and Back-end testing using SQL

Participated in Defect Review and status meetings.

Coordinating with Business Analysts, Project Managers, Infrastructure Team and Development Team in resolving various issues.

Worked on data driven and keyword frame works.

Coordinated patch releases/defects/fixes with the development teams.

Coordinated with other testing teams for Integration Testing.

Coordinated with BSA, Development, and Environment Management and Test Data Management teams.

Executed and documented various manual test results from regressive testing of each release.

Created data-driven tests to check application performance with different sets of data.

Coordinated patch releases/defects/fixes with the development teams.

Coordinated with Other Testing Teams for Integration Testing.

Coordinated with BSA, Development, Environment Management and Test Data Management Teams.

Executed and documented various manual test results from regressive testing of each release.

Created Data-Driven tests to check application performance with different sets of data.

Performed Manual, GUI, Functional, Regression, and Smoke on Mobile device and Role based testing for Share Point application.

Environment: Quality Center, SOAPUI, TFS, QTP, Selenium, .Net, Manual Testing

QA Analyst

McKesson – GA

September 2011 – January 2012

Involved with the Business and Development team to understand the requirements

Analyzed the existing business scenario and business rules.

Designed Test Documents, including Test Plan, Test Requirements, Test Cases and Test Procedures for functional and GUI testing.

Involved in the conversion of Manual regression test cases to Automation Test Cases.

Involved in Regression testing on each build during various phases of application.

Defect reporting and review of the defects with development team.

Identified key performance bottlenecks in the application and also performed end-to-end root cause analysis on these bottlenecks to pin point the reasons. Also presented my analysis in the reports to the client which was helpful in improving performance.

Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures

Set test strategy and work closely with team members to execute the plan.

Consulted with developers and clients about software system design and requirements.

Provide mentoring and guidance for an agile approach to application development.

Performed Manual, GUI, Functional, Regression, and Smoke on Mobile device and Role based testing for SharePoint application.

Environment: Quality Center, SOAPUI, TFS, QTP, Selenium, .Net, Manual Testing

QA Consultant

Xansa India Pvt. Ltd.

DEC 2006 – DEC 2009

Generated test plans, test cases and test steps for manual testing through Test Director.

Analyzed the critical functionality and transactions in Siebel application.

Tested the GUI manually and automated the tests using WinRunner.

Conducted functional testing and verified the data retrieved from the database.

Performed data validation and mainframe testing in interactive mainframe environment.

Performed Multi-Threading on different hosts/clients on multi-operating systems using Test Director as online Bug tracking tool.

Involved in preparing Traceability Matrix for the functional requirements of the system.

Prepared test plans that included testing strategies, traceability matrix, test scripts and test data for integration, functional, user, security, load and stress requirements of the application.

Conducted Regression Testing on various builds of the application and reported the defects to the developers using Test Director for the bug fixing and tracking.

Wrote complex SQL queries using joins, sub queries and correlated sub queries

Attended performance meetings with developers and business analysts to review the testing.

Environment: WinRunner7.5, Test Director, Windows NT/98, SQL Server, UNIX

Education / Training

Masters in Software Engineering, ITU, Sanjose,California

Contact this candidate