Resume

Sign in

Manager Test

Location:
Frisco, Texas, United States
Posted:
September 10, 2018

Contact this candidate

Resume:

Devika Anumolu

Telephone: 469-***-**** E-mail: ac6zv2@r.postjobfree.com

CLEARENCE

MBI

EDUCATION

Bachelor of Science

PROFESSIONAL SUMMARY

Over 13 Plus years experience in Requirement Analysis, Quality Assurance, Quality Control and Testing of Client Server, e-commerce, Life Insurance, Health Insurance, financial, Point of Sale (POS), Mainframe and Web-based applications. Experienced working with Governmental Organization and Fortune 500 environment such as FISA, New Jersey Motor Vehicle Commission and Internal Revenue Service’s (IRS).

Extensive knowledge of Software Development Life Cycle (SDLC) process/ Software Development Engineer in Test(SDET), Quality Assurance (QA) Lifecycle and Software QA methodologies and has good understanding of Relational Database Management Systems (Oracle, SQL Server).

Working experience in Waterfall, agile development methodology and scrum teams.

Experience with both manual and automation testing using Mercury, Rational and Microsoft tools.

Expert in analyzing Business Requirements and developing Test Plans, Test Strategy, Test Cases, Manual and Automation Test Scripts.

Expert in creating new Test Data for Test Conditions and Test Scripts.

Working experience on Functionality Testing, Integration Testing, GUI Testing, System Testing, Database Testing, Regression Testing, Security, Performance Testing, User Acceptance Testing(UAT), Black box Testing and White Box Testing .

Experience in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tools such as JIRA, ClearQuest, Quality Center, MS Visual Studio & TFS (Team Foundation Server)

Experience in maintaining support documents, QA Sign off Documents and maintaining Weekly Status Reports

Experience in the implementation phase of a Data Warehouse application. Tested if computations involving business rules are correct and inserted correct values into target warehouse tables. Was involved in every aspect of project from beginning, entire coding part in, to tracking of work progress.

Experience in preparation of Test Data to test the functionality of ETL Sources Mappings and Targets.

Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing

Strong working experience in ETL,Pivot and Data Audit Frameworks

Can demonstrate critical thinking and an aptitude for learning new concepts.

Ability to work independently, as well as, in a team environment.

Ability to organize and prioritize work and to meet tight deadlines

I have excellent oral and written communication skills and confident in providing training to QA Team (Other Testers) on testing applications.

TECHNICAL SKILLS:

BOE(Business Objects), Tableau, Data Mart, Big Data Analytics, ETL, Greenplum Data base, PGAdmin, Rational Suite 2002/2003 (Robot, ClearQuest, ClearCase, IBM Manual Test Manager, Rational Test Manager, Rational Manual Tester 7.0, Rational ReqPro 7.0, Rational Functional Tester (RFT), Rational Performance Tester (RPT), ClearCase, JIRA, Visual Studio, Team Foundation Server, Microsoft Test Manager, Test Track, IssueNet, Web Services,Test Director 8.0, QTP8.2, Quality Center, Mercury Tools 6.5, C,C++, object oriented programming language, HRMS 7.5, PeopleSoft 7.52 Financial & Distribution (AP, AR, BI), PeopleSoft 7.60 IA, People Tools, People Code, BO 6.5/XI, Oracle Oracle9i/10g, JSP, Servlets, EJB, HTML, DHTML, XML, UML, JavaScript, Java, J2EE, .Net,DB2, SQL, SQL Loader, SQL Server, Postgre SQL, Shell Scripting, Visual Basic 5.0, OS/390, File-Aid, Trizetto Facets 4.32, Sybase, MQ Series, EDI, Toad, MQ Series, WebSphere, Informatica5.1, Windows XP Professional, Win 98/NT, UNIX (Solaris), UNIX scripts, UNIX (AIX), Linux, Apache Server with Browser Clients, SOW, SOX Compliance, AS400, Selenium,Mainframes (COBOL, QMF, DB2, SQL, TSO/ISPF, JCL, CICS, TSO, MVS, SPUFI, PANVALET), MS-Excel, MS-Word, MS Access 2K, MS Project.

PROFESSIONAL EXPERIENCE

Apr 2018 - Present Global Life Insurance(Torchmark Corp) McKinney, TX

Senior QA Lead

Responsibilities

As a QA Lead, analyzes Requirements and provides project estimation, test design, defect management, and risk assessment.

Works in iterative Waterfall environment/Agile development methodology and scrum teams.

Ability to organize and prioritize work and to meet tight deadlines

Expert in QA testing principals, software development process, and software development tools.

Performs project management activities at both the project and release level

Ability to determine data-layer test strategies, write detailed test plans providing test approach, function/features to be tested and a comprehensive test summary report with results, write/execute test cases and enter bugs for failed tests.

Creates test data requirements for the assigned reports

Support to Maintenance Production Releases and as well as trained other Testers on testing applications.

Support to User Acceptance Testing.

Analyzes the Control and Dataflow services within ETL packages.

Good understands runtime services via jobs and stored procedures.

Can demonstrate critical thinking and an aptitude for learning new concepts.

Analyzes Business Requirement Documents(BRDs), Functional Design Documents(FRDs), Specification Design Documents(SDDs) to design and execute Unit, Functional, System Integration, Regression, UAT,Re-test, Security, Performance and Ad-hoc Test Scenarios, Test Procedures, Test Cases in word document and Test Data for testing different functionality of ETL Frameworks, Data Audit Framework, Pivot Framework for each work stream and Tableau Reports.

Develop and deliver Data gaps QA services for data integration (ex. DW) and business intelligence customer teams

Develops and executes Structured Query Language(SQL) queries in Oracle SQL Developer Tool(Oracle Insurance Policy Administration(OIPA) as well as in Microsoft SQL Server to perform Back End Testing.

Testing the data replication and Extract, Transform, Load (ETL) services from source to target data objects and usage of data comparison techniques

Testing the Oracle Attunity Replicate usage and functions

Testing the Operational Data Store (ODS) datamart

Testing the ETL Frameworks,Jobs and workflows using the Informatica PowerCenter Workflow Monitor

Validates the integrity of data between source and target objects using data validation techniques (ex. record counting, Checksum function, etc.)

Testing the ETL,Pivot and Data Audit Frameworks

Develops and executes SQL queries to validate Data Manipulation Language (DML) functions of data states within databases.

Compared source data(OIPA) with the data pushed into the SQL Server(ODS) system to make sure they match

Validated the right data is extracted and loaded into the correct SQL Server(ODS) location

Data aggregation or segregation rules are implemented on the data

Key value pairs are generated

To check the transformation rules are correctly applied

To check the data integrity and successful data load into the ODS target system

Testing the SOA Interfaces using SoapUI 5.2.1/Postman.

Tested SOA processes and methodologies used to deliver Customer order application, New Web application for quality standards interface to meet customer expectation.

Performed Web Service Testing experience using SOAP UI.

Continuous delivery and Continuous integration testing the Oracle Policy Administration (OIPA) application using SQL developer and SQL Server 2014 Management Studio.

Involved in validating SOAP XML specifications as per the standards.

Functionally validated Web Services delivered in SOAP XML format as provided in specification document.

Create documentation and test results then uploaded to SharePoint once reviews and peer reviews done.

Logging the defects in Microsoft Team Foundation Server(TFS) for any issues found in testing

Working with the development team and deployment team to troubleshoot and determine root cause for testing issues then retested again once the issue is fixed by the developer.

Perform different types of testing like unit, Functional, Sanity, Positive, Negative, System Integrating, Regression, Ad-hoc, Performance, UAT, Security and Retests.

Resolve issues, prioritize test cases, escalate defects by working closely with business analysts, output developers, database developers and release manager.

Responsible for review of test artifacts and provide suggestions to the test team.

Conducts peer reviews internally and with externally.

Create Traceability Matrix in Mirosoft Test Manager(MTM) Tool and in Excel Spread Sheet(Excel).

Conducts weekly status meetings and defect review meetings.

Conducts testing status on a regular basis.

Prepares weekly testing status for the Manager.

Environment: ETL Informatica 10.1.1 HF2, Cognos, DataStage,Tableau, Business Objects, ODS Data Mart, Microsoft SQL Management Studio 2014, Oracle SQL Developer 4.1.3.20, Microsoft Team Foundation Server(TFS), SoapUI 5.2.1, Postman, Hadoop, GreenPlum(BDA), Teradata, XML, Microsoft Test Manager2017, Microsoft Visual Studio 2017, PuTTY, JIRA, Web Services(SOAP), XML, MS-Excel, MS-Word, MS Access 2K, SOX Compliance, ODS, Toad, SQL Developer, PuTTY, Oracle 10g, SSIS, SOA, JAVA, J2EE, Selenium, TIBCO, JMS, DB2, JCL, WINDOWS XP Professional, UNIX.

Nov 2013 – Apr 2018 Internal Revenue Service Farmer’s Branch Dallas, TX

Senior QA Lead

Responsibilities

As a QA team Lead, analyzes Requirements and provides project estimation, test design, defect management, and risk assessment.

Performed project management activities at both the project and release level

Developed Test Plans

Worked in Agile development methodology and scrum teams.

Expert in QA testing principals, software development process, and software development tools.

Supported to Maintenance Production Releases and as well as trained other Testers on testing applications.

Supported to User Acceptance Testing.

Analyzed Business Requirements, User Stories, Mock-Ups and mapping documents to design and execute Unit, Functional, System Integration, Regression, UAT,Re-test, Security, Performance and Ad-hoc Test Scenarios, Test Cases in word document and Test Data for testing different functionality of Business Objects and Tableau Reports.

Developed detailed test plan documentation providing test approach, function/features to be tested and a comprehensive test summary report with results.

Created test data requirements for the assigned reports

Developed and deliver Data gaps QA services for data integration (ex. DW) and business intelligence customer teams

Delivered high volume of 5000 plus complex detail test cases covering multiple reports (Affordable Care Act Information Returns(AIR), Information Returns Database(IRDB), Business Operational Reports(BOR), Integrated Business Reports(IBR), Integrated Business Analytics(IBA), Exchange Periodic Data(EPD), Tableau, and Ad-hoc Universes) and platforms (Business Objects, Tableau, Big Data Analytics (Green Plum database), and SQL Developer database).

Performed functionality testing which involved the testing of all core functions of the (Affordable Care Act Information Returns(AIR), Information Returns Database(IRDB), Business Operational Reports(BOR), Integrated Business Reports(IBR), Integrated Business Analytics(IBA), Exchange Periodic Data(EPD), Tableau reports, and Ad-hoc Universes using Business Objects and Tableau tools.

Developed and executes Structured Query Language(SQL) queries in Structured Query Language (SQL) Developer Tool as well as in Datamart GreenPlum (Big Data Analytics Test) to perform Back End Testing.

Planned, documented and tested extensive data integration process (PL/SQL) in support of financial security reference data.

Worked with systems engineering team to deploy and test new Hadoop environments.

Transferred data to the relational databases for visualization and generate reports by the BI team.

Performed and lead the testing effort on multi data base testing like SQL server, GreenPlum and hadoop.

Data from various source like SQL Server, GreenPlum, Hadoop should be validated to make sure that correct data is pulled into system

Compared source data(Oracle) with the data pushed into the Hadoop system to make sure they match

Validated the right data is extracted and loaded into the correct HDFS location

Data aggregation or segregation rules are implemented on the data

Key value pairs are generated

To check the transformation rules are correctly applied

To check the data integrity and successful data load into the target system(Hadoop)

Conducted extensive data integration testing.

Captured report generation time(duration), volume and pass or fail status.

Performed Regression Testing by generating QTP scripts based on the business process.

Conducted Functionality testing during various phases of the application using QTP

Developed automated scripts using QTP to perform functional and regression testing

Worked directly with Business Analysts in order to prepare Key Word driven framework for automation scripts.

Validated generated report data with the database results.

Created documentation and test results then uploaded to SharePoint once reviews and peer reviews done.

Executed test cases through ALM/Quality Center and reported defects in ALM/Quality Center.

Interacted with the developers to report and using ALM/Quality Center.

Continuous delivery Continuous integration Testing using Big Data Analytics(BDA)

API’s SOA Interfaces testing done using SoapUI 5.2.1/Postman

Developed Web Services scripts for a Web Service call sing SOAP UI

Worked with the development team and deployment team to troubleshoot and determine root cause for testing issues then retested again once the issue is fixed by the developer.

Performed different types of testing like unit, Functional, Sanity, Positive, Negative, System Integrating, Regression, Ad-hoc, Performance, UAT, Security and Retests.

Resolved issues, prioritize test cases, escalate defects by working closely with business analysts, output developers, database developers and release manager.

Responsible for review of test artifacts and provide suggestions to the test team.

Conducted peer reviews internally and with externally.

Resolved issues, prioritize test cases, escalate defects by working closely with business analysts, output developers, database developers and release manager.

Created Traceability Matrix manually in Excel spreadsheet.

Conducted weekly status meetings and defect review meetings.

Prepared by-weekly testing status for Internal Revenue Service(IRS) Manager.

Environment: BOE(Business Objects), Tableau, Data Mart, Big SQL Server, Data Analytics, Greenplum Data base, Hadoop, PGAdmin, HP ALM, ALM/Quality Center, QTP, JIRA, ETL Informatica, Web Services(SOAP), XML, MS-Excel, MS-Word, MS Access 2K, SOX Compliance, ODS, Toad, SQL Developer, PuTTY, Oracle 10g, JAVA, J2EE, TIBCO, JMS, DB2, JCL, WINDOWS XP Professional, UNIX.

Aug 2012- Oct 2013 Epsilon Irving, TX

Senior Lead Quality Assurance Lead

Responsibilities

Worked as a senior QA Analyst at VISA Account, CITI PER Account, Dunkin Donuts Account and CITI Global rewards Account on multiple projects.

Worked in Agile development methodology and scrum teams.

Analyzed Business and User requirements, Use Cases and User Interface Screens (UIs).

Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.

Developed and executed Functional, System Test Scenarios, Test Procedures, Test Cases, Test Scripts and Test Data for testing different functionality of the applications.

Reviewed test cases internally with QA manager, Business Analyst and Developer.

Reviewed test cases with the Client.

Conducted Smoke, Functional, Integration, System, Re-test, End-to-End, Regression, Security and User-Acceptance (UAT) Testing.

Worked closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.

Documented testing defects, including the follow through on correction and retesting.

Attended project-related meetings and walkthroughs to obtain data to continually add information to the test plan and test cases.

Automated VISA web site application using Selenium.

Conducted weekly status meetings and defect review meetings.

Managed offshore test team

Provided Clients support based on their requests.

Reviewed of test team work and provide suggestions on Test plan, Test cases and Scripts.

Responsible for development of necessary infrastructure for SIT and UAT.

Responsible for interaction with UAT groups and document UAT suggested enhancements.

Responsible for manual and automation testing.

Prepared, managing time estimates and fixed bid deliverables (SOW)

Responsible for file processing.

Responsible for Point of Sale (POS) integration testing.

Validated the Web Services (SOAP), both Request and Response messages and API Testing.

Validated the protocols (TCP/IP, HTTP and HTTPS)

Responsible to liaison with other teams to resolve integration and regression issues

Created new Test Data for Test Conditions and Test Scripts

Used Test Track for defect tracking

Performed Cross Browser Testing using Internet Explorer 8.0/9.0, Firefox14.0/15.0 and Safari.

Developed and executed SQL queries in Toad as well as in Oracle Database to perform Back End Testing.

Developed execution Plans in MS-Excel and updates Test Case status (Pass/Fail) on the Excel Spreadsheet in the Shared Site/G drive.

Maintained Test Logs, Test Summary reports and participates in defect review/Status/GO-NOGO Meetings.

Mapped Defects with Test Case ID.

Performed maintenance testing as well as trained other Testers on testing applications.

Environment: Visual Studio 2010, Selenium, Quality Center, Team Foundation Server, Microsoft Test Manager, Test Track, IssueNet, Web Services, SOW, Cognos, MS-Excel, MS-Word, MS Access 2K, Toad, File Processing, PuTTY, Oracle 10g, JAVA, J2EE, TIBCO, JMS, DB2, JCL, WINDOWS XP Professional,

Aug 2011- Jul 2012 CITI Group Irving, TX

Senior Project Leader

Responsibilities

Worked on Credit Process Initiative(CPI) Project for Citi and is a complex project with many different functional subsystems (LoanPath, Business Banking) and Concierge that will utilize multiple tools and technologies.

Worked in Agile development methodology and scrum teams.

Led onsite and offshore test team

Supported to Maintenance Production Releases and as well as trained other Testers on testing applications.

Supported to User Acceptance Testing.

Developed test plan documentations providing test approach, function/features to be tested and a comprehensive test summary report with results.

Conducted Smoke, Functional, System, Re-tests, Regression, Security and User-Acceptance Testing.

Worked closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.

Developed and executes SQL queries in SQL Developer as well as in Oracle Database to perform Back End Testing.

Documented testing defects, including the follow through on correction and retesting.

Conducted weekly status meetings and defect review meetings.

Responsible for creation and maintenance of Test Labs and setup of Test Labs in Quality Center.

Used Quality Center for requirements management and Clear Quest for defect tracking

Maintained Test Logs, Test Summary reports and participates in defect review/Status/GO-NOGO Meetings.

Environment: Quality Center 10.0, Quick Test Pro 10.0, MS-Excel, MS-Word, Oracle 10g, SQL Developer, JAVA, J2EE, TIBCO, (Cobol, QMF, DB2, SQL, TSO/ISPF, JCL, CICS, TSO, MVS), WINDOWS XP Professional, UNIX.

Jul 2009-Jul 2011 New Jersey Motor Vehicle Commission (NJMVC) Trenton, NJ

Senior Quality Assurance Analyst

Responsibilities

Motor Vehicle Automated Transaction System (MATRX) is a complex project with many different functional subsystems that will utilize multiple tools and technologies.

Worked MATRX Project for NJMVC. Motor Vehicle Automated Transaction System (MATRX) is a complex project with many different functional subsystems that will utilize multiple tools and technologies.

Worked in Agile development methodology and scrum teams.

Analyzed Business and User requirements, Use Cases and User Interface Screens (UIs).

Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.

Good knowledge on HP service manager.

Developed and executes Functional, End-to-End, System Test Scenarios, Test Cases, Test Scripts and Test Data for testing different functionality of the applications and Q&R in the MATRX.

Conducted Smoke, Functional, Integration, System, back-end, Re-test, Performance, End-to-End, Regression, Security and User-Acceptance (UAT) Testing.

Documented testing defects, including the follow through on correction and retesting.

Attended project-related meetings and walkthroughs to obtain data to continually add information to the test plan and cases.

Worked closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.

Performed Cross Browser Testing using Google Chrome, Internet Explorer 6.0/7.0/8.0

Developed and executes SQL queries in SQL Developer as well as in Oracle Database to perform Back End Testing.

Created new Test Data for Test Conditions and Test Scripts

Requested for ETL Batch jobs (Informatica) to test the BO Reports.

Runs the Q&R ETL’s and verifies if ETL extraction process from MATRX has completed successfully

Verified TPI Reports with New and Existing data and validates Report data/results with query results (SQL)

Tested functionality of TPI Application and verifies Report results on the Applications.

Used RequisitePro for requirements management and Clear Quest for defect tracking.

Wrote Test Cases and Test Scripts using Rational Manual Tester Manager.

Inserted Synchronization points and verification points in JavaScripts whenever necessary.

Runs Test Suites from Test Manager and conducts Test Management using Rational Test Manager.

Performed Regression Testing using the Rational Functional Tester.

Used Rational ClearCase for maintaining different versions (Configuration Management).

Migrated data from the previous version to the next version using Rational Clear Case.

Reported defects using ClearQuest.

Developed execution Plans in MS-Excel and updates Test Case status (Pass/Fail) on the Excel Spreadsheet in the Shared Site/G drive.

Maintained Test Logs, Test Summary reports and participates in defect review/Status/GO-NOGO Meetings.

Daily 15 minutes, participated in Scrum meetings at the end of the day.

Mapped Defects with Test Case ID.

Performed maintenance testing as well as trained other Testers on testing applications.

Environment: Rational Manual Tester 7.0, Rational Test Manager 7.0, Rational ReqPro 7.0, Rational ClearQues7.0, Rational Functional Tester (RFT), Rational Performance Tester (RPT), BO 6.5/XI, MS-Excel, MS-Word, MS Access 2K, Oracle 10g, SQL Developer, JAVA,J2EE, TIBCO, JMS, DB2, JCL, WINDOWS XP Professional, UNIX scripts, UNIX (AIX).

Nov 2007- Jun 2009 Financial Information System Agency (FISA) New York City, NY

Senior System Integration Tester

Responsibilities

Analyzed Business and User requirements (Detail Design Documents & Package Test Scripts (PTS)).

Developed and executed Functional, Integration, System Test Cases, Test Scripts and Test Data for testing different functionality of the applications and Q&R in the VENDEX.

Conducted Functional/Base Case, Integration, System, back-end, Re-test, Performance, End-to-End, Regression, Security and User-Acceptance Testing (UAT) manually.

Documented Testing Defects, including the follow through on correction and retesting.

Attended project-related meetings and walkthroughs to obtain data to continually add information to the Test Plan and Cases.

Worked closely with the Business Analyst to ensure robust requirement documents are created to obtain accurate and precise requirements.

Interacted with Developers and on site Vendor to discuss and to resolve defects and their priorities as well as to develop and test applications.

Developed and executed SQL queries in MS Access as well as in Oracle Database to perform Back End Testing.

Created new Test data for Test Conditions and Test Scripts.

Ran the Q&R ETL’s (Submission Package Batch Jobs, Email letter generation batch jobs, Vendor/Contract batch jobs, Regular ETL’s, SA ETL’s and Publisher( daily, weekly, bi-weekly and Monthly basis ETL’s)

Verified ETL extraction process from VENDEX have completed successfully, ran the reports based on the criteria, verified reports with New and Existing data and validated report data/results with query results (SQL).

Verified Report results on the Applications, reported defects using ClearQuest and developed execution Plans in MS-Excel.

Updated Test Case status (Pass/Fail) on the Excel Spreadsheet in the Shared Site/G drive.

Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.

Mapped RMs with Test Case ID.

Performed Maintenance Testing as well as trained other testers on testing applications.

Environment: ClearQuest, BO 6.5/XI, MS-Excel, MS-Word, MS Access 2K, Oracle 10g, SQL Server Studio Manager/Query Analyzer, JAVA,J2EE, DB2, JCL, WINDOWS XP Professional, UNIX scripts, UNIX (AIX).

Mar 2006- Nov2006 Regence Blue Cross Blue Shield of Oregon (BCBSO) Portland, OR

Quality Assurance Analyst

Responsibilities

Provided 24/7 supports to Technical and Functional Specifications.

Gained extensive experience writing on UTDDs (Unit Test Design Documents) and SDDs (System Design Documents).

Participated in Business Analysis, Requirements Review and Technical specs inspection.

Involved in writing Test Plans and developing Test Cases from Business Requirements in Test Manager.

Conducted White Box / Black Box Testing, System Testing, Functional Testing, Integration Testing, Regression Testing, UAT, Load Testing, Browser Testing and Performance Testing.

Participated in testing various interfaces (Inbound and Outbound) of Facets.

Tested various reports and custom reports from facets.

Validated Provider, Member, Membership, Billing and the claims data through EDI based on ANSI 837 claims implementation guide.

Tested the loading of claims data into Facets. Testing is done both manually and by using ROBOT.

Developed automated Test Scripts using SQABASIC defining scenarios and procedures to test the performance, security, recovery and reliability of the application.

Synchronized SQABASIC Test scripts and inserted Bitmaps for greater accuracy of testing.

Developed Test logs and exceptions, managed requirements using RequisitePro and tested the data loading and data mapping.

Extensively used SQL queries to verify database table in the backend as part of Transaction Testing,

Tested the CICS Screens, the database integrity by writing SQL Queries using QMF and other various menus, options and utilities.

Worked with JCL extensively to schedule and execute the jobs

Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.

Used Clear Quest as error tracking system.

Interacted with developers, Users and various members of my team to discuss and to resolve defects and their priorities.

Environment: Rational Suite 2002/2003 (Robot, ClearQuest, IBM Manual Test Manager, Rational Test Manager), Trizetto Facets 4.32, Sybase, MQ Series, EDI, Toad, Java/J2EE,TIBCO, JMS, Oracle9i, Mainframes (Cobol, QMF, DB2, SQL, TSO/ISPF, JCL, CICS, TSO, MVS), MS Project, Win NT, Unix (Solaris).

Nov 2004- May 2005 VISA Foster City, CA

Quality Assurance Analyst

Responsibilities

Involved in gathering requirements and maintained requirements in Requirement Manager of Test Director.

Developed and executed software System Test Plans and Test Cases. These Scripts were developed after reviewing the business requirements document, and technical specifications document.

Tested Extraction Methods and Source Transformations are properly accessing required Source data.

Tested Computations involving business rules are proper and correct values are inserted into target warehouse tables.

Checked all transformation routines are properly working or not.

Validated Aggregate values in the target with the non-aggregate values in the source tables.

Developed the Test Cases to test functionality, and interface of the application.

Planned and managed tests using Test Director and performed Manual Testing.

Used Test Director to store all testing results and metrics.

Conducted Functional, Integration, System, Regression.

Tested the data loading, data extraction and transformations in Informatica.

Validated the source and target data marts, validated the reports from Business objects and wrote complex Stored Procedures and functions using SQL.

Wrote SQL Queries to retrieve the data from various Tables and to test the database.

Used ClearCase in conducting version control and configuration management.

Generated automated Test Scripts using Quick Test Pro (QTP).

Developed VB Scripts, used various checkpoints and developed reusable functions using QTP.

Performed data driven testing using QTP.

Involved in testing applications developed using J2EE framework.

Used TIBCO connectors as Middle-Tier.

Developed XML test files based on XML schema, generated XML data files using XML Spy, validated the J2EE Web services and tested the Java Components, EJB, Servlets, JSP pages and Applets.

Wrote Functions for testing customer and billing data with database and validating the conditions.

Used QTP for Regression Testing using on each new build of



Contact this candidate