Projects
Reporting automation, ERP improvements and web tools built to remove manual work from daily store and inventory operations.
Web Tool
Web-based analytics app to search, filter and analyse engineering store inventory instantly.
Benefit: Answers stock questions in seconds instead of running ERP reports.
HTML · CSS · JavaScript · Developed
MIS & KPI
Monthly store and inventory KPI pack — Melting, Oxygen Plant, liquid and local spares cover days — generated from a standard data model.
Benefit: Consistent monthly reporting with far less manual preparation.
MS Excel + PowerPoint · Developed
Procurement
Purchase cost vs. production, lead time, emergency purchase and top-20 item analysis, plus live PR & PO balance monitoring.
Benefit: Visibility of pending procurement commitments and purchase performance.
BI Tools · Excel · Developed
Warehouse Operations
Location search with admin bulk auto-mark update of physical storage locations against item codes.
Benefit: Faster picking and accurate physical traceability.
Web tool · ERP / BI · Developed
Web Tool
Instant search across the item master by code, description and category.
Benefit: Find any spare item without opening the ERP.
HTML · CSS · JavaScript · Developed
Web Tool
Searchable internal phone and IP extension directory for departments and staff.
Benefit: Anyone can find a contact in one keystroke.
HTML · CSS · JavaScript · Developed
Reporting Automation
Automated report that flags transactions booked to the wrong account.
Benefit: Faster correction of accounting errors in inventory transactions.
BI Tools · Developed
Inventory Control
Reorder point and economic order quantity analysis for spare items.
Benefit: Balanced stock holding and reduced stock-out risk.
MS Excel · Developed
Warehouse Operations
Tracking of goods received notes that remain pending in the system.
Benefit: Cleaner receiving pipeline and faster closure.
BI Tools · Developed
Inventory Control
Automatic summary of materials moved between sister concerns.
Benefit: Quick reconciliation of intercompany material movement.
MS Excel · Developed
Reporting Automation
Automated summary of gaseous item sales and transactions.
Benefit: Reduced manual compilation effort for gas reporting.
MS Excel · Developed
Warehouse Operations
Printed code labelling system for electrical spare items.
Benefit: Reduced identification errors on the store floor.
Printed identification system · Developed
Warehouse Planning
Layout planning for store areas and capacity.
Benefit: Better space utilization and material flow.
Warehouse planning · Developed
ERP
Oracle view of purchase requisition approval status, built with the IT team.
Benefit: Transparency on where an approval is waiting.
Oracle + IT collaboration · Developed
Web Tool
Simple web-based finder for projects and tasks.
Benefit: Quick lookup without opening multiple files.
HTML + CSS · Developed
Web Tool
Web tool that converts plastic cap quantities between units.
Benefit: Removes repetitive manual conversion.
HTML + CSS · Developed
Calculation Tool
Calculator for ready-mix concrete mixture requirements.
Benefit: Consistent, quick mixture calculation.
MS Excel · Developed
ERP
Segregation of Rolling Mill 2 assets in records and system.
Benefit: Clear ownership and reporting per unit.
MS Excel + ERP · Developed
Reporting Automation
Physical location fields surfaced inside BI inventory reports.
Benefit: Location visible directly in the analysis view.
BI reporting · Developed
Process Standardization
Detailed standard operating procedure documents for store employees.
Benefit: Consistent execution and easier onboarding.
Process standardization · Developed
Continuous improvement
Improvement ideas, clearly labelled as concept, proposal or development — not completed implementations.
