USA-based Oil Company

Family-owned oil company founded in 1958 in Brighton, Michigan by Bernie, now led by his sons, operates as a multi-state diversified group across fuel and environmental services.

Solutions n Features:
A fuel pricing app was built as a centralized automated pricing and discount system, replacing manual workflows and enabling search, audit, and real-time monitoring.
• A dedicated interface enabled direct access to raw, undiscounted fuel price feeds, ensuring accurate pricing without intermediate adjustments.
• Displayed discounted/regular prices and standardized external vendor products to internal Rack Product naming for platform consistency.
• A streamlined interface enabled viewing of Bills of Lading with automated retrieval and parsing from an external server.

Goals:
• Database triggers and stored procedures automatically ensured retrieved prices were accurately updated according to the latest vendor discount agreements.
• Automated audit logging tracked all critical table changes, capturing who changed what and when for compliance and troubleshooting.
• High-performance data grid enabled instant search, filtering, and export of pricing history, replacing manual effort and improving efficiency, responsiveness, and accuracy.

Tech Stack: