Skip to main content
yusrb

Projects

Selected work

04 projects shown

  • 01 2025
    CURRENT STOCK CODEITEMMOVEMENTSTOCK

    Integrated Web-Based Inventory Tracking System

    A web application that records raw material and finished goods movements in real time, replacing end-of-day spreadsheet reconciliation.

    Web Development HTMLCSSJavaScript
  • 02 2025
    EXEC dbo.usp_CheckBatch @Days = 1;-- status: 142 batches, 3 failedSELECT TOP 5 name, row_countFROM sys.tables ORDER BY row_count DESC;-- purge history > retention (500 rows/batch)DELETE TOP (500) FROM batch_historyWHERE created_at < @cutoff;-- done: 18,500 rows removed CHECK HISTORY

    ERP Database Log Maintenance & Diagnostic Scripts

    Scheduled X++ and SQL jobs that check the health of a Microsoft Dynamics AX 2012 database and purge log data that has outlived its retention period.

    Systems & IT Support X++T-SQLMicrosoft Dynamics AX 2012
  • 03 2024
    Search guides, e.g. "print job failed" ERP HARDWARE NETWORK SYMPTOM STEPS 1 2 3

    Internal Technical Documentation & Operations Help Center

    An internal documentation site with ERP usage guides, hardware troubleshooting procedures, and answers to frequently asked questions.

    Systems & IT Support AstroMarkdownTailwind CSS
  • 04 2024
    CATALOGORDERSCUSTOMERS ORDER #0047 STATUS Received Confirmed Production Quality Shipped

    Product Catalog & Manufacturing Order Management Web App

    A web application that presents a textile print product catalog, accepts orders, and tracks each order from intake to delivery.

    Web Development HTMLCSSJavaScript
Next section — Working Principles, Skills Matrix & Certifications

About & Method

Continue reading