The last few years I have been doing Data Architecture and Data Modeling for AWS based cloud solutions, using AWS Redshift and different AWS RDS like Oracle , Aurora, PostgreSQL.

Experienced Data Modeler/Data Architect with extensive hands-on experience in all aspects of Logical and Physical Data Modeling for Data Warehouse applications as well as for OLTP applications using multiple Data Modeling Suites like Embarcadero ER-Studio, CA Erwin and Oracle Designer.
Proven ability to translate business requirements into conceptual, logical and physical data models
Practical experience in designing and delivering Operational Data Store (ODS) solutions.
Ability to provide best practices in Data Modeling and implement them in related everyday tasks.
Extensive working experience in Logical and Physical Data Modeling for Oracle environment including Oracle 11g (Creating logical and physical partitions, creating Materialized Views for performance in Data Warehouse Environment).
Proven experience in designing Enterprise Data Dictionary for usage across all Data Modeling environment
Extensive hands-on Experience in Data Analysis, Data Profiling and Data Mapping for Legacy Systems as well as Data Warehouse Applications, including Enterprise Data Modeling, Operational Data store and Data Marts.
Working knowledge of applying Data Governance rules and methods do Data Modeling including creating of Enterprise Data Modeling Standards to be used across all Data Models for enterprise.
Proficiency level in producing complex mapping spreadsheets for ETL source to target data mapping including Informatica Initial Data Load (IDL) and Change Data Capture (CDC).

