Problem Statement
Sales teams and executives at Functional Fragrances spent significant time navigating the Unleashed inventory system to answer questions they needed quickly — stock levels, SKU availability, reorder timing, and sales projections. Manual system navigation created bottlenecks and slowed customer-facing conversations.
Proposed Solution & Architecture
- Natural language AI assistant answering SKU-specific, stock level, and forecast questions without system navigation
- Live Unleashed API integration for real-time inventory data retrieval during every conversation
- Power BI forecast integration — historical sales and current stock combined into inventory sufficiency projections
- Role-based access for executives, sales staff, and distribution managers — each with appropriate data scope
- Automated alerts for low stock thresholds and projected shortages via email or collaboration tool notifications
- Safeguards ensuring relevance and accuracy — assistant responses grounded in actual inventory data
AWS Services & Technologies
Amazon BedrockAWS LambdaAmazon DynamoDBAmazon API GatewayAmazon CognitoAmazon SESUnleashed APIPower BIAmazon CloudWatch
What We Delivered
- Built the AI-powered conversational assistant on Amazon Bedrock — configured for inventory domain queries with accuracy safeguards.
- Integrated Unleashed API for live stock, SKU, and product data retrieval during every assistant interaction.
- Connected Power BI reports to the assistant — historical run-rate data combined with current stock for real-time sufficiency projections.
- Implemented event-driven backend for query processing, workflow orchestration, and data flow management.
- Deployed role-based access control ensuring executives, sales, and operations each access appropriate data levels.
- Configured automated low-stock and shortage alert notifications via Amazon SES and collaboration tool integration.
Outcomes & Success Metrics
- Natural language inventory queries answered instantly — no system navigation required.
- Unleashed integration live — real-time stock and SKU data available in every conversation.
- Power BI forecast data integrated — inventory sufficiency projections delivered conversationally.
- Executive, sales, and distribution teams all accessing appropriate inventory insights through a single interface.
- Automated stock alerts configured and operational — teams notified proactively on threshold breaches.