Case Studies

Clinical Trial Tracking


Client is a cancer clinical trial organization, which conducts clinical trials on patients and tracks the outcome of each drug at each stage and years after completion of the trial. Normally trial continues up to 6 months and follow up happens for next 5 years.

They were already using a web solution, but given the volume of data and the concurrency of users, the application started falling short of expectations quickly. Especially the application wasn’t able to handle the large amount of files to be handled.

Moreover client also started looking for a cloud based solution to avoid the hassles of infrastructure management.

Given the proven capabilities platform, HIPPA compliant infrastructure, ready to use features and incentives for Non Profit organizations; client decided to move the whole application to platform.


  • The nature of client’s business is such that it couldn’t be paused while new system is built, but at the same time it was getting difficult to use existing system. The new solution was required in short timeframe.
  • There huge amount of data to be migrated (~600 gb including files) over to Salesforce in order to be able to stop using current system completely.
  • The security aspects were very important, as the application holds health records of people. The security must company with various US government regulations.
  • The huge amount data processing for reports was perfect recipe for hitting salesforce governor limits, if the system not architected for handling those limits.
  • The number of screen to be developed was huge for short amount time and client had preference to the UI they were used to.
  • Store the historical data for audit


Based on the requirements and specification, we decided to architect the application using following components of

  • Apex and VF heavily
  • Approval Processes and Validation Rules
  • Apex based data Sharing
  • Self-Scheduling Schedule Jobs
  • Chatter (for sharing files and internal user interaction, field history tracking)
  • Partner Portal (for interaction of all stake holders and independently capture some data)
  • SOAP API (for data and file migration)

To migrate data from existing system to Salesforce, Talent data migration tool was used. To migrate files, a custom Java based tool was built which locates patients in Salesforce and uploaded their respective files for that patient.

The security was implemented using finest level of security framework provide by, which achieved all the security requirements.

The chatter is used in solving the large amount of files’ storage which allowed users to quickly share the files and not worry about the space available.

The approval processes framework is used to pass data through approving authority without much development around approvals.


The initial version of the solution was deployed in production in just 8 weeks and widely appreciated. This followed up enhanced version of application going in production 16 weeks later with all major capabilities included.

The system is currently in use by more than 150 users and daily submission of 200+ forms with more than 1000 patients on trial being studies concurrently.


Cancer Clinical Trial Organization

Remi Head of Operations at Renovo Financial, LLC

"Bakul from Aspire Software Consultancy has been integral in implementing Renovo’s manual business processes into the Salesforce system. He has an amazing team that works around the clock to deliver on all of our requests. Since partnering with his team, we have been freed up to spend more of our time thinking of creative ways to improve our business, leaving the execution piece to him. We have worked with numerous developers in the past and no one else has been as consistent & thoughtful. Any time we have had an idea, Bakul has found a way to write the code and implement it for us. Partnering with him has transformed our business. Bakul and his team are very communicative, very proficient in writing code, and actually collaborate with each project, providing feedback as to how they can improve upon my initial project ideas. We have been working together for almost two years now, and we plan to continue doing business together for the foreseeable future."

Måns Johansson Network manager

"Aspire helping us create a unique digital platform used in the Dental market. From first contact to deployment of platform, and ongoing it has been a professional and swift. Aspire has helped us to build, fine-tune our new platform. The Dentnet group highly recommends Aspire software.

Rob McNicoll Director - Copper Monkey Ltd.

"Overall I strongly recommend Aspire. I’ve worked with many different suppliers over the last decade, but in the last 3 years have only used Aspire as they have consistently provided the performance I require in my business."

Craig Vaughan Founder and Director - BrokerEngine

"Aspire team has worked incredibly hard and taken ownership of the BrokerEngine product development and support/enhancements project as of their own product. I would highly recommend Aspire Team for any such software project development."

John Ragsdale Chief Information Officer at EyeCare Services Partners (ESP)

"Great development team! Great architect skills, great ideas, experience with many different types of apps, etc."

Scroll to Top