10/1/2017 – 10/31/2017
Completed
- Automation of the ETL process for Legacy data the ones which are complete.
- Student Mapping Complete.
- Additional columns added to AR Bliss Tech specifications.
- Re-established the access to SISSHARE registrar database.
- SZRADAP Extension script sent for review with Tom Braun.
In Progress
- Summer Archive tables created in ODS.
- ETL development for legacy summer tables.
- Working with mapping of legacy registrar data into Composite table (STUDENT_COURSE) columns.
- DCE Course Information - I&C SCI X426.53 Data Structures, Data Mining and Big Data with Python class began.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
9/1/2017 – 09/29/2017
Completed
- Summer ETL Access established.
- Grad Aid Staging development put on hold as the source data development is in progress.
- Grad Aid Change to column names completed.
- Automation of the ETL process for Legacy data the ones which are complete.
In Progress
- Testing of ETL connectivity for summer Database.
- Extension on a table (SZRADAP)from Base line into ODS.
- Student Mapping.
- Time to degree report.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
6/16/2017 – 08/31/2017
Completed
- Issue on ODI Application resolved.
- Grad Aid Staging development.
- Grad Aid (PPS Data & Quarterly Info) composite completed.
- Individual Access to Summer Database.
- UG Admission Legacy data.
- Financial Aid Legacy data.
- Grad Division Legacy data for tables requested by Rachel.
- Ethnicity Data.
- KFS Data.
- Soap UI Installed.
- KSAMS Webservice mapping complete.
- AR Bliss Tech specs.
- Automation of the ETL process for Legacy data the ones which are complete.
In Progress
- Establish the ETL connectivity for Summer database.
- Testing for KSAMS Webservice.
- ODI Work on Composite tables for remaining Grad Aid.
- Extension on a table (SZRADAP)from Base line into ODS.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
5/19/2017 – 06/15/2017
Completed
...