AssetControl: Asset Management System

Description

Technologies used

C#
Kotlin
MySQL
.NET
PHP
Google Cloud Run
Docker

Responsibilities

Product owner
Backend developer
Windows CE App Main developer

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.

Development started back in 2010 for a health provider who suffered equipment theft regularly. Currently on version 13.8.0.

Achievements

Comprehensive Asset Reporting: Generate detailed reports of missing assets across multiple locations and buildings.
Dynamic Asset Status Tracking: Evaluate and monitor custom asset parameters, such as [oil pressure, clean, open, color]
System Interoperability: Support for SAP and other external systems, functioning as a standalone "last-mile" solution.
Cloud-Native Deployment: Optimized to run on Google Cloud Run (GCR) with a minimal resource footprint.
Mobile Data Collection: A dedicated Android application specifically designed for efficient field data entry.
Universal Hardware Support: Compatible with a wide range of industrial printers and handheld data collectors.
Multi-Modal Identification: Identify and track assets via Barcode / RFID / Manufacturer Id / Serial number
Intuitive User Experience: A streamlined, user-friendly interface requiring minimal training.

Learned

Implementing RFID-enabled data collectors and readers: Integrated hardware solutions for real-time data acquisition.
Optimizing high-volume data imports: Developed strategies for importing large datasets while efficiently managing high key-collision risks.
Managing complex external mappings: Handled multiple external identifier links per model to ensure cross-system data integrity.

Design

graph TB
    MAIN([<b>DB</b> </br> MySQL])
    WEBSERVICE[<b>WEBSERVICE</b></br>]
    DESKTOP[<b>PC</b> </br>Windows 7 or higher]
    BARCODE_LABEL_PRINTERS[<b>Printers</b> </br>Zebra/Honeywell/etc]
    RFID_READERS[<b>RFID Readers</b> </br>Portals / directional]
    DATA_COLLECTORS[<b>Data collectors</b> </br>Android o WCE/ WEH]

    MAIN <--> WEBSERVICE
    WEBSERVICE <-->  DESKTOP
    WEBSERVICE <-->  DATA_COLLECTORS
    DESKTOP --> BARCODE_LABEL_PRINTERS
    DATA_COLLECTORS --> BARCODE_LABEL_PRINTERS
    WEBSERVICE <--> RFID_READERS

Components

API (New)
- Developed with Python and FastAPI, leveraging asynchronous capabilities for optimal speed.
- Extensive API Surface: Managed a complex ecosystem of 200+ endpoints, ensuring modularity and clean routing
- High Code Coverage: Achieved 79% code coverage, prioritizing critical business logic and data integrity through rigorous unit and integration testing.
- Robust Test Suite: Maintained a comprehensive suite of 400+ tests to ensure system stability and prevent regressions.
WebService (EOL)
- Developed in PHP using NuSOAP
View WebService
Windows APP
- Platform: Developed using .NET C#
- Operating System Compatibility: Engineered for Windows 7 and above
View product page
Windows CE APP (Deprecated)
- Developed for Windows CE and Windows Embedded Handheld (WEH) environments.
- Lifecycle Management: Currently in the maintenance phase of its lifecycle, providing critical support until the transition to updated customer hardware is complete.
- Offline-First Architecture: Designed as a standalone application capable of full functionality without a network connection, enabling audits in high-security or zero-coverage areas.
View product page
PlayStore Android App (deprecated)

We currently do strategic distribution: Managed via a private repository to address specific dependency constraints and ensure compatibility with legacy data collection hardware.
- Modern Kotlin Development: Leveraged Kotlin to build a robust, performant mobile application.
- Offline-First Architecture: Designed as a standalone application capable of full functionality without a network connection, enabling audits in high-security or zero-coverage areas.
- Continuous Integration & Deployment (CI/CD): Implemented automated pipelines for web builds.
View Playstore
Website

Product page

View product page

Main advantages

High-Efficiency Asset Management
- Rapid Inventory Auditing: Leverages specialized data collectors and integrated handheld workflows for streamlined, real-time asset tracking.
- Comprehensive Movement History: Maintains a chronological audit trail for every asset, including initial entries, internal transfers, maintenance-related repairs, and final disposal.
- Photography: Allows users to attach high-resolution images to asset files, providing an indisputable visual record of physical condition for insurance and compliance purposes.
Financial & Lifecycle Intelligence
- Automated Fiscal Reporting: Handles complex calculations for Depreciation, Rentals, and Leasing with automatic generation of monthly financial reports.
- Categorization & Vendor Management: Advanced organizational structure using Categories, Manufacturers, and Suppliers to optimize searchability and procurement strategy.
Maintenance & Operational Reliability
- Proactive Maintenance Scheduling: Supports both Preventive and Corrective maintenance cycles. Users can schedule inspections and maintain a permanent digital log of all service history.
- Status Checkpoints: Monitors specific operational metrics (checkpoints) for each asset to maintain a performance and health log.
Advanced Hardware & Security Integration
- Native Barcode Orchestration: Features a built-in label designer with direct-to-printer communication. Eliminates the need for third-party middleware, ensuring seamless hardware compatibility.
- Granular Access Control: Robust user profile management with specialized permissions. Security policies are enforced consistently across both desktop and mobile (handheld) environments.
Universal Data Export: One-click functionality to export critical data into industry-standard formats, including Word, Excel, and PDF.