SUMMARY

• 5+ years of IT and Management experience with emphasis on Software Testing/Quality Assurance. experience in testing of Client Server and Web based applications using Manual testing techniques and Automation tools.
• Prepared Test plans for small, medium and large applications and running thru the project towards a successful closure.
• Experience in High level Documentation and test data preparation; RTVM (Requirement Traceability Metrics) preparation, experience in Testing Methodologies and implementing in SDLC Life cycle process.
• Experienced in Agile, Waterfall and V - Model testing.
• Involved extensively in Functional, Integration, Regression, WhiteBox, BlackBox, Defects testing, Re-testing, product, solution, Test Log, Test results, Authentication & Access control testing, UAT and Smoke testing.
• Expertise in reviewing requirements for their correctness, completeness, consistency and testability.
• Experience in Web servers, Databases and Performance Analysis and presentation of the performance Test analysis
• Expertise in the functional testing of client/server and web applications using Quick Test
• Professional and SOAPUI.
• Analyzed Business Requirement Specifications and created Test Plans and Test Cases inRationalClearQuest for the Functional, Integration, end-to-end and smoke testing.
• Worked on Front End Construction on Facets Version 4.71, 5.01 for CSP and validating the Build by running SQL in the Backend ( Sybase Database)
• Experience in Automation tools like Load Runner and Quick Test Pro and Test Management tools like ALM, Quality Center, Test Director, QA Director, Rational Clear Case & Rational ClearQuest
• Strong skills in RDBMS backend testing using SQL queries.
• Good experience inSQLand Oracle.
• Experience in using the Microsoft test manager, Quality Center for writing and managing the test cases and reporting the bugs.
• Experienced in communicating with offshore development teams, BA’s and test teams.
• Hands on experience of Unix testing environment.
• Experience in testing various database applications in Oracle, SQL Server, and MS Access.
• Expertise in test data preparation for banking, sales, ticketing and insurance applications.
• Good understanding of Configuration Management.
• Experience in source control systems such as SVN.
• Established and maintained productive working relationships with management, clients, project team members, QA testers and other groups.
• Quality testing experience in banking applications, HR application, telecome ticekting, e-commerce and Web application’s.
• Strong communication and interpersonal skills to maintain effective work relationships with all levels of Personnel.
• Clear understanding of business rules and ability to work individually and as a part of team

TECHNICAL SKILLS

Testing Tools: Quick Test Professional 8.2/9.x/11,, Load Runner 8.x/9.x Win Runner 8.0

Languages: C, SQL, TSQL, Visual Basic, TSL, UML, J2EE, Java

Operating Systems: Windows NT, Windows 95/98/2000/vista, and UNIX

Databases: Oracle 11g/8i/9i, DB2,MS Access, MS SQL Server

Scripting: HTML, XML, VBScript, Java Script and Shell Scripting

Protocols: TCP/IP, HTTP, HTTPS, SOAP, .Net WebServices and MQ Series

Servers: WebLogic, WebSphere MQ, Apache Tomcat

Management Tools: HP Quality Center 11/9.2/9.0, Test Director 8.0, IBM Rational ClearQuest, Excel, Visio, VSS, PVCS, JIRA, Bugzilla, SQL* Loader, MS-Sharepoint, Escrum and TOAD, SVN

PROFESSIONAL EXPERIENCE

Confidential, Tampa,FL

QA /Automation & Manual Test Engineer

Responsibilities:

• Worked as QA Tester with project management teams to prepare full life cycle test plan and to formalize QA Methodology as per the Business Requirements and Software Resources Specifications.
• Studied and understood the business requirements and flows for the application.
• Followed the Agile testing and e-Scrum methodology for the integration and regression testing approach.
• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Performed functional, regression, system and user acceptance testing (UAT).
• Responsible for defining pre-condition and post-condition information for different test case scenarios
• Involved in writing complex SQL queries for extracting data from multiple tables.
• Performed the back-end integration testing to ensure data consistency on front-end by writing and executing SQL statements.
• Developed Automated test scripts for different Oracle e-Business Suite products testing using QTP
• Implemented database checkpoints for back-end testing.
• Involved in solving environmental issues, server connections and database sharing activities.
• Tracked defects using bug-logging with tools like JIRA and Project tracker, knowledge in analysis of bug severity, bug tracking system and bug reporting.
• Involved in application security testing for securing the application with proper authentication & authorization.
• Composed and operatedSQLqueries and Joins, Group By clause, having clause etc. to validate the data.
• AuthoredSQLqueries for searching, creating and updating test data.
• Created target tables in Oracle and Workflows inInformaticato populate the data according to requirements.
• Performed unit testing for developed ETL mappings before deploying toQA.
• Worked onInformaticaSource Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer
• Documented and monitored defects using JIRA.Authenticate reports by executingSQLqueries.
• Extensively used QTP/UFT as automation tool for automating the scripts for regression testing and
• Configuring QTP tool setting, object identification and globalizing the settings.
• Designed & Implemented automation testing methods like Data-Driven and test code and independent methods were being used effectively there by saving lot of maintenance costs and making the scripts more user friendly.
• Design strategy to test P&C Insurance applications for multiple LOB's (Auto, Property, Claims, Billing, etc) onMainframeand Web based platform.
• Involved in Software Testing - ETL/BI Testing or Data Warehousing Testing and web based client/server applications.
• Perform System, Integration, User Acceptance and Regression Testing.
• Responsible for automation approach document preparation and also maintained the scripts in ALM.
• Extensively used comparison tools like Confidential compare, Compart doc bridge delta.
• Responsible for collecting the Performance Baseline document before and after data center move, and comparison of the results.
• Wrote and executed complexSQLqueries including JOINS to find loan numbers.
• Track issues and work with project managers and developers to resolve.
• Used ALM to execute the test cases, track execution against the plan during testing and manage defects from inception to resolution.
• Configured Database adapter in Jdeveloper using JNDI to retrieve process status, and exposed service in OSB as business service using JCA protocol
• Assist with managing projects using time tracking tools as well as updating issues lists along with monthly and weekly status reports.
• Provide training, mentoring, and input to year-end performance evaluations on all aspects of business analysis and manual QA testing.

