Divya Pargavi Balasubramanian

• Understand business requirements related to insurance data like policies, claims, underwriting, premiums, and reinsurance.

• Analyze source-to-target (S2T) mappings, data models, and transformation rules from business analysts and data architects.

• Verify data completeness, consistency, and accuracy across staging, transformation, and target layers.

• Validate insurance-specific fields like Policy number, claim status, sum insured, coverage dates, Loss ratios, deductible amounts, premium types.

• Ensuring no data truncation, duplication, or null propagation in critical fields.

• Perform count checks, checksum validations, and sampling between source and target.

• Validate insurance dashboards and reports fed by ETL pipelines (e.g., renewal rates, claim volumes).

• Ensuring accurate representation of aggregated data in tool as SSIS.

• Experience in SDLC and Agile methodologies such as SCRUM.

• Involved in Data validation & verification, ensuring the data accuracy.

• Involved in validating the ETL pipelines and data transformations using SQL.

• Worked on functionalities such as claims, Loss Loading, Ratings.

• Identify and correct errors in policy, claims, and customer data.

• Standardize customer, product, and agent data for consistency.

• Handle missing values and ensure data quality before analysis.

• Attended agile planning and refinement meetings to break down requirements into sprint JIRA stories.

• Actively participated in daily scrum calls to provide QA status updates, highlight any blockers, and coordinate testing efforts with the broader Agile team.

• Ensuring that QA tasks aligned with sprint goals, communicated test progress, defect status, and environment readiness, and escalated critical issues to the Scrum Master and Product Owner when necessary.

• Represented the offshore QA team’s progress and resource availability, and helped synchronize testing timelines with development handoffs to ensure timely defect resolution and quality delivery.

• Understanding Functional and technical perspectives from Requirement walkthroughs.
• Involved in Project discussion with other interfacing projects.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Experience in SDLC and Agile methodologies such as SCRUM.
• Analyzing requirements and creating and executing test cases.
• Involved in Data validation & verification, ensuring the data accuracy.
• Involved in validating the ETL pipelines and data transformations using SQL.
• Test Case Execution and Ad hoc testing.
• Performed Integration, End-to-End, and system testing.
• Involving in Functional Testing & Regression Testing.
• Involving in writing complex SQL queries to verify data from Source to Target.
• Performed data validation testing by writing SQL queries.
• As Offshore Team Lead, used to manage the team members who were in different locations.
• Coordinating the tasks performed in the project.
• As this was a new project, took the KT from the counterpart & have given a reverse KT for better understanding.
• Documenting the information by making presentation with the relevant information needed for the project.
• Reporting the project status reports to the client, onsite & offshore managers.
• Used Quality Center for creating and documenting Test Plans and Test Cases and registering the expected results.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking, and reporting.
• Experienced in retesting the existing test cases with the different kinds of source systems for different periods of data.
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
• Environment: HP Quality Center, Windows, MS Excel, DB Visualizer, Tableau, Microsoft Teams.

• Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle.
• Develop Test strategy, test plan/design, execute test cases, and defect management.
• Quality Management - Knowledge of quality management methods, tools, and techniques.
• Discussing the new requirements, business enhancements and scope of the Release with the team.
• Performing Impact Analysis for changes made in the release.
• Performing estimation, planning and scheduling in consultation with the clients. Get the necessary sign off from the clients.
• Meeting with various stakeholders, application teams, interfacing teams, network teams and devise an agreeable and feasible solution for a development and testing environment.
• Periodic review meetings with all stakeholders and other teams to discuss the status of the project and highlight any issues or risks.
• Cascade status reports regularly to stakeholders, highlight risks and issues and facilitate resolution as appropriate.
• Interact with other teams to analyse cross module dependencies and also facilitating integration testing and user acceptance testing.
• Post-Implementation support as required.
• Knowledge transition to the new team members.
• Environment: Mainframe, SharePoint, Microsoft Teams, MS Excel, Windows, Web Application.

• Interacted with Developers and Business analysts regarding requirements, test scenarios, and defects.
• Analyzed the ETL design documents to understand the logic.
• Performed troubleshooting the loading failure cases, including database problems.
• Written the test cases based on the requirement and executed the test cases.
• Performed functional testing, integration testing, regression testing, system testing, UAT and Database testing through different iterations.
• Performed data validations between summary files and extract files after ETL flow.
• Performed various comparisons between Landing zone tables and tracing tables generated during the ETL process.
• Verify the Data flow (Data mapping, Counts) from source to target.
• Verify the data Transformation logic from source to target works as expected.
• Verify the Database structural changes if any, DB fields and field data are loaded without any truncation.
• Perform Data validation like - Valid values, null value checks, duplicate checks, and blank record checks.
• Verify and validate the data integrity.
• Participated in overall end-to-end testing.
• Created regression test cases and used RTC for defect tracking.
• Included in meetings with the development teams to investigate and correct software bugs and defects based on the testing results.
• Created documentation for the client's future use.
• Environment: MS SQL Server, Informatica, Aginity Workbench for Netezza, PuTTY, MS Excel, OBIEE 11g.

• Analyzing existing requirements and communicating to the business and the developers.
• Participating in functional and business requirement walkthroughs and initiate System testing activities.
• Participating in functional walkthrough and involving in Test Scenario preparation, script preparation activities.
• Create and Manage Defect Reporting Forms for all the assigned Releases.
• Responsible for creating test plan, test cases, and uploading the test cases in ALM.
• Monitoring the test timeline and making sure there is no slippage in it.
• Co-ordinate with Onsite team and working on test timeline and Test approach.
• Plan and align Test resources for respective Projects.
• Identifying the scope for Automation testing & providing test data.
• Reporting project status to clients and coordinating with Onsite team through status emails and conference calls.
• Understanding the business and functional requirements.
• Preparation of Test Plan, Project Plan and Test Strategy documents.
• Preparation of the Requirement Traceability Matrix (RTM) for test coverage.
• Environment: MS SQL Server, OBIEE 10g, SharePoint, MS Excel, Windows, HP Quality Center (ALM), WebEx.