Erick Javier Mireles Riojas · Senior .NET Full Stack Developer

Software for real-world operations: construction, warehousing, flights and maintenance.

Erick Javier Mireles Riojas

I learned to program in 2003, and since 2004 I have built systems for construction companies, an airline and an aircraft maintenance shop. I started with Visual FoxPro and today work with C#, .NET, SQL Server and Vue, always close to the people who use what I build.

Years building software professionally
20+
Flight legs recorded in COLDEV since 2014
219,000+
Components with tracked limits in CICMA
16,737
To take cargo reporting to Canada into production
< 1 month

I wrote my first program in 2003, in Turbo Pascal, in the Programming I course at the Instituto Tecnológico de Saltillo. I liked it enough to keep going on my own, and by the following year I was maintaining and supporting Visual FoxPro systems.

From 2004 to 2009 I worked for construction companies contracted by the city water utility, Aguas de Saltillo. At CIMAGUA I built the warehouse system for the materials supplied by the utility: quarterly audits, which had always ended in losses, began to close with no shortages and several times with a surplus in the company's favor. That result took me to SERSA, where I built the company's complete operations system in Visual FoxPro 9: field work, reports, photo evidence and materials control. It handled 20 to 80 jobs a day from about 12 field crews, including service shut-offs, reconnections and new connections, and each job deducted its materials from the warehouse. It was my first lesson in something I still do: understand the process with the people who run it before writing the system. While working, I studied at the Tecnológico de Saltillo and later at the Faculty of Systems of the Universidad Autónoma de Coahuila.

In November 2009 I joined Aeronaves TSM as a developer and technical support lead. One of my first projects was the first version of COLDEV, which handled flight tracking, cargo, fuel and crew control, continuity between flight legs, and monthly, quarterly and annual reports. At the time, each department had its own program and its own data. From 2012 on I started building for the web and moved those modules, one at a time, into SAGA: an ERP with a single database, shared users and permissions, and common catalogs for operations, maintenance, crews and administration. It took years, and it was done while the airline kept running on the old systems.

For much of that time, besides the software, I also handled servers, the network and users. Over the years the department grew and I came to coordinate the development team.

  1. 2003

    First programs

    Turbo Pascal at the Tecnológico de Saltillo and, on my own, Visual FoxPro.

  2. 2004 – 2007

    Construction companies · CIMAGUA

    Visual FoxPro maintenance and support. At CIMAGUA, a warehouse system that eliminated losses in the utility's quarterly audits.

  3. 2007 – 2009

    SERSA · Aguas de Saltillo contractor

    Complete Visual FoxPro 9 system: field work for about 12 crews, photo evidence, reports, materials control and warehouse inventory.

  4. 2009 – 2012

    Aeronaves TSM · desktop systems

    Maintenance and development of Visual FoxPro modules for operations, maintenance and administration. Windows Server 2000 and 2008 administration.

  5. 2012 – 2022

    From desktop to web

    First ASP.NET applications and migration of the modules into SAGA. COLDEV, CICMA and crew management move onto one platform. Servers migrated to virtualized infrastructure on Windows Server 2012.

  6. 2022

    ERP / MRO for Servicios Aéreos Quintana

    Design and development of a warehouse, purchasing and maintenance application. In production since June 2022; I still maintain it.

  7. 2023

    New generation of COLDEV

    I led the development and wrote most of the backend.

  8. 2025 – 2026

    Transport Canada integration and modernization

    Air waybill and cargo manifest reporting to the PACT program, in production since February 2026. In parallel I started a new layered API and a .NET MAUI app for pilots, both left in development.

  9. April 2026 – now

    Independent development

    Client projects and my own products with .NET, Vue and PostgreSQL.

SAGA brought what used to be separate programs into a single web application. These are the modules I worked on, with the volume they handled at the end of 2025.

COLDEV

Flight operations and logistics: quotes, trips, legs, cargo and tracking.

27,455 legs in 2025

CICMA

Maintenance: work orders, tech logs, task cards, components and due limits.

23,066 tech logs in 2025

Crews

License and certificate expirations, type qualifications and flight-hour pay.

10,552 expiration records

Engine monitoring

Engine parameters captured in the tech log to follow trends per aircraft.

51,469 parameter records

Trip expenses

Recording, approval and reimbursement of each trip's expenses.

29,296 expenses recorded

Technical library

Technical documentation linked to maintenance and operations records.

Outside SAGA I built TSM Connect, the original ground logistics system, and worked on its web version.

Aeronaves TSM · ASP.NET MVC · SQL Server

COLDEV: a record of every flight

COLDEV holds the operation together, from the quote to the closing of each trip, with crew, cargo, route and tracking. I built its first generations and, in the 2023 rewrite, most of the backend.

The operation grew more than fivefold on the same system. In 2025 it recorded 27,455 legs and 8,999 quotes for 152 aircraft, with more than 1,500 active customers and 280 user accounts.

Flight legs recorded per year
Flight legs recorded per year in COLDEV 2014: 4,809; 2015: 8,532; 2016: 10,116; 2017: 13,513; 2018: 14,458; 2019: 13,574; 2020: 14,731; 2021: 27,443; 2022: 30,720; 2023: 27,101; 2024: 25,695; 2025: 27,455. 10k20k30k 20144,809151617181920212230,7202324202527,455
COLDEV · Flight tracking
COLDEV flight tracking screen with trips, crew, route and cargo
Anonymized demo data.

Aeronaves TSM · ASP.NET MVC · SQL Server

CICMA: traceable maintenance

CICMA tracks the maintenance of the fleet. Working with the engineering staff, I built the work order, tech log and task card workflows and the tracking of limits by hours, cycles and days.

In 2025 it handled 4,460 work orders and 23,066 tech log entries. It tracks 16,737 components with 16,509 limits and more than 2,100 task cards for 23 aircraft models.

CICMA · Fleet status
CICMA dashboard with fleet by model, position map and open work orders
Fleet by model, positions and open work orders. Anonymized demo data.

Aeronaves TSM · C# · IATA Cargo-XML

Cargo reporting to Transport Canada in under a month

Transport Canada requires airlines carrying cargo into Canada to submit air waybill and manifest data before departure (the PACT program). The requirement reached the IT department in mid-January 2026, with the deadline close and flights to Canada at stake.

I studied the specification, built the messages from COLDEV trips and had it in production in February. Each message is validated against the XSD schemas, stored before it is sent so it is never duplicated, retried if the service does not respond, and reconciled with Transport Canada's acknowledgment.

  1. COLDEV tripAir waybills actually on board
  2. XFWB · XFFMWaybill and manifest in Cargo-XML
  3. XSD validationBefore leaving the system
  4. API PACTSubmission with retries
  5. XFNM acknowledgmentAccepted, or rejected with a reason

Servicios Aéreos Quintana · ASP.NET · EF6 · SQL Server

ERP / MRO: warehouse, purchasing and maintenance

I designed and built this application for an aircraft maintenance shop. It covers requisitions, purchasing, warehouse issues, serial number traceability and work orders. It has been in production since June 2022.

In 2025 it recorded 14,404 requisitions, 13,216 warehouse issues and 13,751 serial number movements. It manages more than 9,700 active part numbers, 63 aircraft from 22 customers and 340 user accounts.

ERP / MRO · Work orders
Work order list in the maintenance ERP
Anonymized demo data.

For years I also handled infrastructure and support. That taught me to see the whole system, from the server to the user, and it still helps me design software that is easier to run.

  • Servers. Windows Server 2000 and 2008 administration and the move to a virtualized platform on Windows Server 2012, which I administered and maintained.
  • Access. Accounts, group policies and user permissions.
  • Network. Access policies on the Fortinet firewall, monitoring and general network tasks.
  • Deployment. IIS sites, SQL Server databases, backups and production releases.
  • Support. Computers, printers, cabling and supplies for staff.

.NET 10 · PostgreSQL · Vue 3

AeroFlux

Multi-tenant ERP for aircraft maintenance shops. Modular monolith with a standalone API and an OpenAPI contract. In development.

.NET 10 · PostgreSQL · Vue 3

MaBelle

Management platform for beauty salons, with per-organization data isolation. In development.

ASP.NET Core · Vue

Grillers

Team, judge and results management for a sports competition.

ASP.NET Core 10 · SQL Server · JWT

Vehicle workshop

Work orders, parts and inventory for maintaining a vehicle fleet.

Backend
C#, .NET Framework, .NET 10, ASP.NET MVC, ASP.NET Core, Entity Framework, APIs REST, SignalR, Hangfire, .NET MAUI
Data
SQL Server, T-SQL, stored procedures, query optimization, PostgreSQL, SQLite, Crystal Reports
Frontend
Vue 3, TypeScript, JavaScript, HTML and CSS
Integrations
XML and XSD, IATA Cargo-XML, REST services
Operations
Windows Server, IIS, Docker, Linux, Git
Legacy
Visual FoxPro

Education

Studies in Information and Communication Technologies Engineering, Faculty of Systems, Universidad Autónoma de Coahuila, 2006 – 2009. SQL Server course in Monterrey.

I keep that foundation current through ongoing training. On Udemy I completed Object-Oriented Design and Programming in C# and Design Patterns in C# Applied to ASP.NET, and I keep studying Entity Framework Core, ASP.NET Core, concurrency in C#, .NET MAUI, Vue and Docker.

Native Spanish. Intermediate English.

If you need someone who understands the process as well as the code, I would be glad to talk.

I also take on contract projects in process automation, inventory control and field operations.