PROFESSIONAL SUMMARY

• Around 8 years of strong experience in Quality assurance testing of web and client/server applications.
• Experience in all aspects of the SDLC, with specific focus on testing and experienced on different system testing tools to test the functionalities.
• Thorough understanding of software development life cycle and different methodologies like waterfall, Agile and Scrum.
• Extensive experience in Manual and Automated Testing of GUI and functional aspects of the Client-Server and Web based Applications on multiple levels of SDLC.
• Good Understanding of requirements and analysis diagrams Use Cases, State Diagrams, and Activity Diagrams.
• Experience in preparing the requirements traceability matrix and in designing specifications and reviewing.
• Responsible for creating, documenting and developing test Plans, test cases and test scripts.
• Experienced in performing Automated testing using popular tools such as Mercury Interactive QTP, WinRunner, Test Director, Rational suite. Proficient in quick test in customization and creating checkpoints, synchronization points, parameterization (data-driven test) and break points.
• Performed Functional, GUI, Regression, End-to-End, User-acceptance, Back-End, Stress, Migration, System testing and Integration testing.
• Have good knowledge in web services where SOAP (Simple Object Access Protocol) is a XML-based protocol to let application exchange information over HTTP.
• Have experience in Siebel data models in order to test the data bases as part of backend testing and have good knowledge of Siebel architecture( physical and application)
• Have good knowledge in testing the EIM tables where data use to get from different source systems to Siebel system using Informatica tools.
• Responsible for testing the EAI messages where the Siebel messages used to trigger the data to external databases.
• Have good experience in Physical and logical data models of the relational databases in order to test the databases where data is correctly stored in the required fields.
• Strong experience in Back-End testing using SQL queries in SQLServer 20005, Oracle 9i/10g.
• Extensively tested ETL Batch Interfaces testing between different application
• Experience in working with Java, VBScript, XML, HTML/DHTML, C, and C++, ASP.Net, C#.Net, SQL, VSS, CVS ability to prioritize tasks well and work on multiple test projects at the same time.
• Excellent communication, leadership, and interpersonal skills.

TECHNICAL EXPERIENCE

Testing Tools

Mercury Quality Center 9.2/8.x, Mercury Quick Test Pro 9.5, Rational Clear Quest 7.2, HP screen recorder, Data studio 2.0

Business Tools

INFORMATICA, UML, TIBCO

Languages

C, C++, VB Script, Java 2.0, J2EE, and XML

Application Server

BEA Web logic, Web sphere

Siebel Skills

Siebel Sales, Siebel Marketing, Siebel Call Center, Siebel Finance, Siebel Communications, Siebel eSales, Siebel Integration, EIM, Siebel Tools.

Data warehouse

Informatica, Data stage, Cognos, Business Object.

Packages

Siebel 7.5/7.7/7.8/8.1.

Front End

Visual Basic (5.0/6.0), HTML, ASP.NET 3.0, VB.Net 3.0, C#.Net 3.0. Java 2.0, Mainframe systems, IMS, TSO, EVT, AS400

Database Skills

MS SQL 2005/2000, Oracle 10g/9i, Sybase, MS Access, DB2

Operating System:

Windows XP/ 2000/ 98/ 95, UNIX, and MS-DOS

EXPERIENCE

Confidential, Jacksonville, Fl. (Florida Blue) Dec 2009 to Present
Health Care

Sr QA Analyst

Project Synopsis:
Blue Cross Blue Shield of Florida is a Leading Health care provider in Florida. The company provides Insurance to different Organizations and Individuals. The Solution has capability to support BCBSFL Sales, Enrollment, Billing and claims Services.

Projects: 
Enrollment and Billing :
Enrollment and Billing project involves the sales, Enrollment and Billing of the Small and large groups Health Insurance plans. RBMS (Mainframe system) is source system and Integrated with different vendor web application are maintained by BCBSFL.

CCP(Common Customer Platform):
Siebel CRM application is used as front end to support the BCBSFL ‘s e-sales where integrated with different BCBSFL Internal agent applications called Small group portals(SGPT), large groups (e-rate) and IST (Individual sales) for Agents sales which internally Integrated with Mainframe systems.

Responsibilities:

