INTERNAL

zEt/n

Enterprise Mining Data Platform

Replaced Excel macro workflows across 6 mining sites with a browser-based platform that validates and uploads operational data to MineMarket in real-time.

MineMarket is the mining industry's operational data system. iHub is its file-based ingestion service. The org was phasing out Excel macros because they're a security vulnerability.

PythonFastAPINext.jsDynamoDBS3TerraformECS Fargate

Internal — Enterprise

Sole engineer, 92% of codebase. Architecture, 19 Terraform modules, CI/CD, deployment across DEV/STG/PRD.

19Terraform Modules

7Mining Processors

93React Components

3ECS Services

ARCHITECTURE

Scroll to zoom·Click fullscreen for detail

HIGHLIGHTS

IN-BROWSER SPREADSHEETS

Univer replaces Excel entirely. Users pick their module (DigBlock, ExPit, Crushing, etc.), get a template with validation rules baked in, and fix errors before anything touches MineMarket

DIRECT MINEMARKET INTEGRATION

Delivers processed CSVs to iHub watch paths over SMB/CIFS with WebSocket notifications tracking each file from upload through ingestion

FULL AUDIT TRAIL WITH REVISIONS

Every upload tracked by user, timestamp, site, and module. Users can go back, correct, and resubmit previous spreadsheets with the revision chain preserved

ENTRA ID AUTH

OAuth sign-in with existing MRO credentials. Role-based access per site controls who uploads, views history, and manages templates

TECH STACK

Frontend:Next.js 15React 19Univershadcn/uiTanStack Query

Backend:FastAPIPythonSQSDynamoDBRedis

Infrastructure:TerraformECS FargateCloudFrontWAFS3

Integration:SMB/CIFSiHubWebSocketMicrosoft Entra ID

All Projects PiggyBack