Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Hobbies and Interests
Software
Timeline
Generic

Sanjana Banerjee

Bangalore

Summary

Accomplished QA Professional with over 12 years of progressive experience in all aspects of Software Development Life Cycle. Solid track record of dependability, leadership, and delivering quality software solutions. Detail-oriented individual with exceptional communication and project management skills, able to handle multiple tasks effectively in fast-paced environments. Recognized for proactive approach to identifying and addressing issues, focusing on optimizing processes and supporting team objectives.

Overview

13
13
years of professional experience
1
1
Certification

Work History

QA Team Lead

Sapiens
11.2024 - Current
  • Involved in Requirement Analysis, well-organized, efficient and successful test cases.
  • Used SQL queries to verify and test data validation of ETL application which involved testing of each layer.
  • Led performance testing initiatives for ETL workflows and reporting solutions, ensuring optimal database and report response times.
  • Executed and monitored Talend ETL jobs, analyzed execution logs to capture job success/failure statistics and identify performance bottlenecks.
  • Leveraged SQL Server Management Studio (SSMS) to extract and interpret batch statistics reports, identifying slow-running queries and optimization opportunities.
  • Utilized J-Meter for simulating user load and testing the scalability of Power BI reports and database queries under peak load.
  • Integrated Dynatrace for real-time monitoring and performance diagnostics of report executions and back-end services.
  • Collaborated with DBA and Dev teams to tune SQL queries and stored procedures contributing to high execution times in ETL and reporting pipelines and reducing it by nearly 50%.
  • Prepared and presented performance test reports, highlighting critical metrics, execution trends, and improvement recommendations.
  • Mentored junior QA team members on performance testing practices, tool usage, and result interpretation.
  • Documented testing procedures for developers and future testing use.
  • Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.

Technical Specialist(Team Lead)

CitiusTech
10.2021 - 11.2024
  • Company Overview: Leading US Healthcare Domain, Bangalore, India
  • Involved in Requirement Analysis, well-organized, efficient and successful test cases.
  • Involved in converting SQL test scripts written in snowflake to DBT format so as to run the test cases automatically.
  • Used SQL queries to verify and test data validation of ETL application which involved testing of each layer - Landing, Refined, Enriched.
  • Participated in all the Agile ceremonies.
  • Identified, prioritized and tracked defects with JIRA and worked closely with developers in resolving problems.
  • Involved in creating UAT data, Sanity Testing and working closely with Business in Acceptance environment during UAT.
  • Involve in team management, distribution of daily work and getting regular updates from team members.
  • Involved in preparing Test strategy and Test plan documents.
  • Involved in QMS audit activities and internal/external recruitment drives.
  • Leading US Healthcare Domain, Bangalore, India

Quality Assurance Tester(Team Lead)

Tata Consultancy Services
01.2020 - 10.2021
  • Company Overview: Leading Retail Chain, Kolkata, India, West Bengal
  • Involved in Requirement Analysis, Test feasibility analysis and preparation of new application.
  • Used SQL queries to verify and test data validation of ETL application which involved testing of each layer.
  • Participated in all the Agile ceremonies - Daily, Planning, Refinement, Review and Retrospective.
  • Identified, prioritized and tracked defects with JIRA and worked closely with developers in resolving problems by completing additional tests and to facilitate timely corrections.
  • Involved in Sanity Testing and working closely with Business in Acceptance environment during UAT.
  • Involve in team management, distribution of daily work and getting regular updates from team members.
  • Leading Retail Chain, Kolkata, India, West Bengal

Performance Test Analyst(Team Lead)

Tata Consultancy Services
10.2015 - 12.2018
  • Company Overview: Leading Utility Chain, Kolkata, India
  • Responsible for preparing Performance Strategy, Test plan & work load management depending on the Production traffic.
  • Performance testing using different protocols (SAP, HTTP), feasibility analysis, preparing test data and workload analysis.
  • Created test script & scenario creation for Load/Volume testing using Load runner.
  • Involved in Test execution and monitoring different performance KPIs like response time, CPU utilization, Memory utilization, Thread usage, TPS.
  • Involved in Estimation of new project opportunities, managing team and assigning work.
  • Leading Utility Chain, Kolkata, India

ETL Test Analyst

Tata Consultancy Services
09.2012 - 09.2015
  • Company Overview: Leading Supply Chain Domain, Kolkata, India
  • Analyzed the Data Contract and Business Requirements with Business Analysts.
  • Involved in validation of BO reports End to End (E2E) test validation of ETL application which involved Integration testing of each layer of Data Warehouse.
  • Involved in data migration to SAP.
  • Developed complex SQL queries to fetch data from Database to validate BO reports.
  • Involved in regular discussion with Internal/Business Team to update Risk Assessment Log from Testing perspective and to flag the critical issues/concerns during the conference meets.
  • Identified and tracked defects with ALM and worked closely with developers and business analysts in resolving problems.
  • Involved in preparation of Test summary report.
  • Identified critical scenarios for Acceptance testing (UAT) and executing the same.
  • Leading Supply Chain Domain, Kolkata, India

Education

Bachelor of Technology - Electrical Engineering

Asansol Engineering College
Asansol, West Bengal
07-2011

Skills

  • Database querying
  • ETL/DWH/Report Testing
  • Informatica
  • Functional and Regression Testing
  • Performance testing with Load Runner
  • Test strategy
  • Test plan
  • Talend
  • DBT
  • Client communication
  • Cross skill team leadership

Certification

Oracle Database: SQL certified, 08/01/13

Accomplishments

  • Proactively suggested and implemented Performance Testing using J-Meter to monitor and improve the performance of the Application.
  • Received Beyond Excellence award for project initiatives.
  • Received Team Applause award.
  • Received Rewards and Recognition award at my previous org for outstanding performance.

Hobbies and Interests

  • Reading Story books
  • Singing
  • Listening to music

Software

Sql server

Informatica

Cognos BI

Talend

DBT

Timeline

QA Team Lead

Sapiens
11.2024 - Current

Technical Specialist(Team Lead)

CitiusTech
10.2021 - 11.2024

Quality Assurance Tester(Team Lead)

Tata Consultancy Services
01.2020 - 10.2021

Performance Test Analyst(Team Lead)

Tata Consultancy Services
10.2015 - 12.2018

ETL Test Analyst

Tata Consultancy Services
09.2012 - 09.2015

Bachelor of Technology - Electrical Engineering

Asansol Engineering College

Similar Profiles

CREATE PROFILE
Sanjana Banerjee