Hema Sethia, SAFe Certified

GW Test Data Lead

Toronto, ON E:hemabhutoria @gmail.com P: 647-***-**** Immigration status:Citizen

Profile Summary

Over 10 years of IT experience in Quality Assurance and testing, worked as ETL/GW Tester

Strong Insurance background with specialization across auto, property and life insurance in Guidewire Claim Center/Policy Centre and Billing Centre for reports for Fraud Detection, Special Investigation Unit, KYC

Strong Test Methodology Background in both Waterfall & Agile– Including Defining Test Strategy, Plan, Test Scenarios/ Cases in alignment with Business needs, Sprint Planning, Traceability, Test Management and Reporting, Defect Triage Meetings, Performing Retrospections and Continuous Improvement.

Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking defects using HP Quality Center, HP Alm,Rational Clear Quest, Jira,Confluence

Expertise in writing complex SQL queries to access the data in Oracle database to execute back-end testing and perform data validation.

Deep expertise in handling large scale migration projects across with specialization in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch

Ability to drive change by managing relationships across business and IT stakeholders and being closely engaged with the development team to ensure timely completion of QA task and early risk identification to maintain database integrity

Strong Analytical Skill, Interpersonal skill and Communication skill with a track of leading discussion in Agile Ceremonies, project review meetings and contributing over and above designated responsibilities to move project forward.

Tools

Test Management: Test Track, HP –ALM, Jira, Confluence

RDBMS: Oracle 8i, 9i, 10g, MS Access, and SQL Server,Hive and Impala

IDE: Message Processor, Toad, Clear quest, Manage Now, BMC Remedy, SQL Developer, Eclipse

MS Office excel: Status reporting, Building execution tracker and tools for testing purpose.

Professional Experience

Cognizant Technology Solutions, Toronto (Nov 2016-Present)

Project 1: TD Data Foundation Acquire and Ingest Team (July 2020-Present)

Acquire and Ingest process in Data Foundation effort, refers to the process of acquiring data from various source systems and ingesting them into EDPP data store on Hive. SIT scope for A&I effort will be to validate the additions/modifications/production issue fixes done to the ingestion process for the different source systems. Testing include validation of data load(initial/delta) from source (RDBMS/flat files) to target tables in Hive.or Impala

Role: Acquire and Ingest Test Lead

Responsible for Project data quality and analytics validation deliverables across the project

Hadoop layers data flow validations.

Write hive quires and prepare scripts to validate data between source and target systems in Hive and Impala

Test data preparation and planning to facilitate the testing of BI reports in line with the source and Data warehouse data.

Verification and validation from HDFS to the BI Reports, UI and data validation test scenarios.

Triage Day to day Production Issues and Enhancements testing and impact analysis.

Design End to End data verification and validation strategy from Source to HDFS and the BI Reports.

Technical support to the test team to effectively validate and streamline the data warehouse specific rules and validation process.

Project 2: TD Bank Channels Team (Mar 2020-July 2020)

Channels Teams support Data provisioning for Projects under Channels BU Including Insurance projects. We support Mainly EW, EA, CMOB, TDCT Data setup. As part of transformation Projects, it developed CA TDM portal for QE users to get required Data. It has been implemented in CMOB and IRM. CA TDM Portal Development is going on for Insurance.

Role: Insurance Test data Lead

Lead the GW Policy center/Claim centre automation plan by providing KT on Critical GW Business SPOC for Insurance data entry request raised across by 8 different team interacting with channels team

Data Manufacturing- Creation of production like data in Test Environments.

Manufacturing data for the complete end to end.

Registering GW accounts in online Myinsurance portal.

Validation and verification of Duplicate fields, Data continuity, Row counts, Joins and ECTL columns.

Review of ETL Specification documents and data models.

Monitoring data request status through various tools / analysis and implementation of corrective actions.

Creating complex sql script for Policy Centre/Billing centre/Claim centre business scenario to be used by CATDM developer .

History events on a claim

Rules, activities and messaging events

Payment process

Reimbursement schedules

Approval activities

New Activities open, closing functionality

Document screens, ledger screens, payment screens etc.

Project 3: GPS TD Insurance (OCT 2018—Mar 2020)

TD Insurance is Canada’s largest direct insurance writer and in 2015 had a gross earned premium of 4.2B CAD. TD Insurance’s home and auto products are distributed by TD Insurance Direct Agency Inc. Its insurance products for professional and alumni groups are underwritten by Security National Insurance Company and distributed by Meloche Monnex Financial Services Inc. in Ontario, by Meloche Monnex Insurance and Financial Services Inc. in Quebec and by TD Insurance Direct Agency Inc. in the rest of Canada. TD also offers credit protection, travel insurance and life and health.

Role: QA Lead

Testing lead for all functional testing efforts

Hands on experience in analyzing, testing large scale Claim Center and Billing center applications in a dynamic environment.

Preparation of Test Cases and Test scenarios based on the User Stories, created in Jira, Confluence

Participation in the requirement analysis and Solution meetings

Interacted with different integrations services like Rating, Motor Vehicle, Address validation and Document & Forms

Tested various major functionalities like Policy Submissions, Changes, Cancels, Reinstate, Rewrites and Renewals.

Performed Policy and Billing Center Integration Testing on various Billing Instructions.

Execution of billing batch jobs such as the batch for Invoicing, delinquency workflow, Write-Off, disbursement and payment apply batch to trigger the billing transactions

New screen for Credit Card processing, Cheque Recon Apps

Performed System and Interface availability check in Stage and Test environments

Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data

Providing support to the automation team and providing them with business - critical scenarios to automate as well and helping them with regression scenario execution.

Involved in providing KT for all the new resources of the team and KT on Claim center and transactions handled to other Claim Center teams

Project 4: MI Reporting (RSA) (Nov 2016-Sept 2018)

This project was mainly for migration of claims related data from Legacy HUON system to Guidewire and finally to the MI reports. Earlier claims and policy was generated from Huon. Now claims data will be generated from Guidewire and policy related data will come from Huon as usual.

Role : QA Lead

Worked as a QA Analyst to assist in testing Guidewire system related to claims and policy applications

Attended BRD and FSD review meetings conducted by the business and technology partners. Review the BRD, FSD and TDD document and conducted feasibility and impact analysis.

Prepared test plan and design test cases, test scripts to validate claim reports

Analyzed, documented and maintained Test Result and Test log as well as logged Defect in Test track

Strong experience in Claims administration for personal and commercial property and auto claims – FNOL, Assignment, setup and coverage verification, investigation, reserves and financials, large loss setup and thresholds, recovery (subrogation and salvage).

Expertise in Payments process, check processing, Interfaces and batches.

Performed System and Interface availability check in Stage and Test environments

Worked on Approval activities of a claims New Activities open, closing functionality

Executed and validated data mapping for Claims and claims party via EDI into RDC through Oracle PL/SQL.

Successfully created and executed complex SQL Queries on SQL Server Database using Teradata to verify and validate data.for data analysis and reconciliation

IBM, India (Oct 2007 – Feb 2014)

Project 5: IKEA - CODA

The scope of the project was to do major enhancement to the existing online applications, performing functional and acceptance testing, proving fast and secure online information from third parties.

Role : QA Lead

Analyzed business requirements, technical design/specifications to ensure testability of the product being developed and created Functional and Regression Test Cases.

Set-up ALM for the project including requirements/ test case upload and creation of requirement traceability matrix

Performed functional/ regression test execution in ALM, logging defects, generating automated daily reports through ALM dashboards.

Created multiple SQL queries to identify and re-use existing data. Performed both backend validation and GUI testing.

Managed external risks and dependencies pro-actively– environment, release management and ensured on time delivery.

Assisted Business users to identify and create Test data for UAT testing

Project 6: Safmarine Application Maintenance and Support

In the BI -ETL and BO sphere, new interfaces were being developed which involved recreating new ETL procedures, new extraction sources using MQ/MP as well as changes to the transformations PL/SQL procedures.

Role: Quality Analyst

Handled E2E Life Cycle of incidents – from initiation to implementation.

Worked closely with business analysts and technical team for impact assessment on downstream and upstream applications.

Worked closely with development in creation, review and implementation of Stored Procedures, Triggers, function and views using Oracle PL/SQL based on business/ incident requirements.

SPOC for Message processor/SQL Loader- involved in reviewing designs, preparing estimations, creating test cases/cycle plan/execution plan and co-ordinating with another competency involved.

Facilitated the code migration between Development, Test, Staging/ UAT and Production

Identified and communicated issues and business risks relative to testing and implementation

Ensures that defects uncovered in the test are documented, summarized, and utilized in post-implementation reviews to improve the development and testing processes.

Provides detailed status reporting on work efforts - summary on defect, effort and schedule

Project 7: Norfolkline B.V. Migration Support project

COSMOS is a set of around 170 applications that keep track of almost all the business areas of the Transport industry. Our team was supposed to provide support/resolution for day to day issues like billing, invoicing, system maintenance and other such activities

Role: Quality/ Production Support Analyst

Worked as a COSMOS application Maintenance and Support (SME).

Handled day to day incidents by data fixing (using SQL scripts), code studying, and debugging of T-SQL store procedure in Sybase alongside development.

Responsible for assessing the upstream/ downstream impacts and designing test cases for both functional and regression aspects.

Reviewed test cases with BA’s, development and technical teams to ensure adequate coverage.

Performed functional/ regression test execution, identification and reporting of issues/ bugs to development.

Gained E2E shipping business knowledge - booking creations, invoice generation (sales, purchase and hauler), shipment of bookings through ferry services, freight forwarding.

Preparing monthly metrics data and Coordinating Quality Assurance reviews, as required.

Education

Bachelor of Engineering, Information Technology

M.C.K.V.I.E, Kolkata

Sep’03 to Jun’07

Contact this candidate