Case Study Banner

CASE STUDY

How i2e Consulting reduced manual efforts by 95% and increased accuracy

industry-iconCLIENT :Confidential
industry-iconINDUSTRY :Automation
industry-iconDURATION :6 months
CLIENT :
Confidential
INDUSTRY :
Automation
DURATION :
6 months

Business case

The client faced significant challenges with the synchronization of project level data between Salesforce and Planisware. Additionally, the process of updating project details in Planisware based on Salesforce data required multiple comparisons causing a significant drain on time and resources. This inefficiency led to delays and errors in project management, which resulted in reduced productivity and increased costs.

The client recognized the need for an automated solution that could synchronize project data and streamline the project creation process, thereby reducing manual effort and improving accuracy.

Our Solution

  • Revise the import scripts to incorporate project level details, which would be essential in ensuring that the project data is updated correctly.
  • Establish an intermediate table with multiple attributes to assess template eligibility and selection. This would reduce the time and effort required for manual selection, as the system would automatically choose the appropriate template based on predefined conditions.
  • Modify project import scripts to automatically create projects by comparing input parameters with the intermediate table to eliminate the risk of human errors.
  • Design and conduct multiple testing procedures to validate the accuracy and efficiency of the automated process.

Results

Results