SUMMARY

• 7+ years of Experience in Quality Assurance and 5+ years of ETL/BI testing experience wif extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing..
• Expert in Oracle database testing.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Experience in developing the Manual Test Suites and Automated test suites.
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing wif business scenarios.
• Strong noledge of Business Intelligence, Data Warehousing and Business Architecture
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensive experience in testing of Investment banking and Academic clients.
• 5 years of strong data base experience in Oracle, SQL Server 2000, IBM DB2 and Sybase.
• Strong experience in testing tools like TestDirector7.6, Quality Center, Quick Test Pro.
• Expertise in writing SQL and PL/SQL statements.
• Good expertise in using TOAD, SQL*Plus and SQL Advantage.
• Experience in testing and writing complex SQL, T - SQL and PL/SQL statements.
• Experience in all aspects of project development life cycle.
• Experience wif integration testing of the applications using various sources like flat files, Sybase and oracle databases.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experience in debugging the issues.
• Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
• Excellent communication skills and Ability to work in-groups as well as independently wif minimum supervision and initiative to learn new technologies and tools quickly.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.

TECHNICAL SKILLS

ETL Tools: Informatica 8.6.1/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS 9.0, DataStage 8.1, Ab Initio (GDE 1.15, CO>Op 2.15)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

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

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R2/6.x/5.x,SSRS 9.0, MicroStrategy9.0

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML

Tools: Toad, SQL* Loader, SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP 10, Quality Center 9.2, Test Director 5.0

Rational Tools: RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS, Rational Requisite Pro, IBM Rational Manual Tester

PROFESSIONAL EXPERIENCE

Confidential

Sr.ETL SQL/ BI Tester/Analyst

Responsibilities:

• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Experience onEnterpriseTax Management(ETM) V2.2
• Preparation of test scenario’s and test cases based on FD and TD documents
• Generating and validating theCognosreports based on functionality
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and warehouse
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the Report requirements and migration of risks prior to formal acceptance.
• Performed Interface and Integration (SIT) Testing
• Extensively use SQL queries for data validation and backend testing.
• Working wif Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Track Sheet Maintenance and map the use case to requirement.
• Monitor Testing Activities wifin the team and report regular progress to the Test Manager.
• Work closely wif the software engineers to ensure successful, high quality releases.
• Working wif Tivoli job scheduler for submitting the jobs and monitoring the jobs
• Preparing the SQL queries to fetch the data from databases.
• Worked wif job scheduler tool Tivoli for running the ETL batch jobs and monitoring the batch jobs
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Gathering the requirements and preparing the case generation.
• Provide review comments on Test Scenarios and Test Cases based on Functional Requirement Specifications.
• Knowledge on Data validation, Data merging, Data cleansing and Data aggregation activities
• Execute theETLjobs sessions and workflows
• Preparation of Requirement Traceability Matrix, Test Metrics and Deployment manual
• Experience wif Data profiling, Data Validation and Data Integrity andData Cleansing and ETL processes using Informatica
• Perform User Acceptance Testing wif UAT test scenarios.
• Build deployment activities and participate in design (spec) reviews wif the Core team.
• Evaluate and suggest improvements to the software development process.
• Conduct Project Domain and Internal Project Functionality Training Sessions.
• Understand Business Requirement Specifications and System Requirement Specifications.
• Extract data from different source systems using Data Services tools.
• Create the universe based on the Reporting specification document.
• Prepare the SQL queries to fetch the data from databases.

Environment: Informatica Oracle SQL Developer, .Net 4.0, ASP.net 4.0, Web Methods and Web Services, UNIX, IBM COGNOS, HP Quality Center, Tivoli, SQL, PL/SQL, SOUPUI

Confidential, NYC, NY

Sr. ETL/BI Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Tested several UNIX shell scripting for File validation, Data Parsing, Cleanup and job scheduling.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Involved in creating Test plan, Test Cases, and Test scenarios
• Involved in Scenario based testing & Field level validation.
• Developed test cases bases on Requirement Specifications and Design Documents and executed using Quality Center.
• Executed batch processing and verified job status and data in database tables.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Performed Verification, Validation and transformations on the Input data (Text files, XML files, and database) before loading into target database.
• Validating transformed data by using transformation rules given in requirement document.
• Interacted wif functional/end users to gather requirements of core reporting system to understand exceptional features users expecting wif ETL and Reporting system and also to successfully implement business logic.
• Executed Stored Procedures and Triggers using PL/SQL to validate the data.
• Written several PL/SQL stored procedures. Tested the output of Stored Procedures vs. ETL output.
• Performed Functional, Data validation, Integration, Regression, and System testing.
• Used Oracle 9i to validate data that was populated by ETL applications.
• Executed UNIX commands to run the jobs.
• Designed and tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Prepared extensive set of validation test cases to verify the data
• Escalated issues in Issue register as necessary for meeting deadline.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in dis project to write Shell Scripts and SQL queries.
• Defects were tracked, analyzed, and documented using Quality Center
• Involved in Defect Triage meetings.
• Logged defects in Quality Center and worked wif the developers to resolve any issues.
• Reported the daily status of test cases executed/failed, defects status.
• Worked wif business analysts to assure new functionality changes were reasonable regarding existing physical design.
• Preparation of weekly and monthly status reports.

Environment: Business Objects XIR3/XIR2, SQL, PL/SQL, SQL Server 2008, XML, XSD, XSLT, XML Spy 2010,, KORN SHELL SCRIPTING, Informatica 8.6/7.1/6.2, Teradata V2R6 (SQL Assistant, Fast Load, Multi Load, TPUMP, BTEQ, FEXPORT), HP Quality Center 10, Oracle 10g, Erwin 4.0, UNIX, TOAD, WinSQL, Mercury Test Director 8.0

Confidential, Washington, DC

ETL Test Analyst

Responsibilities:

• Created Test Strategy and Test cases for the testing effort.
• Responsible for finding the indicators and writing the test scripts for testing the test cases.
• Conducted Smoke, Non Functional, Functional, System, Regression and Integration testing.
• Developed SQL to achieve the data transformations.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Performed back-end testing on the Oracle, DB2 and Teradata databases by writing SQL queries
• Conducted backend testing using SQL Assistant.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Responsible for testing all the four entities Group Batch, Group Real-time, Member Batch and Member Real-time.
• Participated in daily stand-up meetings wif the management team
• Responsible for testing the staging tables and Look-up spreadsheet.
• Worked on UNIX commands and shell scripting for scheduling the jobs from command line.
• Developed shell scripts for finding the XML’s for each member from the files.
• Worked wif clients to demonstrate agile techniques for software development, explained and implemented unit testing, created coding standards based on IBM recommendations.
• Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif performance tuning of complex SQL queries.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Performed Quality Analysis on problem reports against software and the production system in order to confirm that problems truly exists and can be recreated for testing
• Responsible for executing the test cases for Batch and Real-time that included both Member and Group data.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Responsible for the ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Executed the scenarios and analyzed the results through monitors and graphs.
• Tested and worked on creating open document reports for business.
• Actively communicated wif the end users and business users to create realistic test cases.
• Batch testing development and execution and done analysis of batch works.
• Participated in various meetings and discussed Enhancement Request issues.
• Review the test cases written based on the Change Request document.
• Testing TEMPhas been done based on Change Requests and Defect Requests.
• Conducted Regression testing after the bugs has been fixed by the development team
• Generated reports from Quality Center.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects

Environment: Informatica 7.1/6.2/5.1,7.X/6.X, SQL, PL/SQL, Teradata, IBM DB2, TOAD 9.2, Oracle 10g,MS SQL Server, Teradata SQL Assistant, XML, XML Spy 2008, UNIX, HP Quality Center 10.0, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP/2003.

Confidential, Dallas, TX

ETL Informatica Tester

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for Backend Testing of the data warehouse application.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Performed Functionality, Stress, Security, and GUI & Regression testing of web-based applications.
• Tested several reports and automated using Quick Test Pro.
• Wrote several Stored Procedures and modified existing stored procedures.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Analyzed business requirements, use case documents, functional specs & assisted QA team lead in writing the test plans.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Performed Manual Testing of the application Front-End and ETL testing.
• Developed test cases bases on Requirement Specifications and Design Documents and executed using Quality Center.
• Performed Functional, Data Validation, Integration, and Regression, System testing, Ad Hoc, Performance and User Acceptance testing.
• Created Test scripts for performance testing using Load Runner.
• Involved in Reports testing, Interface testing and DC (Data Conversion) Validation.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Was extensively involved wif backend testing by writing complex SQL queries.
• Worked wif Production environment to resolve several data issues.
• Executed Extraction, Transformation and Loading jobs and verified job status and data in Oracle tables.
• Validating transformed data by using transformation rules given in requirement document.
• Conducted regression testing for the fixes and enhancement of the application
• Logged defects in Quality Center and worked wif the developers to resolve any issues.
• Used Oracle Database to validate data that was populated by ETL applications.
• Involved in backend testing for different environments like Integration testing, System testing and User Acceptance Testing.
• Involved in CA/CR updates
• Actively participated in Defect Triage meetings.
• Reported the daily status of test cases executed/failed, defects status, worked wif business analysts to assure new functionality changes were reasonable regarding existing physical design.
• Preparation of weekly and monthly status reports.

Environment: Informix, DB2, Java, Cognos, Informatica Power Center 7.1, SQL, Teradata V2R5 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 5.0, XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Oracle 8i/9i, SQL Server 2000, Mainframe, SunOS 5.8, XML, DTS, ERWIN, Windows XP, Teradata.

Confidential

Software Engineer

Responsibilities:

• Performed manual testing of the application.
• Responsible for design, development and testing of Tournaments module.
• Performed report generation for Tournaments module.
• Actively involved in preparing test plans and test cases.
• Wrote SQL queries to perform database Validations
• Performed Unit Testing, Integration and Regression testing of the application.
• Reported bugs in Test Director.
• Generated weekly reports.

Environment: Windows 2000, Red Hat Linux 3.0, Oracle 8i, SQL, UNIX, LINUX, PL/SQL