Sri Datta Boggaram
Dallas
Summary
Senior Data Engineer with 7+ years of experience designing, building, and optimizing Snowflake-based data platforms using dbt, SQL, and Python across banking, healthcare, retail, and manufacturing domains. Proven expertise in ELT/ETL pipelines, medallion architecture, star/snowflake schema modeling, CDC, and SCD Type 2 implementations. Strong background in Power BI and Streamlit enablement, data governance, and translating complex business requirements into scalable, secure, analytics-ready data solutions in regulated environments.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Engineer
Bank OZK
Dallas, TX
04.2025 - Current
- Architected and automated enterprise-grade Snowflake ELT pipelines using dbt, integrating relational sources, APIs, and flat files while implementing medallion architecture and star/snowflake schemas to deliver governed, analytics-ready datasets at scale.
- Designed join-safe, mixed-grain Snowflake data models, resolving composite-key dependencies and fan-out risks to ensure consistent, auditable enterprise reporting across regulated banking domains.
- Implemented CDC and SCD Type 2 frameworks in dbt, leveraging incremental models, snapshots, deduplication logic, and backfill scripts to preserve historical accuracy, lineage, and regulatory auditability.
- Established dbt data quality and engineering standards, including generic and custom tests, grain-level uniqueness enforcement, not-null validations, reusable macros, seeds for static reference data, and comprehensive lineage via dbt docs.
- Led end-to-end analytics enablement, delivering curated datasets for Power BI and Streamlit, driving CI/CD deployments via GitHub, scheduling dbt jobs, optimizing query performance, and partnering with stakeholders to translate business requirements into secure KPIs and operational insights.
Analytics Engineer
Allegion
03.2024 - 12.2024
- Developed analytical data models and OLAP-style datasets using Azure Synapse Analytics and Snowflake, migrating data from SAP HANA, S/4 HANA, and other on-prem systems.
- Built consolidated analytics views using Watson Query (IBM CP4D) to enable cross-domain reporting.
- Automated Power BI dashboards to validate real-time data scenarios and support executive decision-making.
- Ensured adherence to data governance standards, including role-based access, data quality checks, and documentation.
Data Engineer
Avantor
08.2023 - 01.2024
- Designed and optimized ETL/ELT pipelines, reducing compute and storage costs by approximately 50% through performance optimization.
- Built semantic layers on Snowflake and SAP HANA supporting supply chain, pricing, and marketing analytics.
- Collaborated cross-functionally to document transformations, optimize queries, and support planning and forecasting solutions.
- Delivered interactive Power BI reports for near real-time insights.
BI Developer / Data Engineer
V-Soft Consulting (Samsung)
08.2022 - 02.2023
- Architected and managed Snowflake data warehouse solutions with secure, role-based access.
- Designed KPI-driven dashboards using SQL, Power BI, and Tableau across multiple business units.
- Analyzed customer purchase behavior to support marketing optimization and ROI improvements.
Data Warehouse Developer
Churchill Downs Inc.
04.2022 - 06.2022
- Automated end-to-end data pipelines from on-prem systems to Snowflake and Azure Data Lake.
- Developed ETL workflows using SSIS, MySQL, and Azure Data Factory.
Data Engineer / Business Analyst / SAP Consultant
Gaman Software Solutions Pvt. Ltd.
09.2015 - 12.2021
- Built scalable ETL/ELT frameworks using Snowflake, Azure, and AWS, supporting enterprise data warehousing and analytics.
- Led reverse engineering of H2R data models, documenting joins and aggregations using SQL and SAP HANA Studio.
- Delivered real-time analytics using Power BI and Tableau.
- Served as SAP consultant (TM, EWM, SD) with focus on data modeling and reporting.
Education
Master’s - Technology Management
Lindsey Wilson College
01.2026
Master’s - Business Analytics
University of Louisville
01.2022
Master’s - Biotechnology (Honors)
Deakin University
01.2011
Skills
- Data Engineering & Modeling
- ELT/ETL Pipelines
- Incremental Loads
- CDC
- SCD Type 2
- Star Schema
- Snowflake Schema
- Medallion Architecture
- Data Warehousing
- Grain Enforcement
- Reverse Engineering
- Snowflake
- Dbt
- Azure
- Data Factory
- Synapse Analytics
- Databricks
- Data Lake
- DevOps
- SQL
- Python
- Power BI
- Streamlit
- Tableau
- SSRS
- SAP Analytics Cloud
- Data Quality Frameworks
- Validation Rules
- Documentation
- Agile
- Jira
- CI/CD
- Git
- Azure DevOps
Accomplishments
- Improved query response times by 40% through optimized Snowflake modeling.
- Reduced compute and storage costs by 30% via efficient ELT and cloud architecture.
- Established enterprise data quality and governance frameworks supporting regulatory compliance.
- Delivered BI-ready datasets enabling faster, more reliable decision-making across teams.
Certification
- Snowflake Snowpro core
- IBM Data Science Certification
- Google Analytics Certification
- Foundations of Project Management
- SAS – University of Louisville Joint Certificate in Data Analytics
Core Skills
ELT/ETL Pipelines, Incremental Loads, CDC, SCD Type 2, Star Schema, Snowflake Schema, Medallion Architecture, Snowflake, dbt, Azure (Data Factory, Synapse Analytics, Databricks, Data Lake, DevOps), SQL, Python, Power BI, Streamlit, Tableau, SSRS, SAP Analytics Cloud, Data Quality Frameworks, Validation Rules, Documentation, Agile / Jira, CI/CD (Git, Azure DevOps)
Timeline
Data Engineer
Bank OZK
04.2025 - Current
Analytics Engineer
Allegion
03.2024 - 12.2024
Data Engineer
Avantor
08.2023 - 01.2024
BI Developer / Data Engineer
V-Soft Consulting (Samsung)
08.2022 - 02.2023
Data Warehouse Developer
Churchill Downs Inc.
04.2022 - 06.2022
Data Engineer / Business Analyst / SAP Consultant
Gaman Software Solutions Pvt. Ltd.
09.2015 - 12.2021
Master’s - Business Analytics
University of Louisville
Master’s - Biotechnology (Honors)
Deakin University
Master’s - Technology Management
Lindsey Wilson College