Senior Data Architect / Snowflake Data Architect
Resume:
EXECUTIVE SUMMARY
Senior IT Professional Specializing in Enterprise Information Architecture and Enterprise Information Management, with a Special Focus on:
IT Strategy and Transformation
Information Architecture Vision, Strategy and Roadmap
Information Governance and Stewardship
Information Architecture Tools, Techniques and Best Practices
Information Federation & Virtualization
Enterprise Data Warehouse Architecture and Design
Business Analytics and Optimization
Relational Database Architecture and Mgmt (Snowflake, Teradata, MySQL, DB2, etc.)
Specialty Areas:
Enterprise Data Warehouse Architecture and Design
Enterprise Data Architecture and Data Management
Enterprise Information Consolidation & Integration
Business Analytics & Optimization
Teradata & IBM Industry Data Models
IBM Information Management Solutions
Data Strategy, Architecture, Implementation & Management
Snowflake AI: ML, Cortex Functions
Snowflake Semantic Layer
Industry Experience:
Entertainment
Insurance
Utilities
Manufacturing
Automotive
Finance
Health Care
Native/professional: English, Italian, French, Spanish
Good working knowledge of German, Dutch, Danish, Swedish, Finnish, Chinese, Japanese
我会说中文
日本語ができます
PROFESSIONAL EXPERIENCE
NBC UNIVERSAL + 09/2021 – 09/2025
VERSANT MEDIA 10/2025 – 05/2026
Universal City, California
SR. DATA ARCHITECT ~ STAFF DATABASE ENGINEER
Lead and Participate in Gathering Business Requirements and Analysis of Source Systems
Define Underlying Data Sources and Transformation Requirements, Design Suitable Logical/Physical Data Models, and Develop Metadata for the Data Warehouse/Analytical Reporting
Create & Update 3NF and Dimensional Logical & Physical Data Models and Create Physical Teradata & Snowflake Databases for Various Projects across Various Business Units
Provide Guidance to ETL and BI Development Teams on Optimal Data Retrieval Strategies and Transformation Requirements
Document Data Management Processes and Mentor Other IT Staff to Develop Data Analysis and Data Modeling Skills
Develop Standards, Guidelines and Compliance Rules, for Data Modeling, Metadata Management, Data Integration and Business Intelligence
Develop Data Quality and Master Data Management (MDM) Standards, Managing the Enterprise Data Models and Managing All Metadata in the Current Data Warehouse Environment, Contributing to the Collibra Data Dictionary
Perform DBA Activities on both Snowflake and Teradata platforms, Including Physical Database Design & Performance Tuning, Cost Monitoring, Shares & Replications
Participate in Planning & Execution of POC/Pilot Projects for Teradata-to-Snowflake Cloud Migrations
Assist During Software & Hardware Upgrades and Migrations, Including Working Across Cross-Functional Teams to Plan and Coordinate Teradata to AWS/Snowflake Migrations
Support the Following Business Organizations: TV Distribution, Filmed Entertainment, Parks & Resorts, Studio Operations, Content Distribution, Content Research
SKECHERS INC
Manhattan Beach, California 03/2021 – 09/2021
SR. DATA ARCHITECT
Develop a Thorough Knowledge and Understanding of Cross System Integration, Interactions and Relationships in Order to Develop an Enterprise View of Skecher’s Data Assets and Future Needs
Design, Coordinate and Execute Pilots/Prototypes/POCs to Provide Validation on Specific Scenarios and Provide Deployment Guidance
Perform Data Source Gap Analysis and Create Data Source/Target Catalogs and Mappings
Design and Implement Conceptual, Logical, and Physical Data Models for Enterprise Data Warehouse and Business Intelligence Systems
Design Cloud-Based Data Warehouse & Operational Reporting Databases
Lead Multiple Projects and Efforts to Orchestrate and Deliver Cohesive Data Solutions in Partnership with Related Architectural Teams
Build End-to-End Data Strategies Designed with Holistic Systemic Fit Including Specific Post-Launch Operational Processes
Facilitate Workshops to Define Business Requirements and Develop Solution Designs
Design Database Transaction Structures and Patterns for Enterprise Level Usage as well as Direct Usage of Canonical and Enterprise Data Models
Apply enterprise and solution architecture decisions to data architecture frameworks and models
Maintain a Corporate Repository of all Data Architecture Artifacts and Procedures
Recommend/Assure Technical Functionality (e.g. Scalability, Security, Performance, Data Recovery, Reliability, etc.) for Data Engineering
Collaborate with Other Technical Teams to Deliver Data Solutions that Meet Business and Technical Requirements
Collaborate with All Areas of Data Management as Lead to Ensure Patterns, Decisions, and Tooling are Implemented in Accordance with Enterprise Standards
Collaborate with IT Teams, Software Providers and Business Owners to Predict and Implement Data Architecture Solutions that Address Business Needs for Collection, Aggregation and Interaction with Multiple Data Streams
TECHNOLOGY: AWS, Snowflake, Teradata, Databricks, MariaDB, Erwin Data Modeler, Talend Data Profiler, GitHub, JIRA
NBC UNIVERSAL
Universal City, California 05/2017 – 05/2020
SR. BI DATA ARCHITECT
Led and Participated in Gathering Business Requirements and Analysis of Source Systems
Defined Underlying Data Sources and Transformation Requirements, Designed Suitable Logical/Physical Data Models, and Developed Metadata for the Data Warehouse/Analytical Reporting
Created Entity-Relationship and Dimensional Data Models and Physical Databases for Relevant Projects across NBC/Universal Business Units
Documented Data Management Processes and Mentored Other IT Staff to Develop Data Analysis and Data Modeling Skills
Developed Standards, Guidelines and Compliance Rules, for Data Modeling, Metadata Management, Data Integration and Business Intelligence
Developed Data Quality and Master Data Standards, Managing the Enterprise Data Model and Managing All Metadata in the Current Data Warehouse Environment, Contributing to the Collibra Data Dictionary
Contributed Heavily to Teradata DBA Activities, Including High Performance Physical Database Design & Performance Tuning
Participated in Planning & Execution of POC/Pilot Projects for Teradata-Snowflake Cloud Migrations
Assisted During Software & Hardware Upgrades and Migrations, Including Working Across Cross-Functional Teams to Plan and Coordinate Teradata to AWS/Snowflake Migrations
Created Data Models (Logical & Physical) for Snowflake Target Applications and Provided Guidance to ETL and BI Development Teams on Optimal Data Retrieval Strategies and Transformation Requirements
Supported the Following NBCU Business Organizations: TV Distribution, TV Production, Filmed Entertainment, Parks & Resorts, Studio Operations
MATTEL, INC
El Segundo, California 08/2015 – 12/2016
SR. CONSULTANT ~ INFORMATION ARCHITECT
Advised and Provided Guidance on Information Architecture, Integration and Management of Supply Chain Systems
Participated in Shaping Vision and Strategy for Information Architecture Foundation
Provided Technical Leadership in the Implementation of an Operational Data Store (ODS), Data Quality (DQ), Data Governance (DG) and Master Data Management (MDM) program using IBM InfoSphere Information Server’s Information Governance Catalog (IGC), covering Customer, Product, Inventory, Orders, and Shipments
Oversaw Analysis, Design and Implementation of Supply Chain Analytics Systems
Acted as Technical Liaison between Legacy Systems and BI/EDW Organizations
Participated in Vendor RFPs, Articulating Requirements and Refining Scope and Success Criteria
Participated in Planning and Execution of Various IT Projects
TERADATA CORPORATION
Los Angeles, California 11/2011 -- 08/2015
SR. PRESALES ENGINEER ~ SOLUTION ARCHITECT
Responsibilities included:
Leveraging Data Warehouse Technical Knowledge to Promote Sales of Data Warehouse Solutions within Several Industry Verticals, through Expert Knowledge and Experience in Data Architecture, Data Mart Consolidation/Redesign, Data Governance & Stewardship, Data Lineage and Profiling
Playing an Active Role in Pre-Sales and Post-Sales Activities, Ensuring a Long-Term Partnership with Customers and Enhancing Customer Relationships
Providing Technical Consulting to Support Sales and Professional Services (PS) Activities
Advising on Competing Products in the Data Warehouse, BI and Big Data Spaces: Teradata UDA, IBM BigInsights, Oracle, HP, Pivotal Data Hub, Hadoop Distributions (Cloudera, Hortonworks), MapR, NoSQL Databases (MongoDB, Cassandra, etc.)
Articulating Customized Solutions to a Wide Spectrum of Business Problems using RDBMS, Master Data Management (MDM), Cloud Services (PaaS/SaaS), Data Mart Consolidation, Big Data, Industry Data Models, and Other Related Solution Offerings
Functioning as a Trusted Advisor to the Customer's Decision-Makers by Establishing Credibility and Expertise in both Information Architecture and Information Management
Contributing to the Financial Objectives of the Team through Business Development and Demand-Creation Activities
TOYOTA MOTOR SALES USA
Torrance, California 01/2010 – 06/2011
SR ENTERPRISE INFORMATION ARCHITECT
Projects:
-Enterprise Information Architecture Services
-IBM InfoSphere Data Federation Platform Support
Sr. IT Architect Responsibilities included:
Creating and Maintaining High-Quality, Flexible, Logical and Physical Data Models using ERwin Data Modeler and IBM IDA (InfoSphere Data Architect).
Providing Guidance and Leadership in the areas of Data Governance and Stewardship, Data Lineage and Profiling
Reviewing Data Integration Requirements from Project Teams and Evaluate Eligibility of Data Federation as a Viable Data Integration & Virtualization Option
Working Closely with Application Teams and Business Users to Identify Pilot Projects, Reporting Requirements, KPIs, Data Sources and Needed Facts & Dimensions
Assisting and Mentoring Project Teams with Interaction with Federation Servers and Back-End Data Sources
Consulting and Participating in the Configuration and Administration of Data Federation Servers on UNIX/Solaris and z/OS (Classic Federation), including DB2 LUW HADR
Designing, Developing and Implementing Federated Data Models and Federated Application Objects using IBM IDA (InfoSphere Data Architect), Classic Data Architect (CDA) and IBM Information Server’s IISD (Information Services Director)
Environment: DB2 z/OS V8, DB2 LUW 9.5, IMS/VS V7, Oracle 9i/10g, IBM InfoSphere Classic Federation, IBM InfoSphere Data Federation, IBM InfoSphere Information Server & Information Services Director (IISD), ERwin 7.2, IBM InfoSphere Data Architect (IDA), Endeca
TOYOTA MOTOR SALES USA
Torrance, California 11/2007 -- 04/2009
SR ENTERPRISE INFORMATION ARCHITECT
Project: Implementation of IBM WebSphere/InfoSphere Data Federation Technology
Platforms and Solutions
Implemented IBM InfoSphere Data Federation as a New Technology Platform to Expedite Delivery of Application Solutions Requiring Data from Both Legacy & Distributed Systems, as well as a New Approach to "Federate" Existing Data Marts within a Bottom-Up Approach to an Enterprise Data Warehouse Framework.
Sr. IT Architect Responsibilities included:
Performing in a Lead Role in the Coordination of Technology Proof of Concept (POC) Setup and Execution
Reviewing Data Integration Requirements from Project Teams and Evaluate Eligibility of Data Federation as a Viable Data Integration & Virtualization Option
Working Closely with Application Teams and Business Users to Identify Pilot Projects, Reporting Requirements, KPIs, Data Sources and Needed Facts & Dimensions
Assisting and Mentoring Project Teams with Interaction with Federation Servers and Back-End Data Sources
Consulting and Participating in the Configuration and Administration of Data Federation Servers on UNIX/Solaris and z/OS (Classic Federation), including Setup and Operation of DB2 LUW HADR
Designing, Developing and Implementing Federated Data Models and Federated Application Objects using ERwin and IBM RDA (Rational Data Architect), Classic Data Architect (CDA) and IBM Information Server’s WISD (Information Services Director)
Creating and Executing Migration/Promotion Scripts across Federation Environments
Tuning Federated Queries Performance
Developing Standards, Procedures and Guidelines for InfoSphere Data Federation
Environment: DB2 z/OS V8, DB2 LUW 9.5, IMS/VS V7, Oracle 9i/10g, IBM InfoSphere Classic Federation, IBM InfoSphere Data Federation, IBM InfoSphere Information Server & Information Services Director (WISD), ERwin 7.2, IBM InfoSphere Data Architect (IDA)
AUTOMOBILE CLUB OF SOUTHERN CALIFORNIA
Costa Mesa, California 04/2007 -- 10/2007
LEAD SR. INFORMATION ARCHITECT
Projects: - Call Center Analytics Reporting System
- Travel Portal Reporting System
Lead Sr. Data Architect Responsibilities included:
Interfacing with Business Clients and Project Sponsors
Participating in Business Requirements Capture Sessions
Creating 3NF/Normalized Transitional Logical Data Models
Creating Multi-Dimensional (Star Schema) Physical Data Models
Assisting & Mentoring ETL Design & Development Staff
Defining Data Architecture and Data Governance Standards
Environment: ERwin 4.1, Business Objects, Siebel, Teradata, MS SQL Server, Informatica ETL
EDIC INSURANCE COMPANY
Agoura Hills, California 07/2006 – 03/2007
LEAD SR. INFORMATION ARCHITECT
Projects: - Web-Based Policy & Claim Inquiry System
- Reporting System in the Areas of Finance, Actuarial and Enterprise
Lead Sr. Information Architect responsibilities included:
Participating in Requirements Gathering Sessions with Business Systems Analysts and Client Representatives
Creating Conceptual and Logical Data Models using Standard 3NF Modeling Techniques
Forward-Engineering Logical Data Models into Physical Database Schema Designs
Maintaining Data Dictionary
Collaborating with ETL Design & Development Staff in an Agile/SCRUM environment
Environment: Embarcadero ER/Studio 7.1, Cognos ReportNet, Cognos ETL, Oracle 10g, SVN
PARAMOUNT PICTURES
Home Entertainment Division
Hollywood, California 06/2005 – 06/2006
SR. DATA ARCHITECT / DATA WAREHOUSE ARCHITECT
Projects: - Home Entertainment Data Warehouse (Sales & Operations)
- Data Warehouse Conforming Dimensions
- Order-To-Delivery Data Mart
- Vendor-Managed Inventory (VMI) Data Mart
Sr. Data Architect Responsibilities included:
Conducting Exploratory Meetings and Joint Design Sessions with Project Sponsors and User Representatives in order to Define Project Scope and Gather/Define/Document Business Requirements
Performing Conceptual & Logical Data Modeling using Standard 3NF Modeling Techniques, as well as Star Schema & Snow Flake Techniques for Data Warehouses and Data Marts
Transforming Logical Data Models into Physical Models with Special Emphasis on Denormalization Techniques to Optimize Performance
Working Very Closely with Development Staff to Provide Guidance and Technical Assistance in the Form of Data Mapping to Legacy Systems, ETL Strategy, SQL Complex Query Design, and Fast Performing Data Loads into the Target Database Tables
Performing Post-Implementation Reviews to Assess whether Data Integrity, System Utilization and Response Time Targets have been Successfully Achieved and whether Additional Database Turning is Needed
Environment: PowerDesigner 11.0, AllFusion ERwin 4.1, Cognos ReportNet, MS SharePoint, Sybase IQ, MS SQLServer, EAI/ESB tools
WARNER BROS STUDIOS
Burbank, California 01/2002 –03/2005
SR. DATA ARCHITECT and
SR. DB2 DATABASE SPECIALIST
Projects: - Payroll Management System
- PeopleSoft 7.01 HR System
- Domestic Media Tracking System
- Domestic TV Distribution System
- Rights & Residuals Systems
- Network Television Systems
Sr. Data Architect Responsibilities included:
Defining Business Requirements and creating Data Flow Diagrams
Reverse-Engineering from Existing Systems
Performing Logical Data Modeling
Transforming Logical Data Models into Physical Models
Providing Guidance to Development Staff
Defining Data Architecture and Data Governance Standards
Sr. DB2 DBA Responsibilities included providing Overall DB2 Technical Support:
Performing Logical & Physical DB2 Database Design
Object Sizing and Defining DASD Requirements
Providing Database & SQL Support to Application Developers
Providing 24x7 Around-the-Clock Production Support
Providing DBA Support during Migration from OS/390 to z/OS and from DB2 UDB OS/390 V5 to V7
Performing Ongoing Database & Application Performance Tuning (Both Pre- and Post-Production)
Performing Ongoing Database Monitoring and Capacity Planning
Environment: DB2 UDB z/OS V7, DB2 UDB AIX/SOLARIS V7-8, DB2 CONNECT 7.1, NET.DATA, IBM DATA PROPAGATOR V7, COBOL, CA-PLATINUM TOOLS, BMC CHANGE MANAGER, ERWIN 4.0, QMF, DB-ARTISAN, ER-STUDIO, PEOPLESOFT 7.0, INSYNC-DB2, MOVE-DB2, CA-INSIGHT PERFORMANCE MONITOR, BUSINESS OBJECTS
Prior to 2002, Various Other Consulting Work at the Following Clients, as a DATA ARCHITECT, DATABASE ARCHITECT and DATABASE ADMINISTRATOR in Mainframe Environments with DB2, MVS and z/OS, CICS, IMS/DL1, IMS DB/DC:
-FARMERS INSURANCE COMPANY
-IBM GLOBAL SERVICES
-NISSAN MOTORS CORP
-SOUTHERN CALIFORNIA EDISON
-MAZDA MOTORS OF AMERICA
-FHP – FAMILY HEALTH PLANS
-AUTOMOBILE CLUB OF SOUTHERN CALIFORNIA
-ORANGE COUNTY REGISTER
-HONDA MOTORS OF AMERICA
-SECURITY PACIFIC NATIONAL BANK
-TRW INFORMATION SERVICES DIVISION
-IBM PROFESSIONAL SERVICES
EDUCATION
UNIVERSITY OF CALIFORNIA
Irvine, California
Diploma -- Management Information Systems
CLC - COMPUTER LEARNING CENTER
Anaheim, California
Diploma, "Computer Systems and Programming"
LICEO SCIENTIFICO
Italy
Diploma, Science & Mathematics
OTHER
United States Citizen
EU Citizen (Italy)
IBM Western Regional Manager Excellence Award
IBM Systems Engineering Symposium Award for Outstanding Performance
Orlando B. Manta
Azusa, CA 91702
+1-626-***-**** -- ********@*****.***
http://www.linkedin.com/in/orlandomanta
Contact this candidate