Q3 Technologies successfully enhanced & migrated an ERP application on the cloud platform with a central reporting server for a leading solution provider. The application delivered to the client was a complete ERP solution for the construction industry, and helped in planning, estimation of budget, execution of projects, user management, payment, billing, purchases, accounting, employee payroll, etc.

Client Background

The client, based in Latin America, is a leading solution provider to the construction industry offering a wide range of services to its clientele. The client offers implementation, consulting, training, and technical support services in order to add value and profitability to the customer’s business.

Industry Landscape

Companies around the world are suffering hugely in maintaining and updating their legacy ERP software. They make huge investments in buying a software and then training their employees. The decision to switch to the latest technologies requires significant time for integration and subsequent employee re-training.

Cloud computing provides the best and most flexible platform to the businesses in implementing solutions at their own pace and is less time-consuming.

Opportunity

The client’s existing ERP application was a desktop-based application written in VB6, and multiple instances of the application consumed the same database. This lead to heavy consumption of the system’s resources and as a result led to the application becoming non-responsive most of the times.

Hence, the client wanted to upgrade the existing application to a cloud hosted ERP with a central reporting server. Business logic and processes need to remain intact during this switchover. The new ERP needs to integrate with their existing advanced licensing system with single sign-on feature.

Solution

Q3 Technologies addressed the business requirements by rewriting and migrating the ERP application to the cloud platform and migrating the legacy VB6 code into ASP.Net MVC.

Multi-tenant and Multi lingual feature: A SaaS ERP solution with Multi-tenant feature was implemented for the client where a single instance serves multiple tenants through the sub-domain.

Also, multi lingual support for English and Spanish was provided for the application.

Budget Creation: With the Budgeting module created by Q3, planning for Sales, Target and Baseline budgets can be done for all kinds of construction projects (Residential, Commercial, Public – Road, Malls, Universities, Bridges, Hospitals, etc.). Graphical comparisons with similar projects can be made with budget estimates and ratios. The budgets created can be imported from Excel or exported to MS Project.

This budgeting module is currently the most used construction cost estimating software in Latin America.

Lean Module: Designed with Lean thinking, it enables the client to record activities and plan using Look Ahead for generating the weekly plan and then to verify compliance. A model can be seen with detailed information of the building along with showing and hiding parts of the building. That is, the model can be viewed in 360° degrees.

Planning and Accounting: The Cash & Bank module is fully integrated with the Budgeting and Planning module for Current Account Clients and Current Accounts Suppliers. This module enables advance accounting and planning that can be used by the management of Cash-Banks. It efficiently takes care of the treasury and financial sections of companies, SMEs and accounting studies. Reliability analysis (PPC and CI) can also be performed.

Integration with Microsoft Project: To carry out activities like Budgeting, task planning, planning of finances, material purchase etc. the system was integrated with Microsoft Project.

Advanced database Management functionality: This functionality supported a connection to multiple databases in addition to dynamic database creation, and streamlined backup and restoration processes.

System Re-architecture: Q3 reprocessed the reusable windows components and kept the existing business rules intact while modernizing the application.

Moreover, molded as an N-Tier Application, the use of Entity Framework as ORM for accessing data gave greater control without changing the existing data schema. Q3 developers also made use of the library classes in C# and JavaScript to increase the re-usability of the code.

Single Sign-on: To access multiple modules and to connect seamlessly to other systems, the Single Sign-on (SSO) feature was used.

Multiple Integrations: Integration with customized Licensing management and User management systems across multiple modules was carried out.

Business Impact

Large reductions in the running, maintenance, and operational costs.
The cloud platform provides massive capacity to customize functionalities in the least possible time and in a cost effective manner.
Data redundancy is eliminated and processes are channelized effectively for the business to run