SUMMARY

• 11+ years of Software Quality Assurance experience withtesting of ETL/Data Warehouse, BI (Business Intelligence)reports, Azure Cloud, Database, Data Analyst, MDM, Reltio, Web and Client - Server Systems and Applications for banking, healthcare and insurance industries
• Extensive experience in Banking, Insurance, Healthcare and Telecom domains.
• Collaborate across teams to ensure test environment readiness, provide direction and guidance for testing teams with Test Plans, test cases, verifications and validations.
• Bug reporting, tracking, analysis, documentation of Test plans and Test Strategy
• Experienced in Agile and Waterfall methodology of software development
• Skilled in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution usingInformatica & SQL Server Integration Services ETL tools.
• Expertise in Testing BI applications using Qlikview, OBIEE, MSBI and Tableau.
• Solid experience in coding complex SQL,Oraclequeries and report (BI) testing.
• Extensive ETL testing working experience using Informatica Power Center (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server)
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification andidentifying Data mismatch.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing
• Proven success in handling requirements gathering sessions, understanding the Business requirements, product demonstrations with Clients.
• Experience in Software Testing Life Cycle (STLC) (designing, debugging, testing, documentation, maintenance, and enhancement).
• Involved in data migration projects from SSIS to cloud, Informatica lower to higher versions and Teradata to SQL Server
• Outstanding experience in analysis of business, technical, and functional requirementsand developed, executed & tested the test plans, test cases and test strategies.
• Worked in Offshore / Onsite model managing offshore resources
• Extensively usedAzure, Jira, HP Quality Centerand MTM for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Experienced in Java script to offer responsive website layouts
• Part of RFP (Request For Proposal) meetings with different clients related to banking and insurance domains
• A self-motivated, responsible, and reliable team player with a set of strong technical skills.

TECHNICAL SKILLS:

• #Agile
• #Azure
• #Cloud
• #ETL
• # ETL Testing
• #Database Testing
• #Big Data Testing
• #Datawarehouse #SQL Server
• #Informatica
• #SSRS
• #SSIS
• #MSBI
• #Reltio
• #MDM
• #OBIEE
• #EDM
• #BI
• #Angular Dashboards #Qlikview #Oracle
• #Data Analyst
• #Teradata
• #SSRS
• #Azure
• #BigData
• #Tableau
• # Java Script #Jira
• #HP QA
• #MTM
• #Defect Tracking
• #SDLC
• #STLC
• #Test Plan
• #Test Strategy
• #Test cases
• #Complex SQL Queries
• #Defect Tracking
• #API Testing

PROFESSIONAL EXPERIENCE

Confidential

ETL-BI Tester /Agile Test Lead/ Data Analyst

Responsibilities:

• Manage a team of testers to lead the testing efforts of multiple projects that meet user requirements and technical specifications in an agile environment with 2-week iterations.
• Handling offshore scrums, stories planning and estimations for sprints
• Validation of data transformations and perform End-to-End data validation for ETL & BI systems
• Contributed to quality and process improvement initiatives.
• Created, reviewed, and inspected all key deliverables including Test Strategy, Test Plan, Test Cases
• Developed and executed manual test cases through various levels of testing - System, Integration
• Part of regression testing and UAT testing.
• Part of Informatica transformation validations between databases based on mapping documents
• Develop and maintain effective relationships with internal and external customer/teams
• Managed defects in Azure and Jira for the different modules of the project
• Involved in migration from SSIS to Cloud platform
• Used Java scripting for this project to offer responsive website layouts
• Worked on Tableau analytics and Tableau report testing

Confidential

ETL/ BI Tester/Test Lead/MDM Test

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Used HP Quality Center 10.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Prepared test cases for checking the populated data correctly into fact and dimension tables.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status
• Expertise in creating complex SQL Queries to verify and validate the Database Updates.
• Verified end to end validations as part of code migration from Informatica lower to higher versions and Teradata to SQL server

Confidential

ETL/ BI Tester/Test Lead

Responsibilities:

• Prepared test cases for checking the populated data correctly into fact and dimension tables.
• Contributed to quality and process improvement initiatives
• Coordinated and controlled testing projects at every step of the quality cycle from test planning through execution to defect management.
• Reviewed system usecases and functional specifications with the appropriate business analyst.

Confidential

ETL/Tableau Testing/Lead

Responsibilities:

• Test cases and test scripts preparation/execution with team
• Writing queries to validate reports
• Dashboard validations in Tableau reporting tool
• Defect fixes and regression testing
• Handling team work and update to onsite and client
• Used Java scripting for this project to offer responsive website layouts

Confidential

BI/ETL Test Lead/MDM/Data Analyst

Responsibilities:

• Handling team work, Client meetings and Status reports
• Developed Test Plans, Test Cases, and Test Scripts testing.
• Created Test Cases and developed Traceability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing and Functional testing.
• Tracked the defects using Quality centre tool and generated defect summary reports.
• Created Test Cases in Quality Centre and mapped Test Cases to Requirements.

Confidential

BI/ETL Tester/Report Testing

Responsibilities:

• Coordinated and controlled testing projects at every step of the quality cycle from test planning through execution to defect management.
• Reviewed system usecases and functional specifications with the appropriate business analyst.
• Generation and documentation of test cases from functional requirements and design documents.
• Performed Integration, System tests and Customer acceptance testing. Created new tests based on the review of the customer in the acceptance test phase.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.

Confidential

Testing/Database Test Engineer/MSBI Report Testing/SDET

Responsibilities:

• Understanding the scope and writing ATP and Test case preparation
• Test case review with Engineering teams and Dev team
• Executing test cases and working on web services
• Defect tracking and Report Generation in MTM

Confidential

ETL Test Engineer/ OBIEE Report Tester

Responsibilities:

• Developed Test Plans, Test Cases, and Test Scripts testing.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Tracked the defects using Quality center tools and generated defect summary reports.
• Created Test Cases in Quality Centre and mapped Test Cases to Requirements.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse databases
• Did end to end data validations after code migrations in project from one platform to other platform