...
DRS
...
continues
...
to
...
participate
...
in
...
and
...
act
...
as
...
a
...
hub
...
for
...
data
...
issues
...
in
...
support
...
of
...
various
...
Institute/Enterprise
...
projects.
...
Major
...
projects
...
for
...
DRS
...
are
...
RAFT
...
(MITBI
...
– Reporting
...
&
...
Forecasting
...
Tool),
...
the
...
MIT
...
and
...
AAUDE
...
Data
...
Warehouses,
...
Managed
...
Data
...
Services,
...
MITID
...
Database,
...
Roles
...
and
...
Reporting
...
&
...
Consulting
...
Services.
...
A
...
key
...
member
...
of
...
our
...
team,
...
Jim
...
Repa
...
officially
...
retired
...
on
...
June
...
30,
...
2010.
...
RAFT
...
(MITBI
...
– Reporting
...
&
...
Forecasting
...
Tool)
...
DRS
...
has
...
been
...
working
...
closely
...
with
...
representatives
...
from
...
16
...
Departments,
...
Labs
...
and
...
Centers
...
and
...
other
...
groups
...
across
...
IS&T
...
(CSS:
...
Usability
...
&
...
Accessibility
...
and
...
Documentation
...
&
...
Training,
...
and
...
OIS:
...
Server
...
Operations
...
and
...
Database
...
Services).
...
During Q4
...
Phase
...
II
...
requirements
...
gathering,
...
review
...
and
...
prioritization
...
was
...
completed
...
and
...
approved
...
by
...
the
...
steering
...
committee.
...
Requirements
...
are
...
currently
...
waiting
...
approval
...
from
...
our
...
sponsor.,
...
The
...
initial
...
forecasting
...
design
...
was
...
completed
...
and
...
the
...
development
...
process
...
has
...
begun.
...
DW
...
Reporting
...
Tools
...
Project
...
This
...
project
...
was
...
started
...
last
...
quarter.
...
The
...
focus
...
is
...
to
...
select
...
a
...
easy
...
to
...
use
...
reporting
...
tool
...
to
...
replace
...
BrioQuery.
...
30 members
...
o
...
the
...
community
...
sat
...
through
...
3
...
vendor
...
presentations
...
and
...
participated
...
in
...
3
...
hands-on
...
workshops.
...
We are
...
currently
...
in
...
the
...
final
...
review
...
and
...
recommendation
...
phase.
...
We
...
expect
...
this
...
work
...
to
...
be
...
complete
...
and
...
a
...
recommendation
...
made
...
to
...
senior
...
management
...
in
...
FY11
...
Q1.
...
MIT
...
Data
...
Warehouse
...
The
...
Data
...
Warehouse
...
team
...
has
...
made
...
many
...
changes
...
in
...
support
...
of
...
the
...
enterprise
...
systems
...
during
...
Q4.
...
We participated in and completed modifications required to extract and load processes In support of the SAP Hardware upgrade project. Including modifications to over 100 SAP extracts to resolve Unicode conversion issues.
In support of HR/Payroll data work included the addition of Accounts Payable addition of ACH garnishments and the implementation of access control for historical payroll edacca data, which will be rolled out to the community in July,
In support of VF Office data work included the design and implementation of travel data from the Concur System. This data is currently in user acceptance.
In support of Student systems work included expanding the data feed program to feed student degree data to National Student Clearinghouse for the Degree Verify project to meet new requirements from the Registrar’s Office and completed the design and implementation of a new data model to keep track of outside Interests and activities of students who receive grants from MIT. Students are now required to fill out Online form about their interests and activities as well as to check a consent flag to share the info with Resource Development (i.e., the donors) yearly before they can receive the grant money. Implemented the tables, data models, and processes. This is currently in user test and will be rolled out to the community on August 1st.
Managed Data Services
MDS- OTI. Completed part 1: database configuration and design for the Online Textbook Initiative project.
MDS-OME: Completed database backend development work in support of DCAD’s Phase II development project for OME.
MDS-Abandoned Property: Completed the design, development and implementation of an MDS Abandoned Property application and database to make it easier for the VPF Office to comply with new state regulations. This is currently in user acceptance. Also, began the design of historical snapshots.
Worked with Server Operations to migrate two MDS databases and servers (development and production) onto one MDS server with two operating system environments (dev and prod) and two database instances (mdsd and mdsp).
Roles
11,933 authorizations added
66 Funds Centers added
1 Roles UI Individual trainings
1 Department created in SAP and Roles
PerMIT project was shut down. Completed the Roles design for the Math Dept blogs project. Built a data feed program on the test Roles Database to build a hierarchy of academic courses and subjects from the Data Warehouse. This Subject hierarchy will be a prerequisite for Authorizations for the Math blogs project and also a planned online grading project