EXPERIENCE SUMMARY:

• Having Six years and Six months of experience in Software Testing which includes Database, ETL, Data warehouse, Business Intelligence and Big Data Testing.
• Expertise lies in Functional Testing, Manual Testing, Regression testing, System Integration testing, User Acceptance testing, Black Box testing and Performance testing.
• Comprehensive knowledge in developing Test plans, Test cases, Test Scripts, Test Results, Test closure summaries and Defect Reports using HP Quality centre and Rally tools.
• Good experience working on Project Proposals, Customer Presentations, Effort estimation, Resource Loading
• Having extensive experience in ETL Testing tools like Informatica.
• Having extensive experience in testing Business Intelligence Applications like OBIEE.
• Strong Knowledge on SQL Queries and PLSQL on various databases like DB2, Oracle, Teradata.
• Having knowledge and hands on experience on Big Data technologies like HDFS, HIVE, Green Plum and Bedrock.
• Strong Business Knowledge in Health Care and Pharmacy Domains.
• Having good knowledge in different models like Agile, Waterfall model, V - model.
• Expertise in Data Warehouse, ETL Verification and BI reports testing.
• Experience in Database Performance tuning and Optimization.
• Having good knowledge on working with automation frameworks used in regression testing and data validation of files in Unix Environment.
• Expertise in working with stake holders and product owners on requirement clarifications, reviewing test plans, test results, PI/Sprint planning and grooming sessions, defect reports and sprint demos.
• Performed Capacity planning for several projects within same application.
• Identifying test data gaps in data from source and coordinating with source team on test data requirements.
• Having knowledge and hands on experience on Mainframes files.
• Well acquainted with Onsite/Offshore model working as QA lead.
• Versatile team player with excellent communication and presentation skills.
• Ability to quickly Grasp and Deploy the Technologies and Environment.

TECHNICAL SKILLS:

Operating System: Windows 2003/XP, UNIX

Testing Tools: HP ALM(Quality Center), Rally.

Data Base: Teradata 13.0,Oracle 10g, DB2, Hadoop.

Other Client Tools: Sagent Information Studio, Informatica, SAS, OBIEE 11g, DataStage, Teradata SQL Assistant, SQL Developer, Toad for Oracle and DB2

Languages: SQL, PLSQL

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Teradata, UNIX.

Tools: Used: Rally, Teradata SQL Assistant, HP ALM, Informatica 9.1, OBIEE 11g, DataStage

QA Lead

Responsibilities:

• Analyze the requirements and identifying test scope and test scenarios.
• Coordinate with offshore team and assign the work.
• Execute test cases for data validation in BI reporting
• Execute test cases for data validation during ETL Loads with Informatica
• Meeting with different stakeholders on requirements clarifications, results walkthroughs.
• Attend PI planning meetings and perform capacity planning to plan the work for each PI and resources for all domains Member, Provider and Claims domains.
• Representing QA in Sprint Planning and grooming sessions to plan tasks and adding new User Stories in Rally
• Preparation of Master Test Plan and coordinate with stakeholders to get approval
• Review of Test deliverables completed during sprint demos with cross teams and product owners at the end of each sprint.
• Coordinate with development team for troubleshooting the issues and planning QA work for each PI.
• Coordinate with source team on test data requirements.
• Preparation of Test Closure Summary after QA sign-off for each phase
• Maintaining complete project documentation according to QAA guidelines for all phases.

Confidential

Environment: Unix, Teradata.

Tools: Used: HP ALM, Putty, Teradata SQL Assistant, Data Virtualization tool, SAS, OBIEE 11g

QA Lead

Responsibilities:

• Analyze the requirements with users and identify/define test scope and test scenarios.
• Preparation of Master Test Plan and coordinate with stakeholders to get approval
• Coordinate with Users to identify queries and filter conditions.
• Review the performance metrics with users on weekly basis.
• Consolidate the performance metrics from offshore and onsite.
• Coordinate with development team for troubleshooting the issues
• Write SQL Queries to validate data in Teradata and DV Layers
• Execute test cases and validate data showing up in the reporting tools like OBIEE
• Preparation of Test Closure Summary after QA sign-off for each phase
• Maintaining complete project documentation according to QAA guidelines for all phases.

