SUMMARY

• 7+ years of IT experience in Software Testing of modules involving Quality Assurance, Web based testing, Database testing and SQL
• Strong knowledge on QA Methodology and QA Strategy including Software Development Life Cycle (SDLC) and also experienced in working in Agile/SCRUM based environment
• Expertise in preparing Test Scenarios and Test cases based on the Business requirements
• Worked extensively in preparing Test effort estimates and Test plans
• Expert in analyzing requirements, understanding use - cases, preparing Test Plans and Test Scenarios, organizing Test Data, executing Test Cases and documenting Test Reports for both Manual and Automation testing
• Strong experience in Manual testing and HP Quality center
• Write automated test scripts to test data in Selenium Web Driver 5.x
• Expertise in Defect Analysis and Defect Management using HP Quality Center
• Strong working experience in Structured Query Language (SQL)
• Performed Keyword driven and Data driven testing using QTP 9.5, 10
• Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, Service Layer testing using Java and JUnit & User Acceptance Testing
• Hands on experience in performing Data-driven testing and Web Services using Soap UI 4.0
• Ability to learn new technologies and challenging concepts quickly, implement them and work under pressure
• Active involvement in Testing Documentation Reviews, Test Plans, Test Cases, Test Strategies, and Test Summary Reports
• Experienced in Java coding in a couple of projects and also wrote many java automated scripts for running automated tests for Web-service testing
• Experienced in the using Team Foundation Solution (TFS) for Task management and Microsoft Test Manager for Defect and Test life cycle
• Experienced in Java scripting and VB scripting as well using tools such as Selenium WebDriver, QTP etc.
• Mostly experienced in Black-box testing but also has in-depth knowledge on White-box testing
• Expertise in analyzing bugs, interacting with Developers, other Team members and users to debug the errors
• Worked on Onsite/Offshore model and coordinated with the offshore team to establish standards, templates, communication plan, reviews for effectively managing the project
• Collaboratively interacted with Project Leads/Teams
• Excellent organizational and communication skills
• Experienced working with Agile and Scrum methodologies in some of all the projects (mostly Agile) and also, experienced in SDLC and Waterfall methodologies
• Profound insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines
• Experienced in Front-end testing of GUI/Web UI manually and also using tools like SeleniumRC, SeleniumGrid & SeleniumWebDriver (3 vital components of Web-based testing using Selenium) and SOAP UI 5.x/4.x
• Experienced in backend SOAP XML with SOAP UI
• Hands on experience in Manual Testing, Application/Web service Testing and Database Testing
• Mentored new testers joining the team
• Experienced in using J-Unit framework along with some experience in using AJAX framework as well
• Ability to work independently and multi task without negative impact to timelines or quality
• Involved in UNIX file validation
• Performed backend testing in Oracle database and analyzed the log files for different error codes
• Wrote SQL, PL/SQL scripts to verify data in the Relational Database Management System (RDBMS), Data Analysis and back-end (table) testing and verify consistency with application UI
• Strong experience with MS Word, MS Excel for writing Test Plans, Test Cases and weekly status reports
• Experience in tracking testing progress and defects using Jira

TECHNICAL SKILLS

ETL: Ab Initio GDE 1.15, Co>Operating System 2.14, Informatica 8.6

Database Management: Oracle 10G, Teradata, SQL Server Management Server, TOAD

Scheduling: Maestro

Languages: C, Java, SQL, PL/SQL, T-SQL, UNIX Shell Scripting, VB

Operating Systems: Windows NT/98/2000, Windows 7/8, UNIX, DOS

Tools: & Utilities: TOAD, Teradata SQL Assistant 13.10, Oracle SQL Developer 3.0, Putty, Eclipse 5.0

Testing: HP Quality Center (QC)10.0, HP QuickTest Pro (QTP) 10.0/9.5, WinRunner 8.2, Soap UI 4.0, LoadRunner 8.0, Jira 6.1, Selenium Webdriver 5.x, Selenium IDE 1.10.0/ 1.9.0 , TFS (Team Foundation Server), Microsoft Test Manager, Microsoft Visual Studio. Performance Center 9.x/8.x/7.x

Java: Eclipse 4.x (juno), Eclipse 3.x

Performance tools: J-Meter, J-Profiler, Thread Dump Analyzer, Load Runner

Frameworks: J-Unit, AJAX

PROFESSIONAL EXPERIENCE

Confidential

QA Test Lead

Responsibilities:

