Current Projects
Project Name | Description | Start | % Completion | Current Status | Comments |
|---|---|---|---|---|---|
| TalenD to Informatica Conversion | Conversion of all existing Data Warehouse ETL (Extract/Transform/Load) processes into new tool (Informatica) | 3/1/2015 | 75% | In Progress | Staging 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 Accounts | Enhancement of existing KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements. | 9/1/2015 | 5% | In Progress | Requirements gathering and functional specification development in progress. |
| Decision Support OLA/SLA | Develop Operational Level and Service Level Agreements for Decision Support | In Progress | |||
| 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 LDAP | As 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. | On Hold | |||
| Office of Research Data Warehouse | 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 Progress | Phase I is complete. Phase II requirements gathering is in progress. | |
| ETL Roadmap | 3/2/2015 | In Progress | Initial discussions taking place | ||