Project Overview
Coborder is a logistics and purchase-order management platform that centralizes purchase order creation, box & shipment tracking, and supplier reconciliation. The platform provides tools for per-box GRN tracking, PI/sync automation, and export/reporting to support operations and finance teams with accurate shipment documentation.
My Role
Led backend development and integrations: implemented core reconciliation logic, designed MongoDB queries and aggregation pipelines, authored export formatting using Maatwebsite Excel, and implemented observers and queueable jobs to reliably process catalog sync and PI pushing workflows.
Key Challenges & Solutions
1. Accurate product representation with multiple boxes
Challenge: Multiple boxes per product generated duplicate “remaining” rows and inconsistent exports.
Solution: Refactored payload generation to emit one row per received box (when GRN exists) and a single "remaining" row per product if required. Also used latest-GRN-per-box logic.
2. Cross-collection filtering and pagination
Challenge: Filtering by SKU/status required queries spanning purchase_order_products and box collections, while preserving correct pagination.
Solution: Precomputed matching PO IDs from box filters and catalog IDs from master_sku matches, applied filters before pagination, and used intersections where necessary.
3. Latest-GRN-per-box aggregation
Challenge: Required sum of the latest GRN entry per box (not sum of all updates).
Solution: Implemented MongoDB aggregation to group by box_id and pick the GRN record with the highest modified, then sum the corresponding received_count.
4. Styled, accurate Excel exports
Built export templates using Maatwebsite Excel with WithEvents and WithStyles to create title rows, bold headers, merged metadata cells, and auto-sized columns for business-ready PI/shipment documents.
Technical Skills Used
Measurable Results
Future Enhancements
- GRN timeline dashboard: visualize per-box GRN history and diffs.
- Move heavy aggregations to optimized MongoDB pipelines and add indexes for large datasets.
- Real-time notifications via websockets for status updates.
- Role-based dashboards and approval workflows for PI syncs.
- Comprehensive automated test coverage for reconciliation and export logic.