Project Name	Functional Office	Complexity	Risk	# Functional Resources	#DW Resources	#BI Resources	Estimated Cost	Expected Start	Expected End	Resource Details	Description
KFS GL Enhancements Phase I	Accounting	Medium	High	1	2	1	20,000	2015-Q4	2016-Q2	Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer	Enhance KFS GL data mart to add data elements to balance fact table and dimensions, build Award and RAFG dimensions. Develop reports and enhance Cognos package.
KFS GL Enhancements Phase II	Accounting	High	High	1	2	1	40,000	2016-Q3	2016-Q4	Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer	Enhance KFS GL data mart to include pending entries, historical tracking of chart of accounts. Develop reports and enhance Cognos package.
KFS PURAP & TEM	Accounting, Purchasing	High	High	1	2	1	72,000	2016-Q1	2016-Q3	Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer	Develop new data marts for purchase order, requisition, disbursement voucher, payment distribution processing, payment request, disbursement voucher and travel and entertainment. Develop reports and cognos package
KFS CAM Enhancements	Accounting	Medium	High	1	2	1	30,000	2016-Q2	2016-Q4	Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer	Enhance KFS data mart for capital asset management, develop reports and Cognos package.
KFS Workflow	Accounting	Medium	Medium	1	2	1	30,000	2016-Q3	2016-Q4	Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer
KFS Budget (KBM)	Budget	Medium	High	1	2	1	92,000	TBD	TBD	Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer	Develop new data mart for Kuali Budget Module. Develop reports and Cognos package.
PI Application	Accounting	High	High	1	1	2	200,000	TBD	TBD	Business Analyst, ETL Developer, Cognos (TM1) developer, report developer	Forecasting system for sponsored projects and principal investigators. Include reporting functionality as well.
Self-service Reporting Functionality & Usability Improvements	Accounting	High	High	1	0	2	TBD	TBD	TBD	Business Analyst, Cognos or application developer (depending on solution)	System/application that allows for self-service adhoc reporting functionality. Also includes tree prompts and improved report prompts and ease of saving query parameters. Includes training sessions on new and existing functionality.
Report bursting/repository	Accounting	High	High	1	0	2	TBD	2016-TBD	2016-Q2 (FYEC)	Business Analyst, Cognos and/or application developer (depending on solution)	Functionality that allows users to navigate to and view pre-generated Cognos KFS reports.
TM1 Budget Projections (Phase 1)	Budget	Medium	High	1	0	1	72,000	2016-Q1	2016-Q1 (end)	Business Analyst, Cognos Developer, Consulting (EKS&H)	Allows for budget analysis and projections based on the Statement of Revenues, Expenses and Changes in Net Position (SRECNP).

KFSDWProjectPlanning.xlsx

Browser not supported