The client is one of the fastest growing pharmaceutical company amongst top 100 companies in India as per ORG-IMS. It has a strong presence in domestic branded formulations. Its major thrust area also lies in Active Pharmaceutical Ingredient (API) and Contract Research and Manufacturing Services (CRAMS). It has presence in Spain through its branded formulation business, which was acquired in 2006.

The client in order to manage its business has implemented SAP to facilitate better management of its business processes and to enable easy reporting across the length and breadth of the organisation, decide to go with “1Key” business intelligence tool.

The client has been experiencing significant growth in its business but found that its management reporting system did not scale very well with this growth. Below is a list of challenges that the client faced with its existing system.

Lack of Scalability: The existing system had limited functionality for configuring the key performance indicators/points as and when required. As a result it was exceedingly difficult to add enhance the information needs of its management for better handling of customers/products. This was a major pain area for the client because it was not able to keep pace with its growth.

TIS helped the customer to deploy and map the information needs of the employees at different levels for better understanding of their business. TIS leveraged the capabilities of 1Key technology platform to solve the issues faced by the client. Employees at their levels now have access to summary information available across their roles and responsibilities for monitoring the progress using dashboards.

The client now has an infrastructure setup for accessing day to day information for monitoring the business, while laying down a roadmap to meet their requirements for the information within the required time frame. The client is now in a better position to meet the execution challenges for its growing number of customers/products. The new system enabled the client to service its customers more effectively. TIS also allowed the client to deal with growth pressures by creating a more scalable system.

SQL Server