The excel macros were thousands of lines long with the code and workflows written entirely in Japanese. We hired a translator to help with just the understanding

Japanese Code

Written by devs who were no longer at Roche, the code also never had any documentation, hence we had to sift through the entire project by trial and error before taking help from the end customer.

Nil Documentation

The end user who would actually use the app were not very tech savvy hence Roche decided to not involve them until we had a prototype ready to test and deploy

Enduser Absence

This was easily one of the most challenging projects we had worked with. From requirement gathering to the absence of documentation for excel macros written in Japanese.

Challenges

Cloud Native and Offline-First: Building for Roche Japan Diagnostics

App Modernization

DevOps

Services

Roche partnered with SoluteLabs to modernize its legacy Excel macros and build a cloud-native solution. Learn how this transformation improved efficiency and boosted competitiveness.

See how Roche transformed its business operations by migrating from Excel to a cloud-native tech stack. Discover the impact of this modernization with SoluteLabs.

Roche's Digital Transformation: From Excel to Cloud with SoluteLabs

Roche

Roche App Modernization: Transforming Legacy Excel to Cloud-Native

Industry

Engagement

Investment

Digital Transformation for the World’s Third Largest Marine Company

Award Winning, Transformative Product Engineering for a Media SaaS Unicorn

UX Strategy for AI and Data-Driven Health, Environment, and Lifestyle Insights

We proposed to build two solutions for the the client: one was cloud native and the other would be an offline-first solution (Windows Installer) that would sync to the online solution whenever internet became available. This is because the end users would travel to places with less internet connectivity.

Solution

Offline Windows Installer

Cloud Native SaaS

Syncronization Module

Problem Statement

Explore how we collaborated with Roche on HL7 data analysis and reporting to App Modernization

Enabled real-time KPI calculations and decision-making, enhancing retail execution efficiency.

Time saved through Automation of Reports. The new system automated the generation of PDF reports, eliminating the need for manual data entry.

Cost Savings viz a viz the existing system by eliminating manual processes. Furthermore, making the system future ready in the process.

We utilized NextJS and NestJS as the primary frontend and backend frameworks to build the application on. Furthermore we picked DynamoDB as the database of our choice on the cloud and used PostgresQL for the windows offline installer.

Web Development

We utilized Github and Github Actions for CD/CI for the backend whereas we used Vercel as our NoOps platform for the frontend. We used Terraform for Cloud Infra Deployment Automation as well while using Sonarqube for checking code quality with linters.

Cloud & DevOps

We picked a cloud native solution built around modern JS frameworks that enabled us to build a modern, robust and offline-first app.

App Modernization for Roche: Legacy Excel Macros to a Cloud Native Tech Stack