Professional Summary:

• 7 years experience in Requirement's Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance and testing, worked as ETL Tester, BI Tester and QA Analyst.
• Excellent Communication, Analytical and Interpersonal skills.
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience with test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Extensive experience in ETL and BI testing Business Objects, Cognos, Micro Strategy, OBIEE for many data extractions and data migration projects.
• Well versed with SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client-server and web based applications in all phases of SDLC
• Experience in Functional, Regression, GUI, Usability , Integration, Exploratory, Smoke, Backend, Adhoc, Load, Performance, Black Box and White Box Testing
• Experience in Mainframe Testing
• Extensive experience in Data warehouse testing Informatica, Ab Initio, Data Stage
• Proficient in SQL queries
• All testing engagements completed within project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.

Technical Skills:

• Data Warehouse Tools: Informatica 8.6/8.1/7.1/6.2/5.1, SSIS, MS DTS Packages, Ab Initio, Data Stage
• BI Tools: Cognos 8.0 Series Business Objects XIR3
• Database: Oracle 10g/9i/8i, SQL Server 2005/2008, IBM DB2, Teradata V2R6, Sybase 12.5
• Change Mgt Tools: Test Director 8.0, Quality Center 10/9.2/8.2, Rational Clear Quest
• Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0
• Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, PERL, Shell Scripting
• Office Tools: MS Office Suite, MS Project, Microsoft Share Point
• Operating System: UNIX, LINUX, Windows, MS-DOS
• Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester
• Standards: VSTF 2008, METAL, SQL Server Analysis Server
• Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS, XML Spy 2010
• Web Technologies: XML, HTML, JavaScript, VBScript

Professional Experience:

Confidential

Sr. ETL QA/BI QA

Roles Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Worked with various EDI transactions like 834,835,837,276,277in accordance with HIPPA standards
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing implementation of the test plan, various test cases test scripts.
• Performed Functionality, Stress, Security, GUI Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Involved in testing the Cognos reports by writing complex SQL queries
• Tested several reports and automated using Quick Test Pro.
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Created the test data for interpreting positive/negative results during functional testing.
• Involved in the whole testing life cycle covering the entire project from initiation to completion
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. Involved in the development of Informatica Mappings and also tuned them for better performance.
• Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
• Extensively involved with backend testing by writing complex SQL queries.
• Worked closely with the development teams to replicate end user issues.

Environment: Informatica 9.1, MS SQL Server 2008, Oracle 11g SQL, PL/SQL , TOAD, MS Access, Citrix Server, QTP, Quality Center 10, Cognos 8 BI Cognos Connection, Cognos 8 BI, XML, XSD, XML Spy 2010, J2EE, Rational Clear Quest

Confidential

Data Warehouse Tester

Roles Responsibilities:

• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Authored test plans and test cases based on Informatica Mappings and Data Analyst Mappings.
• Executed Informatica ETL sessions in different stages Source to Stage Staging to Data ware to Datamart and to Business objects.
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Wrote PL/SQL stored procedures for certain data validations
• Used Quality Center for test planning and execution and Rational Clear Quest was used for defect tracking.
• Validated the interface from Frontend to backend tables
• Performed Sanity testing, Security testing, black box and white box testing, web testing and GUI testing
• Performed testing on Java, .NET and on web based applications
• Was involved in executing the Regression testing on new Builds
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Used the ETL processes of Informatica tool to load data from MS SQL Server and Oracle, into the target Oracle database.
• Managed test environments and schedules
• Created, updated and ran the QTP scripts
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders
• Tracked bugs using Quality Center and generated the defect reports for review by the client and the management teams.
• Generated testing reports and metrics, trend graphs according to the test plan
• Created and executed SQL queries in ORACLE and MS SQL server
• Performed tests on various browsers
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.6.1, Business Objects XIR3, Oracle 10g/9i, SQL Server 2000, SQL, PL/SQL, Stored Procedures, Quick Test Pro 9.2, Quality Center 9.2, Points Portal, AutoSys, MS Office Suite, PERL, HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, UNIX.

Confidential

Data Warehouse Tester

Roles Responsibilities:

• Worked closely with the development teams to replicate end user issues.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted with the client on a daily basis and attended status meetings.
• Worked with developer to improve database performance.
• Created and maintained development, QA and audit database environments
• Attended status meetings and sending team status reports.
• Use of TOAD to write SQL queries and validate the backend
• Documentation of Test Results, Test Reports and Test Summary Report.
• Performed Database Testing using SQL queries for testing reports.
• Defined QA procedures to plan, design, execute, evaluate and report results of software testing under minimal or no supervision.
• Worked with QA team members and application developers quickly capture the major business functions and technology to design and implement tests of system functionality that exercise all critical intersystem integration points.
• Utilized mercury test suite for requirement management, test case creation, execution and defect tracking.
• Provided training and mentoring to offshore QA team.
• Executed Ab Initio ETL sessions in different stages Source to Stage Staging to Data ware to Datamart and to Business objects.
• Tested many Ab Initio graphs and tested the functionality of ETL mapping rules.
• Wrote PL/SQL stored procedures for certain data validations

Environment: PL/SQL, SQL, Quality Center, UNIX, Shell Scripting, Ab Initio GDE 1.12, Co>Op 2.12 , MVS, JCL, VSAM Files, XML Files, CSV, Copy Books, AutoSys, Crontab, Oracle 10g, Sybase 12.3, Business Objects XIR2, TOAD, WinSQL

Confidential

Software Engineer

Roles Responsibilities:

• Prepared detailed business requirement documents.
• Worked on gathering requirements for loan level and pool level amortization process.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Developed Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed System Testing and Integrity Testing using WinRunner.
• Developed, tracked and managed Issues Log created during the test phase using Excel.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL on UNIX platform to perform Backend Testing on databases.
• Performed Load Testing, Stress Testing and Performance testing using LoadRunner.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.
• Maintain SQL scripts for creation of database objects.

Environment: SQL, PL/SQL, AutoSys, Test Director, JSP, Java Script, HTML, Windows NT/2000, UNIX