1. / Healthcare Research Firm Saves 2500 Manhours and $375,000 Annually
Overview

For contract research organizations (CROs), the steadily increasing cost of research trials and high levels of ever-present risk make it imperative to streamline operational costs wherever possible.

In a bid to improve their margins and build a more efficient enterprise, the customer contracted Apexon to better integrate their existing operational protocols with the Veeva CRM platform, built on Salesforce.

Problem

Many CROs outsource a significant chunk of their product detailing and sampling activities, often using highly specialized vendors. Each of these outsourced projects requires extensive data exchanges between vendor and customer.

 

  • The existing data exchanges were being processed manually, with validation and updation occurring via Microsoft Excel, before being loaded to and from the Salesforce Platform
  • Considering that the data exchanges were occurring on a daily, weekly, and monthly basis, this function incurred a high manpower cost
Solution

In order to improve the quality and speed at which data was being exchanged, Apexon specialists implemented an automation-based approach.

 

  • We used Informatica Workflow Manager to extract the data from the Salesforce tables and flat files
  • Data was processed via validation and transformation rules and uploaded into Salesforce and vice-versa
  • Complete automation of the previously manual data import and export process
  • Unix scripts were used to validate and transfer files to and from the customer’s SFTP server
Impact

In-line with the customer’s business needs, Apexon solutions drove significant operational value, including:

 

  • Improved system performance as measured by multiple KPIs
  • Over 2500 manhours and $375,000 in annual savings

Other Case Studies
US-based Physicians Group Improves ROI by 6X

Case Studies

Healthcare & Life Sciences
US-based Physicians Group Improves ROI by 6X

Learn how we helped a large physicians group based in the US use deep learning models to improve error identification by 3x and reduce financial leakage by 40%.

German Automaker Labels 12M Objects per Annum from Street Videos

Automotive & Manufacturing

Automotive & Manufacturing
German Automaker Labels 12M Objects per Annum from Street Videos

Discover how we helped a German engineering firm automate video labeling for their autonomous vehicle project to identify street objects and their location with over 82% accuracy.

Financial Advisor Gets Retirement Benefits Calculator to Predict Over 30 Years Ahead

Case Studies

Financial Services & Insurance
Financial Advisor Gets Retirement Benefits Calculator to Predict Over 30 Years Ahead

Discover how we helped a financial advisor offering online investment advice evaluate the feasibility of their retirement plans 30 years into the future.

Asset Management Company Analyzes Churn to Retain 50% of Passive Customers

Case Studies

Financial Services & Insurance
Asset Management Company Analyzes Churn to Retain 50% of Passive Customers

Discover how we helped an asset management company analyzes its high churn rate to identify opportunities for customer retention and improve CSAT

Let’s head to the apex

Get in touch and let’s start a conversation!






    banner_side

    © 2021 Apexon. All Rights Reserved.