SUMMARY

• 8 years of IT experience in testing and providing Quality Assurance (QA) services for Web - based applications, Client-Server applications, Business Intelligence applications, Data Warehousing, Healthcare, eCommerce, Retail and Financial applications.
• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Experience on Functional Testing, System Testing, Regression Testing, Integration Testing, GUI/ Web-based Testing, Database Testing, System Integration Testing (SIT), Certification Testing, UAT (User Acceptance Testing), Smoke Testing, Browser Compatibility Testing, Black Box Testing, and Performance Testing.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, Test Summary Reports, QA Health Reports, and Weekly Status Reports.
• Has working experience in Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Good experience in writing Test Plans, Test Strategy Documents, Test Catalogs/Scenarios and Test Cases/Test Scripts based on business requirements, rules and system specifications.
• Has hands-on experience in eCommerce applications testing.
• Has hands-on experience in API testing and interfaces testing.
• Has hands-on experience in ETL Testing.
• experience in testing Mortgage applications.
• Has hands-on experience in Web Services testing using SOAP UI.
• Has hands-on experience in Performance Testing using LOAD UI.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification, Data Mining, Data Mapping and identifying Data Mismatch.
• Involved in both Front-End and Back-End QA processes.
• Extensive experience in writing SQLscripts from scratch to validate the data according to the technical and functional requirements.
• Has good experience working wif HP Quality Center/ALM, Jira, Microsoft TFS and Rational Clear Quest for Test/Defect Management activities.
• Expertise in Testing BI Reports including dashboards, summary reports, master detailed, drill down and score cards according to the report specification documents.
• Extensively worked on Autosys (Batch Scheduling Tool) to run and monitor scheduling jobs.
• Has experience working wif Star Schema, Snowflake Schema, FACT, Dimension, Physical, Logical, Change Data Capture (CDC) and Slowly Changing Dimensions.
• Having experience inDataConversions (migratingdatafrom legacy to new system).
• Familiarity wif lifecycle of software development and UAT.
• Good understanding of eCommerce development lifecycle and project documentation.
• Immense ability to assess results of tests and communicate through daily updates.
• Remarkable ability to implement test methodologies and audit these on regular basis.
• Excellent problem solving, troubleshooting and debugging skills.
• Good at documentation, communication and interpersonal skills. Quick learner wif an aptitude of taking responsibilities.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows Family, Linux, HP-UNIX, Solaris UNIX, IBM-AIX, Microsoft-DOS, Apple iOS

Programming Languages: C, SQL, Java, XML

Scripting Languages: Unix Shell Scripting, VB Script, Java Script

DBMS: Oracle 11g/10g/9i/8i, DB2, Microsoft SQL Server 2016/2014/2012/2008

DBMS Tools: TOAD, Rapid SQL, Microsoft Management Studio, Oracle SQL Developer

Test Management Tools: Mind Mapping Tools

Defect/Bug Tracking Tools: IBM Rational Clear Quest, Jira, HP Quality Center/ALM, Microsoft Visual Studio

Other Testing Tools: SOAP UI, LOAD UI

Version Control Tools: Clear Case, Requisite Pro, Microsoft Share Point

Incident/Change Management Tools: BMC Remedy, Ticket Tracker

Automation Testing Tools: HP Quick Test Pro (QTP)

Data Modeling Tools: Erwin, MS Visio

Job Scheduling Tools: Autosys

ETL Tools: Informatica Power Center, SSIS

BI/Reporting Tools: Cognos Reports, Tableau

Other Tools: PuTTY, WinSCP, TextPad, SnagIT, XML Spy, Rally, Notepad ++, CompareIT

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. QA Analyst

Responsibilities:

