Our Work

To demonstrate Index’s capabilities, we have developed two demonstration applications that use publicly available datasets. See how we turn data into knowledge with our Open Payments and FDA Adverse Event Reporting System solutions.

schedule a demo

Open Payments Application

Open Payments data is a publicly available dataset published by the Centers for Medicare & Medicaid Services (CMS) on a yearly basis. This data is part of a national transparency program that collects and publishes information about financial relationships between the health care industry (i.e. drug and device companies) and providers (i.e. physicians and teaching hospitals).

aa

map

Tailor analytics to your stakeholders
Our browser-based executive dashboards summarize open payment data for executive leadership. Find out which state was funded the most or the physician specialties that received top dollar from drug manufacturers last year.
com
Dive deeper into the data to identify anomalies and trends
Spot outlier payments made by drug manufacturers & investigate payment activity over time. Drill all the way from the medical specialties to individual physicians and research what type of payments are being paid to physicians.
bon
Perform predictive analytics
Derive powerful insights by deploying advanced algorithms to predict the payments that drug manufacturers would likely make in future years. Or segment drug manufacturers based on the similar types of payments they tend to make.

FDA Adverse Event Reporting System (FAERS) Application

fda

FDA Adverse Event Reporting System supports the FDA's post-marketing safety surveillance program for all marketed drug and therapeutic biologic products. It contains adverse event reports FDA has received from manufacturers as required by regulation along with reports received directly from consumers and healthcare professionals. FDA provides this data as a downloadable file. The application helps users identify and visualize the adverse effects of prescribed and over the counter medications and helps them identify options that may have less adverse reactions.

 

CCSQ ISG Data Strategic Plan Development

Index Analytics supports The Center for Clinical Standards and Quality (CCSQ), Information Systems Group (ISG), in their mission improve how our health care system works. This group is focused on improving outcomes, population health, and reducing health care costs through innovative healthcare IT systems. 

As part of the Data Strategic Plan Development effort, Index performed an assessment of the current data environment—comprised of multiple data assets in various formats—and developed a strategic roadmap and operational implementation plan to help CCSQ ISG achieve their desired future state. In the new environment, users will be able to gain meaningful insights without labor-intensive programming efforts to access and analyze data assets. To prepare an executable roadmap, Index applied their maturity model to characterize the current state and identify three- and five-year goals based on attainability and alignment with business objectives. 

These goals were then packaged into discreet projects that are realistic, easily communicated, and adequately resourced to be successful and deliver measurable benefits to the organization and its stakeholders.

a
 

CMS  Medicare Advantage Encounter Data
Dashboard and Analytics (EDDA)
Development Effort

More than 17 million individuals, representing about one-third of Medicare beneficiaries, are enrolled in the Medicare Advantage (MA) program which allows these healthcare consumers to have access to a wide variety of managed care entities. CMS’s Medicare Plan Payment group (MPPG) sought to gain a better understanding of the approximately 1.9 billion encounter data records submitted by MA institutional & professional providers, ambulance providers, clinical laboratories, & durable medical equipment suppliers. 

Using an agile methodology, Index developed an analytic platform that provides easy to use data, business intelligence (BI), and visualization tools for understanding encounter data, facilitating decision making for CMS. Index engineers developed a series of dashboards on a MicroStrategy platform that provide data insights into topics like compliance with reporting requirements, benchmarking, and quality of care measures. 
 

a
 

FDA CDER MedDRA-based Adverse Event
Diagnostics (MAED) Maintenance, Support, and
Enhancement Services

The Food and Drug Administration (FDA) Center for Drug Evaluation and Research (CDER) provides regulatory oversight to the pharmaceutical and biotechnology industry. MedDRA‐based Adverse Event Diagnostics (MAED) is an adverse event analysis tool that improves reviewers’ ability to effectively and quickly analyze data. It is imperative that FDA provides reviewers with tools that automate repetitive processes and take advantage of powerful computational resources to conduct complex analyses and present results in meaningful and innovative ways. 

