SUMMARY:

• Over 8+ years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
• Experience in Web based applications like online banking, transactions applications.
• Experience in SQL and PL/SQL scripting
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in Automation using Mercury Interactive Tools such as Win Runner, QTP, Load Runner and Test Director.
• Experience in using Bugzilla, Test Director and HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Sever using SQL, PL/SQL for data integrity.
• Experience in Reports testing in Crystal Reports XI Environment.
• Strong working experience in Windows NT/2000/XP and UNIX environments
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.

Operating Systems Windows 95/98/2000/NT/XP, UNIX, Linux, Sun Solaris
Languages C, C++, Java, SQL, PL/SQL, UNIX Shell Scripting
Testing Tools WinRunner 8.2, QTP9.2, Load Runner
Bug Reporting Mercury Test Director 8.0, Rational Clear Quest, Star, CVS, HP Quality Center11.00, and Bugzilla
Databases Oracle 9i/10g/11g, SQL Server 2005/2008, Sybase ASE
ETL Tools: Informatica Power Center 8/7.1.2/5.1.1/5.0., Ab initio Co operating system (2.14/2.15), SAS 9.3

Database Tools TOAD 4.5, SQL Navigator 4.0

Web Design HTML, XML, Java, J2EE, JSP, ASP JavaScript, AJAX, VBScript
App Servers BEA Web logic, JBOSS, IBM Web sphere, IIS, JWS, PWS
Reporting Tools Crystal Reports 10.0/XI R2

PROFESSIONAL EXPERIENCE:

Confidential Memphis, TN May 2011 to Till Date
ETL tester

• First Tennessee is regional bank, and is a part of the First Horizon National Corporation family of companies does each day, serving families and businesses through about 180 locations statewide. This project is to create new warehouse to maintain customer information. . As a QA Engineer I used to run the test cases for the end to end process in that data warehouse
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experience in SDLC and Agile methodologies such as SCRUM.
• Analyzing requirements and creating and executing test cases
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing.
• Involving in Functional Testing & Regression Testing
• Involving in writing complex SQL queries to verify data from Source to Target
• Performed data validation testing writing SQL queries.
• Written complex queries in SAS tool check the data from Source and Target.
• Used TSYS to update the accounts status.
• Used TSYS mainframes, for posting payment transactions for the card member to get enrolled by posting the monthly fix pay amount.
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Experienced in retest the existing test cases with the different kind of source systems for different periods of data.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

Environment: HP Quality Center, DB2, SAS 9.3, Oracle, SQL, SQL*Plus, UNIX, Quick Test Pro
8.0, TSYS Mainframe, Test Director, Windows NT/2000

Confidential, Richmond, VA Jan `10 to Apr’11
ETL tester

Genworth is one of the world’s largest leading mortgage banks. The primary objective of the project was to construct an aggregated data warehouse. As a QA Engineer I used to run the test cases for the end to end process in that data warehouse. Involved in Functional Testing, User Interface Testing, Multiplatform Testing,

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool.
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Developing 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 using LoadRunner
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Developing Test Matrix to give a better view of testing effort

Environment:- Informatica8.6, Teradata R12, SQL, DB2, Oracle, HP Quality Center, Rational Clear Case, Rational Clear Quest, Remedy, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, HP/Unix.

Confidential, Wilmington, DE Nov`08- Jan`10
ETL tester

JP Morgan Chase is one of the world’s largest leading mortgage banks. The primary objective of the project was to construct an aggregated data warehouse for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Created some macros in Teradata to load the test data in to Target tables.
• Involving in Testing Crystal Reports for the data validation in SimCorp Project
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Teradata R6, Oracle10g, QTP, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting

Confidential San Francisco, CA May `07- Oct `08
QA Consultant

The “Simcorp Risk Rating Application” Web based application has been developed to provide an enterprise based solution for calculating Ops risk ratings for the Processing Risk Indicators (PRI’s) for end user use. This generates Risk ratings based on a given Product, Location and “As At Date”.

Responsibilities:

• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Manually performed Ad-Hoc testing, end-to-end testing, and system testing.
• Performed manual testing by entering positive values, negative values, and boundary values to the application.
• Performed Black box, Integration, Regression, Systems, and Backend testing
• Created, maintained and updated regression suites upon receiving new build.
• Worked on conversion of manual tests into automated test scripts
• Performed automation using QTP created Baseline.
• Performed data validation testing writing SQL queries. Tested ETL batch processes using UNIX shell scripting.
• Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.
• Used Teradata utilities to load the sample test data in to target tables.
• Used to play with the queries in the Teradata sql assistant
• Compared SQL results with application results by writing SQL queries.
• Used SQL queries to test the migrated database for Back End Testing.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.
• Involved in exporting the test cases form Microsoft Excel to Test Director and running the cases remotely in different hosts.
• For tracking the Defects used the tool Test Director. Performed Black Box, Integration, and Regression Testing. Investigated and reported bugs to the developers.

Environment: Teradata R6, Sybase, SQL, PL/SQL, Ab Initio, WinSQL, Quick Test Pro 8.0,Mainframes, Test Director, Unix (Solaris), Unix Shell Scripting, Windows NT/2000

Confidential San Mateo, CA Oct `05- Jan `07
QA Tester

Wage Works is a leading provider of employer-Sponsored services that save employers money and make their employees lives easier. WageWorks provides the tax advantage benefits programs such as FSAs, HSAs and HRAs to help the participants to save money on health care, wellness, dependent care, commuting, and tuition expenses.

Responsibilities:

• Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.
• Gathered and Analyzed Functional and Performance requirements.
• Involved in project planning, coordination and implemented QA methodology.
• Extracted test data by understanding relational database design diagrams Created.
• Designed, Created and Executed manual Test Cases.
• Reviewed Test cases for automation and provided inputs about the scope of Automation.
• Prepared documentation about the automation suite architecture.
• Peer Review of the scripts and made recommendations for updates if any.
• Performed extensive backend testing by writing Complex SQL queries.
• Setup the Performance test environment with the support of technical team.
• Response time, throughput, hits per second, etc were studied by graphs and reported.
• Created manual & automated test cases for testing web services.
• Used TestDirector for storing, maintaining the test repository, bug tracking and reporting
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects
• Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation
• Wrote SQL queries to test the data in database using TOAD and validated the data
• Developed Test Matrix to give a better view of testing effort
• Participated in Test Readiness Review Meetings

Environment: Java, Java Applet, JavaScript, Weblogic Application Server, Oracle9i, SQL, PL/SQL, Test Director 8.0, UNIX (Solaris), Unix Shell Scripting.

Confidential Oct ’03 – Sep’05
QA Tester

Worked as a QA Engineer for testing E-Learning products. Involved in Functional Testing, User Interface Testing, Multiplatform Testing, Browser Compatibility Testing and Internationalization Testing.

Responsibilities:

• Involved in designing the Test Cases using Functional Specifications
• Conducted extensive manual Black Box testing to better understand the functionality of the Application.
• Peer reviewed the Test Cases andmade recommendations.
• Designed, Created and executed manual Test Cases.
• Test Environment Setup and Performed the Functional and Regression Testing
• Detecting bugs, classifying them based on the severity, and documenting them.
• Open Defect\'s with help of Bugzilla wherever discrepancies found in the code and assigning them to development Team.
• Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.
• Attended periodic meetings, teleconferences and led discussions on problem resolution.
• Coordinated with Developers for Defect analysis and performed Regression Testing.
• Developed Test Matrix to give a better view of testing effort.

Environment: Java, XML, Java Script, HTML, Bugzilla, Oracle, Mainframe, UNIX, Shell scripting.