DATA WAREHOUSE
STUDENT:
· Review Functional Specs and Technical Documentation prepared by SAIS-SSIT for double majors, ethnicity, and WTW projects.
· Analyze and design data, build data extract, translations and load processes, update existing and create new metadata, and create new and modify existing tables and views in support of the new student ethnicity policies and data requirements.
· Analyze and design data, build data extract, translations and load processes, update existing and create new metadata, and create new and modify existing tables and views in support of the new student double major phase II requirements.
· Enhance faculty profile by CIP data (add FTE counts and related data).
· Change the detail level of Student Degree Access Control table to username and mit_id (ie. all the individual students the user has been granted access to see).
· Create a new error checking routine to check to see if STUDENTFULL's BAD is due to no data file sent from MITSIS.
· Analyze and design data, build data extract, translations and load processes for student grade data.
· Analyze and design data, build data extract, translations and load processes for adding Undergraduate Time to Degree data.
FINANCE
· Create problem-checking script reporting Purchase orders with non-standard currencies: SING not SGD and others not USD.
· Create new problem checking script to report to CAO closed (Term code '3') cost objects with balance not equal to zero.
BENEFITS:
· Analyze and design data, build data extract, translations and load processes, update existing and create new metadata, and create new and modify existing tables and views in support of Benefits Eligibility Historical data.
PAYROLL
· Work Lisa Allen in CAO to fix discrepancy/problems in Payroll Fiscal Period Salary Distribution data.
· Create a new problem checking script identify people not in PAYROLL_PERSON but with payroll results, postings, or distributions.
· Write a problem checking script that checks for Payroll super users who also exist in other Payroll access control tables.
· Implement the revised/new process of loading Payroll EDACCA access control.
· Modify the Payroll Edacca load script to capture the "real" cost objects used in EDACCA.
TRAINING & EVENTS:
· Analyze and design data, build data extract, translations and load processes, create metadata, and create new tables and views for Training and Event Qualifications.
· Analyze and design data, build data extract, translations and load processes, create metadata, and create new tables and views for Training and Event Registration and Wait List (current and historical).
· Analyze and design data, build data extract, translations and load processes, create metadata, and create new tables and views for the Training and Events Catalog. GENERAL
· Automate assignment and revoking of additional roles data (EHS Training)
· Continue to enhance end user metadata (add OSP/COEUS Data Models, Payroll user metadata).
· Create, test, and move to production new problem-checking scripts to identify pernrs in dacca or payroll results but not in PAYROLL_PERSON table.
· Create, test, and schedule a data feed for MIT Mobile which contains MIT IDs and Kerberos data.
· Add a process to delete left-over card records in whcard_picture_text for MIT Card Data.
· Write Test Cases (for QA) for all Data Warehouse Feeds and Extracts REPORTING
· Review and modify existing report templates to make use of the new ethnicity data.
· Review and modify existing report templates to make use of the new Double Major data.
· Redesign the Financial DTR Template.
· Create OSHA Headcount/EFT report template.
· Revise EHS Inspections report templates to reflect changes being made in how they enter and classify inspections in SAP.
· Research, install, and begin evaluating new web-based reporting tools (Jasper Reports, Pentaho, and Oracle Business Intelligence Enterprise Edition (OBIEE).
· Continue working with Software Release Team to finalize new requirements for Oracle 11 Client Installer.
· Work with AMIT and Oracle to resolve issues with Kerberos / Radius authentication with Hyperion Intelligence.
· Create a report template for Jean Dzgeneleski (support for Asst Deans) to identify people paid 100% from research accounts in the last two fiscal years.
· Work with Jean Dzgeneleski to document the Assistant Deans reporting requirements.
· Create a report template for Headcount and EFT comparison of positions for Budget, Finance and Treasury office.
· Create a report template detailing maintenance contracts and repairs across the Institute.
· Create a IPEDS report template for HR.
· Work with the Hass office to create report template specs to meet their HASS minor data needs.
· Create a TNSC Reporting Package for IS&T. AAUDE· Backload IPEDS Completion data for 2003 and 2004.
· Create a mapping of AAMC Institutions to AAUDE Institutions. MITBIMITBI-CSAIL· Completed requirements gathering.
· Decision to stop project – current version of Microsoft Performance Point does not meet CSAIL’s current requirements. MITBI-IS&T· Completed requirements gathering.
· Decision to stop project – based on Microsoft’s announcement to stop development of the Performance Point product. MITBI-ISN· Complete phase I – Requirements Gathering
· Present status and future plans (cost, resources, and timeline) for MITBI projects (MITBI-CSAIL, MITBI-IS&T Finance, MITBI-ISN) to ASPCC. ROLES RolesDB· Upgrade production and databases to Oracle 10g
· Add enhancements to the authorizations table triggers (stored procedures) that record all authorization inserts, updates, and deletes in the table AUTH_AUDIT. This includes the end-user who made the change as well as the server user. Roles User Interface· Fix known bugs and issues in test and move to production in preparation for Usability testing.
· Complete Usability Test
· Analyze results of Usability Test and prepare a plan to fix issues/bugs found. MDS-OME· Complete design and build of the managed data service test/development and production databases.
· Add appropriate indexes and generate statistics to provide the DCAD Filemaker application with better performance.
· Turn the Oracle audit on for testing. Analyze and review results.
· Build trigger (stored procedures) to update OME_STUDENT_ACL dynamically to keep track of the students in each Program Coordinator's program.
· Set up a Change Password web application/process for OME users to change/setup their Oracle passwords as the Filemaker ODBC drivers do not work with Radius.
· Generate and maintain metadata in support of the data extract, load and verification processes.
· Design and implement a production process to grant Oracle roles in OME/MDS based on authorizations set up in Roles DB.
· Design and create OME access control tables.
· Analyze and design data, build data extract, translations and load processes, update existing and create new metadata, and create new and modify existing tables and views in support of Interphase Student data requirements.
· Add OME-maintained emergency data. Set up field level access (including update) appropriately.
· Analyze, design, and implement Interphase Cluster functionality for non-academic groups/clusters and subgroups. PERMIT· Continue documenting current Roles functionality, stored procedure/triggers, scripts, etc.
· Reverse engineer the RolesDB schema to be used in the creation of a new mySQL database for permit.
· Work with perMIT Team to design and develop an open source version of Roles.