Mancilla Consulting

Case Studies

AI-Powered Research Librarian

Client Need: A company struggled to access and utilize a vast internal research document repository.

Solution Implemented

  • Developed an AI-powered indexing system to categorize and index all research documents.
  • Created an autonomous query system that directs user searches to the most relevant content.
  • Implemented a multi-container architecture using Docker for efficient management of query engines.

Business Impact

  • Enhanced Data Retrieval: Reduced time spent searching for documents by 80%.
  • Improved Decision-Making: Enabled employees to access critical information quickly.
  • User Satisfaction: Increased internal user satisfaction due to improved accessibility.

Modular Survey Analysis System

Client Need: Manual analysis of diverse surveys was time-consuming and prone to errors.

Solution Implemented

  • Designed a modular system capable of autonomously analyzing various survey types.
  • Implemented context-aware logic to understand question dependencies and survey flow.
  • Developed an autonomous clustering algorithm for open-ended responses, allowing for automatic categorization and description.

Business Impact

  • Efficiency Gains: Reduced survey analysis time by 70%.
  • Resource Optimization: Decreased resource allocation by 50%, allowing reallocation to other strategic initiatives.
  • Insight Depth: Provided deeper insights through advanced analysis, leading to more effective strategy development.

Customer Support AI Chatbot

Client Need: A high volume of customer inquiries overwhelmed the support team, leading to delayed responses and decreased customer satisfaction.

Solution Implemented

  • Developed an autonomous customer support agent using advanced NLP and GPT-3.5.
  • Indexed over 300 support articles to create a comprehensive knowledge base.
  • Utilized embeddings to match customer queries with the most relevant information.

Business Impact

  • Reduced Workload: Lowered call center inquiries by 40%, allowing support staff to focus on complex issues.
  • Improved Customer Experience: Increased customer satisfaction scores due to prompt and accurate responses.
  • Cost Savings: Decreased operational costs associated with customer support.

Predictive Analytics for Inventory Management

Client Need: A retailer needed to optimize inventory levels to reduce costs and prevent stockouts.

Solution Implemented

  • Developed predictive models using historical sales data, seasonal trends, and external factors.
  • Implemented machine learning algorithms to forecast demand at a granular level.

Business Impact

  • Inventory Optimization: Reduced excess inventory by 25%, freeing up capital.
  • Sales Increase: Minimized stockouts, leading to a 15% increase in sales.
  • Data-Driven Decisions: Enabled proactive inventory planning and procurement.