|
|
S I D A D E L M A N
 Sid
Adelman is a Principal in Sid Adelman & Associates, an organization
specializing in planning and implementing data warehouses and in
establishing effective data architectures and strategies. He
consulted on data warehouse with banks, distribution companies,
utilities, governmental authorities, manufacturing companies,
insurance, and the health care industry. Sid has been involved with
data warehouse and its predecessors before the term itself was
coined.
Sid worked for IBM as a systems engineer for 24 years. He attained
the position of consulting system engineer, at that time the highest
designation for this role.
On a
number of projects and in a wide variety of industries, he has spent
considerable time with business management and end users,
understanding their businesses, determining and documenting their
requirements, and focusing on integrating their diverse data
environments and developing a data strategy.
Sid led a team to gather data warehouse requirements for a large
mutual fund company. The team identified data and tool requirements,
developed an initial implementation plan and defined roles and
responsibilities. They also generated a cost/benefit scheme and
provided recommendations for a successful data warehouse
implementation. He managed a data warehouse team responsible for the
extract/transform/load process, for data quality, for information
delivery and peripherally for performance. Sid led a team to assess
an existing data warehouse including the performance, the quality of
the data, the timeliness of the data and how well the data warehouse
supported the needs of the business partners.
He jointly developed a methodology for assessing an organization’s
systems for security, availability, and performance and applied this
methodology at a large hospital. Sid worked with two health care
organizations to plan and execute an enterprise data warehouse with
an emphasis on the need to implement a data quality program and
support the enterprise data warehouse with metadata.
Sid led an Architecture Team composed of both consultants and
clients for a large utility. The team developed a technical
architecture for data, communications, workstations, and hardware
and software platforms. A major deliverable of the team was a
comprehensive RFP for Financial Systems, Human Resources and
Environmental Systems. He was part of the team that evaluated the
RFP responses. The technical architecture became the basis for the
development of an infrastructure upon which the new systems were
built.
He consulted and helped develop a data strategy at a large
Transportation Authority. The strategy included the choice and use
of the RDBMS, security, availability, performance, the organization
to support the strategy and the processes to measure the
effectiveness of the data management.
Sid worked and consulted on the implementation of a large data
warehouse at a major Savings and Loan. He organized and ran a
comprehensive database design review prior to the large scale
rollout.
He helped clients plan for major data warehouse implementations
including developing a data strategy and incorporating it in an RFP
for vendor selection. He worked with a large organization in the
health care industry to develop goals and objectives for the data
warehouse, established roles specific to the data warehouse and
specific to that organization and jointly developed a detailed
implementation plan.
In a large and highly distributed non-profit organization, Sid
assessed the skills and infrastructure required to develop a major
new system, identified the critical components that were lacking,
and recommended and helped plan the strategy necessary to build the
new system. These included staffing, training, tools, utilities,
user involvement, hardware, justification, and internal selling. He
led the client in the evaluation and selection of an RDBMS.
Sid worked with a large bank in the development and implementation
of a large marketing data mart. He was instrumental in architecting,
planning and staffing the bank’s first major data warehouse effort.
Sid was instrumental in developing a scope agreement that documented
the function, schedule and responsibilities to be delivered in each
phase of implementation. He co-authored the bank’s metadata strategy
to incorporate metadata from data modeling tools, acquisition
software, existing databases and files and the metadata from query
tools. He was a major participant in the evaluation and selection of
a RDBMS and of query tools. He helped the bank create a capacity
plan for a multi-terabyte data warehouse.
He worked with a large health care insurer to develop a metadata
architecture that was to become an integral part of the
organization’s overall data warehouse architecture.
He worked with a large electric utility to understand and document
requirements, create roles and responsibilities, cost/benefit
analysis, planned an enterprise data warehouse and identified a plan
for training and user support. He mentored the project manager and
her direct reports.
He developed usable materials that facilitate a data warehouse
implementation. These include: criteria for front-end tool
selection, data warehouse implementation plans, criteria for RDBMS
selection, data warehouse roles and responsibilities, goals and
objectives, critical success factors, questions for users to
determine requirements, guidelines for distributing data, framework
for design reviews and a methodology to improve data quality. In all
cases, these materials were tailored to each client.
He understands the software requirements for major systems and has
assessed those software needs for clients. This includes which
categories of tools needed (front-end tools, data quality tools,
extract/transform/load products, RDBMSs and metadata repositories).
Sid has extensive experience in database performance: modeling
performance, conducting design reviews, measuring performance and
tuning.
He jointly developed a methodology, MapXpert for Data Warehouse
that provides a master plan for implementing a data warehouse.
Sid has developed, consulted and presented on topics including
"Organizational and Cultural Change to Support Application
Development," "Establishing a Target Application Environment,"
“Developing a Data Strategy,” Data Warehouse Data Quality, and "What
it Takes to Build a Successful Data Warehouse."
He has been a regular speaker at DCI’s Data Warehouse Conferences in
the “Building a Better Data Warehouse” track and a regular speaker
at IBM’s Data Management Conference. Sid conducts a Data Warehouse
Project Management seminar for The Data Warehouse Institute. He
presented at DAMA, Data Resource Management Association, GUIDE, and
SHARE/GUIDE in the United States, Australia, the Philippines, and
Hong Kong. He presented at Data Warehouse conferences in Great
Britain, Holland, Germany, Canada and the United States, at the Data
Quality Conference, the Catalog Management Conference, the Business
Intelligence Pharmaceutical CRM Conference, and at the Customer
Information System Users and Technical Conference. He will be
speaking this year at the Teradata Partners Conference on Data
Warehouse ROI, and at the Enterprise Data Forulm on Developing an
Enterprise Data Strategy.
Sid is a
founding member of the Business Intelligence Alliance whose members
include Colin White, Herb Edelstein, Larry English, David Foote,
Douglas Hackney, Pieter Mimno, Neil Raden and David Marco.
Membership in the Business Intelligence Alliance gives Sid Adelman &
Associates access to the acknowledged best resources in data
warehouse.
Sid chairs the “Ask the Experts” column on
www.dmreview.com.
He is a member of the IBM Gold Group, consultants who participate in
periodic advanced briefings by the IBM developers and labs and
advise IBM on direction for their data products including DB2 and
IBM’s data warehouse offerings. Sid is also a member of Friends of
Teradata, a select group of consultants who are invited to learn
about current and future Teradata features and capabilities.
Sid has an MBA in Business Economics from UCLA and is a member of
the Life Office Management Association with a specialty in Data
Processing. He is active in the Los Angeles Chapter of the Data
Administration Management Association.
Data Warehouse Applications
Publications
He
published articles in Data Base Management Magazine, ComputerWorld,
Database Programming and Design, The Journal of the Institute of
Internal Auditors, Journal of Data Warehousing, Auerbach, Data
Warehouse Report, Teradata Magazine and Sid is a regular contributor
to DMReview. He has white papers on Data Warehouse ROI and
Benchmarking Data Warehouse on the Teradata web site, a white paper
on “The Seven Secrets of a Successful BI Implementation” on the
Sybase website and an article on Data Warehouse Standards published
by the Cutter Consortium. See the “Articles” tab for a more complete
list of publications and links to these materials.
He contributed two chapters to the book Data Warehouse: Practical
Advice from the Experts. The chapters are Organizational and
Cultural Issues of the Data Warehouse and Data Quality. He
co-authored Data Warehouse Project Management with Larissa Moss,
published by Addison Wesley in 2000. Sid’s second book, Impossible
Data Warehouse Situations and Solutions from the Experts, published
in 2002 has contributions from Joyce Bischoff, Jill Dyche, Doug
Hackney, Sean Ivoghli, Chuck Kelley, David Marco, Larissa Moss, and
Clay Rehm. His most recent book, Data Strategy, co-authored with
Larissa Moss and Majid Abai, was published in 2005.
Clients
-
Allegheny Energy – Greensburg, Pennsylvania
-
American Century Investments – Kansas City, Missouri
-
Bertelesmann - New York
-
Blue
Cross/Blue Shield of South Carolina – Columbia, South Carolina
-
Cedars Sinai – Beverly Hills, California
-
Countrywide – Pasadena, California
-
DIRECTV – El Segundo, California
-
Eli
Lilly - Indianapolis, Indiana
-
Great Western Savings – Northridge, California
-
Home
Savings of America – Irwindale, California
-
Hawai’i Department of Education – Honolulu, Hawai’i
-
IBM
– Los Angeles, California
-
Jackson Energy Authority – Jackson, Tennessee
-
Kaiser Permanente – Pasadena, California
-
Mammoth Mountain – Mammoth Lakes, California
-
Metropolitan Transportation Authority – Los Angeles, California
-
Metropolitan Water District – Los Angeles, California
-
MusicLand – Minneapolis, Minnesota
-
NationsBank – Charlotte, North Carolina
-
Sentara Medical Group – Norfolk, Virginia
-
Society of Human Resource Managers – Alexandria, Virginia
-
Southern California Gas Company – Los Angeles, California
-
Student Assistance Foundation - Helena, Montana
-
ThedaCare – Appleton, Wisconsin
-
The
Principal – Des Moines, Iowa
-
Prudential – Livingston, New Jersey
-
UNIFI Insurance – Lincoln Nebraska and Cincinnati, Ohio
-
Universal Music – Universal City, California
-
Western Digital – Irvine, California
Sid Adelman & Associates
4068 Weslin Ave.
Sherman Oaks, CA 91423
818 783 9634
sidadelman@aol.com
sid@sidadelman.com
|
