Specifications include, but are not limited to: Key Role Responsibilities Migrate users and reports from EPM 8.9 Cognos 8.3 Legacy to EPM 9.0 Cognos 8.4 OAKS BI Analyze impacts, Legacy report usage, and perform Fit/Gap to delivered Reports Conduct focus groups and validate communication and decommissioning approach by logical grouping Conduct workshops with agencies to review Fit /Gap and create standardized requirements Create weekly status and progress reports Reduce Cost of Ownership Decommission Legacy Reduce frequency of refresh, restrict access, and plan sunset of legacy warehouse Agency Adoption Analyze legacy reporting solution(s), recommend approach for integration Solicit buy-in from HR Administrators and CFOs, reinforcing value and synergy of Integrated BI Provide functional plans to agencies for transition to BI solution Facilitate training and phased rollout of integrated BI Introduce KPIs, dashboards, and scorecards Create Roadmap for Enterprise BI Capability Create development steps to create Enterprise Data Warehouse (EDW) approach Provide templates for Initiation, Planning, Business Analysis , Design, Build, and Deployment Encourage familiarity with dimensional model and options for integrating data sources Document state-specific experience from agency integration Provide functional training templates to be used by agencies for transitioning to state of Ohio BI reports and tools Each vendor candidate responding to this solicitation must demonstrate the following experience: Three (3) years experience in ERP. PeopleSoft multi-module (FIN, HCM) experience preferred Three (3) years experience with business analysis/requirements gathering/strategy and leadership. Business intelligence focus preferred Two (2) years of recent experience with a Cognos or similar business intelligence tools preferred - OLAP, Dashboards, Scorecards and Reports Excellent documentation and communication skills.
