SUMMARY

• Over 7 years of experience in the Software Testing of Web - based, Data warehousing/ETL, and Client/Server applications.
• Actively participated in all the stages of Software Development Life Cycle (SDLC), QA Life Cycle and Testing Life cycle.
• Excellent analytical skills for understanding the business requirements, business rules/processes, and detailed design of the application.
• Expert in writing Test Plans, defining Test Cases, developing and maintaining Test Scripts, Test Case Execution, Analyzing Bugs and interacting with team members in fixing the errors as per specifications and requirements.
• Experienced with Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting System.
• (ReCAP) that allows users to enter, track, review, amend and clone research concepts
• Technical expertise in BI, DW, Data profiling, Data Cleansing, Data Integrity, reference Data, Data Security and Data Quality Management.
• Developed and customized test scripts in UFT and played back the scripts after fixing The bugs
• Proficient in validating Source to Target mapping documents including the transformation rules.
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life Cycle Management
• Experience in testing Cognos Reports, Business Objects Reports, SSRS Reports and Micro Strategy Reports.
• Experience in validating the ETL applications built using Informatica, Ab Initio, SSIS, Data Stage.
• Extensive experience in quality assurance using Manual Testing, Automated testing tools like Quick Test Pro, Quality Center & Load Runner.
• Experience in complete Software Testing life cycle: Unit Testing, Functional Testing, Regression, Integration, System Testing, Performance testing and Data driven testing.
• Expertise in Defect Reporting and Tracking using Test Director/ HP Quality Center.
• Extensive experience in testing applications for Telecom, Confidential Domains.
• Extensive experience in testing applications on UNIX environment.
• Excellent in meeting deadlines, time management and presentation skills.
• Excellent team player with problem-solving and trouble-shooting experience

TECHNICAL SKILLS

Testing Tools: Quality Center 11.0, Test Director

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Perl, Linux.

Languages: SQL, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , Teradata, Sybase, DB2

ETL Tools: Informatica Power Center 8.x/9, Ab Initio, SSIS and Data stage

BI Tools: Business Objects XIR2/XIR3, Cognos, Micro strategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr QA Tester

Responsibilities:

• As a Team Lead, I have been mainly involved in the following activities.
• Worked with the business team in analyzing and understanding the business requirement of the application
• Scripted test cases in test plan and mapped them with the requirements and generated requirement traceability matrix
• Wrote tractability matrices based on use cases and business requirements documents (BRDs) using HP Quality Center/ALM as QA Status Report, QA Summary Reports, QA Test Logs.
• Worked with physical and logical data model in understanding the database structure
• Proficient in using DOORS for business requirements
• Reviewing and interpreting content of source documents and statistical reports and abstracting appropriate data.
• Created user defined functions and prepared design documents using UFT
• Involved in Implementation and development of Pega Framework
• Wrote complex SQL queries using multiple joins, case statements and subqueries to validate the source data against the database
• Prepared test data by underwriting loans in OUS and MPS according to the business rules which covered all the possible scenarios.
• Prepared the test data manually and by running an automation script.
• Worked on UNIX environment to run the batch jobs to trigger loans for simulating real time scenarios.
• ImplementedPerlengine to dynamically render HMIs based on pre-formatted files.
• Used Oracle Enterprise Manager to extract the XML for the instances generated after a loan was triggered through desired method.
• Validated the MSS generated reports against the application and the database
• Performed smoke testing, adhoc testing, integration testing, end-to-end testing, regression testing, system testing and assisted in UAT.
• Skilled in bug reporting and defect tracking using HP ALM
• Worked with the developers in closing the defects and re-testing them
• Worked with the UAT team to find issues in reports etc.

Environment: HPALM 11.0, UNIX, Perl, Oracle EM 11g (web logic), UFT, VB.Net, Document Management system, Putty, PEGA, Telnet,IE 9, Windows 7, IBM Rational Doors 9.4, Lotus Notes 8.5, XML Notepad++, Rapid SQL,QTP, HPALM 11.52, Webservices SOA applications, Share Point 2007, Rapid SQL for SQL Server 2008 and Sybase

