Sterna
An Intelligent Logistics & Reporting Platform for Field Operations.
Internal Designation: Project Routings
Beginning as a React Native mobile application named Routings, Sterna evolved into a full-stack logistics platform with a dedicated .NET Core backend, Postgres persistence, Next.js web frontend, and proprietary Genetic Algorithm routing engine. It has been relied upon for years by telecommunications and industrial service providers to plan routes, capture field data, and generate professional reports. The system represents a multi-year architectural evolution from Firebase prototypes to sovereign, containerized infrastructure running inside the Orrery Stack.
Project Milestones
3/1/2017
Project Inception (Routings)
React Native mobile application launched for telecommunications maintenance route planning.
7/1/2017
Trello Integration
Integrated Trello API to convert board tickets into job cards within the routing pipeline.
12/1/2017
Google Maps Optimization
Google Maps API integrated for route optimization and distance matrix generation.
1/1/2021
Rebrand to Sterna
Project retained and renamed after separation from BTS Revenue Assurance.
6/1/2022
Backend Re-Architecture
Standalone .NET Core API introduced with dedicated React back-office frontend.
3/1/2023
Genetic Algorithm Optimization
Reduced reliance on Google Maps optimization by implementing proprietary GA routing engine.
3/1/2024
Modern Reporting Framework Released
Automated PDF reporting engine deployed for Solar and Panel Cleaning Solutions.
8/1/2025
Izimo Expansion
System enhancements underway to support multi-contractor deployment.
3 more milestones
Project Strategy
Key Decisions
- Transitioned from pure Google Maps route optimization to proprietary Genetic Algorithm to reduce API cost.
- Separated mobile field operations from dedicated back-office web frontend.
- Re-architected backend from Firebase to .NET Core with Postgres persistence.
- Implemented dynamic Trello board ingestion for operational ticket automation.
- Designed modular reporting engine capable of generating client-ready PDF documents.
Challenges Solved
- Balancing optimization accuracy with API token cost constraints.
- Migrating from Firebase Realtime Database to structured relational persistence.
- Designing flexible job card templates for dynamic data capture.
- Supporting multiple industries beyond telecommunications.
Future Plans
- Enhance multi-contractor tenant isolation.
- Introduce advanced optimization heuristics.
- Modernize mobile application for cross-platform maintainability.
- Expand reporting customization engine.