PROFESSIONAL SUMMARY

• 8+ years of experience as Quality Assurance Analyst for several web and client/server applications in Banking, Insurance and Healthcare industries.
• Experienced in both manual and automation testing.
• Experienced in all phases of the Software Testing Life Cycle (STLC).
• Strong in analyzing Business Requirements and Functional Specifications, identifying Test Scenarios, developing and executing Test Cases.
• Experienced in performing Functional, System, Regression, User acceptance (UAT) and load & performance tests.

• Bachelor’s Degree in Science

Testing Tools

QTP, Load Runner

Management Tools

Mercury Quality Center and Rational Clear Quest

Programming Languages

C, Java, J2EE, SQL, .NET

Operating Systems

Windows, Unix and Sun Solaris.

RDBMS

DB2, Oracle, SQL Server and MS Access

DB Tools

Toad and DbVisualizer

Web Technologies

HTML, XML, JSP, Servlets, JavaScript, and VBScript.

Web Servers

Tomcat, Apache, IIS, Web Sphere, iPlanet(SunOne) Web Sphere

Web Browsers

Internet Explorer, Mozilla Firefox, Netscape

Application Servers

Web Sphere Application Server

Confidential,Omaha, NE Jan10 - Current
QA Analyst

CVS Caremark is the largest pharmacy health care provider in the United States. Caremark is uniquely positioned to provide greater access, to engage plan members in behaviors that improve their health and to lower overall health care costs for health plans, plan sponsors, and their members.

Responsibilities

• Used Quality Center to create manual and automated tests, build test cases, Test cycles, run tests, report and track defects.
• Generated reports and graphs to review the progress of test planning, tests run and defects tracked.
• Used Quality center to manage the requirements, test cases and also log defects and generate defect reports and graphs.
• Developed Test Plan and Test Strategy for multiple data feed applications.
• Developed regression test scripts for the application and Involved in metrics gathering , analysis and reporting to concerned team and Tested the testing programs
• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• As part of Data warehousing QA responsibilities, we have done with data verification and data validation of services providing by the Clear Vision system for business decision and reporting.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Written several complex SQL queries for data validation and data verification.
• Tested the messages published by data stage and data loaded into various databases
• Defined the Scope for System Integration Testing and was responsible to understand and train others on the enhancements or new features developed.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Tune and test the mappings to perform better using different logics to provide maximum efficiency.
• Written Test Cases for ETL to compare Source and Target database systems, Source to Target column level mapping , check Referential integrity etc and created the scripts accordingly.
• Created BTEQ Scripts to automate the test cases and extensively written test scripts for back-end validations.
• Identifying duplicate records in the staging area before data gets processed and ensured that the mappings are correct and conducted data validation.
• Testing the source and target databases for conformance to specifications
• Written several complex SQL queries for validating Cognos Reports.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Conducted review sessions on test case and regression test scripts in quality center.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.

Environment: Oracle 10g, SQL, PL/SQL, Data stage 7.0, EME, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant, UNIX, TOAD, Cognos 8.0 Series, XML, XSD, XML Spy 2008, Quality Center 10.0, Windows XP.

Confidential,Allen, TX Apr 08 – Dec 09
QA Analyst

HHMS helps home health care providers solve business problems with integrated solutions that advance the patient care process, reduce medical errors, increase productivity, improve business operations and drive profitability. A
Comprehensive online management system, the patient accounting solution integrates the Provider functions: patient billing, revenue and statistical reporting. It contains modules like Doctor Ledger, Intake Form, Patient Ledger, PCC Oasis, Schedules, and Visits and also provides reporting of Active Patient List, Patient Dues, Employee Reports, etc.

Responsibilities

• Analyzed the Business process specifications, Use cases, and User Interface specification documents.
• Testing and comparing the use cases with the legacy application Time Tracker.
• Created detailed Test plan and Test cases using Mercury Quality Center.
• Performed Manual Testing of the application, interacted with developers to resolve the identified bugs.
• Used Test director for bug tracking and for maintaining the test documentation.
• Participated in meetings with developers and business analysts to discuss about various enhancements for the application.
• Executed various SQL queries to extract the data from Database and to validate the updates done in the front end.
• Involved in documenting QA procedures using the MS Office suite.

Environment: Quality Center, Java, J2EE, AWT/Swing, JDBC, Oracle, Load Runner, MS Office.

Confidential, Mar 07 – Mar 08
QA Analyst
BlueSquared is the one-stop shop for all the Blue Cross Blue Shield Plan to Plan real time communications. It enables Plans to enrich member and provider satisfaction by improving efficiency in handling exceptions, enhancing operational capabilities around Inter-Plan business processes, and increasing the speed of exchange of claim-related information between Plans. It is integrated with the local processes like Electronic Content Management for document storage and retrieval, Paperless Inventory for Inventory Management and Cognos for reporting.

Responsibilities

