AT&T Business MERGE tool

AT&T Business MERGE tool

The MERGE tool is an open platform designed to track work across multiple organizations, provide historical reporting, and forecast future workload for optimal team sizing. Initially built on a custom SharePoint farm, it evolved into a scalable Power Apps solution, streamlining processes and setting a precedent for Power App adoption at AT&T.

Financial Impact

LIGHTRIC MOTORS

Value Justification: Reduced workforce requirements by automating processes, saving significant time previously spent on manual updates. Savings Calculation: Assuming a reduction of 10 full-time employees at $100K/year each: Annual Savings = $1M Additional Value: Enabled AT&T to sustain declining workforce and improved reporting efficiency for better strategic decision-making.

Client

AT&T's Enterprise Transition Services

Year

2015

Category

Projects

Concept

Concept

The MERGE tool was conceived out of a critical need for an open, scalable platform that could efficiently track work across various teams to completion. The goal was to provide comprehensive reporting based on historical analysis and enable accurate forecasting of future workload trends. This capability was essential for proper team sizing and resource allocation, especially in response to a decreasing employee count. The platform aimed to break down organizational silos, offer visibility into project progress, and provide actionable insights for better strategic decision-making.

The MERGE tool was conceived out of a critical need for an open, scalable platform that could efficiently track work across various teams to completion. The goal was to provide comprehensive reporting based on historical analysis and enable accurate forecasting of future workload trends. This capability was essential for proper team sizing and resource allocation, especially in response to a decreasing employee count. The platform aimed to break down organizational silos, offer visibility into project progress, and provide actionable insights for better strategic decision-making.

Concept

The MERGE tool was conceived out of a critical need for an open, scalable platform that could efficiently track work across various teams to completion. The goal was to provide comprehensive reporting based on historical analysis and enable accurate forecasting of future workload trends. This capability was essential for proper team sizing and resource allocation, especially in response to a decreasing employee count. The platform aimed to break down organizational silos, offer visibility into project progress, and provide actionable insights for better strategic decision-making.

Design

Design

The initial version of the MERGE tool was built as a highly customized SharePoint farm, offering a centralized workspace with configurable lists, workflows, and document management features. As the platform requirements evolved, the design transitioned to leverage Power Apps, enhancing flexibility and user experience. The integration of Power Automate streamlined processes, reducing manual tasks and improving efficiency. The user interface was designed with simplicity and ease of use in mind, ensuring that both technical and non-technical users could effectively engage with the tool.

The initial version of the MERGE tool was built as a highly customized SharePoint farm, offering a centralized workspace with configurable lists, workflows, and document management features. As the platform requirements evolved, the design transitioned to leverage Power Apps, enhancing flexibility and user experience. The integration of Power Automate streamlined processes, reducing manual tasks and improving efficiency. The user interface was designed with simplicity and ease of use in mind, ensuring that both technical and non-technical users could effectively engage with the tool.

Design

The initial version of the MERGE tool was built as a highly customized SharePoint farm, offering a centralized workspace with configurable lists, workflows, and document management features. As the platform requirements evolved, the design transitioned to leverage Power Apps, enhancing flexibility and user experience. The integration of Power Automate streamlined processes, reducing manual tasks and improving efficiency. The user interface was designed with simplicity and ease of use in mind, ensuring that both technical and non-technical users could effectively engage with the tool.

Development

Development

The development of MERGE involved a phased approach, starting with the core features on SharePoint and progressively moving towards a modern, low-code solution on the Microsoft Power Platform. I led the efforts to secure funding for the initial SharePoint farm, Power BI licenses, and third-party tools necessary for robust reporting and data visualization. The transition to Power Apps required extensive customization, with Power Automate workflows introduced to handle approvals, notifications, and task automation. This evolution was driven by the need for a scalable solution that could adapt to changing organizational demands.

The development of MERGE involved a phased approach, starting with the core features on SharePoint and progressively moving towards a modern, low-code solution on the Microsoft Power Platform. I led the efforts to secure funding for the initial SharePoint farm, Power BI licenses, and third-party tools necessary for robust reporting and data visualization. The transition to Power Apps required extensive customization, with Power Automate workflows introduced to handle approvals, notifications, and task automation. This evolution was driven by the need for a scalable solution that could adapt to changing organizational demands.

Development

The development of MERGE involved a phased approach, starting with the core features on SharePoint and progressively moving towards a modern, low-code solution on the Microsoft Power Platform. I led the efforts to secure funding for the initial SharePoint farm, Power BI licenses, and third-party tools necessary for robust reporting and data visualization. The transition to Power Apps required extensive customization, with Power Automate workflows introduced to handle approvals, notifications, and task automation. This evolution was driven by the need for a scalable solution that could adapt to changing organizational demands.

Implementation

Implementation

I spearheaded the justification and rollout of MERGE as the first production Power App within AT&T. This involved working closely with cross-functional teams to address critical issues, secure stakeholder buy-in, and navigate compliance and security reviews. The successful deployment set a precedent within the organization, paving the way for future Power Apps projects. The tool’s impact was immediate, reducing manual effort, improving data accuracy, and providing comprehensive analytics through integrated Power BI dashboards. The implementation of MERGE has become a template for other teams seeking rapid, scalable solutions for tracking, reporting, and automation.

I spearheaded the justification and rollout of MERGE as the first production Power App within AT&T. This involved working closely with cross-functional teams to address critical issues, secure stakeholder buy-in, and navigate compliance and security reviews. The successful deployment set a precedent within the organization, paving the way for future Power Apps projects. The tool’s impact was immediate, reducing manual effort, improving data accuracy, and providing comprehensive analytics through integrated Power BI dashboards. The implementation of MERGE has become a template for other teams seeking rapid, scalable solutions for tracking, reporting, and automation.

Implementation

I spearheaded the justification and rollout of MERGE as the first production Power App within AT&T. This involved working closely with cross-functional teams to address critical issues, secure stakeholder buy-in, and navigate compliance and security reviews. The successful deployment set a precedent within the organization, paving the way for future Power Apps projects. The tool’s impact was immediate, reducing manual effort, improving data accuracy, and providing comprehensive analytics through integrated Power BI dashboards. The implementation of MERGE has become a template for other teams seeking rapid, scalable solutions for tracking, reporting, and automation.

David Baird

David Baird

David Baird

David Baird

©2024 All Rights Reserved

GO BACK TO TOP

©2024 All Rights Reserved

GO BACK TO TOP

©2024 All Rights Reserved

GO BACK TO TOP

©2024 All Rights Reserved

GO BACK TO TOP