Mancii

Chatbot Director is an AI-powered assistant that enables business directors to access operational data and make informed decisions directly through WhatsApp. Instead of navigating complex dashboards or relying on technical teams to write database queries, directors can ask questions in natural language, just as they would speak to a colleague.The project addresses a common business problem: decision-makers often have access to valuable data but cannot use it quickly or independently. Dashboards may require technical knowledge, take time to interpret, or provide more information than is immediately necessary. Since WhatsApp is already widely used across Latin America, the project brings data intelligence to a familiar and accessible communication channel.<h2>How It Works</h2>The interaction follows a three-step process:<ol><li>Natural-language questions: The director asks a question through WhatsApp, such as “How many sales did we make last month?” or “Which organization generated the most revenue this week?”</li><li>Secure SQL generation: Gemini interprets the question and converts it into a SQL query that can be executed against the company’s database.</li><li>Numerical verification: Before the answer is sent, every figure is checked against the underlying data to ensure that the response is consistent with the actual database results. If the system cannot validate the result, it rejects the response instead of sending potentially inaccurate information.</li></ol>

An AI assistant for executives that turns data into decisions right in WhatsApp.

Data Analysis

Chatbor Director Marketing

AI Partners

Chatbot Director is an AI-powered assistant that enables business directors to access operational data and make informed decisions directly through WhatsApp. Instead of navigating complex dashboards or relying on technical teams to write database queries, directors can ask questions in natural language, just as they would speak to a colleague.The project addresses a common business problem: decision-makers often have access to valuable data but cannot use it quickly or independently. Dashboards may require technical knowledge, take time to interpret, or provide more information than is immediately necessary. Since WhatsApp is already widely used across Latin America, the project brings data intelligence to a familiar and accessible communication channel<h2>How It Works</h2>The interaction follows a three-step process:<ol><li>Natural-language questions: The director asks a question through WhatsApp, such as “How many sales did we make last month?” or “Which organization generated the most revenue this week?”</li><li>Secure SQL generation: Gemini interprets the question and converts it into a SQL query that can be executed against the company’s database.</li><li>Numerical verification: Before the answer is sent, every figure is checked against the underlying data to ensure that the response is consistent with the actual database results. If the system cannot validate the result, it rejects the response instead of sending potentially inaccurate information.</li></ol>

A RAG chatbot that answers questions based on a knowledge base using LangChain and Gemini.

Strategy Consulting

RAG Chatbot

Personal

Personal Finance is a full-stack application designed to manage personal finances with the help of artificial intelligence. It connects directly to real bank accounts, synchronizes transactions automatically, categorizes expenses, provides financial analytics, and allows users to interact with their financial data through a Telegram assistant.<h2>The Problem</h2>Many personal finance applications provide generic dashboards that do not adapt to an individual’s spending habits or connect easily to their actual bank accounts. They often require users to manually review transactions and navigate complex interfaces to answer simple questions.This project was created to provide a more personal and practical alternative: an intelligent financial system that connects to real banking data, automatically organizes expenses, and delivers personalized insights without requiring the user to open a dashboard.<h2>How It Works</h2>The interaction follows a three-step process:<ol><li>Natural-language questions: The director asks a question through WhatsApp, such as “How many sales did we make last month?” or “Which organization generated the most revenue this week?”</li><li>Secure SQL generation: Gemini interprets the question and converts it into a SQL query that can be executed against the company’s database.</li><li>Numerical verification: Before the answer is sent, every figure is checked against the underlying data to ensure that the response is consistent with the actual database results. If the system cannot validate the result, it rejects the response instead of sending potentially inaccurate information.</li></ol>

A full-stack app for managing personal finances with AI—bank account syncing, analytics, and an assistant via Telegram.

Juan Sabogal Bohórquez

Financial Analyst & Project Manager & Dev

À propos

Expérience de travail

Mancii

Cofundador

Director de finanzas

Formation

Arts et Métiers - École Nationale Supérieure d'Arts et Métiers

Universidad El Bosque

Platzi

Platzi

Centro cultural Astilleros

Bolsa de valores de Colombia

Clubclass Malta

Bancolombia

Portfolio

Chatbor Director Marketing

Mancii

RAG Chatbot

AI Partners

Finance App

Personal

Talents

Recruteurs

À propos

Juan Sabogal Bohórquez

Financial Analyst & Project Manager & Dev

À propos

Expérience de travail

.css-171onha{display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-webkit-box-align:center;-ms-flex-align:center;align-items:center;gap:4px;}Mancii

Cofundador

Director de finanzas

Formation

Arts et Métiers - École Nationale Supérieure d'Arts et Métiers

Universidad El Bosque

Platzi

Platzi

Centro cultural Astilleros

Bolsa de valores de Colombia

Clubclass Malta

Bancolombia

Portfolio

Chatbor Director Marketing

Mancii

RAG Chatbot

AI Partners

Finance App

Personal

Talents

Recruteurs

À propos

Mancii