Selected work delivered by our founding engineer, in house and freelance, before and alongside UrkAI.
Manufacturing and distribution company · Ecuador
From spreadsheets and paper to one platform
- Before
- Information was spread across Excel files, the ERP (SAP Business One) and an internal database. Reports were made by hand, machine output was written on paper at the end of each shift, and warehouse deliveries arrived with no schedule.
- Built
- One web platform where each department logs in and sees what it needs:
- Supplier portal. Suppliers see their purchase orders and how much is still pending, and book a delivery slot at a specific warehouse, with email notifications.
- Live machine monitoring. Machines send data every second, 24/7. Managers see uptime, downtime and units produced as it happens, and get an alert when a machine stops.
- Dashboards. Sales, stock and critical items, updated automatically and available inside the platform.
- WhatsApp bot. Managers ask for daily sales, items about to run out or today's orders, and get the answer from the database.
- Result
- Warehouse reception went from chaos to scheduled, and production got real-time data instead of end-of-shift totals.
Tools: Python, Flask, Google Cloud Run, Siemens PLC, Node-RED, Firebase, Power BI.
US software company serving major airlines
Hourly reporting for 5 airlines
- Before
- Raw booking and pricing data had to become clean reports for 5 airlines, each with its own currency and business rules. The longest jobs were too slow.
- Built
- An automated data pipeline that runs every hour, keeps each airline's data separate, and delivers ready-to-use tables straight into each customer's Power BI.
- Result
- 6x faster on the longest-running jobs.
Tools: Databricks, PySpark, Delta Sharing, Power BI.
The same airline software company
From manual releases to automatic ones
- Before
- Every release meant copying code into production by hand and creating tables manually.
- Built
- Proposed and built automated release pipelines and a shared code library.
- Result
- Adopted by the whole data team.
Tools: Azure DevOps pipelines, Python.
Freelance
App for delivery operations
An Android app for logistics and quality control in delivery operations.