Vishal Sankpal

Results-driven QA Technical Lead and SDET with 13+ years of experience across the full software test lifecycle — including Manual testing, ETL testing and Database testing using SQL-based database verification in Agile/Scrum environments in validating complex data pipelines, data warehouses, and BI systems. Strong expertise in writing advanced SQL queries for source-to-target validation, data reconciliation, and identifying data anomalies. Hands-on experience with SSIS workflows, data migration testing, and end-to-end ETL validation including staging, transformation, and reporting layers.

Proven track record of leading quality assurance for data-intensive fintech products in the mutual funds and insurance domain, delivering 10+ zero-defect production releases through rigorous test planning, defect lifecycle management, and cross-functional collaboration. Skilled at translating complex business requirements into comprehensive test strategies and embedding quality at every stage of the SDLC. Proficient with Postman, JIRA, Zephyr, and MS-SQL Server to drive regression efficiency, release velocity, and software reliability.

QA Technical Lead - ICRA Analytics Ltd - Pune

(2019-08 - 2025-10)

Spearheaded end-to-end quality assurance across 4 high-availability fintech products, owning the full test lifecycle from requirement analysis and test planning through execution, defect management, and release sign-off — delivering 10+ major releases with zero critical production escapes.

• Authored and maintained 500+ detailed test cases improving regression coverage and ensuring traceability across multiple product modules, including mutual funds, portfolio tracking, and insurance workflows.
• Performed end-to-end ETL testing including source-to-target validation, data completeness, and transformation logic verification.
• Wrote complex SQL queries DDL, DML, and DCL commands and joins, aggregations, window functions to validate large-scale data across multiple systems.
• Validated data migration and reconciliation between legacy and target systems ensuring 100% data accuracy.
• Tested SSIS packages to ensure correct data flow, transformation rules, and error handling mechanisms.
• Collaborated with developers and business analysts to understand ETL logic and ensure proper test coverage.
• Automated repetitive SQL validation tasks to improve testing efficiency.
• Ensured data integrity, consistency, and performance across ETL pipelines.
• Designed and executed smoke and regression test suites for every sprint cycle, proactively catching defect regressions, maintaining application stability post-release, and reducing overall regression cycle time by standardizing reusable test scenarios.
• Supported automation readiness by identifying repetitive regression scenarios suitable for automation and collaborating with development teams to improve overall testing efficiency and reduce manual effort across release cycles.
• Created and managed structured test data sets simulating real-world mutual fund transactions, investor portfolios, and insurance records to ensure realistic and comprehensive coverage of functional and boundary test scenarios.
• Ensured consistent delivery of high-quality releases by maintaining strong QA governance, resulting in multiple successful production deployments with minimal post-release defects and high stakeholder confidence.
• Collaborated closely with developers, business analysts, and product managers in Agile ceremonies — translating complex business requirements into clear, measurable, and testable acceptance criteria.
• Managed complete defect lifecycle in JIRA — logging, triaging, prioritizing, and tracking bugs with detailed reproduction steps, severity classification, and impact analysis — achieving 95%+ SLA adherence across all reported incidents.
• Coordinated UAT sessions with business stakeholders and end-users, gathering release sign-off on critical features and ensuring delivered functionality aligned with stated business objectives and compliance requirements.
• Maintained up-to-date QA documentation including test plans, execution reports, and defect dashboards; delivered weekly/monthly status reports to leadership enabling data-driven, transparent release decisions.

IT Officer - SRL Diagnostics Pvt Ltd - Mumbai

(2019-05 - 2019-07)

• Performed daily health monitoring and functional validation of in-house clinical laboratory applications, proactively detecting performance degradation and functional regressions that could impact business continuity and patient workflows.
• Identified, documented, and escalated application defects to technical teams with detailed reproduction steps, and conducted post-deployment verification to confirm successful resolution before business go-live.

Senior Technical Support Associate (QA & Application Support) - ICRA Analytics Ltd - Mumbai

(2014-04 - 2019-04)

Managed end-to-end application release coordination for the fintech product suite, aligning internal development teams, third-party vendors, and business stakeholders to meet delivery milestones with quality compliance and minimal disruption.

• Administered and optimized Microsoft SQL Server (2008 R2 – 2017) databases, including schema upgrades, data migrations, replication configuration, query performance tuning, index optimization, and critical production issue troubleshooting.
• Reviewed FRS, SRS, and change request documents to validate implementation accuracy, and performed structured manual testing of new features, patches, and custom financial reports to ensure quality before client-facing deployment.
• Delivered Tier-2 client support via JIRA and Remedy, resolving 100+ functional, data, and configuration incidents within SLA; led structured root-cause analysis for critical escalations to prevent issue recurrence.
• Served as the primary communication bridge between business analysts and implementation teams, ensuring change requests, defect priorities, and business requirements were accurately documented, understood, and delivered on time.

Technical Support Executive - Krishna Enterprises - Mumbai

(2012-11 - 2014-03)

Delivered end-to-end client-facing software support for an in-house stock handling application, troubleshooting functional issues, coordinating with internal teams and vendors, and ensuring all release areas were thoroughly verified and properly managed.

• Communicated change requests and defect priorities between business analysts and implementation teams, ensuring accurate handoff and timely delivery of bug fixes and enhancements within agreed timelines.

Junior Software Engineer - ENVEE Information Technology - Mumbai

(2011-04 - 2012-10)

Provided software support and functional validation for MIDC Payroll and Accounts systems, working directly with clients to understand reported issues, reproduce defects, and coordinate resolution with development and business teams.

• Supported release management activities by coordinating with internal teams, vendors, and business partners to ensure all release areas — including testing, documentation, and deployment — were properly planned, executed, and signed off.
• Collaborated with business analysts and implementation teams to communicate and prioritize change requests and bug fixes, ensuring accurate requirement handoff and timely delivery of software updates to end-users.

Bachelor of Commerce - University of Mumbai (2008-01 - 2009-01)