SUMMARY

• Over 7+ years of Professional experience as Manual Tester, Automated Tester and Performance Tester.
• Expertise in different domains like HealthCare, Banking, Finance, Automobile.
• Expertise in Designing and implementing Automated, Manual Testing Methodologies for Web Based, Client server applications.
• Experience in White Box, Gray Box and Black Box testing.
• Performed different kind of testing like Smoke, System, Functional, Integration, Regression, GUI, Database/Backend, Security, Ad - hoc, Performance/Load Testing.
• Good knowledge of Software Development Life Cycle from Requirement Analysis to User Acceptance Testing.
• Involved in Test plans Development, Test Case Development, Test Designs, Test Specifications and Test Strategies, according to the business specification given.
• Tested compatibility of application with Internet Explorer, Safari, and Mozilla browsers.
• Having good judgment and communication skills required for reporting and prioritizing software bugs in conjunction with the Development & QA Managers.
• Performance & Scalability testing using Load Runner & executed different Test Scenarios using controller and generated detailed reports using Load Runner
• Involved in testing applications using testing tools such as HP QTP, Load Runner.
• Worked extensively on Automation Framework.
• Strong and extensive work experience in various Relational database systems such as Oracle, SQL Server, MySQL, MS-Access and DB2.Strong skills in executing SQL Queries/SQL Programming to perform back-end database testing.
• Experienced in creating UNIX scripts and executing the UNIX Shell scripts for testing.
• Expertise in using Autosys Job Scheduler for scheduling and testing the batch jobs
• Strong SQL Skills and expertise with backend testing using TOAD
• Expertise in software management tools such as Bugzilla, Rational Clear Quest and Quality Center for Defect tracking and reporting.
• Strong experience in working on Windows, UNIX, LINUX Environments.
• Expertise in creating Test Plan, Test Bed, Test cases, Defect and Status Reports.
• Performance & Scalability testing using Load Runner & executed different Test Scenarios using controller and generated detailed reports using Load Runner
• Expertise in cross browser, cross platform compatibility testing.
• Maintain Close interaction with developers and Business analyst to solve technical issues.
• Good experience in S/W Methodology.
• Ability to work independently and in a team under deadline pressures.
• Test-to-break attitude, having the ability to work independently, or in a group, with minimal guidance in testing.

TECHNICAL SKILLS

Operating Systems: Windows NT/XP/2000, MS-DOS, UNIX, Linux 6.2/7.2, Sun Solaris 7, Mac OS X 10.6.8

RDBMS & Tools: ORACLE 8i/9i/10g/11g, DB2, My SQL, MS Access, SQL Server 2000/2005/2008

Programming Languages: C, C++, T-SQL, ASP.NET, ADO.NET, C#, VB.Net, PL/SQL, HTML, XML, XSL, Java script, VB Script, Visual Studio 2005, ODBC

Web Technologies: ASP.NET, XML, XSLT, HTML, VBScript, JavaScript

Networking & Protocols: TCP/IP, FTP, LDAP, SSH, DHCP

Testing Tools: HP Quality Center 9.5/9.0, QTP 9.2/9.0, Load Runner 9.0 and Win Runner 7.5, Clear Quest, TOAD, XML SPY, SOAP UI

Defect Tracking Tools: HP Quality Center/Test Director 7, Bugzilla, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, NY

Manual Tester/SQL Tester

Responsibilities:

