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
