Rachana Reddy Chandupatla
Houston,US
Summary
Results-driven Software Engineer & Data Engineer with 4+ years of experience in Java (Spring Boot),Python, data engineering, cloud-native development, and analytics. Expertise in building scalable data pipelines, REST APIs, AWS cloud services, Kafka workflows, and trading systems. Proven ability to design and implement high-performance applications for financial markets.
Overview
4
4
years of professional experience
Work History
Software Developer
Macquarie Capital Group
Houston, US
02.2023 - Current
- Led migration of 150 Excel spreadsheets from legacy LIM to Marketplace, ensuring data accuracy for pre-data analytics and decision-making
- Developed backend services using Java and Spring Boot, ensuring efficient data processing and integration
- Designed and built a data analytics pipeline for onboarding time-series and metadata into Quasar, improving data ingestion and transformation
- Developed a web-based analytic studio tool enabling business users to wrangle data from Quasar, Houston Market DB, and YES Energy for modeling and visualization (Spotfire, Excel, REST APIs)
- Migrated settlement price feeds (Day-Ahead, Real-Time) for North American Power Markets, Commodities, and European Power
- Developed an ISO Portal for the U.S
- Power Business, integrating transactions across CAISO, NYISO, MISO, and ERCOT, enhancing virtual, physical, and Financial Transmission Rights (FTR) Market capabilities
- Integrated SOAP services, Kafka workflows, and AWS infrastructure, improving processing speed and reliability
Software Development Engineer
Amazon Web Services
Bellevue, US
04.2022 - 01.2023
- Developed REST APIs for Amazon AppFlow, enabling secure data transfer between SaaS applications and AWS services
- Built an analytics pipeline using AWS Athena, S3, Glue, and DynamoDB, providing real-time data insights
- Worked on Control Plane, Data Plane, and Connector Vending Service (CVS) to enhance data flow and monitoring
- Developed metering services and GDPR systems for tracking data usage and ensuring compliance
- Implemented API performance dashboards for real-time analytics, a major success for AppFlow
- Automated CI/CD pipelines (CRUX/Pipelines), contributing to DevOps and infrastructure automation
- Gained hands-on experience with AWS Step Functions, SQS, ECS, Event Bridge, IAM, and VPC
Data Engineer
Raven Software Solutions
Dallas, US
12.2021 - 04.2022
- Designed and built ETL pipelines for data extraction, transformation, and loading (ETL)
- Developed SQL-based solutions for data transformation, aggregation, and reporting
- Optimized database design and architecture for performance efficiency
- Automated data validation processes to ensure data integrity
Data Engineer Intern
Raven Software Solutions
Dallas, US
08.2021 - 12.2021
- Designed and implement data mining algorithms, data cleaning procedures and data analytics, including machine learning and big data applications
- Provide data analytics detailing the quantity, aggregate dollar amount, and frequency of qualified bookings
- Worked on Validation, Completeness Testing of Accounting Data and Journal Entry Data Analytics
- Worked with other interns as a team on two separate data analytics projects
Education
Master’s - Data Science
University of North Texas
Texas, US12.2021
Skills
- Java (Spring Boot)
- Python
- Angular
- React
- ETL
- Data Pipelines
- SQL
- PostgreSQL
- AWS Glue
- Athena
- DynamoDB
- AWS (Lambda, S3, DynamoDB, ECS, CloudFormation, Step Functions, EventBridge, IAM, VPC)
- Kafka
- Kubernetes
- REST APIs
- SOAP
- Microservices
- Pipelines
- AWS Step Functions
- Monitoring (CloudWatch, Spotfire)
- Spotfire
- Power BI
- Tableau
Timeline
Software Developer
Macquarie Capital Group
02.2023 - Current
Software Development Engineer
Amazon Web Services
04.2022 - 01.2023
Data Engineer
Raven Software Solutions
12.2021 - 04.2022
Data Engineer Intern
Raven Software Solutions
08.2021 - 12.2021
Master’s - Data Science
University of North Texas