Randy Hills

Principal Information Architect, Data Warehouse Architect

Celebration, Florida, 34747

407-***-****

ade8b0@r.postjobfree.com

https://www.linkedin.com/in/randy-hills-073119b1/

Profile

Randy consistently delivers high visibility, high value solutions for major organizations including currently architecting and delivering solutions for The Disney Company from 1998 to the present.

Focusing on enhancing business results and capabilities, Randy provides leadership in Data Architecture, Metadata Strategy, Metadata Management, Data Warehousing Data Modeling, Master Data Management, Information Architecture, and Data Governance.

From 1980-2002, Randy was an independent consultant, providing Oracle and Informix database administration, development, data modeling and data warehouse leadership for a range of industries and companies including The Walt Disney Company, JC Penney, First Union (Wells Fargo), Fidelity Investments, Hitachi, American Honda, Sun Microsystems, Wal*Mart, Jefferson Pilot, Aramark, GTE, ADC Telecommunications, Moore Business Forms, American Benefit Plans Administrators, Hotel Clearing Corporation, and American Diversified Savings Bank.

He is currently Information Architect for The Walt Disney Company providing Big Data and Cloud solutions on AWS Hadoop and Teradata, developing Walt Disney Park and Resorts Reference Architecture throughout his employment at the Disney Company, providing solutions for Sales, Marketing, Revenue Management, Merchandise, Food and Beverage, and Operations.

Randy is skilled in data architecture, data-focused solution architecture, data modeling tools (ERwin, ER Studio/Data Architect, PowerDesigner), modeling methodologies (3NF, dimensional/star, flattened columnar), system development life-cycle methodologies (including agile scrum and modified scrum for Data Warehousing using Jira and VersionOne), industry standard data models (Teradata, Silverston), ETL software (Informatica, DataStage), various databases (Teradata, Oracle, SQL Server, Informix and to a lesser degree No SQL databases), various SQL tools (Rapid SQL, Teradata SQL Assistant, Toad, Dbeaver) and C++ and Python.

He provides leadership for Disney in Metadata Management, implementing their current data warehouse data catalog, and in Data Governance for operational systems being ingested into the data warehouse. He led the effort at Disney Parks and Resorts to develop their metadata management strategy and to select ASG Rochade as their Metadata Repository.

During Randy’s leadership at The Disney Company he was instrumental in the delivery of four generations of data warehouses and three generations of master data management solutions for individual and organization data as well as principal designer for most of Parks and Resorts sales and marketing major analytical solutions.

SUMMARY

Over forty years of experience in Information Systems, with an emphasis in Data Warehousing Architecture, Business Intelligence, Data Architecture, Information Architecture, Data Modeling, Database Administration, and Software Design. Skilled in management, planning, development, consensus building, thought leadership, technology application and implementation solutions. Has strong interpersonal communications, creative and analytical skills. Has proven cross-functional expertise in:

Data Warehouse Architecture on various platforms including Teradata and AWS Hadoop

Big Data experience with the Walt Disney Company

Machine Learning

Business Intelligence

Data Architecture

Information Architecture

Master Data Management

Entity-Relationship and Dimensional Modeling (ER Studio, Erwin, PowerDesigner)

Business Intelligence

Enterprise Data Management (Rochade, in-house solution, data lineage solutions)

Oracle Database Administration

Informix Database Administration

Team Leadership (Data Architecture, project management, design and solutioning teams)

Partnership with users of Tableau, MS Power BI, Business Objects, Lumira, and SAS

Marketing and sales data and processes

Software Development

Systems Analysis/Design

Data Analysis, Process Analysis

Physical Database Design

SQL, ETL scripting, various programming languages including Python

Project Management

PROFESSIONAL EXPERIENCE

The Disney Company, Parks and Resorts Lake Buena Vista, Florida October 2008 – present

Principal Information Architect

Principal Information Architect for Data Warehousing engaging other data warehouse disciplines to extend existing data warehouse environment

Principal Information Architect for Operational Systems from 2002 to 2015.

Designed and delivered successful Teradata Data Warehouse of over 1500 entitles and 23,000 attributes covering all important business areas of including Finance, Resort and Parks sales (including 143 tables, 2500 attributes for Resort Sales and the POS subject area of 90 tables and 2000 attribute), Marketing, Guest Relation Management, Revenue Management, Merchandise, Food and Beverage, Disney Cruise Lines, Adventures By Disney and over fifty other subject areas

Developed and implemented Information Architecture and design for AWS Hadoop

