Thursday, April 27, 2006

8:30 am - 9:30 am

Level: Intermediate

After working in the data management profession for 19 years, I didn’t think there were too many new tricks of the trade, until I recently discovered one, i.e. Data Profiling, but not as a data quality tool, as a data architecture tool. I have learned how to use data profiling to write metadata, design databases including data warehouses, develop data mapping documents, understand the databases I inherit, and to reduce the time I need to develop these artifacts. I haven’t seen many Data Architect’s take advantage of data profiling in this way, and so this presentation will explain how to profile your data and apply this knowledge to database design, and not just to data quality analysis.

• How to Profile Data
• Applying Data Profiling to metadata development
• Applying Data Profiling to database design
• Applying Data Profiling to data conversions and data mappings
• Applying Data Profiling to interpreting inherited databases including packages
• Making the boss and project manager happy by reducing time to develop data architecture deliverables by using data profiling

Sandy Georgas-Gait has been in the Data Management profession since 1986, in roles including Data Architect, Data Architect Team Leader, DBA, DBA Manager, and is currently the Enterprise Data Architect for Laidlaw Education Services, North America’s largest provider of school bus and public transit services. She has designed a vast number of databases in a number of DBMS platforms, including multiple data warehouses, as well as numerous OLTP and OLAP databases. She has developed several Enterprise Data Models, defined Data Architecture processes, taught new DA’s, and has developed many company specific data architecture tools and standards. She has worked in a variety of industries including energy, banking, retail and transportation. In addition, as a graduate of famous Second City in Chicago, she peppers her presentations with humor, making her sessions entertaining as well as educational.