SUMMARY:

• 5+ years of experience in the field of Quality Assurance
• Experienced in analyzing business requirements at different stages of software development life cycle
• Experience with development models such as Agile Scrum and Waterfall
• Hands on experience in developing Test plans, Test Scenarios, Test Cases and Test Data
• Tested software applications including Client - Server, Web based and desk top applications
• Developing and maintaining Requirement Traceability Matrix
• Designed testing documents such as test summery report and defect tracking report
• Experienced in Back-End Testing on SQL and Oracle database by writing SQL queries
• Participated in walkthrough or knowledge transfer meeting to analyze requirements
• Worked on different types of testing including Smoke, functional, integration, regression, system, performance, end to end testing and browser compatibility testing
• Develop packages to extract data from different sources and load to target database using SSIS
• Validating the load process of ETL based on transformation rules
• Better understanding of the business processes of an application
• Strong Manual Testing skills and proficient in using automated testing tools like QTP, ALM/QC
• Hands on experience in writing and executing automated Test Scripts, Tracking Defects
• Ability to work on multiple projects simultaneously with aggressive schedules
• Self-motivated, work well in a team structure or independently
• Strong communication skills both verbal and written, presentation and interpersonal skills
• Flexible to handle changing priorities in fast pace environment

TECHNICAL SKILLS:

Test Management & Bug Tracking Tool: JIRA, HP ALM/QC, OTM

Test Automation Tool: QTP

Operating Systems: Windows, UNIX/LINUX

Programming Language: VB Script

ETL Tool: SSIS, Informatica

Database Systems: SQL, Oracle, SSMS, SSIS, SSRS

Application Software: Ms-Excel, Ms-Access, Ms-Word, Ms-PowerPoint

WORK EXPERIENCE:

Confidential, Norfolk, VA

QA Engineer

Responsibilities:

• Participated in knowledge transfer meeting with product owner, developers and testing team
• Participated in sprint meeting, daily scrum meeting, sprint review and retrospective meeting
• Wrote test plan and test suits including test scenarios, test cases and test data based on user stories
• Created Requirements Traceability Matrix (RTM)
• Performed Smoke Testing, Lay out Validation, Positive and Negative Field Validation, Integration Testing, Regression Testing, System Testing and Acceptance Testing
• Executed manual and automated test cases
• Logged and escalate issues to developers using JIRA
• Created scripts for Regression testing in QTP
• Performed Data-Driven testing using data table parameterization in QTP
• Performed back-end testing procedures using SQL statements
• Converted Functional requirements into test scenarios and detailed test cases
• Performed data drive testing to validate the same set of operation with different set of data
• Enhanced QTP script using recovery scenarios for error handling
• Communicated to Line of Business team, QA team and Test Manager about issues, concerns and risks
• Designed testing metrics like test summery report, defect tracking report and daily execution status report

ETL tester

Responsibilities:

• Validate the source and target table structure against corresponding mapping doc
• Ensures that all expected data is loaded in to target table as expected
• Ensure records count between source and target are correct and no column data is truncated
• Check boundary value by utilize data profiling results
• Validate accurate processing of ETL generated fields
• Validate data types within the warehouse against the data model
• Validate column values and duplicates based on business logic
• Develop packages to extract data from different sources and load to target database
• Identifying duplicate records in the staging area before data gets processed
• Validating the load process of ETL to make sure the target tables are populated accordingly
• Verify all the data is moved from the application to staging tables
• Verify the transformed and cleaned data is loaded into target tables
• Verify how the data organized as per the specification such as the name of the columns, order of the column and data type of the columns

QA Engineer

Responsibilities:

• Attended Requirement Review Meetings and provide feedback
• Developed test plans, test scenarios, test cases and test data based on business requirement
• Performed Smoke Testing, Lay out validation, Positive and Negative Field Validation, Integration Testing, Regression Testing, System Testing and Acceptance Testing
• Executed test cases for manual testing and created Requirements Traceability Matrix (RTM)
• Documented and reported application defects to team lead and developers using HP ALM/QC
• Wrote and executed SQL query to retrieve test data
• Wrote SQL query to check if the data integrity has been maintained on the database
• Developed automated test scripts to conduct regression testing on the application
• Designing test summery report, defect tracking report and daily execution status report
• Performed user acceptance testing
• Developed SQL queries for Backend Testing to verify the database DML operations

Data Analyst

Responsibilities:

• Wrote T-SQL statements to create database objects like table, view and stored procedure
• Used ETL tools (SSIS) to extract data from different data sources like flat file and CSV file and load to the target database MS SQL Server
• Created, updated and drop database objects to satisfy the database requirement
• Rebuilt indexes at regular intervals for better performance
• Creating Ad-hoc reports using SSRS and report builder
• Backing up, restoring database