Robert W. Klimek *** Bennett Drive

Carol Stream, IL 60188

707-***-****

acems0@r.postjobfree.com

Introduction

As a seasoned enterprise, data, and solutions architect and developer with

over twenty five years of experience in the planning, analysis, design and

implementation of information systems, my focus is on

. identifying, clarifying, and prioritizing business, systems, and

technical strategies and objectives

. defining enterprise-level standards, policies, and procedures to ensure

consistently high-quality applications and systems deployments

. developing data (ER and Dimensional), process, and object models using

major modeling tools such as ERWin, ER/Studio, and Rational Rose

. specifying data-based solutions and architectures, from both a user and a

technical perspective, to meet stated requirements, using major database

management technologies such as Teradata, Microsoft SQL Server, and

Oracle, as well as open standards such as XML

. developing databases and process components in specified technologies

Representative Experience

Tata Consultancy Services - 4/2012 to Present

PepsiCo, Chicago, IL - 9/2013 to present

Data Modeler/Architect

. Develop Functional Design documents to interface various data sources

with the company's new Teradata-based Master Data Management (MDM)

database

. Prepare MDM data standards

. Develop logical and physical models representing target database objects

in MDM

. Perform source-to-target mapping from source systems to newly developed

database objects

. Prepare acceptance testing and system testing scripts against interface

specifications

. Maintain metadata in line with MDM standards, requirements,

specifications, and implementations

ACNielsen, Schaumburg, IL - 4/2012 to 8/2013

Data Modeler/Architect

. For Nielsen's Consumer Package Group, participated in the company's BASES

(Booz Allen Sales Estimating System) project, aimed at developing the

next generation of applications to serve the concept assessment process

. Developed initial logical data models, using Embarcadero's ER/Studio,

based on business requirements and system design artifacts and generated

the corresponding physical models and T-SQL DDL scripts

. Revised models as requirements surfaced, in line with the company's Agile

development methodology

. Performed metadata management activities using the ER/Studio Repository

Independent Consultant - 5/2002 to 3/2012

Wells Fargo Internet Services Group, San Francisco, CA - 12/2006 to 3/2008

Data Modeler/Architect

. Responsible for the development, care, and maintenance of logical and

physical ERWin data models, along with corresponding metadata, to support

Wells Fargo Online Applications.

. Worked with Teradata Database Administrators to develop effective and

efficient database implementations in conjunction with Data Warehousing

and Business Intelligence applications.

. Analyzed and developed ETL procedures using relational, flat-file, and

XML technologies

. Developed approaches and frameworks for the enhancement of data quality

and integrity

APL Limited, Oakland, CA - 12/2005 to 9/2006

Enterprise Architect/Data Modeler

. Worked with internal enterprise architects and KPMG consultants,

assisting in the development of current and target state enterprise data

architectures

. Worked with project team representatives to ensure that logical and

physical ER/Studio data models were developed in line with corporate

standards and guidelines

. Developed and delivered classes in beginning, intermediate, and advanced

logical and physical data modeling and the use of the ER/Studio modeling

tool

. Developed an Access-based "mini-repository" to help the Enterprise

Architecture team track the similarities and differences between the

current and future states

Genentech, Inc., South San Francisco, CA - 4/2005 to 11/2005

Data Analyst, Commercial Data Governance

. Developed a detailed conceptual model for the company's sales and

marketing arm using Embarcadero's ER/Studio; modeling sources included

existing reports, data structures, and XML schemas

. Mapped conceptual model concepts to existing systems and data structures,

as well as to newly-implemented ERP suites

. Developed and maintained organization-wide business and systems data and

information standards, working with project teams to develop business

solutions in line with those standards

Plan B Solutions, Newport Beach, CA - 11/2003 to 12/2004

Data Architect

. Developed the Universal Business Architecture, a comprehensive data and

process model, deploying the Rational Rose data modeler and describing

the operations functions for the electrical utility's Transmission and

Distribution (T&D) division

. Facilitated information gathering and modeling sessions with subject

matter experts to validate and enhance the models

. Planned future application consolidation activities, developing an

approach to integrate 100+ applications into a common enterprise

solutions architecture

Kaiser Permanente, Walnut Creek, CA - 10/2002 to 11/2003

Enterprise Architect, Information and Data Quality

. Developed a comprehensive enterprise process for the deployment of

Information and Data Quality efforts throughout the Kaiser organization

. Consulted with project teams deploying IQ and DQ concepts to ensure

compliance with the corporate process and to build new learnings into the

process itself

. Reviewed corporate standards and models, as well as logical and physical

data models and definitions of existing and proposed applications

. Defined quality standards for data warehouses and marts, along with those

for the newly acquired Epic ERP application

R. R. Donnelley & Sons, Downers Grove, IL - 5/2002 to 10/2002

Data Architect

. Developed logical data models for the operations business area, using

ERWin

. Reviewed enterprise data and process models for adherence to standards,

currency, and applicability to major application and database deployments

. Assessed Oracle 9i database designs for faithfulness of implementation of

corporate data standards, business rules, and managed redundancy

. Wrote standards for logical modeling and the deployment of the ERWin data

modeling tool

Navigant Consulting - 5/2000 to 5/2002

Principal Consultant, Internal Projects - 2/2001 to 5/2002

. Developed standards, policies, and procedures for Enterprise, Data, and

Applications Architectures

. Wrote and delivered consulting proposals

. Mentored junior staff and prepared performance evaluations

McDonald's Corporation, Oak Brook, IL - 6/2000 to 2/2001

Enterprise Data Architect, Supply Chain Data Warehouse

. Developed an integrated supply chain data and process model using Oracle

Designer 2000

. Developed the technical architecture and design for McDonald's product

mix (PMix) systems and data warehouse, including data structures,

application interfaces, ETL specifications, and the underlying technical

infrastructure. Assisted project managers to ensure conformance to the

design. Database was developed using Oracle 9i.

Independent Consultant - 7/1990 to 5/2000

Bank One, Columbus, OH - 11/1999 to 4/2000

Systems/Data Architect, State of Ohio Child Support Payment Data Warehouse

Motorola, Radio Systems Network Group, Schaumburg, IL - 11/1998 to 11/1999

Project Manager/Architect, Clarify Implementation

First Health, Downers Grove, IL - 7/1998 to 11/1998

Project Manager, Financial and Payroll Systems

McDonald's Corporation, Oak Brook, IL - 5/1997 to 6/1998

Enterprise Architect

Architect -- Data Warehouse Standards, Policies, and Technologies

Allstate Insurance, Northbrook, IL - 5/1996 to 4/1997

Data Analyst, Enterprise Planning and ERP Systems

Data Warehouse Architect

Moore, Business Forms and Systems Division, Lake Forest, IL - 8/1994 to

4/1996

eBusiness Modeler/Applications Developer, Customer Management Systems

Helene Curtis, Inc., Chicago, IL - 1/1996 to 4/1996

Data/Process Analyst, Risk Management and SAP Implementation

Follett Campus Resources, Forest Park, IL - 2/1994 to 7/1994

Data Architect and Applications Developer, Warehousing and Employee

Management

QuadGraphics, Pewaukee, WI - 5/1993 to 12/1993

Data Architect/Applications Developer, Production Management

Kohl's Department Stores, Menomenee Falls, WI - 9/1992 to 4/1993

McDonald's Corporation, Oak Brook, IL - 1/1992 to 8/1992

Methodology Consultant, Strategic Planning and Human Resource Management

Sears Credit, Chicago, IL - 7/1990 to 12/1991

Strategic Planner/Consultant

James Martin and Company - 4/1987 to 7/1990

Pacific Gas & Electric, San Francisco, CA - 4/1990 to 7/1990

Data and Process Analyst, Financial Systems

United Airlines, Elk Grove Village, IL - 7/1989 to 4/1990

Strategic Planner/Consultant, Airline Operations

Shell Canada and Imperial Oil, Ltd, Calgary, AB and Toronto, ON - 9/1988

to 7/1989

Data and Process Analyst/System Designer, Sales and Customer Management

Xerox Corporation, Rochester, NY - 12/1988 to 4/1989

Data and Process Analyst, Warehousing and Logistics

Coldwell Banker - 4/1985 to 4/1987

Project Manager, Enterprise Architecture

DBMS, Inc. (subsequently Platinum Technology) - 9/1982 to 4/1985

Project Manager, Software Engineering

Coopers & Lybrand - 9/1979 to 9/1982

Senior Staff Accountant

Education

University of Illinois at Chicago

BA in Psychology, with high honors; minor in Organizational Behavior

University of Chicago

MBA in Finance and Accounting

Illinois Institute of Technology

MS in Computer Science, with a specialization in Intelligent Information

Systems

Skills and Technologies

Databases: SQL Server 2008, Oracle13, Teradata 13, MS Access 2010, IBM

DB2/UDB

Modeling and Metadata: ER/Studio, ERWin, Oracle Designer, Rational

Rose/RUP/UML, System Architect, COOL/IEF, GroundWorks, Sterling Key,

Platinum and Rochade Repositories, ER (OLTP and ODS) and Dimensional (OLAP)

Modeling, Kimball, Object Modeling, .NET

Data Transport: Microsoft Integration Services (SSIS), AbInitio, MQSeries

Analysis and Reporting: Microsoft Reporting Services (SSRS), Crystal

Reports/Decisions, Actuate

Development: Microsoft T-SQL, Teradata SQL Assistant, Visual Basic.NET,

ADO.NET, XML

Productivity: MS Office, MS Project, Visio

ERP: SAP R/3 (FI/CO, HCM), Lawson HR/Payroll, Oracle Financials, Clarify,

EpiCare

Other: JAD Facilitation, Requirements Analysis, Project Planning and

Management

Functional Areas: Finance/Accounting, Customer Order Management/Invoicing,

Sales Force Automation, Insurance Claims Processing, Supply Chain, Risk

Management, HR/Payroll, CRM, Bank Payment Processing, Production

Management, Warehousing/Logistics, Patient Care Delivery, Health Plan

Operations, Asset Management

Other Accomplishments

Received my CPA in the State of Illinois in 1981

Conducted substantial original research in the areas of intelligent systems

frameworks and object modeling and decomposition approaches

Lectured on systems planning and development methods and practices, and

wrote and delivered several papers on expert systems and its incorporation

into traditional computing environments

Taught data and process modeling techniques, and developed DB2 Technical

Design course materials for a leading marketer of data and process modeling

products

Wrote several white papers on enterprise systems management and

architecture, including reviews and assessments of architectural components

such as data warehousing frameworks and products and message-oriented

middleware

Contact this candidate