Case study : Data Optimized with BI

BI for the pharmaceutical industry represents a significant market
opportunity in terms of market size mainly because they are composed of large
organizations. These companies accumulate vast amounts of data through global
discovery projects, numerous clinical trials, and cost-marketing activities.
These factors create a more pronounced and immediate need for BI tools across
the product lifecycle in the pharma sector. As a result, a growing number of
companies are turning towards enterprise-class BI solutions that provide a
common underlying architecture and end-user interface and integrate data from
different laboratories both research and clinical.

With an elaborate list including Biodeal Laboratories, S Kant Healthcare,
Astral Pharmaceuticals, Vasu Healthcare and Mercury Laboratories, Soham
Computers is primarily engaged in loan licensing production of large companies
like Abbott, Glenmark, Lupin, Nicholas, Ranbaxy, Cadila, Zydus and others. The
company also develops enterprise software for the small to medium scale
pharmaceutical organizations.

Soham had a challenge in terms of ever growing demand for reporting needs of
the functional users of the pharmaceutical industry. They were actually looking
out for a tool that can be integrated to deliver the breadth and depth of
analysis, insight, and actionable intelligence that pharmaceutical customers
need. 1KEY BI integration with Soham solutions provides convenient access to
this intelligence from within Soham applications.

It is in this space, Soham approached MAIA for its reporting and analytics
software 1KEY BI in July 2008. MAIA trained the technical and functional team of
Soham on 1KEY BI report creation, database connectivity, 1KEY architecture,
business-user related features and etc. With 1KEY, Soham made a library of
standard reports available to its customers, including Trend analysis reports
(for QC & QA department), sales analysis reports (for marketing department),
purchase and consumption analysis (for store department), batch costing analysis
(for costing department), and flow management (for finance department) and
production planning and achievement (for production department).

“The pharmaceutical companies need complete visibility into their business
performance. The answer to many of its issues lie with a company's ability to
extract knowledge from raw data and to make it readily available where and when
it is needed. Reporting and analytics is pivotal today for pharma companies,”
said Suketu Shah, CEO, Soham Computers.

With 1KEY BI, Soham is now able to deploy a robust, cost-efficient reporting
solution on its pharmaceutical solutions. Soham can now also reap the benefits
of 1KEY BI, including the scalability, and cost benefits. Now, several
departments across its customers use 1KEY BI for their reporting needs-including
production, sales, operations, and finance. The reports are easier to read than
ever before and are offered in several different formats, such as PDF, XML or
CSV.

Soham is now able to give its clients easy access to valuable information,
and save time and report development costs.

“The reports offered are now filled with rich real time analytic features
which we did not have before, like graphs and charts. We can also create reports
in about an hour rather than spending on them several days or weeks. Our
developers can focus their time on more important development projects instead
of reporting.”

“Our clients did not want just spreadsheets or lines of data. They wanted
information presented in a way that allows them to understand the goings on in
their company more. With 1KEY BI, we are able to give our clients information
they are looking for in the form in which they can easily absorb it,” Shah
concluded.