Offshore Systems: Access Apps Consolidated Into One Web System

Client

Offshore Systems, Inc.

Industry

Maritime services

Technologies

SQL Server, ASP.Net Core MVC framework running on Microsoft Internet Information Server (IIS) using a Responsive Design

Overview

Project highlights

Three tools into oneA time-tracking website and two Access applications consolidated.
Built for slow connectionsUsable from harbor locations with slow connectivity.
Many users at oncePeople in different offices can add and edit data simultaneously.
Role-based permissionsAdministrators control what each user can see and do.

Before

The challenge

Offshore Systems, Inc. (OSI) has staff in locations all over the world and at sea, including harbor locations in Alaska. They ran their operations across three separate tools: a time-tracking website and two Microsoft Access applications, one for administration and one for reporting.

OSI needed one redesigned website and database that centralized all three, which several people in different offices could use at the same time, including from harbor locations with slow connectivity.

After

What we built

J Street built a robust, highly searchable web application and SQL Server database from the ground up, letting multiple users access, add, and edit data at the same time from different locations, even over slow internet connections. Its responsive design works on desktops, tablets, and phones.

Employee work entries, both time cards and services, can be searched, viewed, and edited in one place, and a Work Entry invoicing module lets authorized users see every time card and service associated with a project. A Pots Inventory tracks gear such as crab pots warehoused onshore.

Customer and employee searches show basic information with drill-down to full detail. Reports include a Time Card Labor Cost Report in PDF format, and administrators can create roles that control granular permissions for each user.

Inside the system