SUMMARY:

• Total 8.4 years of experience in IT industry, involved in Software Development and Testing.
• Primarily working in DWBI testing projects where involved in ETL mapping design, ETL testing, Report testing, MDM Testing and Database Testing.
• Well Experienced in working in Maintenance & Development projects.
• Performed activities of STLC related to data warehouses projects like Planning, Designing, Execution of Test Scripts & Jobs and managing the defect cycle and defect tracking.
• Gained experience in functional testing methodologies that include Functional Testing, Systems Integration Testing, User Acceptance Testing, various SCD logic scenarios and Regression testing also.
• Has good knowledge in databases like Oracle, Netezza, Teradata, SQL server 2016 and efficient in Database programming languages like SQL which are required as a part of ETL and BI testing activities.

TECHNICAL SKILLS:

Operating Systems: Windows and UNIX

Databases & ETL Tools: Oracle, SQL server 2016, Neteeza, Teradata, DB2

Reporting Tools: Cognos

ETL Tools: Datastage, Informatica, SSIS

Defect Management Tool: JIRA, QC, HP - ALM

Scheduling tool: UC4

MDM & other tools: TIBCO MDM, Informatica MDM, Postman, NIFI, Python

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Understanding of feature documen, buniess requirements and work flow of the project
• Test design activity - test plan, test scenario and test case preparation
• Sql scripts preparation as per scenarios
• Critical business logics validation in several DW layers
• Testing in AWS platform, using AWS components like: crawler, redshift, Dynamo DB etc
• Defect raising and defect management in JIRA
• Involved in daily scrum call discussion
• Providing demo about test document in client meeting
• Ability to handle multiple tasks and work independently as well as in a team.
• Co- Ordination with Onsite counterpart providing new team members with KT and managing task for the team
• Good interpersonal skills, communication skills, commitment, coordination with different team, result-oriented, hardworking with a quest and zeal to learn new technologies and undertaking challenging tasks.

Confidential

Responsibilities:

• Understanding of Business requirement and the data flow of the project
• Test design activity - test plan, test scenario and test case preparation
• Data Mock up and data load activity
• Sql scripts preparation as per scenarios
• Critical business logics validation in several DW layers
• Store procedure, Function writting and execution as part of testing
• Performed Test execution as per sprint and maintaining in JIRA
• Defect raising and defect management in JIRA
• Involved in daily scrum call discussion
• Co- Ordination with Onsite counterpart providing new team members with KT and managing task for the team

Confidential

Responsibilities:

• Understanding of Business requirement and the data flow of the project
• Test design activity - test plan, test scenario and test case preparation
• Data Mock up and data load activity
• Sql scripts preparation as per scenarios
• Critical business logics validation in several DW layers
• Performed Test execution as per sprint and maintaining in HP ALM
• Defect raising and defect management in JIRA
• Involved in daily scrum call discusssion
• Co- Ordination with Onsite counterpart providing new team members with KT and managing task for the team

Confidential

Responsibilities:

• Understanding of Business requirement and the data flow of the project
• Responsible for test scenario & test case design, test script preparation
• Involved in Data load and test data mock up activities
• Performed Test execution as per sprint and logged observation in JIRA
• Validated critical business logics in several DW layers and involved API service testing using Postman
• Performed Agile testing, Smoke Testing, System testing, Delta, Regression and delivered quality deliverables on time.
• Defect raising and defect management in JIRA
• Involved in daily basis scrum call and participated in the discussion
• Co- Ordination with Onsite counterpart providing new team members with KT and managing task for the team.

Confidential

Responsibilities:

• Understanding of Requirement and Typical data flow of this project within stipulated delivery period.
• Test Case Design as per the Informatica Mapping used for each of the sub modules of source systems
• Required complex SQL queries for validation from Landing to ODS layer and ODS to DW.
• Count Check and field level check was performed.
• Initial data load and Delta data load validation was performed
• Informatica mapping contained complex variables which were scripted through SQL
• Ran the respective jobs in Informatica Cloud Service
• Defect raising and defect management in HP-ALM
• Co- Ordination with Onsite counterpart providing new team members with KT and managing task for the team.

Confidential

Responsibilities:

• Preparation of Test case design and execution
• Test script generation and validated the business logic as per mapping
• Performed data count and data migration check between the intermediate source and target layers
• Match Rule Validation, Survivorship rule check in MDM Hub.
• Performed service testing through SOAP UI (Add Party/Get Party/Update Party)
• Attended Defect Triage Calls

Confidential

Responsibilities:

• Understanding of Requirement and Typical data flow of this project within stipulated delivery period.
• Participated in test design i.e. writing Test Cases, reviewing the test cases by understanding requirements, design and mapping document.
• Preparation of Test Logs by executing test cases, using Platinum tool and Oracle & Netezza databases.
• Upload and Executing test cases, Test Requirements in SharePath and QC.
• Introduction of Following tracker in team to track project delivery-
• Test Execution Tracker, Defect Tracker
• Test Execution for various DW layers (Stage to PostStg, PostStg to MDM)
• Execution of test cases and data comparison of extracts using Platinum tool, reports and views.
• Performed Smoke Testing, System testing, Regression and delivered quality deliverables on time.
• Defect raising and defect management in QC and JIRA
• Co- Ordination with Development team, providing new team members with KT and managing task for the team.

Confidential

Responsibilities:

• Understanding of Requirement and Typical data flow of this project within stipulated delivery period.
• Participated in test design i.e. writing Test Cases, reviewing the test cases by understanding requirements, design and mapping document.
• Preparation of Test Logs by executing test cases
• Upload and Executing test cases, Test Requirements in SharePath.
• Introduction of Following tracker in team to track project delivery-
• Test Execution Tracker, Defect Tracker
• Test Execution for database tables from OLD MDS to NEW MDS
• JSON file Validation with NEW MDS against SQL Server Database
• Performed System testing, Regression and delivered quality deliverables on time.
• Performed QTC validation and as well as OLO Website testing
• Performed Report Testing and validated the report data with Teradata server data
• Defect raising and defect management in the test track.
• Co- Ordination with Onsite, Development team, providing new team members with KT and managing task for the team.
• Working as a single offshore team member

Confidential

Responsibilities:

• Integrated, Reliable, Single version of truth, consistent and accessible Information
• Accurate information at the time of need to enable efficient decision making
• Foundation for an enterprise wide data management strategy including data governance
• Improve trust in information by defining a solution centered around data management, data governance and data quality
• Business units in EZ CORP will spend less time to create manual reports. It will focus on less manual reporting, so less support need for EDW
• Less Total Cost of Information Ownership
• Enhanced operational efficiency to reduce operational cost
• Build a stable, scalable and flexible delivery platform leveraging the best of breed technology stack having the ability to onboard any new source system as needed by EZ CORP.
• Understanding of Requirement and Typical data flow of this project within stipulated delivery period.
• Participated in test design i.e. writing Test Cases, reviewing the test cases by understanding requirements, design and mapping document.
• Preparation of Test Logs by executing test cases, using Data Stage job to load the data in required tables and introduced UC4 job scheduler for data loading accordingly.
• Upload and Executing test cases, Test Requirements in SharePath.
• Introduction of Following tracker in team to track project delivery-
• Test Execution Tracker, Defect Tracker
• Test Execution for various DW layers (Stage to Base, Base to Dim)
• Execution of test cases and data comparison of extracts using Platinum tool, reports and views.
• Taking Dumps for report testing from SQL Server and the validated the report data with the Dumps taken.
• Validations of Layouts and Cognos Reports.
• Validations data displayed by the Reports and underlying views of the reports.
• Performed Smoke Testing, System testing, Regression and delivered quality deliverables on time.
• Defect raising and defect management in JIRA.
• Co- Ordination with Onsite, Development team, providing new team members with KT and managing task for the team.
• Performed MDM testing using TIBCO MDM tool.
• Attended for TIBCO MDM and incorporated the features in MDM testing.
• Thorough analysis and testing of functionalities in Informatica workflows.
• Performing Data Analysis on the source system tables, identify the granularity and relationships
• Validate the data; identify the domain list and anomalies.
• Identify the list of data elements that would be needed to satisfy the requirements.
• Document all data profiling artifacts from data discovery to the delivery phase.
• Provided recommendations regarding enhancements and/or improvements regarding data profiling procedures within the enterprise master data, operational data stores, data warehouse and data marts.
• Analyze and identify the data pattern, relations, rules
• Analyze the data quality, data consistency, redundancy and Uniqueness