Summary
Overview
Work History
Education
Skills
Timeline
Generic

Robert E Mann III

Arvada,CO

Summary

Adept in leveraging Power BI and problem-solving skills, I significantly enhanced data accuracy and operational efficiency across roles, notably reducing repair ticket completion times by 39.6% at LUMEN TECHNOLOGIES. Recognized for excellence with 7 RAVE awards at ARDENT MILLS, my track record showcases a blend of technical prowess and exceptional service delivery. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

21
21
years of professional experience

Work History

IT Data Analyst

ARDENT MILLS (Contract)
05.2021 - 11.2024

· Awarded 7 RAVE peer to peer awards for exemplifying Living Ardent Mills Core Values

· Checked and Validated the accuracy of all 11315 Accounts Payable Vendor and 15050 Account Receivable Customer records during Ardent Mills Enterprise Resource Planning transition from Great Plains to Microsoft Dynamics 365

· Processed with an Accuracy Rate of 99% 9700 Customer, MRO Parts, and Vendor user submitted requests involving over 25,000 records through email, instant message, Service Now tickets, and SharePoint

· Provided effective solutions using MS Excel, MS Teams, and Power BI for diagnosed weaknesses to improve accuracy and prevent fraud by becoming an SME on Ardent Mills Customer, MRO Parts, and Vendor processes on building, submitting and validating records.

· Improved the accuracy of Ardent Mills Master Data by proactively completing, updating, and validating over 36,000 records from Customer, MRO Parts and Vendor sections in Dynamics 365 that had been incomplete or unfinished from previous file and data integrations

Forecaster /Business Data Analyst

LUMEN TECHNOLOGIES / CENTURYLINK (Contract)
01.2019 - 04.2021

· Decreased by 16.7% YoY combined install and repair average time to completion percentage in Arkansas from 2019 to 2020 using varying data visualizations to leadership & peers to provide visibility on install & repair backlog. This allowed field and capacity planning teams to identify resource shortage and see near real time progress for service areas & techs

· Dropped by 39.6% repair ticket average time to completion over 6 months for Virginia from 67.6 hours in August 2020 to 40.8 hours in January 2021 through effective ownership of capacity planning through concise reporting and use of overtime recommendations, closing of capacity streams, and effective relocations of available resources

· Surpassed team goal of cLink chat AHT of 8:00 minutes in resolving over 2,000 issues with AHT of only 6:56 minutes

· Improved by 24% YoY repair ticket average time to completion in Arkansas and Mississippi of 62.2 hours in 2019 to 47.1 hours in 2020 using accurate reporting, strategic relocations and recommendations for overtime and weekend techs

Financial Analyst

SPECTRUM (Contract)
07.2018 - 10.2018

· Finished testing and migrating over 12,000 records from old SharePoint version to redesigned and more efficient 2016 version

· Restructured monthly $12M General Ledger reconciliation report to provide insight more effectively by company processes and departments

Billing Systems Analyst

CENTURYLINK
05.2016 - 04.2018

· Acquired Trust Level clearance in GSA contracting

· Reached monthly accuracy rate of 99.99% for $1.6M invoice that covered federal government internet services nationwide

Operations Analyst

DISH NETWORK
04.2004 - 05.2016

· Monthly Platinum Award winner for May, June, Sep, Oct 2011 based on Productivity and Quality Assurance scores among peers

· Maintained a daily multi-million dollar spreadsheet that reconciled customer payments through all CSG revenue streams with banks and third-party vendors documenting all variances

· Supplied management with payment reporting briefings created with MS Excel and MS PowerPoint which showed financial forecasting, modeling, and trending

· Led $10M monthly chargeback reconciliation process between billing system, bank and vendors for month end ledger closing

· Enhanced efficiency by using one MS Access database to combine the functionality of 16 daily team updated MS Excel reports

Education

Certificate - Google Data Analytics

Coursera
Google
01-2023

Certificate - Excel Skills For Data Analytics And Visualization

Coursera
Online
05-2022

Certificate - Data Visualization With Tableau

Coursera
Davis, CA
06-2021

Certificate - Fundamentals of Visualization With Tableau

Coursera
05-2021

Certificate - Microsoft Power BI Business Intelligence

Udemy
04-2021

Bachelor of Arts - History

University of Northern Colorado
Greeley, CO
06-2001

Skills

    SharePoint

  • Customer Service
  • Problem-Solving
  • Power BI
  • Tableau
  • Python

Timeline

IT Data Analyst

ARDENT MILLS (Contract)
05.2021 - 11.2024

Forecaster /Business Data Analyst

LUMEN TECHNOLOGIES / CENTURYLINK (Contract)
01.2019 - 04.2021

Financial Analyst

SPECTRUM (Contract)
07.2018 - 10.2018

Billing Systems Analyst

CENTURYLINK
05.2016 - 04.2018

Operations Analyst

DISH NETWORK
04.2004 - 05.2016

Certificate - Google Data Analytics

Coursera

Certificate - Excel Skills For Data Analytics And Visualization

Coursera

Certificate - Data Visualization With Tableau

Coursera

Certificate - Fundamentals of Visualization With Tableau

Coursera

Certificate - Microsoft Power BI Business Intelligence

Udemy

Bachelor of Arts - History

University of Northern Colorado
Robert E Mann III