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. Done database 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).

SKILL:

• 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
• Confidential & 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, Arizona

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

Software: Platform, Windows 7.

Technology: IBM Cognos Analytics, IBM Datastage, Rally, HP ALM (Quality Center)

Database Tools: Oracle 11G

Other Tools: Cognos 10.2 & 11(Report Studio, Analysis Studio, Query Studio, Transformer, Framework Manager), Application Manager, IBM Data Manager, Datastage 11, ITSM, New Relic, Motio PI, Unix

Confidential

QA Lead/Onsite Coordinator/Testing Architect, New Jersey

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

Software: Platform, Windows 7.

Technology: HP ALM, Rally, PMF

Database Tools: Oracle 11G, Sybase

Other Tools: Duck creek, Selenium Webdriver with Cucumber & Gherkin, Pega, SAP, Openspan, Datastage, Cognos, Jmeter,Perfecto

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

Software: Platform, Windows XP,Windows 7.

Technology: HPQC

Database Tools: Oracle 10G

Other Tools: Duck creek, Pega, Salesforce, IBM Cognos 10.1, Datastage 8.1, Selenium webdriver, SOAP UI, Perfecto

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

Software: Platform, Windows XP,Windows 7.

Technology: Jira, Toad

Database Tools: Oracle 10G

Other Tools: Informatica, Confidential, Confidential, WinSCP,Putty,Citrix Metaframe,SOAP UI, HP QC, Unix

Confidential

Functional Tester

Responsibilities:

• Analysis of Functional design documents in Jira Performed Functional and Database Testing and updated Test execution status
• Performed Integration Testing and End to End Testing to make sure complete modules are tested
• System Test cases and Test Scenario Design and Test Execution with Jira
• Conducted Weekly Conference calls with Clients regarding module status
• XML Testing
• Performed Regression & Retesting
• Defect life cycle performed with Jira
• Requirement Traceability Matrix Preparation to ensure all Requirements are tested.
• Review Report Preparation and publish to stake holders
• Reviewing Peer Test Scripts and Test Scenarios and raise review comments

Software: Platform, Windows XP,Windows 7.

Technology: Web Based Application built on J2EE and XML

Database Tools: Oracle 11G,SQL.

Other Tools: QC,Jira,Putty,WinSCP