Legal Fee Audit System

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. An efficient solution was needed to handle their massive amount of data.

Solution

Legal Fee Audit System

Before building the system, our 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.

Production Database System

The botanical museum is managed by the Chicago Horticultural Society …

Pallet Production System

The company is a manufacturer and distributor of quality wood pallets…

Title Management Database

The book supplier is a full service resource for customers. The compa…

  • Large Manufacturing Plant

    Open quoteEvery major project has gone live by the desired target date, and runs problem-free.Close quote

    - Vice President

  • Plant Museum

    Open quoteSQL Programmers upgraded our Plant Records database and Plant Production database. The new systems provide access to a scalable, reliable and user-friendly system for any user within our networks.Close quote

    - Director of Information Systems

  • A Regional Philanthropy Foundation

    Open quoteYou continually translate our business needs into successful projects within budget. Thank you!Close quote

    - Manager of Information Technology

  • A Meat Distributor

    Open quoteSQL Programmers did an outstanding job translating our needs and wants into a workable program. After the development, we have been very pleased with the support. We are currently working on Phase Two!Close quote

    - Operations and Process Support

About us

SQL Server Programmers is a database consulting firm specializing in Microsoft technologies. For over twenty years, we have assisted hundreds of companies nationwide. Our staff has extensive experience working in various industries to develop systems that manage business information. We develop desktop database solutions and integrate these solutions with the web to create data-driven websites. Our firm is a Microsoft Certified Partner, and our developers are Microsoft Certified Professionals.