COLDEV
Flight operations and logistics: quotes, trips, legs, cargo and tracking.
27,455 legs in 2025
Erick Javier Mireles Riojas · Senior .NET Full Stack Developer

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.
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.
Turbo Pascal at the Tecnológico de Saltillo and, on my own, Visual FoxPro.
Visual FoxPro maintenance and support. At CIMAGUA, a warehouse system that eliminated losses in the utility's quarterly audits.
Complete Visual FoxPro 9 system: field work for about 12 crews, photo evidence, reports, materials control and warehouse inventory.
Maintenance and development of Visual FoxPro modules for operations, maintenance and administration. Windows Server 2000 and 2008 administration.
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.
Design and development of a warehouse, purchasing and maintenance application. In production since June 2022; I still maintain it.
I led the development and wrote most of the backend.
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.
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.
Flight operations and logistics: quotes, trips, legs, cargo and tracking.
27,455 legs in 2025
Maintenance: work orders, tech logs, task cards, components and due limits.
23,066 tech logs in 2025
License and certificate expirations, type qualifications and flight-hour pay.
10,552 expiration records
Engine parameters captured in the tech log to follow trends per aircraft.
51,469 parameter records
Recording, approval and reimbursement of each trip's expenses.
29,296 expenses recorded
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 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.
Aeronaves TSM · ASP.NET MVC · SQL Server
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.
Aeronaves TSM · C# · IATA Cargo-XML
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.
Servicios Aéreos Quintana · ASP.NET · EF6 · SQL Server
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.
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.
.NET 10 · PostgreSQL · Vue 3
Multi-tenant ERP for aircraft maintenance shops. Modular monolith with a standalone API and an OpenAPI contract. In development.
.NET 10 · PostgreSQL · Vue 3
Management platform for beauty salons, with per-organization data isolation. In development.
ASP.NET Core · Vue
Team, judge and results management for a sports competition.
ASP.NET Core 10 · SQL Server · JWT
Work orders, parts and inventory for maintaining a vehicle fleet.
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.