An Overview of the Banner Implementation Project at MCC

1. An Overview of the Banner Implementation Project at MCC A presentation to the MCC College communityMay – July 2004

2. Presentation Objectives • Provide an overview of SCT Banner • What is Banner? • Why are we implementing the Banner system? • What is the timeframe for implementation? • Who is working on the project? • How will it impact MCC? • MCC Banner project--current status • How can I prepare for Banner?

3. What is Banner? • An upgrade to FRS, HRS, SIS and ADS • SCT Banner includes the following modules: • Finance • Human Resources • Advancement (Alumni/Development) • Student • Financial Aid • An integrated, database-driven information system (Oracle)

4. What is Banner? • Banner is a web application • Available 24/7 via a web browser for access by students, faculty and staff • Integrated application • Point and click (GUI) interface • Uses SQL (structured query language) • Reporting software enhancement is BRIO • Provides more functionality for end users

5. What is Banner? • All data reside in one database • Information shared among all applications • Will use generated IDs with SSN as a searchable alternate ID • Pushes functionality out of the IT area • Individuals can customize their views of Banner

6. Why Implement Banner • MCC’s current SCT PLUS products are 15+ years old • PLUS system is based upon mainframe systems (flat files) that do not support full integration of data that can be shared across modules • Banner product is enhanced by the SUNY SICAS center

7. Implementation Timeframe2003 - 2006 • Start-up phase April 1 – August 31, 2003 • Year 1 Finance (September, 2004) • Year 2 Human Resources (January, 2005) • Year 2 Advancement (September 2005) • Year 3 Banner Student (October 2005- September 2006) • Year 3 Banner Financial Aid (March 2006)

8. Who is on the Banner team? • MCC Banner Executive Committee • Jeffrey Bartkovich—Chair • Janet Glocker • Chet Grzelak • Susan Salvador • Brenda Babitz • Richard Degus • Marie Fetzner • Bob Bertram

9. Who is on the Banner team? • MCC Banner Steering CommitteeMarie Fetzner, Chair • Melissa Barbara Maddy Cuciti • Bob Bertram • Susan Gurak • Sherrill Ison • Sherry Ralston • Betsy Ripton • Diane Shoger • Taine Vinci • Debra Watson • Chuck White • Ad Hoc: Donna Burke, Denise Klein

10. Banner Team Leaders Banner Team Leaders (by Module) • Finance – C. White • Human Resources – S. Ralston • Advancement– D. Shoger and S. Gurak (co-leaders) • Student – B. Ripton and T. Vinci (co-leaders) • Student Ad Hoc – D. Burke and D. Klein • Financial Aid – M. Barbara • Technical – B. Bertram

11. Banner Sub-Committees • Data Standards Committee – S. Ison and D. Watson, Co-chairs • Critical to the success of the data conversion process from Plus to Banner • Critical to maintaining a well tuned database • Reporting Committee – M. Barbara • What reports do we use now? • What else do we need? • What reports need to available at “go live?” • How can report data be accessed in Banner?

12. Banner Sub-Committees • Systems Interfaces and Cross-Product Issues – M. Cuciti, Chair • Focuses on ad hoc issues related to several modules • Addresses interfaces that currently exist in PLUS and need to be moved to Banner • Tracks SICAS modifications across all modules

13. Project Scope:The Data • 3,000 vendors and over 8,100 fixed assets • 1,964 current employees • Average number of Fall term applicants = 10,184 • 3,363 Fall 2003 courses • 2,600 course sections • Average Fall student headcount = 17,771

14. Project Scope:The Data • Average number of registration records for Fall term = 56,892 • 328,211 academic course records • Average number of Fall term Financial Aid recipients = 8,199 • 66,872 alumni • 138,475 MCCF gifts and pledges

15. Efforts to Date • Banner application seed data, test instances and pre-production running on MCC’s servers • SCT Banner training for Banner team is underway for three modules • Data Standards document developed • Reporting inventory underway • Banner website developed in Manila

16. Efforts to Date • Initial data scrubbing has begun • Business Process Analysis (BPAs) on-going • Data Mapping sessions underway • Internal Banner navigation training developed by IT • End User training plans in development • Power users of Purchasing system to be trained as first end user cohort

17. Banner Benefits • College records will be housed in one large relational database • information retrieved and reports generated will draw from current, non-duplicative system information • Students have greater access to information • Banner will bring closure to the problems associated with systems that "don’t talk to each other" • Banner will allow access to information via a web browser in a highly secured and stable environment

18. Impact on MCC • Moratorium on current system changes - System revisions for compliance with regulatory issues only • Business Process Analysis (BPA) • End-user training • Same timeframe as SUNY Mission Review and Middle States

19. Impact on MCC • Purchasing cut-off date for 2003-04 has been moved up to June 11th • MCC’s Open Enrollment period for 2004-05 will be moved up to @November, 2004 • MCC will be working off of two systems—PLUS and Banner—for the duration of the implementation • MCC end users can better utilize Excel and Access to manipulate Banner data

20. Impact on MCC after Implementation • Access to data for students, faculty and staff will be improved • Reports will be generated in a different way • End users will have better access to reports • Learning curve for end users will be steep and then will diminish • PLUS system took over 15 years to be customized

21. Banner Preparation • What can I do now to prepare for Banner? • Consider departmental processes and reporting needs • Enhance technical skills in Excel and Access • View the resources on the Banner web page • Talk to colleagues at other Banner institutions

22. Questions? Marie Fetzner: mfetzner@monroecc.edu MCC Banner Web site:http://web.monroecc.edu/MCCBanner