Workforce Overview
Employees
77.8
32.4%
▲ +0.5 MoM
Consultants
162.3
67.6%
▼ +5.2 MoM
Onsite
54.5
22.7%
▼ -0.3 MoM
Nearshore
61.3
25.5%
▼ -5.2 MoM
Offshore
124.3
51.8%
▲ +6.4 MoM
💡 Executive Analysis
The organization employs 240.1 FTE as of Dec 2024, with a 67.6% consultant dependency. The offshore ratio has climbed to 51.8%, reflecting continued cost-optimization efforts. Employee FTE remains stable at 77.8 despite seasonal fluctuations, suggesting workforce planning is maintaining headcount targets. The consultant-to-employee ratio of 2.1:1 warrants monitoring for knowledge retention risk.

Service Type Distribution

Effort allocation across service categories
💡 Analysis
New Development commands 53.3% of total effort — a healthy indicator of forward investment. System Support at 34.4% is within the typical 30-40% band for mature portfolios. Admin overhead at 13.0% is slightly elevated; consider reviewing admin-heavy programs like Echo Data Lake (26.3% admin) for process optimization.

Program Distribution Trend

Monthly FTE by location type (36-month view)
💡 Analysis
Total FTE has been remarkably stable in the 225-248 range over 3 years, indicating disciplined workforce planning. Offshore has consistently dominated at ~50%, with onsite holding steady around 23%. The nearshore segment shows the most volatility (57-67 FTE), suggesting it serves as the flex capacity lever for demand changes.

⚠ Top Alerts — High Offshore Concentration

Programs with offshore ratio above 55%
ProgramOnsiteOffshoreOffshore %
💡 Analysis
Programs like Meridian API Gateway (70.3%) and Atlas Data Platform (67.3%) carry significant offshore concentration risk. High offshore ratios above 65% can impact response times for critical incidents and create timezone coordination challenges. Consider balancing with nearshore resources.

✔ Top Performers — Balanced Distribution

Programs with healthy onsite-offshore balance (onsite > 30%)
ProgramOnsiteOffshoreOnsite %
💡 Analysis
Beacon Self-Service Hub (47.6%) and Nexus Identity Management (47.5%) lead with the strongest onsite presence, enabling better stakeholder alignment and faster iteration cycles. These programs also show strong YoY growth, correlating higher onsite engagement with program success.

Vendors for Portfolio

Size = FTE contribution | Blue = Offshore < 65% | Orange = Offshore ≥ 65%
💡 Analysis
InnoSphere leads vendor FTE at 19.5, followed by HorizonLabs (17.4) and KeyNode Services (16.8). Vendor concentration risk is moderate — the top 3 vendors represent 33% of total consultant FTE. BrightPath Tech and DataBridge Corp show the highest offshore ratios (>67%), while Apex Solutions maintains the most balanced onsite presence (43.7%).

Portfolio FTE Trend

Monthly FTE by portfolio (36-month view)
💡 Analysis
Digital Transformation and Customer Experience Platform are the two largest portfolios, each averaging ~60 FTE. Enterprise Infrastructure has grown steadily from ~58 to ~61 FTE, reflecting increased investment in reliability. Data & Analytics remains stable at ~57 FTE, though it showed a brief spike in early 2024 aligned with the Summit BI Dashboard initiative.
Employee & Consultant Analysis
54.5
Onsite FTE
61.3
Nearshore FTE
124.3
Offshore FTE

Location Distribution — All Resources

Breakdown of 240.1 total FTE by delivery location
77.8
EMPLOYEE
162.3
CONSULTANT
240.1
TOTAL
💡 Analysis
The 2.1:1 consultant-to-employee ratio is consistent with an outsourced delivery model. Offshore dominates at 51.8%, with nearshore at 25.5% providing a middle-ground option. The relatively low onsite presence of 22.7% suggests most client-facing work is handled by a lean onsite team coordinating with offshore delivery.

Consultants Only — Location Split

162.3 consultant FTE by delivery location
36.7
ONSITE (22.6%)
36.3
NEARSHORE (22.4%)
89.3
OFFSHORE (55.0%)
💡 Analysis
Consultants are more offshore-heavy (55.0%) compared to the overall workforce (51.8%), which is expected as offshore typically offers better cost ratios for consultant roles. Onsite and nearshore consultant presence is nearly equal (~22% each), creating a well-distributed model across time zones.

Teams Supporting the Portfolio

FTE contribution by department
💡 Analysis
Data Services (34.7 FTE) is the largest department, reflecting the organization's data-centric strategy. Quality Assurance at 27.3 FTE represents an 11.4% allocation to testing — within industry norms. The presence of regional delivery centers (APD: 26.2, EMEA: 21.5) indicates a follow-the-sun delivery model, which aligns with the high offshore/nearshore mix.

