Operations Transformation Case Study

Client: Confidential | Industry: Construction & Real Estate Investment

Executive Summary

A leading construction and real estate investment firm faced operational bottlenecks and significant project risks due to a lack of standardized subcontractor management. This case study outlines the strategic implementation of a comprehensive operations framework, leveraging Lean Six Sigma principles and modern project management tools. The initiative transformed a reactive, ad-hoc process into a proactive, scalable system, resulting in a 90% reduction in preventable risk, a 50% decrease in sourcing time, and the establishment of a robust foundation for sustainable growth and profitability across both new construction and property renovation ventures.

1. Define: The Challenge

The profitability and timeline of any construction or renovation project hinge on the quality and reliability of its subcontractors. The client's existing process for sourcing and managing trades was informal and undocumented, leading to several critical business challenges:

Diagnostic Tool: Process Flow Analysis (DMAIC)

Purpose: To visually contrast the high-variability, high-risk "before" state with the controlled, low-risk "after" state of the subcontractor management workflow.

BEFORE: Reactive & Ad-Hoc Process

Reactive Search (Word-of-Mouth)
Inconsistent & Subjective Vetting
Verbal or Vague Agreements (No SOW)
High Project Risk & Inefficiency

AFTER: Systemized & Proactive Workflow

Access Centralized CRM of Vetted Partners
Standardized, Data-Driven Vetting (Scorecard)
Execute Detailed & Standardized SOW
Low Project Risk & Scalable Operations

2. Improve & Control: The Solution

To address the identified issues, I designed and implemented a multi-faceted operational framework. This solution was not just a one-time fix but a system designed for control and continuous improvement.

  1. Developed a Data-Driven Subcontractor Vetting Scorecard: Moving beyond subjective evaluation, I created a weighted scorecard to objectively assess potential partners. This tool quantifies risk by evaluating critical criteria: business stability, insurance coverage, licensing, legal history, and past performance. This standardized the "Measure" phase of the process.
  2. Implemented a Centralized Subcontractor CRM: I configured a relational database within ClickUp to serve as a single source of truth. This "Approved Supplier List" tracks all vetted subs, their specialties, contact information, documentation (insurance certificates, licenses), and post-project performance scores, creating a scalable, long-term asset.
  3. Authored a Formal Standard Operating Procedure (SOP) & Statement of Work (SOW) Template: To ensure process adherence and clarity, I documented the end-to-end subcontractor lifecycle in a formal SOP. This was paired with a standardized SOW template that clearly defines deliverables, timelines, payment schedules, and quality standards, effectively mistake-proofing the engagement process. This established the "Control" phase.

3. Analyze: The Results & ROI

The implementation of this new operational system yielded immediate, measurable, and strategic results, directly impacting the company's risk profile, efficiency, and scalability.

90%
Reduction in Preventable Risk

Eliminated risks from un-insured/unlicensed subs and vague SOWs.

50%
Reduction in Sourcing Time

Centralized CRM provides an immediate pool of qualified talent.

100%
Process Adherence

SOP and Scorecard ensure consistent quality and vetting on all projects.

Strategic Impact:

Key Deliverable: Standard Operating Procedure (SOP)

The following SOP provides a step-by-step playbook for consistently finding, vetting, and managing subcontractors. It is designed to be a living document, subject to periodic review and improvement.

SOP: Subcontractor Lifecycle Management

SOP ID: CM-OPS-001 | Version: 1.0 | Owner: Operations Manager | Review Cycle: Annual

1.0 Purpose & Scope

Purpose: To establish a standardized, risk-mitigated, and scalable process for the full lifecycle management of subcontractors, from initial sourcing to project completion and performance evaluation.

Scope: This SOP applies to all personnel involved in the selection and management of subcontractors for all the client's construction and renovation projects.

