Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 3 Next »

Project
Description
Start

% Completion

Current Status
Comments
TalenD to Informatica ConversionConversion of all existing Data Warehouse ETL (Extract/Transform/Load) processes into new tool (Informatica)3/1/201575%In ProgressStaging and OLTP (tables used by transactional systems) workflows are in production. ODS (operational data store) and data warehouse jobs are in testing.
KFS Historical Chart of AccountsEnhancement of KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements.9/1/20155%In Progress

Requirements gathering and functional specification development in progress.

KFS Pending EntriesNew addition to KFS data warehouse to include pending entries. Modify or develop reports based on requirements.9/1/2015 In ProgressRequirements gathering and functional specification development in progress.
KFS Purchasing/Accounts PayableNew addition to KFS data warehouse to include purchasing and accounts payable documents, attributes and transactions. Develop reports based on requirements.9/1/2015 In ProgressRequirements gathering and functional specification development in progress.

UCPath

Implement the UCPath CDW (Common Data Warehouse), including UCI customizations. Import Informatica mappings delivered from UCLA. Maintain UCI's implementation of the DDODS (data dissemination operational data store). Design SQL Views to be used by campus Tier-N systems using the Enterprise Service Bus (ESB). Develop reports based on campus and UCIMC requirements. 10%In Progress 
Re-design process for loading Administrative LDAPAs the first phase of the Internal Directory decommission, re-design the ETL process to load tables used to load employees, guests, and group accounts into the Administrative LDAP. Maintain and track historical changes. 25%On Hold 
Office of Research

Phase I of project (report remediation): Develop ODS and replace legacy reports with new reports in Cognos

Phase II of project (new reports): Develop ODS and/or dimensional data warehouse and reports based on requirements

3/2/2015 In ProgressPhase I is complete. Phase II requirements gathering is in progress.
      
  • No labels