DUNCAN CRANE 11 East Street, Southampton, MA

01073 (413) 527- 8321 home

duncan.crane@charter.net

Objective

A consultant role in corporate IT development as Data Architect / Data Modeler

Data Modeling Skills

Data Warehouse and Traditional OLTP Modeling:

Conceptual Models

Logical Models: Entity Level, Primary Key Level, Fully Attributed 3^rd Normal

Physical Models:

Reverse Engineering of Source Systems

Staging Area

Warehouse: Generalized 3^rd Normal Atomic ODS and Warehouse

Star Schema Data Mart: Conformed Dimensions and Fact Tables

Work with business staff to define reporting requirements

Work with business staff to build Conceptual and Logical Models

Work with IT support staff to reverse engineer source system Physical Models

Work with IT architecture and DBA staff to design Atomic Warehouse and Data Marts

Work with IT ETL staff to define source-to-target mapping and error processing

Work with IT architecture staff to define metadata requirements and delivery method

Education/Certification

Certified ERwin Trainer, Computer Associates (2000)

Data Warehousing In Depth, Ralph Kimball University (2000)

Master of Business Administration, University of Massachusetts (1988)

Bachelor of Science in Physics, Acadia University, N.S., Canada (1975)

Employment History

Mass Mutual Financial Group, Springfield, Massachusetts

Consultant (contract basis), Data Modeler (8/07 to present)

Aetna Health Insurance, Middletown, Connecticut

Consultant (contract basis), Data Architect (3/07 to 7/07)

Konica Minolta Business Solutions, Windsor, Connecticut

Consultant (contract basis), Data Architect (7/06 to 1/07)

Time Warner Cable, Charlotte, North Carolina

Consultant (contract basis), Data Architect (4/06 to 6/06)

Stanley Tools, New Britain, Connecticut

Consultant (contract basis), Data Architect (10/05 to 3/06)

ING, Americas Financial Services, Hartford, Connecticut

Consultant (contract basis), Data Architect (5/04 to 9/05)

Avery Dennison, Framingham, Massachusetts

Consultant (contract basis), Data Architect (1/04 to 4/04)

ING, Americas Financial Services, Hartford, Connecticut

Consultant (contract basis), Data Architect (5/03 to 1/04)

Computer Associates, Princeton, New Jersey

Consultant (contract basis), Quality Assurance – ERwin (6/02-9/02, 11/02-4/03)

CIGNA, CIGNA Health Care, Bloomfield, Connecticut

Consultant (contract basis), Data Architect (7/00-12/01, 3/02-4/02)

CIGNA, Retirement & Investment Services, Hartford, Connecticut

Employee, Data Architect (10/98-7/00)

CIGNA, Retirement & Investment Services. Hartford, Connecticut

Consultant (contract basis), Data Modeler, VB Programmer (5/95-6/98)

Blue Cross Blue Shield of Connecticut, North Haven, Connecticut

Consultant (contract basis), VB Programmer (7/94-11/94)

Farm Credit Bank, Springfield, Massachusetts

Employee, Project Leader, Analyst, Programmer (1/80-6/94)

Notes on Development Projects

Mass Mutual Financial Group, Springfield, Massachusetts - 8/07 to present

Member of enterprise data modeling team supporting various modeling activities; help set up standard modeling practices and use the Computer Associates Allfusion Erwin data modeling tool.

Aetna, Middletown, Connecticut – 03/07 to 07/07

Participated as data architect and data modeler on data warehouse project for health insurance carrier. Prepared a logical/business model of project requirements in preparation of moving Member, Product and Plan source data into strategic generalized data warehouse. Utilized Computer Associates Allfusion Erwin data modeler v 7.

Konica Minolta, Windsor, Connecticut – 07/06 to 01/07

Developed data model for web-based print job management application. Application supports flexible user entry of print shop ticket templates; print job entry; print job workflow. Compatible with printing industries JDF XML document standards. Utilized Embarcadero’s ER Studio data modeling tool.

Time Warner Cable, Charlotte, North Carolina – 4/06 to 6/06

Conducted logical data modeling sessions with subject matter experts; prepared logical data model; prepared corresponding physical data model, all for a cable subscriber data warehouse. Utilized Computer Associates Erwin data modeling tool.

Stanley Tools, New Britain, Connecticut - 10/05 to 3/06

Hired as a consultant to create and maintain conceptual, logical and physical models for source systems, warehouse and data marts for three data mart projects in a tool and hardware manufacturing environment. Utilized the PowerDesigner data modeling tool.

ING Americas Financial Services, Hartford, CT - 05/04 to 09/05

Hired as a consultant Data Architect in ING's TMO (Technology Management Organization) department.  The TMO is a central architectural department that drives enterprise wide projects and supports other departmental level projects.  Involved in two different projects that moved application data into central data warehouse.

Avery Dennison, Framingham, MA - 1/04 to 4/04

As a consultant member of a team, acted as resource for Computer Associates ERwin data modeler tool. Provided training on reverse engineering features of the tool and methods. Reverse engineered a legacy order entry application database. Created a logical data model of Customer subject area.

ING Americas Financial Services, Hartford, CT - 05/03 to 1/04

Hired as a consultant Data Architect in ING's TMO (Technology Management Organization) department. Involved in four different projects: non-financial Defined Contribution Data Warehouse using IBM's generalized EII design; star schema data mart for Workflow and Imaging application; upgrade to a field office web-base sales quote system; Configuration Management Database model.

Computer Associates, NJ – 06/02 to 09/02 and 11/02 to 4/03

As a member of a quality assurance team, took part in testing of new versions of ERwin. Also conducted training sessions in data modeling concepts including star scema design and use of ERwin to assist the quality assurance team with Computer Associates logical and physical data modeling certification.

CIGNA, Bloomfield, CT - 03/02 to 04/02

As a Data Architect developed logical and physical data model for a medical claim history data mart to be used in support of litigation. Built logical model that consolidated the definitions and data structure of claim and provider data to be loaded from three legacy systems. Established query requirements, logical-to-source mapping, design criteria/constraints and physical model in ERwin and then DDL.

CIGNA, Bloomfield, CT - 05/01 to 12/2001

As a Data Architect on a data warehouse and data mart development team, assisted with warehouse metadata repository design and use; data mart design; warehouse to mart loading process design; design and maintenance of lookup code tables. Warehouse was large in scope and utilized the generalized data model approach. Worked on complexities of pulling historical data from the generalized designed warehouse and loading into highly denormalized star schema data mart.

Notes on Development Projects (continued)

CIGNA, Bloomfield, CT - 07/00 to 04/01

As a Data Architect developed numerous logical and physical data models for Product Design and Sales Strategy projects. Designed and built a database of data mapping metadata to coordinate the data design of a five project, multi-release health care Customer Inquiry program accessing a couple dozen existing source systems, including a Sales star schema data mart.

CIGNA, Hartford, CT - 10/99 to 7/00

As a Data Architect developed numerous logical and physical data models for pension division. Reverse and forward engineered between ERwin and DB2, UDB and MS SQL Server. Began the process of setting up standard logical and physical data design procedures. Mentored development teams (programmers, business analysts, DBA’s, project leaders) on use of various logical and physical design documents and activities.

CIGNA, Hartford, CT - 10/98 to 10/99

Wrote development cycle guidelines for major department in pension division, defining all potential phases, deliverables, activities, roles and responsibilities of software development projects. Guidelines were defined in a Microsoft Access database model that allowed flexible reporting of activities by role, deliverables by activities, etc. Obtained technical and business approval of guidelines. Mentored technical and business staff in use of guidelines. Developed a number of logical and physical data models for various business areas.

CIGNA, Hartford, CT - 5/97 to 6/98

Served as session facilitator and data modeler on a three project effort to redesign the investment accounting function of a pension provider. Coordinated and reconciled the overlapping three project data model. Defined Information Engineering deliverables for scope, logical design and physical design phases of development that emphasized the key role of data and process as it evolves through the full development cycle. Conducted as-needed data modeling training for business and systems people utilizing the ERA (Extended Relational Analysis) method and the ERwin tool.

CIGNA, Hartford, CT - 10/96 to 4/97

Served as methods coach and session facilitator for the logical design phase of a pension payment application project. Defined and directed the building of the Business Model - the key deliverable of the logical design effort. Business Model document consisted of: an ERwin data model following the ERA data modeling method; functional decomposition; activity definition sheets; sample entities for all major and minor entities; example pages for critical processes; high level process flow diagram; and a data dictionary. Taught business modeling techniques to a team of 5 system and 10 business people, and lead a series of intense joint design sessions extending over a 12 week period that was credited with establishing a high level of cooperation and understanding among team members.

CIGNA, Hartford, CT - 5/95 to 10/96

Designed and programmed Visual Basic 3.0 screens and transaction processing modules for the on-line client-server based receipt identification activities associated with pension management. The application was designed to be run by 300 concurrent users at two physical locations. The data was modeled using the ERA method. Visual Basic controls used included FarPoint's Spread/VBX grid, Video Soft's tabs/panels and various Crescent controls. Other VB tools included Intersolv's Q+E for development data access and Sheridan's VB Assist. Reports were written in Crystal 4.0 and called from a VB request screen

via Crystal print engine API's.

Blue Cross Blue Shield of Connecticut, North Haven, CT - 7/94 to 11/94

Designed and programmed Visual Basic 3.0 screens for the on-line client-server based prior authorization activities associated with health insurance. The application supported on-line lookup of key patient, doctor and insurance group information on mainframe DB2 databases, allowing authorization of services to be done in minutes rather than days. Use was made of Spread VBX, Crescent controls and Q&E Lib to access the host data. ERA data modeling and function decomposition methods were used. Supported the user in development of test plans and on-line help.

Farm Credit Banks of Springfield, Springfield, MA - 1/80 to 6/94

Designed, programmed and managed a number of multi-year, multi-programmer development efforts - general ledger, loan accounting, credit decision and cost of debt. In the PC environment, Visual Basic 3.0 and Clipper 5.0 were used. ERA data modeling and data flow diagramming methods were used. Made extensive use of formal phased development methods to control analysis, design, coding, testing and implementation activities. Coordinated annual company wide hardware/software computer platform planning activities.