• Analyzed System Requirement Document (SRD), Functional Requirement Document and Business Requirement Documents
• Prioritized the requirements to assure that the most critical issues are addressed
• Followed the organization’s standard documentation format for developing test plan, test cases and coordinated with development team.
• Attended JAD Session, regular project meetings, workshops with BAs, SMEs, Network Administrators and Developers
• Databases and cataloged identified bugs in the build.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed Unit Testing, Functional Testing, System testing, Acceptance testing, Ad-hoc testing. Regression and Performance/Load testing using QA testing tools like Load Runner and QTP.
• Conducted cross-browser GUI functionality testing on multiple platforms
• Identified and categorized the test cases for automation and used QTP to create test scripts
• Created automation scripts from scratch, as well as updated the existing QTP suite
• Automated test scripts using QTP to perform Regression testing for different builds of the application.
• Developed library of reusable VBS functions and shared among the functionality test team
• Enhanced the QTP action scripts with parameterization, log messages and recovery scenarios
• Created Data Driven tests using QTP to analyze the results of various iterations.
• Involved in GUI, Bitmap, Database and Synchronization testing by creating checkpoints using QTP.
• Performed recovery scenarios for error handing mechanism and Performed Function and Load Testing using Soap UI.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Performed Black box and white-box testing on the ASAP application and created work around for lot of issues.
• Tested fixed or combination mortgage application for home loans
• Created Complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications
• Created Load Runner Vugen scripts for different application protocols, co-relation of scripts, setting the desired parameters in the run-time settings
• Used correlation in dealing with dynamic data by using Load Runner.
• Executed Load Testing using Load Runner to analyze the performance of the application by monitoring throughput average transaction response time and HTTP responses per second.
• Parameterized test scripts based on Load test objectives by using Load Runner.
• Created customized Load Runner Report in MSWord, MS Excel for use by the entire testing team.
• Wrote Perl Script to perform routine maintenance tasks and Batch jobs.
• Conducted backend testing of the application for data verification by writing complex SQL queries.
• Executed SQL Query to perform Backend Testing using TOAD.
• Performed backend testing in Oracle database and analyzed the log files for different error codes.
• Worked with defect tracking tool HP Quality Center.
• Responsible in providing regular test status reports to the QA manager.

Environment: Java/J2EE, HP Quality Center 9.5, Load Runner 9.0, HP QTP 9.2, Oracle 9i, Linux, Windows Vista/ XP, TOAD, XML SPY, SOAP UI, ASP.NET, MS SQL Server 2008, SQL Lite.

Confidential, San Francisco, CA

Sr. QA Engineer/SQL Tester

Responsibilities:

• Analyzed business requirements and functional specification documents
• Established and maintained relationships with Key business partners and technology partners.
• Participated in Design walk-through with Subjects Matters Experts to baseline the Business/System Architecture
• Experienced in developing T-SQL (DDL, DML) statements using dynamically generated SQL.
• Defined Referenced relationships with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used profiler to identify and repair database lockup, deadlocks and other issues.
• Analyzed the business models, UML, object models and use cases to develop the test strategy and test scenarios using Clear Case
• Categorized and grouped test cases and managed them in Quality Center.
• Conducted smoke testing, functional testing, System testing and data migration testing
• Mapped the test cases to requirements and prepared test coverage reports in Quality Center
• Performed manual tests to validate the workflows, end-to-end scenarios, EDI formats, interfaces to legacy systems (CICS) and compliance to HIPAA standards and FDA regulations
• Tested EDI transaction on Claim (837), Certification Request (278), Payment processing (835) and its integration MMIS
• Executed test cases with a set of test data to verify the application integration and web services requests (XML, SOAP), message processing, interfaces to legacy application database and dynamic implementation of business process, distribution of work and reporting features
• Validate the inbound/outbound data formats and middleware components functionalities.
• Utilized QTP to automate the UI functionalities and conducted data driven tests using QTP scripts (VBScript)
• Used VB Scripting in QTP, Generated test results using QTP and Analyzed Actual Result and Expected result.
• Validated checkpoint functionality in QTP for database, Image, text. Used Synchronization, Call function, Parameterization, Checkpoints, Regular Expressions to enhance test affectivity also created reusable actions.
• Performed white box and black box testing, and identified and isolated issues.
• Created shared object repository in QTP.
• Established connectivity between QTP and Mercury Quality centre and access the functions from QC and logged defects into QC.
• Performed Load/Stress/Performance testing using Load Runner.
• Tested multiple Vusers for testing various test scenarios to perform Load/Performance Testing using Load Runner.
• Managed and logged the defects/issues in Clear Quest.
• Created Test Data to generate various test scenario to test EDI formats.
• Leveraged experience in SQL and RDBMS to populate test data and execute test scenarios in backend.
• Wrote and Executed SQL Queries to perform backend testing using TOAD.
• Coordinated with business analysts, development team and participated in bug review sessions
• Gathered test results and prepared test status reports

Environment: HP Quality Center 9.0, Load Runner 9.0, HP QTP 9.2, Oracle 9i/10g, Linux, Windows Vista/ XP, TOAD, SQL plus, XML SPY, SOAP UI, ASP.NET.

Confidential, Deerfield, IL

