SANJAY SHAW
Kolkata
Summary
Detail-oriented QA Analyst with 13 years of IT experience, including 2 years in software testing. Expertise in requirements analysis, application testing, data validation, and UAT support. Skilled in translating business requirements into test scenarios, validating workflows, and investigating issues using SQL. Collaborative problem solver with a focus on Finance Technology and a desire to advance in functional application analysis.
Overview
2
2
Languages
1
1
Certification
3
3
years of post-secondary education
14
14
years of professional experience
Work History
QA Analyst – Insurance Domain
Tata Consultancy Services (TCS)
08.2024 - Current
- Executed end-to-end functional testing and application validation for web-based insurance applications, ensuring alignment with pension and life insurance business processes.
- Execute functional, system, integration, regression, smoke, sanity and UAT-support testing across Policy Administration, Pension Services, Retirement Processing and Claims workflows.
- Validate end-to-end business workflows including policy creation, premium calculation, policy updates, renewals, cancellations, claims submission, document validation, approval/rejection and payout processing.
- Analyze business requirements, functional specifications and user stories to identify business rules, process flows, test conditions and expected system behavior.
- Translate requirements into detailed test scenarios, test cases and functional validation coverage, maintaining clear traceability from requirements to execution and defects.
- Perform data validation using SQL to verify consistency between user-interface transactions and backend database records; investigate discrepancies and support issue resolution.
- Identified, documented, tracked, retested, and closed application defects using TCS MasterCraft DevPlus while collaborating with developers, business analysts, and stakeholders throughout the issue lifecycle.
- Facilitated production-release readiness through monthly regression cycles, defect triage, and execution reporting, contributing to 0% post-release defect leakage in the current project.
- Designed and maintained an Excel-based QA dashboard for story tracking, test-case coverage, execution progress, defect/quality tracking and sprint burndown reporting.
Business Process Lead / SME – BFSI Domain Operations
Tata Consultancy Services (TCS)
02.2013 - 07.2024
- Led teams handling policy processing, transaction/data validation and quality controls; served as SME for complex Insurance workflows, business rules and process queries.
- Managed end-to-end back-office operations for Insurance-based projects while ensuring SLA, quality, process and operational compliance.
- Analyzed business processes, requirements and workflow gaps to enhance application usage and operational quality controls.
- Executed data and transaction validation, quality audits, root-cause analysis and corrective-action activities using Lean Six Sigma practices to ensure compliance.
- Coordinated with stakeholders on escalations and operational issues, translating business concerns into actionable resolutions for process improvements.
- Trained and mentored team members on application usage, Insurance processes, business rules, quality standards and operational procedures.
Education
Bachelor's Degree - Commerce and Business Management
University of North Bengal
Siliguri 04.2008 - 01.2011
Skills
- Functional Testing
- Regression Testing
- Data Validation
- Backend SQL validation
- Application & Functional Analysis
- Business Requirement Analysis
- Functional Documentation
- Test Scenario & Test Case Design
- Requirement Traceability
- Agile / Scrum
- Issue and Defect Resolution
- Root Cause Analysis
- Process analysis
- Knowledge transfer
- SQL
- Test Management Tool (Jile, TCS mastercraft Devplus, Jira)
- Automated Testing Tool (Selenium)
- Web Automation Framework (Playwright)
- Advanced Excel skills
Personal Information
Location: Kolkata, West Bengal, India
Career Preference: Manual Testing | QA Analyst | Quality Engineer | Insurance/BFSI Domain
Certification
- Selenium Foundation Certification
- Playwright
- Maven E1 Certification
- Software UAT Testing
- Lean Six Sigma Green Belt – TCS Internal
- Advanced MS Excel
- Visual Basics for Applications – Foundation & Intermediate
AWARDS & RECOGNITION
Title: SOFTWARE / APPLICATION ANALYST | FUNCTIONAL TESTING | APPLICATION SUPPORT | BFSI
STRENGTH
- Strong Analytical and Problem-Solving Skills
- Excellent Attention to Detail
- Strong Insurance/BFSI Domain Knowledge
- Ownership, Accountability and Commitment to Quality
- Effective Communication and Stakeholder Management
- Adaptability, Quick Learning and Team Collaboration
Languages
Hindi
Professional
English
Beginner
Timeline
QA Analyst – Insurance Domain
Tata Consultancy Services (TCS)
08.2024 - Current
Business Process Lead / SME – BFSI Domain Operations
Tata Consultancy Services (TCS)
02.2013 - 07.2024
Bachelor's Degree - Commerce and Business Management
University of North Bengal
04.2008 - 01.2011