SUMMARY

• 7+ years of experience in IT industry in quality assurance & testing in multi - tier client/server web based applications in service sectors with expertise in financial and banking, Mortgage, Mutual funds, Credit cards Industry.
• Expert in writing complex SQL queries for data validation between source and target
• Expert in both ETL and BI testing
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Experienced in querying the databases by developing and running SQL and PL/SQL queries using utilities like Toad and SQL Query Analyzer.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables
• Experience in testing and writing SQL and PL/SQL statements
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.
• Quality Assurance: Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and manual testing based on the User Requirement Document and System Requirement documents
• Experience with Agile Methodology
• Good experience in System, Integration, Performance, Sanity, Security, Load, Database, UAT, Usability and Regression Testing
• Excellent knowledge in using automation tools like QTP, Win Runner and Load Runner
• Professional Experience in Financial, Brokerage, Banking, HealthCare applications and strong understanding of Banking/Financials/Mortgage lending applications
• Tested data feeds from XML to Database.
• Experience of various data warehousing, web-based, client-server and distributed multi-tier applications
• Experience in data validation of various sources like Teradata, DB2, Informix, Oracle, SQL Server and Sybase

TECHNICAL SKILLS

Testing Tools: Quality Center 10.0/9.2, Test Director 8.0/7.6/7.2, Win Runner 7.6/7.0/6.5, Quick Test Pro 10.0/9.00, Load Runner 7.6/7.2, Rational Clear Quest, Rational Robot

Languages: Java, .NET, XML, HTML, SQL, TSL, Java Script, VB Script

Hardware: HP-9000 Series, IBM Compatible PC Pentiums

Operating Systems: Windows NT/2000/XP, UNIX, LINUX

Databases: MS Access, Teradata V2R6, MS SQL Server 7.0/7.5/2005 , Oracle10g/9i/8i, Informix, DB2, Sybase12.0

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Rational Clear Quest, PVCS Tracker, Bugzilla

GUI Tools: Visual Basic 5.0/ 6.0, Crystal Reports 4.6/6.0

App/Web Servers: Apache, Tomcat, Web logic, Web spheres

MS Suite: MS Office 2007 (Word, Excel, Power Point, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Newtown, PA

QA Tester

Responsibilities:

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks
• Participate in data requirements design and prioritize expansion of the MDW across different business areas
• Write custom test management reports using SQL
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables
• Support the MDW in accordance with the prescribed service level agreements.
• Creating external tables based on the copy book to load the source data
• Writing source, target SQL’s based on the mapping documents and validating the data
• Used SQL for Querying the SQL server database for data validation and data conditioning
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in Testing the New 5010 columns .
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Experience in creating UNIX scripts for file transfer and file manipulation
• Worked in an agile technology.
• Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
• Worked with Compatability Testing for Browser, Operating, Mobile & Printing options for Web Apps
• Used Clear Quest to track and report system defects and writing test cases/scripts
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Java, MS SQL Server,, TOAD for Data Analysts, SQL, Teradata V2R6, Quality Center, PL/SQL, Teradata SQL Assistant 7.0, J2EE, Java, XML, XML Spy 2008,, UNIX, Shell Scripting, Agile, Clear Quest, PERL

Confidential, Richmond VA

QA Tester

Responsibilities:

• Developed and executed test plans, test cases based on the requirements and also responsible for creating and updating user-defined functions to meet the current business requirements.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Tested Functionality Testing, Usability testing and Interface testing for mulitiple Web Applications created in Java
• Worked in an Agile technology with Scrum
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Helped the Lead create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all the test conditions and the test data need.
• Designed test data using MS Excel sheet and created data driven tests to test the application with positive and negative inputs.
• Performed System and Regression testing for every modification in the application.
• Categorized defects based on severity and reported them assigning the appropriate priority to developers for resolution.
• Prepared several SQL Updates/Inserts to manipulate the testing data and prepared SQL queries to retrieve data from database.
• Developed automation test scripts by using data driven, parameterization and regular expression in QTP.
• Generated XML data files using XML Spy.
• Wrote the Test cases in Test Plan execute the test cases in test Lab Modules respectively and reported defects using Defects module in Mercury Quality Center and actively participated in defect review meetings.
• Extensively worked on the Console application and to bring the output of the console application to in corporate in to the web application.
• Tested the outgoing links from all the web pages from specific domain.
• Managed and executed the test process, using Agile Methodology
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Reviewed Test Deliverables for the projects.

Environment: s: Mercury QTP, Agile, TOAD, HTML, .NET, ASP.NET, VB.NET, Quality Center, XML, XSLT, Java, Oracle, SQL Server, UNIX, Ms Office Suite.

Confidential, Hoffman Estates, IL

QA Tester

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2008 with high volume data
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running
• Tested on the Data Validation rules of various input data files through the generic conditioning graph ensuring the integrity of data used for processing based on the rules
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Involved in creating both positive and negative test data to cover all business scenarios
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing. Wrote PL/SQL and stored procedures for extracting as well as writing data.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Created Test input requirements and prepared the test data for Data Driven testing
• Performed quality assurance reviews on all System Development Life Cycle
• Participated in defect review meetings with the team members. Used MS-Word for documentation
• Involved in other test planning meetings and submitted test metrics daily to the management

Environment: SQL Assistant 6.0.0, SQL, PL/SQL, Sybase, HTML, Agile, TOAD, QTP, UNIX, T-SQL,DB2, Quick Test Pro, Quality Center, Shell Scripting, PERL

Confidential, Mountain View, CA

QA Tester

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing
• Validated all kinds of transformations used in every work flow used to transform data
• Validating the data flow from source to target
• Checking the data flow from one end to another by using SQL queries
• Worked with technical staff to create, interpret and implement business requirements into technical specifications
• Experience in creating UNIX scripts for file transfer and file manipulation
• Developed automated test scripts using QTP to perform Functional and Regression testing
• Created Test input requirements and prepared the test data for Data Driven testing
• Used Test Director 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
• Performed quality assurance reviews on all System Development Life Cycle
• Used Quality Center for defect tracking.
• Participated in defect review meetings with the team members. Used MS-Word for documentation
• Involved in other test planning meetings and submitted test metrics daily to the management

Environment: Informatica 6.5.1, Shell Scripting, HP Mercury Quality Center, Java, SQL, PL/SQL, T-SQL, Oracle 8i+9i, HTML, TOAD, XML, UNIX, Test Director, QTP