Active Projects & Percent of Effort

Service type breakdown across 20 active programs
127.6
NEW DEVELOPMENT
53.1%
82.5
SYSTEM SUPPORT
34.4%
30.0
ADMIN
12.5%
💡 Analysis
The 53/34/12 split between New Dev, System Support, and Admin is a healthy indicator. Organizations investing >50% in new development are typically in a growth phase. New Development further breaks down into Platform Migration (65.0 FTE) and Greenfield Build (62.6 FTE), showing near-equal investment in modernization vs. new capabilities.

Program Summary Table

Program / Platform Portfolio Total Empl Cons Onsite % Offshore % MoM YoY % New Dev Sys Sup Admin
💡 Program Trends Analysis
Growth leaders: Summit BI Dashboard (+26.9% YoY) and Zenith Reporting Engine (+23.2% YoY) are scaling rapidly — both in Data & Analytics, confirming the analytics investment thesis. Declining: Vertex ML Platform (-23.1% YoY) and Meridian API Gateway (-18.0% YoY) are contracting; verify if these are planned phase-downs or unintended attrition. MoM momentum: Summit BI Dashboard (+5.4) and Horizon Disaster Recovery (+2.5) are actively ramping, while Nexus Identity Management (-3.0) and Sentinel Monitoring Suite (-2.7) are decelerating.

Top 10 Programs by FTE

💡 Analysis
The top 3 programs (Titan, Orbit, Summit) account for 47.9 FTE — 20% of total workforce. FTE distribution is relatively even, with no single program exceeding 7.2% of total, indicating good diversification and manageable program risk.

FTE by Portfolio

Aggregated program FTE by portfolio grouping
💡 Analysis
Enterprise Infrastructure leads with 60.8 FTE (25.3%), closely followed by Customer Experience Platform at 61.3 FTE. Digital Transformation at 58.5 and Data & Analytics at 59.5 round out a remarkably balanced portfolio. This even distribution reduces concentration risk and supports parallel strategic initiatives.
Vendor Analysis — December 2024

Vendor FTE Distribution

FTE contribution by vendor with location breakdown
💡 Analysis
InnoSphere (19.5 FTE) is the top vendor, contributing 12% of total consultant FTE. The vendor landscape is well-distributed with 11 active vendors, preventing single-vendor dependency. CoreWave Systems stands out with the highest nearshore ratio (42.5%), while BrightPath Tech is the most offshore-heavy (67.7%). Consider rebalancing vendors with >65% offshore for critical path programs.

Vendor Location Mix

Onsite / Nearshore / Offshore percentage per vendor
💡 Analysis
Apex Solutions has the best onsite/offshore balance (43.7% onsite), making it ideal for client-facing work. DataBridge Corp and LogicNest are heavily offshore-leaning (>58% offshore, <10% onsite), which works for backend development but creates risk for programs requiring rapid iteration. The nearshore segment varies widely from 10% (LogicNest) to 43% (CoreWave), suggesting different vendor sourcing strategies.

Program × Vendor Matrix

FTE allocation showing which vendors support which programs (top 10 programs shown)
💡 Analysis
Most programs use 7-10 vendors, indicating healthy multi-vendor strategies. However, some programs show strong single-vendor dependencies — e.g., Echo Data Lake relies on KeyNode Services for 3.0 FTE (30% of its consultant base). Cross-referencing vendor concentration with program criticality can highlight supply-chain risks requiring contingency plans.
Department Analysis — December 2024

Department FTE with Location Breakdown

Stacked bar showing onsite, nearshore, and offshore per department
💡 Analysis
Data Services has the largest team at 34.7 FTE but also the highest offshore concentration (55.9%). Quality Assurance is the most balanced department with 28.2% onsite, 33.7% nearshore, and 38.1% offshore — a model distribution. Regional delivery centers (APD, EMEA) naturally skew offshore/nearshore but maintain a meaningful onsite liaison presence of ~25%.

Department Offshore Percentage

Ranked by offshore concentration — higher = more risk
💡 Analysis
Six departments exceed 50% offshore: Digital Strategy, Application Engineering, EMEA Delivery, Process Automation, Data Services, and Platform Core. Cloud Operations has the lowest offshore ratio at 42.1%, reflecting the need for tighter timezone alignment in infrastructure operations. Consider establishing a 50% offshore cap guideline for departments handling production-critical systems.

Department Detail Table

Complete department metrics with location distribution
Department Total FTE Onsite Nearshore Offshore Onsite % Offshore % Risk Level
💡 Analysis
Departments are categorized by offshore risk: Green (<50%), Yellow (50-60%), Red (>60%). Currently 4 departments are in the green zone and 6 in the yellow zone. No department exceeds the 60% critical threshold, which is positive. The aggregate offshore percentage of 51.8% across all departments is within the target band for a global delivery model.