Performance and efficiency delivery in project management systems

Matasma engaged with a global automotive player to enhance performance and efficiency in large scale project management systems

Challenges

Global supply chain issues, such as semiconductor shortages, can impact production and delivery.
  • Managing a PMS for 5,000+ employees across 3 countries, involving over 4,000 projects and 10,000+ activities, while maintaining system performance
  • The model performance was slow due to continuous user data loading for timesheet filling, leading to delays and inefficiencies
  • The model size was approximately 70+ GB, with daily granularity for weekly data, resulting in significant overhead and inefficiencies
  • Project creation took 2 hours, and resource allocation occurred only a day later, delaying project execution and timesheet filling

Our Approach

01
The existing excel based planning process was cumbersome, often taking up to 3 weeks to develop rolling forecast.
  • Refined the model structure to handle large-scale operations efficiently
  • Automated project creation to make it real-time, removing staging and templates for project creation
  • Reduced data granularity from daily to weekly to improve performance, with daily data loading and weekly analytics
  • Enabled real-time activity for resource allocation and timesheet updates for smoother operations

Delivered Outcomes

Global supply chain issues, such as semiconductor shortages, can impact production and delivery.
  • Developed real-time project creation, eliminating the 2-hour initiation delay and optimizing project timelines
  • Built real-time activity resource allocation and timesheet filling, improving team productivity
  • Reduced the model size from 70 GB to 20 GB, significantly improving performance and scalability
  • Successfully managed 5,000+ users, 4,000+ projects, and 10,000+ activities across 3 countries, ensuring smooth performance without any concurrency issues

Let’s Transform Your Business Together

Have a challenge you need solved? Reach out to us today!
Stay in the loop and sign up for the Matasma newsletter.
By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.