Time Tracking System

Time tracking system

Business Case

Initi, lly the client was making use of various applications to manage their client’s resources. This was time consuming and required more efforts. The client was looking for developing a solution which could store and manage all the data in an organized manner, which would save time and effort. They wanted the following features in the application:

  1. Task & Time Tracking Management
  1. Client Management
  1. Resource Allocation
  1. Dashboard (widgets based on Client, Resource, Employee, Task)
  1. Invoice Management

They also wanted advanced filtering and sorting features.


Integrated Development Environment (IDE)
Database Server
Business Analytics
Cloud Computing Tool
Application Programming Interface
Microsoft Visual Studio 2015
.Net Framework 4.5
Microsoft SQL Server 2016
Power BI Desktop
Microsoft Azure
Namely API Integration
QuickBooks Web Connector
Technical Objectives:
  1. Design and develop a web portal for Managed Resources (MRI).
  1. Pull the existing employee information from Namely API and store in MRI application.
  1. Give access to the Admin to configure pre-requisite application settings and manage employee demographic information.
  2. Design and develop a dashboard in such a way that the user is easily able to view data and make necessary decisions.
  3. Easy-to-use Scheduler for the Manager to allocate resources.
  1. Manage the Dashboard dynamically, in order to generate data as and when queried.
  1. User Management using Azure AD Authentication so that there is no need to register each employee.
PSSPL Solution:

PSSPL designed a solution in such a way that the client could monitor everything from MRI Web Application.

It has a Power BI Dashboard so that the Admin and the Business User have broader view of business activities.

It has the capability to manage client-employee tasks and schedules.

The application would also export Client Invoice to QuickBooks Desktop software via Web connector.

All this information can be made available to authorized users from anywhere in the world via internet.

  1. Eliminating time required to manage different software.
  1. Ability to fetch current progress of Employee, Client Allocation, Client Billability.
  1. Give system access to the Manager for employee allocation to clients based on resource availability. Manager would be able to approve and review Employee Timesheet.
  1. Employees can fill their timesheets and submit it to the Manager for review and approval of bill.
  1. Clients can view their resource allocation for keeping track and sending feedback.
  1. Increased productivity and getting more work done from the Manager without looking at many other software at a time.
  1. Access to key information from anywhere at any time.
  1. Improved work-force utilization, increased visibility of resources, time-tracking.
  1. Increased visibility of business plan without having to look across different software.