Agentic AI & Snowflake Cortex Architect

KAMALESH K

Agentic AI & Snowflake Architect

Agentic AI GenAI Snowflake Cortex DBT Agentbricks AWS

984-***-**** ***********@*****.***

LinkedIn: linkedin.com/in/k-kamalesh-145747222

PROFESSIONAL SUMMARY

Agentic AI Architect with 18+ years of progressive experience leading engineering teams and delivering enterprise-scale solutions across Agentic AI, Generative AI, Snowflake CoCo/Cortex AI,DBT and AWS cloud platforms. Combines deep technical expertise in building autonomous Multi-Agent systems with proven Snowflake Advanced Architecture skills and modern ELT pipeline design using DBT

Architected Production-grade AI-powered automation platforms leveraging Snowflake Cortex (Agents, Analyst, Search), RAG pipelines, and LLM-driven autonomous agents while maintaining robust data engineering practices through DBT-based transformation layers, AWS cloud services, and enterprise governance frameworks. Trusted to lead platform modernization across financial services, healthcare, and banking ecosystems

TECHNICAL EXPERTISE

Agentic AI & Generative AI: Multi-Agent Orchestration,MCP,A2A,LLM-Powered Autonomous Agents, Prompt Engineering & Markdown, RAG/RAGaaS Architecture, AI Agent Evaluation & Monitoring, Hallucination Detection, Vector Embeddings & Semantic Search, GitHub Copilot Agent, LangChain, AWS Bedrock, SageMaker, Claude, APIs

Snowflake & Data Architecture: Snowflake Advanced Architecture, Snowflake Cortex AI (Agents, Analyst, Search), Medallion Architecture (Raw/Silver/Gold), Snowpark & Python UDFs, Dynamic Tables, Streams & Tasks, Snowpipe, Data Sharing & Marketplace, RBAC/ABAC Security, Cost Governance & Optimization, Iceberg Tables, OpenFlow

Cloud, Data Engineering & DevOps: AWS (S3, Glue, DMS, Athena, Lambda, Bedrock, SageMaker, EMR), Azure (ADLS Gen2, ADF), Unity Catalog, Agentbricks, Delta Lake, DBT, Informatica, Fivetran, Airflow, Confluent Kafka, Python, SQL/PL/SQL

CERTIFICATIONS

• SnowPro Advanced Architect — Certification ID: S138344-260324-ARA

• SnowPro Core — Certification ID: S13844-260277-COF

KEY ACHIEVEMENTS

• Delivered the STTM Agentic AI Platform into production at Fannie Mae, recognized by the client as a

transformative accelerative solution.

•Reduced manual STTM effort by 80% through multi-agent orchestration, cutting development from 2 weeks to

5 days and increasing team productivity (23 STTMs vs. 16 across four sprints 40% throughput).

•Designed reusable Snowflake Architecture Blueprint (medallion zones, RBAC, cost governance) adopted as

organizational standard across 4+ business domains at J&J.

•Architected and deployed the Arch Assist AI Chatbot with RAG pipelines at State Street, achieving 90%+ answer

relevance and reducing documentation lookup time by 60%.

•Optimized Snowflake platform costs by 40% at Fidelity through warehouse right-sizing, custom automation

procedures, object tagging strategy, and cost-center metrics for enterprise chargeback and resource utilization

•Implemented automated DBT macros for data quality validation at Advarra, catching 99.5% of data anomalies

before production for FDA-compliant clinical trial pipelines.

•Led zero-downtime migration of 5 healthcare systems from Oracle/SQL Server to Snowflake on AWS at J&J,

processing terabyte of records with zero data loss.

PROFESSIONAL EXPERIENCE

Architect — Agentic AI

Fannie Mae (Hexaware) Virginia Jan 2026 – Present

• Partnered directly with customers to understand business objectives, workflows, and operational pain points

addressable through Agentic AI and Generative AI.

• Architected AI-driven STTM Automation Framework leveraging GitHub Copilot User Agent, BRDs, JSON/XML

payloads, and Collibra datasets to standardize Source-to-Target Mapping generation.Reduced STTM

development from 2 weeks to 5 days, achieved 50% reduction in manual effort, and increased team productivity

• Developed AI-powered Data Transformation Agent using GitHub Copilot to automate ETL transformation

development, validation generation, and metadata-driven pipeline execution.

• Design and build multi-agent orchestration patterns (master-orchestrator + worker agents) using protocols such

as MCP and A2A

• Designed reusable markdown/prompt-based framework to dynamically generate transformation scripts based

on business requirements.

• Designed and developed AI-powered orchestration framework to invoke multiple sub-agents for automated

STTM output generation, enabling end-to-end transformation, validation, and output creation workflows.

• Developed AI agents for automated BRD-to-STTM mapping generation using Snowflake and Agentbricks

• Developed AI-powered applications using Cortex Analyst and built a semantic view for Loan applications to

Enable natural language querying over structured business data

• Built intelligent document search solutions using Cortex Search with vector embeddings for semantic retrieval

