SF6 Gas Management, Employee Tracking, and Inventory Management
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.
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.
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.
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
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.
Robust Inventory Management
End-to-end gas management, including purchase, refill, recovery, testing, removal, disposal, and damage processes.
Circuit Breaker Management
versee all substation and circuit breaker operations.
Real-time Gas Topoff Tracking
Track employee and subcontractor activities in real-time with map view for enhanced data understanding.