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

© 2021 Apexon. All Rights Reserved.