Projects

Real cases with measurable impact

Custom ERP System — Ripnel
Featured

Custom ERP System — Ripnel

Problem

Textile company relied on manual, paper-based processes for inventory, transfers, and sales, leading to inefficiencies and data discrepancies.

A textile and retail company relied entirely on manual, paper-based processes for their inventory, transfers, and daily sales, leading to inefficiencies and data discrepancies. I co-developed Ripnel, a comprehensive, custom web-based ERP and POS (Point of Sale) system designed to fully digitize their operations across multiple store locations. Built highly responsive and optimized user interfaces using modern frontend frameworks, coupled with a robust backend architecture to handle complex business logic (sales, multi-location inventory, cash registers). Integrated an Agentic AI assistant (Google Gemini) directly into the database to automate analytics, provide real-time reporting, and answer natural language queries. Authored comprehensive system documentation to ensure long-term maintainability.

Stack
ReactNext.jsSupabaseTypeScriptTailwind CSSGoogle Gemini AIPostgreSQL
Result

30% reduction in operational time and 45% reduction in customer response time.

Commercial Tracking Dashboard BI

Commercial Tracking Dashboard BI

Problem

Need to transform raw commercial data into an interactive dashboard for agile decision-making.

Developed a comprehensive commercial tracking dashboard using Power BI for a simulated business case. The project focused on transforming raw data into an interactive and visually engaging dashboard to track key company metrics. I implemented advanced DAX formulas, created calculated tables, and designed memory-optimized measures to ensure high performance and fast load times. The final product successfully provided clear, actionable insights for commercial decision-making.

Stack
Power BIDAXSQLData ModelingETLData Visualization
Result

Interactive dashboard with advanced DAX and memory-optimized measures for commercial decisions.

CX Metrics Analysis — Teleperformance

CX Metrics Analysis — Teleperformance

Problem

Slow manual CX report generation, making it difficult to track FCR, CSAT, and resolution times.

Managed and analyzed data using an interactive dashboard system in Tableau and SQL Server for a global BPO company. My role focused on operating these tools to track, interpret, and report critical Customer Experience metrics, including First Contact Resolution, CSAT, and Average Resolution Time. By efficiently navigating the existing data pipelines and streamlining the daily reporting workflow, I successfully reduced report generation time by 40% and provided clear, actionable insights that increased decision-making efficiency across the management team by 18%.

Stack
TableauSQL ServerExcelETLCX MetricsData Pipelines
Result

40% reduction in report generation time and 18% increase in decision-making efficiency.

Clean & Analyze Social Media Usage

Clean & Analyze Social Media Usage

Problem

Historical drops in social media engagement with no identified root cause.

Conducted an Exploratory Data Analysis (EDA) on a social media dataset using Python. I successfully cleaned and processed the data to track customer engagement trends, identified the root causes for historical drops in user interaction, and proposed data-driven resolutions to improve future performance. The analysis revealed behavioral patterns and inflection points that enabled actionable strategic recommendations.

Stack
PythonPandasNumPyMatplotlibSeabornJupyterEDA
Result

Identified root causes of engagement drops and delivered data-driven recommendations.

Law Firm Management System

Law Firm Management System

Problem

Law firm with manual case and client management, slow and insecure processes.

The law firm needed to modernize their case and client management, transitioning from manual processes to a fast and secure digital environment. I created an intuitive web application where lawyers could access information instantly, with a clear routing system for seamless navigation. The result aligned with the expectations: a professional UI/UX design that conveyed trust and a robust technical architecture capable of handling databases efficiently. Includes user authentication, protected routes, service listings from database, and contact email sending.

Stack
ReactMySQLNode.jsHTML5CSS3JavaScript
Result

Functional system with authentication, protected routing, and database integration.

Ollas Comunes

Ollas Comunes

Problem

Las ollas comunes enfrentan desafíos en: registro y seguimiento de beneficiarios, control de inventario de insumos, planificación de menús y recetas, trazabilidad de entregas de comida, coordinación entre organizaciones y distritos.

SIGO-OLLAS es un Sistema de Gestión de Ollas Comunes diseñado para digitalizar y optimizar la administración de sopas comunitarias en Perú. El sistema permite gestionar organizaciones, ollas comunes, beneficiarios, inventarios, recetas, menús, entregas de comida y generar recomendaciones inteligentes para mejorar la operación diaria. Arquitectura Multi-Tenant (SaaS) con aislamiento de datos garantizado por Row Level Security (RLS). Cada organización gestiona sus propias ollas comunes, beneficiarios y recursos.

Stack
ReactNext.jsTypeScriptTailwind CSSshadcn/uiSonnerPostgreSQL
Result

Plataforma centralizada que facilita toda la gestión de la operación diaria de ollas comunes, mejorando la eficiencia y coordinación entre organizaciones.

Gestionalo CMS

Gestionalo CMS

Problem

Empresa de arquitectura legal e inspección técnica necesitaba un CMS moderno para gestionar contenido web, agendar citas y publicar artículos sin conocimientos técnicos.

Gestionalo es un CMS construido con Laravel 11 y Livewire 3 que permite la gestión dinámica de contenido: servicios, proyectos, blog con categorías y sistema de citas nativo. Incluye un asistente de IA integrado (Gemini API) para resumir artículos mediante texto a voz y generación automática de resúmenes ejecutivos. La arquitectura incluye cifrado en reposo, auditoría WORM, rate limiting y políticas por modelo.

Stack
Laravel 11Livewire 3Alpine.jsTailwind CSSPostgreSQLPHP 8.2DockerGemini AI
Result

Plataforma completa de gestión de contenido con IA integrada, sistema de citas nativo y panel administrativo en tiempo real.

Centro de Estética Yvette

Centro de Estética Yvette

Problem

Centro de estética con más de 15 años de experiencia necesitaba una presencia web moderna y un panel administrativo mobile-first para gestionar citas, servicios e inventario.

Landing page responsiva con secciones de servicios, información del centro, equipo de especialistas y accesos directos. Panel administrativo mobile-first con tarjetas apiladas, cambio de pestañas interactivo (Dashboard, Citas, Servicios, Inventario) y métricas simuladas. Diseñado para demostraciones rápidas sin backend ni base de datos.

Stack
HTML5CSS3JavaScriptMobile-first Design
Result

Landing page profesional + panel administrativo funcional para gestión del centro de estética.