We provide IT Staff Augmentation Services!

Quality Assurance/database Sql Developer Resume

Leesburg, VA

SUMMARY:

  • Over Five years of IT experience in QA testing on Web based applications in law firm, banking and retail.
  • Experienced in creating and execution of Test Plans, Test Scripts and Test Cases using both Manual and Automated testing techniques.
  • Wrote Test plans, Test cases for all possible scenarios and executed SQL queries to test data, based on the Business Requirements, Functional Requirements and Business Workflows.
  • Performed Smoke test, System test, Functional test, Integration test, End to End test, User Acceptance test and Regression test activities in testing environment.
  • Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete.
  • Maintained Traceability Matrix to track the requirements against test cases to ensure complete test coverage in the Mercury Quality Center.
  • Worked in Back - end testing in writing and executing SQL Queries.
  • Connected remotely to UNIX servers using PUTTY and FTP files across different test environments.
  • Heavily used SQL Queries to verify the data from the MSSQL Server database.
  • Investigated the application server logs for application errors in Linux machines using Putty.
  • Good understanding of Programming Languages like html, Javascript, VBScript, T-SQL and Java.
  • Comprehensive knowledge of database applications, scripting language and MS SQL Server.
  • Excellent Communication, Learning, Problem Solving and Time Management skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005, 2008 and 2000. Oracle 8i, 9i and

Languages: T-SQL, XML, Java, PL/SQL, HTML, VBScript and JavaScript.

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler and Management Studio.

OS: Windows 2000, Windows XP, Windows Server 2003, Linux and Unix

Testing tools: Quality Center, Quick Test Professional (QTP), Selenium and Fogbugz.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

  • Worked on Multiple projects like ITS(Item Tracking System) and LPN(Learning Point Navigator)
  • Involved in test strategy preparation, test plan development, test case creation and test case execution.
  • Tested web applications using agile methodology.
  • Did Functional testing, GUI testing, System testing, Regression testing, Usability testing, Configuration testing and UAT testing.
  • Reviewed functional specification documents, design documents and requirements traceability matrix.
  • Interacted with Business Project Manager and Software developers for defect reviews and participated in QA meetings.
  • Involved in improving software quality, test coverage, efficiency and regression coverage.
  • Actively Participated in Scrum meetings, reviews and developed test scenarios.
  • Tested results in Database using SQL queries.
  • Resolved issues identified during QA, User Acceptance and Production phases.
  • Developed test designs, manual test cases, defect reports and release test reports.
  • Ran test cases and submitted defect reports. Verified fixed defects and ran regression tests.

Environment: Java Script, XML, CSS, MSSQL Server 2008 R2, Windows 7 and Fogbugz.

Confidential, Leesburg, VA

Quality Assurance/Database SQL Developer

Responsibilities:

  • Worked as a Quality Assurance/SQL developer on project i.e. all physical servers were migrated to Virtual environment
  • Wrote detailed test scenarios and test cases for user group on different projects like AIG/ Barnes and Noble.
  • Executed test cases and logged defect in Quality Center/ Documented requirements in Quality Center.
  • Gathered requirements for the User Groups on different projects and mapped the objects in our database.
  • Helped user groups with performance testing once the physical servers were migrated in VMware environment.
  • Mapped Test Cases to Requirements(traceability Metrics)
  • Tested under Windows and Linux Environments.
  • Performed GUI testing, Functional testing, Integration testing, Regression testing, Ad -hoc testing, Negative testing, End to End testing, Load testing, User Acceptance testing on multiple projects.
  • Logged defects in Quality Center, re-tested defects, analyzed defect with Users and Developers.
  • Worked in an agile environment.
  • Created Users and gave necessary permission to users to access the documents.
  • Wrote view which gave summary to supervisors of law firm to see how many documents are reviewed by which users.
  • Uploaded, imported and export documents using FileZilla(ftp) desktop clients.
  • Wrote SQL queries to test the data.
  • Wrote SQL Program to let the reviewers know which documents are already redacted.

Environment: SQL SERVER 2005, Windows server 2000, MS Excel & Word, PowerPoint, JavaScript, .Net, Quality Center, Stored Procedure.

Confidential, Springfield, MO

Quality Assurance/SQL Developer

Responsibilities:

  • Involved in developing test strategy, test plan and test case documents.
  • Involved in GUI Testing, Systems Testing, Integration Testing, Black Box Testing, User Acceptance Testing, Regression Testing in Web based applications
  • Developed Test Plans, Test Scenarios and Test Scripts for manual testing for ACH.
  • Involved in full life cycle testing in LINUX environment using Agile model
  • Developed test designs, manual test cases, defect reports and release test reports.
  • Ran test cases and submitted defect reports. Verified fixed defects and ran regression tests.
  • Wrote SQL queries to test data in MS SQL Server.

Environment: VB Script, SQL Server 2005, Windows server 2003, Business Intelligence Development Studio, T-SQL, MS Access, Java, Quality Center.

Confidential, Springfield MO

Quality Assurance Engineer

Responsibilities:

  • Involved in test strategy preparation, test plan development, test case creation, test case execution for both manual and automated testing.
  • Tested web applications using Agile methodology.
  • Functional testing, GUI testing, System testing, Regression testing, UAT testing And Performance testing.
  • Reviewed functional specification documents, design documents and requirements traceability matrix.
  • Interacted with Business Analysts and Software developers for defect reviews and participated in QA meetings.
  • Involved in improving software quality, test coverage, efficiency and regression coverage.
  • Actively Participated in Scrum meetings, reviews and developed test scenarios.
  • Tested results in Database using SQL queries.
  • Resolved issues identified during QA, User Acceptance and Production phases.
  • Identified defects and monitored status until issues were resolved through communication and Software Developers.
  • Created and Managed database Objects like tables, views and maintained Referential Integrity.
  • Created user logins with appropriate roles granting necessary permissions to the users.

Environment: SQL SERVER 2005, Windows server 2000, MS Excel & Word, PowerPoint, .Net, Quality Center, Stored Procedure

Hire Now