NDCHealth's Information Management division is a data factory. Accumulating, Cleansing, Packaging and Selling data is our business. We take in 10 million pharmacy transactions per week and produces sales, marketing and research knowledge for pharmaceutical companies. The challenge faced, was that with years of legacy systems and over 70 terabytes of data warehouse data, would we be able to meet the growing HIPAA and contractual requirements of managing data access and distribution? This is the story of how over the past year we revolutionized data governance. A little more than a year ago, NDCHealth was faced with two large seemingly insurmountable challenges. (1) The operational impact of ever growing HIPAA compliance requirements. (2) The more granular contractual requirements of data service providers and customers. As newer members of the NDCHealth Information Management team, Pamela Hulse & Paul Dyksterhouse faced technical, process, and people challenges to address data access and distribution requirement in a changing business environment.

• Business Overview
• The great healthcare knowledge opportunities in mining pharmacy transactions.
• Problem
• The challenge of new data access requirements on old infrastructure and processes.
• The Solution: Start a Revolution in People, Processes, and Tools.
• The Roadmap
• How we met the challenges in the communication, timing, packaging, and delivery of the solution so as to not interrupt new product development nor overly hamper business margins.

Paul Dyksterhouse has over 20 years experience in large enterpriseinformation management, data warehousing, business intelligence, and service delivery systems. His passion is digging into data for that knowledge edge. His focus is maximizing knowledge mining for business users through data quality, transparency and availability. Paul is currently the Director of Database Management and Infrastructure at NDCHealth, managing a team that has built and maintained 70 terabytes of pharmaceutical data warehouses.

Paul has also served in Technology Director and VP roles with BankOne, Honeywell, Charles Schwab and UPS. He has consulted organizations nationally on data governance and effectiveness. His biggest accomplishments have been around managing large data migration and data mining initiatives. He received his B.A. in Economic Theory from Wheaton College. Paul is currently on the DAMA Phoenix Board and has been a speaker for Data Warehousing and Database Marketing conferences. He lives in Scottsdale, Arizona with his wife and three teenage children.

Pamela Hulse has over 20 years experience in healthcare operations and information management. Her strength lies in developing and revitalizing business and systems operations by maximizing people and processes through strategic reengineering and culture change management. Pamela is known deploying a subtle, yet effective approach to align information technology with business needs to drive execution.

Pamela is currently Data Access Manager at NDCHealth. She previously served in various business and technical capacities at the Mayo Clinic and as a Consultant for business reengineering and enterprise application implementations in healthcare. Her accomplishments include introducing Data Governance and co-sponsoring the Metadata Project at NDCHealth, developing clinical research programs for Mayo Clinic Scottsdale, and revitalizing clinical practice business operations and systems for select organizations. Pamela has a BS in Business Administration/Management and a MS in CIS from the University of Phoenix.

She is member of DAMA and PMI. Pamela lives in Scottsdale, Arizona with her husband and two Italian Greyhounds.