Kiran Kumar

• Client : Anthem healthcare insurance, USA Environment : Oracle 10g, Informatica, windows XP, Description: Anthem is a provider of health insurance in the United States
• It is the largest for profit managed health care company in the Blue cross Blue Shield Association
• As of 2018, the company had approximately 40 million members
• Anthem ranked 23rd on the Fortune 500
• Prior to 2014, it was named Well point, Inc, The company was formed by the 2004 merged of well point, based in California, and Anthem, based in Indianapolis, after both companies acquired several health insurance
• Responsibilities:
• Understanding various Business requirements
• Verify data Type Size from source to Target table
• If any Defect found, report it to developer and fix it
• Verifying the data in target database after ETL process
• Prepared test data for testing
• Verifying the data which is loaded into target database
• Interactions with BA & Dev teams to resolve the issues
• Reporting daily testing status report
• Defect Analyzing and Reporting in QC.

• Emblem Health is one of the United States' largest nonprofit health plans
• It is headquartered at 55 Water Street in Lower Manhattan, New York City.[1] It is a multi-billion company with over 3 million members
• Emblem Healths was created in 2006 through the merger of Group Health Incorporated (GHI) and the Health Insurance Plan of Greater New York (HIP)
• GHI and HIP had been operating as separate companies in the New York region since 1937 and 1947, respectively
• Responsibilities:
• Execute the test case
• He Database objects creation as per mapping/data model, which include constrains keys table naming convention at target table
• Send the Report to test leads
• Perform the test case again where the defect was found to make sure that the application defect 100% free, Blue Shield of California is a non-profit mutual benefit corporation and health plan[6][7] founded in 1939 by the California Medical Association
• It is based in Oakland, California, and serves 4.5 million health plan members and more than 65,000 physicians across the state
• Blue Shield of California was founded as a not-for-profit organization
• As of 2014, it is no longer tax-exempt in California and has been paying federal taxes for several years before that
• Responsibilities:
• Understanding various Business requirements
• Verify data Type Size from source to Target table
• Prepared and ran sql queries to verify Dimensional and Fact tables
• Verifying the data in target database after ETL process
• Prepared test data for testing
• Verifying the data which is loaded into target database
• Interactions with BA & Dev teams to resolve the issues
• Reporting daily testing status report
• Developed, Reviewed & Executed Test Scripts and Designed test data
• Defect Analyzing and Reporting in QC.

Creating daily, Weekly and Monthly dashboards based on the team performance.

Worked Under Business intelligence tools like Tableau and Power BI.

Designed and Developed reports and Dashboards.

Coordinating across multiple team to add reports insight and support reporting needs if needed.