[843] in I/T Delivery
Re: Data Warehouse Delivery monthly report
daemon@ATHENA.MIT.EDU (Mary Weisse)
Tue Aug 6 09:14:10 2002
Message-Id: <4.3.2.7.2.20020806091249.01763b30@hesiod>
Date: Tue, 06 Aug 2002 09:15:06 -0400
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
In-Reply-To: <5.1.0.14.2.20020801221408.01c42698@po9.mit.edu>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_90492391==_.ALT"
--=====================_90492391==_.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: August 5, 2002
URL: http://web.mit.edu/warehouse/
This month's accomplishments (July 2002)
=B7 Completed Graduate Student Stipend for AAUDE Phase II.
=B7 Ready Freewilly for production -- analyze table size, use, growth,=
=20
load frequency of all
WAREUSER tables on Orca for Jim Goode (DS) to lay out better table=
=20
space in Oracle 8.
=B7 Set up production job to refresh Sloan subject enrollment data=
nightly.
=B7 Started CGI Web interface programming for the Master Department=
System.
=B7 Developed training material & Reports for Data Warehouse rollout=
of=20
the
SAP/HR/CYBORG MIT Departmental (Faculty & Staff) Telephone=
Directory.
=B7 Prepared & Delivered AAUDR training here at MIT.
=B7 Participated in the training of the Telephone Coordinators for the=
=20
rollout of
the SAP/HR/CYBORG MIT Telephone Directory Data.
=B7 Analyzed and developed a tenure ratio report for the Deans Office.
=B7 Completed end-of-fiscal-year financial processing.
=B7 Moved HR Directory loads into production.
=B7 Continued the hiring process (Replace Steve Turner who is=20
transitioning out of
DW as of June 30).
=B7 Met with Campus Police & Developed a Employee home address/home=
phone
emergency Report. Based on HR decision to print home addresses &=
=20
telephone
numbers in the directory -- this is no longer needed.
=B7 Continued working on a library detail data.
o Completed full load process
=B7 Re-wrote table statistics process.
=B7 Recompiled sqlexport on Freewilly for Oracle version 8.1.7.
Next Month's Plans (August, 2002)
=B7 AAUDE Data Warehouse -- continue development work on Phase=
=20
II and Phase III.
=B7 Prepare & Deliver AAUDE training at CalTech in August.
=B7 Continue working with ASST and DS to get a new Production DW=20
machine (Freewilly) up and running.
=B7 Work with ASST and DS to get a new make the current Orca the new=
=20
test warehouse machine.
=B7 Continue hiring process (Replace Steve Turner who is transitioning=
=20
out of DW as of June 30).
=B7 Continue CGI Web interface programming for the Master Department=
System
=B7 Complete Federal Work Study for Student Financial Aid
=B7 Continue to work on the analysis of the SAP/HR implementation in=
=20
the warehouse.
=B7 Continue design and implementation of new HR Org hierarchy.
=B7 Continue data modeling sessions with the Consortium for Functional=
=20
Glycomics.
=B7 Continued working on a library detail data.
o Design and implement incremental load process.
=B7 Begin design of the Library Subscription data.
Next Community Milestones:
=B7 Rollout of the SAP/HR/CYBORG MIT Telephone Directory Data. =
Delayed=20
until August 7, 2002
--=====================_90492391==_.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> August 5, 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 (July 2002)<br>
</b><font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Completed Graduate Student Stipend for AAUDE Phase II.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Ready Freewilly for production -- analyze table size, use, growth,=
load frequency of all <br>
<x-tab> </x-tab>WAREUSER=
tables on Orca for Jim Goode (DS) to lay out better table space in Oracle=
8.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Set up production job to refresh Sloan subject enrollment data=
nightly.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Started CGI Web interface programming for the Master Department=
System.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Developed training material & Reports for Data Warehouse rollout=
of the <br>
<x-tab> </x-tab>SAP/HR/CYBORG=
MIT Departmental (Faculty & Staff) Telephone Directory.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Prepared & Delivered AAUDR training here at MIT.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Participated in the training of the Telephone Coordinators for the=
rollout of <br>
<x-tab> </x-tab>the=
SAP/HR/CYBORG MIT Telephone Directory Data.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Analyzed and developed a tenure ratio report for the Deans=
Office.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Completed end-of-fiscal-year financial processing.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Moved HR Directory loads into production.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continued the hiring process (Replace Steve Turner who is=
transitioning out of <br>
<x-tab> </x-tab>DW as of June=
30).<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Met with Campus Police & Developed a Employee home address/home=
phone <br>
<x-tab> </x-tab>emergency=
Report. Based on HR decision to print home addresses & telephone=
<br>
<x-tab> </x-tab>numbers in=
the directory -- this is no longer needed.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continued working on a library detail data.<br>
<font face=3D"Courier New,=
Courier"><x-tab> </x-tab>o<x=
-tab> </x-tab></font>Completed full=
load process <br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Re-wrote table statistics process.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Recompiled sqlexport on Freewilly for Oracle version 8.1.7.<br>
<br>
<br>
<br>
<b>Next Month's Plans (August, 2002)<br>
</b><font=
face=3D"Symbol">=B7<x-tab> </x-tab=
><x-tab> </x-tab></font>AAUDE=
Data Warehouse -- continue development work on Phase II and Phase III.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
><x-tab> </x-tab></font>Prepa=
re & Deliver AAUDE training at CalTech in August.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue working with ASST and DS to get a new Production DW machine=
(Freewilly) up and running.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Work with ASST and DS to get a new make the current Orca the new=
test warehouse machine.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue hiring process (Replace Steve Turner who is transitioning=
out of DW as of June 30).<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue CGI Web interface programming for the Master Department=
System<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Complete Federal Work Study for Student Financial Aid<br>
<font=
face=3D"Symbol">=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">=B7<x-tab> </x-tab=
></font>Continue design and implementation of new HR Org hierarchy.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue data modeling sessions with the Consortium for Functional=
Glycomics.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continued working on a library detail data.<br>
<font face=3D"Courier New,=
Courier"><x-tab> </x-tab>o<x=
-tab> </x-tab></font>Design and=
implement incremental load process.<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Begin design of the Library Subscription data.<br>
<br>
<br>
<br>
<b>Next Community Milestones:<br>
</b><font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Rollout of the SAP/HR/CYBORG MIT Telephone Directory Data. =
Delayed until August 7, 2002<br>
<br>
<br>
</html>
--=====================_90492391==_.ALT--
