Summary

• Around 7 years of Professional IT experience (Manual & Automation) and Maintenance.
• Experience with QA Methodology, SDLC and QA Validations to ensure the Quality Assurance Control.
• Extensive experience in Manual Testing.
• Experience in Functional Testing, Stress Testing, Regression Testing and Integration Testing
• Extensive experience in writing Test Plans, Test Cases/Scenarios, Test Procedures and analyzing Test Results.
• Experienced in developing Test scripts for Manual as well as for Automated testing using Mercury tools.
• Extensive experience in Comparing the Actual Test Results with Expected Results using Regression Testing.
• Experienced in Test planning, Functional, Integration, Regression and UAT testing manually and using automated testing tools like QTP, Test Director8.2.Quality center9.2
• Over 5 years of experience in CRM applications in Testing, Data Migration, Configuration, Integration and Customization of Siebel 7.x/6.x
• Excellent Problem Solving skills, communication skills, trouble shooter, strong drive to exceed customer expectations.

Technical Skills:

Siebel Tools & Siebel Analytics Server (SAS) Admin Tool Configuration and application Development, Data Models, Business Models and Data Schemas, Business Processes and Workflows, (eEvents-Financial, eMarketing and eSales), eScript, CTI, EIM, EAI and VBC, Siebel Field Services, Sales, Siebel Analytics, Call Center, Personalization, Marketing (Email, Offers-FAX/Wireless/Web/Email, Campaigns, Segments, eEvents, Quality Control, Admin), Data Quality, List Mgt and Analytics (eFinance, eInsurance, ePharms, Mktg and Sales)

Informatica and Siebel Analytics

Functional knowledge & Testing

Solid understanding and hands-on experience in Marketing, Sales, Call Center, Personalization, Data Quality and Analytics.

OOAD, SDLC

Operating System

Unix (AIX, Solaris, HP-UX), Windows NT/2000/XP

C, C++, VC++, SQL, PL/SQL XML, HTML, Unix Internals & Shell Scripts

DB2, Oracle, SQL Server 2000

QTP, SATA, Test Director, QTP and eBiz

MS SQL Server 2000, Sun ONE, Websphere, WebLogic and Apache Tomcat

Confidential, May07 to Till Date

Sr QA Tester
Project: Subscriber Queue Enhancements (Form Ware)

This project is centered on four indexing queues within the FormWare Other Document Processing Indexing (ODPI) Workflow. Subscriber, State-Subscriber, Group Membership, and State Group Membership queues all index the following types of documents; Correspondence, Group Correspondence, Back-End Enrollment Forms, etc. This indexing is also classified as either Front-End or Back-End. Current processing templates and limited rules make it difficult for operators to enter complete and accurate data for backend customer service inquiry systems.

This project will re-organize these four (Subscriber and Group) queues into two new Back-End and Front-End queues to more effectively manage the work. It will create new templates focused on capturing data specific to the document type and new validation rules will insure accuracy of the data routed to IPD, Service First, and other back end resources.

Responsibilities:

• Involved in Preparation of Test Metrics & Test Cases.
• Involved the Scan DocTypes going to FrontEnd or BackEnd
• Validated document versions in file net
• Verified images are stored in file net with different formatters
• Verified stored document in an order based on the requirement
• Verified work flowsfor check in , check out document and businesstriggers
• Verified form ware Queue, and ran the form ware process
• Verified Image Display and Data, QA validation
• Worked with setting up the end user rules in form ware and worked as an administer role by accessing administer consol
• Validated data in the target system while passed through the form ware
• Validated the documents are rooted to the appropriate queues
• Verified Audit and admin functionality
• Verified entire form ware business rule are implemented in the project
• Performed Reporting and defect tracking using Quality Center.

Environment: FormWare, FileNet , Tera Data , Quality Center 9.2

Project: ACS Member Eligibility File Enhancements