Index performs on-going support of the MAED analytics tool as well as provides enhancements to improve the user experience and meet evolving needs at CDER. Enhancements are completed using an agile methodology in accordance with FDA’s standard EPLC process and the team’s Just-in-time Requirements Analysis (JITRA) methodology—resulting in complete, comprehensive business requirements and meaningful improvements to the MAED tool.
 

a
 

com

CMS Business Intelligence/Extract, Transform, Load (BI/ETL)

Index Analytics provides technical and management expertise to support the BI/ETL (business intelligence and extract, transform, load) tool administration; development and innovation; operations and maintenance; and system architecture as a shared service for the Centers for Medicare and Medicaid Services (CMS). We also provide business intelligence, data analytics, and big data expertise to support the customer's strategic vision and goals. In addition, we manage the SAS user group training and user support outreach.

com

HHS OIG Consolidated Data Analysis Center (CDAC)

We provided The Office of Inspector General (OIG) within the Department of Health and Human Services (HHS) with analytics tools to support the Consolidated Data Analysis Center (CDAC), allowing its users to review and analyze data for the detection and prevention of fraud, waste, and abuse. Index also conducted customer outreach for the users of the CAT applications by onboarding new users and managed their training and documentation needs.

com

CMS End-Stage Renal Disease Quality Reporting System (EQRS)

Index supported The Center for Clinical Standards and Quality (CCSQ) within CMS in the consolidation of legacy CROWNWeb, REMIS and ESRD QIP systems into a unified and streamlined End-Stage Renal Disease Quality Reporting System (EQRS). We modernized the EQRS system architecture using user-centered design practices, Agile methodology, microservices, and DevOps in a cloud environment. We also provided dashboard development expertise, creating a user-friendly landing page experience for the EQRS stakeholders. 

com

CMS Premium Stabilization Programs (PSP)

The Center for Consumer Information and Insurance Oversight (CCIIO) within CMS was in need of Customer Relationship Management (CRM) application and outreach support for the Premium Stabilization Programs (PSP) as part of the Patient Protection and Affordable Care Act (PPACA). Index provided Salesforce CRM support for large userbases across multiple workflows. We also provided email-based help desk outreach and resolution; data quality analysis and validation; adhoc reporting and dashboards; and Section 508 expertise.

com

CMS Marketplace Assisters Technical Support (MATS)

CMS was in need of CRM application support for the Marketplace Assisters Technical Support (MATS) program that collects and processes inquiries from Marketplace Assisters and organizations (external to CMS and nationwide) that provide support to consumers in completion, enrollment, and eligibility assistance. Index designed and developed customer websites for the Salesforce CRM application and administered and developed workflow approval processes. We also provided operations and maintenance support for Salesforce-related issues and concerns to support program goals.

com

CMS CEDAR

CCIIO within CMS was in need of technical support the 1095A data reporting error resolution process for the CEDAR program for individuals enrolled in the Marketplace insurance plan deployed as part of the PPACA. Index Analytics assisted in design, development, and operations and maintenance of the Microsoft Dynamics CRM system and its underlying databases. We developed data extraction, transformation, and load services for the current environment in addition to automated and manual data quality processes to improve data quality. We also developed and delivered scheduled operational reports and addressed adhoc requests for the 1095A data error resolution process.

com

CMS Data Services Hub (DSH)

CCIIO within CMS was in need of support services for the Data Services Hub (DSH) system to support a first-class customer experience and provide seamless coordination between 1) the state-administered Medicaid and CHIP programs and the Federally Facilitated Marketplace (FFM), and 2) between the FFM and plans, employers, and navigators. Index provided Oracle database administration support for the DSH system; maintains current services; builds new services; and provides support and maintenance for the current technical solutions.

com

CMS Medicare Cost Estimator

The Office of Communication within CMS, as part of a transparency initiative, was in need of a service that helps Medicare beneficiaries understand procedure cost information to enable them to choose a healthcare provider. Index provides claims data and processing expertise to extract and model claims and cost data in the cloud, enabling a microservices-driven Medicare cost estimator application used by beneficiaries as 3rd party applications. We also provide an open data platform for stakeholders to consume data in a streamlined fashion.