Data and operations-oriented professional with hands-on experience building supply chain planning tools, validating ERP data, and designing decision-support systems in industrial environments. Strong SQL skills applied to production problems. Comfortable working with incomplete, inconsistent data across multi-entity organisations and building reliable reporting logic under real operational constraints.
Experience
Supply Chain Planning & Decision Support
Built a production planning system connected via ODBC to Sage X3 — reduced planning cycle from 3 days to 15 minutes across 350 SKUs, 4 colour cycles, 5 sites.
Replaced description-based material allocation with BOM-driven code logic queried directly from Sage X3; reduced separation errors to near zero and removed ambiguity from daily production decisions.
Designed and iterated 40+ versions of planning tools, progressively migrating calculation logic from Excel into SQL to improve data quality, performance, and reliability.
Implemented a phased delivery tracking system for export orders covering 200–500 apartments per project; built pallet-level traceability and cross-validated delivery notes against invoices to surface discrepancies.
Built a client-facing order schedule integrating Sage X3 data via a SQL composite key (4–5 CASE statements); used simultaneously by planning, client, and export department as a shared source of truth.
ERP Data & Operational Systems
Sole certified Sage X3 resource supporting 50 users across 4 legal entities, 5 factories, and 5 warehouses; completed official 300-hour Sage X3 technical certification.
Built a SQL query library covering stock, open orders, BOM, customer data, and transaction history — replacing manual Syracuse queries that blocked concurrent users: github.com/TemplarK-dev/SageX3
Managed a full inventory reconciliation and rebuild via batched CSV imports (300 lines per file) after standard ERP operations failed to zero stock correctly; resolved root cause and rebuilt data integrity over a 25-hour operation.
Resolved a stock entry gap in the first 6 months by tracing data flow across cascaded societies and implementing a recursive negative invoicing workaround pending system readiness.
Operational Tool Development
Built a subscription-based billing system for an operational client — reduced billing processing from 8 hours to 15 minutes; includes delivery route management, weight-based pricing logic, and partial payment tracking.
Designed the underlying data model for order generation, modification audit trail, and payment history — with data validation rules enforced at the application layer to prevent inconsistencies.
Skills
SQL — advanced, production useSage X3 — certified, 3 yearsExcel + ODBC — data layer, reportingData modelling — schema design, MVCERP data validation & reconciliationSysML / Systems Engineering — MSc
Education
MSc, Industrial Engineering and Management — Instituto Superior Técnico
Dissertation: production costing model for a multinational textile factory using SysML and the V-Model.
BSc, Industrial Engineering and Management — Instituto Superior Técnico