Data & Reporting Services
FY2009 - Quarter 4 Report
July 6, 2009
DW:
Completed 2009 Financial Fiscal Year End maintenance - documentation, preparation, implementation and testing;
Analyzed, designed, extracted and loaded Spouse and Dependent insurance benefit data from SAP.
Analyzed, designed, extracted and loaded Purchasing data for Singapore Alliance from SAP.
Analyzed designed, extracted and loaded changes & new data as required in support of CDU (Edacca) redesign for HR/Payroll. This was done simultaneously with modifications being launched
in SAP:
Analyzed requirements and designed new tables for CAO to review combined FI and Purchase Order data.
Hosting WTW/OSE html reporting on DW -- Phase I. Set up about 40 tables in DW to backup all pertaining 2009SP data in MITSIS.
Rolled out encryption for all SSN's stored in the DWPROD, DWDEV, DWTEST servers;
Analyzed and designed views for the MDS-OME service. Included access to student term enrollment, subject enrollment with grades data.
Analyzed changes and made modifications to the call number structures in support of the Libraries ALEPH upgrade.
Analyzed changes and made modifications to EHS Inspections includes new logic for capturing DCR action taken date and modifications to EHS Training Assesment tables:
additions to WHEHSTA_PI_WORK_AREA_TABLE, EHSTA_MAS and EHS_PI_SPACE.
Re-design Payroll EDACCA access control process for generating ACL sequence numbers. Currently, there is a acl sequence number for each edacca record. Multiply the number of non-superusers with access to the 2.6 million records in Payroll Edacca Detail, there are now almost 120 million ACL records in Payroll EDACCA ACL. The number of records keeps growing. The new scheme will assign ACL sequence number to a group of EDACCA Detail records with the same personnel key, cost collector, GL account, and therefore reduce the number of sequence numbers and the number of ACL records. All work has been completed and tested. Waiting to be put into production.
Participated in PWC audit of the MIT Data Warehouse.
Built a Dashboard for Procurement
Reporting:
All Funds Statement Dashboard demo'd to users June 4th; they were given two weeks to send comments; final revisions based on comments were made and dashboard moved from pilot to production on June 30th.
Payroll Metadata completed and uploaded.
Converted approximately 40 report templates to Hyperion Interactive Reporting v9.
Roles:
Completed the development and testing of the new Roles Database administrators web interface.
Participated in 1st release of perMIT project.
Participated in PWC audit of the Roles Database.
Removing Broad Authorizations for separation.
Created 12,891 new authorizations, deleted 4,414 authorizations, and updates 407 existing authorizations.
MDS:
Completed development and rollout of phase one of the MDS Service for the Office of Minority Education.
Completion of the analysis & requirements for an MDS Honors & Award Service for Institutional Research
Began migration of MDS-Dev database and server to ENIF.
MIITID:
Upgrade of production MIT ID database server, from an old Solaris server to a new Intel Linux VM, and from Oracle 9 to Oracle 10
Participated in an internal audit of MIT ID Database.
MITBI-Raft:
Hosted MITBI-RAFT Kickoff Meeting
Formed MITBI Phase 1 steering committee & testing team
Completed base infrastructure for the project
Completed initial round of user interface/design usability testing.