Attendees: Bob Mullen, Donna Johanning, Carol Larsen, Linda Koch, Cindy Martin, Pat Schwartz, Pat Morton, Laura Stoll, Art Brooks, David Saphian, Larry Westermeyer
The Rolla Point Person and Sponsor were corrected: Art Brooks and David Saphian (Point People); Randy Tucker (Sponsor). Kansas City has officially appointed Nancy Zielke as their Point Person and Larry Gates as Sponsor. The minutes were then approved.
Bob indicated that during the next week the Task Force web page will be moved to the Academic Affairs website.
Bob will meet with the financial aid directors in the near future, and provide advanced notice to the group before the meeting takes place.
Larry and Bob will be attending the Informatica seminar entitled “Building a Data Warehouse in Ninety Days” on October 2.
Vice Presidents Lehmkuhle and Caruso met briefly last week. VP Caruso repeated that the data warehouse is a high priority and that EPM can be a part of the solution, yet not the whole solution.
The IT team will include Randy Wiemer as the Lead and Ben Phelps will be the interface between the functional group and the technical team. Ben Phelps will be invited to the next meeting to be held on October 9, along with the entire technical team to be invited for lunch on that day as well. The technical team members are:
Associate Director Randy Wiemer
Principal DBA - Jim Casstevens
Principal Systems Administrator - Phil Leith
Principal DBA - Michelle McFadden
Team Lead Reporting - Ben Phelps
The revised Team Charge (revisions by David Saphian) was reviewed. The fifth charge [Begin prioritizing and monitoring the implementation of the interim strategies as identified in Appendix E of the recommendations.] will be changed to read: “Communicate the interim priorities as identified in Appendix E of the Task Force on Reporting Strategies Recommendations to functional offices and Data Custodians for implementation.”
Pyramid Implementation Plan Discussion
Pat Morton suggested that the high priority items are the following: 1) People that need tables that feed upstream and downstream systems, 2) grants, and 3) academic summary information for deans and department chairs.
In order to get some quick wins, Bob suggested the group review the charges to scope out what the overall plan will be (and place dates by each for a timeline to work toward). He stated that the group could specify a plan, implementation, and design for each charge.
Art indicated that the group needs to put a parameter on how the tables are designed; a statement is needed that allows the data warehouse to be vibrant for many years to come.
The group then identified the following parts that make up the umbrella to provide categories for the warehouse:
Donna Johanning joined the group following lunch to report on the PeopleSoft Finance Analysis of Quick Wins (Please refer to Donna’s summary handout.) Linda Koch also reported on HR quick wins during the discussion.
In order to clarify a plan for the project and some quick wins, Cindy Martin drew a draft flow diagram for the UMIR (UM Information Repository). One of the early steps is to isolate some areas and work up to some quick wins. Cindy will work on a more definitive copy of the diagram to be distributed to the group. Cindy and Bob will also do a project timeline.
A handout entitled “UMR Data Warehouse” had been distributed in the meeting packet. Art Brooks also distributed the handout “Table/Column Name Search” including a table definition.
In the future, it would be beneficial to hold a meeting on each of the four campuses. We will begin meeting every other Thursday (beginning October 9) from 9:30 – 3:00 (unless otherwise specified, meetings will be held in 321 University Hall – President’s Conference Room). On alternating Thursdays, we will have a one-hour conference call from 11:00 – 12:00.
Due to the Informatica seminar, there will not be a meeting/conference call of the group on October 2. The next meeting will be held on October 9 in the President’s Conference Room (321 University Hall). Ben Phelps will be invited to the meeting and the IT team will be invited to lunch on the 9th.
The meeting adjourned at 3:15 p.m.
Respectfully submitted,
Carol Larsen
Cost Reductions Report (PDF)