Alekhya Reddy Email & Phone Number

United States

Irving, Texas, United States

-Created and maintained Azure Data Factory pipelines to ingest and transform data from on-prem SQL Servers, APIs, and flat files into Azure storage, integrating with Snowflake for data warehousing.-Implemented end-to-end data pipelines using Azure Databricks, PySpark, and Spark SQL, facilitating efficient ETL/ELT processes that load data into Snowflake from diverse sources.-Engineered robust data architecture solutions on Azure, including data models and schemas optimized for Snowflake, ensuring high-performance data processing and query execution.-Utilized Snowflake’s features like Change Data Capture (CDC), Snowpark, and data sharing capabilities to construct advanced data processing and analytics solutions, improving operational efficiency.-Established data archival strategies and applied Snowflake's Pause and Resume features, significantly reducing data storage costs and enhancing system performance.-Partnered closely with business stakeholders to gather requirements, translating them into technical specifications, and delivering data solutions that drive informed decision-making.

United States

I designed and developed scalable data pipelines using Azure Data Factory and Databricks, optimized data workflows with PySpark, and integrated various Azure services to enable seamless data orchestration. I also implemented real-time data processing using Azure Event Hub and leveraged Synapse Analytics and Databricks for complex data transformations, supporting efficient decision-making.Achievement: Reduced data processing time by 30% using optimized Spark configurations and advanced partitioning in Azure Databricks.

United States

- Built ETL/ELT pipelines with Python and Snowflake, leveraging data sharing.- Developed Azure Data Factory pipelines for diverse data sources.- Successfully Implemented Kafka for real-time data streaming.- Oncall production support 24x7- Created Spark applications in Databricks for advanced data transformations.- Optimized Snowflake costs by SCD Types 1 and 2 by leveraging Pause/Resume features.- Performed advanced analytics with Azure Synapse.

Hyderabad, Telangana, India

-Involved in the Database Normalization, Data modeling using ERWIN, Physical and Logical Design of SQL Server Database.-Created Triggers, Indexes, User-defined Functions, Constraints. on various database objects to obtain the required results in Teradata.-Developed Teradata SQL scripts and stored procedures for advanced analytics use cases, enabling actionable insights for stakeholders.-Creation, manipulation and supporting the Teradata Data Warehouse, modeling star schema and snowflake schemas in the data warehouse.-Optimized data warehouse performance by fine-tuning Teradata SQL queries and indexing strategies.-Enhanced data quality and integrity by ingesting and transforming data from diverse sources like Teradata, and developed ETL processes using SSIS and SSRS packages to facilitate data-driven decision-making.-Developed and tested Windows command files and SQL and PL/SQL queries for Production database monitoring.

Hyderabad, Telangana, India

As an ETL Developer in the CyGen, My role focuses on transforming healthcare data into actionable insights to improve patient outcomes and operational efficiency. I design and develop reliable ETL pipelines, ensuring seamless data integration and accuracy. I had to work with diverse data sources, implement data quality checks, and maintain compliance with healthcare standards.

Bachelor Of Engineering - Be, Computer Science, 7 Cgpa

Master'S Degree, Computer Science, 3.7 / 4Gpa