SUMMARY:

• Over 7 years of experience with writing business specifications, having thorough understanding of all phases.
• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Experience in testing web technologies like Web Services, REST, SOAP, XML, HTML, and Java.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Extensive experience in writing complex SQL Queries and PL/SQL scripts.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Micro Strategy, Cognos including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational Clear Case.
• Experience in Mobile Testing of leading - edge mobile applications on various iPhone, I Pad and Android.
• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Have experience in testing reconcile (initial) and daily automated ETL loads using Informatica DVO.
• Have validated mapping document, validated existence of workflow, validated existence of session logs in case of error.
• Have good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Have performed column to column validation and Data Integrity using TOAD data point.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

QA/Testing Tools: ALM//Quality Center TFS, Rally, Soap UI, Bugzilla, Rational Clear Quest

Version Control Tools: Rational Clear Case, CVS, Share Point

Requirements Tools: Rational RequisitePro

RDBMS (Databases): Oracle, MS SQL Server, MS Access, DB2, Teradata

RDBMS Query Tools: SQL/PLUS, Query Analyzer, TOAD, Oracle SQL Developer, SQL Navigator

BI/Reporting Tools: IBM Cognos, Micro Strategy, Business Objects BOXI, OBIEE

ETL Tools: Informatica Power Center, Informatica DVO, Data Stage, Ab Initio, SSIS

Scripting Languages: SQL Scripts, UNIX Shell Scripts

Operating Systems: Microsoft Windows Family, UNIX, HP-UX

MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Quality Analyst

Responsibilities:

• Analyzed Business Requirements Document and Functional Specification document and analyzed the project needs.
• Associated with development team to understand technical design and architecture for test planning.
• Worked in Agile methodology and attended daily standup meetings.
• Involved in the development of Detailed Test Strategy for Functional and System Testing.
• Designed, Developed, Executed and Analyzed Test plan, test cases, test scripts for use in Integration, System, and Regression Testing.
• Reviewed business requirements and added requirements into the ALM/Quality Center, and Wrote test cases and Functionality testing based on Requirements.
• Extensively used ALM/Quality Center as defect-tracking system to log, close and generate reports and tracked through to resolution.
• Involved in Web Services testing using SOAPUI.
• Performed system testing, Integration testing, and Regression testing.
• Uploaded Business requirements, test scenarios, test cases and defects to ALM/Quality Center.
• Developed test cases using the ALM/Quality Center and prepared test data.
• Tested request and response XML's based web services interfaces using SOAP UI.
• Clarified and documented issues raised during the process of data and system model validation, analyzed and propose changes in valuation methodology to make it precise and transparent
• Performed Inbound and Outbound Data Validation.
• Automated end-end Web Service testing using groovy script in SOAPUI and tested JSON and XML based request and response.
• Involved in preparation of test data to test the functionality of the sources.
• Performed Smoke Testing, GUI Testing and User Acceptance Testing.
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Involved in User Acceptance testing and testing UAT defects in test environment before the new code gets moved to UAT environment.
• Managed defects from inception to resolution using ALM/Quality center and imported and exported the Test Cases from Excel to ALM/Quality center.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.

Environment: Oracle, SQL, PL/SQL, TOAD, SDLC, ALM/Quality Center, Rational Clear Case, Clear Quest, Web Services, SOAPUI, UAT, Agile, Waterfall, etc.

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Developed test cases by reviewing the requirement documents.
• Identified Test Data by querying and created Test scripts.
• Conducted the Functional, System, Integration, Regression, performance, and Smoke Tests for various phases of these applications.
• Developed Test plans by coordinating with other team members on the road map.
• Execution of Manual Test scripts and responsible to track and log the defects using ALM/Quality Center.
• Created test plan, test cases for all applications.
• Performed Functional and System Integration Testing on modifications and enhancements prior to production release on Mobile OS/Devices (phone, Blackberry, Android) and Web based applications.
• Created Regression test scripts for testing to ensure the application is working properly.
• Designed, executed and maintained automation test cases, test scenarios for iOS and Android subsystems.
• Executed the test cases and created defects.
• Tested a mobile application on various mobile devices: IOS and Android to improve user experience.
• Prepared Traceability matrix to verify one-on-one matching of requirement with test cases.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Tested request and response XML's based web services interfaces using SOAP UI.
• Performed RESTful API Web Service testing and load testing using SOAP UI.
• Used ALM/Quality Center to check out the latest versions of the build for testing purposes, and check in the updated test cases, and test documentation periodically.
• Performed Functionality Testing, Exploratory Testing, Regression testing, Integration Testing, Security Testing, Compatibility Testing and UAT Testing.
• Responsible for data analysis, report validation and functional testing
• Worked closely with Technical Project Managers and Development Team in defect tracking, re-testing and validation
• Verified bug fixes and tested all impacted modules in application.
• Coordinating with other team members and providing status to project manager.

