Columbus, Ohio - Our most recent project is for Bank One. EIM employees are assisting Bank One in the development of CARS. The Customer Assist Reporting (CARS) Data Mart stores the daily activity that occurs in Customer Assist, VRU and other customer facing applications. These applications are used by the banking and call centers to support customer sales and service activities. Information about customer events such as reported problems, service requests, applications started, account openings, account closings, customer and account data changes, account and transaction inquiries, and monetary transactions performed in these applications are available in CARS. Acting as the data architect for CARS, EIM’s responsibilities include: analyzing and defining business information requirements from the client community; working with the DBAs to design a balanced system which is tuned to the needs of the Business users; lead data design efforts for all system changes and interactions with other systems including data sourcing requirements; establishing auditing procedures to ensure data integrity; establishing detailed data documentation (metadata) for CARS; maintaining the currency and accuracy of data documentation over time in the Metadata Repository (MDR); and conducting peer and client reviews of CARS specifications. A key CARS success was the development and implementation of a multi-dimensional version of the Contact Reporting Data Mart in less than two months.

Dayton, Ohio - Another recent project was for Reynolds & Reynolds.  The objective of this project was to provide a data warehouse to perform eCRM for Reynolds & Reynolds dealership customers.  At the core of this project was Campaign Administration, Campaign Management and Reporting.  EIM provided support to the project in the role of Data Warehouse Architect.  EIM's responsibilities included design and development of several Oracle 8i databases.  Alongside Reynolds & Reynolds employees EIM consultants developed the logical and physical database design.

Fort Lee, New Jersey - We completed a strategic data warehouse project for Toysrus.com designed to support the OLAP analysis of data from AMAZON.COM as well as any future sales partners.  EIM provided support to the project in the role of Data Warehouse Architect.  EIM's responsibilities included design and development of several Oracle 8i databases.  EIM consultants developed the logical and physical database design, developed and implemented a user-interface to user-maintained tables within Oracle, and provided training to the customer staff in data management and database design techniques.

New York, New York - We completed a project with NCR for the Bank of New York where we helped to develop a data warehouse which will provide bank management with a powerful tool for performing channel analysis, determining propensity to buy and measuring customer profitability.

Memphis, Tennessee - We completed a project for Union Planters Bank which implemented a system that will provide financial management reporting and analysis tools to bank personnel.  Our responsibilities included design, development and maintenance of several Teradata databases residing on an NCR 4700.  EIM developed the logical and physical database design, managed the physical database, consulted to the data sourcing, data transformation and application development teams, and developed and implemented a user-interface to user-maintained tables within the database

Buenos Aires, Argentina - The objective of this project for Banco De Galicia was to implement a DSS Data Warehouse that would provide customer account profitability measurement, marketing analysis, channel analysis, and organizational analysis tools to BGBA personnel.  EIM provided support to the project in the role of Senior Data Architect for the project.   EIM’s primary responsibility was to provide guidance and mentoring to project team and BGBA personnel in the development of several Teradata databases residing on NCR 4700 machines.  EIM personnel led the development of the logical and physical database design, developed a strategy for mapping the logical design to the various physical designs, and provided training in logical and physical design techniques.

Nashville, Tennessee - Another project was for First American National Bank to implement a DSS Data Warehouse and associated Data Marts that would provide customer account profitability measurement, marketing analysis, channel analysis, deciling, and organizational analysis tools to FANB personnel.  EIM provided support to the project in the role of Data Architect.  EIM's responsibilities included development and maintenance of several Teradata databases residing on NCR 4100, 4300 and 5100 machines.  EIM consultants developed the logical and physical database design, managed the physical database, developed and implemented a user-interface to user-maintained tables within Teradata, and provided training to the customer staff in data management and database design techniques.  A key component of this project was the need to reverse engineering of legacy systems into logical and physical database specifications.

Omaha, Nebraska - We completed a project for Inacom where we developed a data model of information to support their order management, invoicing, and inventory management processes.  A major accomplishment of the project was the development and implementation of a decision support data warehouse which will provide Inacom managers with the ability to easily review and analyze product sales and inventory data.

If you would like more information on these or other EIM projects please email contactus@eiminc.net.

About Us | Products & Services | News & Information | Projects | Employment | Links | Contact Us | Home

© 1999 - 2004 Enterprise Information Management, Inc.
Email : contactus@eiminc.net
Revised: February 28, 2004.