SUMMARY:

• Around 6 years of experience in IT industry with an emphasis on Software Quality Assurance, GUI, System and Integration Testing, Functional/Regression Testing, Data Migration, Interface, Data Upload, Data Integrity/End to End testing of Web and Client/Server based applications
• Experienced in the creation of use cases and the development and maintenance of test specifications, test cases, test scripts and test data
• Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
• Performing data setup / testing of Rest services using Advanced Rest client and POSTMAN.
• Involved in validating SOAP UI specifications as per the standards.
• Exposure to both Manual as well as Automated Testing of Client Server as well as Web - based applications
• Experienced in using Test Management tools such as HP Quality Centre (QC)/Application Life Cycle Management (ALM), Rally, JIRA and Bugzilla bug reporting tools to track test progress, test execution and deliverables.
• Have good exposure to modern Agile methodologies such as SCRUM, TDD (Test Driven Development)
• Experience in working with Agile as well as traditional SDLC cycles.
• Experience in Functional, Data-driven, Unit, Integration, System, Front-End and Back-End Testing.
• Good understanding of all modules of Quality Center such as Requirements, Test Plan, Test Lab, Defects and Dashboard reports.
• Performed Back End Testing by executing SQL queries.
• Vast experience as a Defect Coordinator for large scale projects, responsible for Managing the Defect process for the project load and ensuring traceability to Requirements and Test Cases, via the respective Requirements and Defect Management.
• Experienced in various types of testing including Sanity Testing, Smoke Testing, Functionality Testing, Performance Testing, Volume Testing, Unit Testing, Integrated Testing, System Testing, Ad Hoc Testing, Positive and Negative Testing, Security Testing, Stress Testing, Load Testing and Regression Testing of Standalone, Web Based and Client-Server applications
• Proficient in both Manual and Automated Testing Tools such as Quality Center and TFS (Team Foundation Server).
• Performed User Acceptance Testing (UAT) Manually.
• Proficient in creating queries in TFS to validate results of TFS reports.
• Expertise in automating functional test cases, test data in XML standards and writing Test scripts using automation tools
• Experienced in SOAPUI/RESTFUL Web Services Testing. Validated request and response XML, SOAP and RESTFUL Web service calls.
• Have good exposure to modern Agile methodologies such as SCRUM, TDD (Test Driven Development)
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Excellent analytical, problem solving, presentation, and interpersonal skills.
• Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

TECHNICAL SKILLS:

Testing Tools: SOAP-UI, ALM Quality Center, TFS, MTM, POSTMAN

Project Methodologies: Kanban, Waterfall, Agile, SCRUM

Languages: C, C++, SQL, ASP.Net, Java, PL/SQL, Groovy, JSON

Web Technologies: HTML, XML, JavaScript, VBScript

Reporting Tools: Business Objects and Crystal Reports

Operating Systems: UNIX.LINUX, Windows, Mainframe

RDBMS: MS SQL Server, Oracle, DB2

Query Tools: TOAD, MS SQL Server Mgmt. Studio, My SQLBusiness Applications MS Office Suite - MS Word, Excel, PowerPoint, Outlook, MS Visio, etc.

PROFESSIONAL EXPERIENCE:

Confidential - West Chester, PA

QE API Tester

Responsibilities:

• Provided QA effort estimates for project iterations.
• Catalog API is used by Ticket Liquidator to get data from the database. Use POSTMAN to execute GET and POST on endpoints like Events, Performers, Categories, and Event Series, Payment methods, User info, cart, checkout etc.
• Analyzed the Business Requirement Document and various functional eDocs.
• Involved in testing WEB Services Testing (REST) for using SOAP UI and POSTMAN Wrote detailed Test Plans & Test Strategy Reports.
• Updated Automation Regression Suites to include latest functionalities.
• Involved in writing SQL queries to check the data integrity
• Performed functional testing of Web Services /XML /SOAP and Restful services using SOAP UI tool.
• Executed Test Suites to test the functionality of the application
• Validated WSDL, request and response XML added Assertions to validate the response xml in SOAP UI.
• Developed Test Strategy document
• Executed POST and GET Calls on Endpoints through POSTMAN.
• Wrote Automation Test scripts within POSTMAN tool.
• SOAP UI and POSTMAN collaboration.
• Developed Requirement Traceability Matrix (RTM)
• Wrote SQL scripts for Backend testing and Frontend Data validations
• Developed automation framework to test SOAP based Web Services using SOAP UI.
• Performed Regression testing mainly focused on critical paths
• Verified Database records by running queries and validated output of triggers.
• Used various aggregate functions through SQL queries in order to validate the data load in order to perform Backend Testing.
• Involved in testing of services using SOAP/REST services using SOAP UI.
• Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
• Created and Reported Defects using Test Manager and JIRA
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Testing APIs through POSTMAN
• Involved in performing the web services testing with SOAP UI by validating request and response for XML
• Performed Multi-browser testing
• Generate Burp reports and review Fortify reports
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database
• Perform REST APIs, Web & Database testing using POSTMAN.
• Wrote Release Test Plans for each iteration that are ready for release
• Performed Database testing using SQL queries
• Contributed to project Retrospective meetings & offered process improvements
• Performed End to End testing, System and Integration Testing