Environment: Agile Methodology, QTP/UFT,, JIRA, UNIX,Informatica, SQL Oracle E-Business Suites (EBS), Oracle Apps R12, ETL scripts, XML and Java scripts,Rational Rose,Sql management studio,Mainframe,SVN, Project Tracker, Remedy, Confidential compare tool.

Confidential, Austin,TX

QA /Automation Tester

Responsibilities:

• Worked as Sr QA Tester worked with Project management teams to Prepare Full Life Cycle Test Plan and to formalize QA Methodology as per the Business Requirements and Software Resources Specifications.
• Studied and understood the Business requirements and flows for the application.
• Followed the Agile testing and e-Scrum methodology for the integration and regression testing approach.
• Developed automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application.
• Conducted variance management by analyzing and verifying test results, providing status and progress reports, using SharePoint as well as JIRA.
• Writing the Selenium test scripts from scratch using Junit.
• Excellent experience in Web service testing using SoapUI tool.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX Shell Scripts for invoking data reconciliation.
• Extensively used QTP as automation tool for automating the scripts for regression testing.
• Created Test cases and Test scripts using QTP for Stress and Performance Testing and Descriptive Programming using VB Script.
• Developed automated test scripts for different Oracle e-Business Suite products (SCP, PO, AP, AR, GL, FA, PA) testing using QTP.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Used SOAP UI for checking the correct transmission of data and to test web services
• Work with other QA Team members to develop test strategies and test scenarios. Also help clarify specific requirements to other System Tester/s to help develop test cases.
• Involved in application security testing for securing the application with proper authentication & authorization.
• Deployment of code in the UNIX boxes for testing purpose
• Implemented Database Checkpoints for Back-end Testing
• Tracked defects using bug-logging with tools like JIRA and Bugzilla. Knowledge in Analysis of Bug Severity, Bug Tracking system and Bug Reporting.
• Designed & Implemented automation testing methods like Data-Driven and test code and independent methods were been used effectively there by saving lot of maintenance costs and making the scripts more user friendly.
• Responsible for Automation Approach document preparation and maintained the scripts in ALM/Quality Center 11
• Responsible for collecting the Performance Baseline document before and after Data Center Move, and comparison of the results.
• Running batch jobs (stored UNIX shell scripts, PL/SQLpackages).
• Verifying successful run of batches by making sure that data in source and destination matches as per requirements.
• Responsible for interacting with the BusinessAnalystand contributing in documenting the requirements from the users.
• UsedRationalClearQuest as bug tracking and participated in Bug reporting and reviews.
• Developed automated scripts using QTP to perform functional and regression testing.
• XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server
• Performed the data integrity on the DB tables by writing the SQL queries for Product Mgt and Harmony applications data integration
• Copy the policies from production to test environment and execute batch cycle testing formainframeapplications as per the requirements.
• Defect Retesting and tracking the defects till they are fixed and set to close using the defect tracking tool. Maintain updated reports on resolved bugs.
• Involved withInformaticateam members in Designing, document and configure theInformaticaMDM Hub to support loading, cleaning, matching, merging and publication of MDM data.
• Use ETL to load data from sources such as Flat Files, Oracle to Oracle, Teradata Target Database. Based on the business requirements Reusable transformations are created in transformation
• Implemented various Checkpoints for data validation and synchronization and developed Reusable functions using QTP.
• Experienced in Data Driven Testing and Data Manipulation using SQL.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.

Environment: QTP 11, MS-SQL server 2008,Informatica,Oracle E-Business Suites (EBS),Mainframe,Oracle Apps R12, Agile Methodology, Windows XP/Vista, Informatica ETL, JIRA, UNIX,SQL, JAVA, PLSQL, J2EE, XML and MS Office.

Confidential, Atlanta,GA

QA Analyst

Responsibilities:

• Analyzed business requirements, and Functional requirements and Involved in writing detailed test cases for the Integration testing and system testing.
• Prepared SOAP message Test Data and Involved in testing IVR applications.
• Extensively involved in designing, reviewing and executing test cases and maintaining the defect tracking logs for open issues.
• UsedRationalRose/MS Office Suite for creating use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models.
• Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837.
• Wrote Structured Query Language (SQL) statement against Claims, Claim Status and updating Personal Information modules by Joins, Unions and Aggregate Functions
• Validated the responses of web services by passing various requests in SOAP UI.
• Conducted various types of testing like Functionality, Integration and Regression.
• Manually checked the important features of the application before going for automation testing.
• Performed Back-end testing using Quickest Pro 8.2 and Silk Test by writing manual SQL queries. Identified functionality and performance issues, including deadlock conditions, database connectivity problems, and system crashes under load runner.
• Data driven testing, Bitmap checks and Data checks were done using QTP.
• Responsible for Database integrity testing by executing SQL statements.
• Developed test scripts and documenting test processes.
• Bugs tracking and reporting managed with using JIRA.
• Monitored and created the defect tracking process and reported bugs to the ODS team.
• Maintained Test Matrix with the test results obtained automated regression testing for new builds using QTP Escalation of critical problems/issues during testing and reporting them in Test director.
• Regression testing was implemented at various phases of the development and test cycles.
• Version control and configuration management was done using PVCS.
• Performed basic security testing. Testing of Web Services using SOAP UI.
• Conducted back end testing by writingSQLqueries for database verification
• Study functional and business requirement documents and use cases
• Extensively performed manual testing process to ensure the quality of the software.
• Performed system testing, integration and regression testing manually with ICE website application.
• Worked with business and development teams to resolve various requirement issues. Performed defect tracking and defect management using Test Director and PVCS
• Used TOAD tool for database querying.
• Responsible for making Defect status report and Project status report every week.

Environment: QTP, Quality Center,JAVA, JIRA, Win Runner, Load Runner, Black Box, Oracle, Borland Silk Test 8.0, TOAD, Windows XP, Mind reef SOAP Scope Server, PVCS, Unix, J2EE, MS Office

Confidential

QA /Automation Tester

Responsibilities:

• Analyzed business requirements, System requirements, and Functional requirements.
• Involved In developing Test Plan, Test Requirements, Test Cases and detailed test cases in Quality Center.
• Used Waterfall model testing methodology for the testing approach.
• Done the Quality Center administration part like creating new users and providing the access to the new user to the specific domain and the projects.
• Performed Functional, System, Integration, User Acceptance and Back End Testing of the application using QTP and Silk Test.
• Used HP Quality Center (QC) and JIRA for reserving, executing test cases, defect tracking, and the complete test management
• Involved in Writing Functionality Test cases, Summary Test Cases and Details Test cases for different modules of the application.
• Prepared Test Data and created test input requirements for Data Driven Testing.
• Used the Defects module of QC to track, fetch, edit, retest and close the defects status.
• Participated In Test planning meetings and submitted Test case Status during the meetings.
• Data validation and Database integrity testing done by executing SQL, PL/SQL statements.
• Performed data driven test by passing parameter from xml files.
• Prepared the test data in CSV format and converted data from CSV to XML data files.
• Executed the test cases on UNIX environment and verified the output on UNIX and Windows platforms.
• Used the SOAP client and Web sphere server to process the xml files data on UNIX.
• Used Quality Center to track and report System Defects and written the description for the bugs of the application and helped the developers to track the problem and helped to solve it.
• Performed UAT using Fitnesse Test Automation Framework
• Conducted the load testing manually on the UNIX environment.
• Prepared defect review reports and weekly status reports for the applications.

Environment: QTP, Quality Center, Java, JIRA,VC++, Transact, UNIX, Windows XP/NT, IBM MQ series, SOAP, Silk Test 7.6, Quality Center 9.x, TOAD and Oracle.

Confidential,

QA Analyst

Responsibilities:

• Involved in Requirement Analysis of Mainframe and Web applications.
• Developed test plans, test cases, test conditions and test reports using Test Director.
• Extensively involved in testing of Claims processing on Mainframe.
• Tested the adjudication of Claims and Migration Process.
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation.
• Involved in Validation of HIPAA/EDI for 837 and 835 claims used for professional, Institutional and Dental billings
• Responsible for creating EDI(837) for different targeted test Health claim scenarios
• Responsible for End - End testing of BizTalk processes: Mapping to Xmls, 52ksds for Processor 1, Claim work items on Image work desk
• Tested and Validated Billing, Claims and Membership (subscriber) Applications.
• Responsible to Create detailed problem reports in defect tracking database of Test Director
• Bug Tracking was done using Test Director Involved in developing test plans by analyzing functional and design specifications.
• Used customized Bug reporting tool to create Bug report.

Environment: Mainframes, Win Runner 6.0, JAVA,Test Director, Load Runner,HIPAA,EDI Tibco,Java, HTML, Windows NT/ 2000.