Margaret Birnbaum

Current

• EDW Data Modeler at NetApp

Past

• Data Modeler and Database Designer at Cisco Systems
• Enterprise Data Modeler at Cisco Systems
• Senior Business Analyst / Data Modeler at Netscape Communications

• Data Administration Manager at Hewlett Packard

see less...

1 more...

Education

• University of California, Los Angeles - The Anderson School of Management

Connections

42 connections

Industry

Information Technology and Services

Margaret Birnbaum’s Summary

I have over ten years of experience as an enterprise data modeler and data base designer. I have reviewed business requirements, performed data analysis, done gap analysis, developed logical data models and created first cut physical designs. I have also created mapping documents and developed and adhered to modeling standards.

Most recently I have been working as a contractor at Cisco Systems where I have designed enterprise logical and physical data models for implementation in the Cisco Data Warehouse and in the Engineering Quality area. I have experience with many different modeling tools, including Erwin and Oracle Designer.

Due to the breadth of my experience and my friendly personal style, I am highly effective with a wide range of people, from business unit managers to software developers. I have excellent communication and organizational skills. I prefer working in a team environment, but can work effectively independently when needed.

I have a strong understanding of data analysis and excellent communication skills. I learn new technologies quickly. I have strong analytical and organizational skills. I enjoy gathering business requirements and rules and documenting them for use by development teams. I am good at analyzing complex problem areas and recommending solutions.

Margaret Birnbaum’s Experience

• EDW Data Modeler

  NetApp

  (Public Company; NTAP; Information Technology and Services industry)

  July 2009 — Present (5 months)

  Creating logical and physical data models for the Enterprise Data Warehouse.

• Data Modeler and Database Designer

  Cisco Systems

  (Public Company; CSCO; Computer Networking industry)

  2004 — 2008 (4 years )

  Designed logical and physical data models for the Software Quality subject area.
  
  • Developed fully-normalized logical data model, including full meta-data and mapping to source data columns
  • Interviewed business managers to obtain business requirements
  • Designed physical tables for QBL Software (data warehouse for bug tracking and related data)
  • Designed fact and dimension tables for user reporting
  • Worked with database developers to implement schemas in Oracle and create ETL to load the data from source systems
  • Re-designed Bug Toolkit database structures for major re-design project to integrate bug data sourced from QBL
  • Performed data analysis and testing to identify and fix data integrity errors in source data
  • Followed corporate modeling and naming standards in all models

• Enterprise Data Modeler

  Cisco Systems

  (Public Company; CSCO; Computer Networking industry)

  2001 — 2004 (3 years )

  Created enterprise logical and physical data models, focusing on areas of Customer (Party), Location, Marketing Seminar, Market Segment, Sales Opportunity, and Sales Order for implementation in Cisco Data Warehouse.
  
  • Developed fully-normalized Enterprise logical data model, including full meta-data and mapping to source data columns
  • Designed first-cut physical design (server model) for Sales Opportunity project
  • Worked with database developers to implement schemas in Oracle and create ETL to load data from source systems
  • Designed fact and dimension tables for Order data on Bookings and Revenue
  • Interviewed business managers to identify business requirements
  • Reverse engineered existing Oracle databases into Oracle Designer, and analyzed data values to determine attributes and valid values
  • Worked with Corporate Data Architect to promote new target architecture
  • Re-wrote corporate modeling and naming standards and incorporated these standards into all models

• Senior Business Analyst / Data Modeler

  Netscape Communications

  (Public Company; Information Technology and Services industry)

  1997 — 1999 (2 years )

• Data Administration Manager

  Hewlett Packard

  (Public Company; HPQ; Computer Hardware industry)

  1983 — 1992 (9 years )

  Rapidly promoted throught a series of positions with increasing responsibility both in people management and scope of business within a large application development lab. The lab provided business applications for HP's worldwide Customer Support business.