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

Home
Portfolios
Database Design

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

  • Encryption-at-Rest, with the proper key management policies would be a solid solution, but it would not have met the requirements in full.

Actual Solution

  • Working with the client, Mantrax implemented the proprietary design with a novel coding process. At Mantrax we believe in putting order to chaos and coming up with solutions that are both elegant and sustainable. Our solution to this problem followed this mantra as well. The engineering of this solution was particularly challenging since an unencumbered user experience was also part of the requirements. At Mantrax, our teams have implemented all types of proven engineering methods, but when the circumstances dictate, we innovate to meet the client’s needs. Nevertheless, functional integrity is never jeopardized.

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

Home
Portfolios
Database Design

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

    Home
    Portfolios
    Database Design

    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

    Multi-Tenant SaaS Application for Sports Club Management with Global Users

    Home
    Portfolios
    Database Design

    Multi-Tenant SaaS Application for Sports Club Management with Global Users

    Project Description

    In 2018 Mantrax delivered Cricket Club Manager, a custom web application and mobile app to help sports club owners minimize administrative tasks and enhance the member experience.  Our client required a design and delivery of a minimal viable product to strike the right balance between speed-to-market, feature robustness, and cost.

    The Problem

    Cricket is the fastest-growing sport in Canada and cricket clubs are forming across a wide range of sectors from for-profit recreational clubs to corporate clubs and university and college clubs. With memberships growing, club administration required better tools to help manage day-to-day tasks such as player availability and match schedules, and last-minute match updates.

    Our Solution

    Budget

    Because managing membership fees was an ongoing challenge for sports clubs, a limited budget was available for a custom application. The minimal viable product we developed met budget constraints as well as client objectives.

    How We Made It Possible

    After careful planning, we chose to build the application on the LAMP stack (Linux, Apache, MySQL, and PHP) due to its ubiquity, availability of support, affordable hosting options, and mature frameworks. After developing the application, we worked on social media marketing to increase the adoption rate, club sign-ups, and traffic. Cricket Club Manager is now being used by almost 100 clubs worldwide.

    Services Used

    • Full Stack Development
    • Strategy & Implementation Consulting
    sports club management
    ccm