[652] in I/T Delivery
DW Status Reportt
daemon@ATHENA.MIT.EDU (Mary Weisse)
Fri Dec 7 21:42:14 2001
Message-Id: <5.0.2.1.2.20011207214446.009f6010@hesiod>
Date: Fri, 07 Dec 2001 21:45:35 -0500
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Cc: thorne@mit.edu
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_7251488==_.ALT"
--=====================_7251488==_.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: November 2001
URL: http://web.mit.edu/warehouse/
This month's accomplishments (November 2001)
=B7 Rolled out the new HR/Benefits in the warehouse, reports, user=20
training, etc.
=B7 Productionized and delivered HR/Benefits data feeds to Tufts=20
Medical and MIT Medical at completion of November open enrollment
=B7 Delivered HR/Benefits statistical reports to Benefits
=B7 Rolled out the Freshman Admissions system, user training, etc.
=B7 Implemented Sales Order system to support Tech Review, phase II
=B7 Provided Support to FSS/CAO in SAP Integration Testing
=B7 Re-designed Project WBS Hierarchy table to allow for more levels=
in=20
the hierarchy
=B7 Continued development of the AAUDE database
o Made 3 phase one tasks available to AAUDE for testing
=B7 Loaded cohort data from MITSIS to the student biographic table
=B7 Loaded (refined) student enrollment Y report data
=B7 Developed and delivered Financial Aid President's Report
=B7 Completed move of AAUDE FTP server from NT machine (mitpo4) to=
Unix=20
machine (AAUDE)
=B7 Began implementation of Legal coding for Senior Counsels Office.
=B7 Began discussion with the MIT Libraries to put library data into=
the DW
=B7 Began researching web reporting products
=B7 Created the advertisement for new DW programmer/analyst II=
position
=B7 Began DW/Bio training for the Admissions Office
Next Month's Plans (December 2001)
=B7 Roll out new Space Data
=B7 (Tentatively scheduled) Upgrade the warehouse to Oracle 8
=B7 Add new fields to Purchasing, Requisitions data
=B7 Continue Student Payroll data analysis
=B7 Put Settlement Rules data into the warehouse
=B7 Undergraduate Cohort Report
=B7 Load Financial Aid Federal Work Study data
=B7 Continue working with the Financial Aid office to give then a=20
better understanding of the DW.
=B7 Make requested changes to the Financial Aid President's Report
=B7 Put Graduate Admissions (applications and test scores) in=
production
=B7 Add directory department to personnel data
=B7 Continue working with Mike Lieberman in Facilities to move their=
=20
Excel spreadsheets into their Access database.
=B7 Train a second Facilities financial person in use of the =93Major=
=20
Construction Costs system=94 - Access Database piece.
=B7 Continue working on documentation for the Facilities financial=20
administrators and the person who will be training the project managers to=
=20
use the =93Major Construction Costs system=94, this includes both the Access=
=20
Database piece and the BrioQuery piece.
=B7 Continue working on the Sloan Revenue Sharing Project.
=B7 Continue researching web-based products.
=B7 Continue development of the AAUDE Data Warehouse.
=B7 Create the advertisement for new DW programmer/analyst position.
=B7 Begin training Admissions Office in use of BrioQuery and=
Admissions=20
data in the DW.
=B7 Meetwith the School of Engineering AO's to demo the draft report=
=20
allowing Department Heads to see all funds available to supervisors=20
connected to at least one cost object homed in their department
Issues
- Prototype of MIT Card Office (building access data) data put on=20
hold pending available DW resource.
--=====================_7251488==_.ALT
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<font size=3D3><b>Team Name</b>: Data Warehouse<br>
<b>Team Leader:</b> Scott Thorne<br>
<b>Report Date:</b> November 2001<br>
<b>URL:</b>
</font><a href=3D"http://web.mit.edu/warehouse/" eudora=3D"autourl"><font=
size=3D3 color=3D"#0000FF"><u>http://web.mit.edu/warehouse/</a><br>
<br>
<br>
</u></font><font size=3D3><b>This month's accomplishments (November=
2001)<br>
<br>
</b></font><font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Rolled out the new HR/Benefits in the warehouse, reports, user=
training, etc.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Productionized and delivered HR/Benefits data feeds to Tufts Medical=
and MIT Medical at=
<x-tab> </x-tab>completion=
of November open enrollment<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Delivered HR/Benefits statistical reports to Benefits<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Rolled out the Freshman Admissions system, user training, etc.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Implemented Sales Order system to support Tech Review, phase II<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Provided Support to FSS/CAO in SAP Integration Testing<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Re-designed Project WBS Hierarchy table to allow for more levels in=
the hierarchy<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continued development of the AAUDE database<br>
<dl>
<dl><font face=3D"Courier New, Courier">
<dd>o<x-tab> </x-tab></font>Made 3=
phase one tasks available to AAUDE for testing<br>
<br>
</dl>
</dl><font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Loaded cohort data from MITSIS to the student biographic table<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Loaded (refined) student enrollment Y report data<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Developed and delivered Financial Aid President's Report<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Completed move of AAUDE FTP server from NT machine (mitpo4) to Unix=
machine (AAUDE) <br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Began implementation of Legal coding for Senior Counsels Office.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Began discussion with the MIT Libraries to put library data into the=
DW<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Began researching web reporting products<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Created the advertisement for new DW programmer/analyst II=
position<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Began DW/Bio training for the Admissions Office<br>
<br>
<br>
<br>
<br>
<br>
<font size=3D3><b>Next Month's Plans (December 2001)<br>
<br>
</b></font><font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Roll out new Space Data<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>(Tentatively scheduled) Upgrade the warehouse to Oracle 8 <br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Add new fields to Purchasing, Requisitions data<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue Student Payroll data analysis<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Put Settlement Rules data into the warehouse<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Undergraduate Cohort Report<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Load Financial Aid Federal Work Study data<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue working with the Financial Aid office to give then a better=
understanding of the DW.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Make requested changes to the Financial Aid President's Report<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Put Graduate Admissions (applications and test scores) in=
production<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Add directory department to personnel data<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue working with Mike Lieberman in Facilities to move their=
Excel spreadsheets into their Access database.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Train a second Facilities financial person in use of the =93Major=
Construction Costs system=94 - Access Database piece.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue working on documentation for the Facilities financial=
administrators and the person who will be training the project managers to=
use the =93Major Construction Costs system=94, this includes both the=
Access Database piece and the BrioQuery piece. <br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue working on the Sloan Revenue Sharing Project.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue researching web-based products.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Continue development of the AAUDE Data Warehouse.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Create the advertisement for new DW programmer/analyst position.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Begin training Admissions Office in use of BrioQuery and Admissions=
data in the DW.<br>
<br>
<font=
face=3D"Symbol">=B7<x-tab> </x-tab=
></font>Meetwith the School of Engineering AO's to demo the draft=
report allowing Department Heads to see all funds available to supervisors=
connected to at least one cost object homed in their department<br>
<br>
<br>
<br>
<br>
<br>
<br>
<font size=3D3><b>Issues<br>
<br>
</b></font><font face=3D"Times New Roman,=
Times">-<x-tab> </x-tab></font>Pro=
totype of MIT Card Office (building access data) data put on hold pending=
available DW resource. <br>
<br>
<br>
<br>
<br>
</html>
--=====================_7251488==_.ALT--