• Obtaining, Analyzing and reviewing copies of the project specification, business requirements documents that comprise the application in the design phase.
• Perform system analysis and understand the deliverables within SDLC using agile methodology.
• Having experience in using Rational Requisite pro. Responsible for verifying the use cases and preparing test scenarios and scripts to verify data integrity, functionality and adherence to business requirements.
• Develop and maintain a Master Test plans and Test Evaluation summary that defines all actions, deliverables, responsibilities and procedures to satisfy the user/customer quality andvalidation/qualification requirements
• Coordinate/Assist with Business analyst with technical/process and scheduling test cases/scenario reviews, work between the staff, internal and external QA integration teams, and the client development and management teams.
• Organized the test cases in Mercury Quality Center for traceability and monitored test results, tracked defects and communicated them using Mercury Quality Center.
• Coordinate deployments on a shared environment with other QA groups participating in the project
• Responsible for validating functional and maintenance of application for a given functionality in web application systems.
• Perform Integration Testing between application and external application/data
• sources
• Identify/work with development on the creation of test data needed for execution
• Coordinate with the third party Vendor/Internal web application and verify the functionality is working as per business requirements.
• Work with development team to resolve defects and any environment issues
• Report test status to QA Manager and client management
• Functional expertise in Healthcare Insurance sales, Enrollment and Billing.
• Used to lead the onshore and external team and communicating with the third party vendors.
• Responsible for Smoke Testing, System Testing, Integration Testing, END to END Testing and Regression Testing.
• Executing ofScripts, defect logging and Bug tracking through an interface withHP ALM Mercury Quality Center. HP screen recorder for defects and lead the project defect calls.
• Responsible for validating the XML files generated from internal system to external vendor system.
• Utilized the Mainframe systems (TSO/ISPF, SDSF, FTP, EVT, IMS, JCL, COBOL, CICS, AS400) for generation of Gmax/Imax flat files, running the JCL jobs, transferring, Edit and validating the Data sets, reports,
• Identified the data scenarios and extensively used SQL queries for data verification as backend DB2 databases testing using SQL statements like SELECT, JOINS, UPDATE, INSERT
• Extensive experience in Backend testing and DB2 Database Validation using Quest Central and Data Studio.
• Performed comparative analysis and gap analysis to identify variation in the process as per HIPAA X12 4010 and 5010 guidelines to incorporate updates as per 5010 guidelines and verify mapping to X12 format
• Used to report weekly status attend the meetings showing progress and future Testing efforts to QA manager.

Environment: Siebel 8.0, C#.NET 3.0, ASP.Net 3.0, JAVA, JSP, EJB, Java Script, Mercury Quality Center 10.0, DB2, Data studio 2.0, Hp screen recorder, XML, MS Office 2010, EAS, Mainframe systems- IMS, TSO, JCL, EVT, AS400, OBIEE tool, Rational Requisite pro, Windows XP professional.

Confidential, Maynard, MA. Jul 2008 to Nov 2009
Sales/ Service

Sr QA Analyst

Project Synopsis:
Monster is the leading global online careers property that has changed the way people looks for jobs; the way employers look for people; and the way companies connect with their target audience. Monster.com is for everyone by connecting quality job seekers at all levels with employers and providing the best career advice available online. The Karma Application I worked is based on Customer Relationship Management System (CRM) which is Siebel Sales and Finance modules. Where the application developed in Siebel 7.5 and upgraded to Siebel 8.0 and also Unicode Implementation is done.

Responsibilities:

• Analyze the Business Requirements Document (BRD),Functional Specification
• Documents and performed gap analysis.
• Wrote the Test Plans &Test cases in Quality Center based on the Functional Requirements and High level design documents for functional and end to end test cases.
• Worked closely with cross-functional team members (Developers, other testers and end-users) to understand business and technical requirements to derive the data requirements.
• Involved in Functional Testing of Siebel entities like Quotes, Orders and Adjustments, Opportunities, pending leads according to the requirements
• Responsible for testing the financial system requirements like Order verification by different types of payment methods.
• Responsible for Communicating the offshore team and check the status.
• Responsible for testing the different Products and pricing for different countries.
• Responsible for Smoke Testing, System Testing, Integration Testing, END to END Testing and Regression Testing.
• Identified the data scenarios and extensively used SQL queries for data verification as backend testing.
• Responsible for writing SQL Queries for data Verification.
• Worked on many SQL statements like SELECT, JOINS, UPDATE,INSERT
• Used to run and develop the automated scripts for regression testing once the manual test cases are passed.
• Responsible for assisting UAT testing.
• Developed Automation test scripts using QTP for Data Driven Testing
• Recorded the actions of application in QTP, made enhancements to the VB Script recorded in Expert view.
• Experienced in Data Validations for the Unicode data in Siebel Application by verifying weather the data is correctly shown in Siebel fields and database.
• Executing regression test suite in QTP and analyzing test results and logging defects in the Clear Quest.
• Responsible for weekly status attend the meetings showing progress and future
• Testing efforts.

Environment: Siebel Call Center 8.0, Mercury Quality Center 9.0, SQL Server 2005, Toad, Rational clear quest 7.0, C#.NET 3.0, ASP.Net 3.0, QTP 9.5, Windows XP professional.

Confidential, Los Angeles, CA Jan 2007 to June 2008
Financial Industry

QA Analyst