• Attended the Business Requirement review meetings conducted by BA team in Agile methodology to better understand the application functionality and to make the Mapping document to create the Test Plan and Test Scenarios
• Wrote queries to execute Count, Data and Duplicate validations on the tables loaded and report bugs to the DEV team and Product Owners when found any.
• Received many appreciations for finding many bugs in the loaded and their causes and helping them get fixed and also, for maintaining excellent documentation information for the bugs created for quick and easy understanding purpose
• Worked with many Plans (client) to MTM and helped in scheduling trips to medical facilities etc., for members, dealt with the providers of different plans etc.
• Performed Smoke, Functionality, Incremental and Regression tests based on Analysis, and understanding of system requirements, non-functional specifications, and end-user needs
• Wrote test scripts in TFS (Team Foundation Server) and executed them in Microsoft Test Manager
• Write automated test scripts in Selenium Web Driver and Automated test engine and also, record and play back already recorded test scripts in Selenium IDE
• Also, helped automate the test cases after 2-3 Sprints with the help of a tool called Automated test engine developed by the DEV team and helped test it and identify many issues that were occurring using this tool
• Used Load Runner for performance testing of web applications
• Experienced in creating the functional testing framework using J-Unit and used SeleniumWebDriver and RC for writing Automated Scripts with Java
• Also, used QTP for automation Web-service testing in only limited scenarios in the project but majorly depended in Selenium WebDriver for automation
• Attending Daily Stand-up calls and discussed any road-blocks or any questions with the DEV team and help them identify the bugs raised during testing and help them resolve those bugs
• Attended Sprint review and planning meetings at the end of every 2-3 weeks and represented QA testing team and discussed the testing status, road-blocks for testing and other ambiguities or discrepancies occurred during testing
• Did manual and automated Application/Web service testing; automated web service and SOAP UI 5.0.0
• Worked closely with the DEV team and wrote extensive queries in SQL to test the tables and analyze the table data when any test cases failed and find out the occurrence of the bug
• Also, worked in writing post deployment scripts for loading some static tables using SSIS which load the tables at the starting of every load
• Created test data using Unix
• Also, wrote automated test scripts by Java scripting and did some coding using Java and helped save time in an automated fashion
• Helped resolve many testing issues and also initiated in creating a mapping which was basic for an ETL project but was missing in the DI project

Environment: SSIS 2013/2012, SSDT 2012/2010, Ab Initio GDE 3.1.2, Co>Operating System 3.1.3, SQL Server Management Studio 2012, FileZilla, TFS (Team Foundation Server), Microsoft Test Manager 2012, MS Office, MS Access, Selenium Webdriver 5.x, Selenium IDE 1.10.0, Eclipse 4.2, JMeter, SOAPUI 5.0.0, J-Unit, CSS, HTML, QTP 10.0

Confidential

Sr., QA Tester

Responsibilities:

• Performed Smoke, Functionality, Integration, Ad-hoc, System, and Regression tests based on Analysis, and understanding of system requirements, non-functional specifications, and end-user needs in Agile environment
• Played the key role in preparing test strategy, test plan
• Developed, Enhanced, and Maintained automated testing scripts with Quick Test Pro (QTP) for Data Driven Tests.
• Verified data stored in the database using SQL queries
• Tested Application/Web-services manually and also automated them after a point of time using Selenium IDE and SOAP UI
• Documented test cases, test results and defect reports using Quality Center 9.2 and used SOAP UI to test the web services
• Utilized Quality Center to write and execute test cases and report defects
• Experienced in using Selenium IDE to record test cases and Selenium RC for cross browser compatibility
• Understood the Agile methodology followed by the client and help newcomers understand it better
• Involved in Functional, GUI, Unit testing and performance testing
• Experienced in Functional testing by writing Data Driven Test scripts and also, running these scripts for Message processing, Registration, and Reports testing using QTP
• Supported in providing post release support and analysis of the application
• Provided Production support from ETL team and created numerous instant Ab initio graphs to solve any errors
• Wrote SQL queries for retrieving and loading data into the tables, checking data in the tables, inserting, updating and deleting records from the tables
• Involved in the Functional design and Quality Analysis of the project
• Provide status reports (Weekly and also daily) to Manager and review boards on the development project
• Ensure compliance of all work within the deadline and conduct appropriate test reviews as necessary
• Experienced in automation testing for different applications in the same project using Selenium WebDriver (using Java scripting) and QTP (using VB Scripting)
• Helped the team in some coding using Java and helped solve many problems which were caused because of some web pages not loading properly
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction
• Write test scripts by Java scripting techniques using J-Unit testing Framework in Selenium WebDriver and execute the test scripts for Web-based testing
• Used Ab Initio for Quality Analysis, Error Handling by attaching files error and reject ports on each transformation and making provision for capturing and analyzing the error data and message in detail

Environment: Pervasive Data Integrator 9.0, Ab Initio GDE 3.1.2, Co>Operating System 3.1.3, Teradata SQL Assistant 7.1 (with 13.0 Teradata ODBC drivers), Putty, WinSCP, Oracle10g, SQL, QTP, QualityCenter 10, Jira 6.1, Eclipse 5.x, Selenium Webdriver 5.x, Selenium IDE 1.10.0, Eclipse 4.2 (Java), JUnit, JMeter, CSS, HTML

