Data Lake Pilot

Analysis and Reporting from Multiple Data Sources

Provides a unified architecture for data analysis and reporting.

Description

The project reduces manual data entry and provides academic affairs and human resources with normalized, standardized and consistent data and reports. Provides data for San Diego State University’s collective bargaining, resources and faculty personnel management needs. 

Goals / Deliverables

  1. Develop a comprehensive mapping of data elements from FDB77, FIN, OnBase and PeopleSoft HR and the Chancellor's Office HR data warehouse focused on faculty personnel and hiring. This mapping should identify overlap and gap between each system to define opportunities for creating one system of record.
  2. A data dictionary of all appropriate elements. In the process pilot iData Data Cookbook as a common data dictionary tool.
  3. A prioritized inventory of required Tableau reports for the management of collective bargaining obligations and faculty management by SDSU's Academic Affairs Resource Management and Faculty Advancement as well as Human Resources.
  4. Automated processes with appropriate audit controls to move data between OnBase and other required reporting systems including PeopleSoft HR.
  5. Eliminate manual data entry in preference for the use of APIs and other machine interactions to support data movement across systems.
  6. Technical cloud‐based architecture and appropriate software tools, designed in alignment with the CSU Chancellor's Office data lake (AWS RedShift), to create a system of record for required reporting for SDSU and CSU system.
  7. Elimination and retirement of legacy systems.

Team Members

Name Area
   
Alex Delino IT Division - IT Infrastructure and Operations
Cyndie Winrow IT Division - Administrative Information Systems
Pavan Chinthapanti IT Division - Administrative Information Systems
Pavani Katam IT Division - Administrative Information Systems
Jeff Henson IT Division - Administrative Information Systems
Mary Anne Kremicki Academic Affairs Resource Management
Sem Tran Academic Affairs Resource Management
Jeanne Stronach Analytic Studies & Institutional Research
Alex Wilson Analytic Studies & Institutional Research
Cris Manlangit - Consultant Analytic Studies & Institutional Research
Devon Cauteray Center for Human Resources
Heidi Poon Center for Human Resources
Shahriyar Dadkhah Center for Human Resources
Marcus Jeffers Data Architecture
Jonathan Santos Data Architecture
Tommy Duong Data Architecture
Kyle Krick Data Architecture

RACI

data lake raci

Timeline

Data Lake Timeline

Updates

Loading Feed