Project Manager Data

Frederick Lange

*** ******** **** ****: ***/***-*494

Cleveland, Ohio 44143-2912 **********@*****.*** Cell: 216/533-2852

OVERVIEW

• Leadership in Enterprise Data Architecture for Customer Relationship Management (CRM), Business

Intelligence (BI) and Data Warehousing, with different environments and platforms.

• Workshop facilitation to develop logical and physical data models that define business requirements for

OLAP, OLTP and hybrid business intelligence.

• Skilled in using metadata driven tools to develop databases, business applications and ETL.

EXPERIENCE

Key Bank, Cleveland, Ohio

Senior Data Architect, 2005 – 2009

• Enterprise Data Architecture: Developed strategies and solutions to enhance customer experience,

risk assessment and shareholder value using data architecture, including:

Governance Risk and Compliance Assessment

o o

Data Quality for CRM Data Asset Management

o o

Enterprise Data Model Training for internal Data Architects

o o

Metadata Driven Tools and Solutions Consulting to internal Software Development

o o

Service Oriented Architecture (SOA) Master Data Management

o o

Data Profiling

o

• Enterprise Data Warehouse Architecture: Redefined the data warehouse architecture based on a

service oriented strategy. Provided support to initiatives requiring data warehouse resources.

Independent Contracting, Cleveland, Ohio

Consultant, 2003 – 2004

• Plant Intelligence Architecture: Information Architect for designing a data architecture integrating

SAP R/3 with other vendor packages and internal applications to support a nuclear power plant fleet

dashboard with drill-down capability. (Adecco at First Energy Nuclear Operating Company)

• GIS Design: Database Modeler of a relational design for ordering and producing geographic

information. Also, developed dimensional designs for analyzing customer contacts, orders and manual

production efficiency. (Robert Half Technology at Geotrac)

• Data Warehouse Assessment: Consultant for assessing best practices applied to corporate business

intelligence on sales and income using a hybrid database design. (Robert Half Technology at MTD)

• Database Migration: Project Manager for the migration of SQL Server to DB2 UDB supporting

Internet meeting planning. Coordinated offshore conversion resources. (S&P Solutions at PlanSoft)

• CRM for E-Commerce: Team Leader of the technical design for initial data conversions, data

interfaces to legacy systems and customized reporting for the enterprise implementation of Oracle 11i

CRM worldwide. Coordinated offshore development and assisted with the business authorship of

functional requirements. (Deloitte Consulting at Diebold)

• E-Commerce Metrics: Database Modeler for Internet reporting and hybrid database design

supporting dashboard and scorecard metrics of customer usage, including two year trend and target

statistics for cable television management. (Robert Half Technology at EverStream)

Frederick Lange page 2

National City Corporation, Cleveland, Ohio

Information Architect, 2001-2003

Defined the enterprise relational database architecture. Led project related database development for application

software using the company system design methodology and enterprise architecture.

• Data Warehouse Business Intelligence: Led the development of a performance improvement plan for

ad hoc reporting with data access increased from four to 13 months.

• CRM Implementation: Defined the database architecture, business intelligence architecture, and data

integration plan for implementation of Argo Teller and CRM for all branches, contact centers, and loan

service centers. The revenue enhancement expected from the project is $50,000,000 per year.

• Data Model Development: Led the facilitated design and development of the data model for

managing origination of direct and dealer brokered consumer and small business loans with potential

annual savings worth $1,000,000 from dealer reserve settlement errors.

Oracle Corporation, Redwood Shores, California

Senior Principal Consultant for Service Industries, 1996-2001

Provided strategic and tactical direction to corporations and government agencies that used the Oracle

database, Oracle’s CRM software, and Oracle’s development software for e-commerce. Led model driven

application software development using the Oracle custom development methodology and led software

implementation using the Oracle application implementation methodology. Trained Oracle consultants and

Oracle partners in the CRM version 11i Trading Community Architecture (TCA) and in general database

concepts.

• CRM for E-Commerce: Facilitated development of a logical data model and data conversion design

for the Xerox North America migration to CRM 11i. Developed a logical data model for the Citibank

data migration to CRM 11i. Led development of a logical data model to define requirements for

improving CRM of a national information consortium of state and local Internet portals. Developed and

delivered CRM 11i logical data model and data migration topics for the Oracle University CRM

Quickstart training course

• Data Models for E-Commerce: Facilitated development of logical and physical data models to define

requirements of suspense accounting for the Defense Finance Administration Service. Led

departmental reporting system design, including development of prototypes and deployment of forms

on the Internet.

• Business Process Re-Engineering (BPR): Directed BPR of litigation management for the Injured

Worker’s Insurance Fund of Maryland. Developed logical and physical data models for claims

management, policyholder services agencies, and litigation. Developed a claims management

prototype.

• Prototype and Data Models: Developed a case management prototype with logical and physical data

models for labor dispute cases for the Michigan Bureau of Employment Relations.

• IT Infrastructure Management: Led development of logical and physical data models to define

requirements for analyzing infrastructure outage and planning capacity for the Defense Information

Systems Agency. Applied models to integrate graphic and text based configuration management

packages served by Internet distributed Oracle7 databases asynchronously replicated.

10/7/09

Frederick Lange page 3

• E-Commerce Development Organization Definition: Defined the application development

organization, two logical data models, and network computing architecture for developing and deploying

child welfare applications statewide using asynchronous database replication and Internet technologies.

• Physical Database Design Improvement: Improved the physical database design of the Cincinnati Area

Geographic Information Service permits management system to integrate with GIS and a document

management system.

Cap Gemini America, Cleveland, Ohio

Principal Consultant and Skill Group Leader, 1994 -1996

Managed a group of ten staff consultants in applying modeling techniques to application software development.

Led model driven application software development and implementation based on relational database technology

and using full life cycle methodologies.

• Information Strategy Planning: Conducted ISP for integrated hydrocarbon refining facilities.

Developed a dimensional data model to support analytic information needs for managing risk,

profitability, and marketing of a national finance company.

• Team Planning and Data Modeling: Developed data management team building plan and enterprise

logical data model with application to sales and marketing data warehouse, labor incentive, warehouse

management, and retail operations functions of an international food distributor and retailer.

ADDITIONAL EXPERIENCE

Setpoint, Houston, Texas, Senior Analyst for Plantwide Systems, 1991-1993.

General Electric, Cleveland, Ohio, Staff Consultant for Consulting Services, 1991.

Professional Support, Cleveland, Ohio, Systems Engineer, 1986-1991.

Ostendorf-Morris, Cleveland, Ohio, Information Architect, 1983-1985.

Case Western Reserve University, Cleveland, Ohio, Systems Analyst, 1982-1983.

Leaseway Information Systems, Cleveland, Ohio, Senior Programmer, 1981-1982.

EDUCATION

The Cleveland State University, Cleveland, Ohio

MA, Economics, BA, Social Science.

TECHNICAL KNOWLEDGE

Software:

Oracle: Designer, Oracle9i, Oracle 10g, CRM 11i, Pure Integrate, Siebel, PeopleSoft

IBM: DB2/OS390, DB2/UDB, System Architect with XT and Process Integrator

Sybase: PowerDesigner, Omni Server

CA: AllFusion ERwin, BPwin

Microsoft: Access, SQL Server, Analysis Services, OLE/DB, ODBC, Project, Visio,

SharePoint

Other: IEF, Aperture, Argo, XML, SAS, Business Objects, Cognos, Ascential (Vality),

webMethods, Informatica, Ab Initio

Software Development Methodologies:

Agile – Scrum, The Open Group Framework (TOGAF), Custom Development Method (CDM),

Application Implementation Method (AIM), Information Engineering (IE), Information Strategy Planning

(ISP), Universal Modeling Language (UML), Integrated Definition (IDEF).

10/7/09

Contact this candidate