• Responsible for the Functional testing (prepared Test Catalogs, Test Cases/Scripts) for the entire application; and was also responsible for performing Regression testing.
• Involved in writing Test Cases based on User Stories defined in different Sprints.
• Actively participated in sprint meetings such as Daily Standup meetings, Sprint Planning, Backlog Grooming, Sprint Demos and Sprint Retro.
• Involved in end-to-end testing for the entire eCommerce application.
• Planned, executed and maintained test scripts and programs.
• Reviewed execution progress of test initiatives to trace negative impacts.
• Coordinated wif agile developers to create new solutions and improve existing ones.
• Checked new software to ensure these meet business needs.
• Responsible to verify Web services API request, response data validations in REST, SOAP protocols. Performed API Testing wif Postman and Swagger.
• Worked wif transactions and validated the data by using SQL.
• Responsible for creating Test Environment for Web Services testing.
• Tested design documentation in terms of stated requirements.
• Maintained and updated reports on results of quality tests.
• Performed compatibility test using different browsers, tablets and mobiles.
• Created and reviewed test cases, conditions and scenarios. Developed estimates for all relevant test activities.
• Ensured its successful implementation of the test plans, design and test cases.
• Gatheird and confirmed test data.
• Reported defects, and escalated issues.
• Generated test logs, and documented & verified test results.
• Developed User-Acceptance Test cases and assisted Business users in conducting UAT.
• Created test scripts and supported business teams during UAT.
• Identified high priority functional areas for UAT and prepared Test Bed for UAT.
• Involved in UAT and worked closely wif UAT Business users to make them understand system functionality.
• Heavily involved in UI testing and written test cases for GUI validation for both positive and negative scenarios.
• Assisted in generating post deployment scripts and UAT scripts for users.
• Interacted wif the Developers and BA for defects and problem resolution.

Environment: Microsoft SQL Server 2016, SQL, XMind, MindMeister, Microsoft Visual Studio, Microsoft Test Manager, XML Files, EDI transactions, Web services, SOAP UI, API Testing wif Postman and Swagger, Microsoft Azure API Management portal.

Confidential, Arlington, TX

Sr. QA Analyst/Web Services/GUI Tester/UAT

Responsibilities:

• Worked as a UAT Tester and prepared Unit Test Plan, Test Strategy, Test Catalog, Unit Test Cases/Scripts according to the user requirements and business specs.
• Involved in Defect Triage Process wifin the Scrum Team (Agile).
• Updated UAT status to senior management, cross-functional Business Teams across the organization.
• Coordinated wif the test data setup team to ensure that the required test data is setup before the business users start UAT.
• Coordinated wif technical teams for UAT blocker defects.
• Conducted UAT & Demo sessions wif users after successful resolution of major defects for each release.
• Validated UI screens, GUI objects, GUI events, GUI representations according to the business requirements documents and systems requirements.
• Validated the data on screens against the database.
• Tested Web Services: i.e. validated Request and Response times, SOAP Calls, Restful calls and WSDL using SOAP UI tool.
• Performed functional testing of web services using SOAP UI.
• Performed System Testing, Database Verification testing and Regression testing and Smoke Test execution after every new build.
• Performed Regression testing after each build is released.
• Tested XML reports using SOAP UI.
• Validated Web Services request and response XML using SOAPUI tool.
• Created SQL Queries to retrieve the data from different tables to perform Back End testing on Database.
• Prepared Test Data for SIT and UAT Testing.
• Created automated Load test scripts using Load UI.
• Performed Load testing using Load UI and documented the test results.
• Tested and Reported Bugs/Defects in product releases and performed the Root Cause Analysis for the Defects raised.
• Coordinated test execution efforts such as test data and support team provision, defect tracking and management, ensuring resolution of testing issues.
• Conducted backend testing by querying databases.
• Prepared Weekly, Monthly QA status and QA metric reports.
• Analyzed root cause investigation for the broken links.
• Provided support and training to users during UAT.