• Acting as the QA for the twice a year mandatory business releases.
• Responsible for gathering and documenting the SDM artifacts for every release.
• Participate in reviewing the Business Requirements and User cases.
• Involve in creating the CRS and test data after reviewing the business requirements for every release.
• Prepare Test plans and test cases based upon Software requirements specification document.
• Participate in touch point meetings attended by Project Manager, Tech leads and other testers involved in the Project.
• Conduct Defect meetings and updating management about testing status.
• Create Testing metrics/Performance Indicators based upon testing execution to facilitate Testing Reports in adherence to SDM process.
• Validate inbound/outbound EDI transactions.
• Using Rational ClearQuest to log and track the defects.
• Involving in performance testing using Rational Performance Tester with Enterprise Testing Team. Providing Test cases and test data for Load test.
• Perform manual testing of the application using various case scenarios.
• Involve in the test team, test planning, test scripts design, test development, test execution and debugging.
• Participate in weekly project status meeting, discuss the testing approach & update the testing progress.
• Identify software problems, maintain bug reports, log the defects in ClearQuest and track the progress and results.
• Create a requirements traceability matrix using Microsoft Excel to make sure that all the requirements have been covered in the test cases.
• Perform Smoke test, Integration, Functional, Positive & Negative, Regression, System and End to End tests.

Environment: J2EE, Java, Struts, Spring, Hibernate, JDBC, JSP, XML, DB2, WebSphere MQ, Web Services, IBM Websphere Application Server, Load Runner, ESB Service Integration Bus, WebSphere and Quartz Scheduler, Jython, Ant, Cognos, Clarity and ClearQuest.

Confidential,FL Sep 06 – Feb 07
QA Analyst

OFSweb is a branch end-to-end, paperless and straight through availment processing environment electronically controlled by a centralized process management unit. It provides an automated workflow that takes the transaction data at the earliest point it reaches the Branch with the mission of managing all the process of consistency, approvals and enrichment up to the point the transaction is ready to be booked. It is integrated with credit system for real time availabilities, booking systems for automatic upload of transactions and backend systems to update the approvals. Lending Limit Control is a CACLSweb module to prevent the bank to grant loans beyond a limit established by country specific regulations to a Customer or Legal Group. There are various levels control based on the Bank patrimony and Obligor patrimony.

Responsibilities

• Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application.
• Participated and Initiated Team meetings on a regular basis and involved in active discussion in order to improve the testing and application quality.
• Involved in manual testing of the application following the complete transaction flow from Transactor to Operations work queue.
• Participated in understanding business issues, process flows and critical factors.
• Prepared test plans and test cases based on the requirements.
• Performed Integration Testing, System Testing and Regression Testing Executed testing in a fully integrated production like environment.
• Participated in the team meetings to discuss the issues arising out of testing.
• Responsible for back-end testing/database testing, which was done using SQL queries.
• Actively participated in regular Defect Calls to discuss the defects to resolve them in efficient and timely manner.
• Tracking Defects and reporting the bugs to the developers using the Clear Quest.
• Re tested the new builds to make sure that the bugs have been fixed and close the defects.

Environment: QTP, Quality Center, MS Office, Clear Quest, J2EE, Java, JSP, Sun One Web Server, Excel Macros, Oracle 9x, PlanView/eTrax, Microsoft Project.

Confidential,FL May 03 – Aug 06
QA Analyst

CACLSweb system manages all credit lines extended to the corporate customers, keeping an updated position of their usage in order to inform availability of funds for new transactions. Many of the front-end systems for booking transactions needs the real-time availabilities for the customers and hence depend on CACLS to provide the availabilities and reserve the lines. One of the important features of CACLS is that it helps the users with risk tracking and legal lending limit control. Another important aspect is, all the outstandings are automatically picked up from the back-end systems on a daily basis and there by allowing the system to maintain the actual availabilities.

Responsibilities

• Analyzed system requirements and developed Test Plans and Test Cases.
• Performed both Manual and Automated tests to conduct Functional and Regression tests on the application modules, mainly focusing on Relationships, Credit Approvals, Presented Collaterals, Operations and Legal Lending Limits. Automated the same using Mercury Suite.
• Involved in creating Test scenarios and tested with Load Runner, which accurately emulates the system.
• Performed the Functional, System and Regression testing to validate the custom changes for the rollout working as defined and the other functions are not broken.
• Interacted with various development Teams, Business Analysts, Project Leaders including Off-shore/ Onsite team and other QA teams.
• Involved in setting up data and required environment for UAT Testing.
• Executed SQL queries to perform the Backend Testing on database.
• Involved in weekly status updates showing the progress of the testing.

Environment: Test Director, Load Runner, MS Office, J2EE, Java, Swing, Struts, Hibernate, JDBC, JSP, XML, AJAX, Oracle, IBM MQ, IBM Websphere Application Server, Sun One Web Server, CVS, Merant PVCS, PlanView/eTrax, Microsoft Project.