OBJECTIVE

To build a challenging career to explore my technical skills in Software Quality Assurance area. I am keen on constantly looking toward ways to improve/automate processes to create value in my work.

SUMMARY

• Over 10 years of IT experience with over 6 years of experience in Functional, System and Integration Testing.
• Experience with testing tools such as Quick Test Pro, Quality Center and WinRunner for testing Client/Server as well as Web applications. Hands on with JIRA, IBM Rational Test Manager and Rational Clear Quest. Very good knowledge of Quality Center Site Admin.
• Experienced in manual and automation testing.
• Extensively used Mercury Quality Center for tracking the functional requirements and the testing progress.
• Have been engaged in all phases of software testing lifecycle (STLC). Strong knowledge of SDLC and test methodologies.
• Experienced in development of Test Plan, Test Cases, and Test Scenarios.
• Developed test scripts using automation test tools.
• Experience and expertise in Black Box Testing, GUI Automation testing, System Testing, Functional Testing, Integration Testing, Regression Testing, Performance Testing, User Acceptance Testing. Also performed BVT (Build Verification Test)
• Proficient in Database Testing using complex SQL Queries. Extensively used TOAD & SQL Server Management Studio to execute SQL queries to validate data
• Technical ability to understand the code and the initial System Demo helps better interaction with development team - ensure timely product release, design review, code review and identification of pain areas in the process.
• UNIX skills – Basic shell scripts, Unix commands including Directory/File, Pattern Matching (grep, awk, sed) etc
• Skilled at assessing client needs, working in a group and supporting end users. Excellent Communication skills.
• Quick learner, adaptable and flexible to the ever-changing technology and confident. Dedicated to understand, translate and meet client needs.
• Possess strong problem analysis skills, with ability to quickly master new concepts, applications, and an effective team player.
• Effective defect tracking and reporting.

TECHNICAL SKILLS

Testing Tools QTP, Quality Center, WinRunner, JIRA, Test Manager and Rational Clear Quest
Database Microsoft Access, Microsoft SQL Server 9.0/2005, Oracle10g, Sybase11.0
Version Control MS Visual SourceSafe 6.0, PVCS Serena VM
Operating System Win NT, UNIX and MS-DOS
ETL Tools DTS, SSIS, Data Junction
SQL Editors Embarcadero DBArtisan, SQL Server Management Studio, Toad, Aqua Data Studio
Methodologies Knowledge of SDLC and STLC
Languages Java, Visual Basic

EXPERIENCE

Sr Oracle QA Analyst Confidential,NJ Sept 2011 – Till Date

Environment : Oracle10g, SQL Server 2005, Toad, Java, J2EE, MQ, Websphere, Datastage 8.0, Maestro Interface

Project:
Involved in testing Oracle migration releases and preparation of Disaster Recovery boxes. Responsible for creating and automating processes involved to reconcile the Holdings, Portfolio and investment data. Create custom processes required by users on a day to day basis in Portfolio Accounting and Investment Management areas.

• Develop test scripts to run on Oracle and SQL server environments
• Execute reconciliation test scripts and verify the expected updates. Increased efficiency of the process by developing custom programs to track and reconcile Market Value, Trade Dates etc
• Enhance existing reconciliation scripts to validate the record counts on different environments at the time of migration
• Create and automate an object and column level comparison process on SQL Server which would access data from Oracle databases.
• Schedule and manage maestro jobs for the relevant SQL processes. Involved in change control releases on the Oracle Production Server. Loading and enriching data through the use of SSIS

Sr QA Analyst Confidential,NJ March 2011 – June 2011

Environment : QTP, Rational ClearQuest, Oracle10g, Toad, Java, J2EE, C, C++, MQ, Websphere, UNIX

Project:
Testing WFN payroll process and reports related functionality.

