SUMMARY

• Having around 7 years of professional experience in testing Web - based and Client-Server applications on different environments.
• Strong expertise in establishing QA Policies, Procedures, strategies, metrics, developing appropriate process and team to ensure the quality of product.
• Wrote and reviewed Test Plan, Test Cases, Test Scripts and Test Scenarios.
• Experienced in analysis of SRS (Software Requirement Specifications), FRS (Functional Requirement Specifications) and Test Analysis Report.
• Used Manual Testing Tools in Mercury Interactive products such as Test Director and Quality Center.
• Experienced in writing both manual and automation test scripts for Functional, Regression, Integration, System, Smoke, Usability, Ad hoc testing.
• Well versed in conducting different kinds of testing such as System testing, Functional testing, Integration testing, Regression testing, UAT testing, Smoke testing and Ad hoc testing.
• Worked closely with the developers and other testers to solve technical and end user issues in UAT environment.
• Attended meetings regularly and played an active role in management meeting.
• Working knowledge of multiple databases such as Oracle, SQL Server and MS Access.
• Strong communication, presentation and problem solving skills as well as strong interpersonal skills.
• Able to work independently and as part of a team and adapt quickly to changing priorities.
• Excellent technical & analytical skills as well as logical & reporting skills.

TECHNICAL SKILLS

Testing Tools: Quality center, Win Runner, Load Runner

Test Management Tools: Quality Center 9.0/9.2/10.0, Guide Wire Policy Center, Test Director, Rational Suite 7.0, LISA 5.0.24

BI Tools: Qlikview, OBIEE, Informatica Power Center

Scripting languages: VB Script, Java Script, HTML, XML

Languages: Java, VB6.0/5.0, C, C++, SQL

Operating System: UNIX, Windows

RDBMS: Oracle 9i/10g/11g, DB2, MS SQL Server 7.0, MS Access, MY SQL

MS Suite: MS Word, MS Excel, MS Access, Out Look, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

QA Analyst

Responsibilities:

• Involved in Custom Implementation projects Business Requirements, Functional Requirements, Solution Proposal and design documentation reviews Involved in Analyzing test requirements, identifying the RISK involved, preparing test strategy, test plan, reviewing test cases for Custom Implementation projects and Enterprise Releases.
• Testing the H2H Custom Implementation Projects
• Involved in Staging Docs to improve the Performance of the project
• Involving in QA / UAT / Production deployments by doing Shakedown testing
• Involved in System / Regression / Smoke testing
• Executing Automated Test Scripts using LISA
• Writing Test Cases using LISA
• Running the reports after executing from Staging Docs. Involved in Performance Summary in Staging Docs. Analyzed metrics from the reports in Staging Docs
• Experience in creating scripts using LISA environment. Performed in assertions, filters, and datasets for enhancements of the scripts. Worked on interactive test run mode on recorded or created test scripts.
• Good knowledge in running a test case and test suite in LISA environment. Analyzed functional test suite summary report, error reports, test performance summary report after staging in LISA environment

Environment: LISA 5.0.24, Quality Center 10.0, UNIX, WinSCP, F-Secure, JPMC SSL, Tumbleweed, SQL Plus, Microsoft Word, Excel, Mainframe Testing, WebMethods, JAVA, Time, Cost, and People Management.

Confidential, Bloomington, IL

QA Analyst

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application. Performed web services testing manually by invoking services at server level. Expertise in Agile Methodology Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed agile process.
• Experience managing projects in an agile development environment. Involved in adding checks and events while recording scripts by using Test Partner.
• Created Test input requirements and prepared the test data for Data Driven testing. Worked on Test Partner in recording new scripts, debugging, printing scripts and playing back scripts.
• Used Quality Center to track andreport system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle. Participated in defect review meetings with the team members.
• Used MS-Word for documentation. Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Mercury Quality Center, Test Partner, Java, SQL, PL/SQL, DB2, HTML, Windows XP

Confidential, NYC

QA Analyst

Responsibilities:

