SUMMARY

• 7 years of extensive and diversified experience in Information Technology with 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, Migration testing and BI Reports Testing
• Experienced in MIGRATION Testing of informatica code from version 8x to 9x, from development to test and production environments
• 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 with 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 with 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 teh Business Requirement and System Requirement documents
• Implemented various Test cases for teh Functional Testing, System Testing, Unit testing, Regression Testing, Smoke Testing, Integration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Involved with preparation, testing and validation of ETL test data for all teh 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 teh 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 teh databases and for backend database testing.
• Experience in Dimensional Data Modeling using Star Schema and Snow Flake Schema.
• Strong working experience with 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), ODI

Reporting Tools: Qlikview 10, COGNOS, Business Objects, OBIEE

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 with client, developers and QA team.
• Involved in preparation of detailed Test Plan, Test Strategy, functional Test Cases, Test Script and executed them to ensure teh 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 teh developed test cases into teh Quality Center from teh excel sheet using teh ‘Export to Quality Center’ options with teh halp of excel add-ins.
• Created teh test environment for Staging area, loading teh Staging area with 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 teh data loaded in to teh 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 teh 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 teh 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 teh database and back-end Testing
• Defects were tracked, reviewed, analyzed, compared and teh feedback is given to teh 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 teh data originating from source is making into target properly in teh right format as per teh business requirement documents.
• Involved in creation of teh test environment for Staging area, loading teh Staging area with 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 teh tables and columns from which data is extracted.
• Created Test input requirements and prepared teh 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 teh DDL and DML commands to check for teh data integrity and data comparison.
• Implemented teh 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 teh Business Requirement Documents and teh 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 teh 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 teh 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 teh requirements / ETL Analysis, ETL Testing and designing of teh flow and teh logic for teh 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 teh data and is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Involved with ETL test data creation for all teh ETL mapping rules.
• Tested several complex reports generated by COGNOS including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Reported teh 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 teh Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for teh mappings developed through teh ETL Informatica tool.
• Executed teh 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 teh requirement.
• Used Test Director to run teh reports and get teh information and post teh 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 teh data loads using Workflow Monitor.
• Optimized Informatica Mappings for Performance at Target, Source, transformations, mappings and Sessions levels.
• Executing teh UNIX shell scripts and SQL queries on teh UNIX box.
• Validating teh parameter and config files.
• Involved in testing teh UI applications
• Worked on Quality Center 9.0 for creating and documenting Test Plans and Test Cases and register teh expected results.
• Attended daily status meetings with Project management on testing update.
• Used SQL plus to test teh integrity of data by querying teh database.
• Performed Functional testing, System testing, Regression testing and Back end testing.