Offshore Systems Inc. Case Study

Need:

Offshore Systems, Inc. (OSI) previously managed their operations using a website for employee time tracking and two Access applications: Administration and Reporting. They needed a new redesigned website and database that centralized these three applications into a single website. The system needed to be accessible for operational activities by multiple users and OSI offices, including their harbor operation in Dutch Harbor, Alaska.

Solution:

Build a robust, highly searchable system from the ground up, allowing multiple users to access, add, and edit data simultaneously from different locations using slow internet connectivity.

Technologies used:

SQL Server, ASP.Net Core MVC framework running on Microsoft Internet Information Server (IIS) using a Responsive Design.
OSI1
Employee work entry detail (time cards and services) can be easily searched and viewed.
OSI2
Time card detail can be edited and viewed.
OSI3
Work Entry invoicing module allows authorized users to see all time cards and services associated with a project.
OSI4
Pots Inventory (e.g. crab pots that are warehoused onshore) displays data for viewing and editing.
OSI5
Customer Search displays basic information with the option of drilling down to see detail.
OSI6
Employee Search displays basic information with the option of drilling down to see detail.
OSI7
Customer detail allow a more in-depth view of information.
OSI8
Employee detail allow a more in-depth view of information.
OSI9
Reports includes a Time Card Labor Cost Report in PDF format.
OSI10
Administration includes the ability to create Roles to control granular permissions for users.