SUMMARY:

• Over 8 years of IT experience in the Analysis and Testing of Business Intelligence solutions, Data Warehouses, Data Marts, SQL, QA, OLAP, Client/Server applications, Web - based applications in Financial, Health Care, Wireless, Mobile and Retail domains.
• Excellent QA experience in all phases of Software Testing Life Cycle (STLC) 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 coordinating User Acceptance Testing (UAT).
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Experience in creating Source to Target Mapping documents.
• Worked with many ETL tools like Informatica Power Center 7.1.3/8.2/8.6.1 , Abinitio
• 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 in report data validations and cosmetic data validations which are developed in Cognos /MicroStrategy and Business Objects.
• Experience is testing the Reports for data validation and cosmetic content.
• Good Experience in testing Initial (Reconcile) and Daily (Delta) ETL loads.
• Technical strengths and automated test tool expertise includes Quick Test Professional (QTP), Quality Center, VBScript, SQL and Rational Tool Suite
• 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, trouble shooting issues.
• Experienced in testing BI reports generated using different BI tools likeTableau,MicroStrategyand Business Objects
• Extensively worked with batch scheduling tool Autosys to run and monitor the ETL and batch jobs.
• 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:

ETL Tools: Informatica Power Center 8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Ab-initio

BI & Reporting: Business Objects XIR3/R 2/6.5/6.0/5.0 , Cognos, BO Developer Suite 6.0/5.0 (Designer, Web Intelligence, Broadcast agent, Netezza, Supervisor, Module)

Testing Tools: QTP, Test Director, Quality Center, Visual Basic 5.0/ 6.0

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2008/2005/2000/7.0/6.5 , IBM DB2, Teradata V2R6, MS Access

Job Scheduling: Autosys, BMC Control M

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux, MS-DOS

Web Service Tools: SOAP UI

Languages/Utilities: SQL, PL/SQL, SQL Developer, TOAD, Quest Central for DB2,XML

PROFESSIONAL EXPERIENCE:

Confidential, OH

SQL Database Tester

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested all the compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested the XMLs feeds received from another source, which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Distributed the reports to the users via Cognos Connection.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained the entire test cases in HP Quality Center and logged all the defects into the defects module.
• Tested the migration of reports from Business objects XIR2 to XIR3.
• Provided the management with weekly QA documents like Test metrics, Daily status reports, Test schedules and Test Exit Report.

Environment: Quality Center 9.0, Informatica Power Center 9.1/8.6, Netezza, Cognos, Erwin, Ms Excel, Oracle 10g, SQL, PL/SQL, SSIS, SSRS, Teradata utilities, TOAD 8.0, UNIX, XML

Confidential, King of Prussia, PA

Sr. SQL Test Analyst

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting & PERL
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.
• Performed Regression testing/system integration/integration testing/ System Integration testing/ Smoke testing
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and XML data.
• Involved in validating SSIS and SSRS packages according to data mapping specifications.
• Created projects, Models, and Packages using Cognos Framework Manager and deployed packages on cognos connection.
• Tested whether the Business Objects reports developed in OLAP are as per company standards.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Performed System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports.

Environment: Oracle 10g, Business Objects, SQL Developer, SQL Server 2008, TOAD, Informatica Power Center 8.6.1, HP Quality Center, PL/SQL, Netezza, UNIX, Putty, SSIS, SSRS, Session log files, Flat files, XML files, Remedy, SnagIT, CompareIT, MS Office, Clear Quest (CQ) and Clear Case.

Confidential, Louisville, KY

Sr. ETL/QA Analyst

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Responsible for validating the files availability, format and data on UNIX server
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Used Toad for testing execution of ETL.
• Performed Data Driven Testing of the Application for different users/data sets
• Developed Test cases for the data warehouse in Oracle System
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness
• Experience in creating UNIX scripts for file transfer and file manipulation.

Environment: SQL, PL/SQL, UNIX, Toad, Test Director V7.6, Informatica Power Center 7.1, Windows NT, Sun Solaris, MS SQL server, Oracle 9i, Crystal Reports

Confidential, New York

DW Tester-Product Sales Data Mart

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, trouble shooting 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.
• Responsible to test the functionality of Ab Initio graphs.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in validating various SSIS and SSRS packages according to functional requirements.
• Involved in preparationand maintenance of theRequirement Traceability Matrix(RTM) to measure the progress, test matrix and test script review.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Tested the ETL AB Initio mappings and other ETL Processes (Data Warehouse Testing)
• 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 Business Objects 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 2.13, Oracle 10g, SQL Server 2008, SSIS, SSRS, HP Quality Center, SQL, TOAD, PL/SQL, DB2, Business Objects XI, Microsoft Visio 2003, XML, XSLT, .Net, Web Logic, Clear Case, Netezza, Teradata, Clear Quest, TFS, DOORS, Autosys, Windows XP, PuTTY, UNIX