Confidential

QA Tester

Responsibilities:

• Reviewed the Business Process to understand the Project details
• Planning QA Test cycles for all the modules in project
• Generated test plans and test lab setup in HP Quality center
• Write and modify several application specific Config scripts in UNIX in order to pass the Environment variables
• Coded some of the important vital code in Java in Eclipse tool
• Using Teradata SQL Assistant (for running SQL queries), we verified our data
• Uploaded detailed level test cases from Microsoft Excel to HP Quality center
• Logged and tracked defects to closure in HP Quality Center
• Generated reports in HP Quality Center and tracked daily defect status reports
• Identified and created test data for all the modules involved
• Tested Application/Web services using Selenium IDE, RC, WebDriver and SOAP UI
• Created SQL queries to verify the Test Results using Toad
• Check the status of source and Confidential tables in the specified database, used in the Ab Initio graphs by running SQL queries in the Teradata SQL Assistant tool
• Conducted defect review meetings
• Unit testing is done to ensure the code is designed and is functioning according to the Design Specifications document
• Conducted domain knowledge transfer sessions
• Prepared knowledge base documents for the projects
• Modified already existing Java program coded projects, for better understand and also reduce redundancy and help re-establish many parts of the code which fell apart
• Analyzed and worked on the trouble tickets (TT) raised
• Wrote many automated Java scripts, executed them and returned the test results to the testing team
• Also, experienced in doing functional (data-driven) and regression testing using QTP and writing VB scripts using it
• Developed test matrices to trace various requirements and scenarios to appropriate test scripts
• Identified and created test data

Environment: Ab Inito GDE 3.1.4, Co>Op 3.1.3, Oracle10g, SQL, QTP, QualityCenter 10, Jira 6.1, Eclipse 5.x, Selenium Webdriver, Eclipse 4.2 (Java), Selenium IDE, TOAD, Teradata SQL Assistant tool, JMeter, J-Unit, CSS, HTML

Confidential

QA Tester

Responsibilities:

• Attended the Business and Functional Requirement Document (BRD) review meetings conducted by BA team to better understand the application functionality and to gather Functional requirement Document (FRD) to create the Test Plan and Test Scenarios
• Analyzed the user requirements, functional specifications and Use Case documents and created the Test Plans, Test cases for various modules of MSR Planogram
• Developed Test Cases after analysis of the Business requirements and Business use cases for various modules of the application based on the SDLC methodology followed by the client
• Understanding of Test Methodologies and Test plans based on BRS
• Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly or not
• Responsibilities include interacting with the development team and requirements team and communicate the related issues
• Involved in Functional, Unit, GUI/Web UI and Regression Testing
• Used SOAP UI to test the Application/web services
• Design and Execution of Test Cases for both positive and negative scenarios
• Involved in unit testing different parts of the source to determine if they are fit for use, valid meeting the design specifications
• Interacted with Developers for assisting them in the Identification, Simulation, Resolving and Tracking of problem events
• Ensure compliance of all work within the deadline and conduct appropriate test reviews as necessary
• Experienced in writing Java scripts and executing those scripts to test the web-services
• Also, experienced in writing VB scripts for executing them using QTP
• Knowledge in relational database concepts like Tables, Primary and foreign keys, Views and Referential Integrity.
• Proficient in the data manipulation using SQL for the retrieval of data from the relational database (inner joins, outer join, group by, order by etc.)
• Used Quality Center as a repository for maintaining test cases, execution and tracking the defects
• Used Clear Case version control system to keep track of different versions of the test scripts
• Check the status of source and Confidential tables in the specified database, used in the Ab Initio graphs by running SQL queries in the Teradata SQL Assistant tool

Environment: Ab Initio GDE 3.0.1, Co>Op 3.0.0, Quality Center 10, SQL, QTP, HP Load runner, Citrix, Soap UI 4.0, windows XP/Vista/7, IE 6/7/8, Jira 6.1, Eclipse 5.0, Selenium Webdriver 5.3, Selenium IDE 1.9.0

Confidential

QA Analyst

Responsibilities:

• Performed Smoke, Functionality, Integration, Ad-hoc, Unit, System, and Regression tests based on Analysis, and understanding of system requirements, non-functional specifications, and end-user needs
• Played the key role in preparing test strategy, test plan
• Developed, Enhanced, and Maintained automated testing scripts with Quick Test Pro (QTP) for Data Driven Tests according to the SDLC methodology followed by the clients
• Developed and executed manual test cases based on user requirements and technical specifications
• Involved in Unit testing and making sure that every part of the source is valid and if fit for the job according the requirements
• Verified data stored in the database using SQL queries
• Documented test cases, test results and defect reports using Quality Center 9.2 and used SOAP UI to test the Application/web services
• Utilized Quality Center to write and execute test cases and report defects
• Interacted and worked with the development team in successfully solving the issues occurred in the test run
• Unit testing is done to ensure the code is designed and is functioning according to the Design Specifications document
• Involved in Usability, Functional, GUI and performance testing
• Participated in weekly and monthly review sessions
• Supported in providing post release support and analysis of the application

