SUMMARY:

• Over 5 years of IT experience in Manual and Automation Quality Assurance testing of Web - based and Clent-Sever application
• Good Experience of testing application in different phases of SLDC and Agile method.
• Extensive experience in testing Client -Server and Web-based applications both in Manual and Automated Testing modes and expertise in performing complete end-to-end functionality testing.
• Working experience in agile process and scrum and conducting test plan and test case walkthrough.
• Experience in Functional testing, Regression Testing, Black Box Testing, Database testing,

TECHNICAL SKILLS:

BI Tools: Business Objects BI4.0/XIR3, Crystal Reports, IBM Cognos Business Intelligence 10.2/10.x/8.x, Microstrategy 9.4/9.3/9.2/9.1

ETL Tools: Informatica 9.5/9.1/9.x (Repository Manager, Mapping Designer, Workflow Manager, and Workflow Monitor), Ab Initio CO>OP 3.x/2.15/2.14, GDE 1.15/1.14, Data Stage 8.0/8.1/8.5/8.7/9.1, SSIS.

RDBMS: Oracle 13g/12c/11g/10g/9i/8i, DB2, MS Access, MS SQL Server, Teradata 14.10/13.10Testing Tools: HP Quality Center 11.0/HP ALM, IBM Clear Quest, Test Director, Jira, Bugzilla

O/S: Windows NT/XP Prof/2003 Server/2000/98/95, UNIX, Linux

Languages: Java, PERL, Shell Scripting, VB, SQL, PL/SQL, HTML, DHTML, XML, XSLT, XSD

Others: TOAD, WinSQL, SQL Assts, MS Office, PVCS, Autosys, Control-M, Aqua Data studio, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

ETL/ BI Tester

Responsibilities:

• Analyzed business requirements document to better understand the process and also referred SRS, source to target mapping document and technical design document.
• Involved in developing test cases and uploaded the same in Quality Center for Functional and Regression Testing.
• Participated in Design review meetings to understand the Data model and implementation process.
• Developed separate test cases for Integration testing and Performance testing.
• Interacted with other team members and other test teams to coordinate and complete integration testing/end to end testing.
• Developed SQL test scripts to validate the end to end process and executed test cases.
• Participated in preparing the test environment for Staging area, loading the Staging area with data from multiple sources. Also validated from source to staging.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations and various containers to do the looping operations
• Tested data loaded using Ab Initio graphs. Performed black box testing.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD for oracle.
• Worked closely with developers and Business Analyst to ensure that an acceptance criterion is complete and accurate.
• Deployed, Tested and Scheduled SSIS packages using SQL Agent.
• Involved in preparing different data scenarios for testing ETL.
• Coordinated with reference data team to get test data created for all the scenarios developed.
• Written several complex SQL queries for validating Cognos Reports on Data mart and BO reports on EDW.
• 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.
• Actively involved in the defect review meeting in which the defects identified were discussed.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Coordinate very closely with the developers regarding functionalities and defects.
• Performed extensive Back-End testing by writing and executing SQL queries on the database.

Environment: Oracle13g, Toad for Oracle, DB2, Aqua Data Studio, Ab Initio CO>OP 2.14/2.15, GDE 1.14/1.15 Quality Center, SQL, Cognos, BO BI4.0, TOAD, Windows XP/2003, HP ALM, IBM Clear Quest, SharePoint

Confidential, Texas

ETL/ BI EDW QA Test Analyst

Responsibilities:

• Review and provide input on all project level documentation.
• Review the Business requirements and analyze the data in EDW.
• Assist in developing detailed testing estimates and timelines
• Create test plans and test cases as they relate to testing project requirements to ensure the overall quality of software delivered.
• Create requirement/test case relationship using Quality Center (traceability).
• Contribute to and assist in implementing improvements in test methods and strategies.
• Test execution and defect identification.
• Execute manual and automated test cases /scripts.
• Log, track, and validate resolution of identified defects. Escalate quality concerns to management.
• Conduct test strategy reviews with the Data Architect, and development team.
• Follow configuration and change management processes.
• Diagnose, document, and troubleshoot systems to resolve problems uncovered by testing.
• Be proactive in taking the appropriate actions to mitigate any risks that may arise.
• End-to-end functional tests for validating that the functionality has been successfully integrated.
• Assess system impact and priority of problems encountered.
• Identify and track defects, issues, risks, and action items.
• Write Test Cases for ETL to compare Source and Target database systems.
• Used Teradata SQL assistant to query the EDW to do the data Validations.
• Used Quality Center for Test management and defect Management.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Executed jobs in Informatica Workflow Monitor and debugged failures.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extensively written test scripts for back-end validations
• Tested Drill down and Alerts in Business Intelligence reports using Web Intelligence.
• Identify the primary key (logical / physical ) and tested update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards
• Preventing occurrences of multiple runs by flagging processed dates
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Worked on issues with migration from development to testing.
• Validated UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested ad hoc and canned reports for Business objects.
• Suggest ways to mitigate risk when issues are encountered and identify contingency plans.
• Involved in daily triage meetings for defect tracking.

Environment: Oracle 12c/11g, Toad for Oracle 11g, SSMS, UNIX Shell Scripting, Teradata 13.10, Teradata SQL Assistant, Business Objects XI R3 & BI 4.0, Informatica, Quality Center 11.0.

Confidential

BI Test Analyst

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Test Director
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Expertise in code reviews. Expertise in security issues of client/server technologies.
• Designed the screens and layout using Visual Basic 6.0.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Design and develop a custom database (Tables, Views, Functions, Procedures, Packages)
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: Oracle, SQL*Plus, SQL, Test Director, SQL Server 2000, Visual Basic 6.0, Java and UNIX Shell scripting