ACS Benefit Services, Inc. receives a daily transaction and monthly member eligibility file from Blue Cross Blue Shield (BCBSNC) of all Dental Blue membership. ACS loads the daily transactional changes to ensure that the member records reflect timely changes made in the PowerMHS system. On a monthly basis, ACS uses the monthly Full file to reconcile all transaction records are recorded in the ACS Dental Blue system. The member eligibility files are used to accurately quote benefits and ensure that claims are processed correctly. Eligibility records not accurately reflected in the ACS Dental Blue system can prevent ACS from quoting correct benefits or processing claims correctly.

Responsibilities:

• Responsible for Preparing Test Stragegy, Test plan.
• Validated i-series Files (AS400) for monthly and daily extract process.
• Verified the daily transactional file must be created prior to generating the monthly full file.
• Responsible for querying the DB2 database and verified the Extract has been successfully completed by writing the SQL queries.
• Verified that ACS Extract file has successfully routed to ACS Vendor.
• Analyzed requirements, Functional requirements and Design documents, and developed Test plans for different Testing stages.
• Analyzed the Use cases provided by Business analysts and wrote Test Cases.
• Experience in executing test scenarios and analyzing the test results and documenting the test results in Test Director
• Defects are tracked and reported using Quality Center
• Maintained Metrics participated in weekly status updates showing the progress of the testing effort and open issues to be resolved.
• Responsible for Member Enrollment in Power MHS.
• Designed Traceability matrix based on functional requirements and Technical Specification.

Environment: AS 400, Siebel 7.8,PMHS, Quality Center 9.2

Project: Online Plan Management

Online Plan Management is a project that involved putting up a GUI against PMHS so that the process of Enrollment and billing the group subscribers is handled with ease.

Responsibilities:

• Provide REBO with a tool to more fully automate and improve the efficiency of group and member enrollment and maintenance processing, replacing the current AGE system and minimizing the need to make changes using PowerMHS screens.
• Involved in Functional, Integration and Regression Testing.
• Writing Test Plans, Test scenarios and Test scripts
• Creating different types of scenarios to test the functionality.
• Provide Producers on-line access to key enrollment and maintenance tasks.
• Provide groups the on-line ability to view and pay invoices, view payment history, and process member maintenance transactions for their members.
• Reported and tracked function defects using Quality Center
• Integrated testing is done between E - Billing application and Power MHS.
• Designed Traceability matrix based on functional requirements and Technical Specification.

Environment: E-Billing, PMHS, Quality Center 9.2, Tera Data

Project: Commission Initiatives

Commission Initiatives 2007 was a project that involved different deliverables, the one that I worked on were as follows:-

Responsibilities:

• Synchronization of the enrollment systems (MHS, LRSP) with the PSOR consequently. Improving the process by which subscriber billing transactions are handled during the monthly commission cycle.
• The sync amongst the various systems was tested by seeding the data in one then looking for that in the other to make sure that its flow is consistent. And different relationships that were there in one system are the same in the other.
• Revisions to Commission Statement and Development of Monthly and Year to Date Production Reports for Health & Life.
• This involved the validation of the Actuate Reports. Data present in the reports was verified against the one that was there at the backend. Testing involved writing SQL queries using query analyzer to retrieve data from SQL server and comparing the same with what we got in reports.
• Prepared Test Plans according to the requirements.
• Creating different types of scenarios to test the functionality.
• Created and executed detail function test scripts based on the business requirements.
• Reported and tracked function defects using Quality Center
• Involved in Functional Testing, System Testing ,UIT and Regression Testing.

Environment: Siebel Actuate Reports, SQL query Analyzer , Quality Center 9.2, PMHS

Confidential, Chicago, IL Feb06 to Mar 07 Sr QA Tester

Confidential, conducts business through four primary business lines Retail Banking & Financial services, Home Loans, Commercial Banking, and Card Services the current project mainly deals with Universal Desktop application developed in Siebel 7.8 that will assist the banker in promoting Sales by standardizing processes, as well as increase service levels and savings. Enterprise Customer Care, National Direct Sales, and Consumer Direct will share one universal application have the ability to present Offers to customers and create referral based upon a response. Loan Consultants will be able to create offers for the customers that are associated to an accounts Loan Consultants will have access to create modify offers for the customer will make the customer's experience more personal and effective.

Responsibilities:

• Involved in Preparation of Test Plans & Test Cases.
• Involved in Functional, Integration and Regression Testing.
• Experience in manual testing of Service Express application written in COBOL language using IBM Mainframe TSO, CICS, IMS, DB2.
• Developed scripts for Functional, Reports, Seed & Transactional Data.
• Involved in Testing Screens, Views, Applets, LOV's.
• Involved In Testing Seed & Transactional Data.
• Verified IVR Calls using CTI in Siebel.
• Involved in Testing Various Online and Batch Interfaces.
• Developed automated test scripts using QTP from Mercury Interactive.
• Installed and Configured QTP 6.0/6.5 and Siebel Add-Ins with Local Licenses.
• Reported Defects Using Test Director and involved with developers to resolve various technical issues.
• Designed Traceability matrix based on functional requirements and Tech specs

Environment - Siebel 7.8 ,QTP, Test Director 8.0, E-Script, Oracle,Mainframes,DB2, Windows NT.

Confidential, (NJ) Jan 05 to Jan 06
QA Tester

Confidential, is the world\'s most comprehensive and broadly based health care products for the consumer, pharmaceutical and medical devices and diagnostics markets.

Viewpoint, which is ePharma Siebel 7.8 CRM application integrated with Siebel Analytics .
Modules involved are Sales Force Automation (SFA), Managed Markets (MM) and Call Center Customer (CCC). Siebel ePharma pre-call planning, call entry and calendaring application designed for the Compaq/HP iPaq that seamlessly integrates with Siebel .

Responsibilities:

• Involved in two phases of Dry Run where the application is tested with respect to its typical working environment.
• Performed functional Testing of the Viewpoint checking the functionality of the application.
• Involved in two phases of System testing where the application is tested with respect to its typical working environment.
• Involved in two phases of Integration Testing where the viewpoint is integration of Analytics.
• Verified IVR Calls using CTI in Siebel.
• Used Test Director 8.0 as a Management Tool for systematic control over the testing process.
• Did Black Box Testing and White Box Testing for the MM, SFA and CCC.
• Maintained a project database of tests that covers all the aspects of the application functionality and organized the tests into unique groups.
• Involved in User Acceptance Testing (UAT) of the Modules MM, CCC and SFA.
• Defect tracking is done in the Test Director 8.0 through Defects Tab to add, review, repair and analyze defects.
• Extensively worked on synchronizing the thin client to the Handheld (palm) and completed successfully.
• Used QuickTest Professional for best solution for functional and regression test automation .
• Conducted regression testing using the Automated Tool (QTP)

Environment: Siebel ePharma 7.8.2, Compaq/HP iPaq, Test Director 8.0, Windows 2000 Professional, Oracle 9i, PL/SQL, QTP 8.0.

Confidential, NYC,NY Jan 03 to Dec 04
Implementation of Siebel-CRM
QA Tester

Description - Teachers Insurance offers insurance to consumers in three ways namely Small Group, Large Group and Individual. Small Group and Large Group are for companies and Individual for individual persons. When the campaign takes place for insurance, Harte Hanks conducts surveys and based on these surveys, they provide with the projects in a flat file, which are uploaded into Siebel as leads. The telemarketer calls the leads and takes all the information to create an Opportunity, Quotes, Census and generates Proposal. SGEO Analyst checks all the documents and sends it to MUD. MUD will make the decision whether to provide insurance or not.

• Writing Test Plans, Test scenarios and Test scripts
• Creating different types of scenarios to test the functionality.
• Monitoring Siebel Test Servers such as SRF and Work flow events.
• Validated Seed Data such as LOVs, Workflow policies and Repeating Components.
• Incident tracking and reporting through TestDirector7.6
• Testing Siebel Applications and modifying test scripts as per the requirement.
• Involved in Functional Testing and Regression Testing.
• Testing team Administrator for Test Director
• Work closely with Project Lead to help ensure project goals are met.

Environment - Siebel 7.0, Winrunner, TestDirector7.6, E-Script, DB2, Windows NT and UNIX.