Industry · Biscayan industrial company (Confidential client)
ERP data platform for an industrial company
The challenge
A Biscayan industrial company had critical data trapped in an ERP (Oracle/Prinex) and spreadsheets, with no single, usable view to make decisions.
What we did
We designed an end-to-end pipeline: ERP extraction, cleaning and normalization ETL, PostgreSQL database, API and a frontend to query and operate the data in production.
Technologies
Oracle · Python · ETL · PostgreSQL · FastAPI · Next.js · Azure
Result
Unified ERP data available through a production application for day-to-day queries and operations.