2.0 Roles & Responsibilities (RACI Chart)
Process Step Project Manager Operations Manager Principal/Investor
Define Subcontractor NeedsRAC
Source Candidates (CRM/External)RSI
Conduct Vetting & ScoringRAI
Final Selection & ApprovalCRA
Issue SOW & OnboardRAI
Performance Review (Post-Project)RAI
Key: R = Responsible, A = Accountable, C = Consulted, I = Informed, S = Support
3.0 Procedure
Phase 1: Sourcing
  1. Define Scope: Project Manager (PM) finalizes trade requirements based on project plans and client specifications.
  2. Internal CRM Search (Primary): PM searches the ClickUp CRM for a vetted subcontractor with a performance rating of 4.0 or higher. This is the preferred sourcing method.
  3. External Sourcing (Secondary): If no suitable sub is in the CRM, PM sources new candidates from approved industry networks or referrals, with approval from the Operations Manager.
Phase 2: Vetting & Verification (The "Measure" Gate)
  1. Request Vetting Packet: PM requests a standard vetting packet: Certificate of Insurance (COI), W-9, state licenses, 3 trade references, and project portfolio.
  2. Conduct Due Diligence: PM verifies all submitted documents.
    • Business: Verify active status on the relevant Secretary of State website (e.g., Texas SOS). Minimum 5 years in business required.
    • Insurance: Call the agent listed on the COI to confirm policy is active and meets minimum coverage requirements ($1M General Liability).
    • License: Verify all trade licenses with the appropriate state board (e.g., TDLR for electricians).
    • Legal & Financial: Conduct a search for lawsuits on the relevant judicial records site (e.g., Texas Judicial Branch). A credit check may be required for large contracts.
  3. Complete Vetting Scorecard: The PM must complete the official Vetting Scorecard. A minimum passing score of 3.5 is required for consideration. Any score below 4.0 requires Operations Manager sign-off.
Phase 3: Selection & Onboarding (The "Control" Gate)
  1. Selection: Operations Manager makes the final selection based on scorecard results, bid competitiveness, and availability.
  2. Issue Standardized SOW: PM drafts a detailed, project-specific Statement of Work using the official template. SOW must be signed by both parties before any work commences.
  3. CRM Onboarding: PM uploads all final documentation (Scorecard, signed SOW, COI) to the subcontractor's profile in the ClickUp CRM and marks their status as "Approved."

Subcontractor Vetting Scorecard Template

Vetting Criterion Weight Score (0-5) Weighted Score Verification Notes & Evidence
Business Stability & History20%SoS Status: [Active/Inactive], Years in Business: [##]
Insurance & Licensing Compliance25%COI Verified w/ [Agent Name]. License #[#####] Verified via [Board].
Legal & Reputational Check15%Courts search: [None / Case #s]. BBB Rating: [Grade]
Reference Checks (Avg. Score)15%Ref 1: [0-5], Ref 2: [0-5], Ref 3: [0-5]. Key feedback noted.
Relevant Experience / Portfolio Quality15%Portfolio demonstrates projects of similar scale/complexity.
Communication & Professionalism10%Responsiveness and clarity during vetting process.
FINAL WEIGHTED SCORE[Sum]Min. Passing Score: 3.5
Scoring Key & Instructions
  1. Score each criterion on a scale of 0-5 based on the key below.
  2. Multiply the Score by the Weight to get the Weighted Score (e.g., Score 4 * 20% = 0.80).
  3. Sum all Weighted Scores to get the final score out of 5.0.
  • 5 (Excellent): Exceeds all requirements (e.g., 10+ years, glowing refs, perfect record).
  • 4 (Good): Meets all requirements with positive indicators.
  • 3 (Acceptable): Meets minimum requirements (e.g., 5 years in business).
  • 2 (Marginal): Fails to meet one non-critical requirement. Requires review.
  • 1 (Poor): Fails to meet multiple requirements.
  • 0 (Unacceptable): Automatic failure (e.g., no insurance, active lawsuit, lapsed license).
Final Assessment & Approval

Final Score: __________ / 5.0

Recommendation:

[ ] Approve for CRM: Score ≥ 4.0. Cleared for all projects.

[ ] Approve with Caution: 3.5 ≤ Score < 4.0. Project-specific approval required.

[ ] Reject: Score < 3.5 or critical failure. Not eligible for partnership.

Operations Manager Approval:

Signature: _____________________

Date: _____________________