{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Comm Lending Proj RACI","Assumptions"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Comm Lending Proj RACI","index":0,"n_rows":102,"n_cols":34,"rows_kept":102,"cut":false,"hidden":false,"merged":[[12,12,12,16],[12,5,12,10],[12,29,12,33],[12,18,12,23],[12,1,12,3]]}
[]
["Commercial Lending Systems Project"]
["RACI (Responsible, Accountable, Consult, Inform)"]
[]
["Document Objective:  To define the various responsibilities of the project team, stakeholders and project sponsors on the Commerical Lending Systems project."]
[]
["Responsibility - People who are expected to actively participate in the activity and contribute to the best of their abilities. "]
["Accountability - The person who is ultimately responsible for the results. "]
["Consultation - People who either have a particular expertise they can contribute to specific decisions (i.e., their advice will be sought) or who must be consulted for some other reason before a final decision is made (e.g., finance is often in a consulting role for projects). "]
["Inform - People who are affected by the activity/decision and therefore need to be kept informed, but do not participate in the effort. (They are notified after the final decisions are made.) "]
[]
[]
[null,"Demand",null,null,null,"Initation",null,null,null,null,null,null,"Planning and Design",null,null,null,null,null,"Execution",null,null,null,null,null,null,null,null,null,null,"Close Down"]
["Responsibility","Project Request",null,null,"Toll Gate","Phase Kick-off Meeting","Project Status Meetings","Business Case","Hi-level Business Requirements","Hi-level Technical Requirements","Vendor Selection","Toll Gate","Phase Kick-off Meeting","Project Status Meetings","Refine Business Case","Detailed Business Requirements","Detailed Technical Design","Toll Gate","Phase Kick-off Meeting","Project Status Meetings","Refine Business Case","Detailed Technical Design","Coding","QA / Testing","Pilot (Group TBD)","Communication","Training","Implementation","Toll Gate","Technical BAU Transition","Business BAU Transition","Lessons Learned","Final Project Close Down Artifacts","Celebration!"]
["Roles"]
["Project Management Team"]
["Erin Kowalow - Project Manager",null,null,null,null,"A","A","R ","R ","R ","R ","R","A","A","R ","R ","R ","R","A, R","A","R ","R ","R","R","R","R","R","R","R","R","R","A","A","A"]
["Tim Murphy - Business Lead",null,null,null,null,"R","R","R","R","R","R","C","R","R","R","R","R","C","R","R","R","R",null,"R","R","R","R",null,"C",null,null,"R","C","R"]
["Project Coordinator - TBD",null,null,null,null,"R","R","R  ","R ","R ",null,null,"R","R",null,"R ","R ",null,"R","R","R  ","R ","R","R","R","R","R","R"]
[]
["Requirements Management Team"]
["*Rob Beigh",null,null,null,null,"R","R","R","R","R","R","C","R","R","R","R","R","C","R","R","R","R",null,"R","C",null,null,null,"C",null,null,"R","C","R"]
["*Tim Schunk ",null,null,null,null,"R","R","R","R","R","R","C","R","R","R","R","R","C","R","R","R","R","R","R","R","R","C",null,"C",null,null,"R","C","R"]
["Russell Hom",null,null,null,null,"R","R","R","R","R","R","C","R","R","R","R","R","C","R","R","R","R",null,"R","R?",null,null,null,"C",null,null,"R","C","R"]
["Margie Means",null,null,null,null,"R","C","R","R","R","R","C","R","I","R","R","R","C","R","C","R","R","R","R","R",null,null,null,"C",null,null,"R","C","R"]
["Bob  Schmon",null,null,null,null,"R","C","R","R","R","R","C","R","I","R","R","R","C","R","C","R","R","R","R","R",null,null,null,"C",null,null,"R","C","R"]
[]
["Technical Team"]
["Applications Architect - TBD",null,null,null,null,"R","R","R","I","A?","R","C","R","R","R","I","A?","C","R","C","R","A?","C"]
["**Technical Lead",null,null,null,null,"C","R","C","C","C","C","C","R","R","C","I","C","C","R","R","C","R","A","R","A","C","C","A"]
[]
["Quality Assurance Team"]
["Ed Benkert",null,null,null,null,"R",null,null,null,null,null,null,"R","R",null,"R",null,null,null,null,null,null,null,"A",null,"R",null,null,null,null,null,"R",null,"R"]
["**TBD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,null,null,null,null,"R",null,"R"]
["**TBD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,null,null,null,null,"R",null,"R"]
[]
["Communications / Training Team"]
["**Communications Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","C",null,null,null,null,"R",null,"R"]
["**Training Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","A",null,null,null,null,"R",null,"R"]
[]
["Servicing Team"]
["*Michelle Giles ",null,null,null,null,"R","R","A","A","C","R","C","R",null,"A","A","C","C","R",null,"A","C",null,"R","R","R","R","R","C",null,"A","R","C","R"]
[]
[]
["Corporate and Business Banking"]
["*Nancy Cinfio ",null,null,null,null,"R","R","A","A",null,"R","C","R","R","A","A",null,"C"," ","R","A",null,null,"R","R","R","R","R","C",null,"A","R","C","R"]
["Ammon Baus",null,null,null,null,"R","I",null,null,null,"C",null,"R",null,null,null,null,null,"R",null,null,null,null,"R","R","R","R","R",null,null,"R","R",null,"R"]
["Lewis Cyr",null,null,null,null,"R","I",null,null,null,"C",null,"R",null,null,null,null,null,"R",null,null,null,null,"R","R","R","R","R",null,null,"R","R",null,"R"]
["Renee Coyner",null,null,null,null,"R","I",null,null,null,"C",null,"R",null,null,null,null,null,"R",null,null,null,null,"R","R","R","R","R",null,null,"R","R",null,"R"]
["Bob Moorehead",null,null,null,null,"R","I",null,null,null,"C",null,"R",null,null,null,null,null,"R",null,null,null,null,"R","R","R","R","R",null,null,"R","R",null,"R"]
["Nina Bell",null,null,null,null,"R","I",null,null,null,"C",null,"R",null,null,null,null,null,"R",null,null,null,null,"R","R","R","R","R",null,null,"R","R",null,"R"]
["Credit Admin"]
["Julie Sullivan",null,null,null,null,"R","R","A","A",null,"R","C","R","R","A","A",null,"C","R",null,"A",null,null,"R",null,null,null,null,"C"]
[]
["Small Business and Leasing"]
["Dave Squire",null,null,null,null,"R","I","A?","A?",null,"R?","C","R","R","A?","A?",null,"C","R","R","A?",null,null,"R","R","R","R","R","C",null,"R","R","C","R"]
["*Lynn Sciog",null,null,null,null,"R","R","A","A",null,"R ",null,"R","R","A?","A",null,null,"R","R","A",null,null,"R","R","R","R","R",null,null,"R","R","C","R"]
["Cheryl Malicki",null,null,null,null,"R","I",null,null,null,"C",null,"R","I",null,null,null,null,"R","I",null,null,null,"R","R","C","C","R",null,null,"R","R",null,"R"]
["Joe Murphy",null,null,null,null,"R","I",null,null,null,"C",null,"R","I",null,null,null,null,"R","I",null,null,null,"R","R","C","C","R",null,null,"R","R",null,"R"]
["Jeremy Bilson",null,null,null,null,"R","I",null,null,null,"C",null,"R","I",null,null,null,null,"R","I",null,null,null,"R","R","C","C","R",null,null,"R","R",null,"R"]
["Patrick Cronin",null,null,null,null,"R","I",null,null,null,"C",null,"R","I",null,null,null,null,"R","I",null,null,null,"R","R","C","C","R",null,null,"R","R",null,"R"]
["Tina Jones",null,null,null,null,"R","I",null,null,null,"C",null,null,"I",null,null,null,null,"R","I",null,null,null,null,null,null,null,null,null,null,"R","R",null,"R"]
["Commerical RealEstate"]
["Jill Winter",null,null,null,null,"R","R","A","A",null,"R","C","R","R","A","A",null,"C","R","R","A",null,null,"R","R","R","R","R","C",null,"R","R","C","R"]
["Noreen O'Neill",null,null,null,null,"R","R","A","A",null,"R","C","R","R","A","A",null,"C","R","R","A",null,null,"R","R","R","R","R","C",null,"R","R","C","R"]
["Angela Indelicato",null,null,null,null,"R","R","C","C",null,"C",null,"R","R","C","C",null,null,null,null,null,null,null,"R","R","R","R","R",null,null,"R","R",null,"R"]
["Cash Management"]
["Denise McNitt",null,null,null,null,"R","C","A","A",null,"C",null,"R",null,"A","A",null,null,"R",null,"A",null,null,"R","R","R","R","R",null,null,"R","R","C","R"]
[]
["Business Intellegence"]
["Brian Crimi",null,null,null,null,"R","C","C","C",null,"I",null,"R",null,"C","C",null,null,"R",null,"C",null,null,"R",null,null,null,null,null,null,"C","C","C","R"]
[]
["Legal"]
["Robin Capozzi",null,null,null,null,"R","C","C","C",null,"I",null,"R",null,"C","C",null,null,"R",null,"C",null,null,"R",null,null,null,null,null,null,"C","C","C","R"]
[]
["Finance"]
["Ted Buonanno",null,null,null,null,"R","C","C","C",null,"I",null,"R",null,"C","C",null,null,"R",null,"C",null,null,"R","R","R","R","R",null,null,"R","R","C","R"]
[]
["Technology Leadership Team"]
["Jeff Semonovich",null,null,null,null,"I",null,"I","I",null,"R",null,"I",null,"I","I",null,null,"I",null,"I",null,null,"I","I","I","C","R",null,"R","I","I","C","R"]
["Pete Jones",null,null,null,null,"I",null,"I","I","A?","R",null,"I",null,"I","I","A?",null,"I",null,"I","A?",null,"I","I","I","C","R",null,"R","I","I","C","R"]
["Kerry Ruhl",null,null,null,null,"I",null,"I","I","A?","R",null,"I",null,"I","I","A?",null,"I",null,"I","A?",null,"I","I","I","C","R",null,"R","I","I","C","R"]
["Cindy Bauer",null,null,null,null,"I",null,"I","I",null,"R",null,"I",null,"I","I",null,null,"I",null,"I",null,null,"I","I","I","C","R",null,"C","I","I","C","R"]
[]
["Project Sponsorts"]
["John Petrey",null,null,null,null,"I",null,"I","I",null,"A?","R","I",null,"I","I",null,"R","I",null,"I",null,null,"I","I","R","C","R","R","R",null,"I","I","R"]
["Sharron Fanelli",null,null,null,null,"I",null,"I","I",null,"R","A","I",null,"I","I",null,"A","I",null,"I",null,null,"I","I","R","C","R","A",null,"R","I","I","R"]
[]
["Ops Comm",null,null,null,null,"I",null,"I","I",null,"C","R","I",null,"I","I",null,"R","I",null,"I",null,null,null,"I","I",null,"I","R",null,null,null,"I","I"]
["Vendors"]
["ACBS",null,null,null,null,"R",null,"C","C",null,null,null,"R",null,"C","C",null,null,"R",null,"C",null,null,"R","R","R","R","R",null,"R","R","R","C","R"]
["Capital Stream",null,null,null,null,"R",null,"C","C",null,null,null,"R",null,"C","C",null,null,"R",null,"C",null,null,"R","R","R","R","R",null,"R","R","R","C","R"]
["Miser",null,null,null,null,"R",null,"C","C",null,null,null,"R",null,"C","C",null,null,"R",null,"C",null,null,"R","R","R","R","R",null,"R","R","R","C","R"]
["Metavante",null,null,null,null,"I",null,"C","C",null,null,null,"I",null,"C","C",null,null,"I",null,"C",null,null,"R?","R","R","R","R",null,"R","R","R","C"]
["Sigel",null,null,null,null,"I",null,"C","C",null,null,null,"I",null,"C","C",null,null,"I",null,"C",null,null,"R?","R","R","R","R",null,"R","R","R","C"]
[]
[]
[]
[]
[]
["*Team Lead"]
["**Resource to be defined"]

{"sheet":"Assumptions","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,0,22,0]]}
["Below are the assumed processes and artifacts that will fall within each of the named phases",null,null,null,null,"DRAFT"]
[]
["Phase","Demand","Initiation","Planning and Design","Execution","Close Down","Project Administration"]
["Process / Artifacts","Project Request","Create SIPOC","Create as-is business map","data mapping","Lessons Learned","Upload and maintain the project repository on SharePoint"]
[null,null,"Create CTQ","create to-be business map","custom coding","Compile financials","Manage project team PTO Calendar on Sharepoint "]
[null,null,"High-level Business requirements","Define Functional Speficiations","Report Development","outstanding issues / opportunities","Manage the Microsoft Project Schedule calendar"]
[null,null,"High-level cost and duration estimates","Document Functional Specifications","technical implementation",null,"Record and publish meeting minutes "]
[null,null,null,"Define Technical Requirements","to-be business process execution",null,"record, publish and manage action log"]
[null,null,null,"Document Technical Requirements","unit testing",null,"record, publish and manage issues log"]
[null,null,null,"Define Use Cases","QA",null,"record, publish and manage decision log"]
[null,null,null,"Document Use Cases","UAT",null,"record, publish and manage risk log"]
[null,null,null,"Define Test Plan","Refine Implementation Plan",null,"Manage Finanacial tracking spreadsheet"]
[null,null,null,"Define Organization Change Management Plan",null,null,"Invoice approval"]
[null,null,null,"Define Implementation Plan",null,null,"invoice tracking"]
[null,null,null,"Refine resource plan",null,null,"Schedule project team meetings"]
[null,null,null,"Refine cost and duration estimate",null,null,"Manage Change Control log"]
[null,null,null,"Create project schedule",null,null,"Create change controls"]
[null,null,null,"Create project baseline",null,null,"obtain approval on change controls"]
[null,null,null,"Create gate 2 presentation",null,null,"Define project ROI"]
[null,null,null,"Obtain OpsComm approval",null,null,"Create Project Communication Plan"]
[null,null,null,null,null,null,"Create weekly status reports"]
[null,null,null,null,null,null,"Create Project Charter"]
[null,null,null,null,null,null,"Create Ops Comm presentation"]
[null,null,null,null,null,null,"Obtain project Gate approvals"]
[null,null,null,null,null,null,"Vendor Management"]
[null,null,null,null,null,null,"Create project contact list"]
[null,null,null,null,null,null,"Create resource plan"]