We provide IT Staff Augmentation Services!

Qa Engineer Resume

Norfolk, VA

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
Confidential

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
Confidential, Richmond, VA

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
Confidential

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

Hire Now