TIMELINE OVERVIEW

Brown & Brown
Insurance Projects

Building Lasting Relationships

Create an API connection between Smartsheet to Azure DevOps
Learn about Smartsheet and DevOps

Meet with diffident teams to learn how Smartsheet and DevOps are being leveraged at B&B

Support the Enterprise Risk Mgmt. (ERM) Project by setting up template in DevOps to execute UAT (manual process)

Research the capabilities of creating an API from Smartsheet to DevOps

Develop API between Smartsheet and DevOps

Collaborate with IT PMO PMs to develop a repeatable automated process for the execution of UAT in DevOps

Document the process to perform UAT testing in DevOps using a repeatable automated process

Train IT PMO on new process
Improve the existing manual process for UAT with a repeatable automated process in DevOps
IT PMO – Lucy Gvetadze, Tanja McClain, Franco Barreto and Tim Anthony

Azure Architect – Ravi Pinnamaneni

Corporate Applications – David Goedecke, Matt Rakestraw

Problem Statement:

Project Managers are currently manually inputting each work item into Azure DevOps, which is slowing down User Acceptance testing times

Solution:

Create an automation that grabs rows from Smartsheet and converts them into Azure DevOps Work Items

Grab Smartsheet Data and Convert it to a Work Item in Azure DevOps

Feature 01

Create an Azure DevOps Project from a Smartsheet

Feature 04

Use the information of the work item state to create a project review assessment

Feature 03

Import work items from azure devops to Smartsheet

Feature 02