Environment: Java, J2EE, HTML, XML, Quality Center 9.2, SQL, QTP, HP Load runner, Citrix, windows XP/Vista/7, IE 6/7/8, Soap UI 4.0, Selenium IDE 1.9.0

Confidential

QA Engineer

Responsibilities:

• Reviewed the Business Process to understand the Project details which was Waterfall methodology
• Designed and generated test scenarios, test cases and test data. Successfully executed tests and created defect reports using Quality Center 9.2
• Developed Test Strategies and performed Automated, Manual testing of the application
• Developed test scripts for Corporate Load testing activities using VuGen
• Conducted tests to ensure maximum compatibility of the application to various Windows platforms
• Used QTP to run the existing scripts and also write new VB scripts
• Centralized and managed the testing process using Quality Center 9.2
• Ensured that the application supports the Business Logic by conducting end -to-end testing in the UAT lab for Performance and Regression testing using HP Performance Center and QTP
• Closely monitored progress through testing life cycle and reviewed documentation
• Coordinated and worked collectively with other team members to effectively categorize and report bugs, issues, risks in order to meet the QA testing targets
• Participated and supported User Acceptance Testing and Unit testing to make sure every individual part of the code is working and is fit

Environment: Ab Initio GDE 2.1.9, Co>Op 2.1.8, Quality Center 9.2, SQL, QTP8.2, HP Load runner, Citrix, Selenium IDE 1.9.0

Confidential

ETL Tester

Responsibilities:

• Working as an ETL tester for this project with 8 offshore and two onsite resources
• Reviewed the Business Process to understand the Project details
• Planning QA Test cycles for all the modules in project
• Involved in preparing a detailed test plan constituting project scope, environment, resources, approach, data preparation, and result analysis and test project deliverables and followed SDLC methodology
• Drafted test cases based on functional specifications
• Bug Tracking and Reporting using Quality Center
• Coordinating with developer for issues
• Involved in Manual Testing of the application
• Identified defects and logged defect reports using Quality Center
• Carried out Application/Web-service testing, Data warehouse testing by creating and executing SQL queries and unit testing where individual parts of the developed code were tested whether they are fit
• Run the queries for the corresponding validations in Teradata SQL Assistant and update the error free queries in QC under the corresponding project
• Pass the test cases in the QC tool, when queries are run successfully according to the expected results or raise defects in the QC, when the results do not match the expected results
• Responsible to daily meet Developers and Business Analysts to analyze various Bugs
• Write various VB scripts using QTP and executing those scripts for automation functional and regression testing
• Performed Data Driven Tests to automate the data input in the specific fields of the application
• Provide status reports (Weekly and also daily) to Manager and review boards on the development project

Environment: Informatica 8.6, Quality Center 9.2, SQL, QTP8.2, HP Load runner, Citrix, Selenium IDE 1.9.0

Confidential

ETL Tester

Responsibilities:

• Actively participated in different stages of Project Life Cycle (User Requirement and System Specification gathering, designing, coding, testing, and maintenance) which was Agile methodology
• Supported efficient Data Insertion, Manipulation, and Retrieval using various Joins, Indexed Views, Stored Procedures, and Functions
• Managing and configuring logins to SQL Server, database user accounts, permissions
• Executed tests and tracked bugs through resolution in all the testing cycles
• Analysed the mapping document received from the Ab Initio Development Team
• Wrote SQL queries for Count, Data, Duplicate and Structure validations and executed those queries in Teradata SQL Assistant and performed unit testing to ensure code is meeting requirement specifications and is fit for use
• Passed the test cases which executed successfully and raised defects for the test cases which would not execute
• Confirm the test cases which failed with the records from the error log and reject log and then raise defects
• Interacted with the onsite team which monitor the work done
• Received appreciation mails from Clients and On-site team regarding the work done
• Made changes in the Software Specifications document when found any
• Provide status reports (Weekly and also daily) to Manager and review boards on the development project
• Knowledge in relational database concepts like Tables, Primary and foreign keys, Views and Referential Integrity.
• Proficient in the data manipulation using SQL for the retrieval of data from the relational database (inner joins, outer join, group by, order by etc.)

Environment: Informatica 8.6, Quality Center 9.2, SQL, QTP8.2, HP Load runner, Citrix, Soap UI 4.0