Bespoke Software Development for Merck Sharp & Dohme
How the pharmaceutical giant automated rebates with Evolve and massively reduced their turnaround time
MSD used a massive spreadsheet to validate all rebate claims manually. The sheet was close to reaching Excel's line limit and had a high risk of failure.
The spreadsheet was not linked with any other system and was built and maintained by one person. As a result, the rebate validation turnaround was very slow, seriously affecting the whole process. Nor was there any auditability or control. It was hardbound to manual intervention.
How we helped
MSD partnered with Evolve to build a bespoke Cloud-based solution – a complete automated end-to-end rebate platform.
Evolve provided a data specialist for data cleansing and data transformation due to tight deadlines and built a claims validation module to compare claims from distributors against deals saved on the system. We implemented customised screens and enhanced reporting functionality as well as a smart dashboard for real-time performance task management.
● Instant rebate validation with turnaround time reduced massively
● Full control over data quality and accuracy
● Little to no manual intervention required
● More efficient deal maintenance
● Greater transparency providing protection for the customer and the business
● Risks associated with a single person maintaining the process completely removed
● Full auditability and reporting
- Bespoke Software
- Technical Lead
- Data scientist
- Business Analysts
- Azure Stack