P. Narayana Reddy

Company Overview:

• State Farm is a life insurance company that consists of modules like new business, policy service, re-insurance agency, Moment, client data bank, and accounts. New business is a business brought by the agent, and this business is called a proposal. Proposal will be approved by underwriters to convert into a policy. These underwriter check for the all the eligible criteria like client’s annual income, age, health, etc. along with this proposal needs more amount of money in suspense to convert into a policy. This includes internal and external funds maintenance for the insurer. Agency module maintains all the details about individual and company agent. Moment module maintains modifications details of the insurer.

Roles & Responsible:

• Involved in functional study of the application.
• Running the Jobs/Workflow for ETL process.
• Prepared and ran SQL queries.
• Designed & Executed test cases.
• Verifying the data in target database after ETL process.
• Performed column data mapping between source & target database.
• Prepared test data for testing.
• Defect Analyzing and Reporting in QC.
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report.

Description:

Saudi Dispatchers will create Overfly requests for the flights, which have been displayed through the search criteria. The Overfly request for Saudi flights of which at least one leg has not departed and not yet requested.

• Understanding the functional requirement documents.
• Test cases writing based on the functionality.
• Test case writing, execution and logging Defects.
• Performed functional testing and regression testing.
• Involved in designing frameworks and executed.
• Preparing test data, executing scripts, and analyzing results.