Summary Profile

• 7 years of experience in Web based and Client-server application Testing including in a lead role
• Excellent understanding of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Test Methodologies.
• Experienced in creating and developing Test Plan, Test Cases, Test Scripts, and Test Reports, Defect Reports for Manual tests.
• Extensively performed Functional, System testing, Regression testing, performance, and sanity testing.
• Designed and developed test scripts for Functional and Regression testing
• Experienced in Tracking Defects and Creating reports using Quality Center (Current), OnTime, FogBugz Mantis (Past)
• Writing and executing SQL queries to ensure data integrity to meet user requirements exposure in database testing.
• Proficient in documenting Test documents using MS Office tools- Word and Excel
• Experienced in formulating Test plans, designing manual Test Cases and Test Scripts to support Quality-oriented deliverables.
• Good Exposure in Using of QTP Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.)
• Participated in the Design, Business/Functional requirements and test cases review meetings.
• Interacting with the client and to keep a track of project status, and inspection reviews.
• Experienced in dealing with end clients, coordinating with Business Analyst at various stages of QA life cycle.
• Organized weekly Project Status and Task Review meetings
• Created power point presentations and project updates using MS Project for management review
• Developing Test Cases from Use Cases, using test management tool, SPIRA TEST.
• Experience in developing UATs, Test Summary Report, Traceability Matrix and Beta Testing Report.
• Strong skills in test planning/designing/execution and analyzing user requirements as well as writing Test scripts for usability and GUI testing apart from functional testing
• Experience in creating systematic documents as per client requirements; proactive in reporting bugs and delivering detailed documents in compliance with specified standards.
• Good understanding of FDAs 21 CFR p11 experienced in working on Regulatory submission products like ISIToolBox and Virtual Link Manager and exposure in to Medical Claim.

Training

3 Months of Training at Confidential, New Jersey, on QA processes. SOP for Image Solutions recommended by FDA and validation documentation required for STLC phase

2 Months of Training at Confidential on CSV and 21 CFR Part 11.

IT Expertise

• Testing Tool: Exposure to Automation tool QTP, Test Director, and Manual Black box testing methodologies.
• Test Scripting Language: Basics of VB Scripting
• Operating System: Windows-98, 2000, Vista, Windows 7 and Unix
• Language: C, Visual Basic ,PL/SQL
• Database: Oracle 10g, MS Access, SQL SERVER 2000 2005, Teradata
• Software: Office 2003 and 2007, Adobe Acrobat 5.0,6.0,7.0,8.0 and 9.0

Project Summary

Confidential (ETL/Database and Manual Testing)

• Role: Test Lead Team Size: 7
• Location: Plano, TX
• Duration: Sept 2011 May 2012

Responsibilities:

• As a Functional Tester performed end to end testing of the application.
• Tested all the new requirements manually in test environments and ensure that the new and existing functionality is working as expected.
• Prepared Test Plan, High Level Test Cases and Detailed level Test cases.
• Performed as Onsite Offshore co-coordinator and communicated with Offshore team regularly.
• Involved in Smoke Full Regression Testing of the Application in acceptance environment.
• Tested the stories (requirements) in different browsers and various system resolutions
• Involved in Bug Verification Defect Tracking using Quality Center Mantis.
• Attended Customer Calls and worked closely with Business Analyst
• Employed Test Driven Development (TDD) Extreme programming approaches.
• Executed the SQL queries to verify the data from the database tables.
• Generated Query Suggestion Analysis reports for each release.
• Establish an automated test environment for UI and non-UI testing
• Identify test cases that needs to be automated by reviewing existing manual test cases
• Review test scripts and enhance the scripts if required using Quick Test Pro.
• Execute the scripts with respect to functionality
• Creating Regression suite.

Confidential Using Oracle Insbridge Testing

• Summary: Confidential is an adaptive, enterprise solution for product management, premium calculation underwriting rules management. The application is the single point of rating truth, which allows insurers to respond quickly to market changes, effectively manage the lifecycle of a policy, and meet regulatory requirements.
• Role: Test Lead Team Size: 5
• Location: Trenton, NJ
• Duration: March 2011 Sept 2011

Responsibilities:

• Understanding and analyzing the requirements and deriving use cases that are used by team for writing test cases
• Interacting with BA for clarification required for understanding the requirements
• Working with data analyst during the requirement gathering from Business users.
• Writing and reviewing test cases
• Test Case execution in batch
• Bug reporting and tracking using Quality Center
• Involved in creating Test Plan
• Creating Trace matrix, Test summary Report
• Validating data by accessing Mainframe systems to make sure Oracle Insbridge rating premiums values are same as Mainframe
• Converting the complex insurance mainframe algorithm to excel application as test case steps.

Confidential

