Satyanarayana S

Data Modeler @USAA

US

Responsibilities & Achievements:• Designed and implemented scalable data models in Azure SQL Database and SynapseAnalytics, reducing query retrieval time by 30% through schema optimization andpartitioning strategies.• Led Snowflake data modeling initiatives, enabling high-performance pipelines andimproved scalability for BI workloads.• Developed dimensional (Star, Snowflake) and normalized relational models for OLTPand OLAP workloads, including handling SCD Type 2 for historical reporting.• Utilized ERwin for logical/physical modeling, schema generation, and metadata exportto accelerate governance alignment.• Partnered with data governance teams to enforce metadata standards and bestpractices using Azure Data Catalog.• Conducted data profiling, validation, and quality checks to ensure model accuracy,consistency, and compliance with regulatory standards.• Collaborated with stakeholders to translate business requirements into robust,analytics-ready data structures.• Documented data modeling strategies, lineage, and enterprise metadata repositories inConfluence.• Implemented data encryption and security protocols to safeguard sensitive data assets.Environment: Azure Synapse Analytics, Azure SQL Database, ADLS, Azure Data Factory,Snowflake, Databricks, Apache Spark, PySpark, SQL, T-SQL, ERwin, Power BI, Git, AzureData Catalog