State of Ohio Procurement



Supplement 3Supplement: Change Healthcare DSS/Business Intelligence Requirements and ResponsesState of Ohio Department of Medicaid / Medicaid Clinical Quality and Research#Requirement AreaRequirement Sub-AreaRequirementOfferor Proposed Solution Offeror Comments5.075ReportingDSS/Business IntelligenceThe Contractor shall coordinate with the State's Operational Business Intelligence (BI) contractor to interface with existing Oracle database technology for storage of all pharmacy claims and reference data. The database(s) are stored on the State of Ohio Computing Center (SOCC) and the Contractor shall establish physical connectivity to the SOCC with ODM approved technology. Goold Data WarehouseGoold will coordinate with the State’s Operational BI contractor for interfacing with the existing database technology.? The Goold data warehouse actively supports data transfers on a daily basis and will comply with this requirement.5.076ReportingDSS/Business IntelligenceThe Contractor shall supply the State's Operational Business Intelligence (BI) system with a onetime load of seven (7) years of RAW claims history data in a format to be provided by the State's BI Contractor.Goold Data Warehouse, SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS)Goold understands that their data warehouse will be responsible for providing data conversion of 7 years of Ohio’s claims data.? Upon completion of the conversion, Goold will provide the 7 years of data to the State’s Operational BI system in a format provided by the State’s BI contractor.5.077ReportingDSS/Business IntelligenceThe Contractor shall provide daily incremental loads of Contractor RAW Source Data base to Operational BI environment.Goold Data Warehouse, SSISGoold will provide daily incremental feeds to the Operation BI environment as indicated in this requirement.? Data extracts will be provided on a scheduled basis as identified during the DDI phase of the contract.5.078ReportingDSS/Business IntelligenceThe Contractor shall provide scripts for data validation of source and target data to the State's Operational BI Contractor.Goold Data Warehouse, SSIS, SSMSGoold will provide the scripts and data validation used for source and target data to the State’s Operational BI Contractor as indicated in this requirement.5.079ReportingDSS/Business IntelligenceThe Contractor shall coordinate with the Operational BI Contractor to document data reconciliation requirements.Goold Data Warehouse, SSIS, SSMSThe Goold Implementation Manager will coordinate with the Operational BI Contractor and the Goold Data Warehouse to fully document data reconciliation requirements as indicated in this requirement.5.080ReportingDSS/Business IntelligenceThe Contractor shall coordinate with the Operational BI Contractor to document test/validation criteria.Goold Data Warehouse, SSIS, SSMSGoold has a documented test/validation process and will coordinate with the Operational BI contractor for review, update and agreed upon criteria to meet this requirement.5.081ReportingDSS/Business IntelligenceThe Contractor shall coordinate with the Operational BI Contractor to create pharmacy data mart including but not limited to defining all necessary data elements, valid values for each field and field/file layouts.SFTPGoold will meet the specifications of this requirement. During the design phase for this project, our team will collaborate with ODM to further define the expectations.5.082ReportingDSS/Business IntelligenceThe Contractor shall coordinate with the Operational BI Contractor to document all reporting requirements and design documents for pharmacy reporting, including ad hoc reporting.Goold Analytics StaffDuring the DDI phase of the contract the Goold Project Management team will work with the Operational BI contractor to assure that all reporting requirements are identified and documented.? The PM will engage the Analytics team to assist when applicable to assure that the documentation is adequate and to work with the team to assure that this requirement is met.5.083ReportingDSS/Business IntelligenceThe Contractor shall supply all necessary staff to complete the initial and ongoing data loads in addition to sufficient end users to satisfy the reporting requirements of this RFP and Supplements. Staff shall be familiar with Cognos BI tools and provide end user training to ODM pharmacy staff upon request.Goold Data Warehouse, Goold Analytics StaffGoold has a fully capable Data warehouse with trained staff to meet this requirement.? The staff will be familiar with Cognos BI tools and will provide end user training when applicable to ODM pharmacy staff upon request.? Goold maintains an Analytics staff that is fully capable of supplying the reporting requirements of this contract. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download