SUMMARY:

• 7 + years of professional experience in Software Industry, Expertise in all kinds of testing (Manual and Automation) with focus on Business Intelligence, ETL, Data warehouse, DataMart, Databases, Web services, Client - Server applications.
• Extensive experience in the Information Technology industry, involving analysis, Client Server, Web based, ETL and BI testing of DWH applications and reporting applications.
• Very good working experience in the Banking, Financial and Healthcare domains.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios.
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
• Worked heavily on testing various Data warehouse ETL process with tools includes Informatica, DataStage, Ab Initio, SSIS as well as many reports developed used various BI tools includes Business Objects, Cognos, Microstrategy, OBIEE, SSRS and Crystal Reports .
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Well experienced in writing complex SQL queries for extracting data from multiple sources.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using Oracle, SQL Server and DB2.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Extensive experience in Manual and Automated testing using Mercury Tools Quick Test Pro (QTP), Test Director, Quality Center, ALM, TSS and Test Complete tools for Test Designing, Requirement Mapping, Reports and Defect Tracking.
• Extensive experience working with ETL tools like Datastage, Informatica, Abinitio, SSIS and Autosys tools. In depth knowledge of Agile and Waterfall development methodologies.
• Experience in using Automated Tools like Win Runner, Quick Test Professional, Jira and Load Runner.
• Experience in UNIX and LINUX, File parsing, file processing, comparing data sets from source to target environments and executing Shell Scripts.
• Proficient at performing data analysis and identifying patterns and root causes for data discrepancies.
• Extensive experience in writing complex SQL, PL/SQL queries using joins, aggregation and various other transformations.
• Good experience in SSRS, Cognos & Business Objects Reports testing.
• Proficient in Rational Clear Quest, Quality Center/ALM for Defect Tracking .
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and working with slowly changing dimensions Type I II and III.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels .

TECHNICAL SKILLS:

Test Analysis: Functional Requirement Gathering & Analysis, Analyzing Business Rules,Test Flows, Test Planning, Causal Analysis of Defects,System Change Request, Impact Analysis

Test Management: MS Project Test Scheduling, Test Director, HP Quality Center, ALM, TSSTraceability Matrix for Requirements and Defects

Testing Methodologies: Object Oriented, Keyword Driven and Data Driven testing, Top to Bottom and Bottom to Top test methodology, Requirement based, Risk based, Priority based test methodology

Mercury Interactive: Unified Functional Testing11.0/11.5, Quick TestPro9.5/9.2/8.0, Business Process Testing,, TestDirector9.0/8.0/7.5, HP Quality Center

ETL Tools: Informatica 7.1/8.x, SSIS 2008

IBM Rational Suite: Rational Functional Tester 8.0/7.0Bug Reporting: Rational Clear Quest, Test Director,JIRA

Version Control: Rational Clear Case 7.1/7.0.1/7.0.0Scripting languages: VB Script, HTML, Shell Scripting

Operating Systems: Windows XP/NT/2000/Vista/7, DOS, UNIX

Databases: Oracle 10g/9i, MS SQL Server 6.5/7.0/7.5/2005, IBM DB2, TeradataV2R6, MS Access

MS Suite: MS Office 2007 (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Basking Ridge, NJ

Sr.QA Analyst

Roles and Responsibilities:

• Reviewed Requirements, Specification and Design Documents. Developing detailed test plan, test cases and test scripts using Quality Center.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning. Used Data Driven Testing methodology to test the application with multiple sets of data.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Participated in reporting summary documents reviews. Developed Test Cases and Test Scripts for System and UAT Testing.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables. Worked with Teradata SQL Assistant for data retrieval and data validation.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)Written several complex SQL queries for validating Cognos Reports.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Coordinate very closely with the developers regarding functionalities and defects.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Involved in testing the Cognos reports by writing complex SQL queries
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.
• Extensively used ETL Informatica methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Reported and tracked defects/bugs to the development team using HP Quality Center
• Designed Relational Traceability Matrix to match the test scripts with the Functional design document.
• Provided the Test status to the Tech lead, Project lead and the team mates.
• Effectively communicated testing activities and findings in oral and written formats.

Environment: ETL Informatica, BI Cognos 8.0 Series, HP Quality Center, SQL, PL/SQL, UNIX, TOAD, Oracle 11g, CSV, SQL Server 2008, QTP and UAT

QA Tester

Roles and Responsibilities:

• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• 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.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL Informatica group for understating mappings for dimensions and facts.
• Responsible for logging defects in Defect Manager, monitoring their status and tracking them to closure using Quality Center.
• Involved in gathering and analyzing the user requirements in coordination with Business.
• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Worked with XML transactions for multiple feeds.
• Performed quality assurance reviews on all System Development Life Cycle.
• Assisted in promotion of ETL Informatica Power center code and UNIX from UAT to Production.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Involved in Test Execution and Defect Reporting using Quality Center
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.

Environment: DWH ETL Informatica Power Center 8.6, BI Business Objects, Quality Center, SQL, PL/SQL, Oracle 10g, Shell Scripting, UAT, UNIX and Teradata V2R6.

QA Tester

Roles and Responsibilities:

• Used Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.
• Extensively used Clear Quest for tracking and reporting bugs.
• Categorized bugs based on the severity and interfaced with developers to resolve them. Maintained Test Logs, Test Summary reports and participated in defect review meetings.
• Written Test Cases for ETL to compare Source and Target database systems. Testing of records with logical delete using flags
• Made Change Requests for failed test cases and assigned them to responsible developers.
• Developed complex SQL scripts/queries for data verification to compare the expected results with database and analyzed the data and the calculations in the mapping for its correctness.
• Executed campaign based on customer requirements and followed company code standardization rule.
• Written Test Cases for ETL Datastage to compare Source and Target database systems. Testing of records with logical delete using flags
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing. Developed several data issues for Compliance Data.
• Tested a number of complex ETL Datastage jobs and reusable transformations for daily data loads.
• Tested several different types of reports including Report Layout, Naming Conventions, Totals, Sub-Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Business Objects.
• Performed extensive data validations against Data Warehouse. Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Prepared UNIX scripts to run the Datastage ETL jobs from command line.

Environment: ETL Datstage, BI Business Objects, HP Quality Center, SQL, Excel Pivot, Oracle 10g/9i, Files, UAT, WinSQL and UNIX

QA Engineer

Roles and Responsibilities:

• Responsible for Requirements Collection, analysis, design and documentation.
• Developed Activity Diagrams, Use Cases, Data flow diagrams using Visio professional.
• Responsible for completing SDD (Software Design Documents) for the presentation and business layers.
• Responsible for black box testing of the code developed by other team members.
• Identifying the data model entities and created the database schema in MS SQL Server 2000 to use in development, testing and production environment.
• Tested a number of complex ETL Datstage jobs and reusable transformations for daily data loads.
• Coding in SQL for client-side data validation.
• All the bugs detected were reported using Test Director. Interacted with the development team to report bugs. Maintain relationships with IT managers, Development, production support and business sponsors.
• Extensively used tools like QualityCenter for defect tracking and change management.
• Involved in regression testing after each build release of the application.
• Involved in analyzing the reports and documentation of test results.
• Support test efforts by ensuring that effective communications are in place with IT Project Management, Application developers, Test Teams and Business Product teams when required.

Environment: ETL Datastage 6.x, HP Quality Center, SQL, PL/SQL, Oracle 8.0, UNIX, UAT, Windows 2000/XP, C# .NET, Test Director 8.0.