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

Confidential

Data Modeler/Architect

• As part of the Pricing Knowledge Platoform PKP team, developing a physical data model for a big data application focused on providing new and innovative visualizations to business users
• Developed data hierarchies used for drill-down and trending requirements
• Prepared flat files consumed by technologies such as Hadoop and Tableau

Confidential

Data Modeler/Architect

• Developed Functional Design documents to interface various data sources with the company's new Teradata-based Master Data Management MDM database
• Prepared MDM data standards
• Developed logical and physical models representing target database objects in MDM
• Performed source-to-target mapping from source systems to newly developed database objects
• Prepared acceptance testing and system testing scripts against interface specifications
• Maintained metadata in line with MDM standards, requirements, specifications, and implementations

Confidential

Enterprise 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 enterprise applications to serve the concept assessment process
• Developed multifunctional 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

Confidential

Enterprise Data Modeler/Architect

• Responsible for the development, care, and maintenance of logical and physical ERWin data models, along with corresponding metadata, to support a variety of 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
• Confidential 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

Confidential

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

Confidential

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

Confidential

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

Confidential

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

Confidential

• Developed standards, policies, and procedures for Enterprise, Data, and Applications Architectures
• Wrote and delivered consulting proposals
• Mentored junior staff and prepared performance evaluations

Confidential

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.

Confidential

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

Confidential

Project Manager/Architect, Clarify Implementation

Confidential

Project Manager, Financial and Payroll Systems

Confidential

Enterprise Architect

Architect -- Data Warehouse Standards, Policies, and Technologies Confidential Data Analyst, Enterprise Planning and ERP Systems Data Warehouse Architect Confidential

Business Modeler/Applications Developer, Customer Management Systems

Confidential

Data/Process Analyst, Risk Management and SAP Implementation

Confidential

Data Architect and Applications Developer, Warehousing and Employee Management

Confidential

Data Architect/Applications Developer, Production Management

Confidential Confidential

Methodology Consultant, Strategic Planning and Human Resource Management

Confidential

Strategic Planner/Consultant

Confidential

Data and Process Analyst, Financial Systems

Confidential

Strategic Planner/Consultant, Airline Operations

Confidential

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

Confidential

Data and Process Analyst, Warehousing and Logistics

Confidential

Project Manager, Enterprise Architecture

Confidential

Project Manager, Software Engineering Confidential Senior Staff Accountant

Skills and Technologies

Databases: SQL Server 2008, Oracle13, Teradata 13, MS Access 2010, IBM DB2/UDB, Green Plum, Hadoop 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 Studio.NET, ASP.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
• Certified Microsoft Technology Associate MTA Software Development Fundamentals
• 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-doriented middleware