Environment: UNIX, SQL, Oracle, ALM/Quality Center, Android, iOS, Web Services, SOAP UI, Agile, SDLC, UAT, MS Office, Microsoft Excel, XML, Restful, API, etc.

Confidential, Norcross, GA

QA Tester

Responsibilities:

• Prepared UAT project planning like creating testing scenario, test plans, and test scripts and test summary reports.
• Assisted QA Manager in developing test estimation, scope and test plan for UAT.
• Handled the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals and Responsible for driving end-to-end Test scenarios efforts and in identifying test data for UAT.
• Drafted complex SQL queries and perform allocation testing from front end / user interface.
• Extensively written complex SQL for ETL and report testing.
• Kicked-off test cases design session with business, setup working sessions with Business SMEs, to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases, facilitated test cases sessions, identified test coverage and gaps if any as part of the sessions.
• Validated the responses of web services by passing various requests using SOAP UI.
• Reviewed SIT test cases and test scripts, provide feedback and support in terms of testing techniques and test coverage.
• Managed manual test passes/runs with TFS.
• Prepared test plans using TFS for each release, written test cases and executed them as part of functional testing. Prepared test reports and deliverables and submitted for version releases.
• Identifying defects and performed root cause analysis by analyzing data quality issues.
• Assigned the tasks of preparing test results as well as gather test results from other testers in standardized format.
• Reviewed the test activities through daily Agile Software development stand-up meetings.
• Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.
• Participated in KT meetings with Business Analysts and SMEs.
• Responsible for documenting the process, issues and lessons learned for future references.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Review daily test status and issue/ defects with the project team and business. Prepare communication and create daily status and defect reports.

Environment: SQL, PL/SQL, DB2, Oracle, Clear Quest, SDLC, Web services, TFS, API, SOAP UI, XML, Quality Center, Agile, UAT, MS Office, etc.

Confidential, Louisville, KY

QA Tester

Responsibilities:

• Prepared Test cases and Scripts in Quality center and executed them in test lab module.
• Performed pre-process validation for existence of specified database objects like tables, views, synonyms and grants for the same to corresponding schema in database.
• Validated the target table column definition with source column definition (including type and length).
• Validated database structure with ERD (Entity Relationship Diagram).
• Written SQLs using joins, sub queries, correlated sub queries, group functions, and analytical functions to validate the data between source and target.
• Used JIRA tool for test/ defect/bug management.
• Hands on experience on using Web Service such as SOAP and WSDL.
• Validated data stage mappings that load files into staging tables.
• Involved in extensive end-to-end DATA validation and back-end testing using SQL queries.
• Validated the WSDL using schema compliance assertion in SOAP UI.
• Heavily involved in performance testing and worked with analyzing tables, gathering statistics, tuning of SQL queries used to fetch source data.
• Validated Data Stage jobs. Used Data Stage director to execute and verify Data Stage jobs.
• Presented QA team work update/Status to Project/Program Manager in status meeting and also worked with business team to get approval on test plan/test cases.
• Validated that design meets requirement and functions according to technical and functional specifications.
• Involved with Design and Development team to implement the requirements.
• Developed Test Scripts and executed them manually to verify the expected results and published the same to wider audience upon successful completion along with QA signoff.
• Participated in KT meetings with Business Analysts and SMEs.
• Frequently used Perforce to store documents and update them with the latest versions and additions.
• Participated in walkthrough and defect report meetings periodically.

Environment: SQL, PL/SQL, Remedy, Agile, SDLC, UAT, DB2, Rational Clear Quest, Clear Case, JIRA, SOAP UI, XML, Quality Center, Agile, etc.