SUMMARY:

• 7+ years of IT experience in the Analysis and Testing of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications, Web - based applications, and Financial applications.
• Experience working in the financial, healthcare and telecom industry verticals.
• Excellent QA experience in all phases of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies, disciplines, tasks, resources and documenting.
• Experience in Integration, Functional, System, Regression, SIT, Black Box, White Box and User Acceptance Testing (UAT).
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Experience on working with HPQC (Quality Center), Rational Tools - Rational Clear Quest, Rational Clear Case, Rational Requisite Pro and DOORS.
• Extensive experience in developing Test Plans, Test Scenarios, Test Strategies, Test Cases, Test Reports and RTMs.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing. i
• Solid Back End Testing experience by writing and executing SQL Queries.
• Have solid experience on database query tools such as TOAD, SQL Navigator, Teradata SQL Assistant, Rapid SQL, and SQL Plus.
• Experience is testing the Reports for data validation and cosmetic content.
• Good Experience in testing Initial (Reconcile) and Daily (Delta) ETL loads.
• Experience working in UNIX environment and good at file management using VI editor.
• Experience in maintaining the test environments; involved in requesting the deployments, requesting data loads, data base backups, restarting the servers, troubleshooting issues.
• Extensively worked with batch scheduling tools Autosys, Control M to run and monitor the ETL and batch jobs.
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Experience in meeting with Business Analysts and End Users to define, document and review functional and technical requirements.
• Worked with Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Have experience working as execution support for Autosys Scheduling Team in 24x7 shifts.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, JAVA, Visual Basic, C#, VB .Net, ASP .Net, PL/SQLRDBMS: Oracle 11g/10g/9i/8i, DB2 (Mainframes), Teradata V2R5/V2R6Sybase, MS SQL Server 2003/2005/2008/2010

Operating Systems: Microsoft Windows 98/XP, Linux, UNIX

RDMS Query Tools: TOAD, SQL Assistant, SQL Navigator, SQL * Plus, Rapid SQL

Testing Tools: QTP, WinRunner

Test Management Tools: HP Quality Center

Version Control Tools: Rational Clear Case

Defect Tracking Tools: Rational Clear Quest, HP Quality Center, JIRA

Incident Mgmt. Tools: BMC Remedy

Scheduling Tools: Autosys, Control-M

Reporting Tools: Crystal Reports, Cognos, BOXI, SSRS, Micro Strategy

ETL Tools: Ab-Initio, Informatica Power Center, Data Stage, SSIS

Other Tools: Putty, TextPad, Compare It, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr. ETL/DWH/BI QA Analyst/Data Analyst

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Experienced business analyst specializing in requirements analysis and SDLC documentation in Waterfall, Agile and Scrum methodologies.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed complex data validation using SQL queries.
• Verified the logs to identify the errors occurred during the ETL execution.
• Involved in testing SSIS Packages, and in Data Migration.
• Worked in agile to create, maintain and execute test cases while participating in the validation of functional and non-functional requirements in an agile development environment.
• Actively provided inputs for agile retrospective to improve the process.
• Worked in agile methodology to perform manual exploratory and acceptance testing of new features being iteratively developed
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Tested the Informatica mappings and other ETL Processes (DW Testing).
• Used Team Foundation Server as a test management tool for preparing test cases and executing them.
• Prepared Mock data based for covering all the scenarios on the different test cases.
• Have tested reconcile and incremental ETL loads for the project.
• Scheduled shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Written Shell scripts to run Informatica mapping jobs.
• Written Shell scripts to handle data before executing Informatica Maps and to meet pre-requirements to run the Maps.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Used Rational Clear Quest as defect tracking tool.
• Validated various SSIS and SSRS packages according to the functional requirements.
• Worked on application integration testing in SOA Architecture and validated the SOAP based web services.
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Passed the various requests for web services in Soap UI and validated the responses.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Environment: Informatica Power Center 9.1, Informatica Data Validation Option (DVO), Clear Case, OBIEE, Clear Quest, SQL, PL/SQL, UNIX, Putty, Shell Scripting, .NET, HTML, ASP .NET, SSIS, SSRS, SSAS, TFS, Flat files, XML files, Sybase, WinSCP, Oracle 11g, CompareIT, Web Services, SOA, Soap UI, HP Quality Center, Autosys, SQL Server 2008, and TOAD.

Confidential, Charlotte, NC

DW | BI Tester | Data Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Assist in the maintenance of technical and non-technical SDLC documentation.
• Creation of SDLC documentation, including User Requirements, Technical Specifications, and Test Cases.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• 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.
• Involved in extensive testing of batch processing for positive and negative scenarios.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Extensively tested the Cognos reports for data accuracy and static errors
• Tested Ab Initio graphs with both positive and negative scenarios.
• Responsible to test the functionality of Ab Initio graphs.
• Responsible for testing Initial and daily loads of ETL jobs.
• Written Shell scripts to run the Ab Initio developed jobs (.ksh) and Automated the ETL process through scheduling and exception routines.
• Participated in developing the file management and ftp process for transmitting the files, also scheduled the daily batch process.
• Created new projects in Soap UI to validate the web services.
• Worked with regulatory compliance data and did testing for web interface modules for exchanging the data feeds between the systems.
• Performed Negative testing using Ab-Initio GDE to find how the functions and variables perform when it encounters invalid and unexpected values.
• Used Rational Clear Quest for the bug tracking and Rational Quality Manager for Test Case Management.
• Used Rational Requisite Pro for requirement management.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Validating the data passed to downstream systems.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in validating inbound and outbound batch processes.
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Ab Initio 2.13, DB2, Java, SQL, SQL Server 2008/2005, .Net, SSIS, Rational Clear Quest, Rational Clear Case, Batch Jobs, Shell Scripting, Cognos 8, Autosys, Rational Requisite Pro, OBIEE, XML, XSLT, IBM AIX 5.3, Netezza, Web Services, Soap UI, UNIX, Web Logic, WINSQL, Remedy, Putty, HP Quality Center 10, Oracle10g

Confidential, Reston, VA

ETL QA | Web based Tester

Responsibilities:

• Analyzed the business requirements, system requirements, and data mapping requirement specifications, interacting with client, developers and QA team.
• Written Test Plans, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Tested Metadata of tables including the data types, constraints and default values on the columns.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
• Created and executed Test cases in Soap UI to validate web services.
• Tested Ab Initio graphs with both positive and negative scenarios.
• Responsible to test the functionality of Informatica workflows.
• Responsible for testing Initial and daily loads of ETL workflows.
• Involved in preparation and maintenance of the Requirement Traceability Matrix (RTM) to measure the progress, test matrix and test script review.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Written several complex SQL queries for validating Business Objects Reports.
• 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.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Oracle data warehouse
• Extensively used Rational Clear Quest to track defects and managed them.
• Tested whether the reports developed in Micro Strategy are as per company standards.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Informatica 8.1, Oracle 10g, SQL Server, HP Quality Center, SQL, TOAD, PL/SQL, DB2, Business Objects XI, Micro Strategy, Microsoft Visio, XML, J2EE, .Net, Web Logic, Clear Case, Netezza, Teradata, Clear Quest, DOORS, Autosys, Web Services, Soap UI, Shell Scripting, Windows XP, TIBCO, Putty, UNIX

Confidential, Buffalo, NY

ETL/QA Analyst

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 for User Acceptance (UAT), Functional and Regression test cases.
• Reviewed unit test cases and test results and certified the code for integration testing
• Created user acceptance testing documents and reviewed them with the customer.
• Mapped test cases to requirements using quality center
• Involved in entering and tracking defects using Rational Clear Quest.
• Ran Data Stage jobs by using Data Stage Director and by running UNIX scripts as well.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Conducted reviews of test plans, test cases, and prepared test results.
• Used Data Stage Director to run the ETL mappings and monitor the status.
• Effectively 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.
• Validated business objects reports for data and lay out.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• 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 9i, Toad, DB2, SQL, PL/SQL, Business Objects, MS Visio, Rapid SQL, Mainframes, data stage, TOAD, .Net, XML, Windows, TIBCO, UNIX, SQL Navigator

Confidential, Pittsburgh, PA

Manual | DWH Tester

Responsibilities:

• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Applications.
• Preparation of technical specifications and Source to Target mappings.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively tested several Crystal Reports for data quality, fonts, headers & cosmetic.

Environment: UNIX, Informatica Power Center, Mercury Test Director 6.5, SQL *Loader, Crystal Reports, Oracle 8i, SQL Server 2000, Putty, Erwin 3.5, Java, J2EE, Windows XP, TOAD.