Executive Summary
Brevium Inc. is a software company that provides doctors with
software to reactivate lost patients, to keep track of patients due for
appointments, etc. Currently Brevium only serves a small number of specialized
doctors, including ophthalmologists and dermatologists, but management would
like to add the ability for Brevium software to be able to serve more types of
specialties. Part of this expansion includes adding more insurance codes to our
software. A consultant has been hired to provide us insurance codes. The codes
are changed into regex form and put into our database. Now the test team has
been given the responsibility to test to make sure that all the codes in the
database are in the spreadsheet and vice versa. Also all codes need to be
verified to be sure they apply to the specialty we are working with and any
missing codes need to be added. The VBA script I created has been helping use
look through all the codes to see which are missing, which are extra, and which
have errors in them.
No comments:
Post a Comment