Data Audit Duplicate Rates

Members Not in Coverage table data analysis and preparing SQl Queries .

• Discussion.
• Analysis.
• Data Correction for NULL Health Tier ID for below Company :
  1. Amherst Central School District.

Data audit

Duplicate rates analysis
finding impacted templates and employees.

Data Audit Duplicate Rates

Data correction for Members Not in Coverage table data and execution.

• Data Analysis and Correction of NULL Health Tier ID for below company: - 4 hour
  1. Memorial Regional Health
  2. MGF
  3. Prime Healthcare
  4. Santa Cruz Medical Group
  5. SBSC
  6. Stimson
  7. Town of Cary
  8. UND
  9. CareerBuilder Account
• Data Analysis and Correction of Members Not In Coverage Table Data for below company : - 4h
  1. Stimson
  2. University Health
  3. TIBCO

null health tier and member not in coverage tier analysis and discussion with Harsh and Vinanti

Data audit

Duplicate rates analysis
finding impacted templates and employees.
Updating sheet according to observation.

Data Audit Duplicate Rates and Duplicate Elections

Taking back up for Prime and Decurion before correction on production for Duplicate Rate Corrections.
Dead the duplicate rates from Prime Correction for Plan IDS :- 58,60,69,72,73,74 and RateID - 512
Total corrections - 3640

Data audit for duplicate elections.
Updating sheets and providing updates.

Data Correction of Duplicate Rates on Prime Healthcare & Decurion.
Issue analysis for Decurion.
Discussion.

Data Aufit - plan term election efective

Duplicate Rates analysis

Data Correction of Duplicate Election on PrimeHealthcare.
Email Communication : Data Audit Correction Status.

Data Audit Plan End Election Active
Companies
Precision
Miller Sierra
JCCC
Intrepid USA
Hallmark Aviation Services
Elite staffing

Discussion and analysis

Plan end election active companies distribution
Analysis
And data audit for below companies
AFFCO
Alecto

data correction discussion with team

Discussion.
Email communication.

Data Audit : Plan end election active

Data Audit - Plan End Election Active

Internal discussion
Testing

Testing

Testing
Internal discussion

Analysis discussion with rohan
Analysis for Plan end election active
Document Preparation for Client.
Review Data

data audit - Plan end election active - correction for non impacted and non UHC/White-label company's ,preparing documents for QA analysis.
Correction Done on company :
1. Southland
2. Prime Healthcare
3. Ohio Northern University
4. Superheat FGH - Except 2nd record
5. HMC
Discussion with Vinanati and Rohan

Data analysis and correction of Plan End Election Active for below companies:

1. Karma
2. CAISO
3. SRMC
4. Prime Healthcare
5. Santa Cruz Medical Group

Discussion.

Data Audit -Rate beyond end dates

Data filtration and Analysis of Plan End Election Active.

Data audit-Rate beyond end date.

Rates beyond Date data audit analysis for the companies affected and for the records.

Data audit-Rate beyond end date
Updating sheet and providing status on same.

Data Audit for Rate Beyond End date scenario and Preparing document, analysis data ,discussion with Vinanti.

Data filtration and Analysis of Rates Beyond End Date

Production Build issue fixes and testing

Production Build issue fixes and testing

Data Audit -Wrong member coverage

Finding the impact for the employees through backend , discussing the same for the impacted scenarios  

Analysis of Rates Beyond End Date.

Billing Data Audit script writing for below Scenarios

• Duplicate Records
• Overlapping Billing Records
• Enrollment Does not exists
• Rates does not exists

Data audit Wrong member coverage

Data Analysis of Wrong Health Tier Criteria for below company :
1. Amherst Central School District.
2. Prime Healthcare.

Data Audit - Wrong Health Tier
Amherst Central School District
City of Lynnwood
ILG
Memorial Regional Health
MGF
Prime healthcare
SBSC
university health
Tibco
The Packard Companies
County of San Luis Obispo

Billing Data Audit script review and changes for below Scenarios

• Duplicate Records
• Overlapping Billing Records
• Enrollment Does not exists
• Rates does not exists
• Rates proper but billing continue

Billing Data Audit scripts writing for suggested scenarios by Amruta

Billing Data Audit script writing for Scenarios- Overlapping Billing Records but not in rates

Analysis and data filtration of Wrong Health Tier for below companies :

1. Amherst Central School District
2. CareerBuilder Account
3. City of Lynnwood
4. County of San Luis Obispo
5. ILG
6. Memorial Regional Health
7. MGF
8. Prime Healthcare
9. SBSC
10. The Packard Companies
11. TIBCO
12. UND
13. University Health

• Data Audit of Terminated Employee having Active Election for below company.
  1. Virgin
  2. CSE
  3. Optimum
  Data correction and verification on Optimum(2 Records)

• JIRA Updates.
• Discussions.

Billing Data audit for all companies on Production

Cross verification of Billing Audit Data
Scenario wise Billing Data Sheet creation

Script for Billing Duplicate records correction and script testing on HSPL company

• Written scanning script for below criteria :

1. Find total number of count Generic eligibility rules.
2. Find total number of count Generic eligibility rules having additional criteria more than 9.
3. Find active election count of medical benefit type for all companies(Plan wise). 
4. Find active election count of medical benefit type for all companies(Provider wise). 
5. Find count of election according to employee age for medical benefit.
6. Find count of election according to employee salary for medical benefit.

• Data scanning for above all criteria.