KENNETH (KEN) BROWN 770-***-**** Alpharetta GA adua9t@r.postjobfree.com linkedin.com/in/kennethdbrown

SENIOR DATA MODELER

Strategic Enterprise Data Architect with 15+ years of experience in implementing key corporate information assets into newly developed models to increase efficiency, improve performance, and achieve client growth goals. Expertise in data modeling across industries specializing in health care, retail, airline operations and logistics/supply chain management. Skilled in Integrated (3NF) Data Layer, Star-Schema Dimensional Modeling, and multiple Data Modeling tools - ERwin, Embarcadero, Power Designer, and Rational. CORE SKILLS

Relational Data Modeling (3NF) Dimensional Modeling (Star Schema) Business Analysis Analytic Roadmap Data Warehousing Source System Analysis Data Profiling/Data Analysis Data Integration Source/Target Mapping

PLATFORM/MODELING EXPERIENCE (10+ YEARS)

DB2/udb Star Schema data models for IBM Retail clients (5 YEARS SQL Server Star Schema data models for Transportation/Logistics (6 MONTHS) Teradata Relational Data Models (6 YEARS)

Non-Platform Logical Data Models (4 YEARS)

ERWIN DATA MODELER SKILLS (9 YEARS)

Reverse Engineering Naming Standards Conceptual/Logical/Physical Models Model Mart Model Compare/Merge Domain Standards Data Type Standards DDL Generation Metadata Management Hands-on data modeling STANDARD INDUSTRY MODEL EXPERIENCE

Healthcare Retail Travel and Hospitality Transportation and Logistics CAREER OVERVIEW

KDB Models, LLC Sept 2017 - Current

Federated Co-Op Limited, Canada October 2019 - – February 2020 Supply Chain Analytics Database Design

Loblaw/Shoppers Drug Mart, Canada April 2019 – June 2019 Designed Claims database for Next Generation Pharmacy Analytics solution; conducted Source System Analysis of several legacy feeder Pharmacy systems, produce data mapping into a target Health Care standard industry data model containing customized data requirements.

J.B. Hunt Aug 2018 - Jan 2019 supplement data modeling team with development of transactional, ODS and Star Schema data models on legacy DB2 and SQL Server platforms

Cricket Wireless (an AT&T subsidiary) Dec 2017 - Mar 2018, designed Cricket Records and Information Management (RIM) to conform with AT&T record retention standards.

Formed S Corporation as President and sole proprietor, practicing as a freelance Senior Data Modeler TERADATA Senior Professional Services Implementation Consultant Upstate, SC 2011-2017 Customized Teradata Industry Standard Data Models (iSDMs) for several domains/industries including healthcare, retail, airline, hospitality, and transportation. Lead consultant for the Healthcare domain. Guided clients on Enterprise Data Warehouse (EDW) strategy best practices including data governance and data modeling. Standardized methods for applying client customizations to different iSDMs ensuring ease of maintenance applying enhancements.

Analyzed Whole Foods Market EDW issues based on request from corporate leadership and suggested replacement of existing legacy data warehouse with integrated core layer data architecture.

Migrated Swift Transportation Financial and Driver Data Warehouse to Teradata’s 3-Tier architecture, developed a Relational 3NF model for the Core Data Layer

Improved enterprise data model for Petco Animal Supply by adding OMNI e-commerce capabilities including order management, inventory, merchandising, and supply chain functions; met deadline with quick turnaround.

Highlighted market segment profitability among flight carriers through analytic data architecture for Delta Airlines providing insight into eliminating less profitable PanAm flight segments.

Enhanced flight schedule model for Southwest Airlines by adding tactical operational plans with published flight schedules; provided foundation for analytics and insights addressing irregular business events.

Conformed airline data model to Emirates Airline international, commercial business requirements including reservations, ticketing, and loyalty functions.

Created extensions to Teradata’s Industry Standard Data Model for Healthcare domain o Enabled Walgreens operations POS/pharmacy integration plus Claims Processing requirements customizations. o Integrated new Target pharmacy operations system feed for Quality of Care and other Member and Provider healthcare analytics down to the Procedure level. WIPRO Solution Architect Richfield, MN 2010

Collaborated with stakeholders and team members on creating individualized models to achieve client growth goals.

Developed Analytics Roadmap for Best Buy aligning IT initiatives to corporate leadership objectives; defined target technology with near-term implementations and re-focused EDW to high value subject areas IBM GLOBAL SERVICES Associate Partner Atlanta, GA 2000 -2010 Improved BI strategy solutions as primary field practitioner; recruited and mentored staff of 6-8 in developing BI strategy roadmaps for clients. Directed technology platform installation and EDW architecture implementation for each corporate client.

Home Depot Engagement Manager for EDW migration to IBM DB2/udb database, managed 30+ team members including 5 system integrator partners while reporting directly to The Home Depot EDW Director on implementing successful sales analysis solution; improved unaudited sales reporting time for 1600 stores by decreasing frequency from one week to next day and increasing accuracy.

Developed Star Schema Data Architecture for Dillard’s re-engineering of the marketing promotions process. ü Acquired business requirements through JAD sessions with marketing to obtain 1) desired and gap KPIs 2) those dimensions which would be used to probe promotion performance variations and exceptions

Developed messaging architecture for Albertsons Consumer Driven Supply Chain initiative utilizing data modeling; enabled standard interfaces among Supply Chain applications.

Implemented standard XML interfaces for United Airlines Amadeus reservation project; increased efficiency in Service Oriented Architecture. Additional Experience:

IBM Global Services/MidMarket Management Consulting 1995-1999 BI Virtual National Practice Leader, Small & Medium Business Price Waterhouse Coopers, Consulting Senior Manager (8 YEARS) EDUCATION Bachelor of Arts VANDERBILT UNIVERSITY Nashville, TN CERTIFCATION Access Layer Design IBM Certified Consultant