Switched from architectural responsibility over both operational and analytic areas to focus primarily on studio delivery activities

Partnered with application architects and other data architects on enterprise level architecture to deliver replacements for previous Resort Sales and Booking System, Ticketing System, Merchandise System, Table Management System and other replaced applications

Primary architect for improving existing data warehouse environment on Teradata to better facilitate ease of data usage

Coordinated leverage of Rochade Data Management System and a data catalog of content of Teradata Data Warehouse, Google Big Query Data Warehouse and AWS Hadoop Data Warehouse

Took over ownership of data catalog responsibilities when Disney terminated use of Rochade

Principal Information Architect for AWS Hadoop and Microsoft Azure environments

Partnered closely with previous VP of Information Management on Reference Architecture and exploring opportunities to improve the current environment, including conversations with Teradata, Vertica, SAP, SAS and other vendors and implementation of Agile delivery methodology.

Part of a team that evaluated full range of data virtualization, selecting and implementing Ytrail

Partnered on extending Teradata environment with AWS and cloud based solutions expanding engagement, delivery and implementation patterns continuing to support existing users of Business Objects, Power BI, Tableaux and SAS

Received TOGAF, Mega, Rochade, Scrum, general architecture, big data, cloud, security as well as other training; attended multiple data warehouse conferences including Disney’s own analytic conferences as well as TDWI and Teradata conferences

Familiar with Apache Spark, Scala, R and machine learning techniques and principles

The Disney Company, Parks and Resorts Lake Buena Vista, Florida July 2002 -- October 2008

Principal Data Warehouse Architect

Converted from consultant to cast member after being offered a Principal Architect position

Became the lead for newly formed Data Architecture Team, establishing processes, purpose, direction and engagement model for the team

Established comprehensive set of data architecture and data modeling standards

Responsible for interviewing and mentoring new data architects for the Data Architecture Team

Worked closely with newly hired director to build out new data warehouse on Teradata platform

Led effort to chose an enterprise metadata repository and selected staff to support it, ultimately choosing Rochade as the metadata repository and an administrator and data governance liason.

Responsible for ensuring metadata properly captured in operational systems and managed in data warehouse appropriately. Created standards for ETL jobs to work with metadata.

Part of data warehouse implementation team that was able to roll out rapidly delivered data warehouse projects, extending the data warehouse capabilities in focused, manageable and on-time, on-budget efforts

Delivered BI capabilities for Sales, Marketing, Revenue Management, Merchandise, Food and Beverage, Cruise Lines, Guided Tours (Adventures by Disney), Operations, Labor and Maintenance

Developed and implemented Information Architecture for the Teradata platform

Primary data modeler for all Enterprise Data Warehouse Models (3NF) and dimensional modeling

Modeled Party MDM so that implemented tables were aligned with Enterprise Data Warehouse tables for the Party, Locator (Address, Phone, Email) subject area

The Disney Company, Parks and Resorts Lake Buena Vista, Florida June 1998 -- July 2002

Data Warehouse and Data Architecture Consultant

First dedicated Data Warehouse resource for Walt Disney Parks and Resorts

Developed Parks and Resorts Data Warehouse Strategy

Led over 80 JAD sessions with various business areas to gather requirements for first architected data mart and central data warehouse

Reviewed consultants’ effort to capture sales and marketing portion of enterprise data model

Took over modeling responsibilities for the enterprise model

Delivered initial enterprise data model focused on sales and marketing

Delivered 3NF data model for Central Data Repository (CDR)

Delivered dimensional models in standard star schema format

Transitioned data warehousing responsibilities to cast members (employees) to engage full time in “Destination Disney” as the Data Architect in Parks and Resorts effort to replace their existing operational systems with more guest-focused applications

Delivered a reference architecture that included continuing the CDR, adding an Operational Data Store (ODS), additional marts and better aligning source systems with analytic needs.

Worked with external consultants to establish data governance

First Union, Charlotte, North Carolina June 1997 -- June 1998

Data Warehouse and Database Administrator Consultant

Key member of team that implemented new multi-terabyte Informix XPS data warehouse

Partnered with data modelers, developers and external architects to deliver first phase of data warehouse focused on customer data for marketing needs

Part of data governance team addressing business usage needs, semantic alignment and data quality

First phase of data warehouse successfully delivered using Ab Initio Empower (ETL), Informix XPS (MPP database), Microstrategy, Cognos and ERwin

Emergent Technology, San Mateo, California January 1997 - June 1997

Informix Database Administrator, Data Warehouse Consultant

Database Administrator of Informix XPS for data warehousing

Learned key principles of data warehousing as consultant

Received internal Informix XPS training

Partnered with other Emergent consultants at the data warehouse engagement at Nike

Sun Microsystem, Bentonville, Arkansas July 1996 -- December 1996

Informix Database Administrator, 4GL, ESQL and shell script programmer

Part of Sun Microsystem Team for Proof of Concept at Wal*Mart to convert existing implementations to Sun Microsystem platforms

One of four skilled developers on conversion effort

Part time Informix DBA

Successfully converted large collection of programs to Sun Microsystem platform within engagement timeline

Hitachi Semiconductors, Irving, Texas July 1995 -- July 1996

Informix and Oracle Database Administrator, Physical Database data modeler

Brought in as the single Informix DBA and after several weeks, received Oracle DBA training in order to replace the lead Oracle DBA, providing primary DBA services for all Oracle and Informix implementations.

Supported Oracle data warehouse used for analysis of fabrication efficiency and degree of semi-conductor quality with the purpose of predicting and enhancing product quality and efficiency

Partnered with and mentored by Hitachi’s data architect, extending my knowledge of data modeling best practices and patterns, learning Zachman framework and basics of data architecture.

J. C. Penney, Dallas, Texas Jan 1994 -- July 1995

ETL and application developer

Primary ETL developer for Informix Dynamic Server based ETL

Programmed in 4GL, C++, C ESQL, and COBOL ESQL

Developed all ETL and the data model design for JC Penney’s first marketing data mart

When not working on data mart, took on extra assignment coding programs for transactional systems

In spare time, created issue tracking and resolution software that was then used within and outside of team

Designed and implemented database structures for both data mart and operational implementations

Hotel Clearing Corporation, Dallas, Texas Jan 1993 -- December 1993

Software Developer, Database Designer, Analyst

Solely responsible for developing new Commission Entry and Management System

Performed roles of analyst, developer and database designer on all work

Enhanced and developed new ETL for HCC’s reporting database/analytics system

Mentored by senior manager on Texas Instrument’s design and development methodology and key concepts of data modeling

Various Consulting Assignments 1980 -- 1992

Consultant

Programmer, System Administrator, Analyst and thought leader for multiple consulting engagements

Trained employees in RSTS/E, VAX/VMS, DIBOL, Basic Plus 2 at American Benefits Plan Administrators from 1982-1983

Held key role for major mainframe to minicomputer data conversion effort for ABPA in from 1982-1983

Assigned as Project Manager on ABPA Claims Management IT team in 1983

Used various system development life-cycle methodologies including Method One.

Had development, analyst and project manager responsibilities at various companies including American Honda, Aramark, Jefferson Pilot, American Diversified Savings Bank, Moore Business Forms, Fidelity Investments, GTE, Family Health Plan, Carpenters Union of Southern California, ADC Telecommunications

Programming in C under DOS AND VAX/VMS

Programming in C on INTERGRAPH for DOS, UNIX, VMS

Programming in COBOL, VAX BASIC, DIBOL under VAX/VMS

Programming in C under XENIX and on Apollo

Programming in C++ on UNIX

Applications work included A/P, A/R, G/L, Trust Accounting, Contribution Accounting, Claims Processing, Billing, Job Costing, Inventory Control, Telecommunications, Mortgage Applications, and Design of Utilities for Intergraph Community (including best-selling “TextDesigner”)

Responsibilities included project manager, project leader, programming, system programming, system design, development, design of a medical claims system, conversions from IBM to DEC, system reorganizations, system performance optimization and user support

Taught classes to programmers and users

Digital Equipment Corporation, Los Angeles, California September 1979 -- December 1980

Instructor

Taught classes in RSTS/E User, System Management and programming

Learned Macro-11, Basic Plus, RSTS/E, VAX/VMS

California State University, Fullerton, California September 1975 -- May 1977

Computer Lab Student Consultant

Answered student questions and helped troubleshoot their programs

Provided student consulting for various languages including COBOL, Basic Plus, FORTRAN, COMPASS (Comprehensive Assembler language for CDC systems), APL, PL1, LISP, SNOBOL, ALGOL

Provided support for CDC and RSTS/E operating systems

EDUCATION

California State University, Fullerton, California 1973 -- 1978

Graduate courses in Music

Bachelor’s Degree in Music Composition

Courses in Computer Science, Mathematics and Physics as a Math/Physics double major

Authored a computer program that wrote music which I included in my first of two composition recitals

Contact this candidate