Project | Description | |
|---|---|---|
| TalenD to Informatica Conversion | Conversion of all existing Data Warehouse ETL (Extract/Transform/Load) processes into new tool (Informatica) | |
| Kuali Financial System | Enhancement of KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements. | |
| 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. | ||
| 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. Maintain and track historical changes. | |
| 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 | |
| Student Information Systems |
General
Content
Integrations