SUMMARY

• 8 years of professional experience in Software Consulting & Testing arena using various methodologies.
• Expertise in Web Services Testing, Performance Testing, ETL Testing, QTP Automation, Functional Testing and UA Testing.
• Extensive experience of manual and automation testing of applications with hands on experience with tools like HP Quality Center, HP Quick Test Pro (QTP), Unified Functional Testing (UFT), Test Director.
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Hands on Experience in Project and Product Testing and Test Data Creation.
• Experienced in complete automation framework for the project using QTP
• Designed QTP Automation Framework and Scripts for strategic implementation of Hybrid Application, Database, Web Services regression testing suit.
• 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 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)
• 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 10G/11, MS SQL Server 2005/2008, 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

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Sr Quality Analyst

Responsibilities:

• Written test scripts using HP ALM
• Manually tested the applications that Confidential use internally
• Participated in Use case review sessions
• Participated in Defect Review meetings
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Created test automation best practices and developed automation scripts using QTP
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Independently designed and developed project document templates based on SDLC methodology
• Tested users and user classes through Access manager
• Tested multi-dimensional cubes using models and implemented incremental updates for power cubes
• Created Test input requirements and prepared the test data for Data Driven testing.
• Analyzed the business processes and helped in making changes based on the test results
• Actively communicated with the Developers and User Reps to discuss the defects

Environment: Serena Business Manager, HP ALM, TFCS (Mainframe application), Quality Center, Windows, QTP 10.0 & UFT, SQL, Test cases.

Confidential, McLean, VA

Sr Quality Analyst

Responsibilities:

• Create and Execute Test Plans and Test Cases for various functionalities of different PeopleSoft Financial and Supply chain Management modules.
• Create test plans for System and Integration testing, Regression Testing, User Acceptance Testing.
• Execute and cooperate with employees for Legacy files End to End testing.
• Developed test cases and executed test cases for creating different Vouchers, Posting of Vouchers, Posting of Payments.
• Developed test cases and executed for creating, editing different online and other Journal Entry in General Ledger module.
• Participated in Use case review meetings with Business Analysts and Developers
• Participated in Defect Review meetings which were conducted on daily basis
• Documented defect reports using Serena Business Manager
• Created automated test scripts using QTP.
• Analyzed the business processes and helped in making changes based on the test results.
• Actively communicated with the Developers and User Reps to discuss the defects
• 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
• Participate in the testing process through test review and analysis, and certification of software designs plans, and coordinate work team

Environment: Serena Business Manager, HP ALM, Quality Center, Windows, QTP, SQL, Test cases, PeopleSoft FSCM 8.9 and 9.1.

Confidential, NYC, NY

QA Analyst

Responsibilities:

• Analyzed system specifications and involved in the development of Business Specification Documents (BSD), Requirement Specification Documents (RSD), and Design Specification Documents (DSD)
• Tested trades which were traded with various instruments like Bonds, Swaps, Commodities, Depravities
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Testing and Defect Management Tools Manual testing, Application Life Cycle Management (ALM)
• Highly proficient in automating tests using QTP and modifying the test script code by parameterization, standard checkpoints, and output - value checkpoints using VBScript.
• Performed testing on a Data ware house (DWH) platform, including data integrity and data validation.
• Write Test cases, Test Scripts, and perform End to End Testing, GUI Testing and Regression Testing on all Business Intelligence applications and processes to be used in the event of equipment or system failure.
• 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.
• Converted manual test cases of Agency automation module to QTP Test scripts using VB scripting
• Wrote complex SQL Testing scripts for Backend Testing of the data warehouse (DWH) application.
• Worked in expert view of Quick Test Pro, Configured Quick Test Pro (QTP) with Quality Centre (QC) and Maintained the project information in Quality Centre.
• Manage requirements with Traceability matrices in MS Excel and HP ALM.
• Did Test coverage by adding new test actions from iteration to iteration according to the test strategy.

Environment: Agile/Scrum Methodology, Rational Tools, QTP, HP Quality Center, Linux/Unix, Oracle

Confidential, New York, NY

QA Analyst

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.
• 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.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• 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
• Written Test Cases for ETL to compare Source and Target database and Tested records with logical delete using flags
• 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, ETL, Informatica, Oracle PL/SQL, SQL XML, Unix/Linux.

Confidential, Blue Bell, PA

QA Analyst

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
• Worked with ETL group for understating mappings for dimensions and facts
• Excellent Understanding of Data warehousing concepts - Data marts, Star, Snowflake, Fact, fact less, Dimensions, Measures, cubes Etc
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• 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

Software 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.