Confidential, Jersey city,NJ

SQL QA Tester

Responsibilities:

• Tested all the ETL processes built for fetching various source data into data warehouse.
• Performed data validations on the loaded data by comparing against source data through complex SQL queries.
• Prepared test data files in UNIX box for testing purpose.
• Tested the all the transformation as per the source to target mapping document.
• Tested the UNIX scripts that were developed for moving the used source files into archive location.
• Involved in Testing Enterprise business rules initiative, including PEGA Systems Architecture, design and Methodology
• Tested base line scripts for testing the future release of the application using UFT
• Tested the reports generated from the data warehouse according to the requirement specifications.
• Used HP ALM/Quality Center for requirements management and Defect Tracking
• Developing test cases/scripts/reports inPerl/shell script/Q script to carry out Functional,Regression, PerformanceTesting
• Setting up Autosys jobs for executing the test scripts/tests
• Compared the data in the reports against the data warehouse using SQL.
• Tested the format of the report and compared against the model provided in the requirements specification.
• Delegated work to offshore team and helped them understand the requirements and changes happening in the code.
• Performed End to end testing, Regression testing and sanity testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Written test strategy and all the important test scenarios to be covered and shared across the QA team.
• Written test cases and maintained them in HP Quality Center.
• Raised defects and tracked them to closure by coordinating with dev team.

Environment: SQL, PL/SQL, UFT, HP Quality Center 9, PEGA, Ab Initio, Unix, Perl, Micro strategy, TOAD for Oracle

Confidential, Reston, VA

Sr. QA SQL Test Analyst

Responsibilities:

• Created test cases and test plans for testing the ETL process and reports.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Data warehouse using complex SQL queries.
• Tested all the reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them in closing the defects by coordinating with the dev team.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Extensively worked on HP ALM/Quality center to execute a bunch of test scripts
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and co-ordinated with integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Worked with the team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
• Tested the migration of reports from Business objects XIR2 to XIR3.

Environment: SQL, PL/SQL, HP Quality Center 10.0, XML, Informatica 9, Business Objects XIR3, TOAD for Oracle

Confidential, Springfield, NJ

QA Test Analyst

Responsibilities:

• Involved in analyzing requirement, design and mapping documents.
• Created SQL, PL/SQL scripts using TOAD for Oracle 9.1 for source and target databases.
• Involved reviewing test scripts and providing feedback.
• Involved in clarifying the questions on transformations for offshore and onsite team.
• Prepared Data Migration test and System test plan by conducting requirements analysis.
• Analyzed Data Migration requirements based on UI mapping document and source to target documents.
• Communicated with Development team on business logic and migration logic queries.
• Worked with team members in understanding the business logic and writing queries.
• Analyzed test results (Query results) and communicated critical defects with development team.
• Performed Data Validation for the data flow from front end to back end.
• Performed Japanese Data Validation from PERCEIVE database to MARRS ARGUS database.
• Involved in Data Analysis in the ETL process and Contribute to the analysis of data requirements and data migration.
• Performed Web Service Testing using SoapUI.
• Developed test scripts for Functional, Regression and data driven tests.
• Performed regression testing by repeated execution of test cases in each build and verified the fixation of bugs and reported any new bugs that arose using the defect-tracking tool, Mercury Quality Center.
• Prepared the test automation documentation for the future reference.
• Created requirements and test cases for each project in Requirements and Test Plan modules respectively using Mercury Quality Center.
• Executed test cases in Test Lab Module using Mercury Quality Center.
• Logged defects and tracked defects till the closure in Defects module.
• Produced reports (Test execution report and Bug status report) using Analysis Graphs on weekly basis.
• Prepared reports like test activities, test execution graphs and bugs list from QC for weekly status meetings.

Environment: Quality Center 10.0, Agile, Java, .NET, XML, HTML, Windows and Unix, Shell Scripting, SQL, PL/SQL, TOAD for Oracle 9.1, Oracle 10g, MS Office, COGNOS.