Project Synopsis: 
The Project is iCON (Institutional Client On-Line Network) and is based on Customer Relationship Management System (CRM) which is financial Industry which holds all the Investment funds. iCON has a relational database, This Application will over time hold all of the information related to clients, Prospects, Consultants, 3rd party Organizations.

Responsibilities:

• Analyze the Business Requirement Document (BRD), Functional Specification Documents and physical Data Model (PDM) to prepare Test Cases based on Test Plans.
• Developed test cases, different test plans for Interface testing (Data Integration, migration) scripts in Quality Center 9.0 based on Design documents.
• Worked closely with team members (developers, testers and BA’s) to understand business and technical requirements to derive the data requirements
• Verifying the financial Investment funds with the particular time periods the cash flow is updated.
• Responsible for writing test cases and test scripts for functional and end to end testing.
• Lead and mentoring the onsite and offshore team.
• Involved in developing the test cases considering both real time positive and negative scenarios that could take place in all the major Smart Scripts involved in the application
• Assisted the UAT testing team for testing the functionalities.
• Responsible for writing SQL Queries for data Verification.
• Have good knowledge of OLAP and OLTP systems.
• Tested and verified the creation of OBIEE reports, dashboards and BI Publisher based on business user specifications.
• Responsible for testing the ETL Batch Interfaces (INFORMATICA) from different databases to Siebel UI.
• Used to run the ETL jobs using Auto sys and Responsible for running the EIM jobs to load data into the Siebel.
• Verified Siebel EAI instant XML messages to load data into the different target systems.
• TIBCO Business Works tool used for Data Integration to receive Siebel EAI messages send messages to ODS (Operational Data structure) through Enterprise Service Bus (ESB).
• Also responsible to check weather the correct type of messages are logged in LOG/AUDIT tables while messages are flowing from Siebel UI(Siebel) to ODS(database) and vice versa.
• As part of Data Integration testing, Done Data Validations for Siebel and ODS database Using TOAD.
• Verified the customized Screens, Views, Applets and Pick Lists in Siebel application as part of UI testing and End to End Testing.
• Executed SQL queries for data verification in ODS database as backend testing.
• Responsible for testing the transformations of the ETL Processes (Extract, Transform and Load) to load data in the Data warehouse and created test data for testing an done test documentation.
• Extensively used SQL Queries on data bases for Data Verification
• Responsible for testing the Interfaces from different legacy systems to ODS database.
• Used verify the XML messages sent by Siebel to verify weather the data sent by Siebel is correct or not.
• Involved in developing the automated scripts and maintenance of the scripts.
• Involved in Smoke Testing, System Testing, Interface testing and Regression Testing
• Executed SQL queries for data verification in ODS database as backend testing.
• Worked closely with the developers in resolving those defects and retest as part of regression testing.
• Executing regression test suite, analyzing test results and logging defects in the Quality Center.
• Environment: Siebel call center 7.8, Quality Center 9.0, Oracle 10g, QTP 9.2, EIM, Windows XP professional, Sybase, DB2, Toad, Quest Central, XML,UNIX, SQL server 2005, TIBCO, Java, XML, SQL Server, Informatica .

Confidential, Bloomington, IL. Mar 2004 to Dec 2006
QA Tester

Project Synopsis:

• The Application deals with the day-to-day transactions of policies and claims of different financial sectors, like Auto, Home and Life. The application gives lot of flexibility to the insurer to access the whole details and transactions of his policy online. Customer can claim online and they can change or edit their claim online. The application consists of many details like Insured information, General loss information and Basic information.

Responsibilities:

• Analyzed the user and functional Requirements using use case diagrams.
• Prepared detailed Test Plan and Test Cases for functional, Integration GUI and Database testing.
• Involved in testing policy types Liability and Full-coverage.
• Performed testing in different types of buying insurance policy thru Agent or Directly from insurance company.
• Developed detailed Test Cases according to Functional Requirements using Quality Center.
• Involved in Backend testing using extensively SQL Queries for Data Validation for testing database.
• Performed manual testing by entering positive and negative values to the Application and updated test case document with results
• Used to run and develop automated test scripts as part of regression testing.
• Worked with recovery scenario managers, check points as part of automated testing.
• Documented and communicated test results.
• Performed Black Box, Integration, Regression Testing.
• For tracking the defects used the Quality center and documented as part of Interface testing verified the required data is loaded from flat files into the Siebel database.
• Worked with development team to ensure testing issues are resolved on the Basis of using defect reports.
• Investigating bugs and reporting to the developers.
• Performed System testing by executing the test script.

Environment: Siebel call center 7.7, Mercury Quality Center 8.0, Toad, Oracle 9i, QTP 8.5, C#.NET 3.0, ASP.Net 3.0, JAVA, JSP, EJB, Java Script, Windows 2003/NT.

EDUCATION

• Masters in Computer Science.
• Bachelors Degree in Computer Science.