Customer Profile
Sector: Litigation
Industry: Legal Services
The Legal Bill Review and Legal Fee Auditing Group reviews legal fee bills by assessing the reasonableness of attorney fees from a legal perspective. The company is one in a handful of law firms in the country specialized in auditing defense costs and attorney legal fees.
Business Situation
The team had a Microsoft Access database that was used to analyze legal fees. The Access system was lacking in functionality, versatility, and ease-of-use. In particular, the users of the system experienced considerable performance and functionality problems while using the system. The system would often stall and consequently would crash because of the massive amount of data that was needed during analysis. Working with this system was not ideal since it was inefficient for day to day operations, not to mention the stress it added to its users.
Solution
Legal Fee Audit System
Before building the system, experienced SQL Server Programmers analysts performed an extensive requirements phase to discover and document the exact business requirements.
After documenting their needs and business process, the SQL Server Programmers team developed the system using the latest technologies. SQL Server Integration Services (SSIS) was used to enable the rapid transferring of mass quantities of data in and out of the SQL Server database. Users are able to quickly import large amounts of raw invoicing data and export large amounts of billing data for data cubes. Analysis Services was used to analyze the data exported by SSIS so that users could analyze billing data quickly via data cubes.
Another essential feature of the system is its high performance. Several users are able to concurrently access and manipulate hundreds of thousands of records. This enables the company to handle any case size and be able to deliver results quickly.
This investment gives a competitive advantage to the company and their clientele and will serve their needs for years to come.