Austin Enrollment Audit impact on Billing Table

Discussion on Billing Data correction post Enrollment team

Pre-Analysis

Discussion with Avnish - On Ticket and Task - Rates Data Audit. 1 hr

WT-6182 Data Audit Work - Ticket to be asked to Avnish - 4 hr

understanding the process from prashant
data auditing
verifying the same on the templates checking for the rate fields mapped
verifying through backend

WT-6182 Data Audit Work -

Auditing

Discussion with prashant about rate verification.
Analysis of rate duplication on mentioned companies.
Verified impact of rate duplication.

disscussing about the duplicate rates with Prashant
verifying the rates through the files and database
carriyng out different scenarios to check for the duplicate rates going on the files

WT-6182 Data Audit Work -

Data Audit

Verification on Production HSPL copy

discussing with prashant about WT-6182
verified the rates on the file as well as in the database
mapping the rate fields on respective templates
reporting about the issue

Verified of rate duplication.
Verified impact on templates after correction done on FDAC.

General Meeting for planning of tasks - 1 hr

Data Audit - 4 hr

Data Audit Scenarios

verifying the rates for company softchoice on HSPL
mapping the rates fields on the templates
exporting the templates
verifying the rates
reporting the employees

verifying the rates for company SBM on HSPL
mapping the rates fields on the templates
exporting the templates
verifying the rates
reporting the employees

Meeting of 'impact of 12 parameters on exported files'
Checked impact of rate duplication.

Testing
Analysis,
Discussions with Dev,
Meetings with Amit,
Audit for UVU and Employebridge's remaining scenarios

Data Audit
Analysis
Discussion with Prashant
Checking the wromg member coverages scenarios
company- Merrillville

Discussion with amit regarding 12 parameters.
Analysis of wrong member coverage and tested same for reported employees and company.

Analysis,
Discussions with Dev,
Meetings with Amit,
Audit for UVU's new scenarios.

Discussion with prashant.
Checked rates duplication and duplicate elections on bulk company.

Data Audit

Discussion with Avnish, Amruta, Yogita and Satya for Scenarios's
RCF Meeting

Data Audit Continued after for new tabs as requested by Satya and Amruta for Impact Report

Checked wrong health tier ID and plan end election active parameters on bulk companies.

Audit and Analysis Continued..

Meeting
Analsysis
Discussion with Satya for scenarios

documenting the duplicate rates scenario
along wit verifying the same on the database

Data Audit Scenarios

Discussion with Yogita and Kanchan for scenarios understanding and Explaination for preparing documents

Analysis Continued

Created document for Plan End Election Active parameter
for impact scenarios and no impact scenarios.

discussion with prashant
verifying wrong members coverage scenarios and documenting the same
verifying the same through database

Checked null health tier id parameter and imapct of same on export files.
Started to create document for same.

verifying the wrong member coverage scenario on company Hallmark

Verifying the scenario employee terminate and enrollment active
Discussion with Prashant
Documenting the Impact and Non Impact Scenarios

Discussion with Kanchan for discussion of the scenarios with Satya and Avnish

verifying the employees for terminated emloyees active election fro company
Hallmark Aviation Services
discussing the scenarios with Prashant

verfying the Rate Beyond End Date Scenario
Documenting simultaneously

Remaining Audit Scenarios- Documents review made by Yogita and Kanchan - 2hr

Data Analysis for meeting - and discussion with Satya and team - 3 hr

verifying for the Plan End Election Active Scenario on company Marin General Hospital

Data Audit Remaining Scenarios and discussion of the analysis documents which were remaining built by team

Data Audit Finding root causes of Plan End Election active for different companies and different scenarios

Templates Information for ONU and Marin General Hospital

12 Points Data Audit - Bulk Companies round 1 reporting

12 Points Data Audit - Bulk Companies round 1 reporting - 5hr

12 Points Data Audit - Bulk Companies round 1 reporting - 5hr

Data Audit - 4 hr

Data Audit

Data Audit on duplicate rates for below companies
Asml
City of Durham
ESBA
GBAPS
Liberty Hospital
Lily
SBM
STEP

Data Audit Scenarios -

Analysis and Root cause - Marking for discussions with Satya and Avnish
Making Data and Analyzed companies as marked -

Discussion for the scenarios with Satya and Avnish.

Analysis and Root cause -Company wise updates on each tabs upto plan end election update.

Data Audit

Data Audit for Plan End Election Active for companies
Austin
CityOfBaytown
cityOfcasselberry
cityof coalinga
clarke
CSS
El Darado
Fazoli
discussion with Prashant for related scenarios