and enterprise knowledge discovery for the support cases use case .

• Implemented Retrieval-Augmented Generation (RAG) pipelines by integrating Cortex Search with enterprise

data stored in Snowflake

• Tested and iterated on agentic framework, prompts, contextual and prompt tuning, and monitoring of AI

services and models.

Technologies: GitHub Copilot, Visual Studio, REST APIs, Agentic AI, Python, Markdown Prompt Engineering,Snowflake,Agent bricks

Gen AI Engineer

State Street — Office of Architecture (Hexaware) Remote Oct 2024 – Dec 2025

• Built GenAI embedding pipelines using Python for chunking, indexing, and prompt optimization to enhance

model inference precision, integrated with AWS SageMaker and Bedrock APIs.

• Led deployment of scalable Generative AI platforms using Anthropic Claude models, enabling natural language

querying, document summarization, content generation, and conversational AI capabilities.

• Integrated and fine-tuned large language models (LLMs) with Fusion search pipelines to enhance query

understanding, semantic search, summarization, and question answering.

• Experiment with different Gen AI techniques and evaluate their effectiveness in improving search relevance and

user experience

• Leveraged AI_COMPLETE, AI_SUMMARIZE, AI_CLASSIFY, and AI_EXTRACT functions to automate document

summarization, classification, entity extraction, sentiment analysis, and business rule recommendations.

• Developed AI-powered underwriting and claims assistants leveraging Snowflake Cortex Agents and Cortex

Analyst.

• Extensively created Knowledge and multiple Data Sources for Text, Image, and Hyperlinks using APIs.

• Mentored junior engineers, led peer reviews, and contributed to architectural decisions aligning data and GenAI

pipelines with HIPAA-compliant, production-grade standards.

• Tested the Arch Assist Chatbot across Confluence pages, SharePoint pages, and images; validated Document

Upload Process using Harness CI/CD Pipeline.

• Actively participated and led discussions during ARB meetings

Technologies: Python, RAG, RAI, LLMs, AWS Bedrock, SageMaker, Snowflake Cortex AI, Harness CI/CD

Sr. Data Engineer

Fidelity Investments — Workplace Investments (Hexaware) Durham, NC Apr 2024 – Sep 2024

• Designed, analyzed, and enhanced EDL (Enterprise Data Lake) Snowflake data pipelines for multi-channel (Net

Benefits, App, Chat, Call, Xtract) Marketing Campaigns.

• Optimized Snowflake platform costs by 40% at Fidelity through warehouse right-sizing, custom automation

procedures, object tagging strategy, and cost-center metrics for enterprise chargeback and resource utilization

• Developed DBT models (SQL transformations) using Jinja templates and macros; configured Snapshots and

Custom Schemas in Snowflake.

• Extensively worked on Drools (Rules Engine) design and implementation for multiple product PZN generation for

Marketing Campaigns.

• Created Airflow DAG orchestration for Business Modules (DC, WI_Part, SPS) and EDL data pipelines.

• Utilized AWS services (EC2, S3, Lambda, API Gateway, SQS, EMR, SNS, Athena, CloudWatch) in data pipelines to

EDL and Aerospike data loads.

• Worked on complex ECP logic and EDL code improvements for Participant Propensity Score as per best practices.

Technologies: Snowflake, SnowSQL, Snowpark, UDF, UDTF, AWS (EC2, S3, Lambda, API Gateway, SQS, EMR, SNS, Athena, CloudWatch), Python, Informatica, Airflow, Control-M, Aerospike, DBT, Git, Jenkins, Jira

Solution Architect

Johnson & Johnson (Infomatics) Raritan, NJ Sep 2023 – Apr 2024

• Led data migration from Oracle and SQL Server to Snowflake for Pharmsphere, Vaccine, CMC, and CSC healthcare

systems.

• Led the architectural design, implementation, and optimization of a scalable and robust enterprise data lake

solution, leveraging AWS cloud services and Snowflake

• Designed and delivered the Enterprise Snowflake Architecture Blueprint, covering ingestion patterns, medallion

zone strategy, workload optimization, and governance

• Built scalable Ingestion & Reconciliation Frameworks, including metadata-driven control validation, record-level

audit checks, and row-count exception handling

• Implemented ETL pipelines using Streamset and SnowSQL for data transformation/conversion into Snowflake.

• Built data ingestion pipelines from Oracle, SQL Server, and Collibra using APIs to Snowflake.

• Implemented Snowflake Event Tables for error handling in Stored Procedures to capture log information.

• Worked on Confluent Kafka integration using Streamset pipeline to Snowflake.

• Converted Trifacta recipes into Snowflake procedures to generate Tableau output.

Technologies: Oracle, SQL Server, Snowflake, Streamset, AWS, Trifacta, Tableau, SnowSQL

Sr. Data Engineer

Advarra Columbia, MD Jul 2022 – Sep 2023

• Led data migration from Oracle and SQL Server to Snowflake for EDC and EVAL systems.

• Implemented real-time data ingestion pipelines using Snowpipe, Storage Integration in AWS and ADF.

