Clients
JP Morgan Chase, Merrill Lynch, IBM, AT&T, United Nations, TD Waterhouse, Lehman Brothers, Marsh & McLennan, AIG, CS First Boston, Wagner Electric, Coopers & Lybrand, Verizon, Westinghouse, Manufacturer's Hanover, NYC, Gibbs & Cox Naval Architects, Equitable Life and Genentech
Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, Operational Datastore Design, Datamart Design, Metadata Management
Contact Information
Phone: 917-612-6960
Email: DavidGrossman@AmericanInformationEngineering.com
Merrill Lynch (2005 - 2006)
Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development. Organization of all existing data models, data flows and data dictionaries into a MetaData Repository. Creation of current physical models of all databases and logical models of strategic customer and product databases.
Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
Redesign of the key structures of Merrill’s central institutional client database.
Genentech (2005)
Designed a comprehensive IT Asset Data Model capturing key information about CIT assets and their inter-relationships to support the development of Genentech’s Enterprise Architecture Repository and Services.
J P Morgan Chase Investment Bank (2003 - 2004)
Designed the Information Model for transformation of the Traditional Credit Product infrastructure.
NYC Office of Payroll
Administration (2003)
Responsible for assessing the architecture of all the databases to be deployed in NYC’s new web enabledtime and attendance system that will eventually be used by all 300,000 plus city employees.
TD Waterhouse (2001-
2002)
Lehman Brothers (2001)
Logical and physical database design for the commercial mortgage loan system.
J P Morgan Chase Private Bank (2000-2001)
Data Architect
for Internet Data Aggregation. Provided data models and data maps (extract,
transform and load analysis) of the datamarts and feeder systems in the
aggregation effort. Designed and
implemented a Metadata Repository providing a centralized information
source for the data models, data maps, processes, documents, contact lists,
project calendars and issues affecting the Chase/Morgan merger.
IBM (2000)
Logical and physical database design for an OLTP internet business to business communications and information system designed to help major financial institutions find, negotiate and agree to custom-tailored complex investment instrument transactions such as futures, options, swaps and other derivatives.
Designed logical and
physical data models for the Web based global
broking system
Chase Manhattan Private Bank (1996–99)
Data Warehouse design
for the corporate data repository.
Datamart design (star schema) for the OLAP Web based compass investment management system.
Designed the data model for VISTA Funds (assets over $25 billion) Management Information System.
Reversed engineered
the data structures of the global
investment management system, esprit relationship management system, navigator
peformance management System, investment analytics system, national depository
system, winner relationship reporting system, polaris relationship management
system. Provided the data models
as Web pages.
Provided mappings between the amtrust tax and securities system, the shear tax and securities system, the global investment management system and the corporate data repository to assist in Chase/Chemical merger decisions and source feed creation.
Designed the Metadata Workstation data model, a Metadata Repository providing mappings between all logical models, physical models, systems, databases, processes, procedures, organizations, people, projects and activities.
Designed Metadata Workstation, a Metadata Repository providing mappings between all logical models, physical models, systems, databases, processes, procedures, organizations, people, projects and activities.
American International Group (1995-96)
Manager of Data Architecture. Responsible for the Corporate Data Model, the Enterprise Client/Server Case Tool, CASE methods and procedures, development of data models and reverse engineering of production systems.
Credit Suisse First Boston (1994–95)
For Data Administration: evaluated mainframe and workstation components of Seer’s HPS Case tool.
Converted all of the corporation’s forty nine data models from IEF to Seer HPS.
Created data models for six new systems.
Administered mainframe/workstation CASE environment.
Verizon (1993-94)
For Verizon’s Work Center Database Integration project: Recommended Information Strategy and Business Area Analysis plans. Provided Current Process Workflow analysis, Business Function/System Matrix, Data Inventory and Data/System Matrix.
Designed a Data Warehouse to replace seven legacy databases.
AT&T Chief Financial Officer Organization (1993)
Performed business analysis, logical and physical database design using CASE tools for AT&T Corporate wide legal and managerial consolidated financial statements. Provided a data architecture designed to eliminate discrepancies in managerial and legal results.
AT&T General Business Systems (1992-93)
Co-authored the Feasibility Study for a national enterprise relational database, a Data Warehouse to provide decision support in a distributed environment. Involved in EDI message definition process. Selected a networked CASE tool, a DBMS platform and designed the data warehouse. Provided a CASE strategy and methodology to support the business system life cycle in key corporate projects. Appointed data architecture liaison in the merger of AT&T General Business Systems with AT&T Business Communications Systems.
United Nations (1992)
Designed a Data Warehouse (SQL Server) to be fed from sixteen legacy systems for the Capital Development Fund.
AT&T Network Systems (1991-92)
As a member of AT&T's corporate wide Data Stewardship Program, reverse and forward engineered the Automated Comcode Assignment System, which assigns AT&T's part numbers. Using CASE, mapped and defined all data elements, records and databases of the system's four databases. Analyzed all data synonyms, and created standard relational and business names for the data. Developed the system's logical model and generated the item data server as a replacement relational database. Proposed a development platform and migration strategy.
AT&T Materials Support (1989-90)
Set up a development platform for the common distribution center system. Evaluated, recommended and installed a CASE tool. Administered the project's shared CASE repository. Evaluated, recommended and installed a DBMS. Designed and generated the database. Provided a multi-operating system environment.
ARC Medical and
Professional Personnel (1988)
Evaluated, recommended and implemented a hardware and software platform to support billing, accounts receivable and mechanized office. Software package customization, system integration and screen design.
AT&T Consumer
Products (1984-88)
Developed a Corporate Information Model. Assisted in the enterprise-wide planning of data by assessing current and future information requirements via user interview and record analysis techniques, capturing all information in the corporation's first major use of a CASE tool. Created a data architecture by clustering the entity-relationship model into subject databases. Used the Corporate Information Model to plan and develop the Logical Database Designs for many new systems. Created Logical/Physical Database Designs for the:
marketing analysis and reporting system; the corporation's largest relational database, a Teradata data warehouse designed to analyze the market behavior of 60,000,000 customers.
combined marketing system; A relational design derived by reverse engineering AT&T Communications
marketing data structures and consolidating the implied logical model with AT&T Consumer Products' Marketing and Analysis Reporting System logical model.
mechanized problem tracking system; Handles reporting and resolution of the nationwide 5000 hardware, network and software problems/month. AT&T Consumer Product's first large relational database.
financial reporting system; Designed for both hierarchical and relational target DBMS's.
resident interface processing system; Canonical synthesis of 110 requirements into a relational model.
message broadcast system; Provides inter-system communications for the Inventory System.
product database; a data warehouse designed to provide product related decision support.
special needs application processing system; Order processing for tariffed handicapped products.
service location management system; Provides lease administration for the Phone Centers.
Created CASE data dictionaries and logical models of the customer service system, which provides corporate billing, and the transaction monitor, which captures and routes all Phone Center transactions.
Consolidated the databases of the inventory tracking evaluation and management system and the
material logistics interface system using reverse engineering and logical modeling methods. Created a CASE repository for the IMS data structures of both systems. Developed a logical model of each system and then the combined logical model. Modified this logical model for performance and used CASE to automatically generate the database schema for the new items/mli consolidated system.
Developed mainframe CASE tool to PC CASE tool interface to allow data inventories from ongoing development projects to be merged into corporate repository. Developed CASE tool to mainframe Data Dictionary interface to allow company's first automated database schema generation.
Wagner Electric Corporation (1982-84); System redesign of the parts replenishment system. Performance optimization and data dictionary development of the sales and marketing database. System design, database design and database administration of the warranty reporting system. Published a database performance optimization manual which included general tuning concepts and procedures as well as database specific tuning procedures.
Coopers & Lybrand (1982); Design and programming of the land bank benefits statement
New York Telephone
(1981-82);
Designed and programmed components of the furniture
inventory system
Westinghouse Electric Corporation (1980-81); Designed an on-line escalator design system, including procedure definition, dialog design, database design and database administration.
Manufacturer's Hanover Trust Company (1979–80); System testing of the overdraft interest system for international corporations.
Yourdan Inc. (1979); Instructor in Structured Design & Programming.
NYC Board of Education (1976–78); Reporting to the Director of Data Processing,
installed and customized IBM’s budget accounting information system for large institutions.
Merrill Lynch Pierce Fenner & Smith (1975); System analysis, design and programming of the
new commission schedule system and the mutual fund system.
NYC Human Resources Administration (1974); Debugging of the welfare system.
NYC Urban Renewal
Management Corporation (1974); System testing of the accounts
receivable system.
Gibbs & Cox Naval
Architects (1973–74);
System design and programming of the job
cost accounting system.
Equitable Life Assurance Society (1970–72); Programming of the on-line customer application
processing system, the tax information system, and the new policy system.
Organization membership: Data Management Association, American Society of Media Professionals, American Society of Composers Authors and Publishers, Mensa