Dharmendra Patel

Sr Data Modeler Sr Data Architect Sr Business Data Analyst Sr Data Engineer @Citi

ON, CA

o Led data architecture for the wholesale lending platform, with a strong focus on the collateral workstream.o Designed Collateral ER models using MagicDraw, structured for easy transformation into message schemas to support API and messaging integration.o Sucessfully Implemented event-driven architecture using Kafka to stream real-time collateral lifecycle events (e.g, onboarding, revaluation, lien release) to downstream.o Engineered a reference data architecture for collateral, customer, facility, and exposure entities, facilitating data consistency and reusability across the wholesale banking landscape.o Recorded complete data lineage which had enabled traceability from source systems to regulatory reporting outputs, and improving data governance and audit response.o Supported business users and operations teams by writing complex SQL queries to generate ad-hoc and scheduled operational reports, improving decision-making and SLA tracking.o Acted as SME during the loan and collateral platform modernization, guiding multiple agile delivery teams on modeling standards, data domain alignment, and system integration best practices.

C. U. Shah University

Bachelor's degree, Information Technology