QA Automation & Testing Leader with Scrum Master focus

Objective

To pursue a long-term career in a professional organization working on challenging projects to best utilize my knowledge & skills and contributing in overall success & development of the organization

Professional Summary

A disciplined QE practitioner having excellent experience & expertise in implementing Agile testing practices for both manual & automated testing. Demonstrated track record of success in applying technical and leadership skills, ultimately increasing the quality of the project deliverables & stakeholder’s confidence

Proficient at identifying & automating effective test scenarios & test cases for Functional Regression, System Integration, Form Validation, UI, Usability, User Acceptance, Web Services, Security and Database testing of web based & client-server applications. Good knowledge of the STLC, Defect life cycle and QA methodologies

The expertise in Automated Testing is using Microfocus tools - UFT/QTP, ALM/QC, VB Scripting, PL/SQL and Object Oriented Programming techniques supported by a detailed understanding of Test Automation Frameworks, best testing practices and knowledge of Java, C/C++ and UNIX Shell Scripting

Ability to work in a collaborative team environment with an eye for efficiency and workflow. Excellent team player with demonstrated leadership qualities and analytical skills.

Master’s in Computer Application (MCA), & Bachelor’s in Computer Science (B.Sc.- Comps.)

A Certified SrumMaster (CSM) & Product Owner (CSPO) from Scrum Alliance

Technical Skills

Test Tools

JIRA, Microfocus-ALM/QC, Microfocus Unified Functional Testing(UFT), Selenium, RESTAPI

Functional Test Design Techniques

Boundary value analysis, Decision tables/Tree, Cause-Effect, Negative testing, Error-guessing, Configuration Based, Backward Compatibility, Role-based, Database testing, Data Migration testing, Data Quality Check etc.

Environments

Web and Windows based applications (client-server)

Databases

Teradata, Oracle, MS-Access

Languages

C,C++, PL/SQL, VBScripting, VBA Programming, Java, Windows Programming, Shell Scripting

Other

MS-Visio, System Designing-ER-Diagram, DFD, Function Decomposition Diagrams, Database Designing; Test Planning, Test Case Designing, Test monitoring & control, Test closure

Professional Experience

Devric Consultancy Services Inc., BA/QA Consultant Dec 2024 – Dec 2025

Responsibilities & Achievements @ Intact Insurance – GB&T Claims Project

Designed, developed, and executed automated ETL data pipelines validation suites in Datagaps, accelerating analytics data releases for business decision making.

Validated ETL processes for Group Benefits & Travel claims data ensuring trusted data flows for improved reporting reliability for Operations, finance & IBNR reporting teams

Built and maintained MS-Excel based test automation utilities that standardized test execution, increasing test effectiveness for all key financial reporting.

Ensured integrity of data warehouse and data lake pipelines by validating data structures, schemas ( Staging, RDS, BDS), business rules, aggregations, and historical data loads.

Identified, analyzed, and resolved complex data defects through root cause analysis & close collaboration with development team, reducing defect recurrence & increasing data quality

Successfully validated end-to-end ETL processes across multiple source and target systems, ensuring reliable and consistent data movement across enterprise platforms

Performed comprehensive data reconciliation, completeness, and accuracy validation using advanced SQL in SNOWFLAKE, proactively identifying data anomalies and preventing downstream reporting issues.

Tata Consultancy Services Canada, Consultant-Automated Testing, Jan 2014 – Feb-2024

Responsibilities & Achievements @ TD Bank – Regulatory Projects

Review project change requirements in S3 under branch banking services

Develop testing strategy/approach & test plan for projects including automated testing

Provide story points estimates & inputs from QE perspective during backlog refinement

Plan, design & execute IN-SPRINT automated tests using MF-UFT for user stories testing

Conduct sprint review and demos with team(s) during agile ceremonies

Worked closely with BAs, DEVs, QEs and product owner(s), scrum master & coaches on daily basis for product & process improvements and for better customer/user experiences

Provide QE sign-offs for SIT testing & package testing for S3 PROD deployments

Provide necessary support to downstream application testing teams

Successfully designed & implemented excel tools/utilities for API logs validations in S3

Adhere and comply with all applicable QA standards & practices at bank

Actively recommend areas of improvement during sprint retrospective meetings

Responsibilities & Achievements @ Ontario Teacher’s Pension Plan (OTPP),

Successfully designed, developed & implemented In-Sprint test automation framework for regression testing Upgrades, projects & user stories in ServiceNow @ OTPP

