Horacio Ontiveros

Description

Sin Rollo is a SaaS platform for secure and private storage, with automatic online portfolio for photographers and private galleries for their clients.

Features

• Secure and private storage: Photographers can upload their photos securely and privately.
• Automatic online portfolio: Photographers can create an automatic online portfolio with their photos.
• Private galleries: Photographers can create private galleries for their clients.
• Downloads: Clients can download photos securely and privately.
• Secure payment: Clients can pay for photos securely and privately.

Architecture

The architecture of Sin Rollo is based on a serverless architecture, with a relational database and a file storage system.

• Database: Supabase
• Storage: Google Cloud Storage
• Frontend: Vue.js
• Backend: CloudRun
• Authentication: Supabase Auth

Systems and Scalability

• Creation of pdfs with python: Utilization of the ReportLab library to create pdfs with a personalized design.
• Microservices Architecture: Fluid integration with external APIs such as Pipedrive and Respond.io to centralize client management and real-time communication.
• Event Synchronization: Automatic synchronization of events with Google Calendar and identification of directions and cost of transportation through the Google Maps API.
• Data Persistence: Implementation of PostgreSQL on Supabase to guarantee data integrity and high availability in production environments.
• File Storage: Implementation of CloudStorage for file storage and ensuring system availability.
• Dockerization: Implementation of Docker for ensuring consistency of development and production environments.
• Cloud Deployment: Implementation of CloudRun for cloud deployment and ensuring system availability.

Technical Impact

The system is highly scalable and efficient, allowing for the creation of personalized packages for food events saving hours of daily work and resources for the client.

Systems and Scalability

For architect Leon Leroy, a solution was designed that transcends the traditional website. The architecture uses Astro as a highly efficient static site generator, combined with native Firebase integration for global content synchronization, allowing a multi-language experience without latency.

Efficiency in Content Delivery

• Data Pipeline: Implementation of a workflow that automatically optimizes heavy visual assets (architectural renders), ensuring the site loads in less than 1 second despite the heavy graphic content.
• Serverless Backend: Deployment of business logic through cloud functions, eliminating physical server maintenance costs and ensuring infinite scalability.

Technical Brand Impact

The platform positions the professional in international markets through an efficient dynamic SEO system and localized content delivery, facilitating the acquisition of high-value global projects.

Systems Architecture

Agenda Citara was conceived as an event orchestration engine. It uses a decoupled architecture with a FastAPI backend managing availability logic through real-time conflict resolution algorithms, while the Supabase (PostgreSQL) data layer ensures the transactional integrity of every booking.

Process Optimization

• Notification Automation: I implemented an asynchronous messaging pipeline using Twilio, eliminating manual work for confirmations and follow-ups.
• State Synchronization: The use of WebSockets allows multiple terminals to view the updated agenda instantly, preventing overbooking and optimizing the professional’s workflow.

Impact on Efficiency

System implementation has enabled a 40% reduction in no-shows. From an operational standpoint, users report saving up to 5 hours per week previously dedicated to manual phone agenda management.

Systems Engineering

HiPets is a resource planning system (mini-ERP) verticalized for veterinary clinics. The solution integrates a distributed persistence engine via Supabase, making digital medical records securely and instantly available from any device on the clinic’s network.

Efficiency and Automation

• Inventory and Appointment Control: Automation of appointment workflows linked to the patient database, preventing manual errors in scheduling medical boosters.
• Reactive Backend: Implementation of a lightweight Python/Flask API deployed on GCP, designed for ultra-low response times in high-demand operational environments.

Implementation Results

The system centralizes administrative operations, reducing patient intake time by 30% and ensuring total control over digital clinical histories, vital for medical treatment continuity.

Catalog Architecture

Hialuroniz represents an information system for health and wellness. The core of the project is a search and logical filtering engine that classifies hundreds of products based on wellness goals, allowing for systemic rather than just visual navigation.

Efficiency in Selection

• Intelligent Taxonomy: Development of a cross-category structure that optimizes the user’s purchase path, reducing the number of clicks needed to find specific health solutions.
• Asset Optimization: Implementation of advanced lazy loading, keeping the extensive catalog fluid even on limited mobile connections.

Commercial Impact

The efficient catalog architecture has resulted in a direct improvement in the conversion rate, making it easier for users to make informed decisions based on a clear and well-structured information system.

Information and Systems Architecture

The IJC project focused on creating a secure and distributed digital asset management system. The architecture is built on a Google Compute Engine environment under a hardened configuration to guarantee the integrity of critical announcements and documents.

Operational Efficiency

• Custom CMS: I developed a tailored administrative backend optimized for non-technical users, allowing vital information to be published in seconds and eliminating internal information silos.
• Database Architecture: Query optimization in MariaDB to support high volumes of concurrent traffic during official notice periods.

Service Impact

The digitalization of procedures and medical directories has reduced the flow of first-level telephone support, allowing the institute’s staff to focus on direct clinical care and more complex management.

Systems Integration

For Galau Consultoría, the system was designed as a lead generation platform. WordPress core was integrated with an advanced tracking layer through Google Tag Manager, allowing for the efficiency of each touchpoint in the talent selection workflow to be measured.

Funnel Efficiency

• Tracking Automation: Configuration of integrated Workspaces that allow data synchronization between the web portal and the team’s internal management tools.
• Low-Maintenance Architecture: Deployment on Google Compute Engine with backup policies and manual scaling, guaranteeing the portal’s operational stability.

Business Impact

The system has professionalized talent intake, allowing the consultancy to manage a larger volume of candidates without increasing its administrative load, thus improving the speed of response to its corporate clients.

Content Engineering

This project focused on creating a high-availability information distribution system. The architecture was optimized at the Apache server level to handle organic traffic spikes, using compression and efficient digital asset delivery techniques.

Efficiency and Technical SEO

• Semantic Architecture: Implementation of a data structure that allows search engines to index information with maximum efficiency, reducing the crawl budget consumed by each visit.
• Loading Performance: PHP pipeline optimization to ensure fast response times, vital for search engine positioning and user retention.

Operational Impact

The portal functions as a passive organic acquisition engine, generating thousands of monthly visits with minimal technical intervention, thanks to the system’s robustness and its initial core optimization.

Communication Systems

Centro AJI’s system was structured to facilitate a direct connection between users and health services. An integrated contact architecture was implemented to minimize operational friction, allowing support requests to reach center coordinators in a structured manner.

Management Efficiency

• Channel Automation: Integration of direct contact tools that eliminate intermediate steps in the communication chain, allowing for an immediate response in critical situations.
• Lightweight Architecture: Resource optimization for stable operation in shared hosting environments, maintaining site agility.

Results

A 24/7 operational channel that has allowed the center to expand its support capacity without needing to increase administrative staff dedicated to initial case reception.