Gold & Gems

Executive Summary

Enterprise jewellery commerce platform featuring real-time multi-branch inventory synchronization, dynamic daily bullion spot-price calculation, complex gemstone attribute filtering, and high-concurrency checkout security.

Problem & Objectives

High-value jewellery retail operations required dynamic daily metal spot-price recalculations across tens of thousands of customizable products, along with zero-latency synchronization between physical boutique inventories and online checkout to prevent overselling.

Key Technical Contributions

• Engineered a real-time dynamic pricing engine calculating product prices based on fluctuating live metal spot rates, diamond carats, making charges, and taxation rules.
• Developed multi-branch inventory synchronization services ensuring physical retail point-of-sale systems and online stores stay in strict lockstep.
• Designed GraphQL schemas and optimized resolvers to minimize payload overhead on mobile devices.
• Implemented tokenized payment gateway integrations and enterprise-grade role-based access control (RBAC) for store administrators and inventory auditors.

System Architecture & Design

Architected a scalable Node.js and Medusa.js backend with GraphQL and REST APIs. Implemented ACID-compliant transactional inventory reservations to eliminate overselling of unique high-value gemstones, backed by a real-time price calculation engine factoring live bullion rates, gemstone certification fees, and making charges.