Build a Supplier Onboarding Document Quality and Expiry Risk Packager — implementation

## Build
Extract, validate, and audit supplier onboarding compliance documents using Frictionless Data framework specifications. Track nearing expiration deadlines for anti-bribery declarations and ISO certifications to maintain enterprise onboarding readiness.

## User
Corporate Procurement Onboarding Specialist

## Workflow
1. Extract tabular onboarding documentation metadata submitted by prospective enterprise suppliers.
2. Run automated Frictionless Data validation checks against strict pre-defined schema constraints and field types.
3. Calculate risk scores based on missing mandatory certifications and documents expiring within 60 days.
4. Compile a comprehensive supplier onboarding qualification report specifying missing items and required re-submissions.

## Interface
An onboarding status grid showing certificate validation status, days to expiry, and required corrective uploads.

## Data
Fictional supplier compliance metadata CSV files tested against Frictionless Data Table Schemas in a sandbox.
Starter examples below are synthetic. They are not downloaded records.

## Source
[Frictionless data validation](https://raw.githubusercontent.com/frictionlessdata/frictionless-py/main/README.md)
Implements Frictionless Data validation functions, error codes like blank-header and missing-cell, and data packages.

## Tools
semantic-kernel, frictionless, pandas.
Semantic Kernel orchestrates data validation skills with enterprise notification plugins for clean pipeline modularity.
OpenAI or Azure OpenAI endpoint accessed via Semantic Kernel connectors for generating remediation guidance.

## Deliverables
Submit runnable source, pinned dependencies, setup commands, a working interface, example outputs, and a recorded end-to-end demo. Include tests and an action log.

## Acceptance
- Catches Frictionless validation errors including missing mandatory headers and malformed date strings.
- Flags vendors with certifications expiring within 60 days of the reference evaluation date.
- Emits a structured JSON qualification summary detailing specific document failure codes.

## Starter Examples
```json
[
  {
    "input": {
      "supplier_name": "Nordic Fabrication AB",
      "records": [
        {
          "cert_name": "ANTI_BRIBERY_POLICY",
          "issue_date": "2023-01-01",
          "expiry_date": "2024-03-15"
        },
        {
          "cert_name": "CYBER_SECURITY_AUDIT",
          "issue_date": "2023-06-01",
          "expiry_date": "2025-06-01"
        }
      ],
      "current_date": "2024-02-01"
    },
    "expected_output": {
      "supplier_name": "Nordic Fabrication AB",
      "onboarding_status": "CONDITIONAL_APPROVAL",
      "expiring_certs": [
        "ANTI_BRIBERY_POLICY"
      ],
      "days_until_next_expiry": 43,
      "resubmission_required": true
    }
  },
  {
    "input": {
      "supplier_name": "Faulty Data Ltd",
      "records": [
        {
          "cert_name": "",
          "issue_date": "invalid-date",
          "expiry_date": "none"
        }
      ],
      "current_date": "2024-02-01"
    },
    "expected_output": {
      "supplier_name": "Faulty Data Ltd",
      "onboarding_status": "REJECTED_SCHEMA_INVALID",
      "expiring_certs": [],
      "days_until_next_expiry": null,
      "resubmission_required": true
    }
  }
]
```

## Safety
Maintains a read-only compliance intake workflow without automated blacklisting or commercial contract execution.
Use mock external writes. Require human review before any real deployment.