Summary
Overview
Work History
Education
Skills
Timeline
Generic
Rodney Cole

Rodney Cole

Data Analyst
Dallas,TX

Summary

Senior Data Warehouse Architect Professional Summary

Mr. Cole is an Accomplished Senior Data Warehouse Professional with over 15 years’ experience in Data warehousing with Teradata, SAP , Oracle , Cloud Technology: Snowflake and AWS Redshift. He has provided designs for Data lakes, SAP EDW, AWS, Azure , Cloud Migrations, MDM, Data Governance on the Cloud Platforms AWS/Azure. Provided Cloud Architectures for Private and Public cloud DW strategies for data warehousing solutions to Fortune 500 Corporations. Proven understanding of complex Cloud Solutions for SAP DW/Cloud Analysis (SCA) HCM (Human Capital Management) Big Data with extensive experience in the critical skills and project leadership. Respected Data Warehouse Architect with history of creating system architectures that reduce costs and streamline operations. Ready to create design plans from whole cloth or tackle revamps of disparate networks full of outdated systems. Uses emerging and nascent technologies to create stress-free operations both on site and via remote locations and online. Top-notch Data Manager with solid background in designing and implementing data management solutions. Strong knowledge of database security, backup and recovery. Collaborative and dedicated to improving and optimizing database performance. Agile Chief Systems Architect with 15 years spent enhancing existing layouts as well as designing complete enterprise-class system architectures from ground up. Brings multi-national portfolio of successful system infrastructure designs to bear on every project. Employs vast technical skills in cloud-based architecture and database technologies to provide optimal architecture outcomes to scale and on time. Respected Data warehouse Consultant with history of creating system architectures that reduce costs and streamline operations. Ready to create design plans from whole cloth or tackle revamps of disparate networks full of outdated systems. Uses emerging and nascent technologies to create stress-free operations both on site and via remote locations and online. Respected [Job Title] with history of creating system architectures that reduce costs and streamline operations. Ready to create design plans from whole cloth or tackle revamps of disparate networks full of outdated systems. Uses emerging and nascent technologies to create stress-free operations both on site and via remote locations and online.

Overview

13
13
years of professional experience

Work History

Senior Data Analyst

