- 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
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
Test Program Manager
- 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
Test Program Manager
- 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
Test Program Manager
- 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