Analysis and code understanding

Analysis of election Import.

What data is already available - Employee, Spouse, Child Election.
How members of one elections are maintained and then inserted into Coverage table.
How the decision is taken if the existing election needs to be terminated.
How eligible Employees, Spouse and Child are maintained.

analysis

Analysis on probable solution,
Discussion with Jaideep
Defining scope of the task

Code Analysis
Analyzing how proposed solution can be inserted into existing system.

Code analysis, creating document and discussion with Jaideep.

Doc review

Coding, Discussion with Gaurav

Working on Hash table to send all related records to bad if one is invalid.

Completed Bad file part and started with Same Coverage.
Same coverage has a Enrollment ID discrepancy. The ID's are used in Rate, SubPlan enrollment etc which will not be available in new way. started working on same.

Discussion with Jaideep,
debug to analyze Enrollment ID discrepancy
redesign solution to handle termination date issue
analyze why existing coverage and rates are checked

Solution re designing,
Discussion with Jaideep, Vinayak,
Debug code
started with new solution

Create code skeleton for decisions based on coverage and termination date.

Collecting data from Coverage table for current processed employees and store in hashtable

Finished with decision making if enrollment needs to be terminated or updated depending upon coverage data, termination etc.
Actual Termination / update query generation is remaining.

Generate query for coverage. This coverage will be checked against coverage given in file.

Unit testing
Corrections wherever needed
Enrollment key deletion from hashtable if not going to be processed.

code review

Code Review

code review

LB testing and discussion

Coding

Re opened issue analysis and Code checkin

test case writting

Internal discussion with jayshree

Scenarios explanation to sanjana

Analysis of document and attached test case
created election import template on LB on "For QA FDU For HSPL" company.

Testing
Jira update
Internal discussion with jayshree

Help to sanjana to execute testcases.

Coding, Unit testing.

Testing
Internal discussion

• Help to sanjana for scenario testing
• Test-cases discussion

Testing

Testing on stage

Testing on production