Data Modeler Resume

Title
Data Modeler

Primary Skills
Data Modeler/Architect

Location
US-CA-Vallejo (will consider relocating)

Posted
Jan-27-09


REPRESENTATIVE EXPERIENCE
INDEPENDENT CONSULTANT - 5/02 TO PRESENT
Wells Fargo Internet Services Group, San Francisco, CA - 12/06 to 3/08
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 usiing relational, flat-file, and XML technologies
* Developed approaches and frameworks for the enhancement of data quality and integrity

APL Limited, Oakland, CA - 12/05 to 9/06
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/05 to 11/05
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

Salt River Project, Phoenix, AZ - 11/03 to 3/04
Plan B Solutions, Newport Beach, CA - 4/04 to 12/04
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/02 to 11/03
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/02 to 10/02
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/00 TO 5/02
Principal Consultant, Internal Projects - 2/01 to 5/02
* 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/00 to 2/01
Enterprise Data Architect, Supply Chain Data Warehouse
* Developed an integrated and aggregated 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/90 TO 5/00
Bank One, Columbus, OH - 11/99 to 4/00
Systems/Data Architect, State of Ohio Child Support Payment Data Warehouse
* Modeled, designed, and guided the implementation of an ODS summarizing child support payment activity in 66 counties; models were developed using ERWin
* Designed and implemented a centralized support and reporting Data Mart in line with federally-mandated requirements

Motorola, Radio Systems Network Group, Schaumburg, IL - 11/98 to 11/99
Project Manager/Architect, Clarify Implementation
* Managed the implementation of the Clarify suite of applications
* Performed requirements analysis and data and process modeling
* Designed reporting and querying capabilities
* Managed report development activities

First Health, Downers Grove, IL - 7/98 to 11/98
Project Manager, Financial and Payroll Systems
* Conducted a vendor/product evaluation and selection effort

McDonald's Corporation, Oak Brook, IL - 5/97 to 6/98
Enterprise Architect
* Established roles, responsibilities, and procedures pertaining to McDonald's internal Enterprise Architecture group
* Developed a set of target architectures (data, applications, communications, platform, and security) along with a transition plan from current to future state

Architect -- Data Warehouse Standards, Policies, and Technologies
* Developed standards, technologies, and policies for the deployment of data warehouses
* Using Oracle Designer, Prepared logical and physical ODS and Data Mart models in support of McDonald's Global Financial Systems (GFS) warehousing project, along with interfaces and ETL specifications
Allstate Insurance, Northbrook, IL - 5/96 to 4/97
Data Analyst, Enterprise Planning and ERP Systems
* Using ERWin, Prepared logical data models in support of Allstate's integrated financial management and reporting requirements
* Developed business requirements in conjunction with an ERP vendor selection effort
* Integrated the selected package (SAP R/3) into the new process design

Data Warehouse Architect
* Designed a data warehouse component to operate in conjunction with SAP
* Performed multidimensional data modeling and design, reporting needs analysis, and application integration design

Moore, Business Forms and Systems Division, Lake Forest, IL - 8/94 to 4/96
eBusiness Modeler/Applications Developer, Customer Management Systems
* Managed a team responsible for the development of a distributed order management and inventory control system to be installed at customer sites
* Prepared logical and physical data models
* Developed customer, supplier, and supply consolidation process models
* Designed the user interface and developed major software components

Helene Curtis, Inc., Chicago, IL - 1/96 to 4/96
Data/Process Analyst, Risk Management and SAP Implementation
* Conducted Joint Application Development (JAD) sessions with upper management
* Developed data and process models
* Directed the transformation of models into appropriate inputs for the configuration of the company's SAP R/3 package

Follett Campus Resources, Forest Park, IL - 2/94 to 7/94
Data Architect and Applications Developer, Warehousing and Employee Management
* Developed and published an enterprise data model
* Designed and implemented a database to support CRM efforts
* Re-engineered the company's warehousing operations and designed and developed a system to monitor the performance of warehouse employees

QuadGraphics, Pewaukee, WI - 5/93 to 12/93
Data Architect/Applications Developer, Production Management
* Managed a project team responsible for
- specifying business requirements in terms of data and process models,
- translating those requirements into system designs,
- preparing prototypes to illustrate major system concepts, and
- driving designs forward through construction and implementation
* Designed a set of integrated systems to support production planning, scheduling, point-of-production, and billing for its pre-press and press operations

Kohl's Department Stores, Menomenee Falls, WI - 9/92 to 4/93
Methodology Consultant, Enterprise Architecture and Warehouse Management
* Selected and implemented a methodology and modeling tool
* Conducted a process re-engineering effort aimed at warehousing and distribution activities.
* Installed and implemented of hand-held bar code scanning equipment, as well as significant work flow enhancements at major distribution centers

McDonald's Corporation, Oak Brook, IL - 1/92 to 8/92
Methodology Consultant, Strategic Planning and Human Resource Management
* Developed enterprise data and process modeling and design standards, internal training strategies, and project management guidelines
* Developed logical and physical data models to support the development of a custom Benefits and Compensation system
* Helped to establish the Enterprise Architecture group, including
- definitions of architectures (data, application, communication, platform, and security),
- roles and responsibilities,
- policies and practices, and
- standard deliverables

Sears Credit, Chicago, IL - 7/90 to 12/92
Strategic Planner/Consultant
* Led a project team responsible for developing strategic plans and performing business analyses
* Guided the selection of a data and process modeling tool
* Developed a data mart to support sales promotions and accounts receivable factoring for the companies 34 million active cardholders
* Initiated the major re-structuring of mainstream credit management systems


JAMES MARTIN AND COMPANY - 4/87 TO 7/90
Pacific Gas & Electric, San Francisco, CA - 4/90 to 7/90
Data and Process Analyst, Financial Systems
* Led a project team in the analysis of a financial business area for the purpose of selecting a set of integrated financial applications
* The company subsequently applied the results of this analysis to the selection of a major accounting package, and based its customization and installation efforts directly on the resultant business models

United Airlines, Elk Grove Village, IL - 7/89 to 4/90
Strategic Planner/Consultant, Airline Operations
* Developed an information strategy plan using a major analysis and design tool
* Conducted top- and middle-management interviews, performed high-level function and data modeling
* Specified and prioritized a set of business and technical strategies, objectives, and critical success factors
* Defined information, systems, and technical architectures

Shell Canada and Imperial Oil, Ltd, Calgary, AB and Toronto, ON - 9/88 to 7/89
Data and Process Analyst/System Designer, Sales and Customer Management
* Prepared and implemented information and technical architectures
* Managed detailed business analysis, system design, and technical design projects
* Developed a functional prototype of a Sales Management system, working from analysis to code generation in a three-month period

Xerox Corporation, Rochester, NY - 12/88 to 4/89
Data and Process Analyst, Warehousing and Logistics
* Developed a prototype system to demonstrate the application of Information Engineering and CASE from business area analysis through code generation


COLDWELL BANKER - 4/85 TO 4/87
Project Manager, Enterprise Architecture
* Developed an integrated information systems architecture
* Developed an expert system for negotiating leases at company-developed ventures

DBMS, INC. (SUBSEQUENTLY PLATINUM TECHNOLOGY) - 9/82 TO 4/85
Project Manager, Software Engineering
* Managed a team responsible for the development of an IDMS Reporting Toolkit

COOPERS & LYBRAND - 9/79 TO 9/82
Senior Staff Accountant
* Performed accounting and financial consulting services, specializing in insurance and emerging business clients

SKILLS AND TECHNOLOGIES
DATABASES: SQL Server 2000/2005, Oracle8i/9i, Teradata, MS Access 2003, IBM DB2/UDBa
MODELING AND METADATA: ERWin, ProForma, ER/Studio, Oracle Desginer/2000, 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 Framework
DATA TRANSPORT: Microsoft Integration Services (SSIS), Ab Initio, MQSeries
ANALYSIS AND REPORTING: Microsoft Reporting Services (SSRS), Crystal Reports/Decisions, Actuate
DEVELOPMENT: Microsoft T-SQL, Visual Basic.NET, ADO.NET, XML, Teradata SQL Assistance
PRODUCTIVITY: MS Office, MS Project, Visio
ERP: SAP R/3 (FI/CO), 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

EDUCATION
UNIVERSITY OF ILLINOIS AT CHICAGO 1974 - 1978
BA in Psychology, with high honors; minor in Organizational Behavior

UNIVERSITY OF CHICAGO 1978 - 1979
MBA in Finance and Accounting

ILLINOIS INSTITUTE OF TECHNOLOGY 1996 - 1999
MS in Computer Science, with a specialization in Intelligent Information Systems

OTHER ACCOMPLISHMENTS
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
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
Received my CPA in the State of Illinois.
Microsoft Developer certifications in progress,

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Vallejo, CA | Resumes in California

View other Data Modeler resumes, Database Administrator resumes