• Implemented ELT process using Fivetran/Snowflake and DBT for database pipeline architecture.

• Built target models and transformations using Snowflake and DBT.

• Created DBT macros to automate data quality checks, including null checks, uniqueness tests, and referential

integrity validations.

• Worked with diverse data formats including JSON, Avro, Parquet, and CSV files.

• Integrated Confluent Kafka with Snowflake and implemented Python-based connectivity between SQL Server

and Snowflake.

Technologies: Oracle, SQL Server, Snowflake, DBT, AWS, Azure, Fivetran, Trifacta, Sigma, Reltio, Git, CI/CD

Sr. Data Engineer

Federal Reserve Bank (Mphasis) Bangalore, India Nov 2019 – Jul 2022

• Designed Dimension Modelling and new Data Warehouse Architecture; conducted workshops for requirements

gathering.

• Built transformations on Snowflake for diverse data sets (JSON, CSV).

• Implemented Snowpipe for real-time data ingestion pipelines using S3 and AWS Storage Integration.

• Led data migration from Oracle and SQL Server to Snowflake cloud data warehouse.

• Implemented data cloning, time travel, and table swapping for multiple target tables.

• Developed complex queries, Secured Views, and Materialized Views in Snowflake.

Technologies: Oracle, SQL Server, Snowflake, Informatica, AWS

Lead Consultant

A&F (Capgemini) Hyderabad, India Jan 2017 – Nov 2019

• Led offshore team, tracking deliverables daily and conducting daily scrum meetings.

• Managed data migration from multiple source systems to target systems.

• Created mappings, sessions, workflows, and worklets; scheduled and monitored loading processes using

Informatica workflow Manager.

• Implemented end-to-end data loading, transformation, and integration to Reltio MDM.

• Transformed data from various formats (JSON, XML) and prepared unit test plans, system test cases, and test

results.

Technologies: Informatica, Oracle, PeopleSoft, MDM (Reltio)

Senior Consultant

Societe Generale (Capgemini) Hyderabad, India May 2015 – Dec 2016

• Handled HCM business requirements for ASIA and EMEA Regions.

• Conducted requirements gathering workshops; worked on identifying Keep/Drop functionalities.

• Modified Pages, SQR, and App Engine programs; worked on compare reports.

Technologies: PeopleSoft HCM 8.4/9.2, PeopleTools, Oracle 10g, PeopleCode, SQR, Application Engine, Integration Broker, Web Services

Senior Consultant

Allegis (Capgemini) Hyderabad, India Sep 2013 – May 2015

• Designed High-Level Functional Design documents; supported design, development, and testing of PeopleSoft

applications.

• Performed code reviews of all customizations and new development; involved in preparing unit test cases.

• Managed handover of deliverables between offshore and onsite teams; provided production support.

• Designed Functional Design documents based on Business Solution Design and Business Requirements Specification

documents.

• Handled Functional Support issues on Billing, AR & GL Modules; interacted with client daily for ongoing issues.

• Worked on enhancement of Canada monthly billing timesheet issue; provided continuous production support.

Technologies: PeopleSoft Financials 8.4/8.9, PeopleTools 8.47, DB2, PeopleCode, SQR

Team Leader

DSNY (NTTData) Hyderabad, India Dec 2012 – Sep 2013

• Prepared TDDs based on FDDs with respect to Asset Management.

• Monitored and supported team members; coordinated with onsite team and client on daily scrum.

• Created data mappings to load data into target tables using Process AMIF1000.

Technologies: PeopleSoft Financials 9.0, PeopleTools 8.50, Oracle 11.2, PeopleCode

Senior Software Engineer

AutoZone (Hexaware) Chennai, India Jul 2011 – Dec 2012

• Managed offshore team work allocation and performed peer reviews of design and migration documents.

• Created data mappings for AR, BI, AP, and PO Modules; created TDDs for AP and PO modules.

• Coordinated team to deliver Technical Design Documents per client documentation standards.

Technologies: PeopleSoft Financials 8.4 to 9.2, PeopleTools 8.50, Oracle 11.2, PeopleCode

Senior Software Engineer

SCB (Hexaware) Chennai, India Dec 2009 – Jul 2011

• Studied functional documents and created technical documentation for client requirements.

• Troubleshot user issues, monitored batches, and ensured system availability within SLAs across various

countries.

• Reduced configuration time for new country rollouts by automating processes using DMS and SQL scripts.

Technologies: PeopleSoft HRMS 8.8, PeopleTools 8.42, Oracle 8i, SQR, PeopleCode

Associate Consultant

Infokall/Embarq Bangalore, India Sep 2008 – Dec 2009

• Designed Technical Specs, created mappings, and worked on production support tickets.

• Utilized transformations (Aggregator, Source Qualifier, Joiner, Expression, Update Strategy, Lookup, Sequence

Generator).

• Performed performance tuning of Role query using Joiner Transformation.

Technologies: Informatica, PeopleSoft, Oracle

Contact this candidate