Case Study: Pfizer reduces costs and mitigates risk with Attunity Visibility

Pfizer Mitigates Risk & Reduces Costs with Attunity Visibility

Pfizer’s Human Resource division managed a massive data warehouse with over one million daily queries from more than 3,000 users, but lacked visibility into usage patterns and faced rising regulatory, audit, and cost pressures. Pfizer also needed to reduce ETL load times to meet service-level agreements, and turned to Attunity Visibility for help.

Attunity implemented Attunity Visibility to analyze BI and data warehouse activity without disrupting production systems. The solution gave Pfizer granular insight into user activity and data usage, helping cut HR data warehouse storage by 50%, reduce user IDs from 3,000 to 300, and lower ETL load times by 75%. Pfizer estimated annual savings of nearly $400,000 from storage reductions plus nearly $80,000 more from faster ETL, while also improving compliance and reducing audit risk.

Pfizer