Excerpts from the article in CIO Review Product of the Month – August 2014

Medico EdSS: The Decision Support System for the Pharma Industry

The pharmaceutical industry is undergoing several fundamental changes. As the pressure increases, pharma companies need to rethink and evaluate alternative business models, focusing on technologies like BI tools. In order to build a significant market share in an expanding and competitive drug market, pharma companies need information management solutions that allow them to make better business decisions thereby maintaining revenue growth.

However, the BI tools available in the market today do collate information but they are more tuned to detailed analysis at the corporate level and cater to analysts who have time to ponder over reams of data and information. Sales people, field managers and people on the move need quick and easy access to key information in simple practical formats with options to drill down, monitor KPIs, keep an eye on HQ level profitability and respond to SMS / email alerts. Identifying a need for an expansive BI solution that can be used by everybody across the organization, Excel Software & Systems Pvt. Ltd. a provider of enterprise consulting software has created Medico eDSS, an Enterprise wide Decision Support System and BI tool, which is more of an operational tool than an analytical tool.

It is focused on providing organizations with summarized information and key performance indicators that allow people in various roles in the organization, at different hierarchical levels to quickly access and monitor information to take decisions in real time. It includes various domain specific functionalities such as business logic, processes, workflows, alerts, controls and analysis.

Leveraging Industry Experience

Unlike an average BI installation that would have about 40-50 users, Medico eDSS can be used by everybody in an organization, right from the CEO to the sales person. "The product's objective is to bring everybody in an enterprise on the same page," says Uday Vijayan, M D, Excel Software & Systems Pvt. Ltd. The forward looking tool has been developed by Excel, an independent software vendor with experience in varied domains such as SCM, Production, MRP, Sales and distribution and Finance. Founded in 1987, Excel leverages its vast industry experience to build products that are well placed in the market to help clients overcome their business challenges.

An enterprise usually uses various applications for its different systems which makes extracting the relevant information a challenge. "In over 20 years of providing enterprise grade products and solutions to the pharma, food and FMCG industries, we have watched people at every level struggle to collate information from different sources and applications," explains Uday. The company built Medico eDSS to counter this challenge.

Excel also has its own products such as Medico Online for sales and distribution and finance; Medico SFA for sales force automation; Medico SG for physician samples and promotional inputs distribution; Medico SS – secondary sales. So we are familiar with the ground realities involved in all these domains. The company that is a JDA, IBM, Open Text, Mowbly partner is well versed with the challenges involved in integrating data from different applications for demand planning, demand fulfillment, logistics and other key SCM areas. It is also an expert at Web services, SOA and BPM based integration. Armed with these capabilities Excel has gained several prestigious names as its clientele such as Pfizer, Bayer, Takeda, Vetoquinol, Indoco Remedies Ltd, Boehringer Ingelheim, IndSwift, Palsons Derma, ICPA Health Products Ltd and is poised for higher growth in the near future.

Providing Strategic Advantages

Excel's tool Medico eDSS, helps pharma companies not only integrate data and information across multiple applications, but also integrates people across different functional areas. Since every KPI that affects the health of the organization is at the fingertips of every employee – it makes everybody aware and accountable. This enables informed decisions to be taken in real time across the enterprise landscape since everybody feels accountable.

Medico eDSS, the decision support system for the pharma industry integrates well with underlying applications such as SAP/ Baan/ JD Edwards and provides real time reporting to users at the head office and to people in the field across the nation. The product also helps organizations monitor sales performances in terms of targets, growth at the HQ, MSR, ABM, RBM and as the Zonal manager levels. It also provides financial MIS with drill downs up to the transaction level; product & brand management and an outstanding, collection, cheque returns of stockists. Enterprises can manage stock and sales at locations, free schemes, sales ranking for each brand; gain analysis of expiry, breakage and spoilt goods along with stock transfer plan and logistics planning support.

Apart from this, the tool has several other features that make it the sought after tool for the pharma industry. Built on the latest J2EE 7 technology and Oracle 11G, Fusion charts the tool is lightning fast and can be viewed on mobiles, notepads and any device that supports internet browsers. Since the company is familiar with the domain and ERP applications like SAP or NaVision it helps them implement Medico eDSS within a short span of 4-6 weeks even at large enterprises with over 3-4000 people. Medico eDSS also brings in transactions and posts them into its own database providing unparalleled multiple company financial MIS across group companies and branches.