Single handedly delivered multiple platform upgrades in ServiceNow (namely Kingston, London, NewYork ) using automated regression test suite that was designed from scratch

Successful implementation of HYBRID test automation framework using UFT, VB Scripting and Excel Macro Scripting ( VBA Programming)

oFramework approach independent of test cases, test data and test environments resulted into higher scalability and lower maintenance

oNo data hard coded in the script, no piece of code replicated in the framework resulted in high reusability and reduced maintenance time and efforts

oUsage of shared object repository along with descriptive programming techniques reduced scripts execution issues and increasing its stability

oAdded/Updated integrated automated tests with zero/minimal scripting efforts which resulted in quick expansion of test coverage by length and breath

oRe-usable scripts, highly robust and able to overcome QTP limitations

oResults reported in Excel files with snapshots for failed test cases

Successfully chaired defect triage meetings using automated test execution movie recordings & results

Worked closely with BAs, development lead & app managers in troubleshooting/re-testing integration issues and identifying system limitations

Given automated test execution results that were produced during SIT testing, business stakeholders gave confident sign-off for PRODUCTION releases, with minimal-to-no UAT testing

Responsibilities & Achievements @ Aviva Insurance

Developed very good knowledge & understanding on various Guidewire applications namely PolicyCenter, ClaimCenter & ContactManager through 2.5+ experience working on various projects @ Aviva Canada

Study & analysis of Source-to-Target mapping requirements, ETL design requirements, source & target data models and ETL work flow diagrams

Design test scenarios and required test SQL queries\statements for validating data that goes in data warehouse to ensure its completeness, correctness and integrity based on the knowledge of business rules and design documents

Perform appropriate level of root cause analysis for failed tests & data and provided optimized SQL statements with result sets to development team for their defect analysis & fixing

Developed VBA scripts for run-time generation of mass SQL statements for automated regression testing in various environments namely DEV, SIT, QA & PROD

Successfully designed, developed and implemented MS-Excel based ETL Test Automation framework (similar to QuerySurge) for validating 3000+ EDW target tables against Guidewire source application table(s). Also got certificate-of-achievement from AVIVA for the same

Worked closely with development team and data architect to troubleshoot/re-test issues

Performed end-to-end data migration testing for landing data from Guidewire source applications to Enterprise Data warehouse

Performed data backup, load and refresh for older data and newer incremental data loads

Successfully performed role as Sr. SQL developer in parallel for Reporting project – KANETIX

Performed audits on the data quality by applying PL/SQL skills & domain knowledge

Alberta Blue Cross, Edmonton Test Lead [ASR-Reporting], June. 2013 – Nov. 2013

Responsibilities & Achievements

Preparation of Test Strategy and Test Plan document for the ASR-Reporting project

Test Effort Estimation & scheduling test activities

Lead the software defect triage meetings and optimized defect management process

Identified critical process issues and submitted recommendations to fix the same

Participated in process meetings to redefine/reset Alberta Blue Cross process standards

Identified test conditions and designed test cases in HP-ALM

Test execution and defect reporting in HP-ALM

Environment & Tools: Windows XP, HP-ALM 11, Oracle Discoverer

CGI Information Systems Inc., Toronto Senior Consultant June. 2011 – September 2012

Responsibilities & Achievements

Gained extensive technical knowledge and expertise on CGI Test Automation Services- ATSM in a short span of time and actively contributed in implementing the same for its internal and external clients

Defined and developed a detailed training plan enabling new resources/users to quickly learn and implement ATSM. Successfully mentored resources in implementing ATSM by defining processes and best practices for the same

Evaluated and submitted recommendations to implement/enhance ATSM in best possible manner to meet client needs

Active contribution in development of test automation project proposal-MVest & Trade 360

Successfully implemented variety of Test Automation Frameworks using QTP, VBScript and OLE automation techniques for clients in the banking and healthcare domain.

Amongst all frameworks, Keyword-Driven Test Automation Framework developed using QTP & VBScript was highly successful.

Keyword-Driven Test Automation Framework included usage & implementation of single shared object repository with visual relationship identifier mechanism, library files, driver scripts, key-word scripts, data tables, error handling, environment variables, custom checkpoints, configuration scripts and scheduler scripts

Environment & Tools: HP-ALM 11, QTP 11.0, VB Scripting, MS-Excel 2010, MS Windows Server 2003, Windows XP, Citrix

Synechron Technologies Pvt. Ltd. India, Automation Test Lead, Oct. 2010 – Mar. 2011

Responsibilities & Achievements

