Data Warehouse/Business Intelligence

This project will move The University of Akron to a more structured data and strategic decision support system.  Currently, the data exists in the transactional system where there is no correlation among various information sources.  This project will provide organization and correlation of the disparate data to enhance the strategic and tactical decision capabilities at all levels of the University.

Currently, the software has been purchased and is being installed. The review of the implementation partners’ bids is in process. 

The timeline of the project’s three phase approach to proof of concept is expected to be complete by the second quarter 2012.

Phase I: Implementation and Proof of Concept (Feb. 20 - June 22, 2012)

  • Install two data marts from each of the three EMP pillars along with selected reports and dashboards
  • Following delivered mappings

Phase II: Research Reporting & Analytics (June 11 - Nov. 27, 2012)

  • Integrate key data elements to facilitate research reporting
  • Pulling data from multiple data marts (within EPMs and perhaps outside of delivered EPMs)
  • Provide NSF & “Composite” Expenditures Reports

Phase III: Define Additional Data Marts/Subject Areas/Reports & Dashboards for Implementation (Nov. 21 - Dec. 24)

Contacts

Links

 

Project Team

Sponsors

  • Jim Sage, VP Info Technology
  • Rex Ramsier, Vice-Provost, Academic Operations

Steering Committee

  • Jim Sage, VP Info Technology
  • David Cummins, VP Finance and Administration/CFO
  • Rex Ramsier, Vice-Provost, Academic Operations
  • Becky Hoover, VP Talent Development

Project Manager

  • Sabrina Andrew, Director, Institutional Research
  • Susan Rzyczycki, Asst VP, Applications Development
  • Oracle PM, TBD

UA Technical Lead

  • Matt Petras, Application Services Technical Lead

UA Functional Lead

  • Diane Maffei, Asst Director, Institutional Research

Oversight Committee

  • John Kovatch, Assoc VP Finance & Administration, Controller
  • Cathy Edwards, Director, HRIS
  • William Kraus, Assoc VP, Strategic Enrollment
  • John Corby, Proj Mgt & Cont Quality Improvement Officer
  • Kathy Watkins-Wendell, Dir Research & Sponsored Programs

Functional Team

  • Laura Spray, Systems Administrator
  • Debbie Samples, Manager, Mgr Enrollment Srvs Systems
  • Brett Riebau, Director, Financial Reporting
  • Amy Gilliland, Resource Analysis and Budgeting
  • Kathee Evans, Coord Research Srvcs & Sponsored Programs

IT Team

  • Joann Johns, Application Services Technical Lead (HCM pillar)
  • Gail Hertzig, Application Services Technical Lead (CSW pillar)
  • Marijane Leonard, Application Services Technical Lead (FMS pillar)
  • Mike Giannone, Communications Officer, ITS
  • Sue McKibben, Manager Software Training Services
  • Deb White, AVP, Hardware and Operating Services
  • Rick Draper, Director Application System Services
  • Shannon Whalen, System Analyst Programmer