Konrad Keenan

Federal Data Scientist Consultant @IBM

Washington, DC, US

Solving USPS Business Problems with Data Driven Decisions and Analysis TDM Circuit Cutovers Problem: Legacy ATT and Verizon circuits increasing in monthly recurring costs Goal: Disconnect TDM circuits as MRCs continue to increase Solution: Create and manage site list to track TDM sites My Responsibilities: 1. Create list of active TDM sites in excel using Splunk queries and excel functions to pull site metrics into one compiled file (SPL: inputlookup, search, strcat, fields – Excel: XLOOKUP) 2. Provide financial analysis for sites that require special construction (TEM, Splunk, Pivots Tables) 3. Compile RFQs for sites that need a new vendor to disconnect legacy circuit Provide financial support and award recommendations based on vendor quotes (Nested IF AND excel functions, Pivots) 4. Consolidating remaining sites by needed action items and communicating with current vendors to update disconnect status to accurate report overall status (XLOOKUP, Pivots) Leveraged TEM (USPS Expense Management application), Splunk queries for real time invoice data pulls, excel functions (XLOOKUP, nested IF AND statements) and Pivot Tables. Outcome: USPS savings $600K in monthly recurring costs, 608 TDM sites cutover to managed solutions