Resource Utilization Data Collection Workflow

Requirement

• Create custom modules and workflows to collect data to calculate resource utilization.
• Employees work timesheet is present in private database.
• The database is pulled in SNOW by connecting to APIs and stored into custom tables.
• Data needs to be pulled in following sequence, processed and stored.
  • Get users
  • Get task names
  • Get project names
  • Get time sheets
• Populate monthly team utilization table.
• Generate various reports as
  • Overall Utilization
  • Utilization by Team
  • Project Data
  • Non-project Data
  • Project Vs Non-project Distribution

About the client

• An American company having 100s of restaurants located globally.
• The idea was to create workflow to collect data of their teams distributed in different geographies and it was needed to integrate it through a common workflow to generate the reports for resource utilization.

Solution

• Create multiple custom tables.
• Create multiple custom work flows.
• Integrate the workflow and generate data.
• Create various reports.

Execution

• Agile Scrum (Managed through JIRA provided by client)
  • Product Backlog
  • Sprint Planning – Sprint Backlog
  • Daily Stand Up
  • Sprint Review Meeting
  • Sprint Retrospective Meeting

• Estimation
  • 5 sprint (10 weeks)
  • 12 stories (5 simple [3 days], 4 moderate [5 days], 1 complex [8 – 10 days])

• Deliverables
  • Update Sets
  • Status Reports

Sample Stories

• Create a workflow to collect data of users and store it in the custom tables.
  • Complexity: Moderate
    • Connect to external server
    • Get data in JSON format via API
    • Process the data as required and store it in custom table

• Create a main workflow which will connect other workflows in sequence and get the data.
  • Complexity: Complex
    • Integrate multiple workflows
    • Data from one workflow should be access by other workflow
    • Process data as required and store it in custom table