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…

cakar76 memenangkan cuan instans mahjong wins 3 wild scatter hitam cakar76 optimalkan scatter hitam mahjong wins 3 cakar76 pemuda main mahjong ways saldo minim dapat jackpot puluhan juta cakar76 rahasia cuan besar modal kecil mahjong wins 3 cakar76 rasakan sensasi hoki mahjong ways 2 kincir88 max win main mahjong wins 3 hujan saldo kincir88 menang jackpot mahjong ways 2 modal tipis scatter hitam kincir88 mengoptimalkan strategi scatter hitam mahjong kincir88 nikmati sensasi mahjong wins 3 dan mahjong ways 2 kincir88 pola pecahan wild berkali kali jepe adat88 menghitung peluang scatter hitam mahjong ways 2 jackpot adat88 menjaga momentum scatter wild emas mahjong wins 3 adat88 modal kecil cuan besar mahjong wins 3 strategi untuk menang tanpa risiko adat88 peluang cuan gila mahjong ways 2 adat88 peluang maksimal modal kecil mahjong ways 2 kincir88 pola ritme mahjong ways 2 keberuntungan kincir88 rahasia menguasai freespin mahjong wins 3 profesional kincir88 scatter hitam mahjong ways 2 cuan besar modal tipis kincir88 scatter hitam mahjong wins 3 kunci keberuntungan kincir88 scatter hitam mahjong wins 3 modal receh cuan gede adat88 rahasia keuntungan tiap hari mahjong wins 3 adat88 rahasia scatte hitam mahjong wins 3 adat88 rahasia simbol mahjong ways 2 cuan dan keberuntungan adat88 rasakan sensasi insting jackpot mahjong wins 3 adat88 rejeki langscung nyelonong mahjong wins 3. cakar76 scatter hitam mahjong ways rahasia kemenangan maksimal cakar76 scatter hitam mahjong wins 3 kunci keberuntungan besar cakar76 sensasi main mahjong ways gacor parah cakar76 simbol emas dan free spin rahasia menang berlipat mahjong ways 2 cakar76 simbol hitam super win mahjong wins 3