Mindtree; HPE Enterprise
Houston, TX
10.2021 - Current
  • Responsible for providing snowflake Data Warehouse strategy and Framework for EDW/MDM/IDQ projects
  • Responsible for managing data migration of Legacy and DB to data warehouses snowflake cloud
  • Defined Data Quality Strategy utilizing snowflake/Informatica IDQ, data profiling and data catalog analysis
  • Designed Snowflake Cloud Data Architect strategy, Data Lake, Data warehouse, ETL, BI projects
  • Responsible for data architecture modeling for data lake, data warehouse using Snowflake, AWS/Azure
  • Leading IT /Business Team in end-to-end implementation of Snowflake cloud data warehouse solutions
  • Responsible for Snowflake data modelling, ELT, Loading Snowflake SQL, implementing DWH and ETL concepts
  • Advanced in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing
  • Analyzed query performance and tuning, time series and understand how are used to solve Issues
  • Responsible for deploying Snowflake features data sharing of DW Schemas events and lake-house patterns
  • Lead developers team Snowflake utilities, snow SQL, Snow Pipe, Big Data model techniques using Python
  • Lead workshops in designing and building Data Pipelines and Transformations using ETL tools / spark scripting to process and load the data onto Snowflake
  • Responsible for Snowflake resource usage cost and performance tuning of Snowflake SQL Queries
  • Responsible for data modeling of relational DB, NoSQL data stores, (star and snowflake, dimensional
  • Designed snowflake Data warehouse data security, Analytics, reports and data access controls
  • Responsible for EDW architecture and plans for data quality practice and data management
  • Conducted workshops with business and IT to understand analytics and reporting requirements
  • Responsible for capturing DQ requirements, defined quality thresholds, DQ reports & dashboards
  • Responsible for developing with business standards, rules, polices, procedures and IT systems
  • Developed current and future state DW architectural diagram’s, DEV, TEST and PROD architectures.

Customer Senior Data Analyst Consultant

Toyota Motor Corporation NA
Plano, TX
11.2020 - 08.2021
  • Provided snowflake Data Warehouse strategy and Framework for EDW/MDM/IDQ projects
  • Responsible for managing migration of Legacy Teradata warehouse and DB to snowflake cloud DW
  • Defined Data Quality Strategy utilizing snowflake/Informatica IDQ, data profiling and data catalog analysis
  • Designed Snowflake Cloud Data Architect strategy, Data Lake, Data warehouse, ETL, BI projects
  • Responsible for data architecture modeling for data lake, data warehouse using Snowflake, AWS/Azure
  • Leading IT /Business Team in end-to-end implementation of Snowflake cloud data warehouse solutions
  • Responsible for Snowflake data modelling, ELT, Loading Snowflake SQL, implementing DWH and ETL concepts
  • Advanced in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing
  • Analyzed query performance and tuning, time series and understand how are used to solve Issues
  • Responsible for deploying Snowflake features data sharing of DW Schemas events and lake-house patterns
  • Lead developers team Snowflake utilities, Snows, Snow Pipe, Big Data model techniques using Python
  • Lead workshops in designing and building Data Pipelines and Transformations using ETL tools / Spark scripting to process and load the data onto Snowflake
  • Responsible for Snowflake resource usage cost and performance tuning of Snowflake SQL Queries
  • Responsible for data modeling of relational DB, NoSQL data stores, (star and snowflake, dimensional modelling)
  • Designed snowflake Data warehouse data security, Analytics, reports and data access controls
  • Responsible for EDW architecture and plans for data quality practice and data management.

Senior Data Analyst Consultant

HP Enterprise
Houston, TX
11.2019 - 01.2020
  • Responsible for providing snowflake Data Warehouse strategy and Framework for EDW/MDM/IDQ projects
  • Responsible for managing data migration of Legacy and DB to the data warehouses snowflake cloud
  • Defined Data Quality Strategy utilizing snowflake/Informatica IDQ, data profiling and data catalog analysis
  • Designed Snowflake Cloud Data Architect strategy, Data Lake, Data warehouse, ETL, BI projects
  • Responsible for data architecture modeling for data lake, data warehouse using Snowflake, AWS/Azure
  • Leading IT /Business Team in end-to-end implementation of Snowflake cloud data warehouse solutions
  • Responsible for Snowflake data modelling, ELT, Loading Snowflake SQL, implementing DWH and ETL concepts
  • Advanced in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing
  • Analyzed query performance and tuning, time series and understand how are used to solve Issues
  • Responsible for deploying Snowflake features data sharing of DW Schemas events and lake-house patterns
  • Lead developers team Snowflake utilities, snow SQL, Snow Pipe, Big Data model techniques using Python
  • Lead workshops in designing and building Data Pipelines and Transformations using ETL tools / spark scripting to process and load the data onto Snowflake
  • Responsible for Snowflake resource usage cost and performance tuning of Snowflake SQL Queries
  • Responsible for data modeling of relational DB, NoSQL data stores, (star and snowflake, dimensional modelling)
  • Designed snowflake Data warehouse data security, Analytics, reports and data access controls
  • Responsible for EDW architecture and plans for data quality practice and data management.

SAP Master Data Management/ Senior Data Analyst Consultant

Flowserve Oil & Gas Industry
Irving, TX
02.2019 - 11.2019
  • Global Oil & Gas Operations)
  • SAP S4/HANA Migration MDM/MDG Consultant
  • Responsible for enterprise data architecture of SAP/Oracle ERP Customer, Supplier master data management
  • Defined the data management, data conversions, data visualization frameworks for tableau, QlikView and PB
  • Performed data and analytics integration, application architecture unstructured and structured data
  • Conducted workshops with business and IT to gather requirements naming convention and system standards
  • Preformed data extraction/loads with Informatica data into snowflake and migrated Tableau dashboards to Looker
  • Designed and planned snowflake EDW cloud architectural roadmaps, standards, reference architecture
  • Developed strategies, roadmaps, standards, and reference architecture/implementation for Enterprise tools
  • Documented existing Business/systems architecture and technology portfolio to ensure accuracy
  • Responsible for developing/writing with business standards, rules, polices, procedures and IT systems
  • Responsible for establishing data architecture policies, procedures, guidelines for MDM/Data Governance
  • Managed data architecture data models, standardizations, definitions, Data Dictionary and Data Lineage
  • Designed ETL development framework, sources to target mappings, and replication strategy
  • Worked with data analysts and data stewards to ensure best practices for data management
  • Defined data architecture solutions including, Data Warehouse, Informatica ETL Data initiatives
  • Conducted assessments and define enterprise roadmaps for enabling a data-driven Analytics organization.

