SUMMARY:

• Over 5+ Years of IT Experienced in Prepared documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
• Good testing experience in Insurance and Banking domains.
• Excellent understanding of the Agile Software Development Life Cycle (SDLC), STLC, DEVOPS and the role of Quality Assurance, RUP and Agile Methodologies, Agile PLM
• Experienced developing Test Plans, Test Cases, Test strategies, Test Scripts, Test Matrix and Conducting manual and Automated testing of functionality, compatibility, reliability, usability, installation, Performance, security and related test methodologies for System, Functional, Structural, Integration, User Acceptance and Regression testing of application (s) in Web, Java, SOA, Client - Server and Mainframe environments.
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data.
• Performed Back End Testing by executing SQL queries.
• Excellent understanding of product lifecycles (PLC) with primary focus on requirements definition, documentation and systems design validation to ensure that the project deliverables are implemented
• Extensively worked with Relational Database Management Systems (RDBMS) including Oracle, MS SQL, DB2 and MS Access.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Solid understanding of STLC, SDLC & DevOPs

TECHNICAL SKILLS:

BUG REPORTING: ALM/Quality Center, CQTM, Clear Quest, JIRA

REQUIREMENT MGMT TOOLS: Caliber RM, Rational Requisite Pro

PROGRAMMING LANGUAGES: PL/SQL, TSL (Test Script Language), VB Script

RDBMS: Oracle, MS Access, SQL Server, DB2

OFFICE SOFTWARE: MS Office (Word, Excel, PowerPoint)

OPERATING SYSTEM: Windows, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, VA

QA Analyst

Responsibilities:

• Analyzed User and Business Requirements for the new requirements.
• Compared the New Build with the old Build to modify the test plans for positive and negative scenarios for Functional Testing.
• Created Manual Test cases.
• Involved in entire QA Life Cycle which included Test Designing and Execution of the entire QA process.
• Interacted with Development and Design teams to design and plan the Test Plans.
• The whole application tested manually.
• Used Quality Center to track and report defects to developers.
• Kept track of the bugs, deciding their priority and then assigned them to the different developers through Quality Center.
• Conducted testing manually.
• Attended status review meetings, interacted with developers, Architects to resolve the issues.
• Worked together with BA's to analyses Functional Requirements for the new requirements.
• Performed Manual Testing and Defect Tracking with Sr. QA analysts for the application, and Prepared Test cases and tested on multiple browsers like IE, FF, Chrome, and Safari with versions approved by client.
• Responsible for testing the web based application on different platforms like Windows, Mac, Linux operating systems.
• Worked with Business analysts in creating business use case, user requirement document (URS), functional (FRS) and technical documents.
• Tested for data in the database by writing SQL queries for SQL Server before testing the module
• Generated various defect reports for stakeholders.
• Was responsible for testing status update during project status meetings.
• Test Director to house all test documentation and report/track all issues and defects
• Interface testing by comparing flat files from the exchange information against application.
• Analyzed test results to ensure existing functionality and recommend corrective action where necessary.
• Swift Protocol Transactions were identified and validated them.
• Designed, documented, built user interfaces for, and constructed queries for large-scale databases in both Microsoft Access and SQL Server.

Environment: SQL plus, VB Script, MS Visio, XML, MS Outlook, Quality Center, Agile, SOA, Oracle, Etc

Confidential, WI

Sr. QA Analyst

Responsibilities:

• Written test cases to test the application manually in Excel, ALM/Quality Center.
• Written Test Cases By using Excel and ALM/Quality center.
• Manually executed test cases for the functionality testing and security testing using ALM/Quality Center
• Performed rigorous manual testing such Functional Testing, Smoke testing, Integration testing, UAT Testing, Backend Testing, Regression Testing, End to End Testing and System Testing
• Used Caliber & ALM as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Defect Management.
• Testing Type Involved: User Acceptance Testing, System Integration Testing, Functional Testing, Regression Testing, Security Testing
• Written SQL scripts for performing data validations
• Performed Smoke, Integration, Positive, Negative, and Security Testing manually as well execute nightly automation from Jenkins.
• Responsible for testing all new and existing ETL Data Warehouse components from DevOPs pipeline.
• Performed Data Profiling of current state of data in the Data Warehouse from Jenkins by doing Data Analysis using Automated test scenarios for GUI, Functionality and performed data driven testing on the application inserting different data in excel sheet using QTP during Jenkins runtime.
• Create departmental reports utilizing MS Excel and pivot tables as requested by management.
• Managed various testing activities throughout the Software Testing Lifecycle (STLC) for multiple projects Performed Backend testing for data validation using SQL Queries.
• Performed backend testing to validate the data using SQL queries
• For Security Testing, ensured entrance and exit criteria for the QA test phases are completed
• Written complex SQL queries for querying data against different database for data verification process.
• Defects identified in testing environment where communicated to the developers using defect tracking tool.
• Created and executed test cases for Enterprise Data warehouse and Data Marts for different stage of testing
• Tested a number of complex mappings, mapplets and reusable transformations for daily data loads.
• Involved in User Interface, Functionality, Smoke, and Security testing.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using ALM/Quality Center.
• Conducted GUI, Backend, Data Driven and Security Testing and regression testing on new builds/versions.
• Worked with ETL group for understating mappings for dimensions and facts.
• Performed Database testing using SQL queries
• Extensively performed manual testing and defect reporting using ALM/Quality Center.
• Writing complex SQL and PL/SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Manage the testing process, schedule batch tests, log and track defects using ALM/Quality Center.
• Well versed with Frontend and Backend testing in MS-SQL Server, Oracle and MS-Access using SQL Queries for data verification.
• Using agile methodology and engage in an iterative workflow and incremental delivery of working software.
• Executed automated test cases in QTP and reported defects in ALM/Quality Center

Environments: ALM/Quality Center, Java, J2EE, HTML, Oracle, MS SQL Server, ETL, Data Warehouse, HTML, XML, DB2, MS Share Point, QTP, Agile, Security Testing, SOA Etc

Confidential, Bloomingdale, IL

QA Tester

Responsibilities:

• Job operated within a very agile environment, employing 2-4 week sprints, daily scrum meetings, burn-down charts, task weighting, pair programming, refactoring, presentations and review.
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Worked extensively on web-based testing and involved in UAT environment, pre-production environment and production environment
• Prepared various test reports from Quality Center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.
• Created test cases for various modules in MS Excel and exported them to Quality Center for Test Case Management.
• Executed the Test Scripts in Quality Center.
• Defects are logged using Quality Center and follow up with Business and Developers to discuss about the issues.
• Actively participated in Walkthroughs and Daily status report meetings.
• Agile methods are used to reduce overheads, such as, rationale, justification, documentation and meetings, keeping them as low as is possible.  And, that is why agile methods benefit small teams with constantly changing requirements, rather more than larger project.
• Generated and published various Daily and Weekly test status reports during the test execution phase of STLC.
• Conducted and participated in the Bug Review meetings to identify, analyze and drive the issues towards resolutions based on the business severity.
• Preparation of Requirements Document, AGILE Story cards, etc
• Tested for data in the database by writing SQL queries for SQL Server before testing the module
• Generated various defect reports for stakeholders.
• Was responsible for testing status update during project status meetings.
• Test Director to house all test documentation and report/track all issues and defects
• Interface testing by comparing flat files from the exchange information against application.
• Analyzed test results to ensure existing functionality and recommend corrective action where necessary.
• Swift Protocol Transactions were identified and validated them.
• Designed, documented, built user interfaces for, and constructed queries for large-scale databases in both Microsoft Access and SQL Server.
• Create test data schemas for XML interface test.

Environment: SQL plus, VB Script, MS Visio, XML, MS Outlook, Quality Center, Agile, SOA, Oracle, Etc