Business Case
In addition to needing to meet an aggressive deadline, the DHCF had reasons for wanting a new Medicaid data warehouse in the first place. The existing Medicaid data warehouse did not provide users with efficient access to the data that they needed.
The new DHCF MDW had to meet the following requirements: Implement a solution using Microsoft Technologies, including Power BI for reporting, provide secure and efficient ad-hoc access to key Medicaid data via a single sign-on web portal, and comply with all Federal and Local requirements and security standards.
The Solution
To get things off the ground quickly, CMA provided DHCF with key MDW materials and documents from our implementation of NYS MDW, including security policies, a change management plan, a business continuity plan, a quality assurance plan, and a risk and issue management plan. CMA also provided key PMO recommendations, which included phasing implementation for select pilot users.
With these previously-written materials in hand, CMA created key deliverables for the project, including a risk and issue management plan, a quality assurance plan, and a data governance plan.
CMA also developed and maintained Work Breakdown Structure (WBS) project plan, reviewed and validated ETL data and reports and dashboards, and developed and unit tested key reports and dashboards.
The Results
CMA has deep experience in Medicaid data warehousing. We possessed the Medicaid knowledge, Microsoft experience, project management expertise, and key MDW documents and materials that DCHF needed to successfully meet their expedited implementation deadlines. DHCF implemented Phase I of their new MDW on schedule in September 2017. CMA’s contract with DHCF has extended beyond this phase and we look forward to continuing our work in DC.