Case Study

Artificial Intelligence, Data and Analytics

Pharmaceutical Analytics Optimization

Problem

Pharmaceutical company had standard reporting from various source systems for finance, accounting, and procurement. This caused difficulty assembling data for analysis and security constraints for additional access. The inability to combine disparate data meant they couldn’t get a full picture of process and status.

Solution

Implemented Snowflake data warehouse on AWS with transformation with Glue to ingest data, curate and prepare reporting in Qlik Cloud. To enable more customized user experience, Power Pages was leveraged to create a portal providing a single point of access for company analytics as well as ability to share related information like training and announcements.

Outcome

User experience was streamlined through portal access and visibility of full financial process was enabled through integration of disparate system data. Due to architecture and technology, data refresh was able to be achieved every half hour to allow for timely month end reconciliation.

Related Blogs

Case Study – VHA Quality and Safety Management – VHA Tiered Safety Huddles

|

Case Study Management Consulting VHA Quality and Safety Management – VHA Tiered Safety Huddles Problem The VHA needed to establish an omni-directional communication process across it’s 172 VA Medical Centers, 18 VISNs, and Central Office Programs that enabled teams to identify safety concerns and efficiently escalate concerns that could not…

Case Study – VHA Quality and Safety Management – Safety Science Publishing Program

|

Case Study Management Consulting VHA Quality and Safety Management – Safety Science Publishing Program Problem VHA embarked on its Journey to becoming a High Reliability Organization and wanted to contribute to the knowledgebase and science of High Reliability through scholarly publications and presentations to share their results and lessons learned.…

Case Study – VHA Quality and Safety Management – Introduction to Just Culture

|

Case Study Management Consulting VHA Quality and Safety Management – Introduction to Just Culture Problem Committing to a long-term journey towards High Reliability and a Just Culture - focused on Veteran and staff safety and transparency - VHA wanted to implement the infrastructure necessary to sustain a baseline level of…

Case Study – VHA Quality and Safety Management – HRO Leader Coaching

|

Case Study Management Consulting VHA Quality and Safety Management – HRO Leader Coaching Problem In 2019, the Veterans Health Administration recognized a need to renew focus on the pursuit of zero preventable harm while facing historic grow and transformation. With added system complexity and volume, the priority to ensure safe…

Case Study – VHA Quality and Safety Management – HRO Assessment and Planning

|

Case Study Management Consulting VHA Quality and Safety Management – HRO Assessment and Planning Problem The Joint Commission estimates that over 60,000 patients per year die due to preventable harm in the U.S. VA hired rockITdata to assess ongoing operations across their 18 Networks, 171 VA Medical Centers, and over…

Case Study – VHA Nurse Standards and Qualifications Modernization

|

Case Study Management Consulting VHA Nurse Standards and Qualifications Modernization Problem The Veterans Health Administration (VHA) has a large, diverse and geographically dispersed nursing workforce and needed a comprehensive plan to modernize the outdated nurse qualification standards and performance management processes. Solution Combined change management, communications and training expertise, focusing…

Case Study – VHA National Center for Patient Safety – Teams Training

|

Case Study Management Consulting VHA National Center for Patient Safety – Teams Training Problem VHA National Center for Patient Safety (NCPS) developed a very sophisticated multi-disciplinary educational program designed to create high functioning clinical teams across 167 medical centers and 1100 outpatient clinics. The training met significant resistance and experienced…

Case Study – VHA Lean Curriculum Development

|

Case Study Management Consulting VHA Lean Curriculum Development Problem VHA needed a Lean Community of Practice structure to standardize, grow, and sustain continuous process improvement across the enterprise. Forward movement was stalled due to the COVID-19 Pandemic Restrictions. Solution Developed Green Belt, Black Belt and a Master Black Belt training…

Case Study – VHA High Reliability Organization – Outreach and Change Management

|

Case Study Management Consulting VHA High Reliability Organization – Outreach and Change Management Problem The Veteran Health Administration needed to align and integrate the portfolio of HRO activities and educational products across the 350,000 enterprise. Solution Created hundreds of video and written products to include eight HRO Dashboard educational videos,…

Case Study – DoD Medical Research and Development Financial Model

|

Case Study Management Consulting DoD Medical Research and Development Financial Model Problem USAMRDC Laboratories are overly dependent on research reimbursements to provide critical and unique Department of Defense (DoD) readiness capabilities. The indirect costs across the system are not sustainable or competitive. Solution Conducted a five-month assessment and synthesized input…