Environment: API, SQL, Oracle, JavaScript, REST API, Newman, Jenkins, Web-Services, POSTMAN, SOAP UI, ALM Quality Center, Agile, JIRA, etc.

Confidential, San Antonio, TX

Test Engineering Analyst

Responsibilities:

• Validated the DB information at the backend by writing and executing SQL queries.
• Using Agile methodology to come up with test scenarios and test cases.
• Worked closely with development team to resolve various issues.
• Documented the daily defect status using MS Excel on Share Point
• Developing and documenting test plans and procedures
• Involved in Database testing using SQL queries.
• Designed and maintained test schedules, test plan, test strategy, test assignment documents for various testing activities.
• Develops and executes test cases based on user stories contained within an Agile Sprint.
• Conducted extensive database testing, passing SQL queries to the Oracle using SQL Developer
• Performed Positive and Negative testing and End User Testing.
• Involved extensively in the Integration, Functional, Regression and CAT testing
• Prod validation experience.
• Created test cases for various modules in MS Excel
• Detecting software failures so that reported defects can be discovered and corrected within a timely manner.
• Participating in problem solving sessions.
• Participating in daily stand up meeting with the team
• Performing analysis to improve overall quality of work products and processes.
• Develop knowledge of application and client requirements
• Assist in functional design based on requirements.
• Test data preparation (script and data creation).
• Test execution. This involved end-to-end testing, including both data process/structures and reports
• Production Support: Analyze data and report results; Research and resolve production issues.

Environment: MS SQL Server, Datastax, UNIX, MQ Utility, MS Excel, Version One, Windows, Share Point, ALM/Quality Center, UFT.

Confidential, Chicago IL

QA Analyst

Responsibilities:

• Formulated detailed Test Plan, Test Cases and Testing Procedures, which included Test Cases/Scripts, capturing Test Results and capturing and resolving Test Anomalies.
• Use Agile systems and strategies to provide quick and feasible solutions, based on Agile system, to the organization
• Establish QTP and database connection for validation
• Involved in writing complex SQL queries to check the data integrity
• Performed negative and positive testing manually.
• Wrote complex SQL scripts for Backend testing and Frontend Data validations
• Performed Functional/Regression testing during the various phases of the application and analyzed the results using QTP.
• Executed test cases through Quality Center and reported defects in Quality Center.
• Used various aggregate functions through SQL queries in order to validate the data load in order to perform Backend Testing.
• Performed Regression Testing by executing QTP scripts based on the business process.
• Used XML (API) for transferring the data from the client to the server
• Developed and executed test cases test Scenarios and followed-up defects using Quality Center.
• Performed Usability and Integration testing manually.
• Automated the Back-End testing for reusability by writing Unix Shell Scripts.
• Performed data driven testing and parameterization using QTP
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database.
• Documented bugs found out during the process of testing.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database
• Tracked defects using Quality Center.
• Developed test scripts for the test cases in QTP for functional and regression testing.
• Worked with business users, business analysts and SMEs to understand different critical business processes.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.

Environment: Quality Center, QTP, Agile, Oracle, Toad, API, C#, XML, .Net, etc.

Confidential, Columbus, OH

QA Analyst/ Tester

Responsibilities:

• Conducted a walkthrough session of the scope document to ensure that the project sponsors and stake holders understand the project scope and any associated constraints, risks and issues as early as possible.
• Implemented test Management tools such as ALM and JIRA bug reporting tools to track test progress, test execution and deliverables.
• Used Quality Center bug tracking tool to analyze & capture bugs, track and manage dashboard any type of updates for project release.
• Created Detailed Test Plan, Test Approach, Test Matrix, Test Strategy documents based on the information gathered through business requirements and design/application walkthroughs.
• Analyzed user requirements and Prepared Test Plan, Test Scenarios and Test Cases using Quality Center and JIRA.
• Performed backend testing for data validation using SQL Queries.
• Prepared a package of Process Flow diagrams to document the existing system and used UML notations for Object Oriented Design and Documentation.
• Assisted designing and developing workflow diagrams for different modules using Rational Rose.
• Responsible for identifying gaps in the software between core functionality and user defined requirements.
• Created various test sets for different test cycles within Test Lab module of Quality Center and perform the test case assignment within Quality Center for offshore QA testers.
• Testing performed on a data warehouse platform, including data integrity and data validation.
• Performed Database testing using SQL queries.
• Tracking and documenting defects throughout the Bug Life cycle using JIRA.
• Assist and guide project teams to implement and document standards, procedures, artifacts, and plans consistent with QA and Test deliverables for the project team.
• Performed negative and positive testing using SQL Queries.
• Mentored QA Team by looking into different technical problems with development and helped them prioritize Testing tasks.
• Analyzed test progress and send weekly progress reports to the Project Manager
• Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.

Environment: MS Visio, Oracle, Quality Center, JIRA, MS Excel, MS Access, Agile, DB2, UNIX, MS Office