Senior Manager - Global Workplace Analytics
Lead designer and developer of data infrastructure providing decision support for managing nationwide building portfolio (transactions, workplace design) and facility management. 175,000 locations. 450,000 people. Team lead and developer of SQL Server database compiling property, transaction, financial, human resource, and location presence data. Oracle. SQL Server. Power BI. ArcGIS Portal. Connected to existing decision support and map tools.Initial role: Performed financial review and signed off on every (800+) real estate transaction (sales, leases: new, renewals, contractions, expansions) in Midwest and Northeast, as well as all ATT Mobility equipment and data center locations. ATT SME for proprietary Argus-like tool applied to all transactions.Oversight of $100M+ budget, planning, forecasting and economic analysis for ATT Midwest portfolio of 450+ leased and owned properties. Developed and deployed improved MS Office data handling routines to greatly simplify and increase productivity of cost reconciliation and forecast processes.Sole ATT CRE SME to Silicon Valley start-up (now division of Siemens) software development team building IoT CRE utilization tools derived from streaming lighting controls embedded across 40 million SF at ATT.Built CRE first SharePoint sites to improve department communication, process, and training. Used as a model for CRE national site.Built CRE first analysis combining IP, private network, and building access data to analyze location and work style behavior.Built CRE first ArcGIS Portal map tool. Introduced and trained ArcGIS tools to CRE.Built only Automation Anywhere RPA script applied to any CRE process. Performed website data entry for 500 locations. 5% annual labor savings.Interface to outside software development consultant optimizing fleet locations. Amended existing contract to improve vendor accountability.