SUMMARY

• Over 7 years of focused experience as a Software QA Analyst in ETL and Manual testing of Web and client - server applications in Hotel, Insurance Banking, and Software solutions sectors.
• Analyzing the ETL mapping and design documents.
• Performed ETL validations (Data Completeness, Data Correctness, Initial and Incremental Load testing).
• Validated ETL- Transformation, Data Cleansing, Lookups and Business Rules.
• Create the Test Scenarios and Test Cases based on the requirement workshops.
• Prepared SQL queries to validate data from source to staging and staging to DWH
• Data warehouse concepts.
• Create test data for incremental load testing
• Validated Job schedule scenarios
• Running and Monitoring SSIS jobs in Test Environment
• Active participation defect triage meetings
• Experience in SQL and Oracle databases.
• Strong hands-on experience in designing test suites for all levels of testing and designing End-to-End scenarios.
• Experience in developing and maintaining test plans and test scripts
• Experience in interacting with QA Lead, developers, technical support and help them base line the requirement specifications.
• Well-versed with all stages of Software Testing Life Cycle (STLC).
• Knowledge of various phases of Software Development Life Cycle (SDLC).
• Experience in using HP Quality Centre and Remedy for Test Case Tracking and Bug Tracking.
• Outstanding organizational skills with the ability to set, priorities and meet deadlines.
• Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS

Defect Management Tools: HPQC, Remedy

Languages: SQL

Databases: MYSQL, SQL Server, OracleOperating Systems Windows 98/95/XP/2000, UNIX

Tools: SSIS, SSRS, MS Office

PROFESSIONAL EXPERIENCE

Confidential, McLean, Virginia

QA Analyst

Responsibilities:

• Understand the ETL mapping and design documents
• Participated in Business analysis and requirements gathering sessions
• Involved in Developing and maintaining the overall testing strategy for the project.
• Prepared Test Plans, Test Schedules based on the Requirement documents for integration and system testing
• Involved in writing the Test cases and Test scripts based on Source to Target Mapping documents and Data Model diagrams.
• Prepared SQL queries to validate data from source to staging and staging to DWH
• Expert in Metadata, Data type, Constraint, Null, Duplicate, Data, Date, Count, Regression & Positive/Negative checks and writing test cases for them.
• Strong usage of HP Quality center for centralized control over entire project.
• Resolved data related issues during initial loads from different sources.
• Developed Excel templates to verify results and performed extensive data analysis and reconciliation.
• Coordinated with the Developers regarding the Defects raised and Retested them.

Confidential, Philadelphia, Pennsylvania

QA Analyst

Responsibilities:

• Understand the ETL mapping and design documents
• Involved/Participated in requirement discussions
• Created the Test Scenarios and Test Cases
• Performed ETL validations (Data Completeness, Data Correctness, Initial and Incremental Load testing)
• Validated ETL- Transformation, Data Cleansing, Lookups, Business Rules
• Prepared SQL queries to validate data from source to staging and staging to DWH
• Create test data for incremental load testing
• Validated Job schedule scenarios
• Participating in daily scrum meetings and weekly meetings
• Working in an agile team, responsible for timely releases of the potential product at every sprint
• Running and Monitoring SSIS jobs in Test Environment.

Confidential, Ashburn, Virginia

QA Analyst

Responsibilities:

• Coordinated with the business analysts during the initial phase of requirement gathering and actively participated in requirement meetings.
• Web and Cross browser compatibility testing.
• Analyzed requirements and conducted gap analysis
• Prepared Test cases and test scenarios based and mapped them to the relevant requirements
• Participated in Test case reviews and Test Scenario Reviews
• Involved in Smoke testing, Integration Testing, Regression Testing and interacted with development team to resolve the issues
• Used HPQC and Remedy track Defects, Features and Tickets
• Frequently communicated with developers and QA Manager to assist in clarification of technical issues
• Performed testing using SQL Queries for the backend validation
• Logged all the defects during testing life cycle and eventually performed retesting for each release
• Executed tests of enhancements and new functionality for a web-based application
• Analyzing test results and created the bug reports for each release.
• Created/updated test plans, test cases as per new/updated requirements and Involved in designing and maintaining Requirements Traceability Matrix
• Tracked, monitored and reported defects during testing. Ensured that new functionality is correctly implemented. Verified and validated bug fixes. Regression testing is performed wherever necessary.
• Developed and executed manual scripts for functional, smoke and regression testing.
• Executed SQL scripts for back-end testing.
• Actively participating in all meetings and walkthroughs. Attended meetings with stakeholders and communicated effectively with clients and all levels of management, peers and organizations.
• Replicate tests using multiple web-browsers (IE, Firefox)
• Working with the project manager and developers to meet deliverable deadlines.

Confidential, Charlotte, NC

Quality Assurance Analyst

Responsibilities:

• Performed Negative Testing and Positive Testing manually
• Updated Test Cases and Retested the application after requirements changed
• Mapped the requirements with the Test Cases
• Performed System Testing, Regression Testing and Function Testing on Integrated Database/Core.
• Backend Testing of the application was performed by writing SQL queries for Integrated Database/Core.
• Created and documented the Test Designs for each functional area mentioned in Test Plans
• Reviewed the Test Designs with QA team members and technical analysts
• Developed Test Cases and verified actual results with expected results
• Created and maintained the QC Plan & Test Strategy document
• Defect reporting and tracking was done using Mercury Quality Center
• Closely interacted with developers to fix bugs, track changes and modifications and/or enhancements.