Data Analytics

Database

• Check PostgreSQL processes and locks

• Clean and update database records for correct zip format and date of loss on claims

• Duplicate JSON field to under new key for multiple records

• Fill in claim fax numbers from other tables and sources

• Filter problematic last names and zip codes for claims, and update database with fix

• Fix State given address, check sum of charges, verify facility name given NPI, and update database

• Insert and update records info with other tables accounting for exact duplicates

• Mask confidential fields in JSON and store processed records in database

• Update pending and rejected claims progress flags

• Store ASC X12 alerts automatically cross verify status with other tables

• Store and manually update ASC X12 alerts table

• Store records of already masked claims with auto-generated script to avoid future duplication

• Track progress and update input from employee A

• Track progress and update input from employee B

• Track progress and update input from employee C

• Update pending and rejected claims progress flags

• Update problematic claims status after resolution

• Use data warehouse to fill in missing ICD code descriptions and update records stored