Case Study | Ford Motor Company

Ford Optimizes Clarity PPM Performance for 10,000 Users

  • Company: Ford Motor Company

  • Industry: Automotive Manufacturing

  • Size: Over 200,000 employees

The Customer: Innovation for Every Lifestyle

Since 1903, Ford has been a pioneer in automotive manufacturing. As the second-largest automotive manufacturer in the USA and a Fortune 500 company, Ford continues to innovate while being recognized among the Ethisphere® Institute’s Top 100 Ethical Companies.

The Challenge: Safeguarding Productivity for 10,000 Users

With around 20,000 active projects and 10,000 Clarity PPM users, Ford depends on a high-performing solution to ensure project success and operational efficiency. However, database, portlet, and configuration issues began to impact user productivity, causing delays and frustration as users struggled to access critical project data efficiently.

Ford sought an experienced partner to identify and resolve these performance issues.

The Solution: Performance Analysis and Optimization

Ford partnered with Rego Consulting to review and remediate its Clarity PPM implementation. Rego’s PPM experts conducted a thorough analysis, pinpointing root causes of the portlet issues and providing targeted solutions:

  • Portlet Optimization: Introduced filters, reconfigured pages to render only with filters, and set default filters to streamline data retrieval.
  • Query Optimization: Improved query execution by:
    • Replacing ‘not in’ queries with ‘not exist.’
    • Using precompiled sources and stored procedures with indexed reporting tables.
    • Designing portlets and queries with date range restrictions to reduce excessive data returns.
    • Eliminating nested sub-queries that strained system performance.

The Benefits: Stabilized Performance and Increased Productivity

Rego Consulting’s expertise restored system performance, eliminating long-running sessions that caused delays and enhancing portlet and reporting speeds. Key results include:

  • Improved User Experience: Faster system response times increased productivity for Ford’s 10,000 Clarity PPM users.
  • Boosted Efficiency: Optimized Clarity PPM performance empowered project teams to work more efficiently.
  • Enhanced Satisfaction: Better usability and speed improved satisfaction levels among project teams.

With Rego Consulting’s guidance, Ford stabilized its Clarity PPM performance, enabling its teams to focus on delivering innovation and maintaining its competitive edge.

Get started with your personalized demo

Managing projects efficiently is crucial. Clarity pricing packages are tailored to your specific needs. Contact our team to get your customized package.