SUMMARY

• 7 years of extensive and diversified experience in Information Technology wif emphasis on Quality Assurance, Data warehousing, ETL Testing and Manual Testing,
• Involved in complete System Analysis, Design, Development, Testing (SDLC), Maintenance, Enhancement and Quality Assurance of software applications.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Strong Experience in various domains like Telecom, Banking, Health Care
• Expert in using Defect Management Tools - HP Quality center, Test Director, Clear Quest
• Worked on Oracle, SQL Server, IBM DB2, Teradata, Sybase and Informix Database Platforms
• In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Worked on various Operating Systems which include Windows, Linux, UNIX (Sun Solaris, IBM AIX, HP Unix)
• Worked wif different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
• Extensive ETL testing experience using Informatica Power Center components (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Well versed wif Software testing concepts, SDLC, Agile and Waterfall methodologies
• Experience in using different Transformations, Sessions, Mappings, Mapplets, Workflows and Worklets in Informatica and testing them for complex business rules
• Expert in writing Test Plan, Test Strategy, Test Metrics, Test Summary Reports, Test Cases and Test Scripts for Manual testing based on the Business Requirement and System Requirement documents
• Implemented various Test cases for the Functional Testing, System Testing, Unit testing, Regression Testing, Smoke Testing, Integration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Involved wif preparation, testing and validation of ETL test data for all the ETL mapping rules.
• Tested several complex reports generated by BI Tools like Qlikview, Cognos including Dashboard reports, Summary Reports, Master Detailed, Drill Down and cyclic grouping in reports
• Expert documenting the project status, bug tracking and reporting using Quality Center
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Extensive experience in writing SQL and PL/SQL scripts to validate the databases and for backend database testing.
• Experience in Dimensional Data Modeling using Star Schema and Snow Flake Schema.
• Strong working experience wif SQL, PL/SQL, T-SQL and UNIX Shell scripting and Defect tracking systems.
• Very Strong Analytical, Debugging and Technical skills
• Excellent communication and interpersonal skills, Team player and Self-Starter

TECHNICAL SKILLS

Operating Systems: Unix- (Linux, HP Unix, IBM AIX), Windows XP,Vista,&7

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008, MS Access, Sybase, Teradata, DB2, Flat Files, CSV Files

Testing Tools: Quality center 9.2/10, Test Director 8.0

Querying Tools: SQL* Plus, TOAD, Oracle SQL Developer, SQL Assistant, Rapid SQL

ETL Tools: Informatica 8.x/9.x, Data Stage 6.x/7.x/8.x, Ab Initio (GDE 1.15, Co>Op 2.15)

Reporting Tools: Qlikview 10, COGNOS, Business Objects

Data Loading Utilities: Export/Import, Datapump, SQL Loader/

Scripting/Programming: SQL, PL/SQL, Unix Shell Scripting, PHP, HTML, XML, C, C++

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL TESTER

Environment: Informatica PowerCenter 9.0.1/8.x, Oracle 11g, Teradata V2R6/V12, Informatica Data Quality 8.6.2/ Developer 9.0.1, WINDOWS 7/XP, LINUX (Red Hat Enterprise 6), SQL Developer, Business Objects XI 3.0/3.1, Qlikview, Live Office and Xcelsius 2008, HP Quality Center 9.2

Responsibilities:

• Involved in analyzing business requirements, system requirements, Data mapping requirement specifications interacting wif client, developers and QA team.
• Involved in preparation of detailed Test Plan, Test Strategy, functional Test Cases, Test Script and executed them to ensure the business requirements are satisfied
• Participated in Integration & status meeting, mentor QA resources and create Test metrics
• Worked on HP Quality Center 9.2 to load test cases, execute them and log defects found in system testing.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Followed Agile Methodology especially SCRUM software development process throughout development, QA and UAT
• Exported the developed test cases into the Quality Center from the excel sheet using the ‘Export to Quality Center’ options wif the help of excel add-ins.
• Created the test environment for Staging area, loading the Staging area wif data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables, Used SQL Developer to run SQL queries and validate the data loaded in to the target tables.
• Tested complex mappings having transformations such as expression, joiner, aggregator, lookup, update strategy, filter and has written corresponding test scripts
• Created UNIX scripts for file transfer and file manipulation.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive Data validation using SQL queries and back-end testing
• Involved in testing entire application manually by using test plans and demo reports.
• Extensively involved in Report Testing of Qlikview Dashboards for data accuracy and cosmetics.
• Implemented the data validation for reports using data from different sources and writing SQL queries.
• Performed Data Loading for Test data using export/import utility, Data Pump, SQL* Loader

Confidential, GA

Environment: Informatica Power Center 8.6.1, Teradata V12, SQL server, Oracle 10g, UNIX, Teradata Assistant, Micro strategy

Responsibilities:

• Extensively used TOAD for Querying the database and back-end Testing
• Defects were tracked, reviewed, analyzed, compared and the feedback is given to the developers
• 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.
• Extensively created test cases to make sure the data originating from source is making into target properly in the right format as per the business requirement documents.
• Involved in creation of the test environment for Staging area, loading the Staging area wif data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Involved in ETL Data Validation, Testing functionality of mapping by preparing test data for all ETL mapping rules by loading data from various sources.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive Data validation using SQL queries and back-end testing
• Prepared demo reports to test functionality of report generation tool by writing stored procedures, SQL Queries and creating dummy tables using SQL Server 2000 database.
• Used various SQL built-in functions including the DDL and DML commands to check for the data integrity and data comparison.
• Implemented the data validation for reports using data from different sources and writing SQL queries.
• Developed PL/SQL packages, procedures, functions and triggers to support applications.
• Created and maintained database objects like tables, indexes, views.

Confidential

Environment: Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), Oracle 10g/11g, SQL * Plus, MS Excel Add-in, XML, Quality Center 9.2, Test Cases, Test Plan, Traceability Matrix, UNIX, Shell Scripting, Test Director, COGNOS

