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 – 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 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…

peri hoki perihoki perihoki duta76 duta76 duta76 duta76 scatter hitam mahjong abc1131 maxwin frekuensi tinggi mahjong wins3 awsbet pemain pro baccarat beri kejutan jackpot besar provider pgsoft bagi maxwin di mahjong ways 2 auto scattr hitam mahjong wins 3 lagi bocor
peri hoki perihoki perihoki main baccarat di perihoki pasti jadi master jackpot rasakan sensasi main dadu sicbo paling paten diperihoki peluang menang besar kartu blackjack di situs perihoki trik gampang dapat petir zeus gates of olympus perihoki pola legendaris pgsoft mahjong ways 2 untuk pemain perihoki kunci kemenangan besar roda baccarat situs perihoki kejutan tembus mix parlay 15 tim auto joget di perihoki jadi milioner berkat main blackjack gacor perihoki perihoki pasti kasih maxwin main pragatic gates of olympus bocoran rtp tinggi dapat scatter hitam mahjong wins 3 skripsi dan cuan mahjongwins3 buyspin bongkar jackpot baru sweetbonanza freelance cuan freespin motor mahjongways2 pola gates x5000 karyawan challenge mahjong sky twitter angkringan cuan mahjongways2 pola kalimantan mahjongwins3 waktu gacor siang mahjong deposit qris awsbet aman strategi menang mahjong abc1131 rtp live evolution abc1131 pola spin efisien awsbet high betting mahjong awsbet