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
- PHP
- PostGreSQL
- Python
- 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.
- Industrial Impact: It facilitates high-speed logistics by grouping orders into picking flows, significantly reducing human error through industrial data collector integration.
- Support to all mayor barcode label printers: Zebra, Datamax, Honeywell. Support printer languages natively. ZPL, EPL, DPL, IPL, Fingerprint.
- 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
- 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
Technologies used
- Docker
- Google Cloud Run
- Kotlin
- MySQL
- .NET
- PHP
WarehouseCounter is a high-performance inventory auditing utility designed for the rapid generation of updated stock records in environments like supermarkets and industrial depots.
- 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.
SAP Synchronization
Technologies used
- Docker
- Google Cloud Run
- MySQL
- Python
- SAP Business One API
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.
MkDocs QR Plugin
Technologies used
- Python
- Markdown
The module allows the generation of QR codes while rendering Markdown documentation using MkDocs. I often place a QR code in the documentation to improve the UX. Enabling the user, for example, to download the latest version of the app on their phone without having to open the page on their phone.
Api test toolbox
Technologies used
- Python
Validate results in FastAPI projects without repeating boilerplate logic. When running tests against an API, you almost always need to verify the HTTP status code and the length of the response. A secondary goal is to raise detailed exceptions that include the request data and status code; this eliminates the need to manually debug tests to identify the root cause of a failure.
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.
- Technical Stack: The architecture was transitioned to include a Python (FastAPI) and PHP backend, with Kotlin (Android) and C# .NET clients.
- DevOps Implementation: I 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.
High-Speed RFID Vehicle Identification System
This system enables the remote identification of vehicles and motorcycles traveling at speeds up to 130 km/h using radio frequency identification (RFID).
- Functionality: The system reads RFID tags integrated into vehicle plates to retrieve domain information, chassis numbers, and VTV (technical inspection) expiration dates.
- Real-Time Processing: Using antennas mounted on traffic control arches, the software transmits data in real-time to a central database for immediate violation reporting.
- Resilience: The technology is specifically designed to remain effective even when plates are dirty, obscured, or mounted vertically.
Precision RFID Railway Positioning System
A mission-critical system designed for the identification and positioning of trains across major railway lines. The problem was that GPS was not precise enough to determine the track number.
- System Integration: The solution integrates with the existing SIGOF system and GPS modules to provide the exact track number a train formation is currently occupying.
- Infrastructure: It involves the deployment of over 1,000 RFID tags per branch fixed to railway sleepers and custom onboard software communicating via TCP/IP.
- Logic: The software is programmed to handle intermittent connectivity, storing read data locally until an Ethernet link becomes available to sync with the central server.