Senior Data Analyst Consultant

Sabre Airlines Solutions
Southlake, TX
12.2018 - 02.2019
  • Responsible for redesigning Teradata warehouse and move to snowflake Cloud DW strategy and Framework
  • Responsible for managing migration of Legacy tera data DW and DB to the Cloud data warehouses snowflake
  • Defined Data Quality Strategy utilizing snowflake/Informatica IDQ, data profiling and data catalog analysis
  • Designed Snowflake Cloud Data Architect strategy, Data Lake, Data warehouse, ETL, BI projects
  • Responsible for data architecture modeling for data lake, data warehouse using Snowflake, AWS/Azure
  • Leading IT /Business Team in end-to-end implementation of Snowflake cloud data warehouse solutions
  • Responsible for Snowflake DW data modeling, ELT, Loading Snowflake SQL, implementing DWH and ETL concepts
  • Advanced in Snowflake concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing
  • Analyzed query performance and tuning, time series and understand how are used to solve Issues
  • Responsible for deploying Snowflake features data sharing of DW Schemas events and lake-house patterns
  • Lead developers team Snowflake utilities, snow SQL, Snow Pipe, Big Data model techniques using Python
  • Lead workshops in designing and building Data Pipelines and Transformations using ETL tools / spark scripting to process and load the data onto Snowflake Cloud EDW
  • Responsible for Snowflake resource usage cost and performance tuning of Snowflake SQL Queries
  • Responsible for data modeling of relational DB, NoSQL data stores, (star and snowflake, dimensional modelling)
  • Designed snowflake Data warehouse data security, Analytics, reports and data access controls
  • Responsible for EDW architecture and plans for data quality practice and data management.

SAP Customer Segment / Data Architect Consultant

TESORO-Marathon Petroleum, Oil & Gas Industry
San Antonio, TX
07.2016 - 01.2018
  • Responsible for the Customer Segment of SAP S/4 HANA, SuccessFactors’s HCM, and Ariba
  • Responsible for leading enterprise SAP cloud solutions and IT infrastructure architecture on AWS
  • Worked with sale teams to deliver infrastructure services and solutions on Amazon Web Services (AWS)
  • Engaged clients in workshops and interviews to analyze process and reporting requirements
  • Advised clients on industry, cross-industry leading practices, SAP recommended processes and functions
  • Designed SAP future state Architecture for clients
  • Influenced clients’ thinking in adopting leading/standard practices while developing target state
  • Analyzed application landscape to design interfaces to SAP solution
  • Designed SAP Cloud solutions delivery model for reliable, scalable architecture solution and services
  • Worked cloud hosting providers to designed distributed environments with SAP IBM and HP
  • Project manager and change management for the AWS solutions and IT infrastructure architecture
  • Responsible for the technical implementation of SAP SuccessFactors’s and Ariba Cloud solutions....

SAP Data Management/ Data Architect Consultant

Dart Container Inc
Lansing, MI
11.2014 - 07.2016
  • IT SAP Information Group)
  • SAP Migration, Master Data Management & Governance Project
  • Responsible for the technical implementation of SAP SuccessFactors, Ariba and Fieldglass
  • Defined data migration of SAP Ariba, Fieldglass and Success Factors Employee Central Cloud Strategy
  • Developed Data migration project plan, deliverables, resources, timelines, and Go-Live schedule
  • Responsible for the technical implementation of SAP SuccessFactors’s and Ariba Cloud solutions
  • Conducted project meetings and is responsible for project tracking and analysis
  • Defining the project scope, project plan, time frames and the required resources.

Huntsman Corp
, TX
09.2014 - 06.2015

Senior Data Architect Consultant

Johnson Control Inc
Milwaukee, WI
03.2014 - 09.2014

Senior Data Management/ Data Architect Consultant, Information Steward Consultant

Nexeo Solutions Oil & Gas Industry, Information Systems Group, BPX Oil & Gas Industry
Houston, TX
04.2013 - 02.2014
  • Lead Data Migration, SAP MDG, Data Services

SAP Business Objects BI/EIM Architect

Information Systems Group
06.2012 - 04.2013

SAP Business Objects BI and Data Services Architect

Information Systems Group, First Group America
, OH
11.2011 - 06.2012

SAP Business Object/Data Warehouse Architect

L3 Communications
Rockwall, TX
05.2010 - 11.2011
  • Shared Service)
  • Technical Summary
  • Technologies: Cloud, BI Analytics, Big Data, Data Integration Solutions, Informatica ETL, MDM, IDQ, Tableau, QlikView, Looker, SAP Business Objects (BOE), Hadoop, Python, SQL, REST API Big Data Platform Architectures methods distributed computing MapReduce, Spark Hive, Java Development, (RDBMS) SQL and NOSQL, Microsoft Azure, Google Cloud Platform, Amazon Web Services (AWS) Cloud Migration, Snowflake cloud Data warehouse

Education

BS - Geophysics

Pacific Western University

Executive MBA - undefined

Southern Methodist University (SMU

Skills

Predictive modeling

undefined

Timeline

Senior Data Analyst

Mindtree; HPE Enterprise
10.2021 - Current

Customer Senior Data Analyst Consultant

Toyota Motor Corporation NA
11.2020 - 08.2021

Senior Data Analyst Consultant

HP Enterprise
11.2019 - 01.2020

SAP Master Data Management/ Senior Data Analyst Consultant

Flowserve Oil & Gas Industry
02.2019 - 11.2019

Senior Data Analyst Consultant

Sabre Airlines Solutions
12.2018 - 02.2019

SAP Customer Segment / Data Architect Consultant

TESORO-Marathon Petroleum, Oil & Gas Industry
07.2016 - 01.2018

SAP Data Management/ Data Architect Consultant

Dart Container Inc
11.2014 - 07.2016

Huntsman Corp
09.2014 - 06.2015

Senior Data Architect Consultant

Johnson Control Inc
03.2014 - 09.2014

Senior Data Management/ Data Architect Consultant, Information Steward Consultant

Nexeo Solutions Oil & Gas Industry, Information Systems Group, BPX Oil & Gas Industry
04.2013 - 02.2014

SAP Business Objects BI/EIM Architect

Information Systems Group
06.2012 - 04.2013

SAP Business Objects BI and Data Services Architect

Information Systems Group, First Group America
11.2011 - 06.2012

SAP Business Object/Data Warehouse Architect

L3 Communications
05.2010 - 11.2011

BS - Geophysics

Pacific Western University

Executive MBA - undefined

Southern Methodist University (SMU
Rodney ColeData Analyst