Looking for a job

Venkat Chamarthy

@venkatchamarthy

Enterprise data architect at CITI GROUP INC. who modernized 17 COO applications and delivered Databricks Lakehouse capabilities.

United States

Message

At CITI GROUP INC., I led enterprise data architecture and modernization across 17 COO applications, defining target-state architecture, platform strategy, and modernization roadmaps. I directed delivery of Databricks Lakehouse capabilities using Delta Lake and Medallion architecture.

At USAA, I led Finance data architecture for a transformation connecting Oracle FSDF/OFSAA and cloud General Ledger capabilities with a Snowflake-based data and analytics platform. I designed its multi-layer architecture and Finance data models.

Across roles at CITI GROUP INC. and PwC ADVISORY SERVICES LLP, I led data architecture and engineering initiatives spanning financial, regulatory, manufacturing, and reporting workloads. My work has included enterprise modeling, governed data products, data quality and lineage controls, and a GenAI/RAG knowledge-assistant proof of concept.

Experience

Work history, roles, and key accomplishments

Consultant – Data Architecture, Data Management & Engineering

USAA

Jan 2021 - Apr 2023 (2 years 3 months)

Led enterprise Finance data architecture and engineering for a transformation aligning Oracle FSDF/OFSAA and cloud General Ledger with a Snowflake-based platform. Designed multi-layer Snowflake architecture and defined ETL/ELT and integration patterns.

Snowflake Oracle FSDF Oracle OFSAA Data Modeling ETL ELT Data Governance RBAC Data Quality Metadata Lineage

Senior Manager – Data Architecture & Engineering

PwC Advisory Services LLP / Ball Corporation

Feb 2020 - Dec 2020 (10 months)

Led architecture and engineering delivery of a cloud data modernization initiative transitioning enterprise data and reporting workloads to a Snowflake analytics platform. Architected Data Vault 2.0 structures and directed ETL/ELT, migration, and reconciliation design.

Snowflake DataVault 2.0 Dimensional Modeling ETL ELT Data Governance RBAC SAP JDEdwards

Senior Vice President – Data Architecture & Modeling

Citi Group Inc.

Oct 2016 - Feb 2020 (3 years 4 months)

Led enterprise data architecture and modernization initiatives evolving traditional EDW capabilities toward distributed Big Data and modern analytical platforms for Finance, Risk, Compliance, and regulatory workloads. Architected environments using Hadoop, Hive, Spark, Teradata, and Netezza.

Hadoop HDFS Hive Spark Teradata Netezza Ab Initio Sqoop Data Modeling Data Governance BASEL CCAR BCBS 239 IFRS 9 CECL

Manager – Data Architecture & Engineering

PwC Advisory Services LLP / Voya Financial

Jan 2015 - Oct 2016 (1 year 9 months)

Led enterprise data warehouse, BI, and analytics architecture and modernization initiatives supporting Finance, Risk, regulatory, and enterprise reporting. Architected Oracle-based EDW solutions using Oracle, Informatica PowerCenter, and ERwin.

Oracle Informatica PowerCenter Erwin Data Modeling ETL Data Quality Reconciliations Reference Data

Data Warehouse Architect

Various Clients

Jan 2002 - Dec 2014 (12 years 11 months)

Designed enterprise data warehouses and data models using ERwin and ER/Studio, and developed ETL architectures using Informatica PowerCenter. Implemented Oracle OFSAA solutions and delivered BI solutions using Oracle BI, Cognos, and BusinessObjects.