SUMMARY

• A total of 18+ years of experience in Automated, Functional/Non - functional, DWH / ETL, MDM, API, REST and BI application Data Quality testing.
• Managed test delivery portfolio worth multi-million USD and team of associates SDETs (automation) on BA/QA engagement model spread across multiple geographic locations.
• Overall responsible for Delivery Management, Operations, Delivery Excellence and People Management.
• Experience in driving testing engagement of high scale integration and M&A data validation of two organizations. (Oppenheimer Fund and Confidential merger)
• Data Quality Manager with experience in Data Profiling, Data lineage and Data Quality Checks and certification.
• Experience in liaising with Business, UAT Coordination with facilitating business and IT defect triages along with tracking of defects to closure along with Root Cause Analysis.
• Worked on the Financial Models (P/L, Forecast and Budgeting) and Solution Approach.
• Experience in leading Vendor management, onshore-offshore delivery model with teams spread across multiple geographic locations.
• Driving delivery excellence - Innovation / Automation adaption to achieve YoY saving in the BU.
• Experience in formulating KPI’s and Metrics to define success delivery criteria.
• Experience in designing Selenium based TestNG UI automation framework
• Hands-on experience with Advanced SQL Design and Python Based Data Automation along with designing Automation Suites & Framework.
• Hands-on experience in leading data lake, data integration and migration testing
• Experience with API/Service Layer Back End Automation using Python using PyTest framework and PyTest-BDD framework.
• Hand on experience of industry leading technologies like web services (REST/ SOAP), Big data/Hadoop eco system (Hive/Impala), On prem/cloud (AWS/Azure) validation.
• Experience in creating evaluation of testing artefacts, test project planning, monitoring & controlling, along with enforcing quality processes, people management, issue management, risk management, stakeholder coordination and overall delivery management.
• Experience in creating Confluence and JIRA dashboard using different gadgets for test management and representing test team into different agile ceremonies and stakeholder review meeting.
• Conducting Mid-Year & Annual appraisals and understanding and setting professional goals for team. Motivate team through incentives, rewards & recognitions and Driving innovation within the team

TECHNICAL SKILLS

Test Framework: PyTest Test NG, Selenium, BDD, Mocha

Analytics Tools: MS BI (SSIS, SSRS, Power BI), Informatica, Power Centre 9.0, Talend, Bigdata, HQL, Impala, Alteryx, Amazon Redshift.

Cloud Technologies: AWS and MS Azure

Automation/Scripting: Python 3, Java, Selenium, QTP/UTF, LR 7.0, WAS, Query Surge, Platinum, ROBOT

RDBMS / NoSQL: MS-SQL Server, Oracle, PostgreSQL, DB2, MySQL, Vertica

Test Management: JIRA, MS Project, QC/ALM, Kintana

Bug Tracking Tool: JIRA, ALM/QC, Rational Clear Quest

Requirement Management: Requisite Pro, JIRA

Configuration Management: GIT, SVN, VSS, PVCS, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Test Program Manager

Responsibilities:

• Define Program Test Objectives/Test Plan - System, Integration, Migration and Regression
• Work with stakeholders to define program objectives
• Creating Confluence pages and JIRA dashboard to track project and metrics
• Develop and implement strategies to maximize synergies across program areas and cross functions (Dev / BA / Ops and Business)
• Identifying KPI’s and Validation Points in association with BA and QA teams and tracking it changing across different layers of applications
• Defining SalesPage and SalesForce cloud testing strategy and approach.
• Designing ETL / MDM test ( Python-PyTest) and Data Analytics using Alteryx
• Designed MuleSoft API/Microservices testing Solutions. (System, Process and Experience API’s validation) using Postman using underlying RAML script.
• Worked with Business and UAT Coordination with facilitating business and IT defect triages along with tracking of defects to closure along with Root Cause Analysis.
• Designed Behaviour Driven Development using PyTest-BDD
• Designed automation Selenium-TestNG based UI automation framework
• Complex test SQL/Stored Procs design and code review

Confidential

Test Program Manager

Responsibilities:

• Formulating the test strategy for Guidewire migration from legacy system.
• Represented test team into Agile Ceremonies and daily stand-up.
• Data Migration Validation on Claim Centre and Policy Centre
• Requirement and User Story Card Validation
• Test Only Sprint planning with onshore and offshore QA teams.
• Territory Claim Reports Data validation and test Data Fabrication
• Defect Management
• UAT Coordination
• Risk Management

Confidential

Test Program Manager

Responsibilities:

• Confidential Data QA work assignment, Program level status, metrics reporting and tracking. Dashboards pertaining to health of projects.
• Designing and Reviewing Selenium-TestNG based Automation Scripts for front end and Java Based Test Scripts for Data base automation in association with BA and QA teams.
• Designed and reviewed Impala and Hive (HIVE QL) queries on HDFS for data validation.
• Test Data Manufacturing to maximize test coverage.
• Monthly and Weekly status updates to Key stakeholders
• Driving Monthly Governance Meetings
• Ensure standardization of test processes, tools and practices across QA organization.
• Manage QA program for all project deliverables and escalation management
• Ensure timely knowledge transition and query resolution in an onshore-offshore model.
• Communicate objectives, initiatives, issues and risk mitigation to all global stakeholders.
• Environment readiness follow-­ups and overcome infrastructure related bottlenecks