Oscar Enrique Portorreal Ramírez

Arquitecto de Software | .NET & ASP.NET Core | Integraciones ERP y Empresariales | Automatización con IA | Modernización de Sistemas Críticos

Software Architect | .NET & ASP.NET Core | ERP & Enterprise Integrations | AI-Driven Automation | Modernization of Business-Critical Systems

Habilidades Técnicas

Arquitectura & Integración

Diseño de soluciones, APIs REST y SOAP, patrones de integración (Hub-and-Spoke, colas de mensajes, Pub/Sub), middleware, OAuth 2.0, Dell Boomi y QXtend.

C# / .NET

ASP.NET Core (.NET 9), Web API, Entity Framework Core, MVC, WinForms y Blazor. Arquitecturas backend orientadas a API.

ERP Empresarial

QAD Adaptive ERP, Epicor Kinetic / 10.x (BAQs, BPMs, Service Connect, REST APIs), Workday, SuccessFactors y PeopleSoft.

IA Aplicada

Claude API de Anthropic, automatización y pipelines de datos con IA, flujos con agentes y despliegue local de modelos (Ollama) para control de costos y privacidad.

Datos & Cloud

SQL Server, PostgreSQL, Oracle, MySQL. ETL/SSIS, migraciones de gran volumen, Power BI Embedded. Azure, Docker, CI/CD e IIS.

Modernización Legacy

Conversión de Visual FoxPro a C#/.NET con preservación de la lógica de negocio, migración incremental y puentes API entre sistemas legados y modernos.

Technical Skills

Architecture & Integration

Solution architecture, REST and SOAP APIs, integration patterns (Hub-and-Spoke, Message Queue, Pub/Sub), middleware design, OAuth 2.0, Dell Boomi and QXtend.

C# / .NET

ASP.NET Core (.NET 9), Web API, Entity Framework Core, MVC, WinForms and Blazor. API-driven backend architecture.

Enterprise ERP

QAD Adaptive ERP, Epicor Kinetic / 10.x (BAQs, BPMs, Service Connect, REST APIs), Workday, SuccessFactors and PeopleSoft.

Applied AI

Anthropic Claude API, AI-driven automation and data pipelines, agent-based workflows, and local model deployment (Ollama) for cost and privacy control.

Data & Cloud

SQL Server, PostgreSQL, Oracle, MySQL. ETL/SSIS, large-scale migrations, Power BI Embedded. Azure, Docker, CI/CD and IIS.

Legacy Modernization

Visual FoxPro to C#/.NET conversion with business-logic preservation, incremental migration, and API bridging between legacy and modern stacks.

Experiencia Profesional

2026 - Presente
Senior Software Engineer — Arquitectura de Integraciones
Upstart 13

Arquitectura de integraciones entre QAD Adaptive ERP y automatización de compras con IA para un cliente manufacturero en EE.UU. QXtend, REST APIs y Dell Boomi.

2019 - Presente
Consultoría Independiente & Ingeniería de Producto
Clientes en EE.UU. e internacionales

Modernización de plataformas críticas a C#/ASP.NET Core, portales de analítica sobre Azure y productos propios. Top Rated Plus en Upwork desde 2016.

2021 - 2023
Operations Manager & Legacy Systems Specialist
CNSWARE Inc.

Lideré programas de modernización de VFP a C# para 5 clientes empresariales y construí middleware de integración con Epicor ERP vía REST APIs.

2019 - 2020
Software Developer — Modernización de Sistemas
DIGEPRES

Modernización de sistemas gubernamentales a ASP.NET Core, con puentes API que alimentan un front end en Angular sin reescribir el back office.

2014 - 2019
Project Leader & Senior Developer
EIKON SA

Modernicé la plataforma de nómina en dos etapas (VFP 7 → VFP 9, luego backend a ASP.NET Core Web APIs) para 50+ empresas cliente. Integraciones con Workday, SuccessFactors, Amazon MWS y eBay. Migración de 100+ GB a SQL Server. Equipo de 8 desarrolladores.

2007 - 2016
Technology Manager & Development Lead
Tower Casinos

Sistema integral de gestión de casino: juego, hospitalidad, reportes financieros e integración con hardware de sala. 99.9% de disponibilidad.

Trabajo remoto con visitas mensuales; a tiempo parcial desde 2014.

Professional Experience

2026 - Present
Senior Software Engineer — Integration Architecture
Upstart 13

Architecting integrations between QAD Adaptive ERP and AI-driven procurement automation for a US manufacturing client. QXtend, REST APIs and Dell Boomi.

2019 - Present
Independent Consulting & Product Engineering
US & international clients