Sr. QA Analyst

Responsibilities:

• Analyzed System Requirement Document (SRD), Functional Requirement Document and Business Requirement Documents.
• Prioritized the requirements to assure that the most critical issues are addressed
• Followed the organization’s standard documentation format for developing test plan, test cases and coordinated with development team
• Performed Manual and Automated testing using Quality Center and QTP.
• Mapped the test cases to requirements and prepared test coverage reports in Quality Center
• Conducted smoke testing, functional, Database, Regression, System, Integration, Ad-hoc, GUI testing
• Performed manual tests to validate the workflows, end-to-end scenarios, EDI formats, interfaces to legacy systems (CICS) and compliance to HIPAA standards and FDA regulations.
• Executed test cases with a set of test data to verify the application integration and web services requests (XML, SOAP), message processing, interfaces to legacy application database and dynamic implementation of business process, distribution of work and reporting features
• Validate the inbound/outbound data formats and middleware components functionalities.
• Identified the test scenarios for automation and created QTP actions to simulate user actions
• Conducted smoke testing, functional testing, System testing and data migration testing
• Identify Automation Scenarios from Manual test cases and Created automation Scripts using QTP
• Creating Reusable Actions and Function libraries using QTP.
• Involved in Data Driven/Checkpoints/Debugging/Customizing Scripts.
• Prepare Test Data for Positive and Negative Testing used in Data Driven Test and tested using QTP.
• Performed batch tests and verified the processed data.
• Utilized SQL Skills to perform backend functionality tests.
• Leveraged experience in SQL and RDBMS to populate test data and execute test scenarios in backend.
• Wrote and Executed SQL Queries to perform backend testing using TOAD.
• Coordinated with business analysts, development team and participated in bug review sessions
• Gathered test results and prepared test status reports

Environment: Windows, Sun Solaris9, DB2, HP Quality Center 9.0, HP QTP 9.0 Java/J2EE.

Confidential, Chicago, IL

QA Engineer

Responsibilities:

• Reviewed the Business Requirements document and Functional Specifications.
• Developed the Test Plan and wrote Test Cases based on the Business requirements, Functional specifications.
• Extensively involved in Black Box Testing.
• Involved in both Automation and Manual Testing.
• Performed Smoke, Functional, System, Integration, Database/Backend, Regression, Performance and Load Testing
• Performed the automation of test scenarios for functionality, GUI and Regression testing.
• Defined UI checkpoints to check frames, complex tables, text boxes, buttons, radio buttons, lists, combo boxes, hypertext links, image links and images.
• Performed Recovery Scenarios Wizard using QTP.
• Used Automated Web Testing Tools and created scripts for testing JSP/HTML.
• Coordinated with the UAT Team (Client) and the developers for Defect Fixing.
• Wrote Shell Scripts using Perl to manage migration of Data to check Database integrity.
• Wrote Perl Script to perform routine maintenance tasks and Batch Jobs.
• Tested the XML templates and data that are extracted by the parsers.
• Involved in GUI, Bitmap, Database and Synchronization testing by creating checkpoints using QTP.
• Analyzed Load/Performance result using Load Runner.
• Developed and executed SQL queries to verify Test Cases and database integrity using TOAD.
• Manually manipulate data directly from Oracle database using SQL.
• Reported the issues found during the testing and retested issues as expected.
• Conducted weekly project meeting and provided status on project progress.
• Participated in dry run before the successful production release.

Environment: JAVA, J2EE, Test Director, Oracle 8i/9i, QTP 9.2, Load Runner 9.0, Windows 2000

Confidential

SQL Tester

Responsibilities:

• Reviewed engineering specifications and business requirements.
• Created/modified existing templates for test plans, test cases, test approach documentation.
• Coordinated with process implementation team, followed the industry standards.
• Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases
• Reviewed T-SQL code written by developers to follow better standards, procedures to optimize for better performance before QA deployment
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance
• Worked on Agile Development Environment.
• Managed and administered the QA documents.
• Managed multiple project repositories in Bugzilla, categorized the test cases, prepared test sets for smoke tests and regression testing.
• Reported defects using Bugzilla and create summary reports.
• Conduct walkthroughs, various Review meeting and troubleshoot the issues.

Environment: MySQL, UNIX, Bugzilla, Windows 2000, MS SQL Server 2005