SUMMARY

• Having 10+ years of experience in QA testing in the domains of Banking, Finance and Health Care.
• Involved in all phases of SDLC waterfall, agile wif timely delivery against aggressive deadlines.
• Experience using query tools for Teradata, Oracle and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica.
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Solid experience of AGILE Methodologies, AGILE and Scrum processes
• Expertise in creating/developing TEST CASES and developing TEST SCRIPTS.
• Experience in testing Data Marts, Data Warehouse/ETL Applications developed in Informatica, Cognos using Oracle, Sybase, Teradata, SQL Server and UNIX.
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers
• Expertise in developing test cases/ test scripts for Inbound and Outbound ETL processes.
• Experience in testing/validating the Source, Stage and Target (End-to-End), BI Testing, and Data Quality Issues & Data Reconciliation process.
• Performed Functional, and Regression testing.
• Expert in analyzing the error caused to failure of the ETL load wif reference to the log file and report them to the corresponding team to get it rectified.
• Experience wif bug tracking tools like ALM Quality Center11.0.0 and Clear Quest.
• Train the administration team on new OBIEE, BI and ETL tools
• Experience in UNIX commands and shell scripting.
• Good understanding of data modeling wif (Star Schema and Snowflake Schema)
• Good experience as SOAP Web Services Tester
• Good knowledge on HADOOP, Hive, Hbase, Map Reduce, Java
• Hands on experience using automation tools like Selenium-Web driver.

TECHNICAL SKILLS

Testing and defect management Tools: QuickTestPro 10.0.0/9.5/9.2/8.0, SOAP UI 5.0, Quality Center 11/10/9.2, Jira and Rational Clear Quest, PVCS Tracker

ETL Tools: Informatica 8.x/9.x, Datastage 8

BI /Reporting Tools: BO XIR2, Cognos 8x/10x

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

Databases: Teradata V2R6, Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008

Web Development/Tools: XML, VBScript, Java Script.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte,NC

ETL Test Analyst

Responsibilities:

• Develop and review test plans and test scripts.
• Define ETL testing process and validate business rules and policies to data and transformations including all data pipelines on Hadoop Clusters, monitoring data activities in HDFS, Hive, etc.
• Develop, maintain and validate data quality standards and metrics.
• Strong knowledge of project management tools such as Quality Center, JIRA, Rally
• Performed data quality analysis using advanced SQL skills.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Tested enterprise dashboards and reports using OBIEE Plus tools
• Identify critical issues and processing faults to optimize BI dashboards and reports
• Extensive SQL querying on Staging,Datawarehouse and DataMarts.
• Performed SIT Testing
• Created and executed regression automation scripts using Selenium-web driver for each release.
• QC can used TEMPeffectively in executing test sets, collecting results and analyzing data.
• QC can be linked to an email system which provides an easy way to share defect tracking information.

Confidential, Jersey City,NJ

ETL QA Analyst

Responsibilities:

• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed data quality analysis using advanced SQL skills.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensive SQL querying on Staging,Datawarehouse andDataMarts.
• Performed SIT and Regression Testing.
• QC can used TEMPeffectively in executing test sets, collecting results and analyzing data.
• QC can be linked to an email system which provides an easy way to share defect tracking information.
• Created reports and graphs which helps in analyzing test data Uisng Quality Center
• Contribute in the development of knowledge transfer documentation.

Environment: Datastage7.0,Informatica 9.x,Oracle 9i, DB2, Sybase, Rapid SQL,GreenPlum,Business Objects, MS Office Suite,HP-QC

Confidential, Michigan,Detroit

ETL QA Analyst

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting wif the data analysts and the end users for informational requirements
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked wif Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data wif backend.
• Worked wif ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked wif data profiling, data scrubbing and data cleansing.

Environment: Oracle11g, Informatica Power Center 9x, Quality Center 11.0.0, XML, SQL, PL/SQL, Microsoft word, Excel,. Net, QTP 9.0, UNIX

Confidential

ETL QA Analyst

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Tested ETL jobs developed in Data Stage environment and Worked wif Data Stage Director for monitoring the job status.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Tested SCD Type II and history tables.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved wif Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source
• Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports
• Involved in building the Cubes and optimizing the cube creation.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyze and compare results using Quality Center.
• Participating in the review meetings to resolve the issues.
• Defined the Scope for System and Integration Testing
• Prepares and submit the summarized audit reports and taking corrective actions
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Preparation of various test documents for ETL process in Quality Center.