Modernization of business-critical platforms to C#/ASP.NET Core, Azure-hosted analytics portals, and commercial products. Top Rated Plus on Upwork since 2016.

2021 - 2023
Operations Manager & Legacy Systems Specialist
CNSWARE Inc.

Led VFP-to-C# modernization programs for 5 enterprise clients and built integration middleware connecting legacy applications to Epicor ERP via REST APIs.

2019 - 2020
Software Developer — Systems Modernization
DIGEPRES

Modernized government systems to ASP.NET Core, building API bridges that feed an Angular front end without rewriting the back office.

2014 - 2019
Project Leader & Senior Developer
EIKON SA

Modernized the payroll platform in two stages (VFP 7 → VFP 9, then the backend onto ASP.NET Core Web APIs) serving 50+ client companies. Integrations with Workday, SuccessFactors, Amazon MWS and eBay. 100+ GB migration to SQL Server. Team of 8 developers.

2007 - 2016
Technology Manager & Development Lead
Tower Casinos

Comprehensive casino management system covering gaming, hospitality, financial reporting and floor-hardware integration. 99.9% uptime.

Remote engagement with monthly on-site visits; part-time from 2014.

Proyectos Destacados

Integración QAD ERP ↔ Compras con IA

Arquitectura de integración entre QAD Adaptive ERP y un sistema de automatización de compras con IA, cubriendo los flujos de Order-to-Cash y procurement.

QAD Adaptive QXtend Dell Boomi REST API

Modernización de Casino PitTrack

Migración de una plataforma de operaciones de casino con 30+ instalaciones y 15+ años en producción, de Visual FoxPro a C#/ASP.NET Core, preservando toda la lógica de negocio.

ASP.NET Core EF Core REST API / JWT SQL Server

Portal de Analítica con Power BI Embedded

Portal que reemplaza dashboards alimentados por Excel con un pipeline en vivo desde la API de BQE CORE, sobre infraestructura Azure con seguridad a nivel de fila.

Power BI Embedded OAuth 2.0 Azure C# / .NET

Migración de Plataforma de Nómina

Modernización en dos etapas de un sistema de nómina para 50+ empresas cliente: VFP 7 a VFP 9 y luego el backend completo a ASP.NET Core Web APIs, sin interrumpir los ciclos de pago.

VFP 9 ASP.NET Core Web API SQL Server

Integraciones E-Commerce y RRHH

Conexión de sistemas empresariales con Amazon MWS/SP-API, eBay, Workday y SuccessFactors para automatizar flujos de inventario, órdenes y datos de personal.

Amazon SP-API eBay API Workday SuccessFactors

Migración Masiva de Datos

Migración de 100+ GB de bases DBF a SQL Server con herramientas ETL propias y reconciliación completa para garantizar cero pérdida de datos.

DBF → SQL ETL SSIS SQL Server

Featured Projects

QAD ERP ↔ AI Procurement Integration

Integration architecture between QAD Adaptive ERP and an AI-driven procurement automation system, covering Order-to-Cash and procurement flows.

QAD Adaptive QXtend Dell Boomi REST API

Casino PitTrack Modernization

Migration of a casino operations platform with 30+ installations and 15+ years in production, from Visual FoxPro to C#/ASP.NET Core, preserving all embedded business logic.

ASP.NET Core EF Core REST API / JWT SQL Server

Power BI Embedded Analytics Portal

Portal replacing Excel-fed dashboards with a live pipeline from the BQE CORE API, on Azure infrastructure with row-level security.

Power BI Embedded OAuth 2.0 Azure C# / .NET

Payroll Platform Migration

Two-stage modernization of a payroll system serving 50+ client companies: VFP 7 to VFP 9, then the full backend onto ASP.NET Core Web APIs, without interrupting payroll cycles.

VFP 9 ASP.NET Core Web API SQL Server

E-Commerce & HR Integrations

Connected enterprise systems to Amazon MWS/SP-API, eBay, Workday and SuccessFactors to automate inventory, order and personnel data flows.

Amazon SP-API eBay API Workday SuccessFactors

Large-Scale Data Migration

Migration of 100+ GB of DBF databases to SQL Server using custom ETL tooling, with full reconciliation to guarantee zero data loss.

DBF → SQL ETL SSIS SQL Server

Plataformas Integradas

QAD Adaptive ERP

Epicor ERP

Anthropic Claude API

Microsoft Azure

Amazon MWS/SP-API

eBay API

Workday

SuccessFactors

PeopleSoft

Payment Gateways

Integrated Platforms

QAD Adaptive ERP

Epicor ERP

Anthropic Claude API

Microsoft Azure

Amazon MWS/SP-API

eBay API

Workday

SuccessFactors

PeopleSoft

Payment Gateways

Contacto

Contact