Categories

All

Services

Industries

Employee Availability Management System with Office 365

Summary

DMC created an employee availability and project management system using Microsoft’s Office 365 SharePoint Online platform, Azure Web Services, and Deltek ERP for an industrial control systems integrator.

Customer Benefits

  • Availability tracking for project managers and employees
  • Future forecasting to identify over/under utilization
  • Identify available resources with appropriate skills
  • Streamlined vacation process

Technologies

Solution

DMC’s client needed an availability management system to track which projects each of their engineers work on and to identify engineers who have upcoming availability to work on new projects.  The client wanted the ability to view both a project manager’s required resources and the employee’s anticipated time allocation to project work. 

A key component of this solution is the integration of data from their Deltek ERP system. Anytime a new project site is created in SharePoint Online, an availability dashboard is generated. The project manager can indicate the amount of effort that needs to be spent on the project over a specified time period.  The project manager can also indicate if the dates are flexible or not. Integration between Office 365’s SharePoint Online Platform and the Deltek ERP system is accomplished through the use of Azure Web Services.

Financial Overview Dashboard
The Financial Overview dashboard provides information on the current financial status of a project broken down into different categories. For each category, the project manager and team members can see the project's budget, as well as the amount of effort put into the Job to Date (JTD) and the estimated Cost at Completion (EAC) based on the tasks assigned.

Project allocation web part - dashboard for viewing how tasks on a project are assigned
The Project Allocation web part allows project managers to view resource scheduling for a single project, including all employees assigned to the project, who project phases are assigned to, and how many hours will be spent working on that phase in each upcoming week.

Project scheduling for a single employee
Using the Project Scheduling dashboard, engineers can view all of the projects assigned to them. If an engineer modifies their project assignments, other engineers working on the project are automatically notified. 

Employee availability tracking via dashboard

Lastly, the Availability web part allows managers to easily find employees who are available for project work during certain weeks. The list can be filtered by project timeline, position, office, category, and competency.

Other benefits of the employee availability system include the automatic generation of a vacation list to keep colleagues aware of who is scheduled to be out of the office. An integrated competency matrix of experience and skills allows management to instantly determine whether or not an available engineer will be suitable for an upcoming project.

The result is an availability system that avoids the dilemma of employees managing up or managers managing down. Project priority and resource distribution is viewed from both directions so that all employees are on the same page with regard to how much time individuals are expected to work on a project.

Learn more about DMC's SharePoint and project management system expertise.

Posted in Custom Applications, Dashboards, Employee Availability Management, Employee Time Entry and Tracking, HR Management Tools, Microsoft Azure Cloud Solutions and Services, Microsoft Consulting Services, Office 365, Project Process and Project Management, SharePoint, SharePoint / Office 365 Packaged Solutions

DMC Chicago • 2222 N. Elston Ave Suite 200 • Chicago, IL 60614 • (312) 255-8757

DMC Boston • 20 Holland St Suite 408 • Somerville, MA 02144 • (617) 758-8517

DMC Dallas • 1920 McKinney Ave 7th Floor • Dallas TX, 75201 • (972) 432-5536

DMC Denver • 1860 Blake St Suite 410 • Denver, CO 80202 • (303) 223-1801

DMC Houston • 3311 Richmond Ave Suite 209 • Houston, TX 77098 • (713) 322-9192

DMC New York • 141 W 36th St Suite 20N • New York, NY 10018 • (917) 473-0030

DMC Seattle • 506 2nd Ave Suite 910 • Seattle, WA 98104 • (206) 388-5186

DMC St. Louis • 1034 S Brentwood Blvd • St. Louis, MO 63117 • (314) 627-5427

https://www.dmcinfo.comsales@dmcinfo.com • (888) DMC-4400