Big Data Warehouse and DataOps: Pharma Case Study with Amazon Redshift and S3

The list of failed data warehouse projects is long. Even operational warehouses often leave end-users, data analysts and data scientists frustrated with long lead times for changes and bug fixes. This case study will illustrate how to make changes to the data warehouse and dashboards quickly and with high quality.

Key topics include:

• Background of a pharmaceutical launch
• Teams, timing, and tools used to support the launch
• AWS cloud resources and their support of the launch with the Data Lake pattern
• Feature requests handling
• Promoting processes between teams
• Lessons learned

Gil Benghiat is one of three founders of DataKitchen, a company on a mission to enable analytic teams to deliver value quickly and with high quality. Gil’s career has always been data oriented, starting with collecting and displaying network data at AT&T Bell Laboratories (now Alcatel-Lucent), managing data at Sybase (purchased by SAP), collecting and cleaning clinical trial data at PhaseForward (IPO then purchased by Oracle), integrating pharmaceutical sales data at LeapFrogRx (purchased by Model N), and liberating data at Solid Oak Consulting.

Gil has a Master of Science in Computer Science from Stanford University and a Bachelor of Science in Applied Mathematics/Biology from Brown University. He completed hiking all 48 of New Hampshire’s 4,000 peaks and is now working on the New England's 67.

Christopher Bergh is Founder and Head Chef at DataKitchen. Chris has more than 25 years of research, engineering, analytics, and executive management experience. Previously, Chris was Regional Vice President at Model N. Before Model N, Chris was COO of LeapFrogRx, a descriptive and predictive analytics software and service provider. Prior to LeapFrogRx, Chris was CTO and VP of Product Management of MarketSoft (now part of IBM). Prior to that, Chris developed Microsoft Passport, the predecessor to Windows Live ID, a distributed authentication system used by 100s of Millions of users today.

Chris began his career at the MIT Lincoln Laboratory and NASA Ames Research Center. Chris served as a Peace Corps Volunteer Math Teacher in Botswana, Africa. Chris has an M.S. from Columbia University and a B.S. from the University of Wisconsin-Madison. He is an avid cyclist, hiker, reader, and father of two teenagers.