Miguel Hatrick - Work Portfolio
I am a professional software developer with extensive experience designing robust, industrial-grade systems focused on logistics, asset management, and RFID technologies.
Projects
The following abstracts represent a selection of my latest key projects.
Warehouse Management System (WMS)
StockControl is a comprehensive solution designed to optimize warehouse management and logistics operations. It provides real-time visibility into stock levels, managing everything from warehouses and rack locations to detailed lot tracking for FIFO/LIFO control.
Technologies used
- C#
- FastAPI
- Kotlin
- MySQL
- .NET
- PostgreSQL
- Python
Business Impact
- High-Performance Throughput: Processes 200+ complex receptions (including QC) in under a minute — far exceeding the client's core requirements.
- Error Reduction: Grouping orders into picking flows significantly reduces human error through industrial data collector integration.
- More in the full description
- Key Features: Integrated assembly/disassembly modules, automated barcode label design, and a multi-platform environment supporting Windows Desktop, Android, and Windows CE.
- SAP Integration: The system features a dedicated Synchronization Panel to integrate seamlessly with SAP, managing purchase orders, stock adjustments, and supplier data.
- Dedicated Android App for warehouse operations in real time.
Asset Management System
AssetControl is a specialized system for the end-to-end administration of a company's fixed assets. It allows organizations to maintain an updated, audited inventory that includes supplier details, warranty tracking, and insurance information.
Technologies used
- C#
- Kotlin
- MySQL
- .NET
- PHP
- Google Cloud Run
- Docker
Business Impact
- Theft Prevention: Reduced equipment theft by 40% through real-time tracking and automated audits.
- Audit Efficiency: Cut annual audit time from 2 weeks to 3 days using mobile data collectors and automated reporting.
- More in the full description
- Capabilities: Users can track internal movements, schedule preventive maintenance, and manage financial amortizations or leasing payments.
- Audit Efficiency: By utilizing RFID tags and handheld barcode scanners, the system allows for rapid periodic audits, detecting missing assets and variations immediately.
- Data Integrity: The software features automatic server backups and multi-level user permissions to prevent unauthorized manipulation of sensitive asset data.
High-Volume Depot Auditing System
WarehouseCounter is a high-performance inventory auditing utility designed for the rapid generation of updated stock records in environments like supermarkets and industrial depots.
Technologies used
- Docker
- Google Cloud Run
- Kotlin
- MySQL
- .NET
- PHP
Business Impact
- Speed: Reduced inventory audit time by 80% compared to manual counting methods.
- Accuracy: Achieved 99.5% accuracy in stock records, minimizing discrepancies and shrinkage.
- More in the full description
- Architecture: The solution runs from a dockerized image which provides an API for the mobile data collector applications.
- Performance: It is engineered to audit hundreds of articles in minutes, with the capacity to handle thousands of items.
- Operational Agility: Key features include automatic item description retrieval, partial count tracking, and a "multiplier" function that enables high-speed counting of full boxes or pallets with minimal manual entry.
Precision RFID Railway Positioning System
A mission-critical system designed for the identification and positioning of trains across major railway lines. The core challenge was that GPS alone lacked the precision required to determine exact track numbers in complex yard environments. The solution deployed industrial-grade RFID tags on railway sleepers and readers on locomotives, creating a highly accurate, real-time positioning network. Developed for SOFSE (Ferrocarriles Argentinos) across the Mitre, San Martín, and Belgrano Sur lines.
Technologies used
- C#
- Kotlin
- MySQL
- .NET
- Python
- RFID (Intermec/Honeywell)
- GPS Integration
- SCADA Integration
- Wireless Mesh Networks
Business Impact
- Precision Tracking: Achieved exact track-level positioning, completely eliminating GPS drift and positioning errors in high-density rail yards.
- Operational Safety: Enabled real-time train detection and route verification, enhancing traffic management and regulatory compliance.
- More in the full description
- Architecture: Deployed industrial-grade RFID tags on railway sleepers and readers on locomotives to create a deterministic positioning network.
- Performance: Achieved exact track-level positioning, eliminating GPS drift in high-density rail yards.
- Operational Agility: Offline-capable handheld PDAs for tag deployment, georeferencing, and auditing without network dependency.
- Resilience: The technology is specifically designed to remain effective even when plates are dirty, obscured, or mounted vertically.
SAP Synchronization
This project involved the implementation of StockControl, a comprehensive Warehouse Management System (WMS), and its deep integration with SAP. The primary goal was to create a parallel operational environment where warehouse activities are managed through specialized data collectors while automatically informing SAP of the results in real-time.
Technologies used
- Docker
- Google Cloud Run
- MySQL
- Python
- SAP Business One API
Business Impact
- Eliminated Manual Data Entry: Automated bidirectional sync between WMS and SAP across 30,000+ items, removing error-prone manual reconciliation.
- Real-Time Accuracy: 2-minute synchronization cycles for critical tasks like inventory audits ensure SAP always reflects current warehouse state.
- More in the full description
- Core Capability: The synchronization program manages the flow of critical logistics data, ensuring that the ERP (SAP) remains the "source of truth" while the WMS handles the granular warehouse logic.
- Bidirectional Integration: Automated import of master data (30,000+ items, categories, customers) and operational documents (purchase orders, sales orders) from SAP, with real-time export of reception results, distributions, and inventory counts back to SAP.
- Quality Control Decoupling: Unique "Packages to control" labels allow warehouse staff to postpone QC without halting physical receipt of goods, with automatic classification into Accepted, Rejected, or Excess states.
AMS Infrastructure: Modernization & CI/CD Transition
This project involved the large-scale modernization of the AssetControl infrastructure to address technical debt and non-standard build environments.
Business Impact
- Reduced Build Failures: Containerized builds eliminated "works on my machine" issues, reducing environment-related deployment failures by an estimated 70%.
- Faster Release Cycles: Automated CI/CD pipeline reduced release preparation time from days to hours, enabling more frequent and reliable deployments.
- Improved Developer Productivity: Decoupled repositories and standardized build environments reduced onboarding time for new developers and minimized context-switching overhead.
- Technical Stack: The architecture was transitioned to include a Python (FastAPI) and PHP backend, with Kotlin (Android) and C# .NET clients.
- DevOps Implementation: Decoupled monolithic dependencies into dedicated repositories and established a robust CI/CD pipeline to automate testing and deployment.
- Optimization: The entire development environment was containerized using Docker, ensuring platform-independent builds and removing reliance on local development machine configurations.
Beekeeping Industry Traceability System (Apitrack)
Apitrack is a first-generation food chain traceability software engineered specifically for the beekeeping industry. It was the pioneering system to implement RFID tags directly on beehives and integrate industrial-grade data collectors with barcode labeling for end-to-end production tracking.
Technologies used
- C#.NET
- MySQL
- .NET Framework
- Windows CE / Windows Mobile
- PSION TEKLOGIX / DATALOGIC / INTERMEC Data Collectors
- RFID (Honeywell/Intermec)
- Barcode Labeling (ZEBRA Thermal Printers)
- RS232 Industrial Scales Integration
- Web-Based Public Traceability Portal
Business Impact
- Industry Pioneer: First system worldwide to deploy RFID identification on beehives, establishing a new paradigm for apiculture traceability.
- Regulatory Compliance: Enabled producers to meet and exceed national food safety regulations and international export standards, opening access to new markets.
- More in the full description
- Industry Pioneer: First system worldwide to deploy RFID identification on beehives, setting a new standard for apiculture traceability.
- Complete Supply Chain Coverage: Tracks honey from individual hive through extraction, fractionation, storage, and consumer delivery — covering the entire apicultural value chain.
- Regulatory Compliance: Enables producers to meet national food safety regulations (Argentina Res 857-2006, Res 870-2006) and international export standards across 6+ countries.
- Weather-Resistant Labels: Custom OPP labels engineered to withstand rain, UV exposure, and extreme temperatures (-25°C to 85°C) in outdoor apiary conditions.