SUMMARY:

• Around 8+ years of professional experience in Software Testing as Software Quality Assurance Engineer on different platforms and environments
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Extensive experience of manual and automated testing of application and use of HP Quality Center, HP Quick Test Pro, Test Director.
• High understanding on the various instruments like Bonds, Swaps, Asserts, commodities, derivatives.
• Responsible for Regression Testing of products using Quick Test Professional (QTP), for every new release to validate that the new enhancements have not caused any issues when compared to existing functionality.
• Involved in developing various test plans and test cases for different versions and applications using Quality Center.
• Involved in executing test plan test strategy and test scripts for Functional, Integration, UAT, Negative and Backend testing.
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Proficient in Oracle 10g/9i/8i/7.3, PL/SQL Development Toad, PL/SQL Developer, SQL Navigator, Perl, UNIX, Korn Shell Scripting.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• Excellent hands-on exposure to SDLC lifecycle methodology involving Waterfall, Spiral, RUP, Agile Scrum & Sprint techniques and thorough understanding of Application Life Cycle Management(ALM)
• Working Experience on Testing Data Warehousing (DWH) concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Extensive experience of manual and automated testing of application and use of HP Quality Center, HP Quick Test Pro, Test Director.QTP
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Automated and scheduled the Ab Initio and Informatica jobs using UNIX Shell Scripting.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Extensive experience in working with databases including Oracle MS SQL Server.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP, NT, Linux, UNIX.

Languages Known: PL/SQL, SQL

Databases: Oracle, Teradata, MS SQL Server, MS Access, SQL Server, IBM DB2.

Testing Tools: Quality Center 9.2/10, HP ALM, Test Director.

Reporting Tools: Cognos 8.4/10.2, Crystal Reports, Business Objects

Web Servers: Web Server, Netscape Enterprise Server, Web Logic

ETL Tools: Informatica.

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. QA Tester

Responsibilities:

• Performed End-to-End testing of full functionality
• Wrote test plans and procedures for DRI Data Migration tool.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Executing the Test cases in various Environments (DEV, TEST and PROD).Defect logging and Analysis
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Experienced in using Mercury Quality Center as a defect tracking tool.
• Extensively used Oracle and SQL to perform backend database testing for data integrity.
• Perform final release testing and Release sign-off.
• Used IBM Rational Quality Manager in managing and tracking of test schedule, test case execution and overall defect management
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management
• Involved in Component Testing, Functional Testing, Integration Testing and Regression Testing.
• Involved in performing Regression testing manually for every new Releases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Extensively used TOAD and SQL developer for Database Testing and written several PL/SQL
• Manage requirements with Traceability matrices in MS Excel and HP ALM.
• Preparation of System Test Results after Test case execution.
• Performed Backend testing to validate the data using Toad, added SQL queries to the required Test cases.
• Tested new Data Migration tool used in the mapping of data to new system.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Worked in keyword view as well as expert view of Quick Test Pro
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
• High Level Test Case Design and writing detailed test cases
• Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
• Extensively used Oracle and SQL to perform backend database testing in data integrity test.
• Data Migration of raw data to excel documents for clients
• Used SQL tools likeTOADto run SQL queries and validate the data in warehouse.
• Tested various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Did various data load simulations to stress test the mappings
• Validated the Data in the Warehouse using SQL queries
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Production test data created early, for the production test case execution.
• Tested the shell scripts to backup the log files and job scheduling in SIT, QA, UAT and Production.
• Co-ordinate with the off-shore teams and mentored junior QA’s.
• Tested the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.
• Used SQL for Querying the DB2 database in UNIX environment
• Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
• Involved in trouble shooting of various reporting errors for testing needs.
• Tested Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports.

Environment: Oracle 10g, Erwin 4.0, pm cmd scripting, Informatica 9, Shell Scripting, TOAD, PL/SQL, UNIX, PERL, HP QTP 9.2,ALM/HP Quality Center 11.0, Business Objects XIR2, VSAM Files, COBOL Copy Books, XML Files, Flat Files, Web Services.

Confidential, NYC, NY

QA Tester

Responsibilities:

