Enhancing business processes
for the Gas Industry

SF6 Gas Management, Employee Tracking, and Inventory Management

About Project

We partnered with a global leader in the supply of SF6 Gas (Sulfur Hexafluoride gas), and other specialty and rare gases for industrial, commercial, and consumer uses. Our collaboration aimed to enhance their business processes, inventory management, and employee tracking in a fast-paced, demanding industry.

The Challenges

Our client previously relied on MS Access for data input and updates, creating a data synchronization challenge between SQL Server and MS Access.
Other hurdles included customizing role-based access, real-time tracking of gas top-off for employees and subcontractors, facilitating both read and write access for account managers, generating annual reports for purchases and returns, identifying gas leakage in circuit breakers, and providing a comprehensive dashboard for vital analytics.

The Solution

We tackled the data sync issue by employing MSSQL SSIS and OLE DB Architecture, facilitating seamless data transmission between MSSQL and MS Access.
For role-based access, we introduced dynamic roles and permissions.
By implementing SignalR in Asp.Net Core Applications, we addressed real-time tracking. Super admin users received a one-click client login solution, providing full visibility into client activities.
Our visualization of yearly purchases and returns came through comprehensive charts. A system to identify gas leakage was implemented by tracking the last 10 topoff histories.
Finally, we empowered users with a customizable dashboard featuring widget options for enhanced data control.

Team Size

A dedicated team of 4 professionals

Time to MVP Launch

Rapid development and
deployment with MVP launched
in just 4 weeks

Project Delivery Timeline

Ongoing development over 12 weeks
and counting, ensuring continuous
innovation and improvements

Key Features

Dynamic Dashboard

Our widget-based design allows you to create a unique view of your business with a wide array of widgets, including inventory reports, total purchases, returns, circuit breaker activities, and client overviews.

Efficient Client Management

Oversee all aspects of your client relationships with features for data management, document uploads, bulk import, and more.

Employee and Subcontractor Management

Handle every aspect of employee and subcontractor data with features for data management, bulk import, and export.

Comprehensive Purchase and Return Management

Manage every aspect of gas handling, from warranty to recycling, with features for customer satisfaction tracking, product replacement, drop shipping, and cylinder management.