Regal Solar Energy_ React

Worked on BOM extraction and inventory reconciliation for project-based workflows.

The task involved extracting Bill of Materials (BOM) data from plan set files stored in an AWS S3 bucket using a Python-based extraction script. The extracted BOM items are normalized and stored in the system with relevant details such as name, description, and required quantity.

After extraction, each BOM item is compared against the existing system inventory to determine the appropriate matching level. Based on the comparison results, items are classified as manual, suggested, or unmatched.

For items that do not match any existing inventory records, unmatched inventory entries are automatically created in the system with a default quantity of 0 to ensure completeness and traceability of BOM requirements. This allows unmatched materials to be tracked, reviewed, and resolved later without blocking the workflow.

Suggested matches include one or more potential inventory items along with confidence scores, enabling controlled selection before final mapping. Allocation-related fields such as required quantity, assigned quantity, and allocation status are maintained per BOM item to support partial and full allocation scenarios.

The overall task ensures reliable synchronization between extracted BOM data and system inventory while supporting review-driven matching and future inventory updates