SUMMARY:

• Over 7 years of diverse experience in Information Technology industry with expertise in Software Quality Testing in Cloud based Web and Mobile applications and Data warehouse environments.
• Strong experience in working Agile, Scaled Agile and traditional waterfall projects
• Experience in Software Development Life Cycle (SDLC) aspects such as Requirements Analysis, Design, Development, Testing and Deployment.
• Extensive experience in Quality Assurance Life Cycle (QALC) aspects such as developing Test Strategies, Test Plans, Test Cases (Manual / Automated), Defect Reports and developing Test Scripts, Traceability Matrices.
• Hands on Experience in ETL testing of Enterprise Data warehouse.
• Experience in using Quality Center for writing Test Plans, Test Cases and executing test scenarios and defect reporting.
• Expertise in exporting requirements to Quality Center from Excel and linking them to the test cases to prepare RTM.
• Expertise using Test Director as well as Quality Center/HP ALM to maintain and update Requirements, Test Cases and Defects
• Created reports and graphs to communicate to the business owners about the daily base testing process and the progression of the system testing.
• Strong working experience in Agile environment and using tools such as - JIRA, Confluence, HipChat and Slack.
• Hands on Experience in writing SQL and knowledge of PL/SQL scripts for Oracle/Teradata and testing the database.
• Well versed with Basic UNIX Commands, participated in modifying Shell Scripts and Database validation scripts for testing.
• Experience in writing, maintaining and updating Test Documentation for various stages of testing for reference and Auditing purposes.
• Black-Box testing techniques with hands-on experience in Unit testing, Integration testing, Functional testing, Performance testing, Regression Testing and User Acceptance testing
• Experience in testing of various database applications Teradata, Oracle, DB2 and Sybase.
• Expertise in Problem solving and Bug Reporting using Bug Tracking Tools such as Clear Quest, Entry Tracking system, Quality Centre, JIRA and RALLY.
• Expertise in selenium IDE, Selenium RC and Selenium Grid, extensively used selenium RC using Java to create automation scripts. Designed and Developed selenium framework which helps to create the scripts quickly
• Experienced in integrating Automation scripts (Selenium WebDriver API) in Continuous Integration tools (Jenkins) for nightly batch run of the Script.

TECHNICAL SKILLS:

Database Management Systems: Teradata, ORACLE 8i/9i/10g, SQL Server 2000 and MS-Access 2000, Sybase, PostgreSQL

Testing Tools: Mercury s Win Runner, Quick Test Pro, Selenium. Informatica DVO

Test Management Tools: Mercury s Quality Center8.x/HP ALM, TestDirector 7.6, DOORS, RALLY

Document Management Tools: DOORS, HP ALM

Bug Tracking Tools: Clear Quest, Entry Tracking, Quality Center, JIRA

508 Testing Tools: Jaws, Magic

Operating Systems/System Software: Windows (2007, 2003, 2000, NT), UNIX, Test Script Language (TSL), VB Script, UNIX, Informatica, SQL PL/SQL, XML, Toad 8.x, SQL Developer, MS-VISIO 2000, MS-Project 2000, MS-Excel, MS-Word, MS-PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Test Engineer

Responsibilities:

• Actively participated in requirement gathering and JAD sessions and also attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Worked closely with Product Owners and developers for the determining Acceptance Criteria of the User Story (US)
• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS and other supporting documents.
• Developed Test cases and Test Scripts and loaded them in HP ALM
• Executed the Test cases, capture evidences and upload to ALM
• Developed Test Data for System and UAT Testing.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Wote SQL in order to data validation in migration as part of backend testing
• Performed testing on Microstrategy Report format, Report layout, Prompt ordering, Prompt Defaults, Security filters, Export/Print functionality
• Validated Microstrategy Reports Data against database
• Performed Positive and Negative Testing of data loaded through ETL.
• Developed DVO data validations using DVO Tool for Dimension, FACTS and other ETL’s
• Executed test cases for source to target count match, data match and transformation logic.
• Performed test to check for Duplicates/unique constraint data loaded through Informatica.
• Performed testing of the API’s developed in the application
• Logged Bugs in ALM for all the issues identified during testing and worked through closure
• Verified the Database table structures against the Model and reported Bugs in ALM
• Verified the data in Database against the source data
• Give a demo of the functionality developed within the Sprint to Product owners and rest of the team
• Participated in the code deployments to higher environments and performed smoke test.
• Used Selenium IDE to automate tests on cross browser and cross platform environment.

Environment: Java, WebSphere Portal, Microstrategy, DB2, HP ALM, Informatica Power center Informatica DVO, Oracle Idenity Management, Jira, Confluence, HiChat, Slack, Selenium.

Confidential, Sioux Falls, SD

Test Engineer

• Participated in analysis of Business and functional requirements
• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel
• Developed Test Cases, Test Scripts and Test Data for System and UAT Testing
• Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Performed Positive and Negative Testing for this application.
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Extensively used SQL queries to check storage and accuracy of data in database table
• Performed basic testing of security features using manual testing
• Performed testing of loading data from flat files to Oracle tables and vice-versa
• Performed the Testing of the MSTR reports manually
• Involved in creating the design and technical specifications for the ETL process of the project.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Reported bugs and tracked defects using Quality Center.
• Involved in the production support team for planning cycle after production implementation.

Environment: Microstrategy 8.0/9.0, Informatica 9.1, SQL Assistant 13.0, Windows 7, z/os server, Unix, HP Quality Center

Confidential, Bentonville, AR

QA Tester

Responsibilities:

• Created Test Plan and Test Scripts and analyzed the user/business requirements. Functional specs, Use Case documents and created the Test Plans, Test cases for System testing.
• Executed of generated Test Cases Manually in Test Director.
• Created the Regression Test cases and automated them for the purpose of regression Testing.
• Developed and maintained automated test scripts to support regression testing and participated actively in system testing and regression testing.
• Developed and maintained the regression test bed.
• Complete responsible for manual testing of the Web Site.
• Attended project meetings, release meetings, and QA status meetings.
• Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Requisite Pro RUP.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conduct workflow, process diagram and gap analyses to derive chuck for existing systems enhancements
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: MS Visio, MS Excel, MS Word, MS PowerPoint, SQL, MS Project, 7.0, Test Director 7.0,Windows NT, Web Logic Server 7.0, J2EE, Oracle 8i, EJB 2.0.