Eli Lilly and Company is a leading, innovation-driven corporation committed to developing a growing portfolio of best-in-class and first-in-class pharmaceutical products that help people live longer, healthier and more active lives. Lilly products treat depression, schizophrenia, attention-deficit hyperactivity disorder, diabetes, osteoporosis and many other conditions. They are committed to providing answers that matter - through medicines and information - for some of the world's most urgent medical needs.

We have provided IT Solutions for this client for over 13 years. These solutions have ranged from maintaining and developing their manufacturing system(s), to creating new applications that help them to remain competitive in the market place.

The service provided to this client has varied over the years, and have covered applications such as (not all listed):

• Materials Management Manufacturing System (MMII).
• Batch Disposition System for the approval of batches manufactured.
• Business Objects reporting systems.
• Batch samples calculation system.
• Year 2000 compliance.

Some of the technologies used are listed here:

• Microsoft Visual Studio 2005 - C# and VB.NET
• SQL Server and Oracle Databases
• Business Object 6.5 and XI versions
• Microsoft Visual Basic version 6.0
• Cognos Powerhouse and COBOL

In addition to developing systems for this client, we have also help maintain the validated status of those applications. With Eli Lilly being a pharmaceutical company, they are governed by the FDA in the US, and require strict documentation to accompany any application that is used for the production of product. A vast amount of experience has been gained in the area of validation and testing of applications.

Peter Ambrose (Castleford) Ltd have one very simple business aim and that is to give the best service to all their customers, even those who have not purchased a vehicle from them. They believe that to achieve their aim of completely satisfied customers will in the longer term give us all a secure and rewarding future.

This client approached us to develop a system geared to providing a personalised service booklet for their customers, helping to tailor car service details to each individual customer. We developed a single user system (Microsoft Visual Basic), hosted on the client PC, that help deliver this requirement.