SUMMARY

• 8 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.
• 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), WinRunner, 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.
• 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.
• Have experience working as execution support for Autosys Scheduling Team in 24x7 shifts.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

Languages: C, C#, SQL, JAVA, Visual Basic, VB .Net, ASP .Net, PL/SQL

RDBMS: Oracle 11g/10g/9i/8i, DB2 (Mainframes), Teradata V2R5/V2R6Sybase, MS SQL Server 2003/2005/2008

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

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

Test Documentation: Test Plan, Test Summary Reports, RTM, Bug Reports

PROFESSIONAL EXPERIENCE

Confidential, Marlborough, MA

DW/BI Tester/Data Analyst

Responsibilities:

• Analyzed the Requirements from the client and developedTest 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.
• Worked with developers to gather information for a set of Development Plan templates documenting the service’s requirements, functional, and technical design Included SDLC documentation.
• 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.
• Participated every day started meetings, story reviews.
• Actively provided inputs for agile retrospective to improve the process.
• Preformed regression analysis refectory of code.
• Actively provided forecasted the road blocks issues that may happen in Agile Development process.
• Worked in agile to designs acceptance tests, from functional requirements that clearly convey the business user’s intent to the entire agile development team.
• 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.
• Preparation of System Test Results after Test case execution.
• Tested theInformatica mappings and otherETLProcesses (DW Testing).
• Effectively coordinated with development team for closing a defect using Team Foundation Server.
• 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.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Scheduling shell script jobs, creating instances of jobs, verifying logs according to client requirement using Autosys server.
• Used Team Foundation Server as a defect management tool.
• 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.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Involved in Smoke and System Testing.
• Validated various SSIS and SSRS packages according to the functional requirements.
• Experience testing on XML documents.
• 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.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Analysis and data digging using SQL to find root cause of defects
• Worked effectively to meet the deadlines for each release.
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do.
• Developed UNIX Shell Scripts for scheduling variousdata cleansingscripts and loading process.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Informatica Power Center 9.1, ClearCase, OBIEE, ClearQuest, SQL, PL/SQL, UNIX, Putty, Shell Scripting, .NET, HTML, ASP .NET, SSIS, SSRS, Session Log files, TFS, Flat files, XML files, Sybase, WinSCP, Oracle 11g, CompareIT, HP Quality Center, Autosys, SQL Server 2008, and TOAD.

Confidential, Danville, PA

Sr. ETL/DWH/BI/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 Data mapping specifications to create and execute detailed system test plans.
• The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Worked onAutosysforBatch ProcessingETL, 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
• TestedAbInitiographs 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 handle data before executing graphs and to meet pre-requirements to run the Ab Initio graphs.
• 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.
• 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.
• UsedRationalClearQuestfor the bug tracking andRationalQuality Managerfor 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, DB2, Java, SQL, SQL Server 2008/2005, .Net, SSIS, Rational ClearQuest, Rational ClearCase, Batch Jobs, Shell Scripting, Autosys, Rational Requisite Pro, OBIEE, XML, XSLT, IBM AIX 5.3, Netezza, UNIX, Web Logic, WINSQL, Remedy, PuTTy, HP Quality Center 10, Oracle10g

Confidential, Reston, VA

Sr. ETL/ Data Analyst

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.
• TestedAbInitiographs 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.
• Involved in preparationand maintenance of theRequirement Traceability Matrix(RTM) to measure the progress, test matrix and test script review.
• Tested the ETL AB Initio 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 usedRational Clear Questto 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: Ab Initio, Oracle 10g, SQL Server, HP Quality Center, SQL, TOAD, PL/SQL, DB2, Business Objects XI, Micro Strategy, Microsoft Visio 2003, XML, J2EE, .Net, Web Logic, Clear Case, Netezza, Teradata, Clear Quest, DOORS, Autosys, Shell Scripting, Windows XP, TIBCO, Text Pad, PuTTY, UNIX

Confidential

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 forUser Acceptance (UAT), Functional and Regressiontest 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.
• Involved in communicating with support, business and development teams to resolve issues during test execution.
• 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

DWH Tester

Responsibilities:

• Develop 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.
• Reported bugs and tracked defects using Test Director 6.5
• 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.