PROFESSIONAL EXPERIENCE:

• Over 4+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client Server, Data Warehousing solutions.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Experience in designing, developing, enhancing automated test scripts for QTP using VBScript .
• 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 for Performance, Functional, Load, Database, and Smoke testing, UAT .
• Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL Testing.
• 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.
• Performed back end testing by writing SQL queries and verifying the data in the table.  .
• Expert in using the Bug tracking with   Test Management Tools  like Quality Center .
• Experience in using test management tools like QC (Quality Center) and Test Director. Have hands - on on experience in other bug tracking tools like Bugzilla, TFS, On time and JIRA. 
• Experience in Quality Center /   HP ALM  Administration including hands on server deployment, Major version upgrades, Patch installations, Utilities using Site Admin API and Quality Center API .
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.
• Worked on testing of   SAS products like rewards and marketing reports. 
• Experience with Black box   testing, white box   testing, Unit, Integration, Regression, Sanity, System test, Functional   testing,   GUI applications testing  and Database   Testing.
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Possess In-depth knowledge of software QA methodologies and Strategies like Waterfall and Agile Scrum .
• 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.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports.
• Extensively worked with flat files and excel sheet data sources.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C and C++ Concepts, Test Script Language (TSL), CSS, HTML, VBScript, JavaScript, Python, Shell Scripting

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Defect Tracking Tools: Quality Center, TFS, JIRA, Bugzilla

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008, MS Access 2008, SAS, Teradata V2R6, DB2 UDB 8.2/8.1, Informix

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX/LINUX

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, HP ALM, Jmeter, Performance Center, VU Scripting, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe

Web Browsers: Safari, Mozilla Firefox, Google Chrome, Internet Explorer

PROFESSIONAL EXPERIENCE

Confidential, Estero, Florida

ETL QA Tester

Responsibilities:

• Test cases, Test Data preparation, reviews & execution of Test scripts. Creating Test case & Test scripts by  Agile Methodology .
• Provided subset of Functional test cases for UAT testing .
• Identified the test cases that needs to be automated using QTP .
• Involved in writing and executing script for regression and functional testing using QTP and HP ALM .
• Performed monitoring of the  ETL jobs (Extraction, Transformation and Loading) by using  Informatica power center . 
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse
• As a ETL Tester responsible for the understanding the business requirements, ETL and subsequently design  ETL testing strategy using SQL scripts .
• Responsible to create, Execute Test Sets in HP ALM Test Lab.
• Logged defects in  HP ALM  and created the sub task for the work.
• HP Reported defects using ALM Verified fixes and closed bugs during regression testing .
• Involved in data integrity, backend, data driven, regression and functional testing.
• Tested the reports developed in  OBIEE  against the database.
• Created Repository and Session Variables as part of developing and used the  OBIEE  reports.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, mapping designer, Mapplets designer and transformation developer.
• Used TOAD Software for querying Oracle. 
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD
• Extensively worked on Web Service testing using SOAPUI .
• Performed manual testing executing all the test cases in ALM before switching to automation testing.
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures.
• Performed Web Services testing and Validated XML request/response data using SOAP UI.
• Identified, created rounds for regression and new functionality test scripts for the IT, IST and UAT test environments and ensure successful test execution. 
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL .
• Document all the findings/results/defects in UAT in HP ALM (Application Lifecycle Management).
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Extraction of test data from tables and loading of data into SQL tables.
• Performed extensive database testing wrote SQL scripts to compare the UI result with that in the database.
•  Executed SQL queries for data validation to verify the data in the database.
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data.

Environment: Informatica PowerCenter 9.5, OBIEE, HP ALM/Quality Center 11.5, Oracle 11g, QTP, Claims, Agile, DB2, SQL, PL/SQL, SQL Server 2008, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, WinSQL.

Confidential, Lake Mary, Florida

QA Tester

Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Preparing Test Objectives Plan Creation. 
• Actively participated in all phases of testing lifecycle (Design, Planning, Development and results).
• Moved test cases to test lab from test plan in Quality Center.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used PL/SQL programs for performance testing.
• Created Requirements and test plan in Quality center . 
• Defects were tracked, reviewed, analyzed and compared using Quality Center
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects
• Performed UAT testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Used UNIX to verify the session log files for error and warning details.
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader.
• .Responsible for testing Business Reports developed by Business Objects XIR2.
• The reports that were created in Business Objects were testing by running the SQL statements.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Compared query result sets from different database systems using UNIX diff command.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Maintained the batch processes using Unix Shell Scripts.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.

Environment: Quality Center, Business Objects, UAT, SQL, PL/SQL, PL/SQL, SOAP UI, UNIX Shell Scripting, Toad, Oracle, XML.

Confidential

QA Test Analyst

Responsibilities:

• Analyzed the use cases given by the business analysts and developed test cases using them.
• Created test cases to test Web Application.
• Gathered specifications and requirements to develop test plans and to create test cases using Quality Center .
• Responsible for complete manual testing of application under test (UAT).
• Identified the test cases that needs to be automated using QTP/UFT .
• Maintained Test Logs and Reports in Quality Center . 
• Written complex SQL queries for data validation and to verify the extract rules.
• Assisted in kicking off ETL jobs using  UNIX  and analyzed the data in dimension and fact tables. 
• Performed black box/functional testing, regression testing on Application Under Test.
• Validated Web Services using SOAP UI.
• Wrote and executed SQL Queries for Data validation. 
• Performed database integrity check using SQL.
• Did extensive backend testing using SQL, UNIX and PL/SQL .
• Involved in writing and executing script for regression and functional testing using QTP/UFT and HP ALM .
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing.
• Executes the test suite to identify regressions and unexpected side effects.
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).
• Generates functional test cases that capture actual code behavior as a deployed application is exercised

Environment: Quality Center, SQL, PL/SQL, Windows NT, Shell Scripting, TOAD, QTP/UFT, MS-Office Tools, XML, XSLT, Web Services, SOAP UI, Manual Testing, Test Director.

Confidential

QA Tester

Responsibilities:

• Develop and document Test plan, Test scenarios and Test cases in accordance with the business requirements document and the functional requirements specification documents. 
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Extensively involved in regression testing activities to ensure accurate software build.
• Prepared the test data for both positive and negative testing to assess the business flow in the application.
• Use Quality Center for tracking and reporting, also follow up with development team to verify defect fixes, and update defect status. 
• Performed User Acceptance Testing on completion of integration testing. 
• Developed UAT test data, test cases for UAT and Business testers, traceability matrix and various test reports during and post UAT signoff.
• Converted manual tests to automated test scripts using Quick Test Professional.
• Identified all windows, Pages, Objects, Methods and Properties to verify the application’s functionality using Quick Test Professional.
• Attended core team meetings with the PM and the functional leads to discuss the scope for new applications to be taken up for testing, planning the overall transition of the application.
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources.
• Maintained and updated the scripts for every release either by updating the object property value for a specific object or by adding new objects to Object Repository.
• Worked with ETL team to facilitate creation of data models based on business rules, and ensured that source-to-target data was accurate.
• Performed the Back-End integration testing to ensure data consistency on front-end by writing and executing SQL Queries on the database. Created and executed SQL statements to extract data from tables and verified output data.

Environment: Java, J2EE, PL/SQL, MYSQL, Oracle, Linux, Windows 2003/2008, Quality Center, QTP