PROFESSIONAL SUMMARY:

• Around 7+ Years of Professional Experience in Software Quality Assurance (QA) and Testing in different environments and platforms including Data Warehousing, Business Intelligence, Manual testing, Client/Server and Web based applications.
• Experience in Data Warehouse applications testing using Informatica, Ab Initio on multiple platforms.
• Involved in gathering requirements, developing Test Plans, Test Scripts, Test Cases & Test Data using specifications and design documents.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Involved in all phases of the QA Life Cycle and SDLC, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
• Extensive experience in writing SQL and PL/SQL scripts to validate the databases systems and for backend database testing.
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Experience in testing tools like HP ALM/Quality Center and Jira.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in corporate - wide-ETL solutions using Informatica and DataStage.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch
• Solid experience in manual testing, Black box & White box testing techniques.
• Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Performed Manual and Automated Testing on Client-Server and Web-based Applications.
• Extensive experience in drafting Test Flows, Test Plans, Test Strategies, Test Scenarios, Test Scripts, Test Specifications, Test Summaries, Test Procedures, Test cases & Test Status Reports.

TECHNICAL SKILLS:

Informatica 8.1,9.1, SSIS: Data Stage 7.5.1, 8.1, Ab Initio (GDE 1.14, Co>Operating System)

Programming: SQL, PL/SQL, MS SQL, UNIX Shell Scripting, PERL, XML, XSLT

Operating Systems: Windows 95/98/NT/2000, UNIX (Sun Solaris2.6/2.8, Linux 2.4, HP-Unix, IBM AIX 5.5)

Databases: Oracle 11g, 9i/10g, IBM DB2 9.x, Sybase 12.5, SQL Server 2008, TeradataV2R6 and Informix.

Testing Tools: HP Quality Center 10, 11 Rational Clear Quest

Clear Case,: Ab Initio EME, PVCS 7.0

Tools: XML Spy 2010, Putty, WinSCP3, Scorex, AppEdit v8.2, Ultra Editor, Control - M, TWS, FileZilla

PROFESSIONAL EXPERIENCE:

Confidential, Marysville, OH

Sr. ETL/BI Tester

Responsibilities:

• Created Test Plan for System Testing.
• Involved in all phases of SDLC which includes gathering of functional requirements in Agile speed pod projects, code reviews and Unit testing.
• Identify & record defects with required information for issue to be reproduced by development team.
• 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.
• Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.
• Involved in standardized guiding principles for maintaining an enterprise wide, reusable approach to transition code from User Acceptance Test (UAT) environments
• Used HP ALM Quality Center to track and report system defects
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Prepared Test Cases for system testing and uploaded them into HP ALM Quality Center Linked the test cases to the business requirements; Defects to Test Cases.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Involved in preparing RTM by link and sync process, mapping the test cases with the appropriate requirements in Quality Center.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Written several complex SQL queries for validating Cognos Reports.
• Involved in planning, designing, building, maintaining and executing tests and test environments at each point in SDLC
• 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.
• Validating the data passed to downstream systems.
• Worked with business team to test the reports developed in Cognos
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Tested whether the reports developed in Cognos are as per company standards.
• Used HP ALM Quality Center for writing the test cases and logging the defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica, Agile, COBOL, HP ALM Quality Center, JCL, DB2, Unix, DWT, Cognos, SQL, SQL Server 2008, XML, XSLT

Confidential, Hillsboro, OR

Sr. ETL/BI 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.
• Implemented SDLC, QA methodologies and concepts in the Project
• Involved in the Agile Scrum Process
• Installed & Configured Tableau on Windows servers
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• 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.
• Managed and executed the test process, using Agile Methodology.
• Analyzed and created the bug tracking reporting and summary report in the HP ALM Quality Center
• 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.
• Planning, designing, building, maintaining and executing tests and test environments at each point in SDLC
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Defined testing criteria, planned, created and executed test plans in a mainframe environment.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Created test cases and executed test scripts using HP ALM Quality Center.
• Conducted and coordinated manual testing, integration testing and regression testing.
• Worked in an Agile technology with Scrum.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Extensively used Informatica Workflow Manager to run the workflows.
• Created Tableau extract files for improving the performance
• Prepared test data to cover all the test scenarios.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained all the test cases in HP ALM Quality Center and logged all the defects into the defects module.

Environment: Informatica, SQL, Agile, COBOL, HP ALM Quality Center, JCL, DWT, Tableau, XML, EDW, UNIX, Control-M

Confidential, PROVIDENCE, RI

ETL Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• 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.
• Performed UAT testing.
• Prepared SDLC documents
• Worked with business team to test the reports developed in Cognos TM1.
• Involved in both Agile and Waterfall development methodologies.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application and Data Management applications.
• Preparation of technical specifications and Source to Target mappings.
• Worked with business team to test the reports developed in Cognos TM1.
• Solid exposure in defect tracking system such as Jira defect tracking system defect model.
• Reviewed the test activities through daily Agile Software development stand-up meetings.
• Develop test scripts for Cognos TM1 Web applications
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Created and tracked software issues with Jira, providing detailed reports for the development team, while using developer tools and analyzing system logs
• Extensively used Informatica power center for extraction, transformation and loading process.
• Creating test cases for ETL mappings and design documents for production support.
• 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.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: Informatica Power Center, Agile, UAT, Jira, UNIX Shell Scripting, Manual Testing, SQL, Cognos Series, SQL Server, Windows.

Confidential, Philadelphia, PA

ETL QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
• Involved in executing the ETL Test Jobs from the Informatica power center workflow Manager to verify different test cases and validate the data.
• Expertise in SQL queries for cross verification of data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Dashboard reports using Cognos TM1 Report Studio and Metric Studio.
• Tested application and filed defects using Quality Centers.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Involved in testing the UI applications
• Created SQL Queries using SQL*Plus for dropping indexes prior to the load graph execution to be able to perform direct loads on the database tables.
• Implemented Informatica recommendations, methodologies and best practices
• Involved in prepare the documentation and manuals for User Acceptance testing.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica, UNIX, Cognos, Shell Scripting, XML Files, XSD, XML, Oracle 10g, Quality Center, BEA Web Logic, QTP.

Confidential

QA Manual Testing

Responsibilities:

• Involved in Data Analysis and Database Designing.
• Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.
• Used MS Visio to develop the database design.
• Extensively involved in developing Data Dictionary.
• Created tables and various database objects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
• Performed Data Profiling to improve search abilities by using tags and aliases.
• Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Involved in creation of tables, writing stored procedures and Triggers.
• Involved in testing, implementation & maintenance.

Environment: MS Visio, Crystal Reports, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT