Case Study

Custom Regulatory Information Application for a Pharmaceutical Provider

APEX Development

The Overview

Services:  Oracle APEX Development

Solutions: Custom Application, Product Information Management Integration

Technology: Autonomous Database

Industry: Pharmaceutical

Our client is a world leader in pharmaceutical technologies and services for the healthcare industry. It is present in 80 countries with approximately 67,000 employees and serves more than 3.7 million customers and patients

The Challenge

The pharmaceutical industry is highly regulated, and our client must document its products’ regulatory information to ensure compliance. It must manage the submission of the regulatory dossiers (regulatory events), as well as track detailed product information.

They had initially purchased a tool from the pharmaceutical market in order to create and maintain this information, but it did not meet their needs. They were looking for a new solution that could provide full lifecycle management with a centralized, global view of product details, documents and submissions, and that could support collaboration and meet compliance requirements.

The timeline was tight and they needed the new system to be completed and in place within 4 months.

Needs

Oracle took note of our client’s challenges and contacted its long-time partner Insum. Together they presented an offer that would:

  • Recover, clean, and migrate existing data to the new platform
  • Ensure data integrity
  • Reduce data entry through a more straightforward process
  • Provide the end-user with a highly intuitive interface
  • Reduce overall costs.
  • Offer great flexibility in configuration
  • Be better suited to their present needs while being easily scalable if needed.

Oracle, aware of Insum’s APEX expertise, knew it would build the application to the highest standards and within budget while respecting the client’s tight timelines.

The Approach

Given the project’s tight timeline, Insum opted for an agile approach, thoroughly integrating our client into the process. There were 2-3 meetings a week with project stakeholders, and regular deployments with demos roughly every 3 weeks. The frequency of these Insum/client meetings ensured there were no surprises.

Meetings almost always included developers, the tech lead analyst, and client users to eliminate any knowledge gaps that could slow the process down.

The client’s team also conducted work sessions on its own to ensure unified feedback and requests.

To ensure smooth adoption of the new application and of the Oracle Autonomous Database, knowledge transfer sessions were jointly conducted by both Insum and Oracle.

Agile methodology

  • Regular meetings
  • Frequent deployments
  • Knowledge transfer

The Technology Used

This solution included Oracle’s fully managed Autonomous Database (Autonomous Transaction Processing), and Oracle Application Express (APEX), the Oracle Database’s Rapid Application Development platform.

Oracle’s Autonomous Database, which hosts the APEX application, was deployed within a day and a half, and work on the APEX application began immediately thereafter.

The Autonomous Database is an optimal solution, ensuring a high level of data security for the client’s sensitive information, while also minimizing maintenance efforts thanks to its self-driving, self-securing, and self-repairing capabilities.

The Results

Our client now works with:

  • An application that’s fully adapted to their needs: secure, simple, very interactive, and performant, with no duplicate data entry.
  • Zero application licensing costs as APEX application and user costs are already part of the Oracle Database license.
  • A fully scalable and fully managed-by Oracle infrastructure that can easily be adjusted to the size of the application as well as other workloads that the client has planned for it.

“Thanks to Insum’s professionalism and technical knowledge, we have now a database that precisely answers our needs. The development of the tool went perfectly well: rapid development through an agile mode, favorable working hours with the time difference between our country and Canada, very good coordination, and communication between our teams, and very open-minded and nice people!”

– Anne-Sophie – Director, Regulatory Affairs, pharmaceutical provider

Work with Us

We appreciate your interest in learning more about Insum.

We want to learn about how we can work with you.
Do you have any questions or need more info?

Fill out this form, and a member of our
team will connect with you. Let's talk!

Some of our other case studies

Transforming Shipping Operations with Oracle APEX at Nidec Leroy-Somer

Discover how a leading manufacturer improved its shipping operations by integrating Oracle APEX with Oracle E-Business Suite, reducing processing time and increasing efficiency with a modern, real-time shipping interface.

AP Automation with Oracle APEX and Document Understanding

Trailcon Leasing, a top transportation company in Canada, struggled with inefficient and error-prone manual invoice processing. Insum implemented an Oracle AI-powered solution to automate invoice parsing, reducing processing time from 30 minutes to 5 minutes. This automation improved accuracy and operational efficiency, allowing Trailcon’s finance team to focus on strategic tasks.

Banking on a Customer Application

Discover how an international banking group improved operational efficiency, reduced customer duplication errors, and enhanced data security through a custom Oracle APEX application integrated with Oracle EBS.

Creating a Supplier Portal with Oracle APEX

Learn how Insum replaced an inefficient and cumbersome Excel spreadsheet and implemented an Oracle APEX-based Supplier Portal that revolutionized data handling, increasing efficiency and accuracy for a global electronics manufacturer.

Moving Air Transat to the Cloud

Air Transat collaborated with Insum to transition its critical scheduling application to Oracle Cloud, addressing server inefficiency and high replacement costs. This move enhanced performance and achieved significant savings.

Revitalizing Legacy Systems: A Cemetery’s Journey to Modernization

In a significant digital transformation, Insum collaborated with one of North America’s largest cemeteries to overhaul a 20-year-old system, replacing cumbersome manual processes with an integrated, user-friendly platform. The solution included a customer portal for online access to gravesite information, advanced reporting tools, and seamless integrations across departments.