• Role: Test Lead Team Size: 7
• Location: San Fransisco
• Duration: April 2010 Feb 2011
• Summary: Confidential is a web based application used by Wells Fargo for wholesale banking customers. It acts as the backbone for enrolling and tracking the sale of wholesale products and services associated with each product. The application helps in collecting information about the Companies and products used by various companies and services used for each product and number of user licenses sold for a Company w r t each Wholesale banking product.

Responsibilities:

• Functional testing on SIT, UAT, ProdFix environment
• Executing major test cases on Production environment
• Bug reporting and tracking using Quality Center
• Involved in creating Test Plan
• Creating Trace matrix, Test summary Report
• Validating data by querying database to make sure load performed by ETL team are loaded correctly
• In case of issues found fixing the stored procedures written in Oracle Pl SQL
• Wrote extensive SQL Queries to verify data in Tables
• Created and executed SQL queries to validate results entered in front end
• Understanding the Source to Target Matrix which is used by the Development team for data integration.
• Developing the test cases to validate the ETL Code.
• Validating the data loaded by Development team in Primary Staging which is loaded from various sources like Mainframe, Informix, DB2, flat files etc.
• Writing Queries to validate the data in EDW or data mart after applying the business rules.
• Validating the business KPI's with the BO reports in production.
• Good exposure to ETL Tools like Informatica and its various transformations. (Source Qualifier, Expression, Aggregator, Router, Filter etc).
• Leading the testing team from Offshore, reviewing the test cases and results.

ENVIRONMENT: Oracle 10g, Toad 10, Mainframe, Infomix, DB2, Informatica 8.6, BOXIR2/R3, Teradata v286 as Source for Data Extraction

Confidential

• Role: Test Lead Team Size : 3
• Location: Hyderabad India
• Duration: Oct 2009 March 2010
• SUMMARY: Confidential is a system that will help users in creating and maintaining links without modifying the original document. This tool will provide clients with a standalone version of the Link Management functionality currently available within the eCTDXPress® and ISIPublisher® linking tools. Confidential will provide users with the ability to create cross reference links from documents stored within the Electronic Document Management System (EDMS) or from a Windows file share without modifying the original document. The resulting navigation is stored within the database and allows for users to change the source and destination documents location while maintaining the navigation virtual. To ensure symmetry between Confidential and companion systems, like eCTDXPress and ISIPublisher, the single product shall replace the current link management within those systems. The navigation created within one environment is reflected automatically when the document is reused within a companion system. As a standalone product, Confidential shall provide audit trail and login credentials directly to ensure its use is only by authorized individuals and provides for applicable sections of 21 CFR Part 11 Compliance.

Responsibilities:

• Setup the test environment by installing Live Link, Documentum DFC setup at local Environment, Client Plug-ins, and Adobe Acrobat.
• Performed Functional testing and Regression testing manually.
• Involved in full fledged Environment Testing.
• Record and Report various issues using OnTime with client confirmation and track them to closure.
• Implemented Test Environment Matrix.
• Interacting with client to resolve technical issues.
• Delivered Test Deliverables to Client such Test Script, Test Summary Reports, Traceability Matrix

ENVIRONMENT: Microsoft .NET Framework 1.1 SP1, Documentum DFC 5.3 SP2 5.3 WebTop, Live Link 10, Acrobat 7.0.5, Microsoft Office 2000 SP3, IE 6.0 Windows XP Professional SP2 and Windows 2003 SP1 and Oracle 9.2.0.7.

Confidential

• Role: Test Lead Team Size: 6
• Location: New Jersey, Whippany
• Duration: Oct 2008 Sept 2009
• SUMMARY: Confidential is a powerful web annotation and collaboration tool that integrates the use of Adobe Acrobat annotations into a Documentum-based content management solution. This tool allows an individual to access documents from a Documentum content repository over the web, annotate the documents using Adobe Acrobats full suite of annotation tools, store the annotations as objects in the docbase that are related to the original document, and accomplish all of this without modifying the original document

Responsibilities:

• Setup the test environment by installing AnnoDoc Client Plug-ins, and Adobe Acrobat.
• Performed Functional testing and Regression testing manually.
• Involved in full fledged Environment Testing.
• Record and Report various issues using FogBUGZ with client confirmation and track them to closure.
• Implemented Test Environment Matrix.
• Interacting with client to resolve technical issues.
• Delivered Test Deliverables to Client such as Updated Test Script, Test Summary Reports.
• Involved in ISO documentation.

Environment : JAVA, IBM Content Manager e-Client / EMC2 | Document WebTop, Windows 2000, Adobe Acrobat 5.0 to 7.0.8 professional/Standard, Unix

• Confidential Team Size 7
• Location: Belgium
• Duration: Feb 2008 Sept 2008

Responsibilities:

• Responsible for test planning, test design and test execution and analysis for software Products and web based applications.
• Created User Requirements Specification (for already developed application, a kind of reverse engineering in terms of documentation) as there was no documentation for the product.
• Co-ordinated with onsite Belgium team for creating the Design specifications with the help of developers sitting at Hyderabad.
• Defined templates for IQ/OQ PQ and created use case diagrams (UML standards) to help testing team for developing Test Cases.
• Scheduling, Costing for the system Testing.
• Created Test Plan
• Guided test team for creating test case doc
• Reviewing Test Case doc for finalizing
• Defined Templates for Traceability Matrix, Test summary, Release Notes
• Helped Technical Writer for creating the User Manual for the application
• Co-ordinated with Belgium team as one point of contact for offshore to drive the project.
• Configured bug tracking system (Mantis, open source code) for tracking the bugs on temporary basis.
• Followed up complete bug tracking system for smooth bug tracking for onsite dev team and offshore test team.
• Team Building

Confidential

• Role: Sr. Test Engineer Team Size : 5
• Location: Hyderabad
• Duration: April 2007 Jan 2008
• SummaryConfidential is a system of templates for Microsoft Word designed to provide guidance to create the content of regulatory documents while increasing the productivity and reliability of Word. ISIWriter adds a layer of protection and control to Word documents, ensuring the kind of consistent formatting that is needed for drug product labels. The document control and capabilities in Confidential go far beyond simple templates with example content to create consistent, reliable scientific and regulatory content.

Responsibilities:

• Analyzing the new requirements from User Requirement Doc and preparing test cases to cover the requirements.
• Prepare Scenario Document on daily basis based on the testing performed. (Maintains only Objective)
• Preparation of test cases, test log and performing Functional Testing.
• Verifying issues logged by other team members and log in to FogBugz.
• Preparation of System Test Summary Reports.
• Preparation of other validation Documents (Traceability Matrix Appendix Document)
• Involved in creating Test Plan.
• Co-ordinate with onsite member to get any detail required for the other team members.
• Execution of the Test Cases and generating Reports.
• Providing daily weekly team status to client.
• Perform regression and preparing Regression report.
• Closing all the issues logged by team which are closed after regression.

Environment: Windows 2000, XP Professional, .Net, SQL Server 2000

Confidential

• Role: Sr. Test Engineer Team Size : 4
• Location: New Jersey, Whippany
• Duration: Aug 2006 March 2007
• Summary : Confidential is designed to help companies produce professionally designed documents in minutes, while realizing dramatic cost savings over more traditional assembly and production methods. Compose allows easy access to more than 20 powerful publishing modules. Vital modules include the ability to repaginate documents; validate links; set security, printing, and file open options; and create bookmarks, hypertext links, and tables of content.

Responsibilities

• Analyzing the new requirements from User Requirement Doc and preparing test cases to cover the requirements.
• Prepare Scenario Document on daily basis based on the testing performed. (Maintains only Objective)
• Preparation of test cases, test log and performing Functional Testing.
• Verifying issues logged by other team members and log in to FogBugz.
• Preparation of System Test Summary Reports.
• Preparation of other validation Documents (Traceability Matrix Appendix Document)
• Involved in creating Test Plan.
• Co-ordinate with onsite member to get any detail required for the other team members.
• Execution of the Test Cases and generating Reports.
• Providing daily weekly team status to client.
• Perform regression and preparing Regression report.
• Closing all the issues logged by team which are closed after regression.

Environment: Windows 2000, XP Professional, .Net, SQL Server 2000

Confidential

• Role: Test Engineer Team Size : 7
• Location: New Jersey, Whippany
• Duration: Nov 2005 July 2006
• Summary: Confidential premiere edition of ISIToolBox with over 40 plug-ins created specifically for the life science's sector. ISIToolBox Pharma edition includes PDF tools for electronic document review, archive, and regulatory submission preparation. By utilizing the wide array of tools available in ISIToolBox, the users able to perform tasks in an effortless automated process.

Responsibilities:

• Prepare Scenario Document on daily basis based on the testing performed. (Maintains only Objective)
• Preparation of test cases, test log and performing Functional Testing.
• Verifying issues logged by other team members and log in to FogBugz.
• Preparation of System Test Summary Reports.
• Preparation of other validation Documents (Traceability Matrix Appendix Document)
• Involved in creating Test Plan.
• Co-ordinate with onsite member to get any detail required for the other team members.
• Execution of the Test Cases and generating Reports.
• Providing daily weekly team status to client.
• Perform regression and preparing Regression report.
• Closing all the issues logged by team which are closed after regression.

Environment: Windows 2000, XP Professional, Acrobat 5.0, 6.0.5 and 7.o.5

Educational Profile: B. Tech in Computer Science

References: Available on Request