SUMMARY

• 10+ years of rich experience in Software Testing & Quality Assurance in ETL Testing (Informatica, Ab Initio, Data stage)
• 5+ years of experience in Hadoop HIVE testing
• Involved in Hydra, Vertica, Curl Command Validations
• Experience on TOSQA Automation tool
• Implemented few Automation scripts using Python and Shell script
• ISTQB / International Software Testing Qualifications Board (Foundation level) Certified tester
• Expertise in ETL and BI testing in STLC (Software Testing Life Cycle)
• Expertise in Agile methodology
• Most of experience On banking domain ( Confidential )
• Solely responsible for creating Automation framework for Regression testing, Functional and E2E Testing
• Responsible for creating User Stories required for all Tasks
• Expertise in Report Testing in SAP Business Objects, Web focus Report Testing
• Comprehensive experience in designing test approach for Requirement analysis, Estimation, Test Planning, Scripting, Reporting, Test environment setup, Execution
• Analyze teh requirements and define teh Test cases for Regression Testing
• Expertise in Defect Tracking using Defect tracker (HPQC/Rally) and track teh same till closure
• Adept at setting achievable goals / targets for teh testing teams
• Hands on in automation tools like Platinum and Idata QA
• Good knowledge on UNIX commands
• Experience on Big data Testing (Hive Testing)
• Expertise in complete E2E Testing
• Web Services Testing Like SFDC
• Database Skills on SQL Server 2008
• Root Cause Analysis in case of failure

TECHNICAL SKILLS

Databases: Oracle 10g, SQL Server 2008, Teradata, SQL Developer, DB2

Languages: SQL, UNIX, Shell Scripting

ETL Tool: SQL Server SSIS, ODI

BI Tool: Informatica, AbInitio, Data Stage, Microsoft Business Intelligence, BO 5.x/6.x

Hadoop/Big Data Skills: MapReduce, HIVE, Cassandra, Spark

Defect Tracking Tools: HP Quality Centre, BUG DB, JIRA

Report Testing: BO Reports & Web focus Report

Automation Tool: TOSQA

PROFESSIONAL EXPERIENCE

Confidential

Team Leader

Responsibilities:

• Working as Team leader at ONSITE at client location in US wif 4 team members.
• Working on Data stage (ETL Tool) Testing & Big data testing.
• Self - Debugging teh code and analysis from Designer.
• Finding teh root cause from code failures and provide root cause to DEV team.
• Developed Automation process for an E2E testing.
• Involved in complete E2E Testing process for plenty of requirement initiatives.
• Web focus report testing as well related to bug fixes and enhancements in UI
• Preparing teh test cases, executing test cases and logging defects in Rally.
• Client interaction for requirement gathering / clarification and issue escalation.
• Attend Sprint Planning meeting wif teh Developers, BSA's and scrum master to understand scope of teh user stories and to mitigate teh risks involved in completing teh tasks.
• Preparing and executing sql queries to verify data in db against teh report.
• Verifying teh data in target database after ETL process.
• Understanding Requirement Specifications and Design Documents.
• Ran ETL batches/Jobs to load teh respective tables.
• Developed, Reviewed & Executed Test Scripts and Designed test data.
• Understand teh detailed design, requirement, Source to Target mapping document.
• Involved in Functional Testing, Integration Testing and E2E Testing for Data(DB) /DW ETL Testing.
• Identified Test Scripts for Regression testing.
• Prepared daily status reports wif details of executed, passed, and failed test cases and defect status and share teh same wif Manager.
• Ensure Team members ability to operate under deadlines and to work on multiple tasks.
• Conduct Knowledge transfer sessions for new joiners and knowledge sharing wifin teh team.
• Monitor and reviewed teh work done by teh team to ensure client satisfaction.
• Responsible for End to End System Testing.

Confidential

Team Leader

Responsibilities & Achievements:

• Work related to bug fixes and enhancements in UI.
• Documentation for Web Services.
• Involved in teh preparation of understanding document and Knowledge sharing documents to Onsite team.
• Involved in BI Testing to verify teh Graphs and data populated are WRT teh required data.
• Responsible for Test Plan, Test Case preparation and Test Execution, Defect Analysis, Defect Tracking.
• Responsible for teh quality and on-time delivery of teh project under supervision.
• Coordinate between Functional team, Development team in Testing phase.
• Involved in publishing Daily and Weekly Status report for teh project.
• Responsible for Project Execution and Team Management.
• Supervising in all phases of testing from design stage to smooth rollout of teh release.
• Client interaction for requirement gathering / clarification and issue escalation.
• Attend Sprint Planning meeting wif teh Developers, BSA's and scrum master to understand scope of teh user stories and to mitigate teh risks involved in completing teh tasks.
• Understand teh detailed design, requirement, Source to Target mapping document.
• Involved in Functional Testing, Unit Testing for Data (DB) /DW ETL Testing.
• Involved in preparation and execution of test cases.
• Developed test scenarios and scripts based on business and functional requirements.
• Worked in new applications Soap UI and Adobe campaign.
• Involved in Data validations for getting teh data from all systems to Database.
• UAT Support.

Confidential

Responsibilities & Achievements:

• Independently executed teh Project.
• Reviewed teh FSD, BDD and TDD documents and raised concerns and Bug against teh document whenever necessary.
• Prepared Test Scenarios, Test cases, Test Execution report, Metrics Validations.
• Hive and Oracle DB validations
• Involved in teh preparation of understanding document and Knowledge sharing documents to Onsite team.
• Client interaction for requirement gathering / clarification and issue escalation
• Attend Sprint Planning meeting wif teh Developers, BSA's and scrum master to understand scope of teh user stories and to mitigate teh risks involved in completing teh tasks
• Understand teh detailed design, requirement, Source to Target mapping document
• Involved in preparation and execution of test cases
• Involved in UNIX multi file system scripting
• Involved in Agile methodology and SPRINT Iteration model data validations
• Involved in Data validations for getting teh data from all systems to Database.
• Track teh progress of teh user stories wif teh help of Burn down charts and v1 agile project management tool.
• Writing teh Test Cases, Provided Testing Estimates
• Developed test scenarios and scripts based on business and functional requirements
• Involved in Hadoop, Functional Testing, Unit Testing for Data(DB)
• Request for Sign off approval mail from Risk owner and Product owner
• Attend sprint retrospective meeting, to learn about best practices

Confidential

Associate Hadoop Tester

Responsibilities:

• Independently executed teh Project.
• Reviewed teh FSD, BDD and TDD documents.
• Involved in Test case preparation and getting it reviewed by Development team.
• End to End testing of teh project including teh BI and Metric validations.
• Hive and Vertica DB validations
• Service Layer (Curl commands) Validations
• Hydra (Web UI) validations
• Involved in Production run validations
• Involved in teh preparation of understanding document and Knowledge sharing documents to Onsite team.
• Client interaction for requirement gathering / clarification and issue escalation
• Attend Sprint Planning meeting wif teh Developers, BSA's and scrum master to understand scope of teh user stories and to mitigate teh risks involved in completing teh tasks
• Understand teh detailed design, requirement, Source to Target mapping document
• Involved in preparation and execution of test cases
• Involved in UNIX multi file system scripting
• Involved in Agile methodology and SPRINT Iteration model data validations
• Involved in Data validations for getting teh data from all systems to Database.
• Track teh progress of teh user stories wif teh help of Burn down charts and v1 agile project management tool.
• Writing teh Test Cases, Provided Testing Estimates
• Developed test scenarios and scripts on teh basis of business and functional requirements
• Involved in Hadoop, Functional Testing, Unit Testing for Data(DB)
• Request for Sign off approval mail from Risk owner and Product owner
• Attend sprint retrospective meeting, to learn about best practices

Confidential

Team Leader

Responsibilities:

• Involved in Agile methodology and SPRINT Iteration model data validations
• Attend Sprint Planning meeting wif teh Developers, BSA's and scrum master to understand scope of teh user stories and to mitigate teh risks involved in completing teh tasks
• Preparation of SQL queries for looks up and derived fields using mapping documents provided and validate teh same in Teradata.
• Run teh Abinitio Graph using multifile commands in UNIX.
• Loading teh Source files into staging area and creating teh Load ready files using multifile commands and loading teh Load Ready files to Target/Teradata tables by running teh graphs in UNIX.
• Loading teh Source files into staging area and generating teh Clean files their after loading teh Clean files into Target/Teradata tables by running teh Scripts in Unix
• Validate teh Load Ready files in distribution area against target table(Teradata)
• Preparation of SQL queries for looks up and derived fields using mapping documents provided.
• Request for Sign off approval mail from Risk owner and Product owner
• Attend sprint retrospective meeting, to learn about best practices

Confidential

Responsibilities:

• Involved in teh preparation of understanding document and Knowledge sharing documents to Onsite team
• Writing teh Test Cases, Provided Testing Estimates and execution of test cases
• Validate teh Data load from Source to Target for all teh mapping and functionalities.
• Proficient in mapping client’s requirements using Requirement Traceability Matrix
• Report Validation for given functional scenarios.
• Client interaction for requirement gathering / clarification and issue escalation.
• Involved in teh analyzing of teh workflows and mapping .
• Involved in SFDC validations.
• Worked in new applications SAP/SFDC.
• Involved in Agile methodology and SPRINT Iteration model data validations
• Involved in Data validations for getting teh data from all systems to Database.
• Developed test scenarios and scripts on teh basis of business and functional requirements.
• Involved in Functional Testing, Unit Testing for Data(DB) /DW ETL Testing.
• Regression Testing.

Confidential

Project Specific Skills

Responsibilities:

• Preparing and executing SQL queries to verify data.
• Verifying teh data in target database after ETL process.
• Verifying teh data, which is loaded into target database.
• Involved in teh preparation of Detail documents.
• Testing Estimates.
• Client interaction for requirement gathering / clarification and issue escalation.
• Developed test scenarios and scripts on teh basis of business and functional requirements.
• Functional Testing, DW ETL Testing.
• Involved in Feature and System testing.
• UAT Support.
• Validate if all teh relevant user accessible data is moved to Teradata.
• Logging teh defect and Test Execution results in HP QC and track teh same till teh defects closed.
• Gathering and managing teh Test Data concerning System Test, DW Optimization Validation and System Integration Test.
• Analyze and understand Source to Target Mapping and Source system data model to perform Source system application testing.
• Done Unit Testing and teh preparation of teh unit test cases.