We blend information expertise and healthcare knowledge to deliver insight into your business. Drive better decisions. Improve productivity.
For a multi-billion division of a top 5 health plan that wanted to ensure quality and consistency of care among its network of newly established Accountable Care Organizations (ACOs), Ajilitee applied its deep experience across healthcare, data integration, and analytics to integrate claims and clinical data coming from Electronic Medical Records (EMRs) and laboratories in the form of HL7 and CCD reports. The lack of common master data for the patient across a range of source systems made it impossible to create a holistic view of the patient experience or perform analysis beyond basic reporting. Ajilitee first defined the master data that should be associated with a patient across various source systems. The team then integrated the various source systems to deliver claims and clinical data across the lifecycle and associate it to the appropriate individuals in a Patient Master Index, which used a unique identifier per patient. The client now can perform analytics across its nationwide network of ACOs to measure quality and introduce quality improvements, and has the foundation to integrate with Health Information Exchanges.
For a major insurer, Ajilitee conducted a comprehensive ICD-10 and BI assessment and developed a detailed inventory of data management assets. The team conducted a metadata tool selection process and chose a tool to house the inventory for ICD-10 impact analysis and future mandates. They also developed the ICD-10 remediation and crosswalk strategy for the EDW, common data stores and informatics. The future state BI solution architecture recommendation included the selection and use of a data warehouse appliance to alleviate the current data warehouse performance and provide the scalability needed for the future growth. The team integrated the BI Strategy with the CRM strategy and MDM/DG roadmap. The BI strategy helped the client move to the next step in achieving the CTO organization’s five-year systems strategy, and positioned the client to be ICD-10 compliant ready by the federal mandate date. Ajilitee’s ICD-10 project was one of the 10 projects in the client’s ICD-10 program. The client recognized Ajilitee’s ICD-10 work as setting the bar for other ICD-10 tracks.
For a health solutions company that wanted to evaluate its complex ETL architecture for potential improvements and reduce their cost structure by understanding ongoing migration issues, Ajilitee interviewed stakeholders and reviewed documentation regarding ETL architecture, standards and documentation, typical project design and adherence to standards, and a host of other practices.The team then shared their findings and recommendations regarding ETL standards, guidelines and governance, which included a comparison of current practice with best practices. The client confirmed Ajilitee’s recommendations were valid and accepted proposed risk mitigation strategies.
For a regional health plan in New England that wanted to define and implement a data governance strategy, including standing up a Data Governance Council and Stewardship groups, Ajilitee evaluated the current data governance program, including processes, organization, and technology, and created a gap analysis showing current state against a set of target focus areas. A governance “playbook”captured processes, roles and responsibilities, and various use cases. Ongoing guidance helped to restart the Data Governance Council and launch three new stewardship groups. The team developed and implemented a work plan for the tools and processes needed to support the data governance initiatives. With Ajilitee’s guidance and mentoring, the client was able to introduce more clarity, accountability, and cohesiveness into its data governance model. The client leveraged the new data governance organization to support an ongoing EDW build. The client deployed an initial data dictionary with 5000 business terms. A data quality profiling toolset was selected to meet data quality and monitoring needs. Discipline was applied to critical non-productionized spreadsheets.
For a provider of health management solutions that envisioned adding benchmarking and other analytics to the current product mix to provide clients additional value and drive down cost, Ajilitee helped the client to develop a product integration strategy to deliver all its solutions using a single, integrated platform that would serve all their markets. This required the evaluation of two platforms that served different markets for delivering patient safety and quality solutions, patient relations, risk management, and legal services. Ajilitee inventoried technology and product modules and evaluated the suitability of the two platforms and created aconceptual architecture based on the integration strategy and results of the assessment. A Product Integration Roadmap prioritized the integration projects, along with high-level estimates for cost and efforts. The Roadmap presented multiple implementation scenarios driven by how aggressive the client wanted to be in effecting change. The acquisition was successful and the client is integrating the two platforms per Ajilitee’s recommendation.
For a provider of laboratory and mobile imaging services to long-term care facilities that wanted to improve Revenue Cycle Management and achieve better insight into the performance of product lines and regions, Ajilitee established a Financial Data Warehouse in a Managed Analytics environment with iterative builds to support more agile operations. The client needed the Financial Data Warehouse to support key lines of business, including Finance, Laboratory, and Mobile business units and derive insights from consolidated reporting on geography, product line, and customer profitability. They also wanted to achieve results cost-efficiently and quickly. Ajilitee conducted business requirements covering information, data, business process and organizational considerations with key stakeholders in IT and the business, then developed the data sourcing design, logical data model, and overall conceptual architecture and prototype for a cloud-based Financial Data Warehouse. Phase I of the Financial Data Warehouse is now live.
For a major wireless provider serving more than 6 million customers that wanted to expand its enterprise data warehouse, Ajilitee provided leadership to the business and data analysis teams throughout the requirements gathering process. This included working closely with the data architect to resolve any requirements ambiguity and enhance data and business analysis processes. Ajilitee synthesized findings and created the business requirements documentation, system requirements specifications and requirements traceability matrix. The client is using the business requirements to guide its EDW expansion.
For a regional health plan that wanted to achieve business agility and velocity to effectively support the business, Ajilitee helped rethink their entire information management landscape and analytics infrastructure, and re-envisioned their data warehouse. Ajilitee’s recommended solution included a survey of analytical processes across the business to define a “service catalog” of specific supported services to be delivered through an Information-as-a-Service architecture; a business case for a data warehouse appliance to determine whether this path could serve as a catalyst for change and faster results; a user adoption strategy to gain support of key business stakeholders; and purposeful legacy system sunsetting as the new architecture was put in place, including ETL and EDW frameworks, MDM and metadata, data governance and data quality, data architecture, and security.
For a major insurer that wanted to govern its broad lines of business, Ajilitee helped establish a data governance framework, including a Data Governance Officewith data stewardship processes and success measures. Ajilitee also advised the Business Analytics Competency Center on its setup and framework, including charter, team structure, capacity planning, processes and requirements gathering.
For a health benefits company that wanted to explore the applicability of cloud computing as an alternative to current outsourcing, Ajilitee analyzed the client’s readiness for a cloud solution against security, performance, agility, licensing, billing, administration, readiness, cost, and technology, as well as various types of statistical analyses and their flexibility for supporting client needs. The team recommended separating Analytics as a Service and Collaboration as a Service to give them due attention. Ajilitee also recommended a public cloud solution to achieve faster time-to-market for pilots but also provision hybrid and private clouds for the longer term implementation.
For a regional health information exchange that wanted to evolve their analytic infrastructure with an enhanced and integrated BI capability, Ajilitee conducted an intensive analysis of the client’s environment through a series of workshops with stakeholders. The team prepared high-level requirements that synthesized the shared understanding of common and unique needs across the collaborative and options that best fit their goals. They also evaluated the viability of the current clinical data integration product for supporting an expanded capability. The recommendations, currently being implemented, included conceptual architecture options, a data source list by subject area, a Total Cost of Ownership (TCO) model, and governance model.
For an eastern regional health plan that wanted to improve service levels for large employer groups through improved BI and analytics, Ajilitee analyzed user adoptionand reported on adoption barriers by user group with specific recommendations for each group based on process, analytics, data, technology and organization. The analysis drew upon best practices in change management to ensure good results. To support the analytics vision for employer group reporting, Ajilitee created a strategy centered on improving health and wellness. Data on consumption of health services was integrated with workforce analytics on absenteeism, behaviors, and the like, creating a holistic and member-centric view of clinical outcomes. The team created a roadmap for implementation that paved the way for the establishment of data governance and the continued evolution of the BI capability. The client is presently implementing Ajilitee’s strategy and recommendations for employer group reporting, and the effort led to another strategy engagement to extend our approach to the data warehouse environment. The health plan also engaged Ajilitee’s sister division, Discovery Health Partners, to tap its Intelligent Cost Containment Platform for creating new grouping logic that would identify workers compensation incidents. This supported cost avoidance as well as improved compliance.
For a major regional provider in the northeast that wanted to invest in an overall enterprise information management strategy, Ajilitee helped define and stand up a Data Governance Council with data governance and stewardship standards; conduct a review of MDM requirements with a solution recommendation; and define the business case for enterprise BI based on an analysis of the desired outcomes compared to current BI and analytical capabilities, data architecture, ETL, and EDW framework. Ajilitee then defined the enterprise data management strategy and all its components and an end-to-end BI strategy for analytic insights. MDM tool selection is underway and Ajilitee continues to deliver high caliber work to this client.
Inc. magazine has ranked LaunchPoint, parent company of Ajilitee, #100 in its 2014 Inc. 5000 list of fastest-growing privately held companies in the U.S.