SUMMARY:

• Experience in software testing process which includes preparing Test Plans, Test Scripts, Test Cases, Test Scenarios Executing Tests based on business requirements and functional requirements and Defect Tracking for both Manual and Automated Testing.
• High Level Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results Involved in validating both functional and automated business processes using HP Quality center.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Experienced in coordinating resources within Onsite - Offshore model
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Migration Test and Study Configuration Test.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Well versed with Manual and Automated Testing methodologies and principles.
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Configured test environment and create strategy for product development and certification. Assure test data, schedule automated/manual tests. Approve results documentation and tracking systems updates.
• Experienced and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products
• Adept at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• 5+ years with SQL/PLSQL and expertise in writing SQL complex Queries for data testing.
• Work extensively with slowly changing Dimensions.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Assisted in System Test and UAT testing scenarios as required
• Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, SQL Navigator, Perl, UNIX, Korn Shell Scripting.
• Experience in Performance Tuning of SQL and Stored Procedures.

TECHNICAL SKILLS:
Operating Systems :  Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)

Databases :  Oracle 8.1/9i/10g,PL/SQL,SQL Server 2000/2005, Siebel, Sybase

Testing Tools : Quick Test Pro 8.2/9.0/9.2/9.5/10.0, Quality Center 8.2/9.0/9.2, Win Runner 8.x

Load Runner 8.0/7.8,ClearQuest,Test Director 7.6 and PVCS:

Reporting Tools :  Cognos, Business Objects 5.0/6.5/XI R3/R2/R1

Query Tools :  PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

Testing Tools : Win Runner, Load Runner, QTP, Test Director, Quality center

Scripting Languages :  XML, HTML, XHTML, Shell Scripting

Languages :  C/C++, SQL, PL/SQL

Application Development:  Visual Basic 6.0, Oracle9i/10g

Packages :  MS-Office, Visual Studio. 2005

Scheduler Tools :  Autosys, Appworx, Tidal
PROFESSIONAL EXPERIENCE:

Confidential, Richmond VAQA Manual Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Managed multiple projects from different Line of Businesses.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Reviewed and approved database modifications
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Performed manual testing and Regression testing to check the BPM flow goes correct for different plans.
• Used Quick Test Professional for automating manual test cases for regression testing.
• Used Check Points, Output Values, Recovery Scenarios, Regular Expressions, Object Repository Administration extensively in QTP.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Coded UNIX awk and sed shell scripts for data migration for the Department of Credit Risk Warehouse and Capital Funding (CAPFUN) Database.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Prepared the guides for UAT.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Worked with business analysts, developers, and content department to resolve issues.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: SQL, PL/SQL, Quick Test Pro 8.0, UNIX, Shell Scripts, Mercury Quality Center, SQL Assitant 6.0, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, Oracle, SQL Plus, Access, XML.

Confidential, Charlotte, NC

QA Manual Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Managed multiple projects and schedule the timelines for testing process for entire data warehousing projects.
• Executed the Test cases for Crystal Reports and Cognos.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Used HP Quality Center to write test cases, analyzed the results, tracked the defects and generated the reports.
• Performed Automation testing on Claims Processing using QTP and Mercury Quality Center.
• Interaction with developers, users and management to speed up the defect resolution.
• In-depth testing of the application enhanced scripts using Checkpoints and Synchronization points.
• Debugged the application to identify and check that the scripts run smoothly.
• Upload QTP test scripts into Quality Center for automation.
• Defect tracking and reporting using Quality Center
• Generated test data (on UNIX box using Perl scripts) to support development.
• Extensively used Mercury Quality Center (Test Director) and created Test Cases in the Test Plan according to the specifications.
• Verified layout of data files and control file entries as per business requirement.
• Based on the generated test data wrote test cases to demonstrate testing approach with detailed explanation of the cases for SORs.(System Of record)
• Did Unit Testing for all reports and packages.
• Tested the entire data reconciliation process for multiple source and target systems.
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Involved in the application tuning of database by identifying the suitable Indexes.
• Worked on UNIX Shell wrapper scripts
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Quick Test Professional, SQL, PL/SQL, TOAD 7.0, Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director, HP Quality Center, IBM DB2, COBOL, Flat Files, Copy Books, MVS, TSO.

Confidential, Chicago, IL

QA Manual Tester

Responsibilities:

• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Created Used Mercury Quality Center for organizing Requirements, Creating Test Plans, Test Cases
• Performed Manual testing of the application
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases
• Prepared the Customer Templates to Upload the Data to the Application.
• Assist with the user testing of systems (User Acceptance testing) developing and maintaining quality procedures, and ensuring the appropriate document is in place.
• Conducted review sessions on test case and regression test scripts in quality center.
• Designed and executed Functionality and User Acceptance test cases.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production i.e. Jil scripts for the Box and Commands.
• Written UNIX AWK Scripts to manipulate test data and input files.
• Responsible to find out different DDL Issues and Report to DBA’s using Test Director.
• Participated in bug triage meetings with developers to validate the severity of the bug and responsible for tracking of the bug life cycle using TestDirector.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Tracked the bugs and reported them using the Quality center as the defect tracking tool and performed regression testing
• Performed Automation testing on Drug Information using QTP, Load Runner and Mercury Quality Center
• Perform data driven testing and validated the test results.
• Created various User Defined Functions for script enhancements and to verify the business logic.
• Written Complicated SQL queries in DB2 for Update Dimension Tables, Export Data from Target tables etc.
• Written various Unix Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
• Wrote complex SQL scripts in DB2 for testing data quality and validation.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

Environment: Quick Test Professional,, Load Runner, Quality Center, Oracle 9i, Autosys, IBM DB2, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL.

Confidential, Minnesota, MN

QA Manual Tester

Responsibilities:

• Verified layout of data files and control file entries as per business requirement.
• Validated the base table (Star schemas- Fact and Dimension) by writing complicated SQL statements and reports.
• Developed backend programming in Oracle using PL/SQL and SQL.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive ,Negative testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Experience in writing complicated SQL statements.
• Wrote extensive SQL and PL/SQL Scripts for creating stored procedures in Oracle.
• Created new Oracle Stored Procedures and modified the existing ones. Designed, Developed and tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Did functional testing using Quick Test Pro.
• Designed forms and reports using Developer 2000 according to the client requirements. Triggers, procedures and functions are developed in this reports using PL/SQL.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables. .
• Wrote and ran UNIX Scripts for batch jobs.
• Involved in validating the ETL mappings from various systems(CRM,OLTP) to transaction history/reporting database
• Interacted with Solutions analysts, system staff, ETL developers and the data load staff.

Environment: Toad, SQL, Test Director, Shell Scripting, QTP, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts