Cloud-Based Multi-Tenant SaaS Business Intelligence Application for Enterprises

Cloud-Based Multi-Tenant SaaS Business Intelligence Application for Enterprises

Project Overview

Mantrax was engaged to build a unique cloud-based multi-tenant SaaS application platform. The client had very specific requirements in terms of functionality, scalability, security, identity, and user experience to meet the needs of a narrow market segment. We started with a proof-of concept project to evaluate the feasibility of our proposed solution. Due to the success of this development, Mantrax has been retained to develop the other applications based on this platform.

The Problem

A particular challenge was to deliver on the rather unique identity and data security requirements for this type of mobile application deployment. It did not allow for any corporate or user identifiers to reach the cloud servers. The challenge was to de-identify all private company information (name, emails, product names, etc.) before they made it to the database and reconstruct them in the application in real-time. For example, if Acme Corp sells a product called Foo Bar, we couldn’t save either the label “Acme Corp” or “Foo Bar” in the database but the labels had to be re-inserted while the application was in use (that is on the client side).

Potential Solution

Actual Solution

Project Challenges

The client implemented the ERP system IFS in 2016. In 2020, four years post-implementation, the Client’s pain points included:

1. Unique Security Model

The initial challenge was creating a data model that would support client isolation and allow users to log in seamlessly.

2. Multi-Tenancy at Scale

At Mantrax, we are not committed to any specific tech stack; we select the one that best fits the solution.

3. Data Entry for Mobile Screen

A hybrid deployment was recommended since maintaining a separate code base for iOS and Android leads to a more expensive development process.

Project Solutions

1. Unique Security Model

A robust multi-tenancy database was selected for the platform making it possible for each client on this app to not only have their own individual database but can enable them to be put on different clusters in different public clouds to satisfy client requirements.

2.  Multi-Tenancy at Scale

Since the purpose of the app was to allow a large volume of data entry capabilities, we chose a non-blocking, cross-platform JavaScript runtime environment running in cluster mode for performance.

3. Security Outcome

Even if there is a breach, no one can connect the server data with the company. This is completely obfuscated to an end user.

Custom Manufacturing ERP

Services : Full Stack Development

Custom Manufacturing ERP 

 

Project Overview

 

A leading developer and manufacturer of advanced concrete materials faced significant challenges with outdated software. The software, developed over 25 years ago, was running on a Windows XP virtual machine, and lacked the necessary functionality to meet the manufacturer’s evolving operational needs. To bridge the gap, the manufacturer relied heavily on Microsoft Excel, resulting in cumbersome manual data entry and calculations by management.

After extensive research, the manufacturing organization opted to modernize their existing custom application over purchasing an off-the-shelf ERP. 

Solution Overview

Mantrax partnered with the manufacturing client to modernize their systems and streamline operations. Key elements of the solution included:

Fresh UI Design

We introduced a user interface that balanced familiarity with modern design principles, simplifying the learning curve while enhancing robustness.

Database Redesign

The existing database was completely overhauled to meet industry standards, simplifying backend processes and incorporating essential missing features.

Core Functionality Enhancement

We refined and simplified core functions to reduce redundant user inputs, ensuring data integrity and improving overall efficiency.

Services Provided

Consulting and Discovery

Comprehensive in-person workshop to understand current state processes and design future state processes. The workshop resulted in a detailed functional specification outlining the scope of ERP modernization.

UI/UX Design

A user-centered design approach ensured a smooth transition to the new system. As part of agile development, wireframes for each module was designed and approved by client before starting development. 

Solution Architecture and Development

Design of three-tier architecture: frontend, backend  and database development. End-to-end module development, ensuring seamless integration and efficient data flow across all modules.


Quality Assurance

Rigorous testing processes included testing as part of agile sprints, and testing by the Client at regular intervals. A final User-Acceptance-Testing (UAT) at the client’s production facility was facilitated. 

Project Management

We provided end-to-end project management, including 100% agile development cadence, ensuring transparency and timely delivery at every stage.

Data Migration

Static and transaction data migration from legacy application to new ERP. 

Technology Stack

Front-end

Front-end technologies

Backend

Database

PostgreSQL Database Development

Cloud-Hosted

Microsoft Azure Development Mantrax

CI/CD

git

Solution: A modernized ERP system with integrated modules to streamline end-to-end production operations.

Operations


  • Production Planning
  • Work Order Management
  • Shop Floor Control
  • Asset Management
  • Supervisor Controls

  • Inventory Controls


  • Inventory Management (RAW, WIP, Finished Goods)
  • Recipe Creation and Management
  • Physical Inventory Tracking
  • Packaging and Shipping Tracker

  • Customer Relationship Management (CRM)

  • Customer Information Management
  • Sales Order Management

  • Quality Control

  • Test Results Entry
  • Test Templates
  • QC Reports
  • Test Standards

  • Reporting

  • Production
  • Inventory
  • Customer Reports
  • Sales Reports by Recipe, Raw Materials

  • Custom Features

  • Memo
  • Health & Safety
  • Maintenance Fuel Tracking

  • Custom CRM Development for a Law Firm

    Services : Full Stack Development

    Custom CRM Development
    for Legal Applications

    Technology Stack

    Project Description

    Development of a new SaaS CRM with multiple modules.

    The Challenge

    The client was trying to develop a new CRM to be used by law firms. The platform was a new product aimed at filling gaps in existing commercial SaaS offerings in the industry. The client was frustrated with the three other vendors and contractors they had worked with since each vendor needed help to meet timelines, stay on budget or deliver the design functionality.

    The Solution

    Our team diagnosed the development work completed to do and collaborated with the client to complete the application.

    Product Development Summary

    Multi-tenant cloudbased SaaS solution

    Event management module

    Compliant with privacy rules

    Multifactor Authentication

    Google Calendar like functinoality

    Digitization of documents exchanged between law firms and their clients.

    Document management functionality akin to Google Drive (Drag & Drop, Merging Documents, Multiple Download/Uploads, etc.

    Services Provided

    Solution Architecture

    UI/UX Design

    Full Stack Development

    Database Design


    Quality Assurance

    Project Management

    What our client says

    Without any exaggeration, all of the work they so far completed has been to my complete satisfaction - all sprints were completed on time as planned and deployed successfully one time. I wish I had met them in 2016 so I did not have to waste my time and money (and face so much frustration ) with the other three developers.
    Cemal Acikgoz
    Partner, Acikgoz Law

    National Association CMS: Digital Renewal Strategy & Implementation

    Services : Full Stack Development

    National Association CMS: Digital Renewal Strategy & Implementation

    Technology Stack

    Project Overview

     

    Mantrax recently proposed a CMS (Content Management System) for a National Association facing numerous pain points. Members were frustrated with the online experience. The existing member portal has frustrated members due to usability issues, navigation challenges, and a need for more intuitive features. This dissatisfaction hampers member engagement and overall perception of the association’s value.

    The Goal

     

    To find a resolution, the following projects were initiated:

    • Phase 1: Functional Research to understand stakeholder’s pain points with the online platform.
    • Phase 2: Complete modernization of the legacy platform.

    Project Challenges

    01

    Stagnant Membership

    The recent stagnant membership growth is partly due to a subpar member portal. Attracting and retaining new members is challenging without a user-friendly platform that boosts engagement and interaction.

    02

    Risk of Member Attrition

    Emergence of alternative platforms for key functions like recruiting and visibility poses a major threat. Members may be drawn to rival platforms with better experiences and solutions, risking membership loss.

    03

    High Operating Costs

    Inefficiencies in the current member portal have raised operational costs. Members frequently seek staff support, adding workload and expenses, and diverting resources from strategic initiatives.

    Phase 1


    Functional research to create CMS

    In Phase 1, we facilitated member feedback collection through a neutral platform. This input was then combined with system diagnosis and external research, comprising six functional analysis activities.

    30 Member Interviews

    Consolidated member interviews with actionable insights & prioritized implementation lists.

    System Review

    Consolidated member interviews with actionable insights & prioritized implementation lists.

    Website & Portal Content Audit

    Consolidated member interviews with actionable insights & prioritized implementation lists.

    Website Analysis

    Consolidated member interviews with actionable insights & prioritized implementation lists.

    User Activity Assessment

    Consolidated member interviews with actionable insights & prioritized implementation lists.

    Global Industry Research

    Consolidated member interviews with actionable insights & prioritized implementation lists.

    The result was a complete 360-degree analysis of member experience

     

    Phase 2

     

    End-to-end modernization of the legacy CMS

    Phase 2 of the modernization journey represents a pivotal step towards aligning the association’s digital ecosystem with contemporary standards. By focusing on user experience, linguistic inclusivity, data security, and advanced functionality, the organization is poised to set new benchmarks in member engagement and digital transformation. This strategic initiative underscores the commitment to excellence and responsiveness, ensuring that the member portal remains an indispensable asset as the organization continues to evolve.

    Core Objectives

    The second phase of the member portal modernization initiative encompasses a comprehensive development scope that aims to revolutionize the digital landscape of the organization.

    Universal style guide creation

    Crafting a universal style guide that harmonizes the design language across both national and district websites. This cohesive visual identity fosters a seamless and recognizable UX.

    Bilingual interface

    Implementing bilingual support for French and English languages, catering to the diverse linguistic preferences of the association’s members

    Enhanced UX & scalability

    Upgrading infrastructure for improved user experience, scalability, availability, and adaptability. This empowers the portal to evolve with organizational needs

    Revamped web design

    We’ve completely revamped national and district websites with data-driven single-page web applications, boosting engagement and data accessibility.

    Member profile & data migration

    Seamlessly migrating member profiles and sensitive PII data, adhering to industry-standard data governance policies with a strong focus on security and compliance

    Dynamic availability calendar

    Introducing an availability calendar tailored for members, enhancing their ability to engage with key events and activities efficiently.

    Configurable content framework

    Introducing a flexible content framework for national and district-level customization, empowering administrators to engage specific audiences.

    Granular content control

    Enabling granular content control via role-based access, providing administrators with effective tools for content management at various levels.

    Services Provided

    Functional Research

    UI/UX Design

    Full Stack Development


    Quality Assurance

    Project Management

    Database Design

    Training

    Change Management

    What our client says

    The team at Mantrax combines a deep, thorough knowledge of leading software development solutions with first-rate technical skill and dedication to their work. Their people know how to balance speed, costs and quality in a product, and – when facing unknowns and making decisions that will impact the future of your organization – they offer honest, accountable and credible counsel delivered in an environment of open and ongoing communications.
    Ian Gillespie
    Director of Communications, Directors Guild of Canada