Confidential

Environment: Unix, HDFS.

File Formats: Delimited (Pipe, Hexadecimal, Comma), AVRO, CSV, XML, Fixed width

Tools: Used: HP ALM, Putty, Global Ids, Rally

QA Tester

Responsibilities:

• Analyze the requirements and identifying test scope and test scenarios.
• Preparation of Master Test Plan and coordinate with stakeholders to get approval
• Coordinate with source systems (> 40 sources) to identify test data.
• Representing QA in Sprint Planning session to plan tasks and adding new User Stories in Rally
• Preparation of test cases, execution of test cases and reporting defects in ALM
• Review of test deliverables completed and presenting results demo to the Product Owner while Sprint Review session at end of each Sprint
• Coordinate with development team for troubleshooting the issues
• Preparation of Test Closure Summary after QA sign-off for each phase
• Maintaining complete project documentation according to QAA guidelines for all phases

Confidential

Environment: Mainframes, DB2 Database

File Formats: .DAT, Delimited, Fixed width

Tools: Used: IBM Personal Communications, Toad for DB2, HPALM, Informatica 9.x

QA Tester

Responsibilities:

• Requirements analysis and test scenarios identification
• Preparation of Master Test Plan and coordinate with stakeholders to get approval
• Preparation of test cases(TPS), review of TPS with project team and Business team and coordinate for approvals.
• Write SQL Queries to validate data in different downstream applications
• Monitor and Execute Jobs using Informatica workflow Monitor and Manager tools
• Verify the Informatica Log for Job Abends and work with development team to resolve the data load Issues.
• Execution of test cases and defect reporting in HP Quality Center
• Review test cases and test results of other team members.
• Coordinate with Cross App teams and upstream sources to ensure test data meets all the system requirements.
• Preparation of Test Closure Summary after QA sign-off on System Testing and coordinate for approvals.
• Maintaining complete project documentation on share points complying to QAA guidelines.
• Maintain Six point communication during project execution phase
• Perform production check out while code deployment.

Confidential

Environment: UNIX

Database: DB2 Database, Oracle 10g Database, Informatica

File Formats: .DAT, Delimited, Fixed width

Tools: Used: Putty, UltraEdit,Toad for DB2, HPALM

QA Tester

Responsibilities:

• Requirements analysis and test scenarios identification
• Execution of test cases for data validation of ETL batch loads
• Preparation of Master Test Plan and coordinate with stakeholders to get approval
• Preparation of test cases(TPS), review of TPS with project team and Business team and coordinate for approvals.
• Execution of test cases and defect reporting in HP Quality Center
• Preparation of Test Closure Summary after QA sign-off on System Testing and coordinate for approvals.
• Maintaining complete project documentation on share points complying to QAA guidelines.
• Maintain Six point communication during project execution phase
• Perform production check out while code deployment
• Validate the requirements in Sagent Information Studio.

Confidential

Environment: Unix

Database: Oracle 10g

Tools: Used: HP Quality Center, Toad, Informatica

QA Tester

Responsibilities:

• Analyzing the Business Requirements and Functional requirements in the New CR’s received.
• Preparing test case scenarios based on the requirements received.
• Designing the Test cases and sending them for client approval.
• Executing Test cases manually to test application functionality against user requirements.
• Execution of test cases to validate data loaded by ETL process
• Involved in database testing.
• Involved in ETL transformation logic testing and count verification at source and target sides.
• Participated in document reviews.
• Involved in System, Functional & Regression testing.
• Involved in Defect Tracking and Reporting of Bugs.
• Identified bugs and interacted with developers to resolve technical issues.
• Involved in Project meetings.
• Involved in Preparation of Test summary Report.