DEVELOPING A COMPREHENSIVE DATA STRATEGY FOR PROJECT MANAGEMENT AND FINANCIAL ANALYSIS

The New York City Department of Information Technology and Telecommunications (DoITT) provides information technology (IT) support, plans and executes IT infrastructure projects, and delivers telecommunications services. Within the DoITT, the Financial Management and Administration (FMA) division oversees procurement, analysis of DoITT's operations, and budgeting-including managing DoITT's annual expenditure of $450 million. FMA is required to collect and analyze data effectively on the projects it manages; however, the DoITT collects project data through numerous separate tracking systems making the compilation and analysis of data difficult. The DoITT enlisted a Capstone team to provide a comprehensive data strategy that will allow FMA to assess a projects' performance against budgets and ensure fiscally responsible use of project resources. The team analyzed DoITT's project management policies and processes, recommended improvements to assist in the collection and analysis of data, and conducted a financial analysis of project performance to budget.