Norma Lynn Hammett

**** ******** ******,

Flower Mound, TX 75028

214-***-**** - Cell-Phone

ad1y52@r.postjobfree.com

CAREER GOALS:

To be part of world class Analytic organization, which is team oriented and

driven by business/technology execution/delivery of analytic solutions

success (e.g. business expectations met, solutions on-time and on-budget,

etc.)

KEY POINTS:

. 30+ Years Information Technology Experience

. 15 Years Software Architecture and Systems Engineering Experience

. 20 Years Management Information Systems, OLAP Analytic, Data

Warehousing/Business Intelligence experience and has participated in

more 45+ data warehousing/business intelligence analytic project

implementations.

. Prior Vice President of Data Warehousing Programs, Data Integration

and is currently the President, of the DFW DAMA organization.

. Published numerous Data Integration/EMP Web Services Systems SOA and

Data Warehousing/Business Intelligence, Master Data Management and

Data Governance white papers, and has been a frequent lecturer at Data

Warehousing business seminars and conferences.

EXPERIENCE SYNOPSIS:

MedSynergies Inc - April 2012 to Present

Director Enterprise Business Intelligence

Responsible for technical architecture frameworks of the (MedSynergies

Enterprise Data Warehouse/Business Intelligence) Product Solution.

Ownership for defining Enterprise Level Technical Architecture blueprints

(i.e., Data Architecture, ETL & BI OLAP APP Architectures, and Technical

Infrastructure Architecture). Worked with Product Management, Client

Delivery, and IT Operations Teams to gather and document business

requirements, technical requirements and critical success criteria DW/BI

Product system releases. Utilized (CA Erwin r8 - Data Modeling Tool) to

develop the (DW_BI) Data Model. Assisted ETL Team to perform (data

profiling) analysis against OLTP (GE FlowCast & GroupCast - PMS Systems)

data feeds to the (DW_BI) database. Assisted ETL Team with Source-to-

Target (SST -Source to DW ETL Data Mapping) MS SQL Server 2008 R2 (SSIS

ETL) design deliverables. Assisted BI Team with (SST - DW to BI Report

Data Mapping) Cognos 10. BI Reporting design deliverables. Assisted QA

Team in defining the (ETL & BI Application) QA Test Plans. Leveraged

company specific "Corporate Assets", to support key analytic information

needs from corporate IT Systems (PMS-GroupCast, PMS-FlowCast, Msight, PMS-

Athena, GL-Great Plains, etc.). Supported Proof of Concept (POC) for Big

Data solutions, leveraging Hadoop, Distributed File System (HDFS) and

MapReduce - JUMBUNE, for unstructured Data integration with MSI traditional

Data Warehouse StarSchema database.

JWT April 2009 to April 2012

Lead Database Marketing Architect

Responsible for defining an implementation of Enterprise (Database

Marketing) solutions, which provided SAP Business Objects (BO) Reporting

Analytic, and CRM data integration services to JWT clients. Examples of the

types of solutions would include customer/consumer product loyalty &

marketing campaign ROI decision management programs. Also responsible for

establishing business driven Data Governance programs to ensure data is

audited for accuracy and timeliness, which ensures that client business

units have and maintain a "single-version-of-the-truth" to support mission

critical information needs. Responsibilities include providing high-level

architecture solution blue-prints, which enable utilization of Client

specific "Corporate Assets", by extracting key analytic information from

corporate assets - such as Client ERP, CRM and SOA systems for building out

new " Event Driven - SOA". Leveraged BIG Data and Stat Modeling Tool - SAS

and Tibco Spotfire. Researched Hadoop Big Data Tools - for possible

integration of Web Click Stream analytics and Social media "Un-structured"

data streams. Company elected to leverage the Tibco Spotfire solution.

CIBER Inc. October 2007 to April 2009

Principal Architect - Global Enterprise Integration Practice (GEIP) -

Consulting

Responsible for defining an implementation of Enterprise Analytic (Data

Management/Data Integration) solutions, to provide an enterprise service

bus and analytic reporting information, which drive client

(customer/product loyalty & revenue enhancement) decision management

programs. Also responsible for establishing business driven Data

Governance programs to ensure data is audited for accuracy and timeliness,

which ensures that client business units have and maintain a "single-

version-of-the-truth" to support mission critical event driven SOA

transaction processing and analytic reporting needs. Provided high-level

architecture solution blue-prints, which enable utilization of Client

specific "Corporate Assets", by extracting key analytic information from

corporate assets - such as DMBS ORACLE, Informix, Sybase, MS SQL Server,

ORACLE Hyperion Essbase, SAP ERP, ORACLE ERP, JD Edwards ERP, Siebel CRM,

PeopleSoft Enterprise Project Management (EPM), HR, POS, and SOA systems

for building out new " Event Driven - SOA".

EXPERIENCE SYNOPSIS:

Bear Stearns/EMC Mortgage July 2006 to October 2007

SVP Managing Director - Enterprise Data Warehouse/Business

Intelligence/Analytic Solutions

Responsible for defining an implementation of a Universal Information

Management Strategy to provide a single environment to collect, manage and

store key business information across the enterprise, along with

implementation of a centralized Information/Data Governance business and

technology solution. Responsibilities include providing high-level

architecture solution blue-prints that enable utilization of Corporate

Assets such as Oracle 10G DBMS for building out new Enterprise Data

Integration services "Data Hub", which leverages the IBM Ascential ETL Tool

Suite including DataStage, MetaStage, ProfileStage, QualityStage, with

direct-connect interfaces to Oracle Hyperion Essbase. All Logical and

Physical Data Models are developed and managed through Computer Associates

(CA) ERWIN and Model Manager for Logical and Physical Database Models. All

Front-Office End-User Business Intelligence solutions are delivered via the

COGNOS ReportNet 8, Web Portal and Reporting Framework components.

Verizon Information Services - Actual March 2004 to July 2006/Service

Bridged (11/1990 to 7/2006)

Director Information Resource Management (IRM)

Responsibilities include providing high-level architecture design support

for Oracle EMP &, PeopleSoft Enterprise Project Management (EPM), and

PeopleSoft HR, POS, CRM 8.8 & 8.9, WebLogic Web Services - Service Oriented

Architecture (SOA), Enterprise Data Integration and Business

Intelligence/Data Warehousing programs within Verizon Information Services

(VIS). Assist Verizon Sales & Marketing Teams in vendor management

partnership activities and project scoping/delivery RFI & RFP estimation

functions. Core team member of Project Management Office, which provides

governance and executive release management ROI tracking for all VIS

programs and projects.

JPMorganChase Investor Services July 2002 to March 2004

VP Global Application Development (Data Warehouse and Information

Architecture)

High-level architecture design support for all Enterprise EMP Web Services

SOA, Data Integration system architecture solutions. Ownership for all

Business Intelligence/Data Warehousing programs within JPMorganChase.

Assisted JPMorganChase Product Sales Team in pre-sales activities and

project scoping/delivery estimation functions. Hands-on mentoring and

leadership for systems architecture SDLC solution delivery organization.

Have ownership of all end-to-end Enterprise Data Integration with both

internal data feeds (i.e., ORACLE ERP/Hyperion Essbase/PeopleSoft HR), and

external data feed Vendors, and Business Intelligence/Data Warehousing

program and project solution deliverables.

ALLIANCE CONSULTING June 2000 to July 2002

Digital Intelligence Solution Architect/Practice Director

Provided pre-sales support for potential Alliance engagement opportunities.

Assisted Alliance practice management in the development/publication of

"Managed Services" practice specific SDLC methodologies and deliverable

templates. Guidance and recommendations for proposed technology

solutions, and leadership / mentoring support for junior technical staff

members. Consulting engagement with South West Airlines - supporting Y2K,

Enterprise Data Integration Management leveraging Oracle and BI OLAP Cognos

Impromptu & PowerPlay Reporting Soutions.

SAP AMERICA June 1998 to June 2000

Senior Data Warehouse Implementation Consultant

Defined and developed effective strategic business plans for the rollout of

a standardized SAP Data Warehousing methodology and "best practices"

software implementation approach.

Assisted in the development of a standardized DW methodology and "best

practices" approach for the implementation of Data Warehousing Programs for

Client Partnerships.

Responsible for end-to-end development processes for manufacturing SAP's

ASAP BW methodology CD. This CD contained SAP's recommended approach to

implementing the BW data warehousing software product on top of SAP R/3

application modules. Application of expertise Project Management, Vendor

Contract Management, Data Base Management, Business/Rule Modeling, Data

Base Modeling, Resource Management, and Software Engineering.

EXPERIENCE SYNOPSIS:

DMR CONSULTING GROUP, INC. February 1997 to June 1998

Oracle Applications Implementation Consultant and Data Warehousing

Engagement Director

Provided hands-on support for ORACLE Applications SmartClient 10.15 and

ORACLE DBMS 7.1, 7.2 and 7.3.2 implementations. Application modules

installed (General Ledger, Accounts Payable, Accounts Receivable,

Purchasing, Inventory, Fixed Assets, Project Accounting and Human

Resources). Responsibilities included installing both Client and Server

Oracle application software, as well as developing any custom ORACLE

Forms/Reports using the ORACLE Designer 2000/Developer 2000 & Discover 2000

case tools. Data Warehousing Engagement Director responsibilities included

providing pre-sales support for potential DMR engagement opportunities.

Application of expertise Project Management, Vendor Contract Management,

Data Base Management, Business/Rule Modeling, Data Base Modeling, Resource

Management, and Software Engineering.

ASSOCIATES BANCORP, INC. November 1995 to February 1997

Credit Card Data Warehousing Project Manager

Defined, developed and implemented appropriate and effective Decision

Support and Data Strategies related to the deployment of Data Warehouse

projects throughout The Associates Corporation. Responsible for

determining and implementing the processes and team required to effectively

facilitate change, build effective relationships with multiple business

units, and market the Data Warehouse projects.

Provided hands-on support to the point of teaching, reviewing and helping

implement Data Warehouse processes (i.e., Corporate Enterprise Data, Data

Access Paths, Data Extraction/Transformation, Data Modeling Logical and

Physical, Data Mapping, Data Base Loads, Source to Target Data

Reconciliation's, Data Mining, etc.).

Worked with developers to develop custom data sourcing software using the

PRISM Warehouse Management Metadata Tool and Oracle Case Tools. Hands on

experience using ERWIN, S-Designor and Oracle D/2000, to support

development of Oracle DDL for target database structures. ORACLE Tools

used (i.e., Forms/Reports using the ORACLE Designer 2000/Developer 2000 &

Discover 2000 case tools. Custom development on UNIX Server using PL/SQL,

SQL*NET, SQL*PLUS, SQL*DBA, SQL*LOADER, SQL*FORMS, SQL*REPORTWRITER).

Application of expertise; Project Management, Vendor Contract Management,

Data Base Management, Business/Rule Modeling, Data Base Modeling, Resource

Management, and Software Engineering.

GTE DATA SERVICES/TELEPHONE OPERATIONS July 1985 to November 1995

(August 1994 - November 1995) Project Manager/Advisor Systems Engineer

Project Manager for the GTE Re-Engineering & Data Warehousing conversion

projects.

Managed, planned, staffed, coordinated and organized data conversion

activities for transformation of data from legacy systems to client server

OLTP, ODS and Data Warehouse systems environment.

Supported Proof of Concept for GTE SAP (GL, AP, AR & HR) project, which

required intense analysis Of GTE's legacy systems/functions that would be

replaced by utilizing the object-oriented ABAP/4 and distributed components

using SAP's Business Framework and Intranet Technology.

Application of technical expertise; Mapping Source to Target Object

Functions, Data Base Management, SAP R3-ABAP/4, Operating Systems Data

Extraction, Business/Rule Modeling, Data Resource Management, QDB/Analyze,

and Software Engineering. Additional responsibilities; provide advise and

counsel to executive management concerning complex technical issues and to

make recommendations as to the appropriate application of systems

technologies.

Additional responsibilities included initiating functional systems

requirements for GTE Data Services Legacy systems. Resolved system and

functional issues for the CCC, CBC and Customer Contact Centers for both

Production and Testing environments. Traveled about 50% of the time meeting

in person with each State Regulatory Commission Staff members, where GTE

provides Local Service, seeking approval to implement new Advanced Credit

Management (ACM) programs.

EXPERIENCE SYNOPSIS:

GTE DATA SERVICES/TELEPHONE OPERATIONS July 1985 to November 1995

(Continued)

(July 1991 to August 1994) Project Leader Systems Engineer/System Analyst

Responsibilities included determining impact of proposed enhancements to

CBSS Billing System architecture during the High Level Design and Detail

Level Design requirements phases. Acted as a project resource to guide,

instruct and monitor team members in Coding, Testing and Implementation

tasks. Instructed team in coding techniques, technical/user procedures and

estimating tasks, per GTED's Project standards. Assumed supervisor

responsibilities whenever necessary. Focal point for all MIS decision

support issues relating to GTE Billing data. Member of core team

responsible for OLTP, ODS, Data Warehouse implementation and Decision

Support Data issue resolution.

GTE DATA SERVICES/TELEPHONE OPERATIONS

(July 1987 to July 1991) Programmer/Programmer Analyst

Determined impact of proposed enhancements to the CABS and/or CBSS Billing

System. Provided production support for "Problem/Incident" Coordinator

for the Bill Calc, Pricing, Format and BOCB groups. Designed/developed

system software specifications, Coding, Testing, Debugging of system

software and the formal inspection of assigned Data Processing Service

Request (DPSR's) modules, as well as to assist in the creation of the RVL

release PMW Work Plan. Assumed project leader responsibilities when ever

necessary.

(September 1986 to July 1987) Technical Writer/Technical Publication

Project Leader

Originated, edited and published System and User documentation.

Provided assistance and training to coworkers in the origination of

documentation, desk top publishing procedures and the interpretation of

COBOL II and ADR/IDEAL programs, Dump Analysis, JCL syntax and TSO/ISPF

mainframe command options. Planned, organized, edited, and published the

EXPRESS Systems and User documentation Project. Provided assistance and

training to coworkers in the origination of documentation and desk top

publishing procedures. Generated on-demand ADR/IDEAL Data Queries, which

produced cross-reference listing of data elements within the EXPRESS

system.

(July 1985 to September 1986) Accounts Payable Accountant/Purchasing Agent

Researched and resolved accounting, purchasing purchase-order procurement-

match rejection errors.

Contacted vendors to expedite shipment of open purchase orders. Generated

on-demand ADR/IDEAL Data Queries to report inventory levels, identify

potential shortages, report pricing and warehouse-receiving errors, as well

as to insure the accuracy of payment for invoices processed through

accounts payable. Acted as a mediator between purchasing, accounting and

information management departments.

FIRST SECURITY BANK, HILL A.F.B. UTAH October 1975 to July 1985

Branch Operations Officer/Head Teller/Systems Security Administrator

General accounting functions, administrating in-house system security

access to users, Air Force base security officers, tellers and new account

reps. Secured all vaults and alarms with Air Force Base Security

administration. Bonded for 2,000,000.00 with a personal cash limit of over

750,000.00 per day. Directly Supervised 6 employees. Excellent balancing

record.

EDUCATION:

. Graduate 1985 (Bachelor of Science - Cum Laude) in Information

Technology

. Graduate of GTE Data Services Technical Development Program 1989

. GTE's Information Systems Training (over 600 IT courses taken to date)

. Graduate of Oracle Masters Program 1997

TECHNICAL EXPERTISE:

HARDWARE

Intel PC's /Win 95/NT XP/2007, SUN/Solaris Servers, HP/UX Servers

NCRTeradata, DELL ProLiant Servers, IBM/AIX Servers, IBM AS/400 Servers

IBM-MVS Mainframe, Amdox Mainframe

SOFTWARE:

SAP R/3 ERP & BW ERP Apps. SAP SFA, FICO Applications Process Modeling

BPWIN,

PeopleSoft Enterprise Project Management (EPM), Oracle

ERP/Hyperion/PeopleSoft - CRM 8.8 & 8.9 ERP,

ERD/LDM/PDM - MDM Data Modeling CA Erwin, IBM DB2 & UDB SQL QMF Reporting,

Informatica ETL Software,

IBM Ascential ETL Software, Informitaca ETL Software, Abinitio ETL Software

SAS STAT Analytical Tools, Enterprise BRIO Holos, MVS File Aid CA7/CA-

Unicenter AutoSys,

WebMethods, WebLogic EAI SOA Software FTP - TCP/IP/WSFTP Syncsort Software

Microsoft Project Microsoft Office Pro, Platinum Repository, Microsoft

Exchange Server,

VISIO Professional / Microsoft Publisher, Microsoft Access DB, LOTUS Notes,

COGNOS Impromptu/PowerPlay, Business Objects (BO), Microstrategy Software,

ORACLE Express ORACLE Discover ORACLE Designer 2000, ORACLE Developer,

ORACLE ERP Smart Client, IQ Objects, Microsoft SQL Server 2005, 2008 R2,

Microsoft Reporting & Analysis Services, OLAP Reporting (SSIS, SSRS, SSAS),

Microsoft Visual Studio (Visual Basic, Visual C#, Visual C++, C++, C#, J#)

and Visual Web Developer) and MQ Series Messaging, ETI Extraction/Transform

Software

LANGUAGES:

Oracle PL/SQL Oracle SQL*Net Oracle SQL*DBA Oracle SQL*Loader

Oracle SQL*Forms Oracle SQL*Report Writer MVS DB2 QMF SQL SAS

INFORMIX, Hyperion Essbase, SYBASE NCR/Teradata IMS DB/DC,

Microsoft Visual Studio Visual C++, .Net Framework, MS SQL Server 2008,

2010

MVS JCL MVS CLISTS/REXX Microsoft SQL Server Syncsort

RAMIS/RXX IDMS HTML/XML/JAVA MVS COBOL II

Microfocus JCL, COBOL II and CICS Mainframe Messaging System Applications

REFERENCES:

John F. Cole

Vice President Global Support, Software and Tools - Unisys Corporation

972-***-**** - Office

214-***-**** - Cell

ad1y52@r.postjobfree.com

Karen Moree - Area Vice President Alliance Consulting

Alliance Consulting Group

972-***-**** - Office

817-***-**** - Cell-Phone

ad1y52@r.postjobfree.com

Harold Harrison

President CEO

InfoTech Search

8700 King George Dr,

#102 - Office

Dallas, Texas 75235

214-***-**** - Office

214-***-**** - FAX

ad1y52@r.postjobfree.com

Contact this candidate