[768] in I/T Delivery
Data Warehouse - Delivery monthly report
daemon@ATHENA.MIT.EDU (Mary Weisse)
Wed May 8 13:18:35 2002
Message-Id: <4.3.2.7.2.20020508131838.017266e8@hesiod>
Date: Wed, 08 May 2002 13:22:07 -0400
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Cc: thorne@mit.edu
In-Reply-To: <5.0.2.1.2.20020419171547.00ad64b0@po9.mit.edu>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_103118206==_.ALT"
--=====================_103118206==_.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
Team Name: Data Warehouse
Team Leader: Scott Thorne
Report Date: May 8, 2002
URL: http://web.mit.edu/warehouse/
This month's accomplishments (April 2002)
=B7 Taught Data Warehouse/Libraries class.
=B7 Taught Data Warehouse/Benefits class.
=B7 Scheduled date for production Oracle upgrade (May 11)
=B7 Loaded Rank List 2A data from HR
=B7 Fixed bug in sqlexport. Currently on test machine pending testing.
=B7 Introduced the new employee (Svletlana Lemeshov) to MIT and=
started=20
training her.
=B7 Moved graduate student payroll into production.
=B7 Continued moving Library Financial data into production.
=B7 Began data modeling session with Publications Services Bureau.
=B7 Continue to wrap up AAUDE deliverables in Phase I.
=B7 Completed the AAUDE Data Warehouse Metadata web site.
=B7 Prepared for, attended, and presented at 4 sessions during the
AAUDE conference at the University of Oregon, April 27 - May 1.
=B7 Set up records of incoming freshmen and graduate students for=
Moira.
=B7 Continue work on improving and refining Graduate Awards Reports.
=B7 Began conversations with TLO to put their data into the Data=
Warehouse.
=B7 Worked with SAP/HR team to define specs for new MIT Directory
and data flow between systems.
=B7 Assisted CAO and FSS in SAP Integration testing.
=B7 Put Student Payroll data into production (automatic monthly=
loads).
=B7 Continued work on SAP/HR.
Next Month's Plans (May, 2002)
=B7 Teach another Data Warehouse/Libraries class.
=B7 Teach two more Data Warehouse/Benefits classes.
=B7 Create a 1-day Class for novice library users.
=B7 Hand off facilities application to Mike Sherman (Facilities IT).
=B7 Finish data modeling with Publications Services Bureau.
=B7 Move sqlexport bug fix to production.
=B7 Begin hiring process (Replace Steve Turner who is transitioning
out of DW as of June 30)
=B7 Test production Oracle upgrade.
=B7 Put logon parameters, more access information, sql scripts of
sample queries, etc. on the AAUDE web site.
=B7 Begin AAUDE phase 2; analysis implementation.
=B7 Complete Federal Work Study for Student Financial Aid.
=B7 Complete unique count of students by revenue type and
revenue group for Sloan School Tuition Revenue project.
=B7 Work with MITSIS to load/update archived student records to=20
Warehouse for Alumni.
=B7 Prepare training for AAUDE at ARP/COFEE Conference in Toronto June=
2-4.
=B7 Continue to work on the analysis of the SAP/HR implementation in=
=20
the warehouse.
=B7 Continue to move Library Financial data into production.
=B7 Prepare for AAUDE Data Warehouse presentations in Oregon &=
Toronto.
=B7 Continue work on the AAUDE metadata web page.
=B7 Work with database group on ORCA upgrade.
=B7 Continue design and implementation of new HR Org hierarchy.
=B7 Continue researching reporting tools.
=B7 Begin Student Directory project analysis, design, and programming.
=B7 Begin to bring the "official" (new) department hierarchy into the=
=20
warehouse.
=B7 Train the new programmer analyst II.
--=====================_103118206==_.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<b>Team Name</b>: Data Warehouse<br>
<b>Team Leader:</b> Scott Thorne<br>
<b>Report Date:</b> May 8, 2002<br>
<b>URL:</b>
<a href=3D"http://web.mit.edu/warehouse/" eudora=3D"autourl"><font=
color=3D"#0000FF"><u>http://web.mit.edu/warehouse/</a><br>
<br>
<br>
</u></font><b>This month's accomplishments (April 2002)<br>
<br>
</b><font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Taught Data Warehouse/Libraries class.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Taught Data Warehouse/Benefits class.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Scheduled date for production Oracle upgrade (May 11)<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Loaded Rank List 2A data from HR<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Fixed bug in sqlexport. Currently on test machine pending testing.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Introduced the new employee (Svletlana Lemeshov) to MIT and started=
training her.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Moved graduate student payroll into production.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continued moving Library Financial data into production.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Began data modeling session with Publications Services Bureau.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue to wrap up AAUDE deliverables in Phase I.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Completed the AAUDE Data Warehouse Metadata web site.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Prepared for, attended, and presented at 4 sessions during the <br>
AAUDE conference at=
the University of Oregon, April 27 - May 1.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Set up records of incoming freshmen and graduate students for Moira.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue work on improving and refining Graduate Awards Reports.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Began conversations with TLO to put their data into the Data Warehouse.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Worked with SAP/HR team to define specs for new MIT Directory <br>
and data flow between=
systems. <br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Assisted CAO and FSS in SAP Integration testing.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Put Student Payroll data into production (automatic monthly loads).<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continued work on SAP/HR.<br>
<br>
<br>
<br>
<b>Next Month's Plans (May, 2002)<br>
<br>
</b><font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab><x-tab=
> </x-tab></font>Teach=
another Data Warehouse/Libraries class.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Teach two more Data Warehouse/Benefits classes.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Create a 1-day Class for novice library users.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Hand off facilities application to Mike Sherman (Facilities IT).<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Finish data modeling with Publications Services Bureau.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Move sqlexport bug fix to production.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Begin hiring process (Replace Steve Turner who is transitioning <br>
out of DW as of June=
30)<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Test production Oracle upgrade.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Put logon parameters, more access information, sql scripts of <br>
sample queries,=
etc. on the AAUDE web site.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Begin AAUDE phase 2; analysis implementation.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Complete Federal Work Study for Student Financial Aid.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Complete unique count of students by revenue type and <br>
revenue group for=
Sloan School Tuition Revenue project.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Work with MITSIS to load/update archived student records to Warehouse for=
Alumni.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Prepare training for AAUDE at ARP/COFEE Conference in Toronto June 2-4.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue to work on the analysis of the SAP/HR implementation in the=
warehouse.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue to move Library Financial data into production.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Prepare for AAUDE Data Warehouse presentations in Oregon & Toronto.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue work on the AAUDE metadata web page.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Work with database group on ORCA upgrade.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue design and implementation of new HR Org hierarchy.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Continue researching reporting tools.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Begin Student Directory project analysis, design, and programming.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Begin to bring the "official" (new) department hierarchy into the=
warehouse.<br>
<font face=3D"Symbol"=
size=3D5>=B7<x-tab> </x-tab></font=
>Train the new programmer analyst II.<br>
<br>
<br>
</html>
--=====================_103118206==_.ALT--
