SUMMARY

• Extensive 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), GUI and Web based application testing.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Experience on working with HP QC (Quality Center), WinRunner, Rational Tools - Rational Clear Quest, Rational Clear Case, Rational Requisite Pro and Telelogic 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.
• Having excellent communication, great inter-personal organizational skills, professional attitude and ethical approach.
• Taking responsibility for own work, capability to adapt and learn new tools and applications, ability to attain a high degree of accuracy and neatness in work presentation.
• Excellent personal time management, organizing, analytical and problem solving skills.

TECHNICAL SKILLS

Languages: SQL, JAVA, Visual Basic, PL/SQL

RDBMS: Oracle 10g/9i/8i, DB2 (Mainframes), Teradata V2R5/V2R6,Sybase, 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

Test Management Tools: HP Quality Center

Version Control Tools: Rational Clear Case

Defect Tracking Tools: Rational Clear Quest, HP Quality Center, Team Foundation Server (TFS)

Incident Management Tools: BMC Remedy

Scheduling Tools: Autosys, Control-M

Reporting Tools: Cognos, Business Objects, 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, Weekly Status Reports, Test Readiness Review, Shift Logs

PROFESSIONAL EXPERIENCE

Confidential, Concord, CA

QA Analyst (DWH/ETL)

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements and Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.
• Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments that would account for durations, constraints, assumptions, etc. that are required to accomplish test objectives.
• Test Cases were written and managed in HP Quality Center, based upon functional requirements, and system specifications
• Prepared test data for positive and negative testing used in data driven testing for testing the application dynamically
• Conducted a wide range of testing to ensure that the services meet client standard and end user requirements.
• Continuously in touch with business users in order to acquire up-to date requirements and enhancements.
• As a team, responsibly involved in writing complex queries using SQL and PL/SQL to generate data based upon the business rules and attributes.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Applied the relational database concepts like Tables, Primary and foreign keys, Views and Referential Integrity.
• ETL batch was run daily to test the performance of the Optright conversion tool
• Actively involved in setting up new data on the source to ensure that no testing scenario is missed
• Integration testing was done to ensure data processing, interface validity and proper communication among components of each application
• Beside manual testing, bulk sql scripts were written and executed to enhance the testing performance in a short period of time
• Regression includes black box/white box, Positive/Negative testing.
• Involved in tracking defects and generating defects reports by using TFS
• Actively attended meetings with fellow testers and other groups to evaluate the performance of the application and to discuss the issues arising out of testing.
• Held periodical meetings with the Development team to gather information on the progress and resolve project issues

Environment: SQL server 2008, MS-Access, MS-Visio, Test Director, XML, Java, MS Project, MS Office

Confidential, New York City, NY

Sr. QA Analyst (DWH/ETL/BI)

Responsibilities:

• Developed and conducted a wide range of Tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
• Involved in obtaining Test requirements from the Business Users for new change requirements and enhancement request.
• Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute.
• Participated in Project discussions with analyst, developer & testing teams.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Responsible to test the functionality of Ab Initio graphs.
• Validating the data passed to downstream systems.
• Worked with the development team to create a suite of test data (Input files, Expected results), that fully exercises data validation (detecting, rejecting bad data) to test ETL functionality (properly processing).
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Trackedand executedtheUser AcceptanceTest Cases with respect to the requirements to determine the featurecoverage.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in testing the GUI application testing and Cognos report testing for data quality and format.
• Involved in testing the batch programs by using the Autosys tool.
• Responsible for preparing test cases and scenarios for System testing and UAT testing.
• Have worked in UAT team for CDW ETLs execution support.
• Creating and maintaining repositories, source systems, target databases and developing strategies for ETL mechanisms using Ab Initio.
• Involved in creating various data scenarios (Excel Sheets having expected data) and validating them before and after running the respective Autosys batches.
• Developed UNIX scripts for file archiving, file transfers and file management.
• Involved in Database Validations, Writing Test scripts (Including the related SQL Statements by joining various tables) depending on Requirements for both Positive and Negative Scenarios.
• Involved in Security Access Testing for Role based Internal and External Users application.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Involved in project requirements analysis, writing test specifications, formulating test plan, executing test cases & keeping track of the defects logged (Using Rational Clear Quest).
• Attended and worked with agile scrum standup meetings.

Environment: Ab Initio 2.14, Oracle 11g, SQL, PL/SQL, Toad, Autosys, IBM DB2 V8, RapidSQL, BOXI Reports, Rational Clear Quest, Rational Clear Case, Cognos, DOORS, Oracle SQL Developer, HP Quality Center, VBScript, UNIX, Putty, XML, XSD, XSLT, WinSCP, Leech FTP, Remedy, Windows XP/NT.

Confidential, Kenilworth, NJ

Sr. QA Engineer (ETL/DWH/BI/Data Analyst)

Responsibilities:

• Analyzed the Requirements from the client and Developed Test cases based on functional requirements, General requirements and system specifications.
• Lead and/or participated in the creation, distribution and walkthrough of software test cases, scripts and other documents surrounding testing activities and ensure that all testing activities and deliverables are conducted/produced in compliance with company standards.
• Used DOORS as version control tool for tracking requirements.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Wrote scripts to upload data into database tables on IBM DB2 Command center.
• Prepared Test Cases for system testing and uploaded them into Quality Center; Linked the test cases to the business requirements; Defects to Test Cases.
• 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
• Have tested different Informatica transformations like Source Qualifier,Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Involved in preparing RTM by link and sync process, mapping the test cases with the appropriate requirements in Quality Center.
• Involved in validating various SSIS packages according to business requirements.
• Reviewed the Test Cases and SQL queries prepared by other team members.
• Extensively used Informatica Workflow Manager to run the workflows.
• Documented the Defects found in testing using Clear Quest.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Extensively involved in System testing & Regression testing and Integration testing
• Tested various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible in testing Initial and daily loads of ETL jobs.
• Prepared and reviewed reports for Final System test.
• Have involved in testing reports developed in MicroStrategy.
• Used Rational Clear Case to upload final test scripts and test results after final SIT (System Integration Testing) and UAT test scripts.
• Executed automated test scripts using QTP for Regression testing.
• Excel reports are validated using SQL and embodying complex formulas in the Excel.
• Lead the team to review the Test Results for the Full System and Final System Test cycle.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: SQL, PL/SQL, SQL*Loader, Oracle 11g, IBM DB2 V8, Informatica Power Center 8.6, Rational Clear Quest, Rational Clear Case, Telelogic DOORS, Oracle SQL Developer, RapidSQL, HP Quality Center, QTP 10.0, Mainframes, SSIS, SSRS, SQL Server, Apache Tomcat, Putty, Toad, VBScript, MicroStrategy Reports, WinSCP, Leech FTP, Solaris 10, XML, XSD, XSLT, Windows XP/NT.

Confidential, Montville NJ

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

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements and Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.
• Analyzed the user requirements, functional specifications and Use Case documents and created the Test Plans, Test cases for Functional testing.
• Worked closely with ETL team in each phase of project (data requirement analysis, data field analysis, data mapping and ETL testing)
• Built external mapping to transfer data from SQL Server database to Oracle Data Warehouse. This includes writing SQL Statements.
• Coordinated in testing data stage ETL using complex stored procedures.
• Acted as first point of contact for all critical issues related to data mapping and data sourcing
• Reviewed and tested Informatica ETL code
• Involved in Integration Testing, and Data Testing including boundary testing.
• Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements.
• Actively participated in Functional testing, System testing, and Ad-hoc testing.
• Analyzed bugs, worked with development team and ETL team members in fixing defects and validating the solutions.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Tested many SSIS ETL packages for the project according to data mapping requirements.
• Interacted with the development and product management team to find out the end user actions and scenarios.
• Tested ad-hoc and standard reports generated by using MicroStrategy.
• Involved in providing the Testing effort estimates and provided the timely feedback on progress of the testing activity.
• Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics.
• Successfully Coordinated User Acceptance Testing (UAT) on each release of the project with the help of end user requirements.
• Involved in doing Business analysis and Requirements gathering for new Informatica mappings.
• Coordinate all aspects of the solution delivery including design, development, testing, and deployment.

Environment: Oracle 9i, MS SQL Server 2005 SSIS, SSRS,InformaticaPower Center 8.1/7.1, Data Stage, MicroStrategy, Manual Testing, QTP, PL/SQL, Autosys, Rational Rose, Rational Clear Case, Rational ClearQuest, Cognos, MS Office Suite.