Case studies

Problem · solution · impact. Real projects with results.

Data / Business Intelligence

Conversational BI

Conversational BI system that lets users query complex data in natural language, backed by business semantics and audited SQL.

  • Natural language questions
  • Business semantic layer
  • Generated, safe and reusable SQL
  • Tables, charts and exports
PostgreSQLSQL semánticoPHPJavascriptOpenAI / LLMBootstrap
Read case
HR / Process Automation

Automated System RED Registrations

Automated system for managing employee registrations in System RED, operating unattended even during weekends and outside business hours.

  • Automated System RED registrations
  • Unattended 24/7 execution
  • Power Automate robot integration
  • Reduced errors and critical timing risks
  • Full process traceability
Power AutomateRPASistema REDAutomatización de procesosValidación de datosIntegraciones empresariales
Read case
Construction, installations and technical services

AI-assisted quote generation

Internal assisted quote generation system that automates request intake, interprets structured line items and suggests prices based on real company history, supported by artificial intelligence.

  • Quote process automation
  • Automatic capture of email quote requests
  • Import of structured Excel line items
  • Price suggestions based on real historical data
  • AI support for new or uncommon items
  • Human validation and PDF quote generation
PostgreSQLPHPIMAP (Email ingestion)Document managementOpenAI / LLMHTML to PDF generation
Read case
Finance / Document Automation

Intelligent Document Processing with AI

Document processing and semi-automated accounting system based on a Python API that analyzes documents, structures content by pages and extracts data using LLMs.

  • Native PDF, scanned PDF and image analysis
  • OCR-based text extraction when required
  • Page-based content structuring
  • Structured JSON data extraction using LLMs
  • Explicit control of analyzed context
Python APIPDF / OCRProcesamiento por páginasIAOpenAI API / OLLAMA APIJSON estructuradoPostgreSQL
Read case
Technology / AI / Data

Semantic Search & Content Enrichment

Design and implementation of embedding-based semantic search systems combined with AI-driven content enrichment for product catalogs and enterprise databases.

  • Intent- and meaning-based search instead of pure keyword matching
  • Automatic AI-driven content enrichment (categories, use cases, themes)
  • Support for reference lookup, similarity search and natural language queries
  • Architectures optimized for conversational assistants with limited result sets
PHPPostgreSQLpgvectorPL/pgSQL / PL-PythonOpenAI / OllamaJavascript / JQuery
Read case
Services, outsourcing, mobile teams and HR

RegistroHorario.app: time tracking, costs and workforce management

Multi-company time tracking platform with geolocation, absence management and workforce cost control, designed for services, outsourcing and mobile teams.

  • Compliant time tracking
  • Geolocation and geofencing-based time punches
  • Vacation, leave and absence management
  • Configurable approval workflows
  • Salary and cost concepts with full history
  • Automatic hourly cost calculation
  • Cost allocation by project or activity
  • Operational, legal and financial reports
PHPPostgreSQLJavascript / jQueryBootstrapGeolocation & geofencingWorkflow engineScheduled jobs & reporting
Read case
Tourism / Real estate

Multilingual SEO landing

SEO‑driven landing to capture international and domestic demand.

  • On‑page architecture & multilingual content
  • Responsive & speed
  • Tracking with GA/GSC
HTML5CSS3JavascriptBootstrapSEO on‑pageWeb PerformanceGA/GSC
Read case
Services / Local IT

SEO presence: on‑site IT support

One‑page with fullpage + localised content for geo capture.

  • Local area architecture
  • Search‑intent‑aligned copy
  • Speed and responsive
HTMLPHPJavascript/JQueryBootstrap
Read case
Education / Consumer

SEO presence: private IT lessons

One‑page offering 1‑to‑1 / groups plus local pages.

  • Municipality structure
  • Fullpage & rotating copy
  • Conversion focus
HTMLPHPJavascript/JQueryBootstrap
Read case
Internal finance / Sales

Budgeting & expense management tool

From spreadsheets to a centralised platform with approvals and tracking.

  • Import from Navision & Excel
  • Month‑by‑month tracking
  • Digital approval workflows
PHPPostgreSQLJavascript/JQueryIntegración NavisionETL/ELT
Read case
R&D / IP

Patent search (OCR + indexing)

Multilingual OCR + millisecond searches with Sphinx on PostgreSQL.

  • Exact & fuzzy search
  • Fielded indexing
  • Dynamic filtering UI
PHPPostgreSQLSphinx SearchOCRAJAX/JSXML
Read case
Cross‑functional / Operations

Productivity optimisation with AI

Assistants, extraction and RPA to reduce manual work and accelerate decisions.

  • Internal GPT assistants
  • RAG over repositories
  • Flow automation
PythonOpenAI LLMsETLRPAAPIs
Read case
Distribution / Logistics

Distribution business management

Multi‑company: shared catalogue, warehouses, purchasing/sales, delivery and billing.

  • AEAT SII
  • Tourline WebService
  • ZPL & ESC/POS labels
HTMLCSSJavascript/JQueryPostgreSQLXMLPHPSOAPZPL/ESC-POSSIITourlinePython/WebSockets
Read case
Agri / Animal nutrition

Website with CMS + CRM (animal nutrition)

Site with two business areas and CRM for sales follow‑up.

  • CMS for content
  • CRM for opportunities & visits
  • Technical news
HTMLPHPJavascript/JQueryPostgreSQLXML
Read case
Retail / Food

E‑commerce with payment gateway (perishables)

Real‑time stock and prices from the physical shop system + Sermepa gateway.

  • Real‑time catalogue
  • Pre‑authorisations
  • Daily counter video
HTMLASPJavascript/JQuerySQL ServerXMLRTSPMP4FFMPEG
Read case
Data / Security

Search engines (40M plates)

Exact & fuzzy search at very low latency over large volumes.

  • Sphinx Search
  • AJAX queries
  • XML processing on client
PHPPostgreSQLSphinx SearchAJAXXMLHTML/JS
Read case
Marketing / Digital experience

HTML5 full‑screen video interaction

Synchronise HTML elements with the video timeline, JS control and touch support.

  • JS play/pause control
  • Synced events
  • Touch support
Video H.264Javascript/JQueryHTML5XML
Read case
Operations / Legal

Encrypted document management with OCR & indexing

Information units with encrypted documents, text extraction and content search.

  • Server‑side encryption
  • OCR & extraction
  • Content search
HTMLCSSJavascript/JQueryPostgreSQLXMLPHPSOAPOCRSphinx Search
Read case