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

Home
Portfolios
Solution Architecture

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
Solution Architecture

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

Materials Management

  • Raw, WIP, and Finished Goods inventory tracking
  • Inventory valuation (FIFO, LIFO) 
  • Formula/Recipe creation and management 
  • Physical inventory tracking 
  • Material availability checks tied to production schedules
  • Scrap and variance tracking
  • Bill of Materials (BOM) management

Production Management

  • Production Planning and Scheduling
  • Work Order Creation and Routing
  • Shop Floor Reporting and Process Conditions Tracking
  • Supervisor Controls

Quality Control (QC)

  • Test Templates Creation
  • Incoming, in-process, and final inspection workflows and results
  • Pass/Fail based on Standards per Product

Master Data Management

  • Centralized item, customer, vendor, and BOM master data
  • Data validation and governance rules
  • Version control and audit trails
  • Role-based access 
  • Duplicate detection and data normalization
  • Cross-module data consistency enforcement

Reports and Analytics

  • Role-based reports (operations, quality, finance)
  • Real-time production and inventory tracking
  • Custom and ad-hoc reporting
  • Historical trend analysis
  • Customer specific QC reports (i.e., Certificates of Analysis/Bill of Lading) 

Other Functionality

  • Equipment inventory and tracking
  • Health and Safety Assessment Reports and Logs
  • Maintenance Fuel Tracking
  • Internal Memo Tool
  • Customer and Supplier Profile Management
  • Purchase Order Creation
  • Lead Time and Shipment Profiles

Custom CRM Development for a Law Firm

Home
Portfolios
Solution Architecture

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
Solution Architecture

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