• Develop QA test plans and execute them using user requirements and design documents.
• Perform functional and regression testing including all negative scenarios.
• Report performance issues to the development team and work with them to help resolve and re-test the issues.
• Prepare test data addressing complete set of test cases. Interact with other operations team if required to prepare data. Perform complete end-to-end testing
• Perform BPT based testing in QTP. Create test cases using multiple BPTs and maintain them.
• Report defects using Rational CQ and follow through their resolution lifecycle. Involve in troubleshooting with Development and Support teams to resolve defects and issues quickly and efficiently. Verify fixes.
• Execute DB queries to validate the data integrity of the application.
• Attend status calls, provide updates to project managers and work with manager to address any outstanding issues.

Sr QA Analyst Confidential,NJ April 2010 – Nov 2010

Environment : QTP, Quality Center, Oracle10g, Toad, Java, J2EE, C, C++, MQ, Websphere, SQL Navigator, UNIX

Project:
Verizon Wireless portal is constantly enhanced with new features and services. Few of many that I worked were Wizards and Wigets, secure eBill, Prepay Web and other Verizon Wireless services.

• Develop QA test plans and provide project staffing estimates to manager. Schedule and provide walkthroughs. Attend approach document reviews for requirement alignment.
• Work closely with the other members of the Business, Development Team and Support to review the designs of systems & implement test plans. Perform complete end-to-end testing
• Error log comprehension within UNIX. Validate updates on the database side using queries on SQL navigator.
• Executing automated test scripts utilizing Quick Test Pro as well as perform manual testing.
• Prepare test data addressing complete set of test cases. Interact with other operations team if required to prepare data.
• Report defects and follow through their resolution lifecycle. Involve in troubleshooting with Development and Support teams to resolve defects and issues quickly and efficiently
• Provide project status & updates to project managers and work with manager to address any outstanding issues that need attention during time critical releases.
• Identify test environment needs and create test coverage matrices for features and releases. Contribute to team planning activities. Support releases as a SME of the Verizon Wireless applications.
• Actively scheduling and participating in Simultaneous testing.
• Define and co-ordinate regression test plans for the particulars of each release and propose the release plan to the manager. Lead the release on the production night and proactively work with development and operations team to resolve any issues before providing sign off.
• Participate in pre-implementation reviews with Development and IT Operations

Sr QA Analyst Confidential,NJ June 2008 – Feb2010

Environment : QTP, Quality Center, Oracle10g, Toad, J2EE, XML, HTML, MS-Excel, Win 2000, XP

Project: Content Management System
The system addresses every facet of the document life cycle-including capture, storage, processing, security, revision control, retrieval, distribution, preservation, archiving and destruction of document with an in-built audit tracking. The system gives a full, integrated control of all business documents imported into or generated from within an organization in the course of its operation. The documents include scanned documents, data created with applications etc which are converted into PDF format for easy editing, processing and searching. The scope of the application includes the control of access to this content from outside of the organization\'s processes, content processing and searching.

• Worked with Business Users and Developers to participate in creating a complete test plan according to the high level project schedule. Analyzed Use Cases and wrote test Objectives.
• Developed manual and automated test cases and execute validating them using user requirements and design documents
• Developed Test Metrics to track the tests during the QA Testing Phase.
• Created and Executed SQL test scripts for Functional and Regression Testing.
• Optimized QTP scripts for Regression testing of the application. Maintained test cases and scripts in Mercury QC
• Used QC to report defects found on performing testing cycle. Escalated issues to developers and verified fixes.
• Creating & customizing tests to check the application’s performance against multiple data sets.
• Wrote several SQL scripts in Toad to validate the data integrity in the application using various DDL statements.
• Reported performance issues to the development team and worked with them to re-test the issues.
• Test applications both in QA and Production environment. Work closely with developers, QA Lead and other testers.
• Involved in Walkthroughs, Test Plan Review meetings, Defect Report meetings & Audits, interacted with Project Managers, Developers and End Users on resolving quality issues.
• Enhanced the test scripts and test cases based on the Functional Requirement & Use Cases.
• Expertise in verifying the logs for each job.

QA Analyst Confidential, Dec 2006 - May 2008

Environment: Quick Test Professional, Quality Center, Win NT, UNIX, SQL Server, Visual Studio .NET, Serena VM, Java, J2EE, JSP, LoadRunner