Environment: Cognos ReportNet1.1 MR2 (Framework Manager, Query Studio, Report Studio), Quality Center 11.0.0, XML, SQL, PL/SQL., Microsoft word, Excel,. Net, UNIX

Confidential

QA Specialist

Responsibilities:

• Created Test Plan based on Business Requirements documents.
• Test Approach and Test readiness document Preparation
• Test case preparation and uploading test scripts in to QC
• Updating planned execution date and resource details in QC as per the test plan
• Test Environment set up follows up
• Test Data Preparation
• Test case execution and test results reporting
• Created automation scripts using QTP and executed the regression pack before every release
• Performed manual and automated test procedures for functional testing of Web services using SoapUI 2.5
• Defect tracking, defect follow up wif IT team
• Daily status call setup, driving daily status calls and addressing the issues
• Publishing daily status report at the EOD and make sure dat status report should be in sink wif QC status
• Collected metrics and prepared Defect analysis reports
• Getting sign-off mail from product owner after completion of UAT
• Written SQL queries to validate the data
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participated in weekly meeting wif the management team and walkthroughs.

Environment: PEGA 6.4x, XML, XPATH,JQUERY,QTP 11.0.0,QC 11.0.0

Confidential

Senior Test Specialist

Responsibilities:

• Working in an Agile environment wif short sprints (two weeks)
• As a Scrum Master co-ordinate the team’s day-to-day activities
• Involved in PBR meetings to discover the requirements
• Creating Confluence pages on each requirement discussed in PBRs.
• Participated in sprint planning meeting to define acceptance criteria
• Written test plans which enforce the acceptance criteria of features
• Drafted initial set of test cases for each features included in the sprint.
• Update test Cases in the process exploratory testing
• Keeps all test plans and test cases updated to changing requirements
• Prepared user stories and involved in helping the developers identifying unit tests
• Attended daily stand-ups, planning meetings, quick releases etc
• Involved in Pair programming
• Provides visibility into end-to-end product quality
• Participated in sprint reviews and retrospectives
• Collected metrics and prepared Defect analysis reports
• Conducted demos to product owner on features executed in every sprint

Environment: Java, Eclipse, Toad, Putty, JMX, Java, Spring, Hibernate, Oracle, SQL query, Stored procedure, Unix.

Confidential

Test Specialist

Responsibilities:

• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.
• Executed test cases, and test scenarios forUser Acceptance (UAT), Functional and Regressiontest cases.
• Reviewed unit test cases and test results and certified the code for Integration testing
• Created user acceptance testing documents and reviewed them wif the customer.
• Mapped test cases to requirements using Quality Center
• Involved in entering and tracking defects using Rational Clear Quest.
• Involved in communicating wif support, business and development teams to resolve issues during test execution.
• Tested initial and daily loads for various ETL jobs
• Involved in testing the batch programs by using the Autosys tool.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Conducted reviews of test plans, test cases, and prepared test results.
• Tested theETLgraphs and otherETLProcesses (DW Testing).
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• TEMPEffectively communicate testing activities and findings in oral and written formats.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Validations for Business Objects reports both data and non-data sections
• Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
• Created Test input requirements and prepared the test data for back end testing.
• Involved in testing the reports and UI screens containing those reports.
• Provided status reports on test execution, and defects identified during testing.

Environment: Oracle 10g, Toad, DB2, SQL, Informtica power center, PL/SQL, Business Objects XI R2, MS Visio, Rapid SQL, Mainframes, TOAD, Autosys, HP Quality Center, UNIX, Putty

Confidential

ETL Test Engineer

Responsibilities:

• Understanding the specifications for Data Warehouse ETL Processes and interacting wif the data analysts and the end users for informational requirements.
• Involved in preparation of Test Plan and test strategy for DWH testing.
• Prepared Manual Test Suites for various modules data validation.
• Focused on Data Quality issues / problems dat include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Written SQL queries, stored procedures in order to data validation in migration as part of backend testing.
• Tested stored procedures & views in Toad using SQL/PLSQL.
• Worked wif Data Completeness, Data Transformation, Data Quality and Integration Testing for different line of feeds
• Prepared test cases for data validations between Data Mart to data cubes.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked wif developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Worked wif UNIX scripts in executing and validating logs for the issues.
• Involved in KT sessions for new joiners to ramp up them.
• Validated all the jobs and successfully system tested the jobs
• Involving in Functional testing, End to End testing and Regression Testing.
• Preparing and supporting the QA and UAT test environments.

Environment: Informatica power center 8.X, Quality Center, MS Excel2003/7, SQL/PLSQL, UNIX, Windows, Oracle 9i, Teradata, TOAD, Flat files.