Aashish Rogannagari

Aashish Rogannagari

Profile

  • AWS Certified Data Engineer with 4 years of experience in cloud computing, data engineering, and scalable data pipelines. With expertise in AWS-native services, I specialize in building and optimizing high-performance cloud architectures that support large-scale analytics, business intelligence, and AI-driven solutions.

  • I have hands-on experience in SQL and Python for data transformation, querying, and optimization, as well as ETL workflows using AWS Glue and Step Functions for automated batch and real-time data processing. My expertise in AWS Redshift and Snowflake enables efficient data warehousing and analytics, while Git and streamline deployment and infrastructure automation.

    • Experience

    Data Engineer

    HELIX - HYDERABAD

    Sep 2020 - Jun 2023

    • Automated data pipelines, reducing data processing time by 40% and ensuring consistency across systems.
    • Designed and implemented cloud infrastructure using AWS services such as EC2, Lambda, and RDS.
    • Built an event-driven architecture with AWS Lambda & Step Functions, enabling real-time processing of thousands of daily events.

    Data Engineer Associate

    HELIX - HYDERABAD

    Sep 2019 - Aug 2020

    • Developed & Automated ETL pipelines in AWS Glue, integrating 10+ data sources, reducing manual processing..
    • Optimized SQL queries using indexing, materialized views, and partitioning, significantly improving execution speed by 2-3x.
    • Collaborated in Redshift query tuning, reducing report generation time for BI dashboards by 60%.

    Projects

    Sheet Buddy – Open-Source Python Library

    Creator

    July 2024 - Present

    • Developing and scaling Sheet Buddy, Automating EDA, data transformation, and Excel reporting.
    • Serving Loading... users, streamlining workflows and reducing analysis time by 50%.
    • Enhancing automation with dynamic styling, interactive heatmaps, statistical insights, and high-performance Excel exports.
    Total PyPI Downloads Latest Version
    GitHub Stars GitHub Issues Supported Python Versions
    Colab Jupyter

    Education

    Master's in Data Analytics & Visualization

    Yeshiva University, New York City, NY

    Sep 2023 - Present

      Skills

      Cloud Platforms

      • AWS

      Data Engineering & ETL

      • AWS Glue, Apache Airflow, ETL/ELT, Batch & Real-time Processing, Star Schema, Snowflake Schema, Slowly Changing Dimensions, AWS Redshift, Snowflake, AWS S3, Parquet, ORC
      • SQL
      • ETL Pipelines
      • Data Warehousing , Data Modeling

      Data & Analytics

      • Data Warehousing, Data Streaming, Workflow Orchestration, Tableau, Power BI

      Contact Me

      aashish.roganagari5@gmail.com

      +1 347-389-4273

      linkedin.com/in/aashishrogannagari