Responsibilities:

• Participated in Project Kickoff, External meetings, and Internal meetings (Test case review and Status meetings)
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared test plans, test strategies on project implementation
• Developed Test Cases, test Scripts for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Documented the test results and project status after test case execution using Mercury Quality Center
• Extensively used Informatica power center for testing ETL process.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping, Mapplet, Designer and Transformation.
• Extensively involved in loading the flat files, xml feeds, data from IMS mainframes into databases such as Oracle 11g, SQL server 2005
• Reviewed Informatica mapping results and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Testing TEMPhas been done based on Change Requests and Defect Requests.
• Written several UNIX scripts for invoking data reconciliation.
• Used TOAD for querying the data and is used to perform manual test in regular basis. UNIX and Oracle are using in dis project to write Shell Scripts and SQL queries.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Involved wif ETL test data creation for all the ETL mapping rules.
• Tested several complex reports generated by COGNOS including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Reported the Bugs/Defects using Quality Center 9.2 defect management tool.

Confidential

Environment: Oracle 10g/11g, Teradata V2R6, SQL SERVER 2000/2005, SQL Assistant, TOAD, OLAP, PL/SQL, SQL, UNIX Shell scripting, T-SQL, test cases, Test Scripts, Windows XPETL Informatica 8.6Project: Operation Data Store(Miniview)

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Test Director 8.0.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Look UP, Expression, and Sequence Generator Transformations.
• Extracted data from Relational Data Sources, Flat Files and Excel sheets.
• Validating the Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
• Executed the developed Test Cases and Test Plans.
• Extensively executed T-SQL queries to view successful transactions of data and for validating data in SQL Server DB.
• Converted requirements to test cases whenever needed and developed and executed test plans as per the requirement.
• Used Test Director to run the reports and get the information and post the information to developers
• Extensively used Debugger to validate maps and to gain troubleshooting information about date and error conditions.
• Migrated Mappings, Session and Common Objects from Development to QA environment.
• Monitored the data loads using Workflow Monitor.
• Optimized Informatica Mappings for Performance at Target, Source, transformations, mappings and Sessions levels.
• Executing the UNIX shell scripts and SQL queries on the UNIX box.
• Validating the parameter and config files.
• Involved in testing the UI applications
• Worked on Quality Center 9.0 for creating and documenting Test Plans and Test Cases and register the expected results.
• Attended daily status meetings wif Project management on testing update.
• Used SQL plus to test the integrity of data by querying the database.
• Performed Functional testing, System testing, Regression testing and Back end testing.