Project: List Update and ePost Mail Transmission.
ePost Direct, part of InfoUSA Services provides a wide selection of segmented data for direct mail marketers. In addition, ePost provides data processing and database marketing services, & services for direct e-mail marketing campaigns. The automatic List Update application is used to process and upload the client data file received in varied formats and to maintain the data. The Mail Transmission application is designed for use by the clients to remotely customize Transmissions and schedule them. The system also allows the user to extract reports useful for post-campaign analysis.

• Involved in all aspects of QA process including analyzing the Business Requirement Documentation, Test approach document & Test Plan to develop the Test Cases and Test Scripts for various scenarios.
• Performed Data Driven Tests to validate the same scenario with different test data using Quick Test Professional.
• Developed and updated Test Scripts based on the Functional and Technical Specifications.
• Extensively used HP Quality Center for Test Planning, Bug Tracking and Reporting
• Conducted Browser Compatibility testing to check the consistency of application on various browsers.
• Performed Database Testing to validate the data integrity of the application.
• Created and executed SQL test scripts for Functional and Regression Testing.
• Interacted with developers, system engineers, and testing teams to identify applications defects.
• Responsible for coordinating and executing the testing of the system in accordance with the test plan.
• Coordinate defect validation with test team and assist development team in recreating defects. Improved defect management processes. Performed root cause analysis on defects which was helpful to the developers.
• Performed Black Box testing, Integration and Regression Testing and System Testing for the ePost Automatic Transmission System. Provided Performance Testing support.
• Ran UNIX shell scripts to load several data files in the system & to verify file-format data.
• Logged defects in Quality Center. Wrote reports giving the details of test scripts, Results and defects.
• Interacting with developers for assisting them in the identification & simulation of errors
• Frequently communicated with developers and senior QA team members to assist in clarification of technical issues

Database Analyst/Tester Confidential,Co Dec 2004 - Nov 2006

Environment : WinRunner, Sybase11.0, Windows NT, Oracle 9i, Toad 8.0, IBM Websphere Studio Application Server 5.X (WSAD), Serena Version Manager

Project: Agency Alerts Portlet
This was one of many portlets on the New York Life Agency Portal. Windows based Agency Alerts System was converted to a Web based Alerts Portlet. Agents can log into the Alerts portlet anytime and access their alerts depending on the User Group the agent has been assigned. Performed manual and automation testing on the Web based Agency Alerts portlet.

• Performed BlackBox Testing based on the functional requirements and product specifications of the application.
• Performed Functional and Regression Testing using WinRunner.
• Inserted GUI checkpoints and Synchronization points in WinRunner test scripts and used Context sensitive mode to Record Application under Test (AUT).
• Performed the Data Driven Test that deals with different sets of data. Prepared the Test Data and executed test cases.
• Written SQL Queries to retrieve data from the database.
• Worked closely with development team to resolve the defects and testability issues throughout Software Development Life Cycle
• Checked whether data in the reports module is in compliance with data in database using SQL queries
• Performed Compatibility Testing on Internet Explorer, Netscape Navigator to verify the browser Compatibility
• Maintained Bug Tracking Report for Defect Handling using MS-Excel and sending weekly status reports showing the issues to be resolved across the team.
• Participated in weekly meetings and walkthroughs.

Project: The project Field Technology Contact System.
Project was undertaken by IBM for one of its biggest client NewYorkLife Insurance Company. It was aimed at migrating agents’ data from the desktop application to the centralized web system. Their desktop application is Windows based and it holds a variety of information on the contacts for the agent’s entire book of business.

Involved in the migration of application data on Sybase Windows platform to a centralized Oracle Databases. Designed and developed scripts for Windows based Agent Database migration

• Used TOAD to develop oracle PL/SQL, DDL\'s, and Stored Procedures.
• Wrote scripts to reconcile the data differences in source and target databases.

Performance and fine Tuning stored procedures related to conversion patches and also actively participate in modifying the schema designs for the target application. Identify business logic and data that can be pushed out to tables or other decision structures which the old application contained in code. Interact with Database Synchronization team to understand their processes and database structures and co-ordinate the unit and model testing