shiva Sai Ram Mogulla

shiva Sai Ram Mogulla

Software Engineer @ Blue Yonder | Azure Data Engineer | Snowflake Developer | ETL & Data Integration Specialist | Microsoft Fabric DP-700 Certified


About

As a Data Engineer with 4+ years of experience, I specialize in building scalable data platforms, modernizing ETL processes, and delivering cloud-based analytics solutions that drive business decisions. My professional journey spans enterprise data integration, cloud data engineering, and supply chain technology, with hands-on expertise across Azure, Snowflake, Informatica, Oracle, Python, and PL/SQL. Currently, I work as a Software Engineer at Blue Yonder, where I develop and optimize large-scale data pipelines and cloud-native solutions using Azure Fabric and Snowflake. I focus on designing efficient data architectures, implementing complex business logic, improving data quality, and supporting mission-critical supply chain operations. My work includes ETL/ELT development, data modeling, orchestration, automation, performance tuning, and reliable data delivery across enterprise systems. Before joining Blue Yonder, I worked with Cognizant, where I designed and maintained enterprise ETL solutions using Informatica, Oracle, and AutoSys. I gained extensive experience in data transformation, batch processing, performance optimization, data lineage, and stakeholder collaboration while working on large-scale data environments.

Skills
PostgreSQL
CI/CD
Google Cloud
Kubernetes
Spark
Snowflake
Databricks
Azure Data Factory
C++
PL/SQL
Shell Scripting
Git
Fabric
Lakehouse
Data Warehousing
Data Integration
Data Modeling
Airflow
IceBerg
SCD
ADLS
Medillion
Medallion
Experience

Data Engineer

Cognizant

May 2022 to Jul 2025
  • Architecting dynamic ETL workflow through Informatica PowerCenter, elegantly weaving in intricate transformations and rigorous data quality validations to uphold evolving business logic and compliance mandates.
  • Curating and sustaining comprehensive Source-to-Target Mapping (STM) blueprints & data lineage artifacts, fortifying audit readiness / regulatory traceability with precision.
  • Engaging in cross-functional synergy with Oracle DBAs and UNIX administrators, troubleshooting performance variances & alleviating infrastructure bottlenecks.
  • Deciphering business narratives and translating them into actionable technical constructs, while collaborating closely with analysts and stakeholders to sculpt performant ETL logic using Informatica and PL/SQL.
  • Navigating through ETL execution setbacks—performing root cause analysis and deploying agile workarounds aligned with data criticality and operational impact.
  • Orchestrated and supervised over 20 automated ETL pipelines via AutoSys, streamlined batch job execution, enhanced alerting mechanisms, & minimized manual oversight.
  • Embedded Slowly Changing Dimensions (SCD) Type 1 & 2 into high-volume datasets (50M+ records), preserved historical accuracy and enabled in-depth trend analytics for business insights

Software Engineer

Blue Yonder

Jul 2025 to Present
  • Pipeline Architecture & Integration: Developing and executing scalable, end-to-end data ingestion and ETL/ELT pipelines in Azure Fabric to simplify global merchandise and portfolio data management.
  • Advanced Logic Development: Developing and refining intricate business logic using Python and PL/SQL code related to automating inventory reconcilement, markdown optimization, and stock-out forecasting models for the Merchandise Operations group.
  • Cloud Data Modeling: Designing highly optimized data models in Snowflake, incorporating cutting-edge functionalities such as SCD Type 2, Time Travel, and Zero Copy Cloning to make the data more durable and amenable to faster development turns.
  • Enterprise Orchestration: Managing the overall orchestration process of critical, high-volume batch processing and streaming of mission-critical business data using Control-M, ensuring a system availability of 99.9% in daily supply chain updates.
  • Stakeholder Technology Strategy: Working effectively with other stakeholders in the Supply Chain team to develop technical solutions for handling complex portfolio management tasks on the Azure platform
Education

BE/B.Tech Mechanical Engineering

SCSVMV University · 9.33

Aug 2018 to Apr 2022
Certifications

SnowPRO Core

Snowflake Inc.

Nov 2025