Warranty Claim Analytics for Metro Santo Domingo
Excel-based analytical framework for identifying reimbursable and replaceable spare-part failures under contract warranty criteria across metro maintenance operations.
Project Overview
I designed a comprehensive Excel-based analysis to manage spare-parts warranty claims for Metro Santo Domingo. The model consolidated maintenance records and structured each case by system, failure start and end dates, failure description, responsibility, asset, spare part involved, station, and contract criteria, creating an auditable baseline for claim decisions.
Main Features
- Standardized failure-event registry organized by technical and contractual claim variables.
- Methodology to derive affected asset, spare part, and station directly from failure descriptions.
- Responsibility-based filtering to separate contractor-liable from non-claimable events.
- Contract-criteria validation matrix for reimbursement or replacement eligibility.
- Executive-ready summary outputs supporting formal claim submission decisions.
Key Components
Failure Description Parsing
Defined repeatable rules to interpret free-text failure descriptions and map each event to the correct asset, spare part, and station.
Warranty Eligibility Logic
Applied responsibility assignment and contractual thresholds to flag which parts did not meet claim conditions versus those eligible for reimbursement or replacement.
Executive Claim Reporting
Prepared the final technical report with validated evidence tables, station-level findings, and contract-based justification for executive claim submission.
Operational Impact
The analysis transformed dispersed maintenance history into a defensible warranty claim package, improving traceability and decision quality. By linking technical failures to contractual responsibility and criteria, the project enabled a faster and stronger executive submission process for reimbursement and replacement claims.