Analytics Engineer - Dimensional Modeling & ELT

Srikari Deepthi Puvvada

NC, USA +1-903-***-**** ***********************@*****.*** linkedin.com/in/srikarideepthi1503/ Summary

Analytics Engineer with 5+ years of experience designing scalable data solutions, developing dimensional models, star and snowflake schemas, and semantic layers, and building reliable ELT/ETL pipelines for enterprise analytics and reporting. Strong expertise in SQL, Python, dbt, Snowflake, Azure Synapse Analytics, Azure Data Factory, and Databricks, with hands-on experience developing trusted analytical datasets, reusable transformation models, data marts, and governed business metrics. Skilled in data quality, automated testing, data validation, reconciliation, data lineage, observability, and performance optimization, with experience delivering self-service analytics through Power BI, Tableau, and Looker. Proven ability to translate complex business requirements into scalable, production-ready data solutions while partnering effectively with technical and business stakeholders Core Expertise

Analytics Engineering • Data Architecture & Modeling • Dimensional Modeling • Star & Snowflake Schema • Fact & Dimension Modeling • Slowly Changing Dimensions (SCD) • Semantic Layer & Metrics Layer Design • Data Warehousing • Analytical Data Products • Data Marts • ELT/ETL & Data Transformation • Data Integration & Pipeline Development • Batch & Incremental Processing • Data Quality & Automated Testing • Data Validation & Reconciliation • Data Lineage & Observability • Data Governance & Data Contracts • Pipeline Monitoring & Performance Optimization • Self-Service Analytics & Business Intelligence • KPI & Metrics Development • Cloud Data Engineering • AWS & Azure Cloud Solutions • Machine Learning & TensorFlow • Generative AI & LLM Applications • AI-Assisted Analytics • Natural Language Analytics • Multicloud Networking • Business Requirements Analysis • Stakeholder Collaboration • Production Data Solutions Experience

Analytics Engineer Microsoft, USA Oct 2024 – Present

• Integrate data from 15+ operational and business systems into Snowflake and Azure Synapse, reducing manual data preparation effort by 45% and improving access to standardized analytical datasets across multiple teams.

• Design and maintain dbt transformation models and ELT pipelines using SQL, Python, Azure Data Factory, and Snowflake, improving data availability for enterprise reporting by 35%.

• Develop dimensional data models, data marts, and semantic reporting layers supporting 120+ business metrics, standardizing KPI definitions across operational, financial, and executive reporting.

• Automate data validation, reconciliation, and quality checks across 50M+ monthly records, reducing reporting defects by 35% and improving reliability of business-critical datasets.

• Optimize Snowflake SQL transformations and warehouse workloads, reducing processing times by 40% through query and transformation optimization for frequently accessed analytical datasets.

• Develop governed Power BI and Tableau reporting models used by 300+ business users, increasing self-service analytics adoption and reducing ad hoc reporting requests by 30%.

• Implement dbt testing, documentation, and data lineage practices, improving pipeline reliability and reducing production support effort by 30%.

• Maintain metadata, governance standards, and lineage documentation for critical reporting assets, contributing to a 40% reduction in monthly data incidents

Analytics Engineer CitiusTech, India Mar 2020–Jul 2023

• Integrated healthcare, claims, and operational data from 20+ source systems using Azure Data Factory and SQL Server into centralized Azure Synapse reporting environments, reducing report preparation effort by 40%.

• Developed and maintained ETL/ELT pipelines using SQL, Python, Azure Data Factory, and Snowflake to process millions of healthcare records monthly, improving data availability for analytics and reporting teams.

• Designed dimensional models, fact and dimension structures, data marts, and analytical datasets across SQL Server and Snowflake, standardizing business metrics used across enterprise dashboards and clinical scorecards.

• Built and maintained 25+ Power BI and Tableau dashboards supporting patient utilization, operational performance, and strategic KPI reporting, improving reporting efficiency by 35%.

• Automated recurring reporting workflows using SQL stored procedures and Python, reducing manual reporting effort by 50% and accelerating delivery timelines.

• Optimized SQL queries and warehouse structures by analyzing slow joins, indexing gaps, and query execution patterns, improving dashboard performance by 35% and reducing query response times.

• Performed data profiling, validation, reconciliation, and quality assessments across large healthcare datasets, improving data completeness and reducing reporting inconsistencies by 30%.

• Partnered with clinical and business stakeholders to translate reporting requirements into scalable analytics solutions and performed root- cause analysis, reducing recurring data issues by 30%. Projects

The Aroma – AI-Powered Recipe Platform

• Built a recipe discovery and meal-planning platform using React.js, TheMealDB API, Supabase, and Vercel.

• Implemented user authentication, favorites, shopping lists, and recipe-sharing functionality using Supabase Business Process Improvement using Data Analytics

• Analyzed support workflows using SQL, Excel, and Power BI, identifying bottlenecks and improving ticket resolution time by 30%.

• Developed interactive Power BI dashboards to track ticket trends, SLA compliance, resolution metrics, and operational KPIs IoT Cloud Dashboard

• Built a real-time IoT dashboard using AWS IoT Core, Grafana, Lambda, S3, CloudWatch, MQTT, and Python to monitor device telemetry and automate alerts

Technical Skills

• Data Modeling & Analytics Engineering: dbt Core, dbt Cloud, Dimensional Modeling, Star Schema, Snowflake Schema, Fact & Dimension Modeling, Slowly Changing Dimensions (SCD), Semantic Layer Design, Metrics Layer, ELT/ETL, Data Transformation, Data Marts, Data Warehousing, Analytical Datasets

• Cloud & Data Platforms: Snowflake, Microsoft Azure, Amazon Web Services (AWS), Azure Synapse Analytics, Azure Data Factory

(ADF), ADLS Gen2, Databricks, Microsoft Fabric

• Programming & Query: SQL, Advanced SQL, Python, PySpark, Apache Spark, CTEs, Window Functions, Stored Procedures, Query Optimization, Performance Tuning

• Data Pipelines & Orchestration: Data Pipelines, Data Integration, Apache Airflow, Apache Kafka, Spark Streaming, Azure Event Hubs, Incremental Processing, Batch Processing, Pipeline Orchestration, Workflow Automation, Source-to-Target Mapping

• BI & Reporting: Power BI, DAX, Tableau, Looker, LookML, Executive Scorecards, KPI Reporting, Self-Service BI, Self-Service Analytics, Data Visualization

• Data Quality, Governance & Observability: Data Quality Frameworks, Data Validation, Data Reconciliation, Data Profiling, Automated Data Testing, dbt Testing, Data Lineage, Metadata Management, Data Contracts, Data Observability, Pipeline Monitoring, Data Governance, Master Data Management (MDM)

• AWS Cloud & Application Services: AWS Lambda, Amazon S3, Amazon EC2, Amazon DynamoDB, Amazon RDS, Amazon API Gateway, Amazon CloudWatch, AWS IAM, AWS SDKs, AWS CLI, Amazon SQS, Amazon SNS, Amazon EventBridge, AWS Step Functions, AWS CodePipeline, AWS CodeBuild, AWS CodeDeploy, AWS CloudFormation

• Machine Learning & TensorFlow: TensorFlow, Machine Learning, Deep Learning, Neural Networks, Model Development, Model Training, Data Preprocessing, Model Evaluation, Predictive Modeling, Model Prediction, Model Saving & Deployment

• AI & LLM Technologies: Generative AI, Large Language Models (LLMs), LLM Applications, Retrieval-Augmented Generation

(RAG), Natural Language Analytics, Natural Language to SQL, AI-Assisted Analytics, Prompt Engineering

• Cloud Networking: Multicloud Networking, AWS Networking, Azure Networking, VPC/VNet Concepts, Transit Networking, Network Architecture, Network Security, Network Monitoring, Network Troubleshooting

• DevOps & Databases: Git, GitHub, Azure DevOps, CI/CD, Code Review, Docker, SQL Server, PostgreSQL, MySQL, Agile/Scrum Certifications

• AWS Certified Developer – Associate

• TensorFlow Developer Certificate

• Aviatrix Certified Engineer – Multi-Cloud Networking Associate Education

Master of Science in Computer Science Aug 2023 – May 2025 University of Texas at Arlington Arlington, TX, USA Bachelor of Technology Jul 2019 – May 2023

KL University India

Contact this candidate