Analysis of system requirements, system design document, system architecture and test artifacts to establish test automation needs and prioritize the same through collaboratively working with BA team

Walk through of QA test cases & QA test plans with minimal support from BA and test team

Defined, documented & developed Test Automation Strategy and plan for the project

Effort estimation and scheduling of test automation activities

Multiple projects successfully awarded to Synechron Technologies despite competition from other vendor groups at Standard Chartered Bank, Singapore

Environment & Tools: QTP 10.0, VB Scripting, MS-Excel 2010, Windows 7

Cybage Software Pvt. Ltd. India, QA Team Lead, Aug. 2006 – Oct. 2010

Responsibilities & Achievements

Understood requirements on different clients’ products & processes by attending 1-month training program at LexisNexis Examen Inc., Sacramento, California which involved regular meetings, formal/informal discussions, detailed study and analysis of requirements and counter presentations

Effective high level test scenario/condition identification followed by detailed test case design for functional, form validation and security testing using boundary values, data integrity, decision trees & decision tables, error-guessing, configuration based, role-based and other negative test design techniques

Collaborated with BA and Dev team to design & document complete functional regression test Suite in MS-Excel files. Later the same was uploaded to QualityCenter 9.2 with necessary modifications to file structures and data in minimal time

Defined/Reviewed/Optimized testing efforts, scope, timelines, resource allocations for different milestones within project from time to time

Monitored, tracked and reported test status, reports & bug statistics to senior management.

Successfully designed, developed and implemented key-word driven test automation framework for client’s flagship product – CounselLink using QTP, VB Scripting, object oriented programming techniques and MS-Excel programming techniques

Code review and documentation of technical aspects of automated test suite

Test Automation Framework successfully replicated and implemented for client’s other work product - “LegalPrecision” with minimal efforts and time

Conducted interviews for QA Recruitments

Conducted fast-track and regular product & automation trainings for new team members to make them productive as early as possible Interaction with client manager, dev manager & onsite coordinators on daily\weekly basis and as & when required for multiple QA projects

Responsible for QA sign-off, QA test planning and execution of QA assignments

Gave and received constructive feedback to team members & client on regular basis

Identified opportunities for further efficiencies within team & resource utilization

Reviewed, controlled & optimized quality of project deliverables and processes

Successfully lead a team of 10+ QA professionals including QA Analyst and Sr. QA Analysts

Rewarded with multiple promotions in recognition of outstanding QA contribution leading to successful product releases worldwide from time to time

Environment & Tools: MS Project 2007, MS-Visio, 2003, QTP 9.2, Windows XP with Service Pack3, MS-Word 2003, VB Scripting, MKS Integrity, Putty, MQC 9.2

Kanbay Software (I) Pvt. Ltd. India, QA Analyst, Sept. 2004 – July. 2006

Responsibilities & Achievements

Gained extensive knowledge on AUT and other relevant applications

Designed test plan for various types of testing

Identified test scenarios and wrote effective test cases

Estimated efforts for test case designing, test execution cycles and defect testing

Test environment setup, test case execution, defect reporting & bug fix testing

Prepared test case traceability matrix ensuring requirements test coverage per test strategy

Undertook testing responsibility of critical & high severity defects during non-office hours and as and when required

QA Metrics report generation using Test Director for QA processes

Provided excellent guidance and mentorship to resources with regards to application testing and testing of critical to low severity issues

Co-ordinated, guided and supported team to design effective test cases

Responsible for off-shore QA sign-off, QA test planning and execution of QA assignments

Environment & Tools: MS-Word & .Net, Test Director 7.0, Windows XP with Service Pack3

Elitecore Technologies Pvt. Ltd. India, Jr. QA Engineer, Nov. 2003 – July. 2004

Responsibilities & Achievements

Requirements study & analysis

Identified test scenarios & designed effective test cases

Test Planning and Test cases execution

Designed test traceability matrix for mapping requirements to tests

Defining test automation framework requirements as per directions and inputs from Development Manager and Development lead

Test automation framework designing, scripting and implementation

Automation of the high priority tests using the tools Winrunner, MS-Excel, VSS

Execution of manual & automated tests, analysis of test execution results/artifacts and preparation of test execution summary report

Environment & Tools: Java based web application, WinRunner, VSS, Test Director

Education & Professional Certifications

Sardar Patel University, Anand, Gujarat, India

Master of Computer Application

B.Sc. (Computer Science)

Scrum Alliance

CSM - Certified ScrumMaster

CSPO – Certified Scrum Product Owner

Linked Learning

ServiceNow IT Leadership Professional

Contact this candidate