• Analyzed requirement updates and mapped them with the respective manual Test Cases using HP Quality Center.
• Involved in writing and maintaining Test scripts using HP Quick Test Professional to perform Automation testing during the regression and integration testing phase.
• Involved in Database testing by writing and executing SQL and PLSQL queries using TOAD to validate
• Wrote numerous Pre and Post session SQL and Unix Scripts.
• Used Quality Center 8.2 for writing Test Plan, Test Cases development, test script writing, Test case execution and Defect Tracking
• Preparation of test cases for Functional, Regression, Integration and System testing.
• Good expertise in using TOAD, SQL Plus and SQL Advantage.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Lead the team in offshore to do spec reviews, test case writing, running tests, logging bugs, and communicating issues. Got hands on when / where needed
• Extensively worked on QTP scripts in analyzing the business processes and created UI Automation scripts.
• Automation Test tools development, Test framework development
• Tune SQL queries and database performance for OLTP and DSS applications within the development environment..
• Created the Automation Test Plan and extensively used QTP for creating scripts for functional and regression testing of various features of the application.
• Involved in preparation of System Test Results after Test case execution.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Provided system analysis, design, development and deployment of Business Intelligence Applications.
• Identify the primary key (logical / physical ) and put update or insert logic
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Deleting the target data before processing based on logical or physical primary key.
• Assisted in the integration efforts for merging Business Intelligence platforms with enterprise Systems and Applications.
• Design and execute the test cases on the application as per company standards
• High Level Test Case Design and writing detailed test cases and exporting test cases to Test Director
• Preparation of Data Requirements and Data Mapping (one-to-one mappings)
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• Written several complex SQL queries for data verification and data quality checks.
• Worked with an offshore team also to improve process in the QA environment
• Created test scripts using Automation tool QTP and checked the functionality of the application for every release.
• Identified the bugs and interacted with the team lead and developers to resolve them.
• Extensively used Rational Clear Quest to track defects and managed them.
• Tested the Oracle Applications and Portals like Executive Dashboard, CIE Portal built on Oracle. Used TOAD Software for Querying ORACLE.
• Used Onyx to write back test case execution results and queries tab related data to VSTF.
• Written various Unix Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
• Extensively used test management tools like Quality Center, and QTP to carry out test case documentation, execution, and defect logging
• Used HP Quality Center for the reporting and tracking of defects.
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center.
• Conduct backend testing by querying databases to synchronize testing databases and check for data integrity and proper routing based on specifications.
• Written several complex SQL queries for data verification and data quality checks.

Environment: Agile/Scrum Methodology,, Window, Informatica, Oracle, Teradata, HP Quality Center10.0, Windows, SQL, SQL server, TOAD, Unix/Linux.

Confidential, New York, NY

QA Tester

Responsibilities:

• Define and implement test suites for various aspects of software testing (e.g. things like functional, System, UAT, Regression etc
• Involved in the Defect tracking Management, and Validated Hospital and Medical claims processing.
• Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
• Collected requirements and tested several business reports.
• Tested the conversion of 835 EDI transactions from along with ICD 9 to ICD 10 codes.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend testing
• Analyzed the change detection process on Facets database tables to capture the daily changes done by Users through Online Facets Application.
• Validated the reports and files according to HIPAA enforced standards
• Performed Defect Tracking and Change Control Procedures using Rational ClearQuest, and Configuration Management and Version Control using Rational Clear Case.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Using Rational Clear Quest creating the defects which are related to Service plans and Service plan Ids and managing the same.

Environment: EDI, Hipaa, ICD, Quality Center, Windows, SQL server, Informatica, Oracle PL/SQL, SQL XML, Unix/Linux.

Confidential, Blue Bell, PA

QA Tester

Responsibilities:

• Involved in meetings with Business Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
• Excellent Understanding of Data warehousing concepts - Data marts, Star, Snowflake, Fact, fact less, Dimensions, Measures, cubes Etc
• Created Document for Commercial Package Policy Components (CPP) and Business Owners Policy (BOP) for Small and Medium Sized Businesses
• Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community which includes underwriting, claims, finance, accounting, reinsurance and actuarial departments.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Perform navigation, exploratory and data testing of different transactions through CICS screens.
• Validate Claims Transactions like opening reserves, issuing payments, performing salvage/subrogation on CICS screens of mainframe application.
• Testing and Reporting the Bugs in product releases and performed the Root Cause Analysis for the Defects raised.
• Extensively used Rational Clear Quest to track defects and managed them.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Performed negative and positive testing using SQL Queries
• Automated the Back-End testing for reusability by writing Unix Shell Scripts, and Tracked defects using Quality Center.

Environment: Informatica, Erwin, Mercury Quality Center, Windows SQL, SQL, UNIX, Rational Clear Quest.

Confidential

QA Tester

Responsibilities:

• Adopted AGILE (SRUM) methodology for new projects.
• Responsible for the data for different data cycles, executing the test scripts.
• Interfaced with developers to resolve the problems while executing the test scripts.
• Manually performed Ad-Hoc testing, end-to-end testing, System testing, and Regression Testing, Function testing, Performance testing, and User Acceptance testing.(UAT)
• Parameterized the scripts to perform the data driven testing.
• Extensively worked on Virtual User generator and Controller.
• Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using Test Director
• Performed Positive and Negative testing and tested for boundary cases.
• Plan, Design, Analyze, Execute the test cases from Test Director
• Involved also in Configuration Management of the Projects in Test Director
• Manually executed test cases for the functionality testing and security testing using TestDirector.
• Performed Back-End testing of SQL queries to fetch the data from the database for validating the output and also executed the stored procedures.
• Verifying UNIX batch scripts which will provide Verification Reports
• Documented the modification requests and defects using TestDirector.
• Maintained the bug reports for internal evaluation of the product using Test Director
• Did the Black Box and System testing.

Environment: Windows, UNIX, Test Director, Crystal Reports, SQL Server, and HTML.