ERPlyte
EN ES

Consulting and systems development

ERPlyte (ERP Lite) provides consulting and software development services that help companies organize their data, automate processes, and connect their systems.

ERPlyte diagram: your current systems connected through a middle integration and automation layer to your business's professional applications

What we do

From data to a system in production

We can build an information system end to end: data collection → analysis → design → development and automation → implementation → go-live → maintenance and support.

We connect what you already have with what you need

Our main value sits in the middle layer of your technology stack, where many companies need to connect proprietary systems, legacy applications, or in-house solutions with specialized enterprise platforms. We help these systems talk to each other, using modern tools and technologies to integrate them with ERP, CRM, accounting, healthcare, banking, government, and other specialized systems, according to each company's needs and size.

Modernize and automate your processes

Do you have a spreadsheet that only a few people know how to use? Small standalone applications for a lab, production line, or manufacturing floor? Manual processes that depend on the knowledge of one or two people?

We can turn these processes into secure, scalable, traceable applications, where information can be consulted and used in a controlled way by the people and areas that need it. We can also clean, transform, and filter data before sending it on to your enterprise systems, avoiding duplicate information and reducing manual work.

Services

How the work breaks down

Oracle APEX application development

Low-code doesn't mean low engineering. Normalized data models, business logic in PL/SQL packages, explicit constraints, and audit trails — so the application still makes sense three years and four developers later.

  • New applications built on Oracle APEX
  • Migration and modernization of Oracle Forms & Reports
  • Legacy system assessment: what to reuse, rewrite, or retire
  • Mobile-ready applications and progressive web apps
  • Reporting with Interactive Reports, Jasper, and AOP

Databases and data engineering

Designing a solid corporate database is critical for any company, regardless of its size. We work with whatever engine you're already using, or the one you prefer, applying best practices to get the most out of this key resource.

  • Oracle Database, Oracle XE, Oracle Cloud
  • PostgreSQL, MySQL, and SQL Server, as the project requires
  • Data modeling, normalization, indexing, performance review
  • ETL and ELT pipelines, data migration
  • Multitenant administration and APEX schema management

Integrations and microservices

Connecting systems that were never designed to talk to each other, without either one noticing the difference.

  • RESTful and SOAP integrations, ORDS endpoint design
  • Microservices built in Python and FastAPI, connected to Oracle
  • Interfaces with ERP, CRM, and POS — Oracle ERP, Retail-PRO, Helisa
  • IoT and field-device data ingestion
  • Master data management and synchronization across systems

Infrastructure and managed servers

Turnkey or as advisory. One isolated server per client — never a shared machine or a shared database.

  • Provisioning, configuration, and administration of VPS (Virtual Private Servers), self-hosted on Ubuntu
  • Each client gets their own private virtual server — never sharing a machine or database with another project
  • Docker-based deployment workflows
  • Linux server administration: UFW, fail2ban, key-only SSH, nginx proxy
  • Installation and upgrades of the Oracle, APEX, and ORDS stack
  • Technical advisory for in-house teams

Products

Oil & gas

METRICS LAB

METRICS LAB is an information system for industrial measurements, built for multiple applications within non-destructive testing (NDT) and inspection. Its Inspection and Integrity Management module turns raw NDT data into reliable engineering decisions, through corrosion mapping, crack assessment, and integrity calculations under the ASME B31G standard, including storage tank integrity. The platform centralizes the recording, tracking, and traceability of every inspection in one place, and provides analytical reports that support technical interpretation and decision-making across the industrial asset lifecycle.

Construction

iNEGplus

iNEGplus (Información & Negocios) is a management and administration platform designed for construction companies, with custom-built modules for end-to-end management of the real estate business. It covers project and available-lot management, cash and treasury control, and customer and accounts receivable tracking throughout the entire sales cycle. It also includes an administrative module with cash counts, accounting period close, commission settlement, and user management. The platform is complemented by reporting and analytics tools for day-to-day operations, as well as integration with Siigo accounting software.

Veterinary

iVetPRO

iVetPRO Desktop is a comprehensive management system for veterinary practices, built to centralize each patient's clinical care. It lets staff record and review an animal's medical history, manage clinical care, request diagnostic support, track vaccination and deworming schedules, and manage appointments efficiently. It also handles informed consent (sedation, anesthesia, euthanasia, transport) and certificate issuance, along with patient and owner records, all from a single interface built for the veterinary professional's daily workflow.

Profile

Engineering first, platform second

César Berrio

I'm a Software Developer and Database Architect with more than 15 years of experience building enterprise applications, designing software architecture, and working in data engineering.

My work brings together databases, application development, APIs, and systems integration. I've worked primarily with Oracle technologies, PostgreSQL, SQL Server, and Python on enterprise projects and integrations with a range of ERP platforms.

I also run a personal AI lab, where I explore emerging technologies and how they apply to software development and data.

I'm available for project-based work or to join development teams, from analysis and design through deployment, integration, and support.

Working stack

  • Oracle Database
  • PostgreSQL
  • Oracle APEX
  • PL/SQL
  • ORDS
  • Python
  • JavaScript
  • FastAPI
  • REST
  • SOAP
  • Docker
  • Linux
  • nginx
  • Ollama
  • RAG
  • NL-to-SQL

Let's talk about your system