[828] in I/T Delivery
Data Warehouse - June Delivery report
daemon@ATHENA.MIT.EDU (Mary Weisse)
Mon Jul 15 14:52:56 2002
Message-Id: <4.3.2.7.2.20020715144912.01760078@hesiod>
Date: Mon, 15 Jul 2002 14:53:44 -0400
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_22696926==_.ALT"
--=====================_22696926==_.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: July 15, 2002
URL: http://web.mit.edu/warehouse/
This month's accomplishments (June 2002)
=B7 AAUDE Data Warehouse - Completed the outstanding tasks in Phase I:=
IPEDS=20
Fall Enrollment and
IPEDS Fall Staff (second part: with salary range).
=B7 AAUDE Data Warehouse - Reviewed Phase III tasks -- no data files. Sent=
=20
out a detailed input data file
layout (Graduate Student Stipend) to caretaker.
=B7 Gave a Data Warehouse/AAUDE class at the AIR Conference in Toronto,=20
Canada June 3 - June 5.
=B7 AAUDE Data Warehouse Demo to ITLT.
=B7 Designed, implemented, and tested all the new Graduate Award web=20
reports. These were a replaced
the existing reports.
=B7 Reviewed and analyzed the STUDENT MONTHLY PAYROLL DETAIL with Maria=20
Fernandez. May need to
use this table to get "tuition paid" in one of the graduate award=
=20
reports.
=B7 Turnover of Steve Turners DW work to other staff members:
o Reviewed the CGI programs for all the Data Warehouse web=
functions
o Re-compiled the C programs on Freewilly.
=B7 Started initial work (learning - Perl CGI programming on blue-goose)=
for=20
the Master Department project
with Jim Repa.
=B7 Began the hiring process (Replace Steve Turner who is transitioning out=
=20
of DW as of June 30).
=B7 Prepare training material for Data Warehouse rollout of the=20
SAP/HR/CYBORG MIT Departmental
(Faculty & Staff) Telephone Directory.
=B7 Met with Price Waterhouse Data Warehouse audit.
=B7 Delivered the facilities application.
=B7 Gave a demo of MSQuery accessing the Data Warehouse to CAO.
=B7 Completed data design, extract and load procedures, created=20
pre-conversion scripts and post-batch
scripts, and tested Library Item Detail and associated dimension=20
tables.
=B7 Continue to train last hire
Next Month's Plans (July, 2002)
=B7 AAUDE Data Warehouse -- continue development work on Phase II and=
=20
Phase III.
=B7 Prepare for AAUDE training at CalTech in August.
=B7 Prepare & Deliver AAUDR training here at MIT.
=B7 Finalize Graduate Admissions. Clean up the problems that caused by=20
changes SSIT made on
MITSIS. Show Bette Johnson the tables, queries, etc.
=B7 Continue working with ASST and DS to get a new Production DW machine=20
(Freewilly) up and running.
=B7 Work with ASST and DS to get a new make the current Orca the new test=
=20
warehouse machine.
=B7 Continue hiring process (Replace Steve Turner who is transitioning out=
=20
of DW as of June 30).
=B7 Continue working with Jim Repa on Master Department Hierarchy at MIT.
=B7 Complete Federal Work Study for Student Financial Aid
=B7 Continue to work on the analysis of the SAP/HR implementation in the=20
warehouse.
=B7 Continue design and implementation of new HR Org hierarchy.
=B7 Continue researching reporting tools.
=B7 Continue data modeling sessions with the Consortium for Functional=20
Glycomics.
=B7 Participate in the training of the Telephone Coordinators for the=20
rollout of the SAP/HR/CYBORG
MIT Telephone Directory Data.
=B7 Analyze and build a tenure ratio report for the Deans Office.
=B7 Productionize Library Item Detail and associated dimension tables.
=B7 Work on end-of-fiscal year process
=B7 Move HR Directory loads into production
=B7 Continue to train last hire
Next Community Milestones:
=B7 Rollout of the SAP/HR/CYBORG MIT Telephone Directory Data. July 1,=
2002
--=====================_22696926==_.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> July 15, 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 (June 2002)<br>
</b><font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse - Completed=
the outstanding tasks in Phase I: IPEDS Fall Enrollment and <br>
<x-tab> </x-tab>IPEDS Fall=
Staff (second part: with salary range).<br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse - Reviewed Phase=
III tasks -- no data files. Sent out a detailed input data file <br>
<x-tab> </x-tab>layout =
(Graduate Student Stipend) to caretaker. <br>
<font face=3D"Symbol">=B7 </font>Gave a Data Warehouse/AAUDE class at=
the AIR Conference in Toronto, Canada June 3 - June 5. <br>
<font face=3D"Symbol">=B7 </font>AAUDE Data Warehouse Demo to=
ITLT.<br>
<font face=3D"Symbol">=B7 </font>Designed, implemented, and tested all=
the new Graduate Award web reports. These were a replaced<br>
<x-tab> </x-tab>the existing=
reports.<br>
<font face=3D"Symbol">=B7 </font>Reviewed and analyzed the STUDENT=
MONTHLY PAYROLL DETAIL with Maria Fernandez. May need to <br>
<x-tab> </x-tab>use this=
table to get "tuition paid" in one of the graduate award reports.=
<br>
<font face=3D"Symbol">=B7 </font>Turnover of Steve Turners DW work to=
other staff members:<br>
<font face=3D"Courier New,=
Courier"><x-tab> </x-tab>o&n=
bsp; </font>Reviewed the CGI programs for all the Data Warehouse web=
functions<br>
<font face=3D"Courier New,=
Courier"><x-tab> </x-tab>o&n=
bsp; </font>Re-compiled the C programs on Freewilly.<br>
<font face=3D"Symbol">=B7 </font>Started initial work (learning - Perl=
CGI programming on blue-goose) for the Master Department project <br>
<x-tab> </x-tab>with Jim=
Repa. <br>
<font face=3D"Symbol">=B7 </font>Began the hiring process (Replace=
Steve Turner who is transitioning out of DW as of June 30).<br>
<font face=3D"Symbol">=B7 </font>Prepare training material for Data=
Warehouse rollout of the SAP/HR/CYBORG MIT Departmental <br>
<x-tab> </x-tab>(Faculty=
& Staff) Telephone Directory.<br>
<font face=3D"Symbol">=B7 </font>Met with Price Waterhouse Data=
Warehouse audit.<br>
<font face=3D"Symbol">=B7 </font>Delivered the facilities=
application.<br>
<font face=3D"Symbol">=B7 </font>Gave a demo of MSQuery accessing the=
Data Warehouse to CAO. <br>
<font face=3D"Symbol">=B7 </font>Completed data design, extract and=
load procedures, created pre-conversion scripts and post-batch <br>
<x-tab> </x-tab>scripts, and=
tested Library Item Detail and associated dimension tables.<br>
<font face=3D"Symbol">=B7 </font>Continue to train last hire<br>
<br>
<br>
<b>Next Month's Plans (July, 2002)<br>
</b><font=
face=3D"Symbol">=B7<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=
></font>Prepare for AAUDE training at CalTech in August.<br>
<font face=3D"Symbol">=B7 </font>Prepare & Deliver AAUDR=
training here at MIT.<br>
<font face=3D"Symbol">=B7 </font>Finalize Graduate Admissions. Clean=
up the problems that caused by changes SSIT made on<br>
<x-tab> </x-tab>MITSIS. Show=
Bette Johnson the tables, queries, etc. <br>
<font face=3D"Symbol">=B7 </font>Continue working with ASST and DS to=
get a new Production DW machine (Freewilly) up and running.<br>
<font face=3D"Symbol">=B7 </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 </font>Continue hiring process (Replace=
Steve Turner who is transitioning out of DW as of June 30).<br>
<font face=3D"Symbol">=B7 </font>Continue working with Jim Repa on=
Master Department Hierarchy at MIT.<br>
<font face=3D"Symbol">=B7 </font>Complete Federal Work Study for=
Student Financial Aid<br>
<font face=3D"Symbol">=B7 </font>Continue to work on the analysis of=
the SAP/HR implementation in the warehouse.<br>
<font face=3D"Symbol">=B7 </font>Continue design and implementation of=
new HR Org hierarchy.<br>
<font face=3D"Symbol">=B7 </font>Continue researching reporting=
tools.<br>
<font face=3D"Symbol">=B7 </font>Continue data modeling sessions with=
the Consortium for Functional Glycomics.<br>
<font face=3D"Symbol">=B7 </font>Participate in the training of the=
Telephone Coordinators for the rollout of the SAP/HR/CYBORG <br>
<x-tab> </x-tab>MIT Telephone=
Directory Data.<br>
<font face=3D"Symbol">=B7 </font>Analyze and build a tenure ratio=
report for the Deans Office.<br>
<font face=3D"Symbol">=B7 </font>Productionize Library Item Detail and=
associated dimension tables.<br>
<font face=3D"Symbol">=B7 </font>Work on end-of-fiscal year=
process<br>
<font face=3D"Symbol">=B7 </font>Move HR Directory loads into=
production<br>
<font face=3D"Symbol">=B7 </font>Continue to train last hire<br>
<br>
<br>
<br>
<br>
<br>
<b>Next Community Milestones:<br>
</b><font face=3D"Symbol">=B7 </font>Rollout of the SAP/HR/CYBORG MIT=
Telephone Directory Data. July 1, 2002<br>
<br>
<br>
</html>
--=====================_22696926==_.ALT--
