Teradata Data Mart Consolidation Return on Investment at GST Custom Case Solution & Analysis

1. Evidence Brief: Data Extraction and Classification

Financial Metrics

Initial Investment: $10.1 million total capital expenditure for Teradata hardware, software, and initial implementation services.
Current Operating Cost: $4.5 million annually to maintain 15 disparate data marts across business units.
Projected Annual Operating Cost (Post-Consolidation): $2.1 million for the centralized Enterprise Data Warehouse (EDW).
Quantified Annual Benefits: $6.3 million total, comprised of $2.4 million in IT cost avoidance and $3.9 million in business process improvements (procurement and inventory optimization).
Financial Performance Targets: 5-year Net Present Value (NPV) of $11.8 million, Internal Rate of Return (IRR) of 38%, and a payback period of 2.4 years.

Operational Facts

Infrastructure State: 15 independent data marts running on varied platforms including Oracle, SQL Server, and local Access databases.
Data Redundancy: Approximately 60% of data is duplicated across multiple marts, leading to conflicting versions of truth for customer and supplier records.
User Base: 400+ power users and analysts currently accessing fragmented systems.
Geographic Scope: GST operates as a $12 billion industrial conglomerate with facilities in 22 countries.

Stakeholder Positions

John Geraci (CIO): Primary advocate for consolidation. Argues that fragmented data prevents enterprise-level decision-making and inflates IT overhead.
Susan Smith (CFO): Skeptical of intangible benefits. Demands a rigorous ROI model that excludes soft productivity gains and focuses on hard cost savings.
Business Unit Managers: Protective of local data marts. Fear losing autonomy over their specific reporting logic and worry about centralized IT responsiveness.
Procurement Team: Supportive of the project if it enables global spend visibility to negotiate better vendor contracts.

Information Gaps

Data Migration Complexity: The case does not quantify the specific man-hours required for Extract, Transform, Load (ETL) mapping from legacy systems.
Talent Readiness: Current internal IT skill levels regarding Teradata-specific architecture are not detailed.
Vendor Lock-in: Long-term pricing escalations for Teradata licensing post-initial contract are absent.

2. Strategic Analysis

Core Strategic Question

Can GST transition from a decentralized, siloed data architecture to a centralized Enterprise Data Warehouse (EDW) to capture $6.3 million in annual value without disrupting business unit operations?

Structural Analysis (Resource-Based View)

GST currently lacks a VRIO (Valuable, Rare, Inimitable, Organized) data asset. While data exists, it is unorganized and redundant. Consolidation transforms data from a departmental liability into a corporate strategic asset. The current 15-mart structure creates a structural disadvantage in procurement, where GST cannot see its total spend with single vendors across units, losing significant negotiation power.

Strategic Options

Option 1: Full Enterprise Consolidation (Recommended). Migrate all 15 data marts to a single Teradata EDW over 18 months.
- Rationale: Maximum cost savings and single version of truth.
- Trade-offs: High upfront capital requirement and significant organizational resistance.
- Resource Requirements: $10.1 million capital and a dedicated cross-functional migration team.
Option 2: Hybrid Middleware Layer. Implement a virtualization layer over existing marts without decommissioning them.
- Rationale: Lower immediate disruption and lower capital cost.
- Trade-offs: Fails to eliminate the $4.5 million annual maintenance cost of legacy marts; does not solve data inconsistency at the source.
- Resource Requirements: $3 million in software and integration services.
Option 3: Selective High-Value Consolidation. Consolidate only the top 3 marts (Procurement, Finance, Sales).
- Rationale: Captures 80% of business value with 20% of the migration risk.
- Trade-offs: Leaves $1.5 million in redundant IT costs on the table and maintains data fragmentation for other units.
- Resource Requirements: $5 million capital.

Preliminary Recommendation

Pursue Option 1. The 38% IRR and 2.4-year payback meet the CFO's stringent criteria. The current fragmentation is a structural barrier to GST's ability to operate as a $12 billion entity rather than a holding company of smaller firms. Speed is essential to stop the $4.5 million annual burn on inefficient infrastructure.

3. Implementation Roadmap

Critical Path

Month 1-2: Establish Data Governance Council. Define enterprise-wide data standards for customer and vendor masters. This must precede any technical migration.
Month 3-5: Infrastructure Deployment. Install Teradata hardware and configure the core environment.
Month 6-12: Phased Migration (Wave 1). Migrate Procurement and Inventory data marts. These provide the $3.9 million in business benefits required to prove the project's value to the CFO.
Month 13-18: Phased Migration (Wave 2). Migrate remaining 12 data marts and decommission legacy hardware to realize IT cost savings.

Key Constraints

Data Ownership Politics: Business Unit Managers will resist centralized control. Success depends on the CEO mandating the transition as a corporate priority.
ETL Complexity: Mapping 15 different data schemas into one will likely reveal significant data quality issues that could delay the timeline.

Risk-Adjusted Implementation Strategy

The plan assumes a 20% buffer for data cleaning activities. To mitigate resistance, the implementation team will provide BU managers with enhanced self-service BI tools that were unavailable in the legacy marts, creating an incentive for adoption rather than just a mandate for compliance. Legacy systems will be kept in read-only mode for 90 days post-migration to ensure business continuity.

4. Executive Review and BLUF

BLUF

GST must consolidate its 15 fragmented data marts into a single Teradata Enterprise Data Warehouse. The current architecture costs $4.5 million annually and prevents global visibility into a $12 billion operation. The $10.1 million investment delivers a 38% IRR and $11.8 million NPV over five years. Payback occurs in month 29. The strategic value lies in procurement optimization and the elimination of redundant IT spend. Delays will result in $200,000 of wasted maintenance costs per month of inaction.

Dangerous Assumption

The analysis assumes that the $3.9 million in business benefits from procurement and inventory will be realized through data availability alone. Data does not change costs; management action does. If the procurement team does not use the new visibility to renegotiate contracts, 60% of the project's value proposition disappears.

Unaddressed Risks

Operational Risk: High probability. Data migration often uncovers deep-seated data quality issues that extend the ETL phase by 50% or more.
Human Capital Risk: Moderate probability. Teradata expertise is specialized. GST lacks internal experience, creating a dependency on high-cost external consultants.

Unconsidered Alternative

A cloud-native migration (AWS Redshift or Snowflake) was not evaluated. While Teradata is a proven enterprise performer, a cloud-based approach could convert the $10.1 million capital expenditure into an operational expense, potentially appealing more to the CFO's desire for flexibility and reducing the initial cash outlay.