William F. Slater, III

Data Center Automation Tasks and Tools

Last Updated on August 21, 2009

Task or Purpose

Tool(s)

Asset Management & Reporting

·   MS Access

·   SQL Server

·   Excel

·   Word

·   MS Outlook

Best Practices Planning and Documentation

·   Word

·   Excel

·   PowerPoint

·   MS Outlook

Budget Management  and Reporting - Operating Expense (OPEX) and Capital Expense (CAPEX)

·   Excel

·   MS Outlook

·   PowerPoint

·   Word

Capacity Planning and Reporting

·   Microsoft SCRY

·   Excel

·   MS Outlook

·   Word

·   PowerPoint

Change Management

·   GCMS (Global Change Management System)

·   MS Outlook

·   MS Project

·   Word

·   Visio

·   Excel

·   PowerPoint

Construction

·   Colo-in-a-Kit Planning – Including Bill-of-Materials Build-out planning using Excel

·   MS Project

·   Word

·   Visio

·   Excel

·   MS Outlook

Data Center Operations Documentation

·   Word

·   MS Access

·   SQL Server

·   Visio

·   Excel

·   PowerPoint

·   MS Outlook

Designing for Capacity and Growth

·   APC Rackbuilder

·   Microsoft SCRY

Disaster Recovery Planning / Business Continuity

·   Excel

·   Word

·   MS Access

·   LDRPS

Task or Purpose

Tool(s)

Facility Management

·   Building Management System (BMS)

·   Measurement of Power Consumption and Outages Using Seimens Custom-engineered equipment and software

·   Excel

·   Word

·   MS Outlook

IT Equipment Monitoring

Microsoft Operations Manager

Measurement & Sensors and Recording in the Data Center

·   Measurement of Power Consumption and Outages Using Seimens Custom-engineered equipment and software

·   APC NetBot Sensors to provide data on the temperature inside server cabinets

Project Management

·   MS Project

·   Word

·   Visio

·   Excel

·   MS Outlook

Reporting

·   Word

·   Excel

·   Access

·   PowerPoint

·   Visio

·   MS Outlook

·   Time Tracker custom application that I wrote to track the work Data Center Professionals

Record Keeping

·   Word

·   Excel

·   MS Access

Safety Planning and Management

·   Word

·   Excel

·   PowerPoint

·   MS Access

SAS 70 Compliance and Control Set Monitoring

·   Word

·   Excel

·   PowerPoint

·   MS Access

·   MS Outlook

Salvaged Equipment Management and Reporting

·   MS Access

·   Excel

·   MS Outlook

·   Word

Security Management and Reporting

·   Closed-Circuit Color TV, DVR, and Associated Video Search Software

Service Management

·   Remedy

·   UTS

·   Visio

·   Excel

·   PowerPoint

·   MS Outlook

Task or Purpose

Tool(s)

Staff Management and Reporting

·   Excel

·   Word

·   MS Outlook

·   Time Tracker custom application that I wrote to track the work Data Center Professionals

Technical Presentations

·   PowerPoint

·   Visio

·   Excel

Vendor Management and Reporting

·   MonthlyVendor Management Scorecard in Excel

·   Excel

·   Word

·   MS Access

·   MS Outlook

Warranty Management and Reporting

·   MS Access

·   Excel

·   MS Outlook

·   Word

Workflow Automation and Reporting

·   MS Access

·   Excel

·   Visio

·   Word