SUMMARY:

• Information Technology Expert providing Consulting, Management and Hands On expertise of trouble - free design, development and deployment of effective data systems to support decision-making through superior leadership, planning, organization, team building, mentoring, communication, analysis, modeling, process/organizational design, development and work ethic.
• Agile Data Warehouse, Enterprise Architecture using Togaf and Zachman Framework Methodology, Data Modeling using E/R and Dimension Models, Canonical, Conceptual, Logical and Physical, Master Data Management, Data Governance
• Big Data Research and Development using Artificial Intelligence Architecture
• Database Design, Analysis, and Modeling, Data Migration, Profiling, Data Cleansing ETL, Database Tuning for Performance, Reports Design and Delivery
• Consulting, Business/Organizational Analysis, 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, CRM
• Chief Operations Officer, GPS Development Division Director, Chief Pilot Instructor, Project Manager, Author of Policy, Plans, Requirements, Analysis and Development Documents, Mentoring, Project Presenter/Briefer
• Industries - Healthcare, Financial Services (IDS), Retail, Telecom, Supply Chain, Manufacturing, Department of Defense, Federal Government, Pan American Health Organization Financial Data Warehouse
• Extensive knowledge of the application of Industry Data Models and Roadmaps - IBM Banking/Financial Model and Teradata Financial Services, Health and Communications Logical Data Models, and use of ITIL for basis of IT service delivery

TECHNOLOGIES

Teradata, Netezza, PI

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

PROFESSIONAL EXPERIENCE:

Consultant/Data Architect

Confidential, Moses Lake, Washington

Responsibilities:

• Business Analysis/Data Architecting performed for the Information Technology Division to raise the group’s level on the Gartner Information Technology Maturity Model.
• Provided an Organizational/Operational Assessment and Solutions Implementation Plan based on ITIL to address needs.
• Environment included SAP, MES, Prism, PI, etc. using VM and the Cloud.
• All facets of IT were addressed as well as organizational structure and Master Data Management/Data Governance.
• Business Intelligence Architecture was addressed separately with solutions scoped for inclusion of Big Data solution using Hadoop for the production operations.

Confidential, North Carolina

Data Architect/Data Modeler

Responsibilities:

• Data Architect/Modeler in Agile Environment, creating Erwin 3rd Normal Form Logical (LDM) and Physical (PDM) data models and Source to Target Mapping (S2TM) for BC/BSNC data migration of health data warehouse in Teradata to employ Facets.
• Produced XML document (CDFX) which contain all information pertaining to Data Element (metadata, S2TM, Data, description, Change log, etc.)

Confidential, Bellevue, Washington

Enterprise Senior Data Architect/Data Modeler

Responsibilities:

• Teradata Data Architect in Agile Environment, creating data warehouse dimensional Logical (LDM) and Physical (PDM) data models and Source to Target Mapping (S2TM) for Confidential 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 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.

Confidential, Illinois

Enterprise Data Architect/Data Modeler

Responsibilities:

• Developed a data architecture model for modernizing the Confidential Enterprise Architecture to include Student Social Networking with a Hadoop Solution.
• 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.
• Provided Master Data Management/Data Governance Roadmap

Confidential, California

Data Architect/Data Modeler

Responsibilities:

• Used ER Studio Data Architect for logical and physical data modeling and source to target mapping for ETL development.
• Developed data quality method.
• 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)

Confidential

Chief Operations Officer/System Architect

Responsibilities:

• 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, and CRM Express. Provided data analysis/mining for marketing and sales.

Confidential, Portland, Oregon

Data Warehouse Architect/Data Analyst

Responsibilities:

• Collected and analyzed requirements for data integration/modeling, and ETL. HSS Winstrat and 3M groupers used in analysis of Medicare/Medicaid costs.
• Data analysis with PL/SQL Business Intelligence queries using SQL Navigator. Tweaks using Erwin were provided for a more robust data model and better performance.

Confidential, Forest Grove, Oregon

Data Architect

Responsibilities:

• As Business Analyst collected requirements and business rules to produce requirements document, data model, and technical architecture with project plan for implementation.
• Restructured the data model into a dimensional schema, Operational Data Store (ODS), and changes to the process/model provided a more rapid data access (near real time) for production line corrections, analysis, and inclusion of chemical bath data.

Confidential, Portland, Oregon

Business Intelligence/Data Analyst

Responsibilities:

• 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.

Confidential, Portland, Oregon

Data Architect

Responsibilities:

• 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.

Confidential

Data Architect

Responsibilities:

• 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.

Confidential, Portland, Oregon

Data Architect/Data Analyst/Application Developer

Responsibilities:

• 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 Confidential Data Web house product (Log files) and transfers the data into the Siebel product using DTS on the SQL Server 2000 platform.
• The Conduit provides an immediate 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.

Confidential, Portland, Oregon

Data Architect/Data Analyst

Responsibilities:

• Provided architecture/prototyping of CRM integration of web click stream data from Confidential 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.

Confidential

Program Manager

Responsibilities:

• Established the infrastructure and processes to manage the Confidential Business Intelligence Group operating an E-commerce/Health Oracle data web house, collecting click stream data.
• Delivered metrics and reports via Business Objects (OLAP) and data sets for data mining.
• Added two sites and recommended changes to the dimensional model.

Confidential

Project Manager/Data Architect

Responsibilities:

• Lead completion of three Data Warehouse Pilots, using the Informatica to extract Confidential 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 Confidential 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

Confidential

Data Warehouse Program Manager/Architect

Responsibilities:

• 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

Confidential, Falls Church, Virginia

Data Architect

Responsibilities:

• Designed financial data warehouse for Pan American Health Organization (PAHO); developed a Leave Tracking System for PAHO using Visual Basic with SQL Server
• 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.
• 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.