CQA Compliance

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. Webject 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.