Environment: Agile Scrum, UAT, HP ALM, Jira, SOAP UI, LOAD UI, XML Spy, Web Services, XML Files, HP QTP, Oracle 11g, Rally, TOAD, UNIX, Tableau Dashboards, Tableau Reports, FTP client, TextPad, Clear case, Clear Quest, SQL Server 2012.

Confidential, Buffalo, NY

ETL QA Tester / BI Reports Tester

Responsibilities:

• Generated Bug Reports and Test case coverage reports for status meeting and also involved in resource planning for test cases coverage
• Involved in Bug Review meetings and participated in weekly meetings wif management team.
• Performed regression testing by repeated execution of test cases in each build by logging defects using Jira.
• Involved in writing SQL Queries using TOAD to validate the backend data.
• Involved in validating ETL jobs according to the data mapping requirements.
• Involved in validating BI Report and Dashboards according to the report specification documents.
• Validated the data on web screens against the data points and database.
• Maintained Metrics participated in weekly status updates showing the progress of the testing effort and open issues to be resolved.
• Perform end-end testing of Web Services.
• Provided test results, test summary reports and weekly status reports to QA Manager.

Environment: Informatica Power Center, IBM Cognos Reports, SQL, TOAD, Oracle 10g, HP Quality Center, XML Files, Rally, Agile/Scrum.

Confidential, McLean, VA

ETL QA Analyst / Functional Tester

Responsibilities:

• Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
• Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments which would account for durations, constraints, assumptions, etc. that are required to accomplish test objectives.
• Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
• Involved in obtaining Test requirements from the Business Users for new change requirements and enhancement request.
• Being part of the test team, responsibilities involved writing complex queries using SQL to generate data based on the complex derivations for each attribute.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Participated in Project discussions wif analyst, developer & testing teams.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Validating the data passed to downstream systems.
• Worked wif the development team to create a suite of test data (Input files, Expected results), that fully exercises data validation (detecting, rejecting bad data) to test ETL functionality (properly processing).
• Trackedand executedtheUser AcceptanceTest (UAT) Cases wif respect to the requirements to determine the featurecoverage.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in testing the batch programs by using the Autosys tool.
• Responsible for preparing test cases and scenarios for System testing and UAT testing.
• Involved in creating various data scenarios and validating them before and after running the respective Autosys batches.
• Executed all tests as test sets from Test Lab module (QC) and implemented Traceability Matrix by associating and tracking the test cases and defects from Defects module.
• Developed UNIX scripts for file archiving, file transfers and file management.
• Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.
• Automating the Data and Validating in various builds, using QTP and Quality Center.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Prepared RTM, defect density reports, project QA health reports, test summary reports for each release and updated them to QA Leads/Managers.

Environment: Informatica Power Center, Oracle 11g, SQL, PL/SQL, Toad, Autosys, IBM DB2 V8, RapidSQL, BOXI Reports, Rational Clear Quest, Rational Clear Case, DOORS, Oracle SQL Developer, HP Quality Center 10, QTP 10.0, VBScript, UNIX, Putty, XML, XSD, XSLT, WinSCP, Leech FTP, Remedy, Windows XP/NT, Agile/Scrum.

Confidential

QA Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate test catalog.
• Developed and executed test cases in Quality Center.
• Tested Web services using SOAP UI tool, validated request and response XML.
• Actively involved in UI, functional, database and Integration testing of the applications.
• Extensively performed smoke and sanity testing.
• Extensively used Quality Center for test management.
• Created & executed SQL Queries to validate the data
• Extensively performed end to end to ensure data flow.
• Created and executed detailed test cases for the assigned area.
• Prepared test data for positive and negative test scenarios for Functional testing.
• Executed test cases manually to verify actual results against expected results.
• Defect Reporting, Analyzing, Tracking and Report Generation using HP QC.
• Tracked progress of defects through to resolution.
• Used Toad to write/execute SQL queries for back-end testing.

Environment: Windows XP, Oracle 9i, SQL, SoapUI, Web Services, XML, Quality Center, Toad.