Plan End Election Active Data Audit for Companies :
Hallmark Aviation Services
Jani King
JE Dunn
Ken Ton
LHP
Liberty Hospital
MarquetteTransportation
Chmc
Ehmc
GGH
Srmc

Data Audit continued - scenarios testing on 30 company/ 52

Plan End Election Active Data Audit for Companies :
ASML
Karma
AutoChlor
BDG
St Rose
CEI
california golf

Plan End Election Active Data Audit

Data Audit on 7 companies - plan end election active

Data Audit of terminated employees active election on below companies:
AFI
FRMC
St Rose
Blue Coat
City of Bellevue
City of Casselberry
City of Durham
City of West Covina

Plan End Election Active Data Audit on 4 companies

Data Audit of terminated employees active election on below companies:

Data audit on - 6 companies - Plan end election active

Analysis for Rates Beyond End Date Data Audit

Rates Audit - Meeting and conveying with the completed companies details list to Avnish.
Remaining Rates Audit continued

Data Audit for Terminated Employees Active Elections

Data Audit -

Terminated Employees's Election Active - Remaining Companies

Data Audit analysis for Rate Beyond End Date
Reporting templates for 30 companies for Plan End Election Active

Terminated Employees Active Election reporting Templates for 10 companies
Data Audit / Analysis For Null Health tier ID

Terminated Employees Election active details to avnish
and Rates Beyond end date analysis

Data Audit - Null Health Tier ID's and Wrong Health Tier ID'S

Data Audit for NULL Health Tier ID and Wrong Health Tier
Reporting the scenarios to Prashant
Companies :
Amherst Central School District
City of Des Plaines
DMA
California Golf
Mercy Radiology Group
Santa Cruz Medical Group

Wrong Members covered and Missing companies form Wrong health tier ID's data audit

Data Audit For Wrong Health Tier
Reporting the scenarios to Prashant
Companies :
Stimson
Town of Cary
UND
Member not in coverage Table
Companies :
COSB
ESBA
GBAPS

Wrong Members covered - Cases - Analysis of some records and impact analysis on
Documentation of remaining scenarios.

Data Audit for Member Not in coverage Table
JE Dunn
LHP
Mendocino Coast District Hospital
Mercy Radiology Group
Prime Healthcare
Stimson
TIBCO
UND

Data Auidit Meeting and Discussion

Remaining Documents verification and editing some scenarios

Data Audit for the scenario Member Not in Coverage Table
for the company UND (216 records )
Documenting the scenarios for the Data Audit

Data Audit Discussion with Amit and Satya for all the tabs

• Finding out new cases to eliminate the impacted companies and proceed with data correction
• Combining queries to share with Avnish for data analysis and clubbing the same
• Sharing queries with Avnish for Data Analysis and Discrepancy finding of records through export files

Data Audit Documenting the scenarios

Data Audit

2 hr Training session on Data Audit Overview
Discussion with kanchan related to Data
Meeting with Avnish and Prashant
Go through related document

Data Audit 2nd Round
Duplicate Elections for companies
Auto-Chlor
AYDAH TRADING LLC

data audit for the duplicate rates for 13 companies

reviewing the analysis for Arpita and ateeque

Data Audit done on Duplcate rates.

Audit and Audit Scenarios discussion

data audit for the duplicate rates for 13 companies

reviewing the analysis for Arpita and ateeque

Consolidating the data for duplicate rates (Fetching the templates and verifying )

Verification and Analysis of reported issue on Duplicate rate
Company Name: CEI
Company Name: City of Denton
Company Name: City of Oceanside

1 h - KT by Kanchan about duplicate rate issue
4 h - Analysis on provided companies for duplicate rates issue.

Verifying through single record for duplicate rates
and reviewing Ateeque , Arpita's work

consolidating the data and fetching the templates for duplicate rates through single record

Consolidating data for duplicate rates Employbridge
Verifying the analysis provided by arpita and ateeque

Data Audit for EmployeeBrige company

Data Audit for Rates Beyond End Date
Company GFC

Data Audit for Duplicate rates

Data audit Reverification on 13 companies for duplicate rates

Reverification for the duplicate rates
verifying the templates for the 13 companies

Re verification of duplicate records

• Issue found in previous result - records may export on file
  Duplicate rates new issue found -
  Records identified for re-verification

Duplicate Rates -

Files re-export and verification

• On Liberty hospital - discussion and verification and backend check with kanchan

Restoring the companies
Exporting the files from HSPL to bring down the file to zero records

Consolidating and extracting the exported files and verifying the same
Sent exported files from 7 companies to Avnish

Discussion with Avnish
Verification of Tables for Data Audit
Analysis of created stored procedure related to the same