Database Audit System – A Legal Services Firm

Litigation and legal services firm logo

This leading Chicago-based litigation company has a prominent record of important legal victories on behalf of some of the country’s largest public and private companies. The Legal Bill Review and Legal Fee Auditing  Group is one in a handful of law firms in the country specialized in auditing defense costs and attorney legal  fees by assessing the reasonableness of attorney fees from a legal perspective.

Challenge Challenge - Mountain without Flag

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 experienced considerable performance and  functionality problems while using the system.

The database would often stall and/or crash because of the massive amounts of data analysis needed each day.  Working with this system was not ideal since it was inefficient for day-to-day operations and added stress to  users.

Solution Solution - Mountain with Flag

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.

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. The internal web based system is highly customized to fit the requirements  needs of the audit group, and provides a specialized and expeditious means to discover legal overcharges in a  high volume of invoices.

latest news

01

5 Reasons to Work with a Local Software Development Firm Over a Large Tech Giant

Navigating through the software development industry can be difficult. When taking on a development project, choosing a provider can take longer than the actual project if you have no idea where to begin! Let’s lay out your options: Forget development, continue business as usual or select an off-the-shelf package (Here are 3 ways forward thinking […]

02

7 Reasons to Consider a Cloud Migration [Webinar]

November 29, 2017  –  1:00 PM CT Oops! This webinar already took place! To watch a recording of this webinar, please fill out the form below. An email will be delivered immediately to your inbox with a link to the recorded session. Meet the Speakers: Tony Cichella is a Senior Solution Architect at alligatortek, a leading […]

03

10 Benefits of Outsourcing You May Not Have Considered

Outsourcing is the business practice of shifting tasks, operations, jobs or processes to an external contracted third party for an extended period. To reduce costs or improve efficiency, companies pay an outside organization to work on a project they could not otherwise do themselves. Whether employees don’t have the skills or the scope of the […]