• Solid Experience in all phases of the Testing Life Cycle having performed Smoke, Functional, System, Regression, Integration, Compatibility testing and support during User and Business Acceptance Testing.
• Identified major and hidden defects from any application under test due to precise application knowledge gained through diligent efforts.
• Experience in working on most testing models - the V-Model, Waterfall and Agile models. Have gained expertise in understanding the application involved, deriving test scenarios from functional specs and ERS, writing detailed test cases, executing the test cases and logging the defects using QC tool and tracking them to closure.
• Have experience in writing and reviewing Test Plans, which included details of the Testing Strategy in scope, assumptions, dependencies, tools, risks, mitigation and contingencies, entry and exit criteria and defect management.
• Have been involved in generating details status reports, dashboards, Manual and Automation Test Estimates, and weekly metrics and creating the Final Test Report during Test Closure.
• Experience in browser (Safari, Fire fox, IE) and OS compatibility testing.

Confidential, Oak brook, IL

QA Analyst

Responsibilities:

• Developed Test Plan, Test Cases, Test Scripts, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Expertise in loading the project in to SOAP UI Tool, then using WSDL in SOAPUI Tool REQUEST (invoke) the service on the Server side Good Knowledge in preparing the structured / Unstructured XML files (make sure it has to pass the SCHEMA) with valid data.
• Using PUT and GET we can achieve the above functionality in SOAP UI Involving in QA / UAT / Production deployments by doing Shakedown testing Involved in System / Regression /
• Smoke testing Responsible for test data preparation for the system / integration testing, traceability matrix to ensure the test case coverage and defect logging.
• Leading the defect and issue resolution during testing cycles and coordinating and communicating with the other teams.
• Used Quality Center to track and report system defects and bug fixes. Involved in other test planning meetings and submitted test metrics daily to the management.
• Conducted Regression Testing on each new build, identified software errors and Interacted with developers to resolve issues for every Monthly release.
• Validated the data by using SQL extensively.

Environment: JAVA framework on Web-Logic, SOAP UI, Quality Center 10.0, Oracle 11g, Toad, UNIX, Windows XP, Altova XML Spy

Confidential, Albany, NY

QA Tester

Responsibilities:

• Reviewed business requirements and system specifications and assisted in writing test plan for the installation, GUI, functional, Regression, and integration testing.
• Created Test data, Test procedures, Test casesand documentation using Quality Center. Generated an execution grid in the Test Lab module of Quality Center, group test cases and executing them simultaneously.
• Involved in the complete QA Lifecycle activities like Pre-testing phase, Acceptance Testing Phase, Testing Phase and also in User Acceptance Testing.
• Use SQL for verification of the data is available in a database for Backend Testing Worked with other development team members to better understand the requirement specification in order to improve the quality of an application.
• Worked closely with users, developers, business analyst, configuration management team, project managers, and test lead for a better understanding of requirements for QA testing.
• Prepared test data and checks its availability for the entrance and exit criteria for integration testing. Wrote test plans for positive and negative scenarios for functional & security testing.
• Performed security testing that was accomplished by entering various bogus or fictitious login ID’s. Analyzed bugs using Quality Center and reporting those bugs to the development team.
• Executed test cases manually ensuring the actual results are compatible with expected results.

Confidential, Sunnyvale, California

SQL/PL-SQL Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and Analyzed the existing Actuate and SQR reports.Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports. Coordinated physical changes to computer data bases; and codes, tested and implemented Oracle and SQL data base, applying knowledge of data base management system.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys. Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Created different types of reports such as parameterized reports, matrix report, charts etc. Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports.
• Written stored procedures for those reports which use multiple data sources. Drill down, Slice and Dice and Filtering operations done for all OLAP applications. Specified user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
• Production Support which involves solving user problems. Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time. Tested (manual) the reports after migration to make sure that the developed reports serve the exact business purpose as that of existing Actuate reports. Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, TOAD, SQL Developer, UNIX, Windows XP

Confidential

SQL/PL-SQL developer

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs. Created various PL/SQL stored procedures for dropping and recreating indexes on Confidential tables. Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• The EDW project aims at developing an Enterprise Data Warehouse for the claims Department.
• The project was designed using SQL, Pl/SQL, SAS, Mainframe, Teradata, and Oracle.
• Developed Test Plan, Test Strategy and Testing Scope Document.
• Analyzed the use cases given by the business analysts and developed test cases using them. Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Performed manual testing on various modules of the Application.
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Executes the test suite to identify regressions and unexpected side effects.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).
• Monitors test coverage and achieves high coverage using branch coverage analysis.
• Tests individual methods, classes, or large, complex applications.
• Tracks how test results and code quality change over time.
• Conducted performance and load testing using Load Runner.
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: MS-Office Tools, Informatica 6.1, SQL, PL/SQL, UNIX, Shell Scripting, Manual Testing, Test Director, DB2, Oracle