Summary
Overview
Work History
Education
Extra-Curricular Activities
Skills
Awards
Internship
Certification
Timeline
Generic
SUBHRA MANNA

SUBHRA MANNA

Software Test Engineer
Kolkata

Summary

With over seven years of experience in Manual, ETL, Database Testing using SQL Server and MySQL, and Web-Based Application Testing, I ensure the highest standards of quality and reliability in software products. My expertise encompasses a broad range of testing methodologies, enabling me to effectively identify and resolve critical issues. I possess a strong background in the Life Insurance domain, including Billing, Retirement, and Pension. I am seeking career growth opportunities in Software Testing with a reputable organization.

Overview

11
11
years of professional experience
2014
2014
years of post-secondary education
1
1
Certification
3
3
Languages

Work History

Associate

Cognizant Technology Solutions
02.2022 - Current
  • Experience working in Life Insurance and Annuity Domain.
  • Extensive experience in various Lines of Business (LOBs) including Term Life, Index Universal Life, Whole Life, and Variable Universal Life.
  • Proficient in multiple Annuities LOBs such as Index-linked Annuities, Fixed Indexed Annuities, Fixed Annuities, and Variable Annuities.
  • Skilled in framing and executing SQL queries in SQL Server and SAP HANA databases based on business-provided mapping documents.
  • Expertise in validating source and target data across different layers (landing, staging) using transformational logic provided by the business through the ETL tool QuerySurge.
  • Experienced in validating API responses by cross-verifying with backend database entries using SQL queries, ensuring data accuracy and consistency between the API layer and the underlying data source.
  • Wrote and executed complex SQL queries to validate API output against relational database records.
  • Validated successful data insertion through API by verifying HTTP status codes, response messages, and backend database entries.
  • Ran and monitored scheduled jobs in the CA Workload Automation (CAW) application to ensure timely and successful execution of batch processes.
  • Monitored Informatica ETL workflows and sessions, identifying failures or performance issues, and collaborated with development teams for resolution.
  • Adept at designing and executing test plans, test cases, identifying defects, and collaborating with development teams to resolve issues, particularly in areas such as policy center, claim center, and billing center within cloud-based insurance applications.
  • Experienced in Agile methodologies.
  • Reviewed, evaluated, and identified requirements for testability.
  • Skilled in developing Effort Estimation, Test Scenarios, Test Cases, Test Data, and Test Evidence.
  • Proficient in various types of Software Testing, including Functional Testing, System Integration Testing, Regression Testing, and End-to-End (E2E) Testing.
  • Effectively managed defect tracking systems, maintaining clear communication channels with stakeholders regarding bug status and resolution timelines.
  • Supervised entire testing projects, including direct client handling and follow-up.
  • Successfully managed offshore junior QA resources to ensure seamless workflow integration within the team.

Senior Associate

Tata Consultancy Services Ltd.
07.2016 - 11.2021
  • Well experienced in pension and retirement products.
  • Proficient in creating policies within the ORYX application and verifying commission and Fund Based Renewal Commission (FBRC).
  • Experienced in verifying retirement strategies and retirement plans across various products.
  • Reviewed, evaluated, and identified requirements for testability.
  • Kept test cases updated with current requirements.
  • Skilled at developing & reviewing Test Plan, Effort Estimation, Test Scenario, Test Case, Test Data & Test Evidence.
  • Experience in Defect Life Cycle Management in JIRA.
  • Increased customer satisfaction with timely and effective resolution of reported issues.
  • Worked closely with developers to reproduce and troubleshoot complex bugs, facilitating timely fixes and enhanced product quality.
  • Documented testing procedures for developers and future testing use.
  • Managed resources effectively, ensuring optimal team performance and productivity.
  • Assessed software bugs and compiled findings along with suggested resolutions for development team members.
  • Passion for constant adoption of new tools and methodologies.

Executive Trainee (Banc assurance Channel)

SBI LIFE INSURANCE CO. LTD.
04.2015 - 01.2016
  • Call potential clients of SBI to expand the customer base
  • Interview prospective clients to get data about their financial resources and discuss existing coverage
  • Analyze clients' current insurance policies and suggest additions or changes
  • Handle policy renewals
  • Resolved customer's issues and complaints regarding operational matters - Handled all queries and client feedback in a professional manner

Intern

Techshu Consultancy Pvt. Ltd.
04.2014 - 06.2014
  • A Complete Study of Digital Marketing in terms of Keyword Analysis, Social Media News, Events and Social Media Campaigns
  • Tool Used: MS Excel, Power Point

Education

B.Sc. (HONS.) - COMPUTER SCIENCE

VIDYASAGAR COLLEGE - UNIVERSITY OF CALCUTTA

W.B.C.H.S.E - SCIENCE

KUMAR ASHUTOSH INSTITUTION (MAIN)

W.B.B.S.E - NA

SINTHEE RAMAKRISHNA SANGHA VIDYAMANDIR (FOR GIRLS)

PGPM - MARKETING (Minor-Finance)

GLOBSYN BUSINESS SCHOOL
01.2013 - 01.2015

Extra-Curricular Activities

Participated in various cultural program and sports held in school as well as college. Fund raising for the GBS main student event, Serendipity. Active participation in arranging live project 'Serendipity 2013' (department of cultural activity).

Skills

Agile, STLC, Defect Life Cycle,  Functional Testing, Manual Testing ,  Integration Testing, Web  application Testing and Database Testing.


Database: SQL Server, SAP HANA,SQL  Server Management Studio. 


Tools: Oryx, HP ALM, ADO, Rally, JIRA and WINSCP-File transfer tool, Beyond  Compare, Query Surge.

Awards

  • Star Performer of the Month Award in TCS, 09/20/19
  • Champions League - Best Team Award in TCS, 01/14/19
  • Star Performer of the Month Award in TCS, 08/21/17
  • Awarded by the Certificate of Appreciation for the budget achievement in SBI LIFE
  • Got prizes for academic performances in school

Internship

Techshu Consultancy Pvt. Ltd., 04/21/14, 06/20/14, A Complete Study of Digital Marketing in terms of Keyword Analysis, Social Media News, Events and Social Media Campaigns., MS Excel, Power Point

Certification

Microsoft Certified AZ-104 course (Azure Administrator Associate)

Timeline

Microsoft Certified AZ-104 course (Azure Administrator Associate)

03-2025

Associate

Cognizant Technology Solutions
02.2022 - Current

Senior Associate

Tata Consultancy Services Ltd.
07.2016 - 11.2021

Executive Trainee (Banc assurance Channel)

SBI LIFE INSURANCE CO. LTD.
04.2015 - 01.2016

Intern

Techshu Consultancy Pvt. Ltd.
04.2014 - 06.2014

PGPM - MARKETING (Minor-Finance)

GLOBSYN BUSINESS SCHOOL
01.2013 - 01.2015

W.B.C.H.S.E - SCIENCE

KUMAR ASHUTOSH INSTITUTION (MAIN)

W.B.B.S.E - NA

SINTHEE RAMAKRISHNA SANGHA VIDYAMANDIR (FOR GIRLS)

B.Sc. (HONS.) - COMPUTER SCIENCE

VIDYASAGAR COLLEGE - UNIVERSITY OF CALCUTTA
SUBHRA MANNASoftware Test Engineer