Data Modeler
Resume:
Ashutosh Agnihotri
Data Modeler/ Architect Microsoft Agentic AI Developer Certified Snowflake SnowPro Core Certified AWS Certified
Email: ********************@*****.*** Phone: +1-240-***-****
PROFESSIONAL SUMMARY
Data Modeling and Architecture professional with almost 9 years of experience designing large-scale, AI-ready data platforms that power advanced analytics and Machine Learning systems. Specialized in building distributed, cloud-native lakehouse and warehouse architectures using AWS (S3, Redshift, EMR, Glue, SageMaker) and Snowflake, supporting multi-terabyte to petabyte-scale workloads with high reliability and performance.
Expert in dimensional modeling (Star/Snowflake), relational modeling, Data Vault 2.0, and domain-driven design optimized for feature engineering, model training datasets, and low-latency inference pipelines. Strong experience developing ML-ready data pipelines, curated feature layers, and reproducible experimentation frameworks in collaboration with Data Scientists and ML Engineers for use cases including personalization, fraud detection, recommendation systems, and predictive analytics.
Proficient in distributed processing, partitioning strategies, workload isolation, and cost-performance optimization to meet strict SLAs at scale. Implement robust data governance frameworks including fine-grained access control, automated data quality validation, observability, and end-to-end lineage to ensure model reliability and compliance.
Experienced in CI/CD-driven data deployments, infrastructure-as-code, and real-time streaming architectures supporting event-driven ML systems. Focused on building scalable, secure, and high-performance data foundations that accelerate AI innovation in high-growth, engineering-centric environments.
TECHNICAL SKILLS
Data Modeling Tools: ERWIN, ER Studio, Medallion Architecture, Snowflake Schema, Star Schema, Data Vault 2.0, Delphix Data Masking
ETL Tools: DBT, Fivetran, Informatica PowerCenter, SSIS, Talend
Cloud Technologies: Snowflake, Azure(Blob), Databricks, AWS (EC2, Redshift, Glue, S3, EMR), GCP
Big Data Technologies: Hadoop, Spark, Py Spark, Impala, Hive, MapReduce
Databases: Teradata, Oracle, MS SQL Server, DB2, Vertica
MDM: Talend Data Catalog
Data Visualization: Power BI, Tableau
Programming: SQL, Python
Others: HTML, CSS, JavaScript, Agile/SCRUM
CERTIFICATIONS
Snowflake SnowPro Core
AWS Certified Solutions Architect – Associate
Microsoft- Github Certified- Agentic AI Developer
EDUCATION
Masters in Computer Information Systems
Bachelor of Engineering in Computer Science
PROFESSIONAL EXPERIENCE
Data Modeler/Architect/Business Analyst
Ever Bank, Florida — May 2023 – Present
Designed and optimized enterprise data models and data flows using SQL Server and ER/Studio, supporting 15+ business-critical applications and improving data integration efficiency by 30%.
Developed and optimized logical and physical data models in Snowflake for structured and semi-structured datasets (JSON, Parquet), implementing star and snowflake schemas that reduced query latency by 35% and improved storage efficiency by 20%.
Implemented and maintained Medallion Architecture (Bronze/Silver/Gold layers) to process over 2TB of daily data, ensuring high data quality, governance, and end-to-end traceability across ingestion and transformation layers.
Leveraged Snowflake features such as automatic clustering, clustering keys, materialized views, and query optimization techniques to improve large-scale query performance by 40% while reducing compute costs by approximately 25%.
Enforced data governance and security through role-based access control (RBAC), dynamic data masking, and secure data sharing, achieving 100% compliance with internal and regulatory standards while supporting 50+ cross-functional users.
Implemented Master Data Management (MDM) practices using Talend Data Catalog, enabling robust data lineage, metadata management, and data stewardship, which improved data discoverability and governance across enterprise datasets.
Supported development of interactive dashboards and semantic data models in Power BI for Loans and Wealth Management divisions, enabling real-time KPI reporting and reducing manual reporting efforts by 60%.
Collaborated with Business Analysts and Application Architects to translate complex business requirements into scalable data models and technical solutions, accelerating project delivery timelines by 20%.
Created comprehensive data mapping documentation and ER diagrams for logical and physical models, significantly improving documentation quality and consistency.
Led data migration activities across development, QA, and production environments, ensuring 99.9% deployment accuracy with zero critical post-release defects.
Integrated Azure services, including Blob Storage, with Snowflake to support scalable data warehousing and analytics solutions, managing datasets exceeding 4TB.
Developed robust relational data models for OLTP systems using Third Normal Form (3NF), ensuring data integrity, reduced redundancy, and efficient transaction processing across core business applications.
Environment: SQL Server, ER Studio, ERWIN, Snowflake, DBT, Fivetran, MS Office, Talend, SSIS, AWS Redshift, Scrum, Talend Data Catalog
Data Modeler/Architect
Pacific Life, California — May 2021 – May 2023
Coordinated with cross-functional teams (Business, Sales, Legal, Data Scientists, etc.) to identify and fulfill data modeling requirements for key business projects.
Utilized ERWIN Data Modeler for the creation of physical data models and DDL generation.
Applied Master Data Management (MDM) principles and worked on Snowflake data warehouse performance optimization, including query tuning and pruning strategies.
Developed and maintained data quality frameworks to ensure accurate, reliable data ingestion into Snowflake.
Contributed to the development of enterprise-wide data governance strategies, ensuring consistency across business units.
Environment: ERWIN, Snowflake, Teradata, AWS, Spark, Visio
Data Modeler
Liberty Mutual, New Hampshire — Feb 2020 – May 2021
Developed logical and physical data models using ERWIN and created optimized SQL queries for data validation.
Involved in the migration of data from legacy systems to new targets and ensured proper data transformations through ETL processes.
Assisted in the design and execution of data migration strategies and data quality checks using S3 and AWS.
Collaborated with Business Analysts to prepare BRDs and reviewed data requirements for business alignment.
Environment: Teradata, ERWIN, SQL, Informatica, AWS, MS Office
Database Developer
Vitosha Inc., Pennsylvania — Sep 2019 – Dec 2019
Created and reviewed data models for a cloud-based data migration project involving Snowflake schema.
Analyzed and optimized data transformations and ensured high data quality by working closely with ETL teams and business analysts.
Designed and implemented SQL queries and SAS scripts for efficient data processing and integration.
Used Power BI and Tableau for creating interactive reports and dashboards.
Environment: Snowflake, Teradata, ERWIN, SQL, Power BI, Tableau
Data Analyst
White Elephant Tech, Indore, India — Mar 2017 – Jul 2018
Led client interactions to gather technical requirements and develop data mart models.
Designed reports and dashboards in Power BI and Excel with dynamic KPIs and drill-down functionality.
Environment: Oracle11g R2, DB2, SQL, Teradata, Excel, Power BI
Business Developer
NicheHype IT Services, Indore, India — Apr 2016 – Feb 2017
Acted as a liaison between clients, the development team, and stakeholders for project delivery.
Managed project proposals, timelines, and scope while designing ER diagrams and data models for various data marts.
Environment: MS Office, WordPress, Upwork, Excel
ADDITIONAL INFORMATION
Languages: Fluent in English, Hindi
Soft Skills: Excellent communication, problem-solving, and team collaboration
Interests: Data Modeling, AI, Cloud computing
Contact this candidate