Sector(s)

Team Members

zuhair_ak, rameshkisku, prashdev, johnny_aroza

Visit the site

Visit the site

Organizations Involved

Community contributions

https://www.drupal.org/project/bootstrap/issues/2887742

BCP associates is a neutral, objective and independent Legal audit firm specializing in audit techniques aimed at helping companies achieve 100% compliance levels. With a high focus on Law and Ethics, they identify a firm's risk exposures based on state and industry regulations and provide solutions to control them.

Specbee was entrusted with the task of rebuilding the software auditing application for BCP Associates, that would help companies to keep a check on their labour law compliances. They needed an enhanced application tool with a better architecture for faster and systematic performance.

About the project

The primary goal of the project was to completely revamp/rebuild the auditing tool for BCP Associates, in order to deliver seamless audit reports for their firms. This meant re-designing the architecture in such a way that the application was capable of handling large volumes of data and at the same time make it easy for companies, their units and vendors, to calculate their compliance with the labour laws.

OBJECTIVES

  • Recreate and Develop an auditing application to calculate law compliances of Companies, Units and Vendors separately.
  • Ability to generate individual audit reports for each unit and vendor under a firm.
  • Provide companies, their units and vendors, role based login access to their reports.

OUR SOLUTION
Leveraging Drupal's out of the box features and understanding the client requirements, we at Specbee created an application system with a high level of scalability and user management.

  • Enabled a custom workflow for the auditors to cross check the work of a junior and senior level auditor until it is published.
  • Provided a customized dashboard to show audit results in various charts (using HighCharts) based on their role for a particular period.
  • User roles and permissions added to different kinds of users in the form of units and vendors, based on hierarchical user management.

KEY FEATURES

  • Performing simultaneous multiple audits to calculate the labour law compliances of vendors and units of a firm by using Drupal Batch.
  • Integration of CDM File Manager using Symphony to allow vendors to upload their documents for audit.
  • Role based access to their reports for units and vendors using Drupal’s roles and permissions.
  • Ability to see and download their monthly audit reports in HTML/PDF/Excel formats.

TECHNICAL EXPERTISE

  • Used Drupal 7 Entity API and custom database schema to build the data architecture of the system.
  • Used Drupal Form API to build the Audit form to indicate the status of the law for a company and calculate compliance scores based on it for a particular period.
  • CDM integration for uploading the required documents for audit, from vendors.
  • Used "PHP WK HTML to PDF" and "PHPExcel" to allow vendors to get their reports in Excel or PDF format.

RESULT

  • The project was delivered well within the defined time and budgets.
  • A highly improved performance with respect to the Turn Around Time (TAT) of the software application.
  • The new application projects a better workflow, enabling better communication between the auditors and also the vendors of a company, resulting in a substantially lesser OPEX.

Why Drupal was chosen

The team envisioned a digital space where firms could master the legal auditing of their vendors, from various verticals. For this, they needed an auditing application with easy user management, was scalable, was fast and could let firms perform multiple audits and check for compliance of their units and vendors.

However, their existing application tool had major scalability issues and required optimizations in order to handle data in a better manner. Also, their tool was incapable of producing efficient audit report results for companies or their vendors, thus complicating the entire process.

With every firm having their own set of vendors, and each vendor having to comply with the labour law and ethics, the BCP team needed their application to perform principal employer audits in an efficient manner.

Drupal was the ideal choice to rebuild the auditing application because of its ability to handle the scaling challenges and the frequent vendor changes. With the flexibility and the robustness for seamless third party integration, Drupal allowed vendors and units to provide the required legal documents for compliance check. With a plethora of contributed modules in Drupal, most of the requirements could be met with mostly out of the box solutions or these contributed modules.

Technical Specifications

Drupal version:

Why these modules/theme/distribution were chosen

Administer Users by Role
This module was used for user management by setting fine-grained permissions and access to selected users in the application.

Role delegation
Role delegation played an important role in granting specific roles while creating a user in the application.

Services
This module allowed external clients to communicate with Drupal by building API's, thus allowing other modules to expose their features and functionality.

PHPWkHtmlToPdf
This module allows companies, units and vendors to import data from their HTML audit reports in PDF format.

PHPExcel
This module allows companies, units and vendors to import data from their HTML audit reports in EXCEL format.