Principal Information Architect
Resume:
Randy Hills
Principal Information Architect, Data Warehouse Architect
Celebration, Florida, 34747
*******@*****.***
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