/
KFS Decision Support Project Roadmap

KFS Decision Support Project Roadmap

Project NameFunctional OfficeComplexityRisk# Functional Resources#DW Resources#BI ResourcesEstimated CostExpected StartExpected EndResource DetailsDescription
KFS GL Enhancements Phase IAccountingMediumHigh12120,0002015-Q42016-Q2Business Analyst, Data Modeler, ETL Developer, Cognos/Report developerEnhance 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

AccountingHighHigh12140,0002016-Q32016-Q4Business Analyst, Data Modeler, ETL Developer, Cognos/Report developerEnhance KFS GL data mart to include pending entries, historical tracking of chart of accounts. Develop reports and enhance Cognos package.
KFS PURAP & TEMAccounting, PurchasingHighHigh12172,0002016-Q12016-Q3Business Analyst, Data Modeler, ETL Developer, Cognos/Report developerDevelop 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 EnhancementsAccountingMediumHigh12130,0002016-Q22016-Q4Business Analyst, Data Modeler, ETL Developer, Cognos/Report developerEnhance KFS data mart for capital asset management, develop reports and Cognos package.
KFS WorkflowAccountingMediumMedium12130,0002016-Q32016-Q4Business Analyst, Data Modeler, ETL Developer, Cognos/Report developer 
KFS Budget (KBM)BudgetMediumHigh12192,000TBDTBDBusiness Analyst, Data Modeler, ETL Developer, Cognos/Report developerDevelop new data mart for Kuali Budget Module. Develop reports and Cognos package.
PI ApplicationAccountingHighHigh112200,000TBDTBDBusiness Analyst, ETL Developer, Cognos (TM1) developer, report developerForecasting system for sponsored projects and principal investigators. Include reporting functionality as well.
Self-service Reporting Functionality & Usability ImprovementsAccountingHighHigh102TBDTBDTBDBusiness 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/repositoryAccountingHighHigh102TBD2016-TBD2016-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)BudgetMediumHigh10172,0002016-Q12016-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