Case Studies
Project Profile for the Legal Fee Audit System
Executive Summary
Company
Litigation and legal services company is a leading Chicago-based litigation with a prominent record of important legal victories on behalf of some of the country's largest public and private companies.
Solution Description
The internal web based system is highly customized to fit the requirements needs of the audit group.
Benefits
Provides a specialized and expeditious means to discover legal overcharges in a high volume of invoices.
Software and Services
- ASP.NET 2.0
- Microsoft Windows XP
- SQL Server 2005
- SQL Server 2005 Analysis Services
- SQL Server 2005 SSIS
"You did an outstanding job developing an application for my group. The application met all of our needs (and more), was well thought out, and was delivered on time and on budget. Plus, your team is just good to work with. I'd use them again in a heartbeat."
Joe
Manager
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 lacked 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 amounts of data that was needed during analysis. Working with this system was not ideal since it was inefficient for day to day operations along with the stress it added to its users.
Solution
Legal Fee Audit System
Before building the system, experienced alligatortek analysts performed an extensive requirements phase to discover and document the exact business requirements.
After documenting their needs and business process, the alligatortek 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.