Summary
Overview
Work History
Education
Skills
Timeline
Generic
Rajini Rayapati

Rajini Rayapati

Dallas,TX

Summary

2+ years of experience in data engineering, specializing in ETL/ELT pipeline development, real-time data streaming, and cloud-based data solutions using AWS, Azure, and Snowflake. Skilled in SQL optimization, data modeling, and delivering actionable insights with Power BI and Tableau.

Positive, analytical problem-solver with strong foundation in data systems and processes. Possesses solid understanding of data modeling and database design, coupled with skills in SQL and Python. Capable of driving data-driven decision-making and improving data infrastructure.

Overview

3
3
years of professional experience

Work History

Data Engineer

American Express (Amex)
06.2024 - Current
  • Designed and optimized ELT pipelines in Snowflake using Streams, Tasks, and Snowpipe for real-time data ingestion from multiple sources.
  • Built Kafka-based streaming pipelines and AWS Glue workflows to process high-volume financial transactions, reducing processing time by 30%.
  • Developed data models and Power BI dashboards, improving executive reporting efficiency by 40%.
  • Partnered with stakeholders to deliver analytics dashboards that provided insights into fraud detection, transaction trends, and revenue forecasting.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.

Data Engineer

State Farm
09.2022 - 06.2023
  • Built ETL pipelines in Azure Data Factory and Databricks to integrate claims and policy data into an Azure-based warehouse, improving report availability.
  • Implemented real-time streaming with Kafka for fraud detection and claims analytics, reducing fraud detection time by 20%.
  • Designed Snowflake dimensional models to support Power BI analytics for claims operations.
  • Collaborated with teams to migrate on-prem systems to Azure, enhancing scalability and performance.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.

Education

Master of Science - Computer and Information Sciences

Southern Arkansas University
Magnolia, AR
12-2024

Skills

  • Big Data: Apache Spark, Apache Kafka
  • Orchestration: Apache Airflow, Azure Data Factory
  • Cloud Platforms: AWS (Redshift, S3, Glue), Azure (Data Lake, Synapse)
  • Data Warehousing: Snowflake, AWS Redshift
  • Databases: SQL Server, PostgreSQL
  • Visualization: Power BI, Tableau
  • Automation & CI/CD: Python, Jenkins, GitLab CI/CD
  • ETL development
  • Data warehousing
  • Data modeling
  • Data pipeline design
  • SQL expertise
  • Machine learning
  • Data analysis

Timeline

Data Engineer

American Express (Amex)
06.2024 - Current

Data Engineer

State Farm
09.2022 - 06.2023

Master of Science - Computer and Information Sciences

Southern Arkansas University