|
The
challenge is to automate the process of the insurance company's yearly audit of
Committee on Quality Assurance Hedis is a set of performance measures that the
auditor uses to rate the insurance company's health insurance plans. The
performance measures are in the nature of ratios that are arrived at after
running the reports against the data in the datawarehouse. Trigeo provided a
pure PL/SQL solution instead of standard reporting tools. Stored procedures
were written for the common modules making them reusable across the Hedis set
of measures. Performance tuning, suggesting changes to the design of the
existing schema, designing new temporary tables and query optimization were
crucial for the success of the project apart from coding the modules. The
process was automated using Unix shell scripts.
|
|