APPLICATIONS

Banking

Health Insurance

Utilities

Transportation

Manufacturing

EXPERIENCE

Sid Adelman was with IBM for over 24 years. In his last positions he was a Consulting Systems Engineer and then a Senior Consultant. He now works primarily specializing in planning and implementing Data Warehouses and in establishing effective data architectures and strategies.

Sid has extensive experience designing and implementing data base systems at banks and savings and loans in the Los Angeles area over an 18 year period using both IMS and DB2. He was an IMS and a DB2 Specialist.

He was the IBM representative to the IMS Fast Path Project at GUIDE for two years. IMS Fast Path is a high capacity, high performance, and high availability Data Base Management/Communication System. As the representative to GUIDE and as a Systems Engineer, he worked with large companies, helping them design mission critical systems.

At the regional level, Sid supported IBM's application development (AD) strategy, working with over ten organizations to assess their AD environment and implement constructive steps to improve both the productivity and the quality of their AD process.

He jointly developed a methodology for assessing an organization's systems for security, availability, and performance and applied this methodology at a large hospital. The hospital had a variety of networked UNIX machines.

Sid led an Architecture Team composed of both consultants and clients for a Southern California utility. The team developed a technical architecture for data, communications, workstations, and hardware and software platforms. The target platform was UNIX. 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 management strategy at a large Transportation Authority.

Sid also 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 roll out. Theis S&L used DB2 for their initial Data Warehouse implementation.

He consulted on Data Warehousing with banks, distribution companies, utilities, governmental authorities, manufacturing companies, insurance, and the health industry.

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 a RDBMS.

Sid has 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. He assisted in developing a scope agreement that documented the function, schedule and responsibilities to be delivered in each phase of implementation. He helped the bank develop a metadata strategy to incorporate metadata from CASE tools, acquisition software, existing databases and files and the metadata from query tools. He assisted in the evaluation and selection of a RDBMS and of query tools. He worked with the bank to create a capacity plan for a multi-terabyte data warehouse.

Sid is currently working with two large health care organizations to plan and execute an enterprise data warehouse.

He has written and developed usable materials that facilitate a Data Warehouse implementation. These include: criteria for front-end tool selection, Data Warehouse implementation plans, criteria for DBMS 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 have been 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, migration products, DBMSs and repositories).

On a number of projects and in a wide variety of industries, he has spent considerable time with end users, understanding their businesses, determining and documenting their requirements.

Sid has skills in designing databases as well as in reviewing database designs. He has extensive experience in database performance: modeling performance, conducting design reviews, measuring performance and tuning in both IMS and DB2.

He jointly developed a methodology, MapXpert for Data Warehouse that provides a master plan for implementing 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," and "What it Takes to Build a Successful Data Warehouse."

He presented at DAMA, 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 and the United States, at the Catalog Management Conference and at the Customer Information System Users and Technical Conference.

He wrote articles for Data Base Management Magazine including "Is Your Company Ready for the New Application Development Organization?" and "Budgets in Unreal Time" for ComputerWorld, and "Organizational and Cultural Change for the Data Warehouse" for Database Programming and Design. The Journal of the Institute of Internal Auditors published his paper, "Assessing New Technologies," an article on the role of Internal Auditors in reviewing Client/Server, Distributed, and Downsized Systems. In 1996, Auerbach published his piece on preparing for the Data Warehouse. DM Review published "Data Warehouse Explosion" in the December, 1996 issue and "Data Warehouse Pilot and Prototyping" in the July/August issue.

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 is currently collaborating on a book with Larissa Moss titled "The Bare Essentials of Data Warehousing".

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 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.