SUMMARY

• An ISTQB Certified Software Professional with around 9 years of Expertise in Software Development & Quality Assurance.
• Expertise in setting up Test Center of Excellence & Test Shared Services Utilities.
• Expertise in working as ETL & Business Intelligence Architect, QA/Test Lead and Individual contributor.
• Strong experience in Testing Reporting tools: Business Objects, BI, Crystal Reports, and Cognos Reports 10 & 11 (Report Studio, Query Studio, Analysis Studio, Cubes, Dimensions & Facts, Dashboard Reports, Data Module Reports)
• Strong Experience on Report Automation.
• Strong experience in ETL/DW & Data Mart Testing with Data stage 11 and Informatica tool with different platforms.
• Strong Experience with Mobile Apps and Web testing with Emulator(Perfecto), Android & iOS.
• Strong Experience in testing Cloud based Applications and Products (Salesforce, Service Now, PEGA PRPC)
• Hand on Experience in Web Services Testing using Soap UI, SAP Testing.
• Hand on experience in Performing Testing for Robotic Process Automation(RPA) with Open Span 7.1 across different platforms.
• Hand on experience in Regression & Functional Test Automation with Selenium Webdriver with Cucumber & TestNG.
• Strong experience in Debug & Fix Automation frameworks (Behavior - Driven, Data Driven)
• Strong experience in Insurance Underwriting and Claims Applications, Debit and credit card Testing.
• Proficient in writing SQL Queries involving complex join conditions. Donedatabase Testing, data integrity validation.
• Strong experience in JIRA, HP ALM (Quality Center), Rally, PMF.
• Hand on Experience in Preparing Test Plan and Test Strategy documents. FTE Efforts estimation. Involved in all end to end STLC and SDLC phases.
• Strong Domain expertise in BFSI, Health Care, e-Commerce, Travel Domain(Hotels & Resorts) and expert on Quality Assurance and Project Management.
• Expertise in handling Capital & Maintenance large scale Projects and Migration Projects.
• Expertise in Direct Interaction with Clients, leading large scale projects, managing multiple teams and coordination in Onshore Offshore Model.
• Experience in leading, planning, estimation, execution and tracking of Large Scale testing projects.
• Leveraged budgeting expertise to efficiently manage test bed build out and maintenance. Adopted virtualization as a needed process that reduced equipment costs.
• Led process improvement projects to reduce test times, integrate new tools and manage key tasks
• Established, implemented, and improved QA infrastructure; test procedures, process, and quality standards in accordance with overall development and product releases.
• Worked cross-functionally with other managers to streamline operations (Agile Integration Team)
• Planned and coordinated resources needed to implement new test strategies (Automation, Agile Scrum, Kanban, Sanity Suite Regression, etc.), resulting in development of best practice models
• Evaluated project requirements in both Agile, Waterfall and hybrid environments, Devops environment.
• Managed Continuous Process Improvement (CPI) to build team and enhance PLC (Product Life-cycle) & SDLC (Software Development Life-cycle) adherence.
• Expert in CMMI Level Audits and complete QA Process (ADM & PCI Compliance).

TECHNICAL SKILLS

• Test Plan & Test Strategy
• Test Management
• Quality Assurance
• Mobile Apps Testing
• Web services Testing
• Pega testing
• SQL/Oracle
• Oracle RAC
• Automation testing (Robotic and Regression)
• Functional & Integration Testing
• ETL Testing
• Performance Testing
• Requirement Analysis
• Waterfall Model
• Agile (Scrum & Kanban)
• TestNG
• Excel Macros
• ITSM & Service Now
• System & UAT Testing
• Process Improvement
• PMF
• ALM(QC)
• JIRA
• QTP
• Java
• Putty
• New Relic
• Macess & Xceleys
• Data Stage/Informatica
• Cognos 10.2, 11
• Life Cycle Manager
• Application Manager
• BFSI & Healthcare Domain e-commerce Domain
• Cloud Testing
• Cucumber & Gherkin
• WinSCP
• Motio PI

PROFESSIONAL EXPERIENCE

Confidential

Cognos & ETL Consultant

Responsibilities:

• Perform detailed analysis on the requirement and create User stories in rally
• Responsible for Requirement analysis, Planning, Effort Estimation, Resource Planning, Testing of Cognos Reports (Report Studio, Analysis Studio, Query Studio, Dashboard Reports, Datamodule Reports, Cubes, Dimensions) & ETL Jobs with Datastage 11
• Responsible for Test Artifacts creation(Master Test Plan, Release Test Plan,Test Scripts Preparation)
• Involved in Data warehouse and Data Mart testing
• Responsible for Cognos and Datastage Admin Security.
• Handling 12 Members Team (in offshore)
• Task Allocation to Team members
• Effective Coordination between clients and offshore team, ensured deliverables are accurately reached on daily basis.
• Requirement Traceability Preparation with ALM and Rally.
• Created, maintained and update ETL Test Scripts and Data validations.
• Involved in end to end Report Testing and Regression testing using the Iterative methodologies based on the Test Scenarios and detailed Test Cases.
• Effective and Timely Coordination with Offshore counterparts & Clients and sending the Daily Status Reports.
• Ensure Agile Kanban dashboard is updated correctly based on resource expected and actual hours.
• Test Summary Report Preparation.
• Root Cause Analysis document preparation
• QA Signoff

Confidential

QA Lead/Onsite Coordinator/Testing Architect

Responsibilities:

• Developed highly expertise team to work on BI products in Offshore and Onshore
• Built and Implemented enterprise-level Testing application suites and conducted analysis
• Onsite Coordination between clients and offshore team, ensured deliverables are accurately reached on daily basis.
• Responsible for Test Planning, Test Estimation, development of test, create test data and conducting functional & Automation test on software system and creating result analysis report
• Handling 8 Members Team (Two in Onsite and 6 in offshore)
• Responsible for Planning, development of Robotic Process Automation Scripts(RPA)with Openspan7.1, test, create test data and conducting performance test on software system and creating performance analysis report.
• Task Allocation to Team members
• Requirement Traceability Preparation with ALM and PMF.
• Resource Planning and Effort Estimation for all types of requirements (Functional & Performance)
• Created, maintained and update ETL Test Scripts and Data validations.
• Created, maintained and update Automation Test Scripts using Selenium Webdriver and Java & TestNG and Robotic Process Automation with Open span.
• Involved in Data warehouse testing and Cognos report testing (Query Studio)
• MOM Preparation and publishing
• Preparing and executing Pega Application test scripts.
• Involved in Mobile Applications Testing with Perfecto.
• Involved in end to end Functional Testing and Regression testing using the Iterative methodologies based on the Test Scenarios and detailed Test Cases.
• Effective and Timely Coordination with Offshore counterparts & Clients and sending the Daily Status Reports.
• Ensure Agile Scrum board is updated correctly based on resource expected and actual hours.
• Test Closure Document Preparation.
• Root Cause Analysis document preparation

Confidential

Test Lead / Database & ETL Tester

Responsibilities:

• Handled 20 Members Team across multiple projects. Effort Estimation, Task Allocation to Team members Responsible for Test Planning, Test Estimation development of test, create test data and conducting functional & Automation test with Selenium Webdriver on software system and creating result analysis report.
• Resource Planning and Effort Estimation for all types of requirements (Functional & ETL) MOM Preparation and publishing Preparing testing deliverables like Traceability matrix, Test scenarios & Test Cases Involved in end to end Functional Testing and Regression testing using the Iterative methodologies based on the Test Scenarios and detailed Test Cases.
• Involved in Data warehouse testing and Cognos report testing (Query Studio) Test Summary Report Preparation Root Cause Analysis document preparation Effective and Timely Coordination with Onsite counterparts & Clients and sending the Daily Status Reports Test Metrics Preparation

Confidential

Database & ETL Tester

Responsibilities:

• Analysis of ETL design documents in Jira Preparation of ETL and Database Test scripts for complex requirements Performed Smoke Testing (Build Verification testing) to verify stability of the build and show stopper.
• Performed UAT Testing for Client Involved Integration Testing across different complex modules. System Test cases and Test Scenario Design and Test Execution with Jira Weekly Conference calls with Clients regarding module status Performed XML Testing with SOAP UI and verify Request and Response.
• Involved in Regression & Retesting in every release Involved in Complete Defect life cycle in Jira. Requirement Traceability Matrix Preparation and ensure all the requirements are covered.
• Review Report Preparation and submit the same stakeholders.
• Reviewing Peer Test Scripts and Test Scenarios