Overview
Bravia IFSC manages multiple import-export businesses involving international and domestic vendors and suppliers. With thousands of purchase records across multiple years, they struggled to maintain accurate vendor-wise history, optimize sourcing, and manage inventory across business units.
To address these challenges, iBirds Software Services developed a customized Inventory Management CRM that streamlined purchase management, vendor comparison, and inventory tracking. The system empowered Bravia IFSC with real-time insights, cost optimization, and efficient supply chain operations across domestic and international networks.
Technologies Used
Frontend: React.js
Backend: Node.js
Database: PostgreSQL
Deployment: AWS EC2
Key Challenges
Bulk Data Migration – Needed to migrate historical purchase records spanning multiple years into the new system.
Price Comparison Gaps – Required visibility into last purchase prices to optimize vendor sourcing.
Vendor Overlap Issues – Multiple vendors supplied the same item, causing confusion in cost analysis.
Complex Supply Chains – Needed a unified system to track inventory across international and domestic supply chains.
Purchase Management Module
Developed vendor-wise and product-wise purchase logs.
Allowed teams to track all purchases historically with accurate details.
Price Comparison Feature
Implemented logic to compare current vendor quotes with historical purchase prices.
Helped decision-makers identify the most cost-effective vendor for each item.
Bulk Data Import Tool
Designed a tool to import multi-year historical purchase data.
Integrated validation and duplicate-checking logic to maintain data integrity.
Advanced Filtering
Enabled filtering by:
Vendor
Product Category
Last Purchase Date
Allowed quick insights into vendor performance and procurement cycles.
Outcomes & Impact
Optimized Vendor Selection: Price comparison feature improved sourcing decisions and reduced procurement costs.
Streamlined Data Migration: Successfully migrated years of historical data with no loss of accuracy.
Clear Inventory Visibility: Multi-unit segmentation enabled centralized yet flexible inventory oversight.
Improved Cost Analysis: Vendor-wise and product-wise logs reduced confusion and enhanced negotiation power.
Efficient Supply Chain Management: Unified system improved control over both international and domestic operations.
Faster Decision-Making: Advanced filters and reporting gave leadership actionable insights in real time.
