SUMMARY

• Around 7 years including of diverse experience in Information Technology with emphasis in Software Development Life Cycle (SDLC) specialized in Quality Assurance Process and Methodologies in various Client server and web based Applications.
• Excellent experience in Manual and Automation testing, using Automation Suite like quick test professional, selenium, load runner and quality center in a variety of industries like Finance, Banking & Insurance and Telecommunication.
• Good experience MS SQL Server Database Development in Windows environment.
• Experience in developing Test Plan, Test Scripts and Test Reports as per FRS, SDS and Templates. And by understanding and working with Use Cases.
• Strong technical knowledge of QA process including system, functional, performance, regression and integration testing
• Strong experience in Black Box & Backend Testing / Database Testing.
• Created automated test scripts using Testing tools and formulated Defect databases using Defect tracking tools.
• Experienced in testing applications utilizing technologies such as XML, XSLT, HTML, DHTML and JavaScript.
• Extensive experience of Automated Testing with Mercury Suite of products including HP Quick Test Professional (QTP), Selenium, HP Quality Center (QC), Load Runner(LR).
• Expertise in analyzing functional and design specifications experience in preparing Test plans, Test scripts and Test cases for both Automated and Manual Testing.
• Experienced in Data Modeling, Data Mapping, Design, Development, Testing, Implementation and Production support for RDBM Systems.
• Involved in all stages of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation and Support.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008.
• Written TSL script for Database and data driven testing for regression testing of business workflow.
• Extensive knowledge in writing and modifying Confidential - SQL queries (DDL and DML)
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility.
• Extracting, Transforming and loading(ETL) of data using SSIS and DTS
• Experience in managing Alerts and Jobs through SQL Server Agent in SQL Server.
• Experience in Deploying DTS/SSIS packages in SQL Server Integration services (SSIS).
• Good understanding of iterative software development methods.
• Wide range of IT industry experience with Insurance, Banking/ Finance, Pharmaceutical and Telecom fields.
• Outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication.

TECHNICAL SKILLS

Automated Test Tools: Quick Test Pro 10.0, Selenium, Load Runner, Quality Center

Documentation Tools: MS Word 2000, MS Excel 2000 and FrontPage 98/2000.

Bug Tracking Tools: Quality Center 10.0, BugZilla.

ETL: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Data Modeling: Dimensional Data Modeling, Data Modeling Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Reporting Tools: SQL Server Reporting Services, Business objects, Crystal Reports

Operating Systems: Windows 2003 / NT / 2008R2 Server / XP/ VMware

Languages: SQL, PL/SQL, C.

Databases: MS SQL Server, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. QA Analyst

Responsibilities:

• Created SQL Queries to Extract, Insert, and Delete data from Database including Inner and Outer Joins.
• Interacted with the requirement team of ETL/ data warehousing and analyze the documents to do ETL testing by using SSIS and excel package.
• Do testing of number of rows, columns, formats, data type etc means check the transformation is as per as requirement or not.
• Checked all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Prepare test cases for ETL testing and execute them. After execution do reporting of defects.
• Analyze automated test plans and create test cases for QTP Tool as per new / existing requirements.
• Involved in finding the test cases to automate in Quick Test Pro.
• Used VBScript for scripting the automation.
• Worked on Java and Java script for the scripting in Selenium
• Well known about Descriptive programming in QTP.
• Analyze test cases with the development and business analysis teams.
• Maintain test logs and track defects using Team Foundation server.
• As per system needs, validate our Internal Audit application in offline mode using silver light.
• Executing the test scripts for System, Functional and Regression using checkpoints, parameters, data driven and logical loops in Quick Test Pro.
• Analyzing the test results and reporting defects using Quality Center.
• Performed back end testing using SQL to verify the integrity of the data.
• Supports the customer service team with customer queries.
• Drive cross functional reviews for the test cases - new feature / upgrading existing feature.

Environment: Quality Center, Quick Test Professional, SQL Server 2008, ETL, SSIS, Data Warehousing, C#, VB Scripts, Team Foundation Server (TFS), Silver Light, MS-Excel.

Confidential, Noblesville, IN

QA Analyst

Responsibilities:

• Participated in Requirement Analysis, Business Analysis and Use-Case Analysis.
• Created Traceability Matrix mapping Test Scripts against Business Requirements.
• Conducted UAT sessions with business users along with business analyst.
• Conducted Smoke, Navigational testing in the production environment after Production release.
• Performed technical writing of high level Test Plans, Test Cases, Test Scripts, and Test Scenarios.
• Developed Test Case Procedures and conducted the tests in Selenium.
• Performed selenium automation testing for the application with the complete coverage.
• Performed the database Validation using SQL Queries in order to validate the data
• Conducted and participated walk-through and reviews for test cases and test plans.
• Conducted Functional testing, GUI testing and Regression testing during various phases of the application development.
• Involved in technical writing of high level automation Test Plans, Test Cases, Test Scripts, and Test Scenarios in Selenium.
• Maintained and updated Requirement Traceability Matrix and test data for every project release.
• Reviewed complex test results and the progress of problem resolution and report the progress to management.
• Prepared and presented Testing status to Project Manager.
• Used Bug Tracker for tracking bugs, to report the deviations found. Also interacted with developers to resolve and re-test the deviations.
• Wrote SQL queries to check data populated into tables correctly or not.
• Identified several defects and logged them using Quality Center.
• Oversaw test execution to ensure proper operation of system/program.
• Reviewed complex test results and the progress of problem resolution and reports progress to management.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution.

Environment: Oracle, Bug tracking tool, SQL, Snag It, ASP.Net, HTML, Windows XP, MS Visio, Java/J2EE, Load Runner, Selenium.

Confidential - Grantsboro, NC

QA Analyst

Responsibilities:

• Analyzed business requirements documents to get a better understanding of the system from both technical and business perspectives.
• Used VB script for automation test script in QTP, did functional and regression testing to find out the bugs
• Setup test environment and test data for both positive and negative testing.
• Testing application to accommodate sufficient time for developers to resolve the issues.
• Transformation of use cases to test scenarios and designing test plans and test script for QTP.
• Used Quality Center for generating Requirements, Test Sets, and Test Plan and for reporting defects.
• Performed Smoke, Black Box, Validation and Compatibility testing of the application manually.
• Performed Regression, UAT, Integration, User Interface, GUI, and Usability Testing.
• Reviewed and analyzed artifacts throughout the SDLC, made planning, and then QTP automation VB script.
• Reviewed user documentation for accuracy of implemented functionality descriptions
• Involvement in efficient and optimum test planning with the available resources.
• Interaction with the developers for resolving critical bugs and functionality modifications.
• Using SQL Server database extensively to validate the back end data.
• Participate in weekly status meetings and coordinated with the Developers and Testers to resolve and close defects.
• Actively participated in all phases of testing life cycle including document reviews, and project status meetings.

Environment: Quality Center 9, QTP, SQL Server, JAVA, Microsoft Excel, Windows 2000/XP.

Confidential, MD

Database/ETL Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis and Use-Case Analysis.
• Technical writing of high level Test Plans, Test Cases, Test Scenarios.
• Participated in Black Box Testing and Integration Testing in White Box testing approach.
• Conducted testing of the system End-End Testing manually.
• Perform Regression, UAT, Integration, User Interface, GUI, and Usability Testing.
• Created SQL Queries to Extract, Insert, and Delete data from Database including Inner and Outer Joins.
• Involved in finding the test cases to automate in selenium.
• Involved in technical writing of high level automation Test Plans, Test Cases, Test Scripts, and Test Scenarios in Selenium.
• Analyze automated test plans and create test cases for selenium Tool as per new / existing requirements.
• Interacted with the requirement team of ETL/ data warehousing and analyze the documents to do ETL testing by using SSIS and excel package.
• Do testing of number of rows, columns, formats, data type etc means check the transformation is as per as requirement or not.
• Checked all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Prepare test cases for ETL testing and execute them. After execution do reporting of defects.
• Made recommendations to management regarding the acquisition and/or implementation of software to increase information systems efficiency.
• Monitored post-implementation system/program performance to prevent reoccurrence of operational issues and ensure efficiency of operation.
• Prepared the test cases and test scenarios detailed in Microsoft Excel.
• Transformation of use cases to test scenarios and designing test plans and test cases.
• Performing Black Box testing of the application manually.
• Involvement in efficient and optimum test planning with the available resources.
• Oversaw test execution to ensure proper operation of system/program.
• Reviewed complex test results and the progress of problem resolution and reports progress to management.
• Using SQL Server database extensively to validate the back end data.

Environment: Bugzilla, Windows 9x/NT, JDK, JSP, JDBC, SQL Server, Tomcat, MS Excel, and Oracle.

Confidential, PA

QA Analyst

Responsibilities:

• Interacted with Business partners to perform thorough analysis of business requirements, functional requirements and helped the team develop robust test conditions
• Involved in reviewing Use Cases and Requirements.
• Created test cases and test-case templates for manual testing and performance automation testing.
• Performed System testing, Regression testing and User Acceptance Testing and tested all aspects of products and thoroughly reported issues in bug tracking systems.
• Performing data manipulation in excel and HP QC.
• Performing automated testing of the web Services and applications using QC.
• Performing Load, Stress, Volume, and AD-Hoc Testing of the application using Load Runner.
• Executed SQL Queries using the simple and complicated join.
• Worked very closely with client side managers and developers.
• Tested on QA environment while performing functional tests.
• Initially performed end-to-end manual testing on the billing systems.
• Participated in regular project status meetings related to testing.
• Maintained documentation of test results to assist in debugging and modification of software.
• Analyzed test results to ensure existing functionality and recommends corrective action.

Environment: HP QC, Bugzilla, JDK, JSP, JDBC, SQL Server, Tomcat, Oracle, Windows 9x/NT.

Confidential, Chevy Chase, MD

QA Analyst

Responsibilities:

• Analyzed Business and System Requirements.
• Interacted Test Plans for each release and executed assigned test cases as part of Functional Testing.
• Prepared Test Reports and Deliverables and submitted for version releases.
• Performed validation, Regression, Functionality Testing.
• Performed positive and negative testing.
• Generated test scripts and execute all tests.
• Executed SQL Queries using the simple and complicated join.
• Worked very closely with client side managers and developers.
• Tested on QA environment while performing functional tests.
• Initially performed end-to-end manual testing on the billing systems.
• Participated in regular project status meetings related to testing.
• Used Bugzilla as a bug-tracking tool.
• Found defects and interacted with developers to resolve technical issues.
• Interacted with Business and Developers to exchange the updated functionality specification.

Environment: Quality Center, Bugzilla, Java, SQL Server, Windows 9x/NT.

Confidential

QA Analyst

Responsibilities:

• Interacted in development & documentation of Software Requirements Specification (SRS) and using Rational Rose.
• Modeled the detailed design of the system using UML and Rational Rose, Use Case Diagrams, Class Diagrams, Sequence Diagrams, Activity Diagrams and State Chart Diagrams.
• Handled requests for proposals, making presentations to customers, and negotiating project timelines and deliverables.
• Created different Trace ability views to maintain the Trace ability of the requirements.
• A major part of the responsibility included interacting with the users and business relationship managers and implementing changes on the database in order to ensure approval.
• Utilized PL/SQL (stored procedures, functions, packages and triggers) and SQL (queries) programming to create business logic.
• Implemented SDLC which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Involved in GUI Testing, Unit Testing, System Testing, Integration Testing, Regression Testing, performance Testing.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure.
• Involved in verification and Validation of all issues returned from developers and performed regression testing on new builds.
• Performed User Acceptance Testing (UAT)

Environment: Windows XP, Vista, UML, MS Share point, MS Project, Rational Requisite Pro, Rational Clear Quest, Rational Rose, MS Word, MS Excel, and MS Visio.