SUMMARY

• Around 3 years of experience in Quality Assurance with ETL flows, Business Intelligence Reports, Web based, Client/Server applications using Manual and Automated testing tools.
• Experience in all phases of the Software Testing Life Cycle (STLC) and good exposure to Software Development Life Cycle (SDLC).
• Experienced in different SDLC methodologies such as waterfall model and agile model.
• Experience in Analyzing Business Requirements (BRD), High Level Design Document (HLD) and Use Cases for drafting Test scenarios/Cases and Test Scripts.
• Experienced in Inspections/Reviews, Test Execution, Test Data Preparation, Test Environment set - up and Metrics Collection.
• Experience in creating the Traceability matrix linking test scripts with requirements for complete Requirement Traceability.
• Extensive working experience on Functionality Testing, GUI Testing, Integration Testing, Regression Testing, Performance Testing and System Testing using Business Requirements, System Requirements and Use Case documents.
• Strong working testing experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica, Data Stage, Ab initio.
• Expertise in testing complex Business rules created by mapping and various transformations using Informatica and other ETL tools.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Db2, Teradata 15.10, MS Access, Flat Files and XML files and VSAM files
• Experienced in test data preparation for positive and negative testing scenarios
• Proficient with SQL, Unix Shell, Perl, and Java
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Experience in testing Data Marts, Data Warehousing/ETL Applications developed in Informatica and Data stage using Oracle.
• Proficient in Defect Management using Quality Center, Bugzilla and JIRA.
• Ability to develop complex SQL script for Data validation testing.
• Experience in preparation and execution of Regression Suite.
• Used Test Management tools like Rational Test Manager and Mercury Quality Center (Test Director).
• Interacted with developers and business users for efficient testing process.
• Able to work under tight deadlines and capable to effectively handle multiple ongoing projects.
• Willingness and ability to quickly adapt and learn new technologies.
• Possess Excellent Communication, interpersonal, problem solving and transferable skills.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows, UNIX, LINUX

Testing Tools: HP Quality Center 11.0 and 12.21

Languages: Java, C, C++, SQL, PL/SQL, SAS

MS Office: MS Office Suite, MS Project.

Web Technologies: XML, XSL, XHTML, HTML, CSS.

Databases: DB2, MS SQL Server, Oracle, SQL Developer.

Reporting Tools: Cognos, MicroStrategy

Defect Tracking Tool: HP Quality Center 11.0 and 12.21, Bugzilla.

ETL Tool: Informatica 9.6.1 and 10.2, Data stage, Ab Initio.

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester.

Tools: TOAD for Oracle 11, Teradata 15.10 SQL Enterprise Manager, Win SQL.

PROFESSIONAL EXPERIENCE

Confidential, Strongsville, OH

ETL BI Tester

Responsibilities:

• Created test cases to cover all the requirements
• Responsible in providing test reports to the QA lead
• Performed manual testing, functional testing and usability testing
• Responsible for Smoke Testing for the Build on Daily basis.
• Participated in the Requirement understanding discussion with Business and IT teams.
• Tested theETLInformatica mappings and otherETLProcesses (Data WarehouseTesting).
• Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts.
• Performed Database testing using SQL Server and Teradata 15.10.
• Prepared high level System Test Scenarios and Test Conditions for various functional segments.
• Worked on the Test schedules, Test estimates for the Test Script development and execution.
• Tested cognos reports for verifying and validating the data.
• Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.
• Developed test scripts using QTP for Functionality and Regression Testing.
• Manually performed Smoke testing for basic functionality checking as Entry criteria for the System Testing.
• Worked on User Acceptance Testing (UAT), System testing, Integration testing, Regression Testing, Black Box Testing and Backend or Database Testing.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Tested SQL queries to validate the data and performance of the database
• Wrote complex SQL queries between source and target for validating ETL jobs.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.
• Working with different customers and work with center of excellence groups in taking key decisions.
• Written several complex SQL queries during the tesing phase.
• Involved in extensive data validation using SQL queries and back-end testing.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Provided the UAT and Production support for End to End Test Script execution and Defect retest.
• Good experience in onsite model work. Schedule and Co-ordinate testing tasks in QC.
• Organize defect triage calls Development and Business team to resolve outstanding issues.
• Worked on Informatica Workflow monitor to run workflows.
• Involved in writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box Testing.
• Gathering detailed business requirements and Technical requirements.
• Analyzing and solving problems for change requests/ Enhancements.
• Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports.
• Developed test cases to accomplish ETL data migration.
• Designed the data for interpreting the positive/negative Scenarios.

Environment: SQL, PL/SQL, Informatica Power Center 9.6.1 and 10.2, Agile, SQL Server, Cognos, Quality Center 11/HP-ALM 11.0 and 12.21, Teradata 15.10, QTP, UNIX.

Confidential

QA Analyst/ETL tester

Responsibilities:

• Functional and Technical understanding of the Claims domain data to validate the data obtained from the Healthcare insurance members.
• Validated variousMicroStrategy reports such as ad hoc, grids, graphs.
• Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts
• Performed the access check for all the databases, tools, servers and interfaces as Entry criteria for the System Testing.
• UsedMicroStrategyWeb to offer interactive reporting to the end users
• Wrote complex SQL queries between source and target for validating ETL jobs.
• Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables
• Used Clear Quest to track and report system defects and bug fixes.
• Written modification requests for the bugs in the application and helped developers to track and resolve the problems
• Created test plans and performed unit testing for the Informatica mappings
• Involved in extensive data validation using SQL queries and back-end testing.
• Tested Business Object Reports for promps as well as for Data validation.
• Involved in testing all the reports that were generated through MicroStrategy.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Provided the UAT and Production support for End to End Test Script execution and Defect retest.
• Did testing on multiple Informatica mapping for data validation and data conditioning.
• Good experience in onsite model work. Schedule and Co-ordinate testing tasks in Quality Center.
• Created and executed SQL queries in ORACLE and MS SQL server
• Organize defect triage calls Development and Business team to resolve outstanding issues.
• Responsible for creating the Traceability matrix and linking test scripts with requirements.
• Responsible for sending Daily status Reports for SIT Execution to the team.
• Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports.

Environment: Informatica Power Center, SAS, SQL, Oracle, SQL Server, MicroStrategy, SQL, PL/SQL, Java, UNIX, QTP, HP Quality Center, Waterfall, MS Access.