Project Manager Data

BRIAN E. MALITZ

*** **** *** ******

The Dalles, OR 97058

971-***-**** Skype ID - Cotamundi2

acasfs@r.postjobfree.com acasfs@r.postjobfree.com

SUMMARY

Hands-on Information Technology expert providing trouble-free design,

development and deployment of effective systems to support decision-making

through superior leadership, planning, organization, team building,

mentoring, communication, analysis, modeling, process design, development

and work ethic.

HIGHLIGHTS

. Agile Data Warehouse, Enterprise Architecture using Togaf and Zachman

Framework Methodology, Data Modeling using E/R and Dimension Models,

Conceptual, Logical and Physical

. Big Data Research and Development using Artificial Intelligence

Architecture

. Database Design, Analysis, and Modeling, Data Extraction, Profiling, Data

Cleansing ETL planning and ETL Module Design, ETL/Database Tuning for

Performance, Reports Design and Delivery

. Systems Engineering, Satellite Systems Engineering, Risk

Assessment/Planning, Test Planning

. Business Process Systems Analysis and Design, Requirements Gathering and

Analysis, Business Liaison, Systems Engineering, Systems Analysis, R&D

Science Engineer

. Operations Director, Project Manager, Author of Policy, Plans,

Requirements, Analysis and Development Documents, Business Liaison,

Mentoring, Project Presenter/Briefer

. Industries - Healthcare, Retail (Oil and Gas Apparel), Telecom, Supply

Chain, Manufacturing, Department of Defense, Federal Government, Finance

- IDS Registered Rep.

Technologies

. Teradata 13.1

. SAP ECC and SAP SCM

. SQL Server 2000, 2005, 2008, 2012; SSRS, SSAS, SSIS, TSQL

. Oracle, PL/SQL, SQL Navigator, TOAD

. ER Studio Data Architect, Erwin, UML, Visio, MS Office

. CRM Express, Epiphany, Siebel, Business Objects, Informatica, Business

Objects

EDUCATION

. M.A. Computer Resource and Information Management, Webster University

. MBA, Webster University

. B.S. Electrical Engineering, Texas A&M University

. MBA Program, University of Oklahoma, 48 hours Finance and BankMnance and

b Management

. Microsoft Training - Business Intelligence Training, US Air Force

Instructor Training Courses

. Recent courses - "Coursera - Web Intelligence and Big Data," "Coursera -

Machine Learning"

PROFESSIONAL EXPERIENCE

September 2012 - Present T-Mobile Bellevue, Washington

Enterprise Senior Data Architect/Data Modeler

> Teradata Data Architect in Agile Environment, creating data warehouse

dimensional Logical (LDM) and Physical (PDM) data models and Source to

Target Mapping (S2TM) for T-Mobile projects including Point of Sale

(POS), Commissions, Warranty, Personal Guarantor, Catalog Enhancement,

Anytime Upgrade, No Service Contract, etc. Three tier architecture of

Samson, Oracle, and Teradata with Netezza/Business Objects providing

analysis/reporting. ER Studio and AccuRev used for modeling, DDL,

Source to Target Mapping; support for testing. Presented Dimensional

Modeling and Togaf/Bachman Enterprise Architecture Methodology.

June 2012 - August 2012 Illinois State University Normal, Illinois

Enterprise Data Architect/Data Modeler

> Developed a data architecture model for pilot program to rapidly for

modernizing the Illinois State University Enterprise Architecture to

include Student Social Networking (employment of Big Data concepts).

Used Togaf methodology, referencing the Zachman Framework with JAD

sessions to capture functional and data requirements in concert with

Six Sigma Team. Created Togaf artifacts for system goals, drivers,

services, functions, business models, use cases, process flows, data

models, data lifecycle, metadata, and system migration. Evaluated data

modeling tools and developed a Metadata solution for the Enterprise

data.

June 2011 - May 2012 Intel Folsom, California

Data Architect/Data Modeler

> On Fusion 3x Project building a Teradata, Agile data warehouse using

Doctor Ralph Kimball's methodology, served as a data architect/data

modeler linking data from SAP ECC sales orders, shipping and billing

to data from SAP SCM (Supply Chain) demand/supply planning for

business analysts. Used ER Studio Data Architect for logical and

physical data modeling and source to target mapping for ETL

development. Developed data quality method.

August 2009 - May 2011 Independent Artificial Intelligence Research and

Development

Project Manager/Architect/Research Analyst/Engineer

> Served as leader and focal point for research direction and

conceptualization

> Determined data structure of sensor integration, data schema/model of

Data Warehouse, and concept of structure for rule generation

> Provided research on mathematical concepts and previous algorithms for

sensor integration research, robotics and direction for mechanical

development

> Environment - Neural Net Software, SQL Server 2008 SSIS, SSAS, SSRS,

Erwin, Visual Studio, Hardware (Sensors, and Actuators/Servos)

Proof of Concept - Developed methodology for handling Big Data (volume,

velocity, and variety) using an Artificial Intelligence Architecture to

handle data from multiple sensors in a Neural Network to provide

"snapshots" of conditions for a Data Warehouse. This architecture would

derive "If/Then Rules" of Intelligence for the environment for a

Fuzzy/Expert System to drive Servos for movement of a tool. This would

provide "knowledge" for the system. Exceptions in the learned environment

would require new "knowledge" which the system would then adapt to with new

rules. The system would "learn." When one considers a group of sensors for

pressure, temperature, optics and optical ranges, interacting with multiple

conditions, and providing continuous data; one can begin to appreciate the

use of an architecture that simplifies the utility of the data for

adaptation to the dynamic environment.

April 2005 - March 2009 - Justin Workwear Alaska/IME INC.

Operations Manager/System Architect

> Directed daily operations giving direction and scheduling for retail

clothing sales with marketing and sales planning, business

administration and financial management.

> Primary sales were to Oil and Gas, Construction and Railroad

businesses.

> Established and implemented a Data Warehouse for CRM email campaigns

and retailing sales reporting.

> Gathered requirements, built data models based on Kimball's methods.

> Used ERwin for both ER and Dimensional data models on SQL Server 2005

SSIS, SSAS, SSRS, CRM Express. Provided data analysis/mining for

marketing and sales.

September 2004 - March 2005 - Blue Cross/Blue Shield Regence Group

Portland, Oregon

Data Warehouse Architect/Data Analyst working on the Hospital Reimbursement

Project to consolidate health claims and fee data from 4 states for an

Oracle 9I data warehouse to meet provider modeling and analysis needs.

> Collected and analyzed requirements for data integration/modeling, and

ETL. HSS Winstrat and 3M groupers used in analysis of

Medicare/Medicade costs.

> Data analysis with PL/SQL Business Intelligence queries using SQL

Navigator. Tweaks using Erwin were provided for a more robust data

model.

July 2004 - August 2004 Merix Corporation Forest Grove, Oregon

Data Architect on development of data warehouse and ODS solution for Merix

Corporation Mother Board manufacturing production line.

> As Business Analyst collected requirements and business rules to

produce requirements document, data model, and technical architecture

with project plan for implementation.

> Analysis of data determined that reporting problem was one of too

normalized data model for querying.

> Restructure of the data model into a dimensional schema (Operational

Data Store, ODS) and changes to the process/model provided more rapid

data access (near real time) for production line corrections,

analysis, and inclusion of chemical bath data.

February 2004 - June 2004 Menlo Worldwide Portland, Oregon

Business Intelligence/Data Analyst Provided logistics analysis, reports

and ad hoc information (complex TSQL queries) for management on the CAIR

Project. The CAIR Project provided tracking, financial and performance

information for commercial airlines carrying mail for the US Postal

Service.

> Established metric program and accomplished data analysis for

improvements in database performance and airline bottom line.

> Business rules and data provided a restructure of the data model for

reporting performance gains.

> Implemented a mini data mart with daily extraction of CAIR data from 3

sources for complex querying and analysis using SQL Server DTS. MS

Reporting Services/Excel and Share Point used for reporting.

Jan. 2002 - November 2003 Walt Disney Internet Group

Hewlett-Packard /Compaq Computer Corporation Portland, Oregon

Data Architect (Architect, ETL, OLAP, data modeling, reports, etc.) to Walt

Disney Internet Group for construction of a huge data warehouse to

consolidate web click stream data from Disney, ESPN, ABC and other web

sites for infusion into a data warehouse supporting Epiphany 6 (CRM) email

campaigns.

> Provided data analysis/modeling/specifications to construct

architecture, dimensional data models (ESPN, Disney Stores) in both

data warehouse and Epiphany 6 data warehouses.

> Performed ETL using SQL Server DTS on ESPN and Disney Stores and

tested for correctness and performance.

> Conducted survey of user's, elicited requirements, business rules,

specifications and a project plan for a Reporting Data Mart to support

Business Objects/SQL Server Analysis Services cubes for reporting and

analysis. Provided plans, architecture, data analysis and the

dimensional data model for the data mart.

December 2003 Washington Mutual Bank

Data Architect

> Investigated data processing for electronic funds transfers for

financial institutions under the Federal Reserve System. Data analysis

and examination of the data model provided information on potential

vulnerabilities of the architecture, system data and data transfers

which were then remedied. Provided plan for remedy of short falls.

Oct. 2000 - May 2001 WebTrends/NetIQ Corporation Portland, Oregon

Data Architect/Data Analyst/Application Developer

> Conceived and led development of the E-Business Siebel (CRM) Conduit,

a data transportation application that took Web click stream visit and

event data from the WebTrends Data Webhouse product (Log files) and

transfers the data into the Siebel product using DTS on the SQL Server

2000 platform. The Conduit provides an immediate reference in Siebel

Call Center as to what the customer is doing on the Web site. This

provided for "HOT LEADS" to the sales people and gave immediate dollar

return. Developed Visual Basic.net screens, applets, views and

logical/physical databases for the application and the extended

database tables using Siebel Tools, EIM, Workflow, Communication

modules.

Nov. 1999- Oct. 2000 WebTrends Corporation Contract Portland, Oregon

Meridian Technology Group

Data Architect/Data Analyst

> Provided architecture/prototyping of CRM integration of web click

stream data from WebTrends Data Web house Builder with customer data

from Siebel Customer Relationship Management (CRM) product for Cube

Building (OLAP) on SQL Server.

> Additionally, maintained product data models using Erwin. Extractions

from Siebel and Log files were made into a dimensional model for

analysis of CRM versus Web activity.

> Data Analysis of CRM data in conjunction with Web data (log files and

tagged pages) proved to be too unwieldy an architecture for the Web

house Builder product and integration into Siebel (CRM) was

recommended.

Healtheon/WebMD Contract

Meridian Technology Group

Program Manager

> Established the infrastructure and processes to manage the WebMD

Business Intelligence Group operating an E-commerce/Health Oracle data

web house, collecting click stream data.

> Delivered metrics and reports via BusinessObjects (OLAP) and data sets

for data mining. Added two sites and recommended changes to the

dimensional model.

NIKE Inc. Contract

Meridian Technology Group

Project Manager/Data Architect

> Lead completion of three Data Warehouse Pilots, using the Informatica

to extract NIKE Supply Chain data from SAP, I2, and a combination of

Oracle and Teradata databases to deliver reports in Brio (OLAP) and

HOLOS OLAP tools via the Web.

> Authored project plans providing steps for further development.

Collected requirements and business rules for the Nike Supply Chain

and produced a Requirements Matrix and strategy for implementation.

> Designed dimensional data model for the pilots and ETL plan/document.

> As a Mentor taught dimensional modeling and requirements gathering and

analysis classes to the team

1999 Family Services Division Multnomah County Oregon Contract

UPP Business Systems

Data Warehouse Program Manager/Architect

> Managed development of Health Data Warehouse for Multnomah County

(Portland, OR). Used MS SQL Server 7 in developing the

architecture/data model (Erwin) for data from multiple source

systems/applications including state sources; 2) data marts; 3) county

integration; and 4) user tools. Used DTS for ETL, Analysis Services

(OLAP) for Cube Building and Excel Pivot Tables for data display.

Developed Operational Management Plan

1996-1998 Orkand Corporation Falls Church, Virginia

Data Architect

> Designed financial data warehouse for Pan American Health Organization

(PAHO); developed a Leave Tracking System for PAHO using Visual Basic

with SQL Server

Project Leader/Business Analyst

> Established project to use Electronic Commerce (EC)/Electronic Data

Interchange (EDI) to transmit Federal program data from state and

large city grantee databases to a central DB2 database at HUD

headquarters.

> Presented successfully to Stake Holders (Gov. Officials) architecture

for the DB2 data warehouse.

> Mapped Orange County data into 864 EDI data transfer protocol for

initial test of infrastructure/architecture. Success of test led to

full scale development for additional loading from other large

grantees (New York City, Chicago, Texas).

Project Manager/Business Analyst

> Completed business analysis with a resultant FTS Information

Engineering Strategic Plan, developed dimensional data model for data

warehouse to support FTS. Led JAD sessions for requirements.

1993-1996 IIT Research Institute (IITRI), IRS Tax Systems Modernization

Institute (TSMI) Lanham, MD

Senior Research Systems Engineer (Team/Project Leader)

> Managed IRS Operating Systems Study examining operating systems to

provide direction for future IRS systems. Authored IRS Infrastructure

Study

> Established the IRS Interoperability Test Bed evaluating platforms and

operating systems.

> Analyzed the IRS's software development and authored the IRS's SDLC to

conform to SEI best practices. Provided an Implementation Plan.

> Provided IV&V, Quality Assurance and Configuration Management

improvements. Developed IRS Enterprise Network Operations Requirements

and Network Operations Study documents.

1990-1993 McDonnell Douglas Space Systems Company NASA Headquarters,

Washington, DC

Project Manager (Managed 9)

> For NASA Shuttle Support at the NASA Space Flight Weather Office,

established Artificial Intelligence Laboratory for the following

projects: MIDDS Network Diagnostics System, KSFC Expert System Model

for T-Storm Prediction and the KSC Neural Network for Lightning

Prediction.

> Designed architecture for meteorological forecasting that provided for

the processing of multiple, weather data-flows through neural networks

for pattern-recognition, followed by a fuzzy/expert system to provide

weather prediction. Received appreciation award from NASA and MDSSC.

> Provided NASA Weather Program Architecture, Strategic Plan, and

Network Security Plan.

Project Manager (Managed 23-31, Coordinated multiple NASA Offices)

> Managed the NASA Office of Space Flight LAN/WAN integration project

moving NASA Headquarters to a new location without any network

downtime. Recognized by NASA.

1988-1990 Bendix Field Engineering Corporation NASA Goddard Space Flight

Center, MD

Senior Space Systems Engineer

> Supported NASA with policies, concepts, plans, models/analysis for the

Tracking Data Relay Satellite System (TDRSS) satellite system and NASA

Shuttle Networks.

> Provided the Data Accountability Study for the Hubble Space Telescope

(HST), and Gamma Ray Observatory (GRO), analyzing the data flow for

each that "significantly contributed